Geocode Utility
Requirements, setup, details, and additional resources for the Geocode utility.
This utility geocodes addresses, and updates the Latitude, Longitude, and Last Geocode Attempt fields on the Address record.
Initial Setup and Requirements
ACS Technologies must install and enable this utility for you. Contact Support to request this.
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 are updated when you geocode an address: Latitude, Longitude, and Last GeoCode Attempt.
There is a database trigger on addresses. So, if you change Address Line 1, it will clear both the Geocoding values and Household Distance and Drive Time values.
- Latitude or Longitude is blank.
- Last GeoCode Attempt is blank or at least 30 days prior to today.
- Do Not Validate is set to No.
- Address Line 1 is not blank.
- City is not blank.
- Postal Code is not blank.