Geocode Utility
Requirements, setup, details, and additional resources for the Geocode utility.
Initial Setup and Requirements
ACS Technologies must install and enable this Utility for you. Contact Support to request this.
A Bing API key must be configured.
Details
The routine will run automatically overnight and calculate values for 5,000 records. This means it may take some time before all addresses in your database are geocoded.
The Utility can be run manually for more records by sending a request to support. There is a 20,000 daily limit.
The following fields are updated when an Address is geocoded:
- Latitude
- Longitude
- Last_GeoCode_Attempt
There is a database trigger on Addresses, so if an Address_Line_1 is changed, the Geocoding values are cleared. The Household Distance and Drive Time values are also cleared.
An attempt to geocode an address is made if ALL of the following conditions are met:
- Latitude or Longitude is blank
- Last_GeoCode_Attempt > 30 days
- Do_Not_Validate is set to No/False