Batch Geocoder

When a batch geocoder beats one-by-one search

Operations teams, researchers, and marketers often start with a spreadsheet column of addresses — store lists, survey sites, customer records. Looking each one up by hand is slow and error-prone. A batch geocoder walks the list, returns coordinates (or addresses), and leaves you with a CSV you can join back to the original sheet.

MapBench runs the work in your browser against open geocoders. That means no account, no API key on your side, and no copy of the list on our servers. The trade-off is politeness: we cap each run and space requests so free community services are not overwhelmed.

Matches are only as good as the input and the map database. Ambiguous names, missing city or country, and brand-new streets can fail or land on the wrong pin. Spot-check a sample on the map before you push thousands of rows into production routing or print.

For a single address, the Address to Coordinates tool is faster. For plotting an already-geocoded CSV, use CSV to Map. Use this batch tool when the bottleneck is turning text into coordinates at moderate volume.

Worked examples

• Indoor vs outdoor GPS — a phone under open sky reports ±5–15 m and resolves to the correct street segment; indoors the network fix can be ±300 m, enough to flip counties near a border — nudge the pin when it matters.
• Postal vs administrative — a point in an unincorporated US area can honestly answer 'no city' administratively while carrying a mailing city; the fields stay separate here so both truths are visible.
• Five decimals — (40.71280) is ≈ 1 m — the right precision to store; the sixth decimal is beyond consumer GPS and the seventh is theatre.

Understanding location lookups: how a map knows where you are

Every location question — what county, what city, which ZIP, which country — is answered in two stages. First, a position: your device fuses GPS satellites, Wi-Fi fingerprints and cell-tower timing into a latitude/longitude with an accuracy that ranges from a few metres outdoors to a city block indoors. Second, a translation: that raw pair of angles is matched against boundary and address data to produce human labels. The labels are only as good as the underlying map, which is why these tools draw on OpenStreetMap's community-maintained boundaries — administrative relations that follow legal lines rather than postal habits.

It is worth knowing where each answer level comes from, because they disagree in interesting ways. Your mailing city follows postal routes; your legal city follows municipal boundaries; your county follows a third geometry; and your timezone follows a fourth, political one. A point near a border can honestly belong to different answers depending on the question. Good tools keep those layers separate and show them side by side, which is exactly the layout used here: place, county, state, postcode and country each in their own field, each copyable on its own.

Privacy deserves the same care as accuracy. Browser geolocation shares your position with the open page only, and reverse geocoding sends that coordinate to a public service that answers and forgets. Nothing needs to be stored for any of this to work — a design principle you can verify in your browser's network tab, where the only outgoing request carries exactly one coordinate pair.

Tips & common mistakes

Prefer clicking the map over typing when you can: a placed pin is unambiguous, while a mistyped address can silently resolve to the wrong Springfield. When you must type, include the country for common town names and drop apartment numbers if the street fails — geocoders match best on street + city.

Treat postal and administrative answers as different datasets. A 'wrong' city result is frequently a correct administrative answer disagreeing with a postal habit. If a form demands the mailing version, your postal service is authoritative; if it demands legal boundaries, the administrative layer is.

Check accuracy before trusting a GPS-derived answer: indoors, browser positioning can be off by blocks, which flips counties near borders. Zoom the map and nudge the pin by hand when the stakes are real — the tools here let every GPS result be corrected with a click.

A field guide to trustworthy place answers

The difference between a playful lookup and a dependable one is verification habit. Professionals never accept a single source for a place fact: they triangulate. Click-placed pins beat typed addresses for ambiguity; the administrative layer beats the postal layer for legal questions; and a visible map beat both for catching the absurd. When a tool shows county, city, state, postcode and country side by side, cross-read them — an internally inconsistent row (a county that doesn't contain that city) is the signal to slow down and inspect the point itself.

Equally important is knowing the failure signatures. Geocoders fail politely (no result) or dangerously (a confident wrong town with a common name). Reverse geocoders near borders can flip between neighbours as you drag a pin by metres — that flicker is information, telling you the point sits on a contested edge. Indoor GPS drift shows up as a pin that 'feels' a block off; nudge it. None of these are reasons to distrust the stack; they are reasons to keep the human in the loop, which is exactly what an interactive map is for.

How professionals use this

• Log coordinates at six decimals internally, but display five — the sixth is beyond consumer GPS and implies false rigour.
• When automating checks, flag any reverse-geocode whose county/state pair is internally inconsistent for human review.
• For border-adjacent properties, capture the pin's accuracy radius alongside the answer; it is part of the truth.
• Prefer administrative boundaries for anything legal or tax-related; postal geography is optimised for mail, not law.

Step-by-step masterclass

1. 1. Place the point deliberately — Click the exact rooftop or intersection on a zoomed map instead of trusting a typed query; ambiguity is the largest error source in location answers, and a placed pin removes it entirely.
2. 2. Read all layers at once — County, city, state, postcode and country should form a coherent row; internal inconsistency (a county that doesn't contain that city) is the cue to zoom in and re-place the point.
3. 3. Check the accuracy context — Indoor GPS can drift hundreds of metres; if the answer matters and the point sits near a boundary, drag the pin to the verified spot before copying anything.
4. 4. Copy the exact field you need — Forms want one layer each — legal city, mailing postcode, sovereign country with ISO code. Copying the whole address into a county field is how dirty data spreads.
5. 5. Share the state, not a screenshot — The URL carries your coordinates; a colleague reopening it sees the identical point and can re-verify every layer independently — reproducible beats pretty.

Coverage notes: administrative answers are strongest wherever OpenStreetMap's community is active — effectively all inhabited countries — while US-specific layers (congressional and school districts) come from the Census Bureau and stop at the border. Postal coverage is dense in the US, much of Europe, Canada and Australia, thinner elsewhere; the tools say 'no data' rather than guess, and that silence is itself useful information.

Related questions people ask

Quick glossary

Reverse geocoding

Translating coordinates into the nearest human-readable address or administrative area.

Administrative boundary

The legally defined polygon for a country, state, county or municipality.

Postal vs administrative city

Mailing city follows postal routes; legal city follows municipal boundaries — they can differ.

Accuracy radius

The device-reported uncertainty of a GPS/network position, in metres.

ISO country code

The two-letter sovereign identifier (US, DE, JP) used by shipping and software.

Exclave / enclave

Territory separated from or surrounded by other administrations — where naive lookups fail and boundary data earns its keep.

Honest limits & when to escalate

Every location stack has a competence boundary, and naming it is part of being trustworthy. OpenStreetMap's administrative coverage is excellent where mappers are active and thinner in rapidly changing or sparsely mapped regions; brand-new developments can lag, and disputed zones follow the community's de-facto consensus rather than arbitrating sovereignty. Postal layers add a second boundary: ZIPs and postcodes are delivery-routing systems, not geography, so PO boxes and carrier routes can legitimately disagree with the map. Indoor positioning adds a third: a browser fix can be a block off, which matters precisely at the borders where people ask these questions.

None of this makes the tools unsafe to use; it makes them safe to use *knowingly*. The design response is transparency: fields stay separate so layers never blur, empty answers are shown as empty rather than guessed, accuracy context travels with GPS results, and every page names its sources. For questions where the cost of being wrong is high — a property line, a legal filing, a medical dispatch — the escalation is always the same: licensed surveys, official registers and emergency services own those answers, and a good free tool points at the door instead of pretending to be it.

• Legal boundaries and property lines → licensed surveyor / county recorder.
• Mailing validity → the postal service's own address tools.
• Life-safety dispatch → official emergency services, never a map lookup.
• Bulk or production geocoding → your own Nominatim/Photon instance.

Data & methodology note

Forward: Photon (Komoot) OpenStreetMap search, first hit per line. Reverse: Nominatim reverse API. Sequential requests with ~1s delay. Positions are resolved with OpenStreetMap Nominatim/Photon (ODbL) and, for US districts, the Census Bureau geocoder. Nothing is stored server-side; the only outgoing request per lookup carries the coordinate pair itself.

Category: Location — County, city, state, ZIP, country and addresses. This page is part of MapBench's location tools. Related tools below and the Tools menu link every sibling instrument.

Continue with related tools

• Address to Coordinates — Geocode any address to latitude and longitude.
• Coordinates to Address — Convert lat/long into a readable address.
• Address Validator — Check and normalise an address against open geocoding data.
• CSV to Map — Plot latitude/longitude rows from a CSV on the map.