Lab 6. Geocoding and Data Visualization in ArcGIS Pro
Objectives:
• Learn how to geocode data in ArcGIS Pro
• Learn how to create different visualizations in ArcGIS Pro
Data:
• Download mass shooting data in 2022 from https://www.gunviolencearchive.org/
Steps:
1. Clean the mass shooting CSV file in Excel.
1.1. Delete the columns that only have null values
1.2. Chang the incident date column to date type
1.3. Save the cleaned file into a new CSV file.
2. Geocode the mass shooting data.
Geocoding helps you convert addresses, place names into coordinates, and display them on a map.
2.1. Create a new ArcGIS Pro project and drag the cleaned mass shooting CSV file to the ArcGIS project.
2.2. Right-click the CSV file and select Geocode Table.
2.3. Choose ArcGIS World Geocoding Service as the Locator
2.4. Choose NAD 1927 Contiguous USA Albers as the coordinate
3. Non-spatial Query
3.1. In Map/Select, click Select by attribute.
3.2. Create a new selection where the State is equal to Virginia.
3.3. Open the attribute table and check how many records are selected.
3.4. In Map/Select, click Clear the selection.
4. Query by geography
4.1. In Catalog/ Portal/ Living Atlas, search and drag USA Counties Generalized Boundaries to your project.
4.2. Make sure Richmond City is selected by using the Map/Select tool.
4.3. Open Map/Select by Location: the input feature is the geocoded points, and the selecting feature is the USA Counties (where only Richmond will be the selecting feature). Choose the appropriate relationship.
4.4. Open the attribute table and check how many records are selected.
4.5. Clear all the selections and remove the USA Counties.
5. Create charts
5.1. Right-click the geocoded points and choose a bar chart to show the total number of deaths and injuries in each State.
5.4. Create a line chart showing the total number of deaths and injuries over time.
6. Optional: Create an Animation
6.1. Create a graduated symbol map to show the number of deaths. Try different classification methods. Use a light color for the dots.
6.2. Enable the time attribute of the mass shooting layer.
6.3. Change the base map to a dark color.
6.4. In View, Add Animation
6.5. In the Annotation panel, Insert the Time Slider.
6.6. Set the total duration to be 10 seconds.
6.7. Export the animation as a GIF file.