bkamapantula
commented
3 years ago good idea @planemad, will add that
Open planemad opened 3 years ago
bkamapantula
commented
3 years ago good idea @planemad, will add that
planemad
commented
3 years ago Have started a spreadsheet to help match the unique PMGSY block names to the LGD block list using a name lookup.
PMGSY block list -> LGD code CSV: https://docs.google.com/spreadsheets/d/1mEvP6vW2NWnD9dqvcyAOjkVgXX3iy6TadM66RNlo38M/edit#gid=0
How to contribute
pmgsy-blocks:block-code pmgsy-blocks:block-lookup with the matching lgd-blocks:block-lookup valuepmgsy-blocks:block-code will be auto updatedUse Data>filter views on both sheets to fine tune the filter to the state/district of your interest.
Progress
bkamapantula
commented
3 years ago thanks for the access!
bkamapantula
commented
3 years ago Mostly done except three: tirupati urban (121), nellore (436) and chintur (141). nellore has a near matching lgd entry for "nellore rural". chintur and tirupati urban don't have any.
| pmgsy | lgd |
|---|---|
| arunachal pradesh-changlang-bordumsa-diyun | arunachal pradesh-changlang-bordumsa |
| arunachal pradesh-changlang-nampong manmao | arunachal pradesh-changlang-nampong |
| arunachal pradesh-kamle-raga | arunachal pradesh-kamle-tamen-raga |
| arunachal pradesh-longding-pongchau wakka | arunachal pradesh-longding-wakka |
| arunachal pradesh-lower dibang valley-hunli desali | arunachal pradesh-lower dibang valley-hunli-kronli |
| arunachal pradesh-namsai-namsai-chowkham | arunachal pradesh-namsai-namsai |
| arunachal pradesh-shi yomi-mechuka | arunachal pradesh-shi yomi-mechuka-tato |
| arunachal pradesh-siang-kaying | arunachal pradesh-siang-kaying payum |
| pmgsy | lgd |
|---|---|
| assam-baksa-tihu barama | assam-baksa-barama |
| assam-barpeta-gama-fulbari | assam-barpeta-gomaphulbari |
| assam-barpeta-rupsi | assam-barpeta-ruposhi |
| assam-dhubri-fekamari | assam-south salmara mancachar-fekamari |
| assam-dhubri-mankachar | assam-south salmara mancachar-mankachar |
| assam-dhubri-south salmara | assam-south salmara mancachar-south salmara |
| assam-dibrugarh-borbarua | assam-dibrugarh-barbaruah |
| assam-dibrugarh-jaipur | assam-dibrugarh-joypur |
| Assam-goalpara-joleshwar | assam-goalpara-jaleswar |
| assam-goalpara-kharmoja | assam-goalpara-kharmuza |
| assam-goalpara-kushdhuwa | assam-goalpara-kuchdhowa |
| assam-jorhat-majuli | assam-majuli-majuli |
| assam-jorhat-ujani majuli | assam-majuli-ujani majuli |
| assam-jorhat-titabar | assam-jorhat-titabor |
| assam-kamrup-chayani borduar | assam-kamrup-chayani |
| assam-karimganj-rknagar | assam-karimganj-ramkrishna nagar |
| Assam-kokrajhar-dotoma | assam-kokrajhar-dotma |
| Assam-lakhimpur-boginodi | assam-lakhimpur-boginadi |
| Assam-marigaon-kopili | assam-marigaon-kapili |
| Assam-marigaon-lahorighat | assam-marigaon-laharighat |
| Assam-marigaon-mayong | assam-marigaon-mayang |
| assam-dima hasao-diyong valley | assam-dima hasao-diyang valley |
| Assam-nalbari-barbhag | assam-nalbari-borbhag |
| assam-nalbari-borigog bonbhag | assam-nalbari-barigog banbhag |
| Assam-nalbari-borkhetri | assam-nalbari-barkhetri |
| assam-nagaon-dalanghat | assam-nagaon-dolongghat |
| assam-nagaon-dhalapukhuri | assam-hojai-dhalpukhuri |
| Assam-nagaon-kaliabar | assam-nagaon-kaliabor |
| Assam-nagaon-kathiatali | assam-nagaon-kathiatoli |
| Assam-nagaon-pakhimaria | assam-nagaon-pakhimoria |
| assam-nagaon-laowkhowa | assam-nagaon-laokhowa |
| Assam-nagaon-paschim kaliabor | assam-nagaon-pachim kaliabor |
| Assam-nagaon-rupahihat | assam-nagaon-rupahi |
| Assam-udalguri-udalguri | assam-udalguri-odalguri |
| Assam-nagaon-odali | assam-hojai-udali |
| pmgsy | lgd | |
|---|---|---|
| hr | haryana-jind-uchana kalan | haryana-jind-uchana |
| pmgsy | lgd | |
|---|---|---|
| mn | manipur-bishnupur-bishnupur c.d. block | manipur-bishnupur-bishnupur |
| mn | manipur-bishnupur-moirang c.d.block | manipur-bishnupur-moirang |
| mn | manipur-chandel-chakpikarong t.d.block | manipur-chandel-chakpikarong |
| pmgsy | lgd | |
|---|---|---|
| ml | meghalaya-east khasi hills-laitkroh-khadar shnong | meghalaya-east khasi hills-khadarshnong-laitkroh |
| pmgsy | lgd | |
|---|---|---|
| ng | Nagaland-wokha-chukidong | nagaland-wokha-chukitong |
| pmgsy | lgd | |
|---|---|---|
| tr | tripura-dhalai-durgachowmuhani | tripura-dhalai-durgachowmuhani |
| tr | tripura-south tripura-bagafa | tripura-south tripura-bokafa |
| tr | tripura-west tripura-mandai | tripura-west tripura-mandwai |
| pmgsy | lgd | |
|---|---|---|
| gj | gujarat-ahmadabad-detroj | gujarat-ahmadabad-detroj rampura |
| gj | gujarat-amreli-kunkavav -vadia | gujarat-amreli-kunkavav |
| gj | gujarat-gir somnath-veraval | gujarat-gir somnath-patan veraval |
| gj | gujarat-kheda-mahemdavad | gujarat-kheda-mehmedabad |
| gj | gujarat-morbi-maliya miyana | gujarat-morbi-maliya |
| gj | gujarat-surendranagar-dasada patadi | gujarat-surendranagar-dasada |
| gj | gujarat-vadodara-vadodara | gujarat-vadodara-vadodara(city and rural) |
| pmgsy | lgd | |
|---|---|---|
| jh | jharkhand-chatra-chatra sadar | jharkhand-chatra-chatra |
| jh | jharkhand-chatra-hunter ganj | jharkhand-chatra-shaligram ram narayanpur alias hunterganj |
| jh | jharkhand-deoghar-deoghar sadar | jharkhand-deoghar-deoghar |
| jh | jharkhand-dhanbad-dhanbad sadar | jharkhand-dhanbad-dhanbad |
| jh | jharkhand-dumka-dumka sadar | jharkhand-dumka-dumka |
| jh | jharkhand-garhwa-garhwa sadar | jharkhand-garhwa-garhwa |
| jh | jharkhand-garhwa-majhiaon | jharkhand-garhwa-manjhiaon |
| jh | jharkhand-giridih-giridih sadar | jharkhand-giridih-giridih |
| jh | jharkhand-giridih-raj dhanwar | jharkhand-giridih-dhanwar |
| jh | jharkhand-godda-boarijore | jharkhand-godda-boarijor |
| jh | jharkhand-godda-godda sadar | jharkhand-godda-godda |
| jh | jharkhand-godda-poraihat | jharkhand-godda-poraiyahat |
| jh | jharkhand-gumla-gumla sadar | Jharkhand-gumla-gumla |
| jh | jharkhand-hazaribagh-chauparan | jharkhand-hazaribagh-chouparan |
| jh | jharkhand-hazaribagh-hazaribagh sadar | jharkhand-hazaribagh-sadar |
| jh | jharkhand-jamtara-jamtara sadar | jharkhand-jamtara-jamtara |
| jh | jharkhand-koderma-koderma sadar | jharkhand-koderma-koderma |
| jh | jharkhand-latehar-latehar sadar | jharkhand-latehar-latehar |
| jh | jharkhand-latehar-mahuatand | jharkhand-latehar-mahuadanr |
| jh | jharkhand-lohardaga-lohardaga sadar | Jharkhand-lohardaga-lohardaga |
| jh | jharkhand-pakur-pakur sadar | jharkhand-pakur-pakur |
| jh | jharkhand-palamu-daltonganj sadar | jharkhand-palamu-medininagar |
| jh | jharkhand-sahebganj-sahebganj sadar | jharkhand-sahebganj-sahibganj |
| jh | jharkhand-saraikela kharsawan-gamharia adityapur | jharkhand-saraikela kharsawan-gamharia |
| jh | jharkhand-saraikela kharsawan-rajnagar govindpur | jharkhand-saraikela kharsawan-rajnagar |
| jh | jharkhand-saraikela kharsawan-saraikela sadar | jharkhand-saraikela kharsawan-seraikella |
| jh | jharkhand-simdega-simdega sadar | jharkhand-simdega-simdega |
| pmgsy | lgd | |
|---|---|---|
| mp | madhya pradesh-betul-ghoda dongri | madhya pradesh-betul-ghoradongri |
| mp | madhya pradesh-chhindwara-junnardeo | madhya pradesh-chhindwara-jamai |
| mp | madhya pradesh-dhar-bankaner | madhya pradesh-dhar-umarban |
| mp | madhya pradesh-gwalior-ghatigaon (barai) | madhya pradesh-gwalior-ghatigaon |
| mp | madhya pradesh-jabalpur-bargi jabalpur | madhya pradesh-jabalpur-jabalpur |
| mp | madhya pradesh-jabalpur-shahpura bhitoni | madhya pradesh-jabalpur-shahpura |
| mp | madhya pradesh-katni-bohriband | madhya pradesh-katni-bahoriband |
| mp | madhya pradesh-katni-dhimarkhera | madhya pradesh-katni-dheemerkheda |
| mp | madhya pradesh-narsinghpur-narsighpur | madhya pradesh-narsinghpur-narsimhapur |
| mp | madhya pradesh-narsinghpur-saikhda gadarwada | madhya pradesh-narsinghpur-sainkheda |
| mp | madhya pradesh-raisen-badi breli | madhya pradesh-raisen-badi |
| mp | madhya pradesh-rajgarh-jirapur | madhya pradesh-rajgarh-zirapur |
| mp | madhya pradesh-rajgarh-sarangpur (pachor) | madhya pradesh-rajgarh-sarangpur |
| mp | madhya pradesh-satna-chitrakut (majhgawan) | madhya pradesh-satna-majhgawan |
| mp | madhya pradesh-satna-sohawal (satna) | madhya pradesh-satna-sohawal |
| mp | madhya pradesh-satna-uchehra | madhya pradesh-satna-unchahara |
| mp | madhya pradesh-seoni-dhanora | madhya pradesh-seoni-dhanaura |
| mp | madhya pradesh-seoni-ghansor | madhya pradesh-seoni-kahnapas(ghansaur) |
| mp | madhya pradesh-seoni-kevlari | madhya pradesh-seoni-keolari |
| mp | madhya pradesh-sheopur-seopurkalan | madhya pradesh-sheopur-sheopur |
| mp | madhya pradesh-shivpuri-khaniya dhana | madhya pradesh-shivpuri-khaniadhana |
| mp | madhya pradesh-sidhi-majholi | madhya pradesh-sidhi-majhauli |
| mp | madhya pradesh-sidhi-sidhi (gopad banas ) | madhya pradesh-sidhi-sidhi |
| mp | madhya pradesh-singrauli-deosar | madhya pradesh-singrauli-devsar |
| mp | madhya pradesh-umaria-pali gohparu | madhya pradesh-umaria-pali |
| mp | madhya pradesh-umaria-umaria karkeli | madhya pradesh-umaria-karkeli |
| pmgsy | lgd | |
|---|---|---|
| mh | maharashtra-amravati-anjangaon | maharashtra-amravati-anjangaon s |
| mh | maharashtra-amravati-chandur railway | maharashtra-amravati-chandur ril |
| mh | maharashtra-amravati-dhamangaon railway | maharashtra-amravati-dhamangaon ril |
| mh | maharashtra-amravati-nandgaon khandeshwar | maharashtra-amravati-nandgaon kh |
| mh | maharashtra-amravati-teosa | maharashtra-amravati-tiwsa |
| mh | maharashtra-aurangabad-soyagaon | maharashtra-aurangabad-soegaon |
| mh | maharashtra-beed-parli | maharashtra-beed-parali v . |
| mh | maharashtra-beed-shirur (kasar) | |
| mh | maharashtra-buldhana-buldhana | maharashtra-buldhana-buldana |
| mh | maharashtra-buldhana-chikhali | maharashtra-buldhana-chikhli |
| mh | maharashtra-buldhana-deulgaon raja | maharashtra-buldhana-d. raja |
| mh | maharashtra-buldhana-jalgaon jamod | maharashtra-buldhana-jalgaonjamod |
| mh | maharashtra-chandrapur-sawali | maharashtra-chandrapur-saoli |
| mh | maharashtra-chandrapur-shindewahi | maharashtra-chandrapur-sindewahi |
| mh | maharashtra-gadchiroli-wadsa | maharashtra-gadchiroli-desaiganj (wadsa) |
| mh | maharashtra-gondia-arjuni/ morgaon | maharashtra-gondia-arjuni morgaon |
| mh | maharashtra-hingoli-aundha nagn | |
| mh | maharashtra-nanded-mudkhed | maharashtra-nanded-modkhed |
| mh | maharashtra-nanded-mukhed | maharashtra-nanded-mokhed |
| mh | maharashtra-nanded-naigaon | maharashtra-nanded-naigaon (kh) |
| mh | maharashtra-nashik-trimbkeshwar | maharashtra-nashik-trimbak |
| mh | maharashtra-osmanabad-kallam | maharashtra-osmanabad-kalamb |
| mh | maharashtra-ratnagiri-chiplun | maharashtra-ratnagiri-chipalun |
| mh | maharashtra-sangli-khanapur | maharashtra-sangli-khanapur-vita |
| mh | maharashtra-sangli-walwa | maharashtra-sangli-valva-islampur |
| mh | maharashtra-solapur-mangalwedha | maharashtra-solapur-mangalvedhe |
| pmgsy | lgd | |
|---|---|---|
| ts | telangana-adilabad-adilabad | telangana-adilabad-adilabad urban |
| ts | telangana-jangoan-ghanpur(stn) | telangana-jangoan-ghanpur(station) |
| ts | telangana-jogulamba gadwal-aiza | telangana-jogulamba gadwal-ieeja |
| ts | telangana-karimnagar-saidapur | telangana-karimnagar-v. saidapur |
| ts | telangana-karimnagar-thimmapur | telangana-karimnagar-thimmapur (l.m.d.) |
| ts | telangana-mahabubabad-garlabayyaram | telangana-mahabubabad-garla |
| ts | Telangana-mahabubabad-kothaguda | telangana-mahabubabad-kothagudem |
| ts | telangana-mahabubnagar-mahabubnagar | telangana-mahabubnagar-mahabubnagar urban |
| ts | telangana-mahabubnagar-mahabubnagar rural | telangana-mahabubnagar-mahbubnagar rural |
| ts | telangana-nalgonda-gundla pally | telangana-nalgonda-gundlapally (dindi) |
| ts | telangana-ranga reddy-chowdergudem | telangana-ranga reddy-jilled chowdergudem |
| ts | telangana-suryapet-chinthalapalem | telangana-suryapet-chinthalapalem mallareddygudem |
| ts | telangana-suryapet-aravapally | telangana-suryapet-jaji reddi gudem (arvapally) |
| ts | telangana-yadadri bhuvanagiri-bhuvanagiri | telangana-yadadri bhuvanagiri-bhongir |
| ts | telangana-yadadri bhuvanagiri-pochampally | telangana-yadadri bhuvanagiri-b.pochampally |
| pmgsy | lgd | |
|---|---|---|
| wb | west bengal-24 paraganas south-tha-maheshtala | west bengal-24 paraganas south-thakurpukur mahestola |
| wb | west bengal-birbhum-md.bazar | west bengal-birbhum-mohammad bazar |
| wb | west bengal-jalpaiguri-jalpaiguri-sadar | west bengal-jalpaiguri-jalpaiguri |
| wb | west bengal-medinipur west-midnapur sadar | west bengal-medinipur west-midnapore |
| wb | west bengal-murshidabad-msd-jiaganj | west bengal-murshidabad-murshidabad-jiagunj |
| wb | west bengal-paschim bardhaman-andal | west bengal-paschim bardhaman-ondal |
| pmgsy | lgd | |
|---|---|---|
| or | odisha-baleshwar-balasore | odisha-baleshwar-baleshwar |
| or | odisha-cuttack-baramba | odisha-cuttack-badamba |
| or | odisha-cuttack-cuttack | odisha-cuttack-cuttacksadar |
| or | Odisha-cuttack-kantapara | odisha-cuttack-kantapada |
| or | Odisha-dhenkanal-dhenkanal | odisha-dhenkanal-dhenkanal sadar |
| or | odisha-kalahandi-m.rampur | odisha-kalahandi-madanpur rampur |
| or | odisha-kalahandi-th.rampur | odisha-kalahandi-thuamul ram pur |
| or | odisha-kendujhar-keonjhar | odisha-kendujhar-kendujhar sadar |
| or | Odisha-nayagarh-ranpur | odisha-nayagarh-ranapur |
| or | Odisha-puri-puri | odisha-puri-sadar |
| pmgsy | lgd | |
|---|---|---|
| up | uttar pradesh-aligarh-chandosh | uttar pradesh-aligarh-chandaus |
| up | uttar pradesh-aligarh-jawan | uttar pradesh-aligarh-jawan sikanderpur |
| up | uttar pradesh-amethi-bazar shukla | uttar pradesh-amethi-shukul bazar |
| up | uttar pradesh-auraiya-arwa katra | uttar pradesh-auraiya-erwa katra |
| up | uttar pradesh-auraiya-achchalda | uttar pradesh-auraiya-achchalda |
| up | uttar pradesh-ayodhya-haringtonganj | uttar pradesh-ayodhya-hariyangatanganj |
| up | uttar pradesh-azamgarh-koyalasa | uttar pradesh-azamgarh-koilsa |
| up | uttar pradesh-ballia-sear | uttar pradesh-ballia-siar |
| up | uttar pradesh-ballia-shohaon | uttar pradesh-ballia-sohanv |
| up | uttar pradesh-balrampur-gainsari | uttar pradesh-balrampur-gaisri |
| up | uttar pradesh-balrampur-gendas buzurg | uttar pradesh-balrampur-gaindas bujurg |
| up | uttar pradesh-balrampur-rehra | uttar pradesh-balrampur-rehera bazaar |
| up | uttar pradesh-barabanki-nidura | uttar pradesh-barabanki-nindaura |
planemad
commented
3 years ago Amazing @bkamapantula 🙌 💯
Using the block codes, its now possible to add subdistrict info or even census 2011 codes using this LGD village lookup https://github.com/planemad/india-local-government-directory/blob/master/village-directory.csv.zip
bkamapantula
commented
3 years ago excellent!
in the next few days will look at merging this with pmgsy attributes, will close it then.
Adding official local government directory codes for each facility can help spatially join this data to other datasets without relying on the name. LGD code list: