Canadian Postal Codes
Premium EditionThe Premium Edition contains a complete listing of all Canadian Postal Codes, associated geographic coordinates, time zone with daylight savings time indicator, and primary area code.
The geographic latitude and longitude coordinates are to the center of the postal code FSA. This product does not provide LDU or street level coordinate granularity.
| Field | Data Type | Field Description |
|---|---|---|
| POSTALCODE | CHAR(7) | The six character Postal Code. |
| CITY | VARCHAR(128) | The preferred name for the city, town, or unique organization. |
| ABBREVIATION | VARCHAR(13) | Standard Canada Post 13 character city name abbreviation. |
| PROVINCE | CHAR(2) | Two character abbreviation of the province or territory. |
| NPA1 | CHAR(3) | Primary telephone area code associated with the postal code area. |
| NPA2 | CHAR(3) | Additional telephone area code associated with the postal code area. Generally specifies an area code overlay found in larger metropolitan areas only. |
| GMT | CHAR(2) | Time zone the postal code is located in. Determined using Coordinated Universal Time (UTC) offset also referred to as hours relative to GMT.
|
| DST | CHAR(1) | Daylight savings time recognized, (Y)es or (N)o. |
| CODETYPE | CHAR(1) | Specifies the basic category of the Postal Code (R)ural or (U)rban |
| NAMETYPE | CHAR(1) | Specifies whether the city name field specifies the preferred or an alternate name for the Postal Code. |
| LATITUDE | DOUBLE | Latitude in decimal degrees to the center of the postal code FSA. |
| LONGITUDE | DOUBLE | Longitude in decimal degrees to the center of the postal code FSA. |
