Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a list of 100 companies that I want to geocode. I have all of their addresses but none of their lon/lat coordinates.

I have three columns related to location:

  1. Address
  2. Longitude
  3. Latitude

Is it possible that when file->geocode is clicked (relating to the address column) that it fills in the longitude and latitude columns with the coordinates? I can then read these columns from there on in avoiding the need to geocode again.


On further research it's seems I have to store the geocoded result in a database... not fusion tables as it doesn't seem possible with how I want it to work.

share|improve this question
up vote 2 down vote accepted

Edit: That's not possible with google because you are not allowed by the license to store the geocoding results ( (see comments)

One alternative option is to use the CloudMade Geocoding based on OpenStreetMap data. It has a Python API that you can use to get the coordinates, than you can easily output a simple delimited text file to be imported into fusion tables.

share|improve this answer
Thanks. As far as I can see it doesn't say anything about storing them, just that the geocoded results need to be used with a Google Map, which it will be. Since asking the question it becoming more and more obvious that a fusion table is the right way to go. – Rob Nov 4 '11 at 13:47
Rob, I'm sorry for my mistake, after a better reading of the license I found this: "Geocoding is a time and resource intensive task. Whenever possible, pre-geocode known addresses..and store your results in a temporary cache". – Pablo Nov 4 '11 at 14:00
Great, it's good to know as it points out it's possible. Just need to find out how to do it! – Rob Nov 4 '11 at 14:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.