Canadian Postal Code Databases

What's in the Premium Edition?

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.

Canadian Postal Codes Premium Edition Record Layout

Postal Code master file		Postal Code data samples
Field Name	Data Type	Description
POSTALCODE	CHAR (7)	The six character Postal Code.
CITY	VARCHAR (128)	Name of city or location.
ABBREVIATION	VARCHAR (13)	Standard Canada Post 13 character city name abbreviation.
PROVINCE	CHAR (2)	Official abbreviation of the province or territory.
NPA1	CHAR (3)	Primary telephone area code associated with the postal code.
NPA2	CHAR (3)	Additional telephone area code associated with the postal code.
GMT	CHAR (2)	Time zone the postal code is located in. NT - Newfoundland UTC -3:30 hours AT - Atlantic UTC -4 hours ET - Eastern UTC -5 hours CT - Central UTC -6 hours MT - Mountain UTC -7 hours PT - Pacific UTC -8 hours AK - Alaskan UTC -9 hours HT - Hawaiian-Aleutian UTC -10 hours AS - Samoa UTC -11 (American Samoa) CH - Chamorro UTC +10 (Guam and Northern Mariana Islands)
DST	CHAR (1)	Daylight savings time recognized, (Y)es or (N)o.
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.