Data specifications and definitions

Number of records:28,103
Last updated:
Update frequency:Quarterly (January, April, July and October)
Geographic coverage:Full coverage of all thirteen provinces and territories in Canada
Data formats:CSV, SQL, XLS
Language and Encoding:en-CA, UTF-8
Supply:Direct online download (3.0MB zipped file)

Field formats

FieldExampleTypeDescription
ID99INTEGERA unique numeric identifier for the populated place.
NameBanffTEXT(46)The official name of the populated place. Please see the naming conventions for more information.
ProvinceAlbertaTEXT(25)The full-length name of the province or territory which the populated place falls in.
Province codeABTEXT(2)The 2 letter abbreviation for the province or territory as defined in ISO 3166-2.
Postcode areaT1LTEXT(3)The postcode forward sortation area (FSA) which the center point of the place falls in.
TypeTownTEXT(19)The type of populated place (as defined by the Geographical Names Board of Canada). The possible types are: City, Town, Village, Hamlet, Municipality and Unincorporated area.
Map reference082O04TEXT(6)The National Topographic System 1:50,000 scale map sheet which the center point of the place falls in.
Latitude51.17778NUMERIC(8,5)The WGS83 latitude coordinate for the center point of the populated place.
Longitude-115.57361NUMERIC(8,5)The WGS83 longitude coordinate for the center point of the populated place.
Census divisionDivision No. 15TEXT(36)The full-length name of the 2011 census division (as defined by Statistics Canada) which the center point of the place falls in.
Area code587TEXT(3)The telephone area code which the center point of the place falls in.
Time zoneAmerica/EdmontonTEXT(21)The IANA timezone which the center point of the place falls in.

Naming conventions

All place names in the data follow a consistent naming convention. Specifically: