The purpose of this project is to take addresses provided from an inconsistent and potentially unreliable source and convert the addresses into their LAT / LONG coordinates, as well as to look up and verify the address.
The success criteria of this project are if the Developer produces a solution that will automatically access, parse, geocode, reverse geocode, and store responses (API responses: Verified Address, LAT / LONG coordinates, error/exception XML) within a Microsoft SQL Server database.
The Developer has access to their own development environment, with a Microsoft SQL Server database that contains sample unparsed and unverified United States Addresses. *Note: A single-column list can be provided for development and testing purposes if the Developer does not have their own raw addresses.
The Developer has their own API Token to develop with, but the Client will use and manage their own API Token after the solution is delivered.
SQL Server, Google Geocoding API