Re: [External Email] [datameet] Re: Connecting political boundaries to PIN codes/mapping PIN codes

['Shiv Hastawala' via datameet]

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


On Sat, Dec 2, 2023 at 11:09 AM Mantha Chandrasekhar 
wrote:

> Hi Jatin Rajani,
> Did you find any data sets that matches assembly constituencies with pin
> codes?
>
>
> On Monday, May 18, 2020 at 6:31:12 PM UTC+5:30 jatin rajani wrote:
>
>> Hi Jeff,
>> Were you able to find the pin code matching with assembly constituencies?
>>
>>
>> On Friday, 14 February 2014 22:39:02 UTC+5:30, Jeff Weaver wrote:
>>>
>>> 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!
>>>
>> --
> 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+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/datameet/5b0fa49a-0c00-4694-87fd-c11f99f57f41n%40googlegroups.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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/CAGiG-AzSnwPkvB5esYNLJojLKYGzo432Bss6suvRMLEeCEvRSw%40mail.gmail.com.

[datameet] Re: Connecting political boundaries to PIN codes/mapping PIN codes

[Mantha Chandrasekhar]

Hi Jatin Rajani,
Did you find any data sets that matches assembly constituencies with pin 
codes?


On Monday, May 18, 2020 at 6:31:12 PM UTC+5:30 jatin rajani wrote:

> Hi Jeff,
> Were you able to find the pin code matching with assembly constituencies?
>
>
> On Friday, 14 February 2014 22:39:02 UTC+5:30, Jeff Weaver wrote:
>>
>> 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!
>>
>

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/5b0fa49a-0c00-4694-87fd-c11f99f57f41n%40googlegroups.com.

Re: [datameet] Re: Connecting political boundaries to PIN codes/mapping PIN codes

[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=json=0=6%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  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+unsubscr...@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

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/CAPRin7Gsza4M0fBtTrEePnPXEe%3DQqSqLAu%3DexbKJ3bCNx%3DNrng%40mail.gmail.com.

Re: [datameet] Re: Connecting political boundaries to PIN codes/mapping PIN codes

[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.

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/CA%2BGKQr06P1967Oqv_OGWTCYWyhfdTr%3DpjXaDxahN9iiMny0ngw%40mail.gmail.com.

Re: [datameet] Re: Connecting political boundaries to PIN codes/mapping PIN codes

[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 .

On Fri, May 22, 2020 at 8:10 PM Arun Ganesh  wrote:

>
>
> On Fri, May 22, 2020 at 5:34 PM Primal Vincent 
> 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=pos4=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!
>
> --
> 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+unsubscr...@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

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/CAPRin7H%3DnJK1B3QMcNS%2BUiyxaURUkR2m3ghxA9ctneV_2TQpXg%40mail.gmail.com.

Re: [datameet] Re: Connecting political boundaries to PIN codes/mapping PIN codes

[Arun Ganesh]

On Fri, May 22, 2020 at 5:34 PM Primal Vincent 
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=pos4=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!

-- 
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+unsubscr...@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.

[datameet] Re: Connecting political boundaries to PIN codes/mapping PIN codes

[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?

On Monday, May 18, 2020 at 9:01:12 AM UTC-4, jatin rajani wrote:
>
> Hi Jeff,
> Were you able to find the pin code matching with assembly constituencies?
>
> On Friday, 14 February 2014 22:39:02 UTC+5:30, Jeff Weaver wrote:
>>
>> 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!
>>
>

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/6ddae2ba-22d5-4c6e-b8c6-556c867a8aaa%40googlegroups.com.

[datameet] Re: Connecting political boundaries to PIN codes/mapping PIN codes

[jatin rajani]

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

On Friday, 14 February 2014 22:39:02 UTC+5:30, Jeff Weaver wrote:
>
> 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!
>

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/datameet/63744dc2-c00e-4ae0-b9a3-79b4aaf83d85%40googlegroups.com.