Arjunaraoc
Joined 27 November 2012
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 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 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
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
- 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 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
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
- villages in a set of mandals usally belonging to an assembly constituency which are assigned to another district
- Villages in a mandal
- 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 villages with enwiki articles and wikidata coordinates for a district
- timezone for village articles in AP to assist removal
- multiple values for located in admin to assist cleanup
others edit
MISC queries edit
Counts edit
Sophox queries edit
Overpass turbo edit
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 శ్రీకాకుళం జిల్లా