Combined United States and Canada Postal Codes Database

What's in the Standard Edition?

The Standard Edition contains a complete listing of all Canadian Postal Codes and United States 5-digit ZIP codes, their associated city names and geographic coordinates. For Canadian postal codes the geographic latitude and longitude coordinates are to the center of the postal code FSA. This product does not provide Canadian LDU or street level coordinate granularity.

This is a basic Canadian Postal Code/United States ZIP Code data set suitable for applications that require data to perform simple postal code lookups, calculate basic distances between postal codes or similiar type operations.

Combined Postal Codes Database Fields 

Postal Codes master file		Combined Postal Codes data samples
Field Name	Data Type	Description
POSTCODE	VARCHAR (7)	The five or six character post code.
CITY	VARCHAR (28)	Name of city.
REGION	VARCHAR (28)	Full name of the state or province.
REGIONCODE	CHAR (2)	Official abbreviation of the state or province.
COUNTRY	CHAR (2)	ISO 3166 two character country code.
CITYTYPE	CHAR (1)	Postal Service recognition of the CITY field name
LATITUDE	DOUBLE	Latitude in decimal degrees of the geographic centroid of the ZIP code or Postal Code FSA
LONGITUDE	DOUBLE	Longitude in decimal degrees of the geographic centroid of the ZIP code or Postal Code FSA