Canada Postal Code on Snowflake Marketplace

Published on January 25, 2022
Updated on August 14, 2024

Overview

Canada’s postal codes are alphanumeric, like Dutch, Irish, and British postcodes. Canadian postal codes are in the format A1A 1A1, where A is a letter and 1 is a digit, with a space separating the third and fourth characters. Although postal codes are usually assigned to geographical areas, special codes are sometimes assigned to individual addresses or to institutions that receive large volumes of mail, such as government agencies and large commercial companies.

Canadian Postal Codes typically represent a limited number of delivery points (a few houses, or several roads in more rural areas). Canadian Postal Codes provides the post codes of any location within the Canadian postal region. As areas grow or shrink in population and mail delivery, Canada Post will adjust the Postal Codes and which delivery points they service. It is quite common for several Postal Codes to either change or be retired each month.

This data is now available on the Snowflake Data Marketplace. You can request the data by logging into your Snowflake account

Data dictionary: List of tables and columns

Following are the list of datasets belonging to Canada postal code.

POSTCODE_CAN

This dataset contains the postal code of the area along with its coordinate (a coordinate is a global address given as two numbers. The two numbers are a location’s latitude number and its longitude number [“Lat/Long”]).

Colum NameData TypeDescription
POSTCODETEXTA Canadian postal code is a six-character Text that forms part of a postal address in Canada
LATITUDENUMBERlatitude of the internal point
LONGITUDENUMBERlongitude of the internal point
CITYTEXTThis is the city field in Canada
PROVINCETEXTThis is the Province field in Canada and a text field
CITYALTTEXTEqual name as of city or alternate name
NEIGHBORHOODTEXTA district or community within a town or city
TIME_ZONETEXTIs an area that observes a uniform standard time for legal, commercial and social purposes.
NAMETEXTName of the area
AREA_CODETEXTCode of the area name

Usage

Lookup city, province and related neighborhood for a postcode (e.g. city Cape Broyle )

POSTCODE_CAN_ADDRESS

The POSTCODE_CAN_ADDRESS dataset provides the postcode of an address. It also provides the GEONUMBER for a particular area (e.g. a house number). Nearby locations have similar geonumbers. Canadian geonumbers range from 2472540428642 to 1265540868972. You may use Geonumbers instead of latitude,longitude on 3geonames.org. The CanData dataset has the direction and confidence, which is the geocoding confidence score. It has also a address type: residential or non-residential as “RES” or “NON-RES”

Colum NameData TypeDescription
POSTCODETEXTA Canadian postal code is a six-character Text that forms part of a postal address in Canada
NUMBERSNUMBERNumber in the address field
STREETTEXTstree a paved urban thoroughfare
CITYTEXTName of the city
PROVINCETEXTa region identifiable by a group of similar physiographic features whose characteristics are markedly in contrast with surrounding areas
LATITUDENUMBERlatitude of the internal point
LONGITUDENUMBERlongitude of the internal point
STREET_NAMETEXTName of the street
TYPETEXTResidency type (RES or NON-RES)
DIRECTIONTEXTDirection of the postal code location
CONFIDENCETEXTConfidence is the geocoding confidence score. A score of “1” means “rooftop” geocoding result, everything else is interpolated.
ATYPETEXTis the address type. It takes one of two values: “Res” -> Residential Address, or “NonRes” -> Non Residential.
UNITTEXT“Unit” is the unit/apartment/suite/etc number (if applicable.)
COUNTSNUMBER“Count” is the number of units/apartments/suites/etc in the address.
GEONUMBERNUMBERIt is a unique location identifier based on the Hilbert curve. Nearby locations have similar geonumbers. Canadian geonumbers range from 2472540428642 to 1265540868972. You may use Geonumbers instead of latitude,longitude on 3geonames.org

Usage

Example 1

Get address details for a particular post code e.g. ‘P6C6H5’

Example 2

Get POSTCODE, NUMBERS, STREET, CITY AND PROVINCE IN ORDER OF RESIDENCE TYPE of all CANADA REGIONS

POSTCODE_CAN_POLYGON

This dataset contains the post code and its geographic shape. It shows the polygon and multipolygon along with the number of vertices. The geography contains the geographic coordinates such as latitude and longitude and builds a shape out of it.

Colum NameData TypeDescription
ZIPTEXTA Canadian postal code is a six-character Text that forms part of a postal address in Canada
VERTICESNUMBERNumber of vertices the polygon contains
GEOMETRYGEOGRAPHYGeographical Boundaries

Usage

Example 1

Get the details(LATITUDE, LONGITUDE,GEOMETRY and its VERTICES) of the post code L2E1P2

Example 2

Get the details(GEOMETRY and its VERTICES) of the city Niagara Falls

POSTCODE_CAN_CENSUS

The POSTCODE_CAN_CENSUS dataset holds the postcode of the smaller area units such as census subdivisions, aggregate dissemination, consolidated census subdivisions, dissemination block which uniquely identifies a census subdivision (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code and the 3-digit census subdivision code). The purpose of the dataset is to get the details of the Canadian census information. It is demonstrated in the example1 given below. It also has federal election areas in English version and French version.

Column NameData TypeDescription
POSTCODETEXTA Canadian postal code is a six-character Text that forms part of a postal address in Canada
LATITUDENUMBERlatitude of the internal point
LONGITUDENUMBERlongitude of the internal point
CITYTEXTThis is the city field in Canada
PROVINCETEXTa region identifiable by a group of similar physiographic features whose characteristics are markedly in contrast with surrounding areas
CITYALTTEXTEqual name as of city or alternate name
NEIGHBORHOODTEXTA district or community within a town or city
TIME_ZONETEXTIs an area that observes a uniform standard time for legal, commercial and social purposes.
NAMETEXTName of the area
AREA_CODETEXTArea code
CENSUS_SUBDIVISION_CMAUIDTEXTCensus Metropolitan area unique identification for census subdivision
CENSUS_SUBDIVISION_PRUIDTEXTUniquely identifies a province or territory
CENSUS_SUBDIVISION_ERNAMETEXTEconomic region name.
CENSUS_SUBDIVISION_CSDTYPETEXTCensus subdivisions are classified according to designations adopted by provincial/territorial or federal authorities.
CENSUS_SUBDIVISION_CMATYPETEXTA one-character field identifying whether the unit is a census metropolitan area, a tracted census agglomeration or a non-tracted census agglomeration.
CENSUS_SUBDIVISION_CDNAMETEXTCensus division name
CENSUS_SUBDIVISION_CSDUIDTEXTUniquely identifies a census subdivision (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code and the 3-digit census subdivision code)
CENSUS_SUBDIVISION_CDTYPETEXTCensus division type
CENSUS_SUBDIVISION_SACTYPETEXTThe Statistical Area Classification groups census subdivisions according to whether they are a component of a census metropolitan area, a census agglomeration, a census metropolitan influenced zone or the territories.
CENSUS_SUBDIVISION_SACCODETEXTThe 3-digit Statistical Area Classification code.
CENSUS_SUBDIVISION_PRNAMETEXTProvince or territory name
CENSUS_SUBDIVISION_CMAPUIDCharacter (5)Uniquely identifies the provincial/territorial part of a census metropolitan area/census agglomeration (composed of the 2-digit province/territory unique identifier followed by the 3-digit census metropolitan area/census agglomeration unique identifier).
CENSUS_SUBDIVISION_CSDNAMETEXTCensus subdivision name.
CENSUS_SUBDIVISION_CDUIDTEXTUniquely identifies a census division (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code).
CENSUS_SUBDIVISION_CCSNAMETEXTCensus consolidated subdivision name.
CENSUS_SUBDIVISION_ERUIDTEXTUniquely identifies an economic region (composed of the 2-digit province/territory unique identifier followed by the 2-digit economic region code).
CENSUS_SUBDIVISION_CCSUIDTEXTUniquely identifies a census consolidated subdivision (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code and the 3-digit census consolidated subdivision code).
CENSUS_SUBDIVISION_CMANAMETEXTCensus metropolitan area or census agglomeration name
AGGREGATE_DISSEMINATION_PRUIDTEXTUniquely identifies a province or territory
AGGREGATE_DISSEMINATION_CDNAMETEXTCensus division name
AGGREGATE_DISSEMINATION_CDTYPETEXTCensus division type
AGGREGATE_DISSEMINATION_CDUIDTEXTUniquely identifies a census division (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code).
AGGREGATE_DISSEMINATION_ADAUIDTEXTAggregate dissemination area unique identification. Aggregate dissemination areas (ADA) “cover the entire country and, where possible, have a population between 5,000 and 15,000 based on the previous census population counts
AGGREGATE_DISSEMINATION_PRNAMETEXTProvince or territory name
POPULATION_ECUMENE_ECUMENETEXTfile type
POPULATION_ECUMENE_ECUIDTEXTfile type id
CENSUS_CONSOLIDATED_SUBDIVISION_PRUIDTEXTUniquely identifies a province or territory
CENSUS_CONSOLIDATED_SUBDIVISION_CDNAMETEXTCensus division name
CENSUS_CONSOLIDATED_SUBDIVISION_CDTYPETEXTCensus division type
CENSUS_CONSOLIDATED_SUBDIVISION_CCSNAMETEXTCensus consolidated subdivision name.
CENSUS_CONSOLIDATED_SUBDIVISION_CDUIDTEXTUniquely identifies a census division (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code).
CENSUS_CONSOLIDATED_SUBDIVISION_CCSUIDTEXTUniquely identifies a census consolidated subdivision (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code and the 3-digit census consolidated subdivision code).
CENSUS_CONSOLIDATED_SUBDIVISION_PRNAMETEXTProvince or territory name
DISSEMINATION_BLOCK_CMAUIDTEXTCensus Metropolitan area unique identification for census subdivision
DISSEMINATION_BLOCK_PRUIDTEXTUniquely identifies a province or territory
DISSEMINATION_BLOCK_CTUIDTEXTcensus tract unique id
DISSEMINATION_BLOCK_ERNAMETEXTEconomic region name.
DISSEMINATION_BLOCK_CSDTYPETEXTCensus subdivisions are classified according to designations adopted by provincial/territorial or federal authorities.
DISSEMINATION_BLOCK_CTNAMETEXTcensus tract name
DISSEMINATION_BLOCK_CMATYPETEXTA one-character field identifying whether the unit is a census metropolitan area, a tracted census agglomeration or a non-tracted census agglomeration.
DISSEMINATION_BLOCK_CSDUIDTEXTUniquely identifies a census subdivision (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code and the 3-digit census subdivision code)
DISSEMINATION_BLOCK_CDNAMETEXTCensus division name
DISSEMINATION_BLOCK_DBUIDTEXTDissemination block unique id
DISSEMINATION_BLOCK_CDTYPETEXTCensus division type
DISSEMINATION_BLOCK_SACTYPETEXTThe Statistical Area Classification groups census subdivisions according to whether they are a component of a census metropolitan area, a census agglomeration, a census metropolitan influenced zone or the territories.
DISSEMINATION_BLOCK_ADAUIDTEXTStatistics Canada has created a new sub-provincial census dissemination geography called ‘aggregate dissemination area’ (ADA). The intent of the ADA geography is to ensure the availability of census data, where possible, across all regions of Canada.
DISSEMINATION_BLOCK_SACCODETEXTThe 3-digit Statistical Area Classification code.
DISSEMINATION_BLOCK_DAUIDTEXTUniquely identifies a dissemination area (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code and the 4-digit dissemination area code).
DISSEMINATION_BLOCK_PRNAMETEXTProvince or territory name
DISSEMINATION_BLOCK_CMAPUIDTEXTUniquely identifies the provincial/territorial part of a census metropolitan area/census agglomeration (composed of the 2-digit province/territory unique identifier followed by the 3-digit census metropolitan area/census agglomeration unique identifier).
DISSEMINATION_BLOCK_DBRPLAMXTEXT 
DISSEMINATION_BLOCK_FEDUIDTEXTUniquely identifies a federal electoral district (composed of the 2-digit province/territory unique identifier followed by the 3-digit federal electoral district code).
DISSEMINATION_BLOCK_DBRPLAMYTEXT 
DISSEMINATION_BLOCK_CSDNAMETEXTCensus subdivision name.
DISSEMINATION_BLOCK_FEDNAMETEXTFederal electoral district name
DISSEMINATION_BLOCK_CDUIDTEXTUniquely identifies a census division (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code).
DISSEMINATION_BLOCK_CCSNAMETEXTCensus consolidated subdivision name.
DISSEMINATION_BLOCK_ERUIDTEXTUniquely identifies an economic region (composed of the 2-digit province/territory unique identifier followed by the 2-digit economic region code).
DISSEMINATION_BLOCK_CCSUIDTEXTUniquely identifies a census consolidated subdivision (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code and the 3-digit census consolidated subdivision code).
DISSEMINATION_BLOCK_CMANAMETEXTCensus metropolitan area or census agglomeration name
CENSUS_METROPOLITAN_AREAS_AND_CENSUS_AGGLOMERATION_PRUIDTEXTUniquely identifies a province or territory
CENSUS_METROPOLITAN_AREAS_AND_CENSUS_AGGLOMERATION_CMAUIDTEXTCensus Metropolitan area unique identification for census subdivision
CENSUS_METROPOLITAN_AREAS_AND_CENSUS_AGGLOMERATION_CMATYPETEXTA one-character field identifying whether the unit is a census metropolitan area, a tracted census agglomeration or a non-tracted census agglomeration.
CENSUS_METROPOLITAN_AREAS_AND_CENSUS_AGGLOMERATION_PRNAMETEXTProvince or territory name
CENSUS_METROPOLITAN_AREAS_AND_CENSUS_AGGLOMERATION_CMANAMETEXTCensus metropolitan area or census agglomeration name
CENSUS_METROPOLITAN_AREAS_AND_CENSUS_AGGLOMERATION_CMAPUIDTEXTUniquely identifies the provincial/territorial part of a census metropolitan area/census agglomeration (composed of the 2-digit province/territory unique identifier followed by the 3-digit census metropolitan area/census agglomeration unique identifier).
DESIGNATED_PLACE_PRUIDTEXTUniquely identifies a province or territory
DESIGNATED_PLACE_DPLUIDTEXTDesignated place unique id
DESIGNATED_PLACE_DPLNAMETEXTDesignated place name
DESIGNATED_PLACE_PRNAMETEXTProvince or territory name
DESIGNATED_PLACE_DPLTYPETEXTDesignated place type
CENSUS_DIVISION_PRUIDTEXTUniquely identifies a province or territory
CENSUS_DIVISION_CDNAMETEXTCensus division name
CENSUS_DIVISION_CDTYPETEXTCensus division type
CENSUS_DIVISION_CDUIDTEXTUniquely identifies a census division (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code).
CENSUS_DIVISION_PRNAMETEXTProvince or territory name
FEDERAL_ELECTION_FRNAMETEXTFederal electoral district name in French.
FEDERAL_ELECTION_REVDTTEXT 
FEDERAL_ELECTION_CREADTTEXT 
FEDERAL_ELECTION_ENNAMETEXTFederal electoral district name in English
FEDERAL_ELECTION_NIDTEXTFederal electoral unique GUID
FEDERAL_ELECTION_PROVCODETEXTFederal electoral province code
FEDERAL_ELECTION_QUIPOPCNTTEXT 
FEDERAL_ELECTION_FEDNUMNUMBER5 digit federal election number
FEDERAL_ELECTION_DECPOPCNTTEXTNumber of federal election count in december
FEDERAL_ELECTION_REPORDERTEXTFederal election report order
CENSUS_TRACT_CMAUIDTEXTCensus Metropolitan area unique identification for census subdivision
CENSUS_TRACT_PRUIDTEXTUniquely identifies a province or territory
CENSUS_TRACT_CTUIDTEXTUniquely identifies a census tract within a census metropolitan area/census agglomeration (composed of the 3-digit census metropolitan area/census agglomeration unique identifier followed by the 7.2-character census tract name)
CENSUS_TRACT_CMATYPETEXTA one-character field identifying whether the unit is a census metropolitan area, a tracted census agglomeration or a non-tracted census agglomeration.
CENSUS_TRACT_CTNAMETEXTcensus tract name
CENSUS_TRACT_PRNAMETEXTProvince or territory name
CENSUS_TRACT_CMANAMETEXTCensus metropolitan area or census agglomeration name
CENSUS_TRACT_CMAPUIDTEXTUniquely identifies the provincial/territorial part of a census metropolitan area/census agglomeration (composed of the 2-digit province/territory unique identifier followed by the 3-digit census metropolitan area/census agglomeration unique identifier).
ECONOMIC_REGION_PRUIDTEXTUniquely identifies a province or territory
ECONOMIC_REGION_ERNAMETEXTeconomic region name
ECONOMIC_REGION_ERUIDTEXTUniquely identifies an economic region (composed of the 2-digit province/territory unique identifier followed by the 2-digit economic region code).
ECONOMIC_REGION_PRNAMETEXTProvince or territory name
DISSEMINATION_AREA_CMAUIDTEXTCensus Metropolitan area unique identification for census subdivision
DISSEMINATION_AREA_PRUIDTEXTUniquely identifies a province or territory
DISSEMINATION_AREA_CTUIDTEXTUniquely identifies a census tract within a census metropolitan area/census agglomeration (composed of the 3-digit census metropolitan area/census agglomeration unique identifier followed by the 7.2-character census tract name)
DISSEMINATION_AREA_ERNAMETEXTeconomic region name
DISSEMINATION_AREA_CSDTYPETEXTCensus subdivisions are classified according to designations adopted by provincial/territorial or federal authorities.
DISSEMINATION_AREA_CTNAMETEXTcensus tract name
DISSEMINATION_AREA_CMATYPETEXTA one-character field identifying whether the unit is a census metropolitan area, a tracted census agglomeration or a non-tracted census agglomeration.
DISSEMINATION_AREA_CSDUIDTEXTUniquely identifies a census subdivision (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code and the 3-digit census subdivision code)
DISSEMINATION_AREA_CDNAMETEXTCensus division name
DISSEMINATION_AREA_CDTYPETEXTCensus division type
DISSEMINATION_AREA_SACTYPETEXTThe Statistical Area Classification groups census subdivisions according to whether they are a component of a census metropolitan area, a census agglomeration, a census metropolitan influenced zone or the territories.
DISSEMINATION_AREA_ADAUIDTEXTStatistics Canada has created a new sub-provincial census dissemination geography called ‘aggregate dissemination area’ (ADA).
DISSEMINATION_AREA_SACCODETEXTThe Statistical Area Classification code is a three-digit code that identifies which census metropolitan area
DISSEMINATION_AREA_DAUIDTEXTDissemination area unique id
DISSEMINATION_AREA_PRNAMETEXTProvince or territory name
DISSEMINATION_AREA_CMAPUIDTEXTUniquely identifies the provincial/territorial part of a census metropolitan area/census agglomeration (composed of the 2-digit province/territory unique identifier followed by the 3-digit census metropolitan area/census agglomeration unique identifier).
DISSEMINATION_AREA_CSDNAMETEXTCensus subdivision name.
DISSEMINATION_AREA_CDUIDTEXTUniquely identifies a census division (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code).
DISSEMINATION_AREA_CCSNAMETEXTCensus consolidated subdivision name.
DISSEMINATION_AREA_ERUIDTEXTUniquely identifies an economic region (composed of the 2-digit province/territory unique identifier followed by the 2-digit economic region code).
DISSEMINATION_AREA_CCSUIDTEXTUniquely identifies a census consolidated subdivision (composed of the 2-digit province/territory unique identifier followed by the 2-digit census division code and the 3-digit census consolidated subdivision code).
DISSEMINATION_AREA_CMANAMETEXTCensus metropolitan area or census agglomeration name
POPULATION_CENTRE_CMAUIDTEXTCensus Metropolitan area unique identification for census subdivision
POPULATION_CENTRE_PRUIDTEXTUniquely identifies a province or territory
POPULATION_CENTRE_PCCLASSTEXTPopulation center class
POPULATION_CENTRE_PCUIDTEXTPopulation center UNIQUE ID
POPULATION_CENTRE_CMATYPETEXTA one-character field identifying whether the unit is a census metropolitan area, a tracted census agglomeration or a non-tracted census agglomeration.
POPULATION_CENTRE_PCNAMETEXTPopulation center name
POPULATION_CENTRE_PCTYPETEXTPopulation cente type
POPULATION_CENTRE_PCPUIDTEXTPopulation cente unique id
POPULATION_CENTRE_PRNAMETEXTProvince or territory name
POPULATION_CENTRE_CMANAMETEXTCensus metropolitan area or census agglomeration name
POPULATION_CENTRE_CMAPUIDTEXTUniquely identifies the provincial/territorial part of a census metropolitan area/census agglomeration (composed of the 2-digit province/territory unique identifier followed by the 3-digit census metropolitan area/census agglomeration unique identifier).
CENSUS_AGRICULTURAL_PRUIDTEXTUniquely identifies a province or territory
CENSUS_AGRICULTURAL_CARUIDTEXTCensus agricultural unique id
CENSUS_AGRICULTURAL_CARENAMETEXTCensus agricultural name in English
CENSUS_AGRICULTURAL_CARFNAMETEXTCensus agricultural name in French
CENSUS_AGRICULTURAL_PRNAMETEXTProvince or territory name
ISEDTEXTInnovation, Science and Economic Development Canada ( ISED ) works with Canadians in all areas of the economy and in all parts of the country to improve conditions for investment, enhance Canada’s innovation performance, increase Canada’s share of global trade and build a fair, efficient and competitive marketplace.
ISEDNAMETEXTInnovation, Science and Economic Development Canada ( ISED ) works with Canadians in all areas of the economy and in all parts of the country to improve conditions for investment, enhance Canada’s innovation performance, increase Canada’s share of global trade and build a fair, efficient and competitive marketplace.
PROVINCIAL_RIDING_OFTEXTCanadian provincial electoral districts have boundaries that are non-coterminous with those of the federal electoral districts, except for districts in the province of Ontario, where districts outside Northern Ontario are coterminous.

Usage

Example 1

Get the details(POSTCODE,CITY, LATITUDE, LONGITUDE, PROVINCE, NEIGHBORHOOD, TIME_ZONE, CENSUS_SUBDIVISION_CDNAME, CENSUS_CONSOLIDATED_SUBDIVISION_CDNAME) for the census tract name Montréal

Example 2

Get the details(POSTCODE,CITY, LATITUDE, LONGITUDE, PROVINCE, NEIGHBORHOOD, TIME_ZONE, CENSUS_SUBDIVISION_CDNAME, CENSUS_CONSOLIDATED_SUBDIVISION_CDNAME) of the city Sainte-Thérèse