140 likes | 249 Views
DLI - Small Area Data Product Review. Jeff Moon Maps, Data, & Government Information Centre (MADGIC) Queen’s University National DLI Training Montreal May 14, 2007. Small Area Data. What data exists? Where does it come from? Coverage – Years, Geography? Content?
E N D
DLI - Small Area DataProduct Review Jeff Moon Maps, Data, & Government Information Centre (MADGIC) Queen’s University National DLI Training Montreal May 14, 2007
Small Area Data • What data exists? • Where does it come from? • Coverage – Years, Geography? • Content? • Strengths & Weaknesses?
Content of note… SAAD: Economic Dependency Ratios Economic Dependency Ratio (EDR) Ratio of transfer payments to every $100 of total employment income. e.g. EDR of 18.64 means that $18.64 was received in transfer payments for every $100 of employment income for that area. Provincial Index (Province = 100) & Canadian Index (Canada = 100) EDR expressed as a % of the EDR for the province. e.g. If EDR for an area has a provincial index of 114, that EDR is 14% higher than the provincial EDR. Same applies to Canada.
Strengths & Weaknesses SAAD – Strengths… • The place to go for detailed taxfiler information for small areas • Data broken down by gender, age, income, living arrangements, & more • Generally well documented (guides provided, but would have been nice to have definitions, footnotes, etc. in Excel Tables)
Strengths & Weaknesses SAAD – Weaknesses… • Tables include column for Postal Walk, but no data provided • Tables broken up into inconsistent ‘chunks’ (e.g. 1995-2001 then 1999-2003, and 1995-2000 then 2003… where’s 2002?) • Economic Dependency Profiles show up in a number of places… confusing • http://library.queensu.ca/webdoc/ssdc/cdbksnew/saad/saad_guide.htm#edp
Strengths & Weaknesses SARTRE – Strengths… • The only database that provides retail sales at a geographical level as small as the postal code. • Provides 5-digit NAICS codes starting in 1999. • Census of companies registered as corporations. • Possible to use these data to build econometric models based on the retail sales variables. However, the strength of this database is cross-sectional rather than chronological analysis. • Its data follows closely the levels of data of annual and annualized monthly surveys. Source: prod.library.utoronto.ca:8090/datalib/codebooks/cstdli/sartre/sartre-gid.doc
Strengths & Weaknesses SARTRE – Weaknesses… • Cannot be used for chronological analysis; postal code changes prevent this. • Data published is dated. • Many records are deleted for reasons of confidentiality (Duffett Rules). • Data does not include non-incorporated stores, whereas the annual survey does. • Comparison with other sources of retail sales information (monthly and annual surveys (NAICS estimate)) at the FSA level is not possible and instead must be carried out at the provincial level. Source: prod.library.utoronto.ca:8090/datalib/codebooks/cstdli/sartre/sartre-gid.doc
Strengths & Weaknesses SABAL Strengths: • Vast array of data from a variety of sources Weaknesses: • Dated and dead. No new version of SABAL since 1996. • Less detail (e.g. SARTRE has 5-digit NAICS, SABAL has 4-digit in Business Register)
Other Sources of Small Area Data Census of Canada: • The most detailed geography available – DA and block. PCensus for MapPoint • Canadian Consumer Expenditures – detailed expenditures to DA level and non-standard geography (circles, polygons, drive-time polygons) • Canada Business Summary – Numbers of businesses to 2-digit NAICS to the DA level and non-standard geography • Census data for non-standard geography