Geocoding multiple addresses

 

This site allows geocoding of multiple street addresses. You can download a spreadsheet template, enter your addresses, then copy and paste the data into the batchgeocode website above. The addresses are geocoded, converted to latitude and longitude, and then saved as a Google Earth kml file. From there POIedit can be used to generate a gpx file which can then be uploaded to your GPS via POI uploader. It sounds a lot more complicated than it really is. This is going to be handy for me because I have a list of addresses that I have to visit. Now I can convert them to POIs and use my Streetpilot to navigate to each one.

Frequently Asked Questions

--
Garmin Emap, Garmin C340, Garmin Nuvi650

I love that site. It

I love that site. It totally rocks and makes the process so much easier.

Be careful with the data

If the address has enough information to determine a location, it will spit out the lon/lat. One thing I have experienced is that the street address was not identifiable by the engine, however it used the zipcode and gave the location as the center of the zip code.
One of the techniques I use is to provide the address with the zip code and no city, state and then do the same thing with the city,state and without the zipcode. By comparing the two, if there is a difference, then I am alerted to a problem with the location.

--
Garmin StreetPilot c530, Mapsource

rbrown, I see that you have

rbrown, I see that you have MS Streets and Trips. My uncle gave me a copy of it and I was wondering if you can get lat and long coordinates with it?

--
Charley - Nuvi 350 - Bel STI Driver - Cobra 29 w/ wilson 1000 - AIM: asianfire -

Tools/Location Sensor will

Tools/Location Sensor will turn on a little box that displays the lat/long for whatever you are pointing at. That's all it can do in regards to lat/long.

I think taht will be good

I think taht will be good enough, thanks

--
Charley - Nuvi 350 - Bel STI Driver - Cobra 29 w/ wilson 1000 - AIM: asianfire -

GPSpassion.com

asianfire wrote:

rbrown, I see that you have MS Streets and Trips. My uncle gave me a copy of it and I was wondering if you can get lat and long coordinates with it?

Since I got my C340 I have not used S & T very much but I am pretty sure you probably can. You can go to this forum and someone will be able to help you.
The site is called GPSpassion and the link above is to the S & T forum.

--
Garmin Emap, Garmin C340, Garmin Nuvi650

We are having some work done

We are having some work done on our home. The contractor gave me a list of 42 sites where he has done work. After thinking about it a bit I thought it would be easy to geocode the addresses and use the Geocoding site to convert them to lat longs. It worked perfectly and I used POIedit to convert the kml to a gpx and it is in my C340 now. It works great and really makes it easy to travel to all of the sites without fussing with maps and a list of addresses. I had to run an errand this morning and during the process I was able to visit about 8 of the sites because as I ran my errand I had a running course and distance to the sites. I just picked some closest to my route and made a small deviation. I LOVE this stuff.

--
Garmin Emap, Garmin C340, Garmin Nuvi650

Is there an advantage to the .gpx file?

rbrown3rd wrote:

You can download a spreadsheet template, enter your addresses, then copy and paste the data into the batchgeocode website above. The addresses are geocoded, converted to latitude and longitude, and then saved as a Google Earth kml file. From there POIedit can be used to generate a gpx file which can then be uploaded to your GPS via POI uploader. It sounds a lot more complicated than it really is.

When I use this site, I have just selected and copied the results back into the excel file. From there I have another worksheet that rearrange the data back into the proper order for a .csv file. I will try the your method to see if it is any faster.

Update: Is there a way that you get the 4th column data such as the full address when you use POI Edit. It tried it with the template and it only gave me the long/lat/name. When I use Excel, I create 4 columns with all of the data. I know the .gpx file will hold even more information, so it is probably a deficiency in my knowledge of using POI Edit 2007.

--
Garmin StreetPilot c530, Mapsource