Finding & Using Geospatial Data

1. Finding & Using Geospatial Data Marcel Fortin University of Toronto Map and Data Library gis.maps@utoronto.ca http://uoft.me/FindingGeo last updated: December 3, 2015

2. Workshop objectives • Discover what are GIS/Geospatial/Spatial Data • How these data are used • Use local and external portals and websites to discover data • Download and manipulate datasets • Discover and use Census of Canada Data

3. Workshop sections • Part I - Introduction to geospatial data • Part II - Using the MDL geospatial data catalogue • Part III - Using the Scholars Portal Geoportal • Part IV - Finding and Using Census of Canada Data • Part V - SimplyMap • Part VI - Other Online geospatial data portals, websites, and map making tools

4. Part I - An introduction to geospatial data

5. Geospatial data: Raster & Vector

6. Loading data into a GIS

7. Points Lines and Polygons

8. Working with attribute data

9. Spatial calculations

10. Spatial Selections

11. Attribute and Spatial Joins

12. Raster Data

13. Part II - Using the MDL Data catalogue

14. 7 - Click on the Download button and click on I agree 8 - Download the Italy_provinces_2009.zip file 9 - Go back to the metadata record by clicking on your browser’s Go Back option twice 10 - Examine the metadata record again 11 - Click on the Geography ICELAND 12 - Select the Geospatial Data Collection → Subject Search 13 - Select item 16 City of Mississauga Datasets (2015-03-01) 14 - Click on Download → I agree 15 - Download the Contour.zip file 16 - Select the Geospatial Data Collection → Advanced Search 17 - Fill in the form as below and select search (make sure to click the Scanned maps only box 1 1 - Go to http://mdl.library.utoronto.ca 2 - Select the Map & GIS Website 3 - Select Search → Search the Geospatial Data Inventory... 4 - Select Geospatial Data Collection → Geography Search 5 - Click on Italy 6 - Select item 9 - Europe Complete Global Maps (2009) in the list by clicking on it

15. 8 - In the search box type toronto land use dmti 2013 and click on Search 9 - Select CanMap RouteLogistics Toronto, city subset v2013.3 10 - Click on Download → I agree 11 - Download the ONlur.zip file 2 1 - You should only have one resulting map 2 - Click on the title of the map 3 - Examine the metadata and click on Download 4 - Click the file with the .htm extension 5 - Play around with the zooming and out functions 6 - Go back to the metadata record and download the .zip file 7 - Select Geospatial Data Collection → Google Custom Search

16. 4 - In ArcMap, click on the add data icon 5 - Click on the Connect to Folder icon 6 - Select the C:\users\Documents\ folder and click on OK 7 - Add the Italy Provinces 2009.shp shapefile 8 - Now add the G_6081_P2_550_1947.tif file 9 - Select Yes to building the pyramidpop up dialog box. 10 - Click on the Full Extent icon. You should now see a map similar to the one below 11 - In ArcMap, click on the following icon to open ArcCatalog 12 - In ArcCatalog, locate your Folder Connections. 13 - Within the folders locate the data files you downloaded 14 - Select the ONlur.shp file and drag it into your map 3 1 - Open ArcMap from the Start menu. 2 - In Windows Explorer Navigate to the C:\users\Documents folder 3 - Right-click on each zip file you downloaded and select 7-zip → Extract Here (notice the tif and shapefiles)

17. 6 - Click on the Full Extent icon 7 - Using the Add Data icon, select Add Basemap… 8 - Select any of the base maps and click on Add 9 - Using the Zoom in and Zoom out tools, pan and zoom to to various layers 10 - If you end up with a blank screen, simply click on the Full Extent icon 4 1 - Using Windows Explorer, locate your documents folder in C:\users\Documents\ 2 - Notice the number of files that make up a “shapefile” 3 - Locate the file called CONTOUR.shp and drag it into your map 4 - Ignore the Warning popup 5 - In the ArcMap Table of Contents, right-click on the ONlur layer and select Zoom to Layer

18. Part III - Using the Scholars Portal Geoportal

19. 3 - Click to Download the Toronto Base Maps, Metro title 4 - These titles are all restricted to U of T and refer to the data in the MDL geospatial data inventory 5 - Click on Back to Results 6 - Click to Access resource for the City of Toronto Land Information item 7 - You should have been sent to a data resource in the MDL geospatial data inventory. 8 - Go back to the geoportal tab 5 1 - go to http://geo.scholarsportal.info 2 - Type in the search box Toronto Land Use and click on Search

20. 3 - Click on Find Data 4- Select the facet called Land use and planning and then select Sort by Area: largest 5 - From the results, select Add - 0/6 from the Land Use (LUR) layer 6 1 - In the geoportal, click on the Place or Address button, type in Toronto in the search box and click on Search 2 - Click on Zoom

21. 3 - Using the map tools on the left-hand side of the map screen (or the mouse wheel), zoom in and out of the land use data. 4 - Type of the following address in the search box and click on Place or Address: “130 St. George street, Toronto” 5 - Click on Search and the the Zoom button 6 - You should be above Robarts. 7 - Zoom out three times using the zoom-out tool. 7 1 - From the Downloads screen, click on Add next to the 2014 dataset. 2 - Click on I agree on the Conditions of use agreement

22. 4 - Turn the Land use (LUR) - 2014 layer off, and then on again. The land use layer should turn off and then re-appear 5 - Click on the Download button 6 - Select Download by area of Interest and then Draw an area 7 - Select the rectangle tool 8 1 - Your map should now look something like this 2 - On the left side of the screen, select Map(1) 3 - A legend similar to this one should appear

23. 2 - Select the Shapefile - (.shp) format and leave the coordinate system option as Same as Input. 3 - Click on Download 4 - In the Download list, right-click and save the linked zip file to your Documents folder. 9 1 - Draw a rectangle to select most of the map area

24. 3 - Select the Greater Toronto Area (GTA) Orthophotography Project 2007 dataset by clicking on Add - 0/2 4 - Select the tiff image service by clicking on the add button next to it 5 - Your map should look something like this one below 10 1 - Go back to the Search tab and turn off the faceted search for Land use by clicking on the small blue x 2 - In the topics list, select the Imagery, base maps, and land cover (12) facet

25. 11 1 - Select the Download tab 2 - Select Download by area of Interest 3 - Under Choose an area of Interest:, select Draw an area 4 - Select the rectangle tool 5 - Draw an area surrounding Robarts Library as you did with the previous example 6 - Click on Download 7 - Once processed, right-click on a few of the tif files and save them to your Documents folder.

26. 2 - In ArcMap, using the Add Data icon, add both the _ags_DMTI_2014_CanMapRL_Topo_LUR_ALL_PROV shapefile and the TIF files you just downloaded. Your map should look something like the one below 12 1 - In your Documents folder, right-click on the _ags_DMTI_2014_CanMapRL_Topo_LUR_ALL_PROV.zip file and using 7-zip, and select extract here.

27. Part IV Finding & Using Census of Canada Data

28. 4 - Note the difference between the two boundary files? 5 - Click on the Map tab and remove all layers except the Cartographic Boundary File 13 1 - Go back to the Scholars Geoportal where we will look for census tract information. Census Tracts look like this. 2 - In the Search box, enter census tracts boundary files and click on Search 3 - Add to the map both the Digital Boundary files and the Cartographic Boundary files. 4 - Zoom into the Toronto area near the Lake Ontario Shore

29. 14 1 - Click on the Download tab 2 - Select Download by area of interest 3 - Select Select a pre-defined area 4 - Under Select an area type and click the map as Census Metropolitan Areas 5 - Leave the output options as is 6 - Click on the map (make sure you are clicking inside the Toronto area) 7 Click on Download

30. 6 - In the table of contents, right-click on the boundary file layer, and select Open Attribute Table 15 1 - Save the resulting zip file into your Documents folder 2 - Navigate to your Documents folder and unzip the the downloaded zip file using 7-zip and select Extract Here 3 - Load the resulting shapefile into ArcMap. 4 - Click on the full extent icon 5 - Your map should now look something like the one on the right.

31. 5 - Under Aggregate statistics, click on Profile Files 6 - Scoll down to Census Tracts and click on CHASS census analyser 16 1 - You will notice that the attribute table contains no population values. 2 - In your web browser go to http://mdl.library.utoronto.ca 3 - Select the Data Website. 4 - Select the Census of Canada menu option → Aggregate → 2006

32. 17 1 - Scroll down and select Profile of Census Tracts (cumulative) 2 - Select Toronto as your CMA 3 - Select the first 4 variables under Census Category

33. 18 1 - Scroll down further on the screen and select to Include in the result, the CTUID 2 - Select the output format as dbase (DBF) 3 - Leave all other default options 3 - Click on Submit Query

34. 4 - This text file contains the data dictionary for your attribute data and describes all the columns in your dbf file 5 - In ArcMap, load the dbf file by adding it using the Add Data icon (note that you cannot drag dbf files into ArcMap) 19 1 - Right-click and download both resulting files into your Documents folder. 2 - Navigate to your Documents folder 3 - Open the resulting text file (.txt) into a text editor (double-click on it)

35. 2 - Take note of the column names in your attribute table. Col1 is the most important one to us for the moment. 3 - In the Table of Contents, right-click on the Cartographic Boundary File and select Joins and Relates → Join... 20 1 - Right-click on the dbf file in Table of Contents and select Open

36. 21 1 - Select the Join attributes from a table option 2 - Select CTUID as the field the join will be based on 3 - Select the table (dbf) the join will be executed on 4 - Select COL1 as the column in the table (dbf) the join will be made on 5 - In the Join Options, Select Keep all records 6 - Click on OK

37. 22 1 - Open the boundary file’s Attribute Table. You will notice that your population numbers are now attached to each polygon 2 - Close the attribute table. 3 - Right-click on the boundary file again and choose Properties

38. 23 1 - In the Layer Properties window, select the Symbology tab 2 - Select to Show: → Quantities → Graduated colors 3 - select the Fields Value:COL3 to be normalized by COL5 4 - This calculation gives you a population density map based on the fact that COL3 represents the total population for each polygon in the 2006 census, and COL5 represents the land area for each polygon. 5 - Click on OK 6 - Your map should look something like the one on the right

39. Part V - SimplyMap 1 - Go to http://simplymap.com 2 - Register...TBC

41. Part VI - Other online geospatial data

42. 6 - United States Data Google : GIS Clearinghouse “state name” 7 - Most open data sites contain between 70-90% geospatial datasets http://toronto.ca/open 24 1 - National topographic data: Geogratis.ca 2 - LIO Metadata tool: https://www.javacoeapp.lrc.gov.on.ca/geonetwork/ 3 - Ontario online topographic map making tool http://www.giscoeapp.lrc.gov.on.ca/matm/Index.html?site=Make_A_Topographic_Map&viewer=MATM&locale=en-US 4 - ArcGIS online 5 - Business Analyst Online