The first portion of this week's lab module focused on converting lat/long Degrees, Minutes, Seconds coordinates to Decimal Degrees in order to be better compatible with ArcGIS Pro. This consisted of using an Excel spreadsheet to convert the data and add the data to ArcGIS Pro displaying three known eagle's nests in Santa Rosa County, Florida. Additionally, we projected the data to the Harn State Plane Florida West coordinate system.
The second portion of this lab consisted of obtaining school addresses in Manatee County and preparing them in an Excel spreadsheet for geocoding in ArcGIS Pro. This exercise involved copying data from the Florida Department of Education website and pasting it into an Excel spreadsheet. From here the data needed to be "cleaned up" or parsed into fields including school name, address, city, zip, phone, and the type of institution (high school, university, etc.) After our data was properly parsed in our Excel spreadsheet it was now ready to be geocoded in ArcGIS Pro. Prior to importing our Excel CSV file we downloaded and added some US County and Manatee County road shapefiles from the US Census Bureau website to ArcGIS Pro. The shapefiles were then projected to the Harn State Plane Florida West coordinate system. Using the Select By Attributes tool we created two new feature classes consisting of only Florida counties and Manatee County.
Finally, we added our school location data from our Excel spreadsheet, set up an address locator, and ran our geocoder to geocode all our addresses. I ended up with 5 unmatched addresses. I had to manually look these five locations up using Google/Google Maps and use the "Pick from the Map" tool to place new points. The above screenshot from my ArcGIS Online web map shows my final geocoded map. This map presents various types of schools that exist within Manatee County (with one exception). To view my web map in ArcGIS Online click here.