So i have this table "places" here with a list of countries, states, and cities. The whole project is very user driven, but i cannot just save the users input into the database because each entry has to be in the same format (sf ~ s.f. ~ san fran ~ san francisco ~ sf bay area etc., same with long vs short state names) - thats why i run unknown place names trough the google geocoder first and then save the result in my db. however i still have issues geocooding places. my php side works so far, and the problem boils down to what i get back from google when i try to geocode a place. i had a look at the docs, but couldn't find a solution. here are some queries i send to google when #*$! hits the fan:
Cordoba, Argentinia is apparently unknown, and i only get one place in spain back:
and sometimes it just ignores the language parameter - after my batch finished i had 3 different netherlands and belgiums as countries in my database (english, local name and french). Has anyone experienced this problems before and knows how to resolve it?
Google map data is coming from many different sources. Some information is bought from mapping organizations, other information is user generated with their MapMaker project. If you zoom in on a map, you will see a copyright statement in the footer which is an indication what the main sources were to compile that part of the world map.
What you describe are probably conversion errors and inconsistencies in the data that Google has used. The only thing you can do is to correct the data manually in your own database, or wait until Google corrects the data. If the countries where the problems occur are included in the MapMaker project, you could signup there and make the corrections yourself, but that will still take a fair amount of time of checking and conversion before those changes will be visible in maps.google.com.