Finding Data & GIS Files at the U of S Library Kiran Doranalli Lucy Li

1. Finding Data & GIS Files at the U of S Library Kiran Doranalli Lucy Li https://library.usask.ca/data/

2. https://library.usask.ca/

3. Always remember to login with NSID and password!!

4. https://library.usask.ca/data

5. Ways to Find Files • Library Catalogue • Statistics Canada Catalogue • Web front ends to data: CANSIM, … • Variable level • U of S Data Archive • Variable level 5. Talk to the Data Library staff

6. 1. The Library Catalogue • Know the name of the survey • Looking for a print copy of a codebook Locate a survey by entering the survey name Keyword Search: agriculture

8. Limit your search by “scoping” select Data & GIS files from the pull-down menu more manageable result list

10. 2. Statistics Canada Catalogue • Statistics Canada overview: • A Census every five years • 350 active surveys on virtually all aspects of Canadian life • Search files by keywords or subjects: • agriculture • crop • Off-farm income

15. Census of Agriculture • Status: Active • Frequency: Quinquennial (5 year) • Objective: The Census of Agriculture is conducted to develop a statistical portrait of Canada's farms and its agricultural operators. • Subjects covered: major commodities of the agriculture industry, new or less common crops, livestock, finances and use of technology.

16. Census of Agriculture • Clients: Federal government, provincial and territorial governments, municipal governments; libraries; educational institutions; researchers and academics; private industry; business associations and labour organizations; private citizens; public interest groups.

17. 3. Variable level • Library has access to several web extractors CANSIM via CHASS

19. CANSIM (Canadian Socio-Economic Information Management System) • Statistics Canada’s database of time series • Covering a wide variety of social and economic aspects of Canadian life • containing more than 38 million time series regrouped in approximately 2,800 tables

20. CANSIM II (via CHASS and via E-STAT): • Current and historical time series data for Canada • 38 million time series • Production, sales, trade • CANSIM II via CHASS--Updated weekly • CANSIM II via E-STAT—Updated annually

21. CANSIM I • The version before CANSIM II • Has not been updated since June 1st, 2002.

22. Restrictions on use • CANSIM via CHASS: licensed for use by the U of S faculty, staff and students for academic research and study • CANSIM via E-STAT: licensed for use by students in schools and colleges and universities

23. Demonstration: CANSIM II via CHASS • New version • Continue in English • CANSIM Multidimensional @ CHASS Main Menu • Browse tables by subjects

26. By dimensions • Select the dimensions in table10009: geography (Quebec, Ontario, BC), estimates (Farm value), commodity (Apples), farm area, production and value (Dollars) from the menu Submit • Select the series you want add selected to the series cart • Choose time period, output display (As a time series listed as columns), output format  retrieve the series from cart • Plot format in output format plot charts (draw multiple graphs, draw one graph (max 7 series))

27. Farm values of apples in dollars in Quebec, Ontario, BC, between 1997-01-01 and 2007-01-01

28. Output format: plot-bars graph (draw one graph) - v74278 Quebec; Farm value; Apples; Dollars - v74279 Ontario; Farm value; Apples; Dollars - v74283 British Columbia; Farm value; Apples; Dollars

29. U of S Data Archive • Data Lib webpage • By subject • Select the file • U of S data archive • Download the file and unzip it • Codebooks and other documentations are available in PDF format (some are available in print copy…search in library catalogue) • Restrictions: DLI license

31. Canada Food Stats (CD-ROM) • information on Canadian food consumption, nutrition, supply and demand, trade, prices … • data on the Canadian food industry, processing, economic indicators, labour, productivity, …

32. Census of Agriculture (various) • Farm and farm operator data • Small area data at Census Agricultural Regions (CARs*) • Tables from 1961 to date * A census agricultural region (CAR) is a sub-provincial geographic area used primarily by the Census of Agriculture for disseminating agricultural statistics.

33. Extraction system of agricultural statistics (CD-ROM) • extract data by census agricultural region, farm type and revenue class • i.e. dairy production in Quebec or off-farm income in Saskatchewan current and historical

34. FAO – Food and Agriculture Organization of the United Nations (special password) • Special license for bulk downloading • 3 million time-series and cross sectional  data relating to food and agriculture • FAOSTAT contains data for 200 countries and more than 200 primary products and inputs, just in its core.  http://faostat.fao.org/

35. Canada Grains Council: Statistical Handbook • Grain industry overview • Area, supply, yield • Exports and trade • Prices ie. Canola oil, meal, corn and soybean monthly prices • Handling and transportation • Livestock: price, numbers on farms by class • Total Farm Cash Receipts http://canadagrainscouncil.ca/

36. Eligibility and restrictions • Restriction: DLI license The Data Liberation Initiative Eligibility: Postsecondary academic staff and students Conditions: restricted to teaching and research purposes

37. 5. Ask Data Library Staff Office: 2nd Floor, Murray Library • Appointments recommended • Email us at refdata@library.usask.ca Kiran Doranalli (8841) Lucy Li (8841) Winnie Smit (7261) Rob Alary (5987) Elise Pietroniro (2677) Darlene Fichter (7209) ( on sabbatical)

38. Questions?