Wednesday, March 22, 2017

A complete list of 5,162 cities, municipalities, districts, towns, townships, villages, hamlets in Canada from Statistics Canada 2017

REVISED from 3,683-cities-municipalities-districts-towns-townships-villages-hamlets-in-Canada-from-CRA-as-of-Jan-18-2016

Spreadsheet below is a complete list of 
5,162 cities, municipalities, districts, towns, townships, villages, hamlets, etc. according to Statistics Canada (Stats Can) 2017, Population and Dwelling Count Highlight Tables - 2016 Census.

Spreadsheet below contains an analysis and all the Census subdivisions (CSD) for Canada, but you can get the source dataset from Statistics Canada directly (download).

But you must understand this does not include all places in Canada, for that we need 2 other datasets to be involved, the designated places and geographic place name datasets.

Firstly, what is a 
Census subdivision (CSD)?

Stats Can defines Census subdivision (CSD) is the general term for municipalities which 
including cities, municipalities, districts, hamlets, cree village etc. There are 54 Census Subdivisions (CSD) types.

all of which are populated and thus does not show up in the Census data collected and therefore not in the spreadsheet/charts below for 2016 Census.

Census Subdivision (CSD) Types Table (link, new tab) 

Interesting CSDs Types are Summer District, Township and royalty, and Island Municipality!

List All Canadian Geographic Dimensions Datasets
from here we focus on the following datasets;

1) Some Interesting Finds in the CSD Names Dataset (download)

There are 5,162 CSDs Names refering to cities, municipalities, districts, towns, townships, villages, hamlets, etc.

Funny City/Town/Township/Hamlet/Village names 

Low, Joly, Mono, Webb, Zorra, Vonda, Zelma, O'Leary, Outlook, Zeballos, Ivujivik, Markinch, Spy Hill, Tehkummah, Quispamsis, Burns Lake, Pohénégamook, Whapmagoostui, Aroostook, Asphodel-Norwood, Hoodoo No. 401, Moosomin No. 121, Happy Valley-Goose Bay, Sainte-Madeleine-de-la-Rivière-Madeleine, Sainte-Thérèse-de-Gaspé, Summer Village of Golden Days, Summer Village of Ghost Lake, Saint-Hubert-de-Rivière-du-Loup, Sainte-Catherine-de-la-Jacques-Cartier and lastly 
Saint-Louis-du-Ha! Ha! 
Find and add your favourite in comment section below. See spreadsheet below.

2) Some Interesting Finds in the Designated Places (DPL) Dataset (download)

Designated Places (DPL) is defined as a small community that does not meet the criteria used to define municipalities (not a CSD in other words).

There are
1,629 unique Designated Places (DPL). The shortest DPL name Oba is 3 characters long.The longest DPL name is  "New Chelsea-New Melbourne-Brownsdale-Sibley's Cove-Lead Cove" at 60 characters long. 

Funny Designated Place Names

This where you will find the infamous place name Dildo of
Newfoundland and Labrador

3) Some Interesting Finds in the Geographic Place Names Dataset (download) from NRCAN.GC.CA
This dataset comes from Canada Centre for Mapping and Earth Observation, Natural Resources Canada. Geographic "Place Name (PN)" refers to selected names of active and retired geographic areas as well as names from the Canadian Geographical Names Data Base. 

There are
230,549 unique geographic place namesThe shortest PN name "By" is 2 characters longThe longest PN name is  "
Lethbridge, Morley's Siding, Brooklyn, Charleston, Jamestown, Portland, Winter Brook and Sweet Bay" at 98 characters long. 
Funny Geographic Place Names

This were you find the infamous name "Blow Me Down", Newfoundland and Labrador.
Other fun names are; 

Also Blow Me Down Bight, Tomahawk Bay, The Boot Leg Bay, Toadstool Island, Toadasses, Toad River Hot Springs Park, Tor Mountain, Tork 7, Zoot Lake and 
Sẁiẁs Park

Neat or "Curious" Places as mention on StatsCan website

Aklaktuk Pingo (a Pingo is an isolated, conical, ice-cored mound occurring in areas of permafrost)
Funny Creek Names in the Geographic Place Names dataset

There is no 
Schitt's Creek in Canada, but there is Schist Creek, Schiste Creek, and Etschitka, Scherf Creek, Schimmens Creek, Amazon Creek and Blowhole Creek. Butt to top it all off, there's Mashiter Creek

This a total of 
14,447 uniquely named Creeks in all of Canada 
Interesting names ?yu?h Anta?t Teetshik Creek, 150 Yard Creek, Furry Creek, Tea, Creek, Tzela Creek, Zig Zag Creek, Xenia Creek

Fun Find
Can someone confirm these names - (note, most of these live in 
designated places and geographic place name datasets)

Fun Quick Stats of CSD Dataset, in Spreadsheet below

There are no cities / CSDs with a name of length of 1 in Canada.
There are no 
cities /CSDs with a name of length of 2 in Canada.
There are 4 cities / CSDs with a name of length of 3 in Canada.

Table 1 
   Length  Name                                         CSD
         3   Emo Township of
 Tay Township of
 Low Township
 Oka Municipality

Some Edge Cases of City Name Lengths in Canada

Longest CSD name in Canada has 50 characters.

Indian reserve of "Buffalo River Dene Nation 193 (Peter Pond Lake 193)"

Table 2:
CSD (3x3) Edge Cases Table

3 4
4 34
47 1
49 1
51 3

Total Numbers

Total number is 354, 631 named places with repeats in all 3 data-sets, specifically 348,107 PNs + 1, 632 DPLs + 5,162 CSDs. 

There are 237,340 uniquely named places in 3 data-sets. 

(This does not represent all names on a map of Canada, for it does not not including provincial names, roads, marine names like waterways, etc.)

Fun Find
? Can someone confirm these names -
(NOTE: Most of these live in 
designated places and geographic place name datasets)

Excel Spreadsheet of 5,162 cities, municipalities, districts, towns, townships, villages, hamlets, etc. aka CSDs in Canada according Statistics Canada 2017, Population and Dwelling Count Highlight Tables - 2016 Census.

This is a LIVE embedded Excel Workbook shared from OneDrive. You can play with it and screw it up, its read only data. Refresh this page will refresh with spreadshee. See my post on how embed this on your site.

The workbook contains 4 worksheets you may have to slide over to reveal. The worksheets  are named "All-Canada-QuickStats-2016", "All-CSDName(City+Town)-Analysis", "CSD Types Count" and "All-Canada-STATSCAN-SOURCE-2016".

If you haven't figured out how to download this entire Excel Workbook, you can send contact me in the contact form. Else, Easter egg (think bigger picture). Drop a comment if you use this.

No comments:

Post a Comment