I've been approached by our company's wastewater division to create geocoded data from an Excel spreadsheet. Normally, this would be easy, but the spreadsheet contains a list of subdivision names and lot numbers where step tanks have been installed. There are no addresses, latitude, or longitude information available in the spreadsheet for these tanks. Is there a way to create a custom geolocator based upon subdivision name and lot number? I do have access to our local county's planning department data for subdivision polygons and parcels.
Any thoughts and suggestions are appreciated as I am drawing a blank on how to process this data request.
Bethany G. Hall