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:
however, if i go the other way around and try to resolve the proper geo-coords for cordoba, it suddenly knows the town:
Some towns/cities in my batch came back without a state or region:
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?