Zip Code Database List
1-800-425-1169
Zip-Codes.com
Account Login

Canadian Postal CodeOM Database Technical Specifications

Postal Code List



Actual Customer Emails
I appreciate your great customer service and your fine product.
Best,
Alan Maitland
Online Yellow Pages
Canadian Postal Code Database Versions

Database Technical Specifications


Downloads


Show:

  • All Fields
  • Standard Database Fields Only
  • Deluxe Database Fields Only
  • Business Database Fields Only
Field Name Data Type Description
PostalCode Char(7) The Postal CodeOM of the record in ANA NAN format.
City VarChar(45) The name of the city, town or village of the Postal CodeOM.
Province Char(2) The two-letter abbreviation for the province to that Postal CodeOM.
ProvinceName VarChar(45) The name of the province to that Postal CodeOM.
AreaCode VarChar(3) The telephone area code for this Postal CodeOM.
CityFlag Char(1) Yes/No flag indicating if the Postal Code is marked as a general delivery address.
TimeZone Integer The time Zone Number for which this Postal CodeOM belongs to.
DST Char(1) Indicates whether they observe Day Light Savings Time.
Latitude Decimal(12, 8) Geographic coordinate measured in degrees north or south of the equater.
Longitude Decimal(12, 8) Geographic coordinate measured in degrees east or wets of the Greenwich Meridian.
Elevation Integer Average elevation of the Postal CodeOM in meters.
Population Integer The population count for the Forward Sortation Area by Canadian Census 2016.
Dwellings Integer The total number of private dwellings count for the Forward Sortation Area by Canadian Census 2016.
AreaName VarChar(45) Major community name or greater municipality grouping that contains the street address or its delivery installation as recognized by the Canada Post.
StreetName VarChar(45) The official civic name of a roadway or artery as recognized by Canada Post.
StreetTypeCode Char(6) Official description used to identify the type of road or artery.
StreetDirCode Char(2) The street direction component of an official street name.
CityMixedCase VarChar(45) The name of the city, town or village of the Postal Code in Mixed Case format.
AreaNameMixedCase VarChar(45) Major community name or greater municipality grouping that contains the street address or its delivery installation as recognized by the Canada Post in Mixed Case format.
MunicipalityName VarChar(45) The name of the Municipality.
CensusMetropolitanAreaUID VarChar(3) Uniquely identifies a census metropolitan area.
CensusMetropolitanAreaName VarChar(100) Census metropolitan area name.
CensusDivisionUID VarChar(45) Uniquely identifies a census division.
CensusDivisionName VarChar(100) Census division name.
CensusSubDivisionUID VarChar(7) Uniquely identifies a census subdivision.
CensusSubDivisionName VarChar(100) Census subdivision name.

Portions of data provided by and © Canada Post 2021. Zip-Codes.com is a non-exclusive licensee of Canada Post.