Geocoding locations

Geocoding locations

The QB Maps extension uses Google Maps Platform's Geocoding API. After data is retrieved from the Quickbase table, if the longitude and latitude fields are empty or have a value of 0, the extension constructs a URL encoded address string using the information retrieved from the table. This string is then used to geocode the location (get the latitude and longitude corresponding to the address) by calling the Geocoding API. After successfully geocoding the location, the extension uses the returned longitude and latitude values and updates the appropriate field in the table, which reduces the number of Geocoding API calls made when running the extension again. If the address for a record is invalid or can't be geocoded, the extension updates the longitude and latitude values for that record with the value "NA". If you want to update the address, use a pipeline to clear the corresponding "NA" values so the extension knows to geocode the locations again.