Skip to content

Batch geocoding

Every request needs an API key; see Authentication.

The product is POST /geocode/batch: up to 100 searches, one HTTP request, one billed call per non-blank query. There is a copy-paste example. A CSV is a file on your machine. unmap geocode csv is a client of that route. unmap does not store the file.

The API

POST /geocode/batch

The body is JSON. queries is required: 1 to 100 strings, order preserved. Shared search controls only (lang, limit, layers, focus, region, bbox). The response is an array aligned to queries. Index i is what GET /geocode/search would return for that string. Blank entries stay as [] and are not billed. More than 100 queries is a 413. Remaining allowance below the non-blank count refuses the whole request.

curl -X POST "https://api.unmap.dev/geocode/batch" \
  -H "Authorization: Bearer $UNMAP_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"queries":["17 Ave SW Calgary","Springfield"],"limit":1}'

geocoder.batch chunks a longer list at 100. A 100,000-row file is 1,000 client requests, not a Worker queue. The Geocoding API has the full contract.

A CSV on your machine

unmap geocode csv reads the file, POSTs the mapped column in chunks of 100, and writes a copy with ten new columns appended. Your file is never modified and never uploaded.

npx @unmap/cli geocode csv addresses.csv --query-column address --output geocoded.csv --review-output review.csv

Download a sample file to try it on. It is twenty synthetic rows covering the cases that are worth seeing: accents, a street with no civic number, a rural route, the same street name in two provinces, a blank row, and one address that cannot be resolved at all.

Only the column you map leaves the machine. The columns you did not map are never sent. Your API key comes from --key, the UNMAP_KEY environment variable, or unmap.config.json. It is never written to the output, the review file, the resume record, or any message the tool prints.

Count before you spend

--estimate validates the mapping and counts the rows without sending a single request.

npx @unmap/cli geocode csv addresses.csv --query-column address --estimate
20 rows, 19 with an address, 1 without.
1 requests if nothing retries; up to 4 if every request uses all 4 attempts.
Each request geocodes up to 100 addresses. Every successful address is one billed call. Retries are billed.
Remaining allowance: unknown from the CLI. Check the dashboard at unmap.dev/dashboard/usage.

Two numbers, not one. Requests are POSTs of up to 100 addresses. Each successful address is one call against your plan. A retried request is billed again, the same as retrying GET /geocode/search. A row with no address is zero. The estimate reports the floor and the ceiling and says which is which.

--sample 100 runs only the first hundred rows with an address, then stops and checkpoints. It does send requests, and they are billed. Re-run with --resume and no --sample to finish.

The columns it adds

Ten columns, all prefixed unmap_, appended after your own. If your file already has a column by one of these names it is suffixed (unmap_status_2) rather than overwritten, and the tool says so.

ColumnMeaning
unmap_statusmatched, review, no_match, invalid, failed, or unprocessed
unmap_idStable id of the matched record
unmap_nameThe label the geocoder resolved
unmap_lng, unmap_latCoordinates, WGS84
unmap_layeraddress, street, locality, region, or poi
unmap_sourceWhich dataset the record came from
unmap_match_typeexact, partial, fallback, or unknown
unmap_precisionpoint, street, locality, region, or unknown
unmap_reviewWhy the row needs a look, when it does

unmap_status and unmap_match_type answer different questions, and the pairing worth watching for is matched with fallback. That means an answer came back and it is coarser than the row asked for: you gave a civic number and got the street. See result metadata.

The review file

--review-output writes a second CSV holding only the rows worth looking at: fallbacks, partial matches, near-ties between the top two candidates, rows with no match, and rows that failed. It is a subset of the main output, in the same format, with the same columns.

Every input row appears exactly once in the main output no matter what happened to it. Nothing is dropped quietly, which is the point of having a status column at all.

Interrupt it

Press Ctrl-C and the run stops after the requests already in flight, then writes a resume record next to the output. Run the same command again with --resume and it continues from the last row it durably wrote.

npx @unmap/cli geocode csv addresses.csv --query-column address --output geocoded.csv --resume

The resume is refused if the input file or the mapping has changed, because row numbers would no longer line up and half the file would have been geocoded a different way. Changing the pace (--rate, --concurrency, --max-attempts) is fine: those change how hard the tool tries, not what any row resolves to.

One thing resume cannot do: a request that was in flight when the process died may already have been served, and it will be sent again. Nothing on your machine can know which, so a resumed run can bill a small number of rows twice.

Pace

FlagDefaultWhat it bounds
--rate10/secondHow fast requests are sent, averaged
--concurrency4How many are in flight at once
--max-attempts4Attempts per request, including the first

Rate and concurrency bound different things and are set separately. The defaults are deliberately well under the per-key burst limit, because a batch run shares your account's allowance with whatever you are serving to real users. See plans and limits.

Retries are only for failures that could succeed later: a rate limit, a timeout, a 5xx. A malformed request is never retried. A bad key stops the whole run immediately and marks no address as bad, because the address was not the problem. An exhausted quota or spend cap also stops the run rather than retrying into it; re-run with --resume once it lifts.

Spreadsheets

--spreadsheet-safe prefixes a tab onto any value that Excel, Sheets or LibreOffice would evaluate as a formula, so a cell beginning =, +, - or @ displays as text. It is off by default because it changes the bytes, and a pipeline reading the file programmatically wants the original value.

What it does not do

  • It geocodes free text. Column mapping for separate address, city and province fields uses structured search and is not wired into the CLI yet.
  • It does not validate deliverability. A postal code in a row is compared against whatever the matched record carries; unmap does not know whether an address receives mail.
  • Canada only.

Not a job API

There is no POST /jobs today, and POST /geocode/batch is not one. The request answers in the same HTTP call. unmap does not hold your file, does not keep a queue running after you close the tab, and does not take a webhook.

A generic job API is later work, and it will be async: POST /jobs returns 202 and a job id; the client polls GET /jobs/:id and reads the result only when the job has succeeded. The create request does not wait for the work. The trigger is the first product that cannot finish in one request: a large routing matrix, many truck routes, anything past a Worker or container budget. That API will be a new prefix and new tables, not an extension of hosted CSV. Geocoding does not get a job handler in that first cut. Do not build it to make a spreadsheet faster.

Next steps