What would you like to know more about?

Geocode Utility

Requirements, setup, details, and additional resources for the Geocode utility.

Note: CloudServices is required to leverage this functionality. Contact Support to get started.

This utility geocodes Addresses, which updates these fields: Latitude, Longitude, and Last Geocode Attempt.

Initial Setup and Requirements

You must have an existing Bing API Key.
Attention: Microsoft is retiring Bing Maps and will no longer accept new Bing Maps for Enterprise customers. For more information, see this topic.

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 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

See Also