I haven’t found an open or reliable database providing the geo-location of Indian PIN codes. That’s a bother if you’re creating geographic mash-ups. The closest were commercial sources:
a PIN code directory from the Postal Training Centre for Rs. 2,000, which probably just contains a list of PIN codes, and
a PIN code map from MapMyIndia for Rs. 1,00,000, whose quality I’m not sure of. (I spoke to one of their sales representatives who mentioned that the data was gathered via companies such as Coca Cola, using their local distribution knowledge, perhaps GPSs.)
Crowd-sourcing this might help. Here’s a site where you can map the location of any PIN code you know:
For example, if you knew the exact location of the PIN code 110083 (which happens to be Mongolpuri in New Delhi), just go to http://pincode.datameet.org/IN/110083 and move the marker to where it should be.
I’ve initially populated the data from GeoNames. Arun has offered OpenStreetMap data. If you know of any sources that we could use, please let me know. And if you want to use the data, feel free. It’s CC licensed. You can check out the source on github too.
You’ll first need to create a database, which you can do by visiting the /phpmyadmin/ on your localhost, typing in the database name and pressing ‘Create’.
Now go to /wordpress/, click the buttons and fill out the form. Type in ‘root’ for the database username and leave the password blank. Select any password you want for the administrator account. You can now log in with this administrator password and log into the WordPress dashboard.