This week, our project involved geocoding a dataset using open source data. I started with cleaning a raw tabular dataset composed of the names and addresses of various schools located in Manatee County Florida, obtained from the Florida Department of Education. In Excel, I separated the raw information of schools in Manatee County, Florida into tabular data that would ensure successful geocoding in ArcGIS Pro. Utilizing the power of spreadsheets, I used Excel text formulas to expedite the process and saved the table to a CSV file. Next, I downloaded Florida and Manatee County Tiger/Line shapefiles from the United States Census Bureau Geography program.
After projecting shapefiles into a common State Plan coordinate system, I created an address locater using the Census Bureau data and the cleaned address data. Once geocoding was complete, I had one unmatched address due to missing information in the original census data. To adjust this error, I dropped a point on the correct location using the “Pick from map” button. I chose to symbolize the schools by type. Finally, I published the Geocoded Manatee County Schools map in a web map, making it publicly accessible. Please follow the link and check it out!
https://pns.maps.arcgis.com/home/webmap/viewer.html?webmap=c785a1c4e5864f44ace019e350cb4a33
No comments:
Post a Comment