1 / 41

CANSIM A look at 3 interfaces

Learn how to access, search, and visualize data using CANSIM, E-STAT, and CHASS interfaces. Discover the various output formats and manipulation options available.

kareemb
Download Presentation

CANSIM A look at 3 interfaces

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CANSIMA look at 3 interfaces Ontario DLI Training University of Guelph April 12, 2006 Suzette Giles Data, Map and GIS Librarian Ryerson University Library

  2. Where? What? Access Content Searching Results Visualization Manipulation Output formats Which to use? A look at Stat. Can. website, E-Stat and CHASS

  3. “Imitation is the sincerest flattery”Sources: • Statistics Canada: About CANSIM: http://www.statcan.ca/english/ads/cansimII/index.htm • Statistics Canada E-STAT: http://estat.statcan.ca/content/English/over.shtml • University of Toronto CHASS CANSIM information: http://00dc1.chass.utoronto.ca/cansim2/English/index.html • University of Toronto Data Library Services: http://www.chass.utoronto.ca/datalib/codebooks/cstdli/cansim.htm

  4. Where is CANSIM?? • Statistics Canada home page: • Click on Advanced search • Search CANSIM is in left hand menu • OR Click on Our Products and Services • CANSIM is under “ Access our Online databases” • E-STAT: • Left hand menu of Table of Contents page • CHASS: Google or go via University of Toronto’s Data Library Service page “CHASS interface to selected databases”

  5. What is CANSIM? • “CANSIM is Statistics Canada's key socio-economic database.” (Stat Can website) • “CANSIM: Canadian Socio-Economic Information Management System.” (CHASS) • “CANSIM is a multidimensional database containing more than 26 million time series regrouped in over 2,400 tables” E-STAT April 4, 2006

  6. CANSIM I and CANSIM II • CANSIM I : Original CANSIM database consisting of 908,879 time series in 9,380 matrices. Contains matrices and time series not in CANSIM II. Series start with a letter followed by numbers (called a label) Last updated June 1, 2002. (CHASS) • CANSIM II (CANSIM). Reorganized database. Matrices called Tables. Time series all start with a V, sometimes called a vector or a label (CHASS)

  7. Timing!! • NOTICE: The CANSIM service will be unavailable most of this coming weekend, from 7PM (Eastern time) Friday April 7 to approximately 7PM Sunday April 9, because of a major database reconfiguration.

  8. Access

  9. Content

  10. NOTES • When a method of measurement or definition or an attribute or concept changes, the old series is terminated, and a new series with a new series identifier is begun. (CANSIM – the many faces, UT/DLS) • When SIC 1980 was changed to NAICS 1997 series were terminated and new ones begun. This explains the limited time line of the NAICS series

  11. Content (CANSIM II)

  12. Searching

  13. Searching

  14. NOTES – Searching/ Results • CHASS - get listing of series unless search by Table number • Stat Can - get listing of Tables unless search by Series number • Therefore difficult to compare retrieval • PETS – CHASS got 60 series (82 with carPETS) • PETS – Stat Can got 5 tables – did not include carpets • Important to check “Match full keyword” in CHASS

  15. Results

  16. Results

  17. Results

  18. NOTES Notes from Chris Leowski’s presentation in 2002: • CANSIM II: vector numbers not recycled when a series terminated. In CANSIM I they were. • No frequency conversion in the CHASS CANSIM II, this is not a CHASS priority. • Badly need a way of pointing users to series that replace terminated series and vice versa.

  19. Visualisation of results

  20. Manipulation of Results

  21. Output formats * Choice of time as columns or rows

  22. Choosing which to use • Currency – Daily vs. weekly vs. yearly • Ease of searching – pick lists in Stat. Can. helpful • Sophistication of user – list of series can make finding data difficult with CHASS interface • Frequently used series are fast – in CHASS • Could use Stat Can interface to find series # and then go to CHASS to get most recent data • Output required – CHASS has more formats for statistical packages • Data manipulation required • Data visualisation required

  23. Statistics Canada: Search results

  24. Statistics Canada: Series selection

  25. Statistics Canada: selecting Dimension members and dates

  26. CHASS: Selection options

  27. CHASS: Keyword search

  28. CHASS: Results page

  29. CHASS: Series information

  30. CHASS: Retrieval, date and output selection

  31. CHASS: Display of data

  32. E-STAT: Search CANSIM

  33. E-STAT: Text search

  34. E-STAT: Advanced search

  35. E-STAT: Search results

  36. E-STAT: Series selection

  37. E-STAT: selecting Dimension members and dates

  38. E-STAT: output options

  39. E-STAT: HTML table, time as rows

  40. Search done on topic Pets in CANSIM II, CHASS interface

More Related