Very cool Thejesh! The LGD dataset is definitely super useful to help reconcile various other datasets that reference any territory.
Have been maintaining a dump of all the other LGD lookups here https://github.com/planemad/india-local-government-directory . Would be great to have it merged with the datmeet repo and see how we can maintain an easy to access dump of https://lgdirectory.gov.in On Sat, Mar 20, 2021 at 10:28 AM Bodhisattwa Mandal < bodhisattwa.rg...@gmail.com> wrote: > Hi Thejesh, > > The best place to discuss this is here - > https://www.wikidata.org/wiki/Wikidata_talk:WikiProject_India > > There are Wikidata contributors who had been working on this, who might > respond there. > > Thanks, > Bodhisattwa > > > On Sat, 20 Mar 2021 at 10:46, Thejesh GN <i...@thejeshgn.com> wrote: > >> LGD publishes some important IDs, that can be useful. I also think >> WikiData item Id as a primary key. I just started syncing both of them >> locally so, I can update the WikiData with missing Census Location IDs. >> States was easy, but districts turned out to be not so easy. >> >> I have blogged here >> >> >> https://thejeshgn.com/2021/03/20/mapping-local-government-directory-to-wikidata/ >> >> But here are the differences. Let me know what do you guys think. >> >> WikiDataIdLabelDescriptionComments >> Q955977 South Arcot Former district in Tamil Nadu, India Needs to be >> marked as dissolved in WikiData >> Q1900496 Bangalore Former district in Karnataka, India Needs to be >> marked as dissolved in WikiData >> Q1606061 Andaman Former district of the Andaman and Nicobar Islands Needs >> to be marked as dissolved in WikiData >> Q24949801 Shahbazwan District of Bihar in India is this same as >> GOPALGANJ district? Marked by mistake in WikiData. Should be removed as a >> district. >> Q6007135 Imphal Wikimedia disambiguation page is ex-district. Was split. >> Needs to be marked as dissolved in WikiData >> Q48731903 Noklak District in India, Nagaland New district >> <https://en.wikipedia.org/wiki/Noklak_district>. LGD needs update. >> January 20, 2021. >> Q61746013 Narayanapet District of Telangana, India There seem to be a >> duplicate Narayanpet district (Q85787759); but Q61746013 was created >> earlier. DataCommons <https://datacommons.org/place/wikidataId/Q61746013> >> also uses the same. It also has >> Q29025081 East Karbi Anglong District of Assam, India When KARBI ANGLONG >> was split. The western part became the new "West Karbi Anglong" and the >> rest remained part of "Karbi Anglong". There is no "East Karbi Anglong" as >> such. Should be removed in WikiData? >> Q101088203 Bajali district of Assam India New district >> <https://en.wikipedia.org/wiki/Bajali_district> formed in 12 January >> 2021. LGD needs an update >> DONT KNOW Vijayanagara district of Karnataka in India New district >> <https://en.wikipedia.org/wiki/Vijayanagara_district> formed in 2020/21 >> <https://www.newindianexpress.com/states/karnataka/2021/feb/18/karnatakas-newest-district-to-have-admin-buildings-in-vijayanagara-architecture-style-2265741.html>. >> Needs an addition to LGD. May be mark Q1611788 >> <https://www.wikidata.org/wiki/Q1611788> as district in WikiData? >> DONT KNOW Chachaura district of mp Missing on LGD, WikiData and OSM. No >> gazette yet >> DONT KNOW Maihar district of mp Missing on LGD, WikiData and OSM. No >> gazette yet >> DONT KNOW Nagda district of mp Missing on LGD and WikiData. No gazette >> yet. >> Q61439260 Pakke-Kessang district of Arunachal Pradesh in India It was >> missing from WikiData query results. Because it was not tagged as district. >> I updated >> <https://www.wikidata.org/w/index.php?title=Q61439260&action=history> >> WikiData. >> >> >> Thej >> -- >> Thejesh GN *⏚* ತೇಜೇಶ್ ಜಿ.ಎನ್ >> http://thejeshgn.com >> GPG ID : 0xBFFC8DD3C06DD6B0 >> >> -- >> 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/CAABnYsUTfHZnmisWitBKBAGRBkYQ2OA8%2BuuK46MwRy8uNqiWTg%40mail.gmail.com >> <https://groups.google.com/d/msgid/datameet/CAABnYsUTfHZnmisWitBKBAGRBkYQ2OA8%2BuuK46MwRy8uNqiWTg%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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/CAHyrfgb4AybH9okfQ2S9-r71agRi5kkMGueTdt_hOQs%2B1e1eDw%40mail.gmail.com > <https://groups.google.com/d/msgid/datameet/CAHyrfgb4AybH9okfQ2S9-r71agRi5kkMGueTdt_hOQs%2B1e1eDw%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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%2BGKQr0YAKYDsTHyo7H0X0CqOAtWGsvjAsp9eDDTt2QPcowH9g%40mail.gmail.com.