Geocode Utility
Requirements, setup, details, and additional resources for the Geocode utility.
This utility geocodes Addresses, which updates these fields: Latitude, Longitude, and Last Geocode Attempt.
Initial Setup and Requirements
ACS Technologies must install and enable this Utility for you. Contact Support to request this.
You must configure a Bing API.
Details
The routine automatically runs overnight and calculates values for 5,000 records. It may take some time to geocode all addresses in your database.
You can send a request to Support to manually run the Utility for more records. There is a 20,000 daily limit.
The following fields update when you geocode an Address:
- Latitude
- Longitude
- Last_GeoCode_Attempt
There is a database trigger on Addresses, so if you change an Address_Line_1 field, the Geocoding values clear. The Household Distance and Drive Time values also clear.
CloudServices attempts to geocode an address if ALL of the following conditions are met:
- Latitude or Longitude is blank
- Last_GeoCode_Attempt is greater than 30 days
- Do_Not_Validate is set to No/False