Arjunaraoc

• Wikidata:WikiProject India/Portals/Andhra Pradesh/Village names consistency with Local government directory data

Only working for simple queries. For complex queries timeout is happening

• Places in a district which are part of mandals with tewikilink and osmlink
• get osmid for mandals in a district
• get osmid and format for osmwiki for mandals in a district Paste this definition line below as the first line of query, if you change the values interactively.

PREFIX osmt: <https://wiki.openstreetmap.org/wiki/Key:>

• • osmid for mandal and admin_centres
• for name:te updates based on itemLabel:te name_te to be renamed as name:te in generated csv file.
• Telugu wiki link and Open street map link for mandals in Andhra Pradesh (updated 2022-01-02)
• Telugu wiki link and Open street map link for mandals in a district

• Mandals in a district and their osmlinks for mandals and their admin_centres and wikidata for admin_centres(if available)
• Mandals with out admin_centre wikidata in osm
• AP Mandals and their admin_centre from osm
• AP Mandal hq and their population as per 2011 census

Maintenance edit

• Distance between village location as per wikidata and OSM in a district for identifying potential errors with 2011censuscode (with distance rounded to two number after decimal point)
  • Distance between revenue village location as per wikidata and OSM in a district for identifying potential errors (with distance rounded to two number after decimal point)
  • Revenue village wikidata yet to be mapped on OSM (indicates further work)
    • Inhabited Revenue village wikidata yet to be mapped on OSM (indicates further work)
• place location in an admin area as per wikidata to generate geojson using openrefine

• All human settlements in Prakasam district having population for year 2011 and coordinates with tewiki page
• All mandals and their population as per 2011
• All mandals in district with population as per 2011
• All Revenue villages in Prakasam with area and unit info
• All districts in Andhra Pradesh with Tewiki Article names
• All prakasam villages with telugu wikipedia article and wikidata reference
• All Vizianagaram mandals with censuscode and english label
• All Prakasam mandal HQ with Coordinates
• All Prakasam mandal HQ without Coordinates
• All Prakasam mandal with map display
• All Prakasam mandal HQ with Coordinates with english labels
• All Prakasam mandal HQ with Coordinates (Point) with Telugu labels
• All Prakasam mandal HQ with Coordinates (lat,lon) with Telugu label, wp article
• Parchur mandal places with qid, telugu article name
• Parchur mandal places with coordinates
• Revenue Villages in Parchuru Mandal
• Humansettlements with mandals
• All humansettlements with their enlabel, qid in a district

• UN member states
  • UN member states with flag and telugu wiki link (Danish realm has two flags)

• All mandals which moved to different district during 2022 district reorg with their tewikilink
• /parliament, assembly, old districts
• /assembly, district post 2022 org tewiki article
• /assembly, district, loksabha, assembly tewiki article link
• /assembly, loksabha for specified district with assembly tewiki article link
• /assembly tewiki article, new district tewiki article, old district tewiki article for changes during 2022 reorg
• All human settlements in a district with their admin territorial entity label (to catch any non mandal labels)
• All human settlements with PIN
  • As of 2019-07-25, 1457 places . Total villages as per Wikipedia is 19546.
• All Village in Prakasam district with mandal page te,en, 1051
• All human settlements in Prakasam district with mandal tewiki page (958)
• Mandal tewiki page wise count of all human settlements in Prakasam district
• human settlements without census location code
• finding duplicates in loccode for Prakasam district
• All human settlements in Prakasam by their admin centre.. To tally with actual mandal wise revenue villages and identify hamlets.

• Mandals of Prakasam district prior to reorg in 2022

• Mandals of Anakapalli district
• Mandals and their districts as per AP post restructure of districts in 2022
• inhabited Villages or subvillages in a district (optimized)

• Internal links for a english wikipedia page and corresponding te wikipedia page using mwapi
• Articles which are members of Category:Pages with maps, in India and which have a geo id, displayed using map
• Articles which are members of Category:Pages with maps, in India
  • Articles which are members of Category:Pages with maps, in India and which are not administrative entities or hamlets as a list
  • Articles which are members of Category:Pages with maps, in India and which are not administrative entities or hamlets as a list, with tewiki details

Commons queries edit

• Commons category "Category:Images from Wiki Loves Earth 2021 in Australia" images used as depict for items with WDAPid in Australia

• human settlements in Prakasam district without mandal info in wikidata
• Mandals without P625 in wikidata
• AP assembly constituencies reconcilation with wikidata
• 1727 wikidata entries for places on OSM as on 2024-04-05
• census 2011 villages with wikidata on OSM (using a canned places generated using overpass turbo with result captured in [osm places with wikidata with corresponding tewiki page file number 57070 (pages 1524) (88.2% of all places with Wikidata on OSM are census villages) (203 pages are hamlets with most probably links to enwiki.
• tewiki village pages with wikidata on OSM but without OSM maps
• enwiki village pages with wikidata on OSM but without OSM maps
• English wiki village articles of Andhra pradesh (2241 as on 2024-04-06)
  • English wiki articles displaying osm map location (1892 as on 2024-04-06)
  • English village articles of AP having infobox settlement but lacking coordinates (169 as on 2024-04-06)
  • English wiki articles of AP not using Infobox settlement template (180 as on 2024-04-06)

• AP villages with P131 being Andhra Pradesh rather than a mandal or city (Check complete 2025-05-16)
• AP villages with P131 being a specific district rather than a mandal, with tewiki or enwiki link
  • AP Revenue villages with P131 being a specific district rather than a mandal, with tewiki or enwiki link (Checked 2025-05-15 and corrected)
• AP villages with P131 being a specific district, but without english or telugu wiklinks (other wiki entries and blank knowledge graph result, names familiar to be merged to items with en or te wikilink)
• Revenue divsions used in andhra Pradesh (output to be used for deleting such association, as district is being used primarily as P131 for mandal
• Population entries without determination method for mandals in AP
• villages in a district and their te and en descriptions, teluguwiki name
• town in AP with their te, en descriptions, districtname
• city in AP with their te, en descriptions, tewikiarticle
• human settlements in a set of mandals in a district with their en,te descriptions, tewiki article
• Enwiki mandal pages not linked to Tewiki mandal pages in Andhra Pradesh (For merging to tewiki qid items or correction as appropriate)

• wikidata entity id, label, descriptions for a specific India census code (2011)
• AP districts post bifurcation of Telangana - 2011 Census Village and Town Directory reports
• AP Mandals population entries with refurl, retrieved, statedin values
• AP census report labels

districts edit

1. AP districts with enwikilinks
2. AP districts with enwikiname
3. AP districts with new or old flag and tewiki name
4. newly created districts of AP with tewiki article name
5. AP districts and district capitals
6. /AP district qids

mandals edit

• pagepile (id:55017) of 679 mandals as on 2024-02-26
• Pagepile (id:42128) of 670 mandals as on 2022-05-10

1. /mandals with new and old district tewiki articles

• Mandals in Andhra Pradesh, with districts, tewiki page_title
• Mandals in Andhra Pradesh with districts, enwiki article
• Mandals of AP after 2022 restructure (updated 2024-02-25)
• Mandal counts by district in Andhra Pradesh
• Mandals in a district

villages edit

1. All revenue village in Andhra Pradesh (16544 as on 2024-06-01)
   1. All inhabited revenue villages with tewiki article link in Andhra Pradesh (16152 as on 2024-06-01)
      1. All inhabited revenue villages with tewiki article link, coord location in Andhra Pradesh (14738 on 2024-06-01)
   2. All revenue villages with tewiki link, pop,area,location, postalcode
   3. All revenue villages with tewiki link with postal code
      1. All revenue villages with tewiki link without postal code
   4. /Village_pop_households
2. villages with P131 not a mandal in a specific district
3. Villages in a specific district with en,te labels having enwiki or tewiki article
4. villages in a set of mandals usally belonging to an assembly constituency which are assigned to another district
5. Villages in AP with census2011code for syncing data with https://lgdirectory.gov.in/ (15629 on 2024-03-30)
   1. Villages in AP with coordinates (4432 on 2024-03-30)
      1. Villages in AP with coordinates with source (1209 on 2024-03-30)
6. villages in a mandal for updating in osm via openrefine, osmcsvappender (2024-03-31)
7. Identify old id redirects for villages For fixing old ids on OSM
8. Villages in Andhra Pradesh via mandal, district without tewiki link
9. Villages located directly in Andhra Pradesh without tewiki link
10. Revenue village with its mandal in a district with coordinates on wikidata,tewiki article
    1. Revenue village with its mandal in a district with coordinates on wikidata,tewiki article with qid
    2. Revenue villages to show multiple administrative values for a district
11. timezone for village articles in AP to assist removal
12. multiple values for located in admin to assist cleanup
13. Script for identifying places (more than one) with same coordinates
14. Revenue villages with tewiki articles and coords but without wikidata in OSM in a district
15. /allvillages (subtract data from over pass query using spreadsheet VLOOKUP to get villages which do not have wikidata on OSM, as Sophox queries are timing out sometimes)
    1. villages with mandal info but without wikidata in OSM in name,qid order with wd prefix (for matching with overpass-turbo query)
       1. /villagewithoutwd
       2. /villagewithoutwd-mandalqidvillage
    2. Revenue villages with mandal info but without wikidata in OSM in name,qid order with wd prefix (for matching with overpass-turbo query)
16. Revenue villages needing coordinate info in wikidata in AP
    1. Revenue villages needing coordinate info in wikidata in AP with bare qid for matching with external data
    2. Revenue villages needing coordsinates info without English labels
17. Revenue villages without English/Telugu labels
18. village coordinate source info
    1. village coordinate source counts (need some improvement for geonames) (2024-05-01) for tracking coordinate me 2024
19. villages and their coord values count (desc) in AP (to clean up for more than one value)
20. villages which are not located in mandal
21. villages with OSM matched villages in a district (to compare with overpass turbo query to look for potential wikidata redirects of unmatched items)

others edit

1. /assembly constituencies with new and old district tewiki articles
2. assembly with old districts in AP
3. Assembly constituencies in a specific current district]
4. tewiki articles with location which are not of human settlement in a district for updating district name

• Indian actors with enwiki page but not tewiki page
• human settlements need fixing mandal
• Revenue division wise mandal map for use with <mapframe> on tewiki Tewiki prakasam district permalink

• Count of mandals by district in AP
• Count of revenue villages by district in AP (2024-04-08)
• Count of revenue villages without coordinate location by district in AP (2024-06-01) total 1553

• get wikidata of mandal and its headquarters

• Subregions with labels
• Subregions with Telugu labels
• mandal admin_centre locations with wikidata
• places count in OSM by district
• Places with node geometry in a Andhra Pradesh district by mandal (CSV)
• places in a district with wikidata if available, geometry and its mandal info (CSV)

• USA Governers

Mandal descriptions,district changes edit

•  Y All mandals descriptions, district changes done

Villages in new districts - descriptions edit

1.  Y http://www.wikidata.org/entity/Q110714857 అనకాపల్లి జిల్లా
2.  Y http://www.wikidata.org/entity/Q110714854 అన్నమయ్య జిల్లా
3.  Y http://www.wikidata.org/entity/Q110714850 అల్లూరి సీతారామరాజు జిల్లా
4.  Y http://www.wikidata.org/entity/Q110876763 ఎన్టీఆర్ జిల్లా
5.  Y http://www.wikidata.org/entity/Q110714851 ఏలూరు జిల్లా
6.  Y http://www.wikidata.org/entity/Q110714860 కాకినాడ జిల్లా
7.  Y http://www.wikidata.org/entity/Q110714859 డాక్టర్ బి.ఆర్. అంబేడ్కర్ కోనసీమ జిల్లా
8.  Y http://www.wikidata.org/entity/Q110714853 తిరుపతి జిల్లా
9.  Y http://www.wikidata.org/entity/Q110714861 నంద్యాల జిల్లా
10.  Y http://www.wikidata.org/entity/Q110714862 పల్నాడు జిల్లా
11.  Y http://www.wikidata.org/entity/Q110714856 పార్వతీపురం మన్యం జిల్లా
12.  Y http://www.wikidata.org/entity/Q110876712 బాపట్ల జిల్లా
13.  Y http://www.wikidata.org/entity/Q110714863 శ్రీ సత్యసాయి జిల్లా

Villages in old districts - descriptions (updates if needed) edit

1.  Y http://www.wikidata.org/entity/Q15212 అనంతపురం జిల్లా
2.  Y http://www.wikidata.org/entity/Q15381 కర్నూలు జిల్లా
3.  Y http://www.wikidata.org/entity/Q15382 కృష్ణా జిల్లా
4.  Y http://www.wikidata.org/entity/Q15341 గుంటూరు జిల్లా
5.  Y http://www.wikidata.org/entity/Q15213 చిత్తూరు జిల్లా
6.  Y http://www.wikidata.org/entity/Q15338 తూర్పు గోదావరి జిల్లా (పశ్చిమగోదావరి జిల్లా ప్రాంతం నుండి కలిసినదానికి మార్పులు చేయబడినవి)
7.  Y http://www.wikidata.org/entity/Q15404 పశ్చిమ గోదావరి జిల్లా
8.  Y http://www.wikidata.org/entity/Q15390 ప్రకాశం జిల్లా
9.  Y http://www.wikidata.org/entity/Q15392 విజయనగరం జిల్లా (శ్రీకాకుళం జిల్లా నుండి కలిసిన ప్రాంతానికి మార్పులు చేయబడినవి)
10.  Y http://www.wikidata.org/entity/Q15394 విశాఖపట్నం జిల్లా
11.  Y http://www.wikidata.org/entity/Q15342 వైఎస్ఆర్ జిల్లా
12.  Y http://www.wikidata.org/entity/Q15383 శ్రీ పొట్టి శ్రీరాములు నెల్లూరు జిల్లా (ప్రకాశం జిల్లా నుండి కలిసిన ప్రాంతానికి మార్పులు చేయబడినవి)
13.  Y http://www.wikidata.org/entity/Q15395 శ్రీకాకుళం జిల్లా

• category members which are pages for Districts of Andhra Pradesh

• District headquarters of Andhra Pradesh - pagepile 48913,
• osm places with wikidata with corresponding enwiki pagepile 57069 (pages 1454)
• osm places with wikidata with corresponding tewiki pagepile 57070 (pages 1524)
• villages in AP requiring coordinates pagepile 58253 (12939 pages as on 2024-01-08)
• villages in AP requiring coordinates pagepile 58321 (5635 pages as on 2024-01-13)

• Coordinate Me AP Project page: https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Andhra_Pradesh/Coordinate_Me_2024
• RV with P625 in wikidata as on 2024-04-30 after deduplication cleanup (pages 2957)
• villages without coordinates
• Changes in a geographical area of Andhra Pradesh as defined by its bounding box in the last 24 hours
  • Changes in a geographical area of Andhra Pradesh filtered to a census village
• Bapatla todo
• Q125798966 Bharat Map Services for use with panchayat database
• Q125616557 Andhra Pradesh State GIS Portal , for use with manual update of coordinate locations
• Q125757386 PMGSY Habitations Dataset
• Q125747325 eGramSwaraj
• Enwiki article not having coord on wikidata in AP
• Telugu wiki villages not having P131, P625 on wikidata (petscan query)

• pagepile 58567: tewiki villages edited during May 2024 (14820/16811 pages, petscan query result from intersection of tewiki village category with wd query for previous 30 day edits in bounding box of Andhra Pradesh run on 1 June 2024 at 05:39AM)
• villages with block code in a district

• distance errors between wikidata and OSM for places in a district (timing out)