Product Sheets
Postal Database
1. Product Introduction
Product Name: Postal Database
Version: 2025.07
Coverage: 240+ countries & territories (full global coverage)
Update Frequency: Continuous synchronization (avg. 3 updates/week)
Description: Comprehensive global postal dataset containing postal codes, localities, administrative divisions (up to 4 levels), and geographic coordinates.
The dataset is standardized across all countries and georeferenced in WGS84, enabling seamless integration into logistics systems, ERP platforms, validation engines, GIS tools, and analytics pipelines.
The database also includes business/administrative postal codes, ISO/FIPS/NUTS/HASC codes, time zones, and multilingual place names.
2. Data Delivery
File Formats: CSV (UTF-8, semicolon-delimited), ASC (ASCII), DAT (UTF-16), GML, GeoJSON, KML, Shapefile
Encoding: UTF-8 (CSV default)
Delimiter: Semicolon (;)
Header Row: Yes
Access Methods
- Snowflake Data Share*
3. Data Model (Postal Database)
Denormalized Tables
The dataset is delivered in a denormalized structure with the following main tables:
-
Places - postal codes and localities (core table)
-
Regions – administrative hierarchy (levels 0–4)
-
Business – business reserved and non-geographic postal codes (Not POI)
Model Characteristics
-
Hierarchical structure:
- Administrative Levels 0–4 (Region1–Region4)- Locality
- Postcodes (in all countries with an active ZIP/postcode system)
- Suburbs (if applicable) -
CRS: WGS84 (EPSG:4326)
-
Geocoordinates: Center points
-
Standardization:
ISO 3166-1 (countries)ISO 3166-2 (subdivisions)
IANA Timezone alignment - Stable IDs for tracking changes across updates
- Available in:
Denormalized format
Normalized relational model