Batch Geocoding
To convert addresses or locations into latitude-longitude coordinate pairs:
- Go get an API key from Google. You'll need to enter a payment method, though if you stay under their limits you won't have to pay.
- Enter your Google Cloud API into the Google API Key field.
- Enter your addresses/locations in the input field, one address per line, up to a few hundred addresses.
- Select the desired outputs via the checkboxes in the "Output Fields" box.
- Choose whether or not to include failed geocodes in your output via the checkbox in the "Settings" box.
- Likewise, choose whether or not you want a header row of field labels at the top of your output in the same box.
- Select a field delimiter (separates the output fields) for your output in the same box.
- Click the "geocode" button to begin geocoding.
- Your results will be displayed incrementally in the "output" field. The "Results" box will display the total number of addresses processed, the time it took to process them and the results of the processing.
- When processing is complete you can copy the results from the output field or click the
button to save output to a csv/tsv/text file.
Output Settings
output type - select basic fields if you only wish to select from a few fields, select all fields if you wish access to all available fields. Select full raw json to receive Google's full response in JSON format, select full raw xml for the same in XML format.
output fields - if you selected either of the fields options from output type you can select which fields you wish to output.
include fails - include records for which we are unable to find a result in the output.
If you selected "fields" from the output type you'll have an output fields dropdown containing the following fields:
address in - this is the address or location you entered in the input field.
address out - the closest matching location in the geocode database.
latitude - output latitude.
longitude - output longitude.
accuracy - numerical representation of geocode accuracy (see key below).
status - geocode result code (see key below).
For "fields" you'll also have these selections:
field delimiter - select the delimiter (comma, pipe or tab) used to separate record fields in the output. (Selecting comma as the delimiter will cause the address fields to be double quote enclosed.)
coordinate format - select the latitude-longitude format used (degrees decimal, degrees minutes decimal or degrees minutes seconds decimal).
include header - include a header row in the output.
multiple results per record - return all results available for each record queried. It's strongly recommended that you include your input record in the output when using this option.
Select the checkboxes of the items you wish to be included in the output.
Accuracy
9 - rooftop
8 - address range
5 - city/municipality
3 - region
0 - fail
Status
200 - okay
602 - unknown address
610 - invalid address
620 - over query limit
Results
Time - elapsed time of the latest geocoding run.
# - total number of records processed during the latest geocoding run.
The remaining fields display the number of records of each result type listed below.
Accuracy
9 - address (rooftop)
8 - street (address range)
5 - locality (city/municipality)
3 - general (region)
0 - fail