Tuesday, May 04, 2010

Batch Geocoding with Google Maps

BatchGeo

BatchGeo is a batch geocoding service that allows you to get the latitude and longitudes of addresses held in a spreadsheet.

Batchgeo includes a spreadsheet template so that you can just import your data into the template and then copy and paste it into the BatchGeo geocoder. Once you press 'Map Now' the addresses will be mapped onto Google Maps and you can export the results via kml or copy and past the geocoded results back into your spreadsheet.

BatchGeo will even host your created Google Map for you. If you click the "Save / Print / Share" button you will be sent to the web page where your map is hosted. You can then just copy the URL and post a link to it on your web site.

Aus-emaps Bulk Address Geocoding
This bulk address geocoding tool uses Google Maps' geocoding engine to find the latitude and longitude coordinates from a list of addresses.

This service geocodes your addresses one at a time and requires you to save each geocoded result individually. This means that using this service will be a little slower that BatchGeo but does mean that you can validate that each result is geocoded correctly. If you don't like the positional accuracy of a result you can just drag the map marker to the correct position.

________________

4 comments:

  1. You can also use the no-frills Google hosted geocoder. I use it a few times a week for my projects.
    http://gmaps-samples.googlecode.com/svn/trunk/spreadsheetsgeocoder/geocodespreadsheet.htm

    ReplyDelete
  2. There's another one which does the geocoding and also has some good Google Earth mapping enhancements at www.totallyawesomemapping.com. I use it a lot for customer geocoding and mapping with distance calculations for some pretty robust analysis. One of the most valuable analytical tools I use. Definitely worth looking into.

    ReplyDelete
  3. You can also use a new tool to do complex data analysis on maps and share your maps with http://www.easymapmaker.com

    ReplyDelete
  4. Anonymous7:45 PM

    You can also use SVB Mapper downloadable at mapper.svbgroup.com.au works very well with Excel and Bing Maps,very easy to use you can run a bit of analysis on it as well. I think it is $100 per year but my friend got it for free because he shared his case study with them.

    ReplyDelete