On this page
01
What is geocoding, and why does it go wrong?
Geocoding is turning an address into a latitude and longitude, the point where a map puts the pin. A geocoder compares your text with its database of streets and address points and returns the best match it can find, along with how sure it is.
It goes wrong because the best match isn't always the right one. When the geocoder can't find the exact house, it falls back quietly, and each fallback puts the pin farther from the door:
| What it matched | Where the pin goes | How far off it can be |
|---|---|---|
| The exact address point | On or next to the building | A few yards |
| The street and a house-number range | An estimate along the block | Part of a block; more on long rural roads |
| Only the street name | Somewhere on that street | Up to the length of the street |
| Only the ZIP code or town | The middle of the ZIP or town | Several miles |
| The same street in another town | The wrong town entirely | Tens or hundreds of miles |
The second row, called interpolation, is how many suburban and rural addresses are placed. The map knows a stretch of road holds numbers 100 to 198 and guesses that 150 sits halfway along. Houses aren't spaced evenly, so the guess can be off by a long driveway or more.
02
What are the most common reasons an address won't geocode?
Almost every misplaced pin traces back to one of these. Most are fixed by editing the text; a few need the pin placed by hand.
| Cause | Example | Fix |
|---|---|---|
| Missing city, state or ZIP | 412 Main St | Add them: 412 Main St, Ames, IA 50010 |
| The same street name in many towns | 20 Maple Ave, NY | Add the town and the ZIP |
| ZIP code lost its leading zero | Brookline, MA 2446 | Store ZIPs as text: 02446 |
| A PO box | PO Box 118, Dover, VT | Ask for the physical address |
| A rural route box | RR 2 Box 40 | Ask for the 911 address on the mailbox |
| County road written differently | CR 12, Co Rd 12, County Road 12 | Add the town and ZIP; try the other spellings |
| Highway with several names | 4410 Hwy 9, 4410 State Route 9 | Try the name the post office uses |
| New construction | A house finished this year | Use coordinates or drag the pin |
| Unit in the wrong place | #4B 88 Pleasant St | Unit after the street: 88 Pleasant St Apt 4B |
| Typos and swapped digits | 1081 Elm St for 1801 | Check against the invoice or customer record |
Postal towns that aren't the real town
A ZIP code's mailing city is often a bigger neighbor. Plenty of homes have a mailing address in one town while sitting in another township or an unincorporated area. Geocoders usually know both names, but if a pin lands in an odd spot, try the other one.
PO boxes and rural routes
A PO box is a box at the post office, so it geocodes to the post office or to the middle of the ZIP code, and you can't drive a service call to it. Rural route boxes have mostly given way to street-style 911 addresses; if a customer still gives you one, ask for the address on their mailbox.
New builds and business parks
Map data lags behind construction. A house finished last spring may sit on a street the geocoder doesn't know yet, so it matches the nearest known road or the ZIP center. Business parks, hospitals and campuses share one address across many buildings, and the pin lands on one of them, often not the loading dock or the door you need.
03
How do you spot wrong pins before you drive?
Look at the map, not the list. A wrong pin is usually obvious once you can see all of them together, and invisible in a column of text.
The five-minute pin check
- Zoom out to the whole list. Any pin far from the others needs a look.
- Look for stacks. Several pins on exactly the same spot, in the middle of a town or ZIP code, are partial matches.
- Open the flagged ones first: anything marked uncertain, low-confidence or unmatched.
- Check every new customer. Old addresses have usually been driven before; new ones haven't.
- Zoom in on rural and commercial stops to make sure the pin is at the right driveway or building, not just the right road.
- Compare the address it found with yours. A different street name or ZIP in the match gives the problem away.
04
How do you fix a wrong pin in EZRoutePlanner?
EZRoutePlanner looks up every address when you paste a list or import a spreadsheet, and shows them all on a review map before anything is saved. Rows it isn't sure about are flagged at the top, so you fix the doubtful ones while you're looking at them, not on the road.
- 1
Search again
Edit the address, usually by adding the missing town or ZIP, and pick the right match from the suggestions as you type.
- 2
Type the coordinates
When a place has no reliable address, such as a new build, a farm gate or a job site, enter its latitude and longitude instead.
- 3
Drag the pin
Move the pin onto the right building or driveway. The nearest address is found for you, so the stop still has a readable address on the route.
05
How do you find the coordinates of a location?
Coordinates are the surest fix because they skip the address lookup entirely. In Google Maps on a computer, right-click the exact spot and the latitude and longitude appear at the top of the menu; click them to copy. On a phone, touch and hold the spot to drop a pin, and the coordinates appear with it.
42.33241, -71.12118- Latitude first, then longitude. Swapped, the pin lands somewhere else entirely.
- Keep the minus sign. Longitudes across the mainland US and Canada are negative; drop the minus and the point is on the other side of the world.
- Five decimal places is plenty. That's about a yard, more precise than any driveway needs.
06
How do you keep bad addresses out of your list?
Collect complete addresses at the source and keep them in one consistent shape. Every fix you make at intake is a wrong turn you don't make later.
- Separate fields on your booking form for street, unit, city, state and ZIP, so nothing gets left out.
- Store ZIP codes as text in your spreadsheet. How to combine address columns in Excel covers fixing the ones that already lost their zeros.
- Ask rural customers for the 911 address and a landmark, and note which driveway is theirs.
- Fix the spreadsheet too. When you correct an address on the map, update the source sheet so the next import starts right.
- Clean the list before importing. The address list cleaner catches duplicates and stray spaces in seconds.
For the whole process from spreadsheet to pins, see how to map addresses from Excel.