Places Table
Denormalized Model
The following table defines the columns, explanations, and data types for the Places table within the Postal Database denormalized data schema.
|
Column Name |
Description |
Example |
Data Type |
|
ISO |
ISO 3166-1 alpha-2 country code |
DE |
CHAR(2) |
|
Country |
Country name |
Germany |
VARCHAR(50) |
|
Language |
Language version code |
DE |
CHAR(2) |
|
ID |
Stable identifier unique across all dimensions, except for languages |
1063036838 |
INTEGER |
|
Region 1 |
Administrative level 1 |
Baden-Württemberg |
VARCHAR(80) |
|
Region 2 |
Administrative level 2 |
Freiburg |
VARCHAR(80) |
|
Region 3 |
Administrative level 3 |
Breisgau-Hochschwarzwald |
VARCHAR(80) |
|
Region 4 |
Administrative level 4 |
Bad Krozingen |
VARCHAR(80) |
|
Locality |
City / town / village name |
Bad Krozingen |
VARCHAR(80) |
|
Suburb |
Locality subdivision (if applicable) |
Bad Krozingen |
VARCHAR(80) |
|
Postcode |
Postal code (string, alphanumeric supported) |
79189 |
VARCHAR(15) |
|
Latitude |
Decimal degrees (WGS84) |
47.916695 |
DOUBLE |
|
Longitude |
Decimal degrees (WGS84) |
7.699775 |
DOUBLE |
|
Elevation |
Elevation in meters |
232 |
INTEGER |
|
ISO2 |
ISO 3166-2 subdivision code |
DE-BW |
VARCHAR(10) |
|
FIPS |
NGA geopolitical code |
GM01 |
VARCHAR(10) |
|
NUTS |
EU statistical code |
DE132 |
VARCHAR(12) |
|
HASC |
Hierarchical admin subdivision code |
DE.BW.FR |
VARCHAR(12) |
|
STAT |
National statistical code |
083155001006 |
VARCHAR(20) |
|
Timezone |
IANA timezone name |
Europe/Berlin |
VARCHAR(30) |
|
UTC |
UTC offset |
+01:00 |
VARCHAR(10) |
|
DST |
Daylight saving offset |
+02:00 |
VARCHAR(10) |
|
locality_type |
Town: residential areas OR, |
town |
VARCHAR(20) |
|
is_postal |
1 if regular delivery |
1 |
INTEGER |
|
is_business |
1 if business code |
0 |
INTEGER |
|
is_po_box |
1 if PO Box code |
0 |
INTEGER |
|
post_town |
Official postal town (where applicable) |
VARCHAR(80) |