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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAABnYsUTfHZnmisWitBKBAGRBkYQ2OA8%2BuuK46MwRy8uNqiWTg%40mail.gmail.com.
