#CAJ16
May 27-28
in Edmonton
http://www.caj.ca/events/caj16/caj16-conference-program/
Data journalism
David McKie
CBC News
181 Queen Street
1-613-288-6523 (office)
1-613-290-7380 (cell) 1-613-288-6490 (fax)
Email: david.mckie@cbc.ca
Andrew McIntosh
Investigations Editor, CFE + National Security – Counter Terrorism Correspondent AGENCE QMI Vos
206-445-8748
andrewmcintosh@ymail.com
Twitter: @AndrewMaco
LinkedIn: https://www.linkedin.com/in/
Fred Vallance-Jones
The University of King’s College
fvjones@dal.ca
902.422.1271 ext. 147
Datasets for download
To access the datasets we’ll be using for these sessions, please click here.
Data journalism training
For those interested in following up the training that you received at #caj2016, I’ll be leading a data journalism boot camp with the CTV’s Glen McGregor at Carleton University, beginning the evening of June 24 7-9 pm and running through to end of day June 26. To find out more about the sessions, please visit the Carleton website. There are about 10 spots left. If you have any questions, please feel free to contact me.
Fred and I have a new data journalism book coming out in October, but if you wanted a resource to keep you going until then, please feel free to check out Computer-Assisted Reporting: A Comprehensive Primer. You should be able to pick up a cheap, second-hand copy online.
Open data sites
Alberta
http://data.alberta.ca/
Alberta Historical Wildfire Database
http://wildfire.alberta.ca/wildfire-maps/historical-wildfire-information/historical-wildfire-database.aspx
GeoGratis Product Selection
http://geogratis.gc.ca/api/en/nrcan-rncan/ess-sst/-/(urn:iso:series)canvec
Civil Aviation Daily Occurrence Reporting System (CADORS) – Transport Canada
http://wwwapps.tc.gc.ca/saf-sec-sur/2/cadors-screaq/m.aspx?lang=eng
Edmonton
http://data.edmonton.ca/
Edmonton Fire Response – History
https://data.edmonton.ca/Emergency-Services/Fire-Response-History/3s7f-z7ut
Elections Ontario political donations
https://www3.elections.on.ca/internetapp/efsearch.aspx?lang=en
Elections Alberta
http://efpublic.elections.ab.ca/efCXDataExtract.cfm?MID=CX_DATA
Federal government open data portal
http://open.canada.ca/en/open-data
Trade Data Online (TDO) (Innovation, Science and Economic Development Canada)
https://www.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/Home
Ottawa
http://data.ottawa.ca/en/?page=1
Toronto
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD
Vancouver
http://data.vancouver.ca/
Stories about open data sites
City of Lethbridge launches innovative Open Data Catalogue online
http://globalnews.ca/news/2364381/city-of-lethbridge-launches-innovative-open-data-catalogue-online/
Calgary-based app maps out sports fields and courts
http://metronews.ca/news/calgary/1372887/calgary-based-app-maps-out-sports-fields-and-courts/
Edmonton’s open data initiatives rank #1 among 34 Canadian cities
http://globalnews.ca/news/2456703/edmontons-open-data-initiatives-rank-1-among-34-canadian-cities/
How the quest for a bike collision map opened up city data in Edmonton
http://metronews.ca/news/edmonton/1374445/how-the-quest-for-a-bike-collision-map-opened-up-city-data-in-edmonton/
New Vancouver website will help renters find good landlords
http://globalnews.ca/news/2010721/new-vancouver-website-will-help-renters-find-good-landlords/
Montreal embraces new ‘open by default’ data policy
http://montrealgazette.com/news/local-news/montreal-embraces-new-open-data-policy
New map explores the mysteries of Edmonton’s tax assessments
http://edmontonjournal.com/news/local-news/new-map-explores-the-mysteries-of-edmontons-tax-assessments
Data journalism stories
How to avoid Toronto’s parking ticket hot spots
https://www.thestar.com/news/gta/2016/05/15/how-to-avoid-torontos-parking-ticket-hot-splots.html
Missed garbage pickup complaints rise in east, fall in west
http://www.thestar.com/news/gta/2015/07/09/missed-garbage-pickup-complaints-rise-in-east-fall-in-west.html
New map explores the mysteries of Edmonton’s tax assessments
http://edmontonjournal.com/news/local-news/new-map-explores-the-mysteries-of-edmontons-tax-assessments
NSA Files: Decoded
http://www.theguardian.com/world/interactive/2013/nov/01/snowden-nsa-files-surveillance-revelations-decoded#section/1
Ontario political donations surge, plunge around key policy decisions, Radio-Canada finds
http://www.cbc.ca/news/canada/toronto/ontario-political-donations-1.3588320
‘Open data’: Why it’s making waves across Canada
http://www.cbc.ca/news/technology/open-data-movement-canada-1.3557562
The 100 WORST landlords in Toronto
http://www.landlordwatch.com/
The 15 worst restaurant offenders according to DineSafe
http://www.blogto.com/eat_drink/2015/08/the_15_worst_restaurant_offenders_according_to_dinesafe/
This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press)
http://www.thestar.com/news/gta/2014/08/11/this_fire_hydrant_costs_toronto_drivers_the_most_in_parking_tickets.html
Beech Street fire hydrant has netted city $65,000 since 2008
http://ottawacitizen.com/news/local-news/beech-street-fire-hydrant-has-netted-city-65000-since-2008
Data Journalism Tools
Tableau
Trade Data Online (TDO)
http://strategis.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/Home?OpenDocument#tag
Installing the Tableau Add-In for Reshaping Data in Excel
http://kb.tableausoftware.com/articles/knowledgebase/addin-reshaping-data-excel
To download the Canada small arms trade data export tutorial, please click here.
To download Industry Canada’s small arms sales data, click here.
To download the city of Toronto’s Dinesafe data, please click here.
MySQL
Ontario political donations surge, plunge around key policy decisions, Radio-Canada finds
http://www.cbc.ca/news/canada/toronto/ontario-political-donations-1.3588320
To download the Windows version of MySQL downloading tutorial, please click here.
To download the Mac version of the MySQL downloading tutorial, please click here.
Mapping
Toronto data reveals hundreds of discarded syringes
https://www.thestar.com/news/gta/2013/08/15/toronto_data_reveals_hundreds_of_discarded_syringes.html
ArcGIS
https://www.arcgis.com/features/
Qgis
http://www.qgis.org/en/site/
To obtain the instructions for downloading Qgis, please click here
To download the first Qgis tutorial, please click here.
Check out this national inventory of federal buildings containing asbestos
http://www.cbc.ca/news/canada/ottawa/multimedia/check-out-this-national-inventory-of-federal-buildings-containing-asbestos-1.3555956
Google Fusion Tables
https://support.google.com/fusiontables/answer/2571232?hl=en
Andrew’s examples
Database | 100 people have died from police-involved shootings in Virginia since 2010
http://pilotonline.com/
De riches acheteurs chinois débarquent à Montréal
http://www.journaldemontreal.com/2016/04/19/de-riches-acheteurs-chinois-debarquent-a-montreal
Plusieurs clients chinois achètent sans hypothèque
http://www.journaldemontreal.com/2016/04/20/plusieurs-clients-chinois-achetent-sans-hypotheque
Des Chinois fortunés s’installent de plus en plus à Westmount
http://www.journaldemontreal.com/2016/04/21/des-chinois-fortunes-sinstallent-de-plus-en-plus-a-westmount
Deux policiers de Montréal ont créé un empire immobilier de près de 25 M$
http://www.journaldemontreal.com/2016/05/17/deux-policiers-de-montreal-ont-cree-un-petit-empire-de-limmobilier
Deux policiers ont créé un empire immobilier de près de 25 M$
http://www.tvanouvelles.ca/2016/05/17/deux-policiers-ont-cree-un-empire-immobilier-de-pres-de-25-m
Remorquages de véhicules entravant les opérations de la ville de Montréal
http://donnees.ville.montreal.qc.ca/dataset/remorquages-de-vehicules-genants
Actes criminels – introductions par effraction
http://donnees.ville.montreal.qc.ca/dataset/actes-criminels
Licences restreintes, suspendues et annulées
https://www.rbq.gouv.qc.ca/salle-de-presse/les-grands-dossiers/industrie-de-la-construction-lutte-contre-la-criminalite/licences-restreintes-suspendues-et-annulees.html