The 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.
Produced: on or before 5th calendar day quarterly
Current Release: November 3, 2024
Distribution Frequency: quarterly (issue date: January, April, July, October)
Distribution Format: Postal Code Database Premium Edition Internet download
Postal Code Database Premium Edition Reference Manual
Postal Code Database Premium Edition Sample Data
Postal Code Assignments File
| Field | Data Type | Field Description |
|---|---|---|
| PostalCode | CHAR(7) | The six character Postal Code. |
| City | VARCHAR(64) | The preferred name for the city, town, or unique organization. |
| Abbreviation | VARCHAR(13) | Standard Canada Post 13 character city name abbreviation. |
| ProvinceName | VARCHAR(64) | The full name for the province or territory the postal code is located in |
| Province | CHAR(2) | Two character abbreviation of the province or territory. |
| CityType | CHAR(1) | Specifies whether the city name field specifies the preferred or an alternate name for the Postal Code. |
| PostalCodeType | CHAR(1) | Specifies the basic category of the Postal Code (R)ural or (U)rban |
| AreaCode | CHAR (3) | Predominate 3-digit telephone area code |
| Overlay | VARCHAR (28) | Additional telephone area codes in use when the predominate telephone area code is an overlayed area code. |
| TimeZone | CHAR (2) | Primary time zone the ZIP code is located within |
| DST | CHAR (1) | Single character Y/N value indicating whether daylight saving time is observed at this location. |
| UTC | VARCHAR (28) | The standard time Coordinated Universal Time (UTC) offset at this location. Format is +\-HH:MM. |
| Latitude | DOUBLE | Latitude in decimal degrees of the geographic centroid of the postal code FSA |
| Longitude | DOUBLE | Longitude in decimal degrees of the geographic centroid of the postal code FSA |
SQL Table Definitions
CREATE DATABASE IF NOT EXISTS `postalcodepremium`;
USE `postalcodepremium`;
DROP TABLE IF EXISTS `postalcodes`;
CREATE TABLE `postalcodes` (
`PostalCode` CHAR(7) NOT NULL,
`City` VARCHAR(64) DEFAULT NULL,
`Abbreviation` VARCHAR(13) DEFAULT NULL,
`ProvinceName` VARCHAR(64) DEFAULT NULL,
`Province` CHAR(2) DEFAULT NULL,
`CityType` CHAR(1) DEFAULT NULL,
`PostalCodeType` CHAR(1) DEFAULT NULL,
`AreaCode` CHAR(3) DEFAULT NULL,
`Overlay` VARCHAR(28) DEFAULT NULL,
`TimeZone` CHAR(2) DEFAULT NULL,
`DST` CHAR(1) DEFAULT NULL,
`UTC` VARCHAR(28) DEFAULT NULL,
`Latitude` DOUBLE DEFAULT 0,
`Longitude` DOUBLE DEFAULT 0,
PRIMARY KEY (`PostalCode`));