Our “Geocode and Sort by

Geocoding addresses in Excel

Geocoding is the process of turning an address, city, state, zip or postcode into mappable coordinates.

Batch geocoding using our service is as easy as pasting in a list of location. BatchGeo uses the Google Maps Geocoding API, known to have some of the highest quality data available. Other services require you to write code or manually geocode addresses one by one, but our service performs everything you need to do in a few easy steps.

How does Geocoding work?

First the street is found by matching the street name, direction and street type against a block range in the street center line database. The point is set a certain distance from the street center line, after all the building is not likely to be in the middle of the block. However there is no good way to know just how far back from the center of the street the building is, so it’s guessed. Usually this is a global value set when the geocoder is configured. Generally you would pick around 50 feet from the address block. There is no way to know for sure how far back the building or building entrance is located, but 50′ is usually close.

The final step (and least accurate) in the geocoding process is to try to approximate a location along the block using the address number. Reason being is the address range on your average block face is a nice big range like 1000-2000, or 100-200. However on average there only exists a dozen or less properties on a block. The geocoder does not actually know how many properties are located on the block, the centerline data does not indicate this. In fact it’s not even sure if the address is really there or not. You can test this yourself by going to our single address lookup tool and entering an address number on your block that doesn’t exist.

The geocoder’s best guess about where the address might be located on the block is done by taking the street number calcing it’s position along the centerline using the block range. Example: If the range was 100-200, and the address number was 150, the geocoder would place the point halfway along the block range. Again, this is a guess at best. If the geocoder manages to place the point right on top of the address it is just getting lucky!

Other things can help the accuracy, like setting an offset from the start of the block range (similar to the offset from the center line.) The geocoder does know which end of the street to start the calculation from (for example does the 100 address start on the north end or south end, east or west.) But for the most part, geocoding is not that accurate when looking at precision beyond the block range.

You might also like
How to use the AddressDoctor Excel Plugin
How to use the AddressDoctor Excel Plugin
LocateXL: Quick Geocoder in Excel
LocateXL: Quick Geocoder in Excel

Help with geocoding

by aoompaloompa

Morning-I'm trying to plot a list of addresses on a map using yahoo's service for that. Problem is, the data requires it being in a specific form according to an excel template they've provided as an example.
Now i'd like to know ;
1. General advice on the proccess
2. A way for excel to 'intelligently' break up data into corresponding cells
The problem is my data looks like this:
B & B Real Estate
7525 Auburn Boulevard
Citrus Heights, CA 95610-2239
And needs to look like this: (| being cell lines)
1600 Pennsylvania Avenue NW | Washington | DC | 20500 |The White House

Vintage History 1871 Map of Brazil, Bolivia, Paraguay, Uruguay & Chili of Brazil, Bolivia, Parag
Home (Vintage History)
  • 1871 Map of Brazil, Bolivia, Paraguay, and Uruguay ; Map of Chili. Scale ca. 1:10,, (W 74, W 69/S 24, S 42). Relief shown by hachures. Scale ca. 1:20,, (W 73, W...
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction

7 Game of Thrones Apps That Will Get You Through the Much-awaited Winter  — Gizmodo India
.. or Winterfell, you get a dialog box, which asks you to buy more maps. Unfortunately, you can't dismiss the dialogue box, leading to the obstruction of the cartography. ..

Flagstaff's rocky lava field became a little piece of the moon  — azcentral
If American know-how could put a man on the moon, the man should bring back rocks to study. The government agreed, and in 1963, the .. Volcanoes were chosen because of the moon's volcanic history, the test site for its impact craters.

Vintage History 1864 Civil War Map Petersburg shows Federal forces of the environs of Petersburg
Home (Vintage History)
  • 1864 Map of the environs of Petersburg from the Appomattox River to the Jerusalem Plank Road showing entrenchments occupied by Federal forces / Engineer Department...
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction

Missing in Alaska without a trace  — Anchorage Daily News
The official version of events, according to a still active missing person's bulletin from the Alaska State Troopers is that Griffis went into the wild "to test out a survival 'cocoon' that he had invented.

Vintage History 1895 Map of Knox County, Tennessee
Home (Vintage History)
  • 1895 Map of Knox County, Tennessee
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction
Vintage History 1746 map of Camarones Bay, Argentina, showing Camarones Bay and adjoining capes,
Home (Vintage History)
  • 1746 Map showing Camarones Bay and adjoining capes, Argentina. Oriented with north to the right.
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction
Lowrance Lowrance Elite-7 Gold CHIRP Fishfinder/Chartplotter with 83/200 KHz and 455/800 KHz Transducer and Navionics Cartography
GPS or Navigation System (Lowrance)
  • 7 Widescreen LCD
  • Includes Navionics Gold Cartography
  • Broadband CHIRP and Hi-Def. Down Imaging Sonar
  • Includes 83/200+455/800KHz transom mount transducer
  • Built-in GPS
Related Posts