Wikipedia talk:WikiProject Andhra Pradesh/Coordinate Me 2024

Proposed update from a database

Thanks to all the contributors to this initiative. Since the project begining on 1st May 2024, about 128 revenue village wikidata items were updated with new coordinates. Some people have contributed to hamlet wikidata items as well which was not counted as the focus is on revenue villages. Through discussions on OSM Andhra Pradesh, we are able to locate a dataset from government sources, which has data for 12591 (panchayats), which can be useful to speed up this work. I have analysed that dataset for Bapatla district and found the location data to be on residential areas in 95% of the cases. I also found that AP state GIS portal does not have proper location for some of our villages and the panchayat headquarters data is actually tagged with census village location, which is not on residential areas in several cases. So I propose to use QuickStatements or Openrefine tool to edit wikidata to update the coordinate claim, for which the data is still blank. Please respond if you have any concern about this proposal by 7 May 2024. Arjunaraoc (talk) 13:18, 5 May 2024 (UTC)[reply]

As there were no concerns, I have added coordinate location to 6474 census villages today. If you notice any discrepancy, let me know. I will add some more tomorrow. Arjunaraoc (talk) 14:12, 8 May 2024 (UTC)[reply]

I have added coordinate location to 1115 census villages taking the total villages updated from database to 7589. If you notice any discrepancy, let me know. Arjunaraoc (talk) 07:22, 9 May 2024 (UTC)[reply]

Here is a summary after the update from a database. There are 10565 panchayats traceable to unique census villages out of 12591 panchayats in all. Thus there are 2026 panchyats which are not census villages. I have added coordinates for 7589 villages, taking the total census villages with coordinates on Wikidata to 10497. I think we have utilised the database to the maximum extent. Now contributors can try to manually add coordinates to the remaining census villages of 5293 on Wikidata. At least half of these are going to be from Alluri Sitharamaraju district, which consists of thinly populated villages. Please share your experience and doubts as you work. Arjunaraoc (talk) 08:12, 9 May 2024 (UTC)[reply]

Cleanup of village article links from enwiki, tewiki on wikidata

I have edited 489 wikidata entities to cleanup the linkages from enwiki and tewiki and also edit/add labels, descriptions, instance of, located in admin area values, so that separate entities for enwiki, tewiki articles are merged, admin area values are not Andhra Pradesh or districts from 2025-05-10 to 2025-05-16. (Query) Arjunaraoc (talk) 16:41, 16 May 2024 (UTC)[reply]