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 anada 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. |