Monday, March 27, 2017

Stack Overflow Developer Survey Results 2017 - most jobs come through networking

Stack Overflow Developer Survey Results 2017 

More than 64,000 developers from 213 countries participated in this year's annual survey by Stack Overflow -- the largest number ever -- giving a glimpse into the collective psyche of programmers around the world. An anonymous reader quotes their announcement:

Job Discovery

How Did Developers Find Their Current Job?

A friend, family member, or former colleague told me
  • 26.8%
I was contacted directly by someone at the company (e.g. internal recruiter)
  • 17.9%
A general-purpose job board
  • 13.9%
An external recruiter or headhunter
  • 13.4%
I visited the company’s Web site and found a job listing there
  • 8.5%
Some other way
  • 7.7%
A career fair or on-campus recruiting event
  • 7.7%
A tech-specific job board
  • 4.0%
23,737 responses
Networking matters. The most common way developers found their most recent job was through a friend, family member, or former colleague who told them about it. The second most common, however, is by being contacted by someone at the company, such as a company recruiter.

Friday, March 24, 2017

A complete list of 5,162 cities, municipalities, districts, towns, townships, villages, hamlets in Canada from Stats Canada's Census in 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.

Wednesday, March 22, 2017

Google Site Search aka Google Custom Search end of life April 1, 2018 no joke

Google Site Search or Google Custom Search End-of-Life

On April 1, 2017, Google will discontinue sales of the Google Site Search. All new purchases and renewals must take place before this date. The product will be completely shut down by April 1, 2018.

Google Site Search
(formerly Google Custom Search Business Edition) is an edition of Google Custom Search specifically designed for businesses looking to create a highly customized and Google-hosted site search solution - with the option to include other websites and pages outside of their own. For a fee, Google Site Search provides technical support, customization of search results using XML API, a tailored look and feel, optional Google branding, and no ads next to the search results. While Google Custom search allows you to search the entire web, Google Site Search doesn't permit you to search the entire web but only a specific set of web sites.

Official notice :

Work Around

Looks like I have to build a custom solution using BING WEB SEARCH API. Contact me if you need this done! 
This will be  gone by April 1, 2018

Disappointed to see this go, this will affect loads of my customers.