Sharing some of the LGD-Wikidata mapping that I had done from two years ago. Hopefully its of some use and can be a start. https://docs.google.com/spreadsheets/d/1FhXYDgenJ9rzIrSfXbnajGW1jiMrzcsdvYkkslyFKow/edit#gid=0
On Fri, Sep 22, 2023 at 11:27 AM Thejesh GN <i...@thejeshgn.com> wrote: > Thank you for letting us know Sreeram. > > I had started working on Taluks. Its not that straightforward. I will keep > the list informed. > > Thej > -- > Thejesh GN *⏚* ತೇಜೇಶ್ ಜಿ.ಎನ್ > http://thejeshgn.com > GPG ID : 0xBFFC8DD3C06DD6B0 > > > On Fri, 22 Sept 2023 at 10:53, sreeram kandimalla < > kandimalla.sree...@gmail.com> wrote: > >> Just an FYI, LGD mappings have been asserted in wikidata till the >> district level based on Thejesh's work and I verified them independently. >> >> Moving onto lower divisions( Tehsils/CD blocks ) now. The wikidata >> hierarchy for these is unclear and needs to be cleaned up. >> >> On Friday, 26 March 2021 at 07:56:25 UTC+5:30 Naveen Francis wrote: >> >>> Hello >>> >>> To maintain the country subdivision data model, there is a task force in >>> Wikidata. >>> >>> https://www.wikidata.org/wiki/Wikidata:Country_subdivision_task_force/India >>> >>> Thanks, >>> naveenpf >>> >>> >>> >>> On Sunday, 21 March, 2021 at 10:00:32 am UTC+5:30 Thejesh GN wrote: >>> >>>> Bodhisattwa - Thank you. Added a note - >>>> https://www.wikidata.org/wiki/Wikidata_talk:WikiProject_India#Syncing_Local_Government_Data_to_WikiData >>>> >>>> Arun - Sure. How do we proceed? >>>> >>>> >>>> I also have the udise_districts and udise_blocks in the same SQLITE. >>>> udise_districts uses a completely different *udise_dist_code*. I will >>>> try and map wikiDataId to this as well. >>>> >>>> https://india-local-government-directory.glitch.me/india-local-government-directory/udise_districts >>>> >>>> udise_blocks are completely different from blocks as a geographical >>>> area. I am not going to pick it up as of now. >>>> >>>> https://india-local-government-directory.glitch.me/india-local-government-directory/udise_blocks >>>> >>>> My plan to pickup sub-district after this. >>>> >>>> Thej >>>> -- >>>> Thejesh GN *⏚* ತೇಜೇಶ್ ಜಿ.ಎನ್ >>>> http://thejeshgn.com >>>> GPG ID : 0xBFFC8DD3C06DD6B0 >>>> >>>> On Sun, 21 Mar 2021 at 00:09, Arun Ganesh <arung...@gmail.com> wrote: >>>> >>>>> 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 < >>>>> bodhisat...@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+u...@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+u...@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+u...@googlegroups.com. >>>>> >>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/datameet/CA%2BGKQr0YAKYDsTHyo7H0X0CqOAtWGsvjAsp9eDDTt2QPcowH9g%40mail.gmail.com >>>>> <https://groups.google.com/d/msgid/datameet/CA%2BGKQr0YAKYDsTHyo7H0X0CqOAtWGsvjAsp9eDDTt2QPcowH9g%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/4a7f72db-d74e-4302-ab03-6abecd3970aan%40googlegroups.com >> <https://groups.google.com/d/msgid/datameet/4a7f72db-d74e-4302-ab03-6abecd3970aan%40googlegroups.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/CAABnYsV_Zv%2By43Vq%3DGywTGFBX74fNRJKsNXfXSZwJNvRb%2B3v7w%40mail.gmail.com > <https://groups.google.com/d/msgid/datameet/CAABnYsV_Zv%2By43Vq%3DGywTGFBX74fNRJKsNXfXSZwJNvRb%2B3v7w%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%2BGKQr1WE3jPNnF%3DToD1mZSNcWgyz-eg7KUk%3Da8YZoXLjR-S%3Dw%40mail.gmail.com.