Latest posts for the topic "Getting cities for India"

Getting cities for India

samuele.mattiuzzo — GMT

Hi all, i'm trying to cross postal_codes database with the india database, to get all the main cities (feature code PPL% and population > 1000 inhabitants, sorted by population desc) but i can't seem to get it right. In the india database all i can see is a lot of specific places (shops, public places etc) but i can't find any city. I have no knowledge about India's hierarchy, but i need it for a task at work. Can somebody help me out? I just need city names with maybe admin2 and admin1 names and hierarchy, thanks!

Re:Getting cities for India

marc — GMT

There are hardly any shops in the database, so I don't know what you are referring to. Cities have the featureClass P. Best Marc

Re:Getting cities for India

samuele.mattiuzzo — GMT

Sorry i don't know indian places :) Anyway, what i was just saying is that i can't seem to find a correspondence between the geoname table and the postal_code table, for india's values. I'm using a join query between those two tables, and for both US and UK i can find a match between "asciiname" (geoname table) and "place_name" (postal_code table), but for india it doesn't work. I have to match "asciiname" with "admin_name2" (postal_code table) to get the results. I don't need all the pleaces with a "P" feature code, but places with feature code like "PPL", to go as deep as city in the hierarchy (to achieve this, i also use an arbitrary population filtering, >=2500). As far as i understand the records for india, fcode "PPL" contains also hospitals and things like that, right?