GEOG4480-W24_Lab03

.pdf

School

University of Guelph *

*We aren’t endorsed by this school

Course

4480

Subject

Geography

Date

Apr 3, 2024

Type

pdf

Pages

2

Uploaded by JusticeFrogPerson1050

Report
GEOG*4480-W24 Lab 3 In this lab, you will gain experience with the following: • Finding, downloading and citing publicly accessible datasets • Working with tabular data in python using the pandas library • Plotting and interpreting time series data • Joining spatial and aspatial tables Due: February 6 th before the beginning of your regularly scheduled lab session The Province of Ontario publishes vaccination data on a regular basis. These data are collected at the level of the Public Health Unit (PHU). There is a category of vaccination data for the province with the title “COVID -19 Vaccine Data in Ontario ” on the Ontario data catalogue, which you can find using the search function. In that category, find and download the comma- separated file (csv) dataset with the title “COVID -19 Vaccine data by Public Health Unit ” . Q: What is the full name of the file format used for this dataset? Why can you not directly visualize this dataset in a GIS map document? In other words, what specific information needed to enable this is missing from this file? (1 mark) Find and download the Ministry of Health Public Health Unit (PHU) boundaries from the Ontario GeoHub. This should be available in a variety of spatial data formats (.shp, .geojson, FGDB, etc.). You might be able to find it elsewhere (e.g., via Scholar’s GeoPortal). Open up an ArcGIS Pro map document and add this dataset to your project. Q: What is the spatial reference system of this dataset? (1 mark) Q: What are the names of the attributes in this dataset, and what do they each mean? (4 marks) We’ll deal with this issue a bit later. First, we’re going to dig into this dataset to better understand it and create some summary statistics from it. Open the jupyter notebook entitled “ GEOG4480-W23_Lab03 .ipynb” and follow the instructions written there. Answer the questions in the space provided in the notebook and submit the .ipynb file along with your lab report document (15 marks) Once you are finished running through the notebook, you should have created a new csv file. Add that file to your ArcGIS project. If you’ve closed it, open it again and make sure your PHU layer is also open in the project.
Join the PHU boundary feature layer to your newly created table. You can find the Join functionality by right- clicking on the boundary feature layer and navigating to “Joins and Relates” and clicking “Add Join”. The fields in the Join tool should be fairly sel f-explanatory. Create a join using the PHU ID column on both the input feature layer and the table you created in the jupyter notebook. Q: With your boundary feature layer joined to the summary csv file you created earlier on the PHU ID column, create a map showing the proportion of fully vaccinated young adult residents in each PHU across Ontario. Discuss the spatial patterns observed in this map. Can you think of potential reasons why these spatial patterns are observed? What other spatial variables might you consider bringing into your analysis to further explore the spatial distribution of vaccination rates across Ontario? (10 marks) Q: Create a new jupyter notebook. Copy/paste and adapt the relevant code and create a new csv file representing most recent vaccination rates among a different age group. Create another map, as you did above, showing the spatial distribution of vaccination proportions for the age group you chose. How does the distribution compare to the map you created above? Careful: make sure your legend is the same for both maps! You will probably have to change them in the Symbology tab to make these maps comparable. Note: the vaccination rates were consistently high among adults aged 70 and up, so the maps for these age groups are not interesting. Please do not include these age groups in your analysis. (10 marks) Important: Be sure to cite all datasets you use in this lab at the end of your lab report! You may choose a citation style, but you must be consistent. A simple way is to use APA (see https://guides.nyu.edu/datasources/data-citation for an example). Make sure the full URL is included in your citation, so your TA can retrieve the file(s) you used if needed. (up to -2 marks if not complete). When you are finished, you should submit the following to the teams Assignment portal: 1. A pdf document with your answers to the questions in this document, along with all maps. Maps should be properly labelled and include all necessary map elements like scalebars, etc. 2. Completed jupyter notebook with answers to written questions entered directly in the cells where indicated.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help