Postal Code DatabaseCanadian 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
Database Technical Specifications
Downloads
- Standard Database: [Documentation | Sample Data]
- Deluxe Database: [Documentation | Sample Data]
- Business Database: [Documentation | Sample Data]
Show:
| 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 2021. |
| Dwellings | Integer | The total number of private dwellings count for the Forward Sortation Area by Canadian Census 2021. |
| 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 2024. Zip-Codes.com is a non-exclusive licensee of Canada Post.
