🌎 Locate addresses using data from US Census shapefiles
Python scripts to build geodatabase from US Census shapefiles, create address locators in ArcMap, and locate addresses
Build address locators
- Download and unzip US census shapefiles (1_get_census_data.py)
- Add fields for FIPS county code and FIPS state code to address features (2_add_fields.py)
- Create a geodatabase of merged address features (3_create_geodatabase.py)
- Create a dual ranges address locator in ArcMap (4_create_street_address_locator.py)
- Add places (i.e., cities) to geodatabase and merge (5_merge_place_shapefiles.py)
- Join counties to places (6_join_counties_to_places.py)
- Create city, state composite address locator in ArcMap (7_create_city_address_locator)
Geocode addresses
- Export addresses from SQL server to ArcMap geodatabase (1_export_addresses.py)
- Geocode addresses at street level (2_geocode_street.py)
- Geocode addresses at city, state level (3_geocode_city_state.py)
- Import geocode results from ArcMap geodatabase to SQL server