At first blush, it looks like there’s nothing on the map. So, you’ll have to zoom in. Areas like Vancouver, Calgary, Winnipeg, Toronto, Ottawa, and Halifax have the census tracts that contain the growth rates in recent immigrants between 2011 and 2016. Census tracts are located in communities with more than 100,000 people, and each census tract is a geographic area where between 2500 and 8000 people live. So, they’re quite small, as are the number of recent immigrants. Zooming in will take you to the colour-coded census tracts. The pop-up boxes contain numbers for 2011, 2016 and the percent difference. The rates in some areas are growing, remaining stagnant or shrinking. To avoid confusion, we have removed tracts in which zero recent immigrants were in 2011. Statistics Canada explains that “any change from 0 cannot be really measured as a % increase.” Although the agency does go on to explain that it’s important to “keep in mind that observed 0s should not be interpreted as true 0s – values could be rounded down or populations may not have been selected in the sample.”
Yellow represents negative growth. Tracts with the darker hues are in the positive.
This page contains a tutorial for uploading the city of Ottawa’s 311 complaints data from Jan. 1, 2017, to August 2017 into MySQL.
Below the video tutorial, you’ll also find the MySQL queries that can be downloaded, and then uploaded to a MySQL query tab, allowing you to follow along.
As well, you’ll also find the PowerPoint presentation that accompanies the tutorial, complete with the page references in The Data Journalist. and the MySQL dump file that we uploaded for our Sept. 27 session.
Click within the provincial boundaries to see the average housing prices for 2017. The table below the map shows city comparisons for July 2016 and July 2017, as well as the per cent differences, which are sorted in descending order.
To return to the original view, click anywhere outside the North American map.
Points on the map were downloaded from Halifax’s open data site on August 9, 2017. The different coloured points represent crimes that have occurred in Halifax Regional Municipality within a seven-day period. To see the individual crimes, click the dots for a pop-up box. Click the double-arrows at the top left to see the legend.
Each census tract represents the percent change of lone-parent families in Halifax. The darker colours represent the areas with the highest percents. To see the census tract’s number, click inside the polygon to obtain a pop-up box.
The darker purple colours represent the 2016 census tracts (called dissemination areas) that contain the highest number of unoccupied dwellings. To learn more details about the tracts with largest counts, zoom into the desired areas by clicking on the “+” sign, then clicking within the boundaries to produce a pop-up box with the details. The names represent the federal ridings, which should help you better situate the high-concentration areas.