It has been a few days now with no response, so really I am bumping this.... but do you agree that thier seems to be a problem of major roads, parks, monuments, and what not being wrongly marked as populated place? or am I just crazy, or running a wrong query against the DB?
Your assumption that place names have to be unique is wrong. As for "Agua Caliente", you have just proven yourself that a place like this exists in the area of Tijuana.
If you read my entire posts with examples you would see "Agua Caliente" in tijuana... is not a populated place PPL it is a highway... yet the DB has it marked as a populated place... that is my point... the db is marking non populated places as a populated place...
Your db has the wrong feature codes and feature classes for many places... Look at the one example I showed you (of many I found)
geoname_id: 4019564
feature_code: PPL
feature_class: P
Tell me how a highway "Boulevard Agua Caliente" can be marked with those codes and be "correct"???
Looking at this example would you agree that your feature codes/classes are wrong?
If not does that mean all highways are marked with P and PPL?