Arjunaraoc
Joined 27 November 2012
Please see:
Babel user information | ||||
---|---|---|---|---|
| ||||
Users by language |
Notes
editWikidata+OSM queries
editOnly 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:>
- 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
Sample Queries
edit- 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
edit- 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
editData as per after reorg in 2022
editmwapi integrated queries
edit- 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
Commons queries
editpetscan with wikidata
edit- 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
edit- 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)
Wikipedia maintenance queries
editdistricts
edit- AP districts with enwikilinks
- AP districts with enwikiname
- AP districts with new or old flag and tewiki name
- newly created districts of AP with tewiki article name
- AP districts and district capitals
- /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
- 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- All revenue village in Andhra Pradesh (16544 as on 2024-06-01)
- villages with P131 not a mandal in a specific district
- Villages in a specific district with en,te labels having enwiki or tewiki article
- villages in a set of mandals usally belonging to an assembly constituency which are assigned to another district
- Villages in AP with census2011code for syncing data with https://lgdirectory.gov.in/ (15629 on 2024-03-30)
- Villages in AP with coordinates (4432 on 2024-03-30)
- Villages in AP with coordinates with source (1209 on 2024-03-30)
- Villages in AP with coordinates (4432 on 2024-03-30)
- villages in a mandal for updating in osm via openrefine, osmcsvappender (2024-03-31)
- Identify old id redirects for villages For fixing old ids on OSM
- Villages in Andhra Pradesh via mandal, district without tewiki link
- Villages located directly in Andhra Pradesh without tewiki link
- Revenue village with its mandal in a district with coordinates on wikidata,tewiki article
- timezone for village articles in AP to assist removal
- multiple values for located in admin to assist cleanup
- Script for identifying places (more than one) with same coordinates
- Revenue villages with tewiki articles and coords but without wikidata in OSM in a district
- /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)
- villages with mandal info but without wikidata in OSM in name,qid order with wd prefix (for matching with overpass-turbo query)
- Revenue villages with mandal info but without wikidata in OSM in name,qid order with wd prefix (for matching with overpass-turbo query)
- Revenue villages needing coordinate info in wikidata in AP
- Revenue villages without English/Telugu labels
- village coordinate source info
- village coordinate source counts (need some improvement for geonames) (2024-05-01) for tracking coordinate me 2024
- villages and their coord values count (desc) in AP (to clean up for more than one value)
- villages which are not located in mandal
- villages with OSM matched villages in a district (to compare with overpass turbo query to look for potential wikidata redirects of unmatched items)
others
editMISC queries
editCounts
edit- 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
Sophox queries
editOverpass turbo
editImages from wikidata
editAP District reorganisation 2022 changes status
editMandal descriptions,district changes
edit- All mandals descriptions, district changes done
Villages in new districts - descriptions
edit- http://www.wikidata.org/entity/Q110714857 అనకాపల్లి జిల్లా
- http://www.wikidata.org/entity/Q110714854 అన్నమయ్య జిల్లా
- http://www.wikidata.org/entity/Q110714850 అల్లూరి సీతారామరాజు జిల్లా
- http://www.wikidata.org/entity/Q110876763 ఎన్టీఆర్ జిల్లా
- http://www.wikidata.org/entity/Q110714851 ఏలూరు జిల్లా
- http://www.wikidata.org/entity/Q110714860 కాకినాడ జిల్లా
- http://www.wikidata.org/entity/Q110714859 డాక్టర్ బి.ఆర్. అంబేడ్కర్ కోనసీమ జిల్లా
- http://www.wikidata.org/entity/Q110714853 తిరుపతి జిల్లా
- http://www.wikidata.org/entity/Q110714861 నంద్యాల జిల్లా
- http://www.wikidata.org/entity/Q110714862 పల్నాడు జిల్లా
- http://www.wikidata.org/entity/Q110714856 పార్వతీపురం మన్యం జిల్లా
- http://www.wikidata.org/entity/Q110876712 బాపట్ల జిల్లా
- http://www.wikidata.org/entity/Q110714863 శ్రీ సత్యసాయి జిల్లా
Villages in old districts - descriptions (updates if needed)
edit- http://www.wikidata.org/entity/Q15212 అనంతపురం జిల్లా
- http://www.wikidata.org/entity/Q15381 కర్నూలు జిల్లా
- http://www.wikidata.org/entity/Q15382 కృష్ణా జిల్లా
- http://www.wikidata.org/entity/Q15341 గుంటూరు జిల్లా
- http://www.wikidata.org/entity/Q15213 చిత్తూరు జిల్లా
- http://www.wikidata.org/entity/Q15338 తూర్పు గోదావరి జిల్లా (పశ్చిమగోదావరి జిల్లా ప్రాంతం నుండి కలిసినదానికి మార్పులు చేయబడినవి)
- http://www.wikidata.org/entity/Q15404 పశ్చిమ గోదావరి జిల్లా
- http://www.wikidata.org/entity/Q15390 ప్రకాశం జిల్లా
- http://www.wikidata.org/entity/Q15392 విజయనగరం జిల్లా (శ్రీకాకుళం జిల్లా నుండి కలిసిన ప్రాంతానికి మార్పులు చేయబడినవి)
- http://www.wikidata.org/entity/Q15394 విశాఖపట్నం జిల్లా
- http://www.wikidata.org/entity/Q15342 వైఎస్ఆర్ జిల్లా
- http://www.wikidata.org/entity/Q15383 శ్రీ పొట్టి శ్రీరాములు నెల్లూరు జిల్లా (ప్రకాశం జిల్లా నుండి కలిసిన ప్రాంతానికి మార్పులు చేయబడినవి)
- http://www.wikidata.org/entity/Q15395 శ్రీకాకుళం జిల్లా
mwapi examples
editpage pile
edit- 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 2024 tracking
edit- 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
- 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
Qlever queries
editWikidata based AP Revenue village infobox setup
edit- Petscan query for AP villages with images
- Tewiki Revenue villages with images in Wikidata
- Tewiki pages using Infobox India AP Village template with admin hierarchy
- bare madal labels of SPSNellore, Prakasam Bapatla for matching with PMGSY data of united Prakasam district
- Tewiki pages using Infobox India AP Village template in erstwhile Prakasam needing coordinates
- /images needing telugu captions
- /AP Revenue villages for updating with Infobox India AP Village needing telugu captions
- Petscan+Wikidata query for update of infbox of villages (14997 on 2024-06-26)