|
Data Journalism research methods, Fall 2016 JOUR 4101 – E Wednesdays 19:00-22:00 Location: Room 1105 Richcraft Hall (the TV Newsroom)Instructor: David McKie 181 Queen Street Phone Number: 1-613-288-6523 (office) 1-613-290-7380 (cell) Email: david.mckie@cbc.ca Teaching Assistants: Muhammad Zeeshan Email: Phone Number: (613) 700-0352 Kent Jacobs Email: Phone Number: 613-406-5250 Data journalism stories | What you will learn | Needs and Special Accommodations | Assignments and deadlines | Week one | Week two | Week three | Week four | Week five | Week six |Week seven | Week eight | Week nine | Week ten | Week eleven | Week twelve | Week thirteen | Assignment One | Assignment One |Assignment Two| Assignment Three | Assignment Four | Readings | Additional Reading |Tutorials | Datasets | COURSE DESCRIPTIONThe goal of the Data Journalism Storytelling course is to teach students how to find and negotiate for data that is already publicly available, or must be obtained formally or informally through a federal access-to-information or provincial or municipal freedom-of-information request. We will analyse the records using the following: Excel; MySQL, the data-visualization such as Tableau Public and ArcGISOnline; the document-annotation software called DocumentCloud; and the mapping program called Qgis. Taken together, these skills comprise computer-assisted reporting, now more commonly known as data journalism. Our textbook is The Data Journalist: Getting the Story. At the end of this term, students will become adept at searching for information, perusing and downloading files from government open-data websites, analyzing the material for story ideas, or for questions that could lead to stories. They’ll learn how to use Excel or MySQL to spot trends, and employ data-visualization and mapping programs to show the patterns and allow readers to interact with the material, such as being able to identify the income level or levels of crime in their neighbourhood. As well, they’ll be taught how to perform spatial joins, allowing them to, for instance, see how many income groups, federal contaminated sites, oil spills, construction projects, discarded needles and syringes and government grants fall within certain municipal, provincial and federal electoral boundaries. These matches, and more importantly the story ideas that are produced, can only be obtained using mapping software ArcMap and Qgis. For instance, spatial joins have allowed journalists such as Glen McGregor, formally with the Ottawa Citizen and now with CTV News, to tell the story about the bodies of water protected under the former Harper government’s Navigable Waters Protection Act located in or near federal Conservative ridings. Working with census data, students will also learn how to map characteristics such as income level, much the same way former Montreal Gazette journalist, Robero Rocha, did to help readers visualize the median household income. This exercise will be good preparation for the 2016 long-form census results , which Statistics Canada is publishing this year. Stories and visualizations will be submitted as blogs on this course’s WordPress site, allowing for a multi-media treatment. Documents used as reference material will be uploaded to the account that will be created for you in DocumentCloud, annotated, and then embedded into the blogs. Though it’s designed to be a data-journalism-focused research methods course, there will also be a heavy emphasis on storytelling, both with words and data in properly-labelled and sourced interactive maps and charts. As such, we will begin each class with a story that has appeared in the news: either as an example of how data journalism was used, or how it could have been used. These discussions and the exercises will help students develop new analytical and storytelling skills. Specially designed tutorials based on data used in this class, and tutorials from The Data Journalists will be used to drive home some of the key spreadsheet and mapping skills that will form the course’s backbone. The course will be divided up into four, three-week modules. Each module will teach the following skills: Excel; MySQL, analysis using the mapping software Qgis; and visualization using ArcGIS Online and OpenStreetMaps. There will be four assignments ( please see chart below ), building to a final assignment that combines all the skills we’ve learned during the semester. There will also be two in-class tests worth five percent each, one to test your spreadsheet skills, the other to gauge your knowledge of conducting basic queries in MySQL. This is a professional school, and you’ll be held to professional standards in both assignments and conduct. As a student of journalism, you must read and adhere to the School’s policies:
Undergraduates can find all three policies on this page https://carleton.ca/sjc/journalism/undergraduate-studies/resources-current-undergraduate-students/ Graduates can find all three policies here https://carleton.ca/sjc/journalism/graduate-studies/resources-current-students/ You are expected to be familiar with these policies and apply them to your work. Failure to abide by them will adversely affect your standing in the course. Special needs and Accommodation (TOP)You may need special arrangements to meet your academic obligations during the term. For an accommodation request the processes are as follows: Pregnancy obligation: write to us with any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. For more details visit the Equity Services website: http://www2.carleton.ca/equity/ Religious obligation: write to us with any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. For more details visit the Equity Services website: http://www2.carleton.ca/equity/ Academic Accommodations for Students with Disabilities: The Paul Menton Centre for Students with Disabilities (PMC) provides services to students with Learning Disabilities (LD), psychiatric/mental health disabilities, Attention Deficit Hyperactivity Disorder (ADHD), Autism Spectrum Disorders (ASD), chronic medical conditions, and impairments in mobility, hearing, and vision. If you have a disability requiring academic accommodations in this course, please contact PMC at 613-520-6608 or pmc@carleton.ca for a formal evaluation. If you are already registered with the PMC, contact your PMC coordinator to send us your Letter of Accommodation at the beginning of the term, and no later than two weeks before the first in-class scheduled test or exam requiring accommodation (if applicable). After requesting accommodation from PMC, meet with one of us to ensure accommodation arrangements are made. Please consult the PMC website for the deadline to request accommodations for the formally-scheduled exam (if applicable) at http://www2.carleton.ca/pmc/new-and-current-students/dates-and-deadlines/ You can visit the Equity Services website to view the policies and to obtain more detailed information on academic accommodation at http://www2.carleton.ca/equity/ School ethics policy: http://www1.carleton.ca/journalism/ccms/wp-content/ccms-files/EthicsPolicy.pdf School publishing policy: http://www1.carleton.ca/journalism/ccms/wp-content/ccms-files/PublishingPolicy.pdf School electronic media usage policy: http://www1.carleton.ca/journalism/ccms/wp-content/ccms-files/media-usage-policy-2010.pdf Data Journalism Stories (TOP)Examples stories using data journalism
UNFOUNDED: WHY POLICE DISMISS 1 IN 5 SEXUAL ASSAULT CLAIMS AS BASELESS
https://beta.theglobeandmail.com/news/investigations/unfounded-sexual-assault-canada-main/article33891309/?ref=http://www.theglobeandmail.com& How Is Immigration Viewed In The EU? How to avoid Toronto’s parking ticket hot spots Fatal Force New map explores the mysteries of Edmonton’s tax assessments NSA Files: Decoded Ontario political donations surge, plunge around key policy decisions, Radio-Canada finds This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press) Walmart: Thousands of police calls. You paid the bill. The 100 WORST landlords in Toronto Settling for Misconduct To gain access to a running, up-to-date list of the latest data journalism stories, please click here. WHAT YOU WILL LEARN (TOP)1) How to find data on government open-date web portals 2) How to use a spreadsheet to analyze statistics 3) How to create a pivot table 4) How to use advanced functions in Excel 5) How to use technical skills such as exporting tables from PDFs into Excel 6) How to use MySQL 7) How to advance your numeracy skills 8) How to use Tableau Public 9) How to use Qgis , ArcGIS Online, and the web platform, OpenStreetMap 10) How to geocode data points 11) How to become effective storytellers Assignments and Deadlines (TOP)Assignments in this course are governed by the provisions of the document Ethics and Standards in the School of Journalism and Communication. There are four assignments, each with a deadline. Lateness will be penalized with the deduction of a half a grade for every day the story is overdue, though exceptional circumstances will be taken into account. Questions or appeals about your grade on assignments or other graded components of the course should be raised with the instructor no later than seven business days after the grade has been issued, as explained in the university’s academic regulations (2.7 and 2.8). Your final course grade is based on grades earned throughout the term on the assignments and other graded components listed in the syllabus. This means requests to raise an overall course grade at the end of the term or year cannot be considered. Standing in a course is determined by the course instructor subject to the approval of the Faculty Dean. This means that grades submitted by an instructor may be subject to revision. No grades are final until they have been approved by the Dean. There is no final examination. Each assignment has two components, all of which will figure in the grade: A. A description of how the documents and data were obtained, why they were useful and how the material was analyzed B. The resulting story Final standing in this course is determined by the course instructors subject to the approval of the Dean of Public Affairs. This means that final grades submitted by the instructors may be subject to revision. No grade is final until it has been approved by the Dean. Academic Integrity This course abides by Carleton University’s Academic Integrity Policy. Acts of academic dishonesty include, but are not restricted to, plagiarism and unauthorized resubmission of work, and will be dealt with accordingly. Students who fake any part of their stories or research, plagiarize anyone else’s work, or otherwise cheat on their assignments will get MORE than just a failing grade. They will be dealt with according to the university’s rules for Academic Integrity. The full undergraduate policy is here http://carleton.ca/senate/wp-content/uploads/Academic-Integrity-Policy1.pdf The full graduate policy is here http://calendar.carleton.ca/grad/gradregulations/
GRADESA+ 90-100 A 85-89 A- 80-84 B+ 77-79 B 73-76 B- 70-72 C+ 67-69 C 63-66 C- 60-62 D+ 57-59 D 53-56 D- 50-52 Stories in the A-range are newsworthy, original, accurate, and well-told with very little editing. As such, they are publishable. Stories in the B-range contain similar qualities, but require more editing, and possible restructuring, especially if the lead is buried, or the focus is unclear. Stories in the C-range and D-range require additional research and substantial re-writing in order to them to be published. Stories assigned an “F” grade miss deadlines without being granted extensions and contain major errors. COMMUNICATIONS WITH STUDENTSThis will be done primarily through email correspondence and phone calls, given that I do not have an office at Carleton University. The protocol will dictate that emailed queries will be answered as promptly as possible, if possible within the hour. As such, it will be important for you to regularly check your email account for updates regarding assignments, new datasets or class work. You’ll also be required to use your Carleton University account, not a second account such as gmail. PROFESSIONALISMWe’ll conduct ourselves as professional journalists. That means attending class, showing up on time; being prepared and ready to make a meaningful contribution based on the preparation work you’ve been assigned; paying attention to your instructor and colleagues and ignoring email correspondence, Facebook, text messages, Twitter, and promptly responding to emails from the instructor. You’ll also be expected to stay on top of current events, which is part of your obligation as a journalist. If you must miss class, please communicate with the instructor via email well ahead of time, and then make sure you take steps to catch up. If your absence is due to a medical reason, you may be required to provide a doctor’s note. If it’s for an internship, then you’ll have to provide details. REQUIRED SUPPORT RESOURCESThe course would be taught in the TV computer lab, using the overhead projector. As the school possesses an ArcMap licence, we are be able to use the mapping software, which is installed on the desktops. We also use the open-source software, Qgis. The library’s Maps, Data and Government Information Centre is well positioned to provide support to faculties including journalism and communications. OUTLINEWeek One(TOP)Sept. 6What we will cover: Introduction to the course Installing needed software A discussion about open data Making an informal access-to-information request for a federal dataset Sorting and filtering Working with Statistics Canada’s crime data and the Canadian Institute for Health Information’s LINKS: Open data websites Access to information and privacy Hate crimes against Muslims in Canada up 60%, StatsCan reports Statistics Canada: Police-reported hate crimes, 2015 CANSIM – Table directory – All Section Population by year, by municipality Census Profile, 2016 Census Alcohol sends more Canadians to hospital than heart attacks: report Alcohol leads to more hospitalizations than heart attacks do in Canada CIHI Self-Injury Hospitalization Definition Week Two(TOP)Sept. 13WHAT WE WILL COVER A review of our sorting and filtering from the previous week An introduction to using ratios and numeracy fundamentals Functions using IF statements How to use DocumentCloud LINKS: Ontario’s 2016 deficit was $991 million, beating target by $3.3 billion Ontario Releases 2016-17 Public Accounts The Public Accounts of Ontario 2016-17 Ontario Data Catalogue Canadian international merchandise trade, July 2016 Trade Data Online Section 1: Concepts and definitions Seasonally adjusted data – Frequently asked questions Week Three(TOP)Sept. 20WHAT WE WILL COVER Pivot tables Specialized functions Cracking PDFs using Cometdocs Discussion of the Sept. 22 assignment Review infogram tutorial LINKS 10 principles for data journalism in its second decade Public sector salary disclosure Ottawa Police Cometdocs Week Four(TOP)Sept. 27WHAT WE WILL COVER Test: spreadsheet, filtering, sorting pivot tables; general open data concepts explained in chapter two Introduction to MySQL Performing basic select queries LINKS: This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press) Top complaints to City of Toronto’s 311 line and how to avoid a complaint against your home The city of Ottawa’s 2017 Monthly Service Requests Ontario’s public sector salary disclosure Week Five(TOP)Oct. 4WHAT WE WILL COVER Continuation of MySQL Queries to join tables IN MySQL Discussion of assignment due on Oct. 20 LINKS: Shielded By The Badge: Convicted, But Still Policing Statistics Canada Ottawa Public Health Inspection Data EmEditor UltraEdit Notepad++ TextWrangler Week Six(TOP) Oct. 11WHAT WE WILL COVER A continuation of MySQL perfecting the queries we’ve learned so far And an introduction to web scraping LINKS: Office of the Commissioner of Lobbying of Canada: Registry Search and Statistics The Social Network – screen scraping scene Boil Water Advisories – Health Canada First Nation locations Examples of stories that have used more sophisticated data journalism techniques, including scraping Before you read the stories, you can check out the explanations from the NICAR listserv by clicking here. How the Doctors & Sex Abuse project came about Uber seems to offer better service in areas with more white people. That raises some tough questions BuzzFeed News Trained A Computer To Search For Hidden Spy Planes. This Is What We Found Bhumika Can Speak For Herself What We Learned About The Mood Of Trump’s Tweets Computational Journalism Week Seven(TOP)Oct. 18WHAT WE WILL COVER An introduction to mapping and Qgis with Rebecca Bartlett, a specialist from the Carlton library who, A discussion of the census assignment due on Nov. 17 Links: 2016 Census of Population advisory: Aboriginal peoples, Immigration and ethnocultural diversity, and Housing NHS Profile, Canada, 2011 2016 Census Program release schedule Searching and Downloading OpenStreetMap Data OpenStreetMap How the Epidemic of Drug Overdose Deaths Ripples Across America This Week’s Top Ten in Data Journalism Week Eight (TOP) (Fall break)Oct. 25Have a good break!! Week Nine (TOP)Nov. 1WHAT WE WILL COVER The latest 2016 Census 2016 census release Links: Map: Where immigrants in Canada live – Nearly 22% of Canada’s population are immigrants, according to latest Census figures Aging Aboriginals pose new fiscal, social challenge for government: census Census 2016: Toronto housing affordability now worse than Vancouver Canada getting more diverse as immigration, Indigenous population increase How the Star’s census coverage came together First-time GTA home buyers take to the skies in condos Condo lifestyle the choice of more families Map: Where immigrants in Canada live Dictionary, Census of Population, 2016 Hierarchy of standard geographic areas for dissemination, 2016 Census
Reference materials, 2016 Census 2016 Census – Boundary files Census Profile, 2016 Census Download, Census Profile, 2016 Census 2011 Census Profile – Comprehensive download files for a selected geographic level: CSV or TAB 2011 NHS Profile – Download NHS data for a complete geographic level: CSV or TAB GeoSearch – search geography by name or code GeoSearch (Statistics Canada’s geographic gateway) Guide to the Census of Population, 2016 A continuation of mapping and an introduction to Statistics Canada’s latest census release — Crowdmapping as a new data source for journalists Links: Week Ten(TOP)Nov. 8WHAT WE WILL COVER Working with census data An introduction to OpenStreetMap Week Eleven(TOP)Nov. 15WHAT WE WILL COVER: Introduction to ArcGIS Online Spatial joins A discussion of the final assignment LINKS: An International Consortium of Investigative Journalists: a collection of Paradise Papers stories Create Your ArcGIS Public Account Median Household Income Mapped in ArcGIS Online Pipeline Incident Data Federal Contaminated Sites Federal Contaminated Sites Inventory Federal Contaminated Sites Inventory Open Dataset Data Dictionary Week Twelve(TOP)Nov. 22WHAT WE WILL COVER Review of previous assignment Discussion of final assignment Spatial joins in Qgis LINKS: Toronto is now majority visible minority. What about your neighbourhood TransCanada starts excavation work after South Dakota pipeline leak
Pipeline Incident Data – National Energy Board Decontaminating LeBreton sites could cost as much as $50 million, says expert Federal Contaminated Sites Inventory Week Thirteen(TOP)Nov. 29WHAT WE WILL COVER Test with details to come Geocoding in Qgis Buffering in Qgis LINKS: The man who gives out the most parking tickets in Boston Here’s where your bike is most likely to get stolen in Toronto Toronto Police Service – Public Safety Data Portal Assignment One(TOP)Qs AND As: What is the due date? Before class by midnight Sept. 22 What is required? A 600-word story using a dataset that we have explored in class or another dataset from the agency that you prefer more? A 500-word explanation in a Word document of how you researched the story, including original documents, data and sources, complete with their phone numbers, email addresses and Twitter accounts. An Excel workbook containing the original table and worksheets containing subsets of your data? Should I check with you before using the data? No. You’ll be using the datasets that we’ve discussed so far in class including StatsCan crime data and the Canadian Institute for Health Information’s hospitalization data. How should I analyze the data? Using the techniques that we’ve studied so far (filtering, sorting, percentage increases) How is the assignment to be submitted? You will upload the story to a WordPress category that you’ll be assigned. The Word document and Excel workbook are to be emailed to my CBC address as attachments. What am I looking for in the story? A well-told yarn, with a sharp, crisp lead that makes the audience want to keep reading. Avoid using too many numbers. Think about the most important numbers, and concentrate on them. As writing coach Don Gibb once remarked, choose a number as carefully as you choose a quote. All your references MUST be hyperlinked to the original source. For instance, if you are referring to a study that states a certain fact, then there should be a hyperlinked reference to the original document. What I want to see is evidence of solid research. DO NOT LINK TO NEWS REPORTS THAT SIMPLY REFER TO THE STUDY IN QUESTION. Should the story have any interviews? Yes, at least two, including someone who is directly or indirectly impacted by the trend that you’ve identified. So get the data work completed early enough to allow for enough time to find the right characters for your story. You have plenty of time to complete the assignments, so finding the right characters should be feasible. Should one of the interviewees be an expert? Yes. It could be a knowledgeable police officer, a criminologist , lawyer, trade expert or professor. The expert MUST not be an advocate. Seek out credible, non-partisan voices. Will I lose marks for having less than one interview? Yes, half a grade. Should I have any visualizations? Absolutely. We’ll explore visualizations more in-depth as the term progresses. For this assignment, there should be at least two, including a picture of the subject of your story. Infogr.am with its shallow learning curve might be the easiest option for this story. If you are already familiar with other visualization tools, please feel free to use them. Will I lose marks for neglecting to submit visualizations, or at least the minimum number of them? Yes, half a grade. Can I submit a draft? Yes. However, because this is a large class, I will accept ONLY ONE per student, and will not accept a draft less than 48 hours BEFORE the due date. Remember, a draft can be point form, or even an explanation of where you intend to take the story, if you’re running out of time. Your assignment should not be your first draft. What is the deadline? Midnight Sept. 22. Anything after that will be considered late and docked half a mark. Extensions will be only be granted for exceptional circumstances. However, we must have a conversation. Assignment Two (TOP)Qs AND As: What’s the due date? By midnight Oct. 20 What do I submit?
How is the assignment to be submitted? You will upload the story to a WordPress “CarletonDataJournalism2” What’s the topic? Any dataset that we have discussed in the MySQL section. How many interviews do I need? At least two. One must be an expert; the other must be involved somehow. Do I have to do extensive work in MySQL? No, just the initial data work to obtain the table you want, which can be then Will I be required to use visualizations? Yes, at least two. If you’re using a picture, make it a good size that Will I be required to hyperlink key references in my text to the original source? Absolutely! Can I submit outlines and drafts? Yes, but given the size of the class, I can only review one version, using the same criteria outlined in the assignment one Q and A. Will I be docked half a grade for neglecting to submit any of the required elements? Yes. Will I be docked half a grade for neglecting to give my visualizations titles, source citations and Remember: Keep it simple. The fewer numbers, the better. Tell a story!! Assignment Three (TOP)Qs AND As: What’s the due date? By midnight Nov. 17 This assignment will be based on Statistics Canada’s Oct. 25, 2017 Census release on Immigration and ethnocultural diversity. What’s the topic? The characteristics of the census tract that you choose to highlight, focusing on factors such as the reason for How many interviews do I need? At least two. One must be the person who is involved in the story; for instance, someone who embodies the trend. Will I be required to use visualizations? At least two. The map that you have created in Qgis uploaded to ArcGIS Online or Google Fusion Tables; Will I required to hyperlink key references in my text to the original source? Absolutely! And even better Can I submit outlines and drafts? Yes, but given the size of the class, I can only review one version. What do I submit? A 600-word story posted to the assigned category on our WordPress site to the Will I be docked half a grade for neglecting to submit any of the required elements? Yes. Will I be docked half a grade for neglecting to give my visualizations titles, cite sources or provide Will I be docked half a grade for a late submission? Yes. Remember: Keep it simple. Tell a story!! Assignment Four (TOP)Qs AND As: Deadline: By midnight Dec. 4 The sky is the limit for this assignment. You can choose any dataset: a new one, or one that we’ve already used. You can also follow up a previous story. The choice is yours. As for the type of story, it can be a 600-word piece; a paragraph that sets up self-explanatory and well-made visualizations with titles, cut lines, source citations; or a combination of the first two. In short, any of the formats we used for previous assignments. Your story can also have multi-media elements, but make sure to stick to the word length. You’ll notice that I’ve attached more conditions that in the past I have tended to ignore. Given that this is a final Post the story to the “CarletonDataJournalism4” category. What’s the topic? Any topic. Must I properly cite the source of my data? Yes. Will I lose a half a grade for neglecting to do so? Yes. How many interviews do I need? At least three. One must be the person who is involved in the story and Must I conduct at least one of the interviews in person? Yes. Will I get docked a half a grade if I neglect to do this? Yes. How will the audience know if I’ve conducted the interview in person? If there is the kind of colour, Will I be required to use visualizations? At least two. One must be a picture, complete with cut line and Will I required to hyperlink key references in my text to the original source? Absolutely! Unless it is a killer Can I submit outlines and drafts? Yes, but given the size of the class, I can only review one version. What do I submit? A 600-word story posted to “CarletonDataJournalism4” category; Will I be docked half a grade for neglecting to submit any of the required elements? Yes. Will I be docked half a grade for neglecting to give my visualizations titles, source citations and Will I be docked half a grade for a late submission? Yes. However, if you need an extension, please let me know. Remember: Keep it simple. Tell a story!! Readings(TOP)Week One: Week two: Week three: Week four: Week eight: Week twelve Chapter seven – Working with GIS Programs Additional Reading (TOP)Week one: Tutorials(TOP)From week one: To obtain the tutorial on sorting and filtering the Canadian Institute for Health Information’s hospitalization From week two: To obtain the pivot table tutorial, please click here. For instructions on how to upload data to infogr.am, please click here. From week three: To obtain the specialized functions tutorial, please click here. To obtain the questions we used for our pivot table exercise using ACOA data, please click here. From week four: To obtain the Google Fusion Table tutorial, please click here. To obtain the Excel test, please click here. From week five: To download the Windows version of MySQL installation tutorial, please click here. To download the Mac version of the MySQL installation tutorial, please click here. Click here to see the YouTube tutorial on downloading 311 complaints data from the city of Ottawa’s PowerPoint to accompany MySQL tutorial using 2017 311 data.pptx Queries for Ottawa 311 data 2013-2017.sql CH5 – Making Tables and Importing Data into MySQL.pdf CH5 – Getting Started with Queries in MySQL.pdf From week six: Tutorial for querying Ottawa inspections data in MySQL.pdf Appendix A:Data Integrity and Cleaning.pdf From week seven: Journalism4208_GISPresentation2017_PartOne.pdf JOUR4208Handout_2017_final_Oct23_PartTwo.pdf From week seven: From week nine: CH7 – QuickTourQGISDesktop.pdf CH7 – Selecting Featuresin QGIS Desktop.pdf CH7 – The Data Journalist: Selecting Featuresin QGIS Desktop.pdf From week ten: Please click here for the tutorial for joining csv files with census tract shape files in Qgis For Kent Jacob’s tutorial on downloading Open Street Map data, please click here. From week eleven: Building Maps with ArccGIS Online_updated.pdf From week twelve: CH7 – Working with Projections in QGIS.pdf From week thirteen: 7_19_GeocodinginQgisDesktop_NEW_.pdf Datasets(TOP)From week one: From week two: From week three: To download the workbook for the The Data Journalist- Getting the Story_updated.xlsx OntarioPublicSectorSalaryDisclosure_2014-16.xlsx DefectiveVehicleComplaints.xlsx Ward_12-Rideau-Vanier_Crimes Against The Person.pdf From week four: OttawaServiceCalls_2013-2017_Dump_20170926.zip From week five: Crime_1998-2016_Dump20171001_andQueries.zip AllOttawaInspections_dump_ScriptsQueries.zip From week six: To obtain the city of Ottawa parking ticket dump file, For the queries used to create the tables in the city of Ottawa parking ticket dump file, To obtain the dump file containing federal lobbyist records and the queries used to First Nations Boil Water Advisories and Locations in Google Sheets From week seven: The income data for the mapping tutorial in Qgis From week eight: From week nine: Census2016_Immigration_Housing_CensusTractAndWardsBoundaryFiles.zip From week ten: To obtain the files that accompany the census tract tutorial under Please click here for 2016 median household income csv files broken down by census tracts. From week twelve: FederalContaminatedSitesData.csv From week thirteen: Canadian Post Codes |
|||||||||||||||||||||||