User:Arjunaraoc

Please see:

Babel user information
te-N ఈ వాడుకరి మాతృభాష తెలుగు. en-4 This user has near native speaker knowledge of English. hi-3 इस सदस्य को हिन्दी का उच्च स्तर का ज्ञान है। kn-2 ಈ ಬಳಕೆದಾರರಿಗೆ ಕನ್ನಡ ಭಾಷೆ ಬಗ್ಗೆ ಮಧ್ಯಮ ಮಟ್ಟದ ಜ್ಞಾನವಿದೆ
Users by language

Notes

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

Wikidata+OSM queries

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

• 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)
• place location in an admin area as per wikidata to generate geojson using openrefine

Sample Queries

• 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)

AP Queries

• 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.

Data as per before reorg in 2022

• Mandals of Prakasam district prior to reorg in 2022

Data as per after 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)

mwapi integrated queries

• 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

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

petscan with wikidata

• 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)

Wikidata Maintenance queries

• 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

Wikipedia maintenance queries

districts

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

mandals

• 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

1. villages in a set of mandals usally belonging to an assembly constituency which are assigned to another district
2. Villages in a mandal
3. 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)
4. villages in a mandal for updating in osm via openrefine, osmcsvappender (2024-03-31)
5. Identify old id redirects for villages For fixing old ids on OSM
6. Villages in Andhra Pradesh via mandal, district without tewiki link
7. Villages located directly in Andhra Pradesh without tewiki link
8. 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
9. timezone for village articles in AP to assist removal
10. multiple values for located in admin to assist cleanup
11. Script for identifying places (more than one) with same coordinates
12. Revenue villages with tewiki articles and coords but without wikidata in OSM in a district
13. Revenue villages with mandal info but without wikidata in OSM in name,qid order with wd prefix (for matching with overpass-turbo query)
14. 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
15. village coordinate source info
    1. village coordinate source counts (need some imp for geonames) (2024-05-01) for tracking coordinate me 2024
16. villages which are not located in mandal

others

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

MISC queries

• 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

Counts

• Count of mandals by district in AP
• Count of revenue villages by district in AP (2024-04-08)

Sophox queries

• get wikidata of mandal and its headquarters

Overpass turbo

• 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)

Images from wikidata

• USA Governers

AP District reorganisation 2022 changes status

Mandal descriptions,district changes

• Y All mandals descriptions, district changes done

Villages in new districts - descriptions

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)

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 శ్రీకాకుళం జిల్లా

mwapi examples

• category members which are pages for Districts of Andhra Pradesh

page pile

• 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)

Coordinate Me 2024 tracking

• 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