USL Geocoding Process
USL Geocoding Process
Purpose
Using Google Geocoding API and Bing Maps REST API services to get latitude and longitude coordinates for new or updated address of USL store(s).
Scope
A store that meets all requirements below will be pulled into the process.
- Store has not been geocoded.
- Store Status is Open or Other Custom Location.
- Country is USA or CANANA.
- City Name is not “anywhere”.
- Store Name is not “cluster”.
- Postal Code is not “00000”.
Process
- Store address that meets the requirements above is inserted into staging table stg.ToBeGoogleGeocoded.
- API script task sends address in stg.TobleGoogleGeocoded to Google Geocoding service to get latitude and longitude coordinates.
- Store address that is just geocoded with Google API having ROOFTOP location is saved into staging table stg.GeocodeResult.
- Store address that was geocoded with Google API having NON-ROOFTOP location type is inserted into staging table stg.ToBeBingGeocoded for Bing Maps geocoding.
- API script tasks sends address in stg.ToBeBingGeocoded to Bing Maps service to get latitude and longitude coordinates.
- Store address that was geocoded with Bing Maps having HIGH confidence is inserted into staging table stg.GeocodeResult.
- Update store addresses that are matched with stg.GeocodeResult for geocode method, status and latitude/longitude coordinate.
- Generate email notification for stores that are geocoded successfully or not.