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.
http://www.davidmckie.com/OttawaServiceCalls_2013-2017_Dump_20170926.zip