Blog

Browse Geocoding Tutorials, Guides & Updates

Mapping served populations for grant reporting without retaining PII

Mapping served populations for grant reporting without retaining PII
Grant reporting lives in an awkward middle ground. The programme officer filing the impact report knows which county served the most clients. The compliance officer knows that a CSV of client home addresses is PII that should never sit in a reporting database. The database administrator knows that "we geocoded everything into a spreadsheet" is not a data architecture. And the funder wants a map. T...

Deduplicating a messy CRM with geocoding and stable keys

Deduplicating a messy CRM with geocoding and stable keys
Every CRM over two years old has the same problem. Marketing imports a list from a trade show. Sales manually enters leads from a conference. A SaaS integration pushes records from a web form. Operations runs a bulk upload from the old system. Four months later, an account manager is on the phone with a prospect and discovers there are six records in the CRM, all for the same office building, each...

Adding transit and airport proximity to travel listings at scale

Adding transit and airport proximity to travel listings at scale
Every OTA listing page in existence says something like "conveniently located near public transport" or "minutes from the airport." It is marketing copy. The guest has no idea what "near" means — 400 m or 4 km — and the listing team has no idea either, because nobody ever measured it. The proximity claim lives in the description text, not in a structured field, so it cannot be filtered, ranked, or...

Which jurisdiction is this address in? Permitting and zoning lookups

Which jurisdiction is this address in? Permitting and zoning lookups
A contractor submits a permit application to the wrong county office. The address read like it was in the city limits — same postal code, same city name in the mailing address — but the parcel sat in an unincorporated area governed by the county, not the municipality. The city's permit desk rejected it after two weeks of silence. The county desk took another week to process the resubmission. Three...

Finding comparable properties within a radius — geocode, then filter

Finding comparable properties within a radius — geocode, then filter
Every residential appraisal hinges on the same mechanical problem: find recent sales that are close enough to the subject property to count as evidence, and far enough from each other to provide a representative spread. The guidance is usually "within a one-mile radius for urban markets, two miles for suburban, broader for rural" — and that guidance is worth exactly nothing unless you can actually...

Building a nearest charger lookup for EV fleets

Building a nearest charger lookup for EV fleets
Straight-line distance from vehicle to charger is a comfortable lie. A depot that looks 800 m away on a crow-flies calculation might be 4 km of one-way streets, a rail crossing, and a no-left-turn. A charger that shows up as the second-closest pin on a map might actually be the fastest stop on a Tuesday afternoon when the nearest one is behind a school-zone queue. Fleet operators who dispatch on s...

Standardising civic addresses for emergency dispatch

Standardising civic addresses for emergency dispatch
A 911 call comes in. The caller gives an address. A call-taker types it into the CAD system. The CAD system looks it up. If that address record is misspelled, structurally malformed, or missing coordinates, the nearest unit gets routed to the wrong parcel — or nowhere at all. The call-taker improvises. Time passes. Emergency dispatch is the sharpest edge of address-data quality. Every other indust...

Geocoding rural addresses that break normal parsers

Geocoding rural addresses that break normal parsers
Rural addresses are a different problem from urban addresses. Not harder in a hand-wavy sense — harder in specific, well-documented ways that cause geocoders to return either a wrong confident answer or a polite failure that looks like a network error to the code calling it. If your ag-tech pipeline ingests field locations, farm delivery stops, irrigation district boundaries, or land-parcel data f...

Trade area isochrones for new store screening at scale

Trade area isochrones for new store screening at scale
Site selection is one of the more expensive decisions a retail business makes. A bad site choice is not obviously wrong on day one — it shows up two years later in a lease you cannot exit, a store that does the same revenue as the one you opened ten kilometres away for a third of the rent. The canonical defence is a trade area analysis: define a polygon around each candidate site that represents "...

Mapping health data to boundaries without storing PII

Mapping health data to boundaries without storing PII
Epidemiologists need case counts at the postcode, census tract, or health district level. They do not need the patient's home address sitting in a reporting database three years after the case was closed. The problem is that most pipelines are built backwards: they store the full address first, attach the boundary code as a derived field, and rely on a scheduled deletion job that either never gets...