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

▶
telling your story using community data
SMART_READER_LITE
LIVE PREVIEW

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

Sep 06, 2023 463 likes •887 views

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,

slide-1
SLIDE 1

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

slide-2
SLIDE 2

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

slide-3
SLIDE 3

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

slide-4
SLIDE 4

Community Data Program

4

slide-5
SLIDE 5

Community Data Program

5

  • Data access
  • Training & capacity-

building

  • Membership-based
  • Local, non-profit
  • run by the Canadian

Council on Social Development

slide-6
SLIDE 6

Community Data Program

6

  • Standard and custom data sets
  • Small geographic scale
  • Census, T1FF, PCCF, credit, Canadian Business Counts, Building

Permits, CCHS, …

  • communitydata.ca
slide-7
SLIDE 7

Data Sources

7

slide-8
SLIDE 8

Data Sources - Census

8

Profile Data

all standard levels of geography

slide-9
SLIDE 9

Data Sources – Taxfiler data

9

  • Family tables
  • Individual tables
  • Senior tables
  • Calculated Financial Assets
  • Financial data and charitable donations
  • Migration estimates
  • Custom CDP data:
  • Working Poor
  • Income Inequality
slide-10
SLIDE 10

Data Sources – Taxfiler data – Lo Low in income

10

Changes to the T1FF low income calculation

  • back years of data are available
slide-11
SLIDE 11

Data Sources – More fr from StatCan

11

  • Building Permits
  • Canadian Business Counts
  • Labour Force Survey
  • Canadian Community Health Survey
  • General Social Survey
  • Longitudinal Administrative Database
  • Longitudinal Immigration Database
slide-12
SLIDE 12

Data Sources – CMHC

12

Housing in Canada Online

slide-13
SLIDE 13

Data Sources – CMHC

13

  • Rental markets
  • Household characteristics
  • Funding
  • Securitization
slide-14
SLIDE 14

Data Sources – CMHC

14

Rental Market Data

slide-15
SLIDE 15

Data Sources – Open Data

15

  • Shelter Capacity Reports
  • Registered charity data (T3010)
  • Permanent resident landings (IRCC)

http://data.ottawa.ca/

slide-16
SLIDE 16

Data Sources – 211 data

16

  • Callers' needs
  • Service availability
slide-17
SLIDE 17

Data Sources – Administrative data

17

  • 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
slide-18
SLIDE 18

Community Data Resources

18

slide-19
SLIDE 19

Resources – Ottawa Neighbourhood Stu tudy

19

“…better define Ottawa neighbourhoods …measure and map neighbourhood social determinants of health amenable to policy interventions.”

slide-20
SLIDE 20

Resources – Path thways to Education

20

“…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”

slide-21
SLIDE 21

Resources – Canadian In Index of f Wellbeing

21

“reports on the quality of life of Canadians – nationally, provincially, and locally”

slide-22
SLIDE 22

Resources – Centre for Community Mappin ing

22

  • 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. “We craft Shared Knowledge Platforms”

slide-23
SLIDE 23

Resources – First Nations Data Centre

23

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

slide-24
SLIDE 24

Resources – Measuring Rural l Community Vit italit ity

24

Rural Ontario Institute (ROI) engaged a number of

  • rganizations and municipalities and produced a variety of

resources

slide-25
SLIDE 25

Reso sources – Neig ighbourhood Fin inancia ial l Healt lth In Index

25

CCSD and Prosper Canada: Indicators on income, debt, savings and assets rolled-up into a single metric

slide-26
SLIDE 26

Resources – Open North

26

  • Do-it-yourself Open Data Toolkit
  • Open Smart Cities Guide
  • Open Smart Cities in Canada Webinar
  • Current Projects

“…specialized in open data, open government, community engagement,

  • pen smart cities and civic technology”
slide-27
SLIDE 27

Resources – Powered by Data

27

“…maximize the availability and impact

  • f data for public good”

Unlocking Administrative Data: Maximizing The Impact for the Social Sector

slide-28
SLIDE 28

Resources – GeoSuite

28

  • Explore the links between standard levels of geography
  • Identify geographic codes, names, unique identifiers
  • Land area and population and dwelling counts
slide-29
SLIDE 29

Resources – GeoSearch

29

  • Interactive mapping application
  • Links to data products, analytical products and maps
slide-30
SLIDE 30

Resources – OpenRefine

30

  • Good for data cleaning, wrangling, refining
  • Administrative and open data sources
slide-31
SLIDE 31

Resources – Mapping Tools

31

  • 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
slide-32
SLIDE 32

Resources – Mapping steps

32

  • 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
slide-33
SLIDE 33

Workshopping

33

slide-34
SLIDE 34

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

slide-35
SLIDE 35

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

slide-36
SLIDE 36

Brainstorming around id ideas of f poverty

  • Material, cultural and

social deprivation

  • Value in focusing on

income (after-tax) - simple!

  • Well-being (democratic,

engagement, community involvement)

  • Social determinants of

health

  • Wealth, property, assets,

debt ($)

  • What do people need to

thrive? (not deprivation)

  • Living wage, working

poverty

  • Number of people in low

income or poverty (not just %)

36

slide-37
SLIDE 37

Brainstorming around id ideas of f poverty

  • Polling (e.g., Vital Signs)

worries, thresholds, hopes

  • Inequity, inequality
  • Access to services and

infrastructure

  • Only measuring income

is not enough

  • What about income that

is not reported?

  • Community assets
  • How many pay cheques

away from losing something? RISK

  • Stories to accompany the

numbers

37

slide-38
SLIDE 38

0.0% 10.0% 20.0% 30.0% 40.0% 50.0%

Low income prevalence by visible minority and generation status, Canada

Total - Generation status First generation Second generation Third generation or more

38

slide-39
SLIDE 39

0.0% 10.0% 20.0% 30.0% 40.0% 50.0%

Low income prevalence by visible minority and generation status, Ottawa

Total First generation Second generation Third or more

39

slide-40
SLIDE 40

Sugg ggested topic areas

  • Housing
  • Poverty
  • Immigration
  • Ethnocultural diversity
  • Education
  • Employment
  • Aboriginal identity
  • Seniors
  • Youth

40

slide-41
SLIDE 41

Report Back!

41