Vancouver has consistently been ranked in one of the top 5 best places to live in the world. As a result, this triggered many interest from people around the world (including people from other provinces) to migrate to Vancouver and live. Many people around the world move to Vancouver for school, work, working holiday, migration, and various other reasons. As a result, we're seeing many parts of the city being redeveloped into higher density condominiums.

With a limited land supply and an increase of demand, along with slow pace of development approval process, the price of the land has gone up. With one of the slowest rise in provincial minimum and average wage in Canada, Vancouver has become less affordable, especially for the younger demographics. This would mean people are paying longer mortgages and living in smaller spaces.

I wanted to find out which neighbourhood are people moving into and moving out of. Thus, I've created a map showing where the highest population growth has been in the last 10 years, along with a charts showing the age composition of neighbourhoods in the city. I've also added a scatter plot of the median age and average dwelling values in various neighbourhoods.

This could be helpful in determining which neighbourhoods will need support infrastructure for young families (daycare facilities, schools, and such). Also, to determine which areas are out of reach for people to move into, thus resulting negative population growth, along with aging population in terms of median age. Urban planners should consider rezoning opportunities for higher density development but making sure numerous housing types to balance population growth, affordability, characteristics, and integrity of the neighbourhoods to keep the quality of life to a high standards.

The map below shows population growth in the city from 2001 to 2011.

<iframe src="https://cheungkl04.github.io/LT-Maps-w-G-Sheets/" width="90%" height="700"></iframe> # From this map, we can see the downtown peninsula had the highest population growth within city proper (27,990 in 2001 to 43,415 in 2006, to 54,690 in 2011).

Grandview-woodland has the biggest population decline from 2001 to 2011 (29,085 in 2001, to 28,205 in 2006, then 27,305 in 2011).

Shaughnessy, the historical neighbourhood for the wealthy, is also in decline in terms of population from 2001 to 2011.

The chart will show the various neighbourhoods in the city and the composition of age demographics.

<iframe width="939.5" height="580.9241666666667" seamless frameborder="0" scrolling="no" src="https://docs.google.com/spreadsheets/d/1IiSdQwNaB51xkVnd3RNxQhxLu0t_4nU2CvaYq0BD8Jk/pubchart?oid=1485065387&format=interactive"></iframe>

This chart shows which neighbourhoods young adults of Vancouver (aged 20 to 34) are living in.

<iframe width="943" height="570.4124999999999" seamless frameborder="0" scrolling="no" src="https://docs.google.com/spreadsheets/d/1IiSdQwNaB51xkVnd3RNxQhxLu0t_4nU2CvaYq0BD8Jk/pubchart?oid=1155543093&format=interactive"></iframe>

It seems like the downtown peninsula is a popular place for young people to live. A pie chart will further examine the demographics of the downtown peninsula (the Downtown proper and the West End).

<iframe width="554.2601078167118" height="345.5" seamless frameborder="0" scrolling="no" src="https://docs.google.com/spreadsheets/d/1IiSdQwNaB51xkVnd3RNxQhxLu0t_4nU2CvaYq0BD8Jk/pubchart?oid=1385958942&format=interactive"></iframe>

Here's a Tableau Public scatter chart of Median Age vs Average Dwelling Value in the City of Vancouver.

<iframe width="943" height="570.4124999999999" seamless frameborder="0" scrolling="no" src="https://public.tableau.com/views/VancouverMedianAgeandDwelling/Sheet1?:embed=y&:display_count=yes"></iframe>

All data was obtained online through the City of Vancouver website. Their file names are: CensusLocalAreaProfile2001.xls, CensusLocalAreaProfile2006.xls, and CensusLocalAreaProfile2011.xls. Thus, you can download the data and make your own charts and maps!

The 2016 census is expected to be released in the 3rd quarter of 2017.

What I've learned from this course: Skills in searching for data, best methods to display (visualize) the data, learning about geojson, leaflet, github, Google Sheets, etc and how all these play together in terms of data visualization and open source mapping.