Telling Your Story Using Community Data Michael Ditor, Canadian - PowerPoint PPT Presentation

Telling Your Story Using Community Data Michael Ditor, Canadian Council on Social Development mike@communitydata.ca Leveraging Our Strengths Conference St. Paul University, Ottawa June 14, 2018 1

Workshop Format (? (?) • Assess capacities, needs, expectations • Presentation • Community Data Program • Data sources • Resources • Workshop model • Workshopping! • Topic groups • Data sources, possible narratives • Supporting information • Report back 2

Who are you, anyway? Why are you here? • Data capacity? • Community Data Program member? • Who are you? • Do you use data? What data? • How often do you use data? • What do you want? 3

Community Data Program 4

Community Data Program • Data access • Training & capacity- building • Membership-based • Local, non-profit • run by the Canadian Council on Social Development 5

Community Data Program • Standard and custom data sets • Small geographic scale • Census, T1FF, PCCF, credit, Canadian Business Counts, Building Permits, CCHS, … • communitydata.ca 6

Data Sources 7

Data Sources - Census Profile Data all standard levels of geography 8

Data Sources – Taxfiler data • Family tables • Individual tables • Senior tables • Calculated Financial Assets • Financial data and charitable donations • Migration estimates • Custom CDP data: • Working Poor • Income Inequality 9

Data Sources – Taxfiler data – Lo Low in income Changes to the T1FF low income calculation - back years of data are available 10

Data Sources – More fr from StatCan • Building Permits • Canadian Business Counts • Labour Force Survey • Canadian Community Health Survey • General Social Survey • Longitudinal Administrative Database • Longitudinal Immigration Database 11

Data Sources – CMHC Housing in Canada Online 12

Data Sources – CMHC • Rental markets • Household characteristics • Funding • Securitization 13

Data Sources – CMHC Rental Market Data 14

Data Sources – Open Data • Shelter Capacity Reports • Registered charity data (T3010) • Permanent resident landings (IRCC) http://data.ottawa.ca/ 15

Data Sources – 211 data • Callers' needs • Service availability 16

Data Sources – Administrative data • Government agencies • Social service providers • Examples: • Social housing units, wait lists, wait times • Child care spaces • Recreation and cultural facilities • Long term care beds • Solid waste management • Water and air quality 17

Community Data Resources 18

Resources – Ottawa Neighbourhood Stu tudy “…better define Ottawa neighbourhoods …measure and map neighbourhood social determinants of health amenable to policy interventions.” 19

Resources – Path thways to Education “…indicators that matter most for youth and education… designed to identify communities where large numbers of young people are at risk of poor learning outcomes” 20

Resources – Canadian In Index of f Wellbeing “reports on the quality of life of Canadians – nationally, provincially, and locally” 21

Resources – Centre for Community Mappin ing “We craft Shared Knowledge Platforms” • Apps, Toolkits, Publications… Mission: • Research, develop, supply and sustain information technology and communications services (ITC) to strengthen civil society • Spin-off for-profit enterprises that have beneficial socio-economic impact. 22

Resources – First Nations Data Centre Free access to FNIGC’s published data… • First Nations Regional Early Childhood, Education and Employment Survey Report • First Nations Regional Health Survey (2008/10) Report • First Nations Regional Health Survey (2015/16) Report Fee-based custom tables on request 23

Resources – Measuring Rural l Community Vit italit ity Rural Ontario Institute (ROI) engaged a number of organizations and municipalities and produced a variety of resources 24

Reso sources – Neig ighbourhood Fin inancia ial l Healt lth In Index CCSD and Prosper Canada: Indicators on income, debt, savings and assets rolled-up into a single metric 25

Resources – Open North “…specialized in open data, open government, community engagement, open smart cities and civic technology” • Do-it-yourself Open Data Toolkit • Open Smart Cities Guide • Open Smart Cities in Canada Webinar • Current Projects 26

Resources – Powered by Data “…maximize the availability and impact of data for public good” Unlocking Administrative Data: Maximizing The Impact for the Social Sector 27

Resources – GeoSuite • Explore the links between standard levels of geography • Identify geographic codes, names, unique identifiers • Land area and population and dwelling counts 28

Resources – GeoSearch • Interactive mapping application • Links to data products, analytical products and maps 29

Resources – OpenRefine • Good for data cleaning, wrangling, refining • Administrative and open data sources 30

Resources – Mapping Tools • Arc GIS Community Viewer - 2D and 3D mapping, visualization, analytics, data management • Mango Map - online GIS analysis tools, data visualizations, workflows • Open Layers - display map tiles, vector data, markers • Mapinfo Pro - map displays, analytics, edit tabular and spatial data, visualizations options • GIS Cloud - collaborative mapping, map editor supports vector and raster formats, GIS, data analysis, exporting • Carto - manage data and create maps (simple, cluster, intensity, etc) • Mapline - create maps from excel, lots of visualization options • uDig – user-friendly desktop internet GIS • Tableau – interactive, links to dashboards 31

Resources – Mapping steps • Download boundary files • Download data in CSV format • Open boundary files as layer in GIS • Import CSV file • Import .csvt file with same name to ensure proper formatting (“String”, “Integer”, “Real”). If your geographic identifiers are text, then indicate that field is a “String” • ‘Join’ CSV data file to boundary file layer • Format data to display choropleth map 32

Workshopping 33

Workshop ele lements • Separate into groups by topic of interest • Discuss: • Key concepts • Data sources – standard, derived • Brainstorm around relevant concepts and measures • What can’t be measured? • Potential stories • Report back 34

Example workshop on poverty Key Concepts • Low income measures (LIM, LICO, MBM) • Median/average income • Core housing need • Housing affordability, suitability, adequacy • Working poverty • Income inequality • Consumer debt 35

Brainstorming around id ideas of f poverty • Material, cultural and • Wealth , property, assets, social deprivation debt ($) • Value in focusing on • What do people need to income (after-tax) - thrive ? (not deprivation) simple! • Living wage, working • Well-being (democratic, poverty engagement, community • Number of people in low involvement) income or poverty (not • Social determinants of just %) health 36

Brainstorming around id ideas of f poverty • Polling (e.g., Vital Signs) • What about income that worries, thresholds, is not reported? hopes • Community assets • Inequity, inequality • How many pay cheques • Access to services and away from losing infrastructure something? RISK • Only measuring income • Stories to accompany the is not enough numbers 37

Low income prevalence by visible minority and generation status, Canada 50.0% 40.0% 30.0% 20.0% 10.0% 0.0% Total - Generation status First generation Second generation Third generation or more 38

Low income prevalence by visible minority and generation status, Ottawa 50.0% 40.0% 30.0% 20.0% 10.0% 0.0% Total First generation Second generation Third or more 39

Sugg ggested topic areas • Housing • Poverty • Immigration • Ethnocultural diversity • Education • Employment • Aboriginal identity • Seniors • Youth 40

Report Back! 41