Connecting political boundaries to PIN codes/mapping PIN codes

[Jeff Weaver]

Hi all, 

Just came across this group, and excited to read about all the cool data tasks that people are working on. I’m currently trying to link a dataset of school data (DISE) to the MP/MLA constituencies (and eventually maybe panchayats) in which they are located. Each school has its district, block, village and PIN code listed. I was really hoping to connect it to assembly constituencies using the PIN code data, and avoid doing any name-matching. My plan was to use the GPS coordinates of PIN codes and then link them using the GIS maps of constituencies. 

However, I haven’t been able to find a large enough dataset on the GPS coordinates of the pincodes. Does anyone know of a good public (or private) source of this or have another suggestion for how to do this? I have the dataset that someone in the group made using Open Street Maps, and it’s great, but it doesn’t cover a lot of the pin codes (especially the rural ones). Or are there companies that are willing to sell it for a reasonable price?

Thanks!

[Gautam John]

Jeff, 

Is this for a particular state or for the entire country? If for Karnataka, we can help as we did this exercise to create reports like these: http://www.klp.org.in/reports//infrastructure/English/MP_Bangalore_Central.pdf

If for the entire country, you can buy polygons of PIN Codes from http://www.mlinfomap.com/ as well as MP constituency polygons. 

--
For more details about this list
http://datameet.org/discussions/
---
You received this message because you are subscribed to the Google Groups "datameet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datameet+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Sent from Gmail Mobile

[jatin rajani]

Hi Jeff,
Were you able to find the pin code matching with assembly constituencies?

[Primal Vincent]

I'm also looking for details like Based on zipcode , I should be able to figure out details like State, District, Subdistrict , PC,AC, Village etc ... Is there any single data source for that?

[Arun Ganesh]

On Fri, May 22, 2020 at 5:34 PM Primal Vincent <primal...@gmail.com> wrote:

I'm also looking for details like Based on zipcode , I should be able to figure out details like State, District, Subdistrict , PC,AC, Village etc ... Is there any single data source for that?

Theres never going to be a perfect answer to this since a pin code can serve multiple villages and subdistricts (and maybe even districts?), so you cannot make a 1:1 mapping between levels. For a visual reference use this tool to compare pincode boundaries and administrative boundaries for India https://demos.mapbox.com/vt_polygons/?country=IN&layer=pos4&worldview=IN#8.48/19.8489/74.4616

That said, its still interesting to explore what a good solution would be. This is what i would try:

- Use https://data.gov.in/resources/all-india-pincode-directory to lookup districts and office names for the a given pincode

- Use the above results to match against the village names and codes in https://github.com/planemad/india-local-government-directory/blob/master/village-directory.csv for the corresponding administrative divisions served by the pincode

- Use the village code to match against https://github.com/planemad/india-local-government-directory/tree/master/political/1-2-constituency for constituency+block information

Good luck!

[Primal Vincent]

Thanks Arun for the quick response. This helps a lot.

currently In my app , we were able to figure out Zipcode --> State ,District & Using State to PC ; and based on PC selection( This is a dropdown) i'm able jogged down AC to 6-7 values ( So gave this as well as dropdown).

Now My challenge is to generate the map of District/PC/AC and found out SVG is the best option, But its very costly solution. Hence was looking for as open source solution .

--
Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org

---
You received this message because you are subscribed to the Google Groups "datameet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datameet+u...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CA%2BGKQr3w8s1%2BY%3DnXhrQAGvN_AcqW_tVnbwd5Q4dy%2BE%3DdAFVjUA%40mail.gmail.com.

--

Primal.K.Vincent

[Arun Ganesh]

Now My challenge is to generate the map of District/PC/AC and found out SVG is the best option, But its very costly solution. Hence was looking for as open source solution .

No way for anyone to help here unless you share some code of what exactly you are doing.

[Primal Vincent]

Hi Arun,

Currently I've used data from this website , You can get any data from this.Also this guys are giving API's( Paid one)  as well but not the MAP

https://lgdirectory.gov.in/downloadDirectory.do?OWASP_CSRFTOKEN=Z1KK-A0WR-BQI6-UIF7-9X47-H01D-VUJ4-NDH5

Also Zipcode details from https://data.gov.in/catalog/all-india-pincode-directory?filters%5Bfield_catalog_reference%5D=85840&format=json&offset=0&limit=6&sort%5Bcreated%5D=desc

But I thing this details everyone has.

This is also another website that anyone can refer

https://adrindia.org/content/lok-sabha-elections-2019

On Fri, May 22, 2020 at 9:37 PM Arun Ganesh <arung...@gmail.com> wrote:

Now My challenge is to generate the map of District/PC/AC and found out SVG is the best option, But its very costly solution. Hence was looking for as open source solution .

No way for anyone to help here unless you share some code of what exactly you are doing.

--

Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org
---
You received this message because you are subscribed to the Google Groups "datameet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datameet+u...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CA%2BGKQr06P1967Oqv_OGWTCYWyhfdTr%3DpjXaDxahN9iiMny0ngw%40mail.gmail.com.

--

Primal.K.Vincent

[Mantha Chandrasekhar]

Hi Jatin Rajani,

Did you find any data sets that matches assembly constituencies with pin codes?

[Shiv Hastawala]

Hi Mantha

There isn't a readily-available crosswalk, but there might just be a workaround. I can give you some resources but you would have to be extremely careful while matching stuff across these data sets because district, AC, and PIN code boundaries are very fluid and keep changing. You will have to keep a track of whether your matching makes any sense.

You can use the file named "AC_predelim_District_intersect.csv" (which is an AC-District crosswalk) from this folder: https://www.dropbox.com/sh/rt0tldkybbdccmb/AAChviOyKfqZo3zPpe84xGyHa?dl=0

Please read the paper that is included in the folder to get context on why the data is constructed the way it is.

And then you can use the following District-PIN code crosswalks as well: https://www.dropbox.com/sh/fmodu1b1iwjdw5n/AADSbbXnRP0lxkqi-CpJEZ59a?dl=0

You can perhaps merge both types of crosswalks by district name (you will have to either do approximate string matching, or do it manually for precision; again, district names usually have different spellings in different data sets, so you have to be quite careful; also, district A in year one might split into district A and district B in year 2) and you should have what you need. However, once again, be EXTREMELY careful of whether what you are doing makes sense. This is because district X in year 1 may contain AC Y inside it, but in year 2 district X may or may not contain AC Y within its boundary. So please be really aware of boundary dynamics while merging these crosswalks. It is not going to be an easy task, may require you to look at some other resources as well (like district census numbers and boundaries by year, AC numbers and boundaries by year, etc), and may require several iterations as well before you have the correct crosswalk.

Thanks and regards.

Yours sincerely

Shiv Hastawala

(He/His/Him)

Doctoral Student

Department of Economics

Binghamton University (State University of New York)

Zoom ID: 201 717 2613

www.shivhastawala.com

--

Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org
---
You received this message because you are subscribed to the Google Groups "datameet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datameet+u...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/5b0fa49a-0c00-4694-87fd-c11f99f57f41n%40googlegroups.com.