question

nikhil.kadam49521 avatar image
nikhil.kadam49521 asked

By using Lat-Long How can i get PINCODE in India? We are using SQL SERVER 2012.

We have a requirement to get PINCODE in India by passing Lat-Long.Am unable to get any clue how to do this using SQL SERVER 2012..Please guide me.
sql-server-2008sql server 2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
David Wimbush avatar image
David Wimbush answered
I've had similar fun with UK postcodes. Lots of people claim to know the answer but, because it's not a calculation, it all hinges on having reliable data. It looks like the Indian government publishes pincodes with latitude and longitude here: https://data.gov.in/catalog/all-india-pincode-directory but the data appears to be incomplete so far. I'm not sure who else has the data if they don't!
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.