User:Arjunaraoc
Jump to navigation
Jump to search
Please see:
Babel user information | ||||
---|---|---|---|---|
| ||||
Users by language |
Notes
[edit]Wikidata+OSM queries
[edit]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:>
- 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
[edit]Data as per after reorg in 2022
[edit]- 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
[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
[edit]petscan 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)
- 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
[edit]districts
[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
[edit]- /assembly constituencies with new and old district tewiki articles
- assembly with old districts in AP
- Assembly constituencies in a specific current district]
- tewiki articles with location which are not of human settlement in a district for updating district name
MISC queries
[edit]- 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
[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
[edit]Overpass turbo
[edit]- 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
[edit]AP District reorganisation 2022 changes status
[edit]Mandal 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
[edit]page 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
[edit]- basic wikidata query
- Basic osm-planet query
- Difference between osmloc and wdloc (federated) for places in a district
- Difference between osmloc and wdloc (federated) for places in AP districtwise
Wikidata 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)
- Petscan+Wikidata for current Revenue villages which do not have Infobox India AP Village template
- tewiki articlces without Wikidata item(?)