User:Wladek92/test/page1
< User:Wladek92 | test
Glaciers map
[edit]SPARQL 5
[edit]- Items used: glacier (Q35666)
- Properties used: instance of (P31)
, subclass of (P279)
, coordinate location (P625)
, area (P2046)
- Features used: map (Q24515275)
# by Jura1, 2021-05-21
# defaultView:Map{"hide":["?coor","?area_scale_km"], "layer": "?area_scale_km"}
SELECT ?item ?itemLabel ?itemDescription ?coor ?area_sqkm ?area_scale_km
{
?item wdt:P31/wdt:P279* wd:Q35666 .
OPTIONAL { ?item wdt:P625 ?coor }
OPTIONAL { ?item p:P2046 [ a wikibase:BestRank; psn:P2046/wikibase:quantityAmount ?area_sqm ] .
BIND( ROUND(?area_sqm/10000)/100 as ?area_sqkm)
BIND( strlen(str(ROUND(?area_sqm/1000000))) as ?area_scale_km)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
- Sparql no tiltle
# by Jura1, 2021-05-21
# defaultView:Map{"hide":["?coor","?area_scale_km"], "layer": "?area_scale_km"}
SELECT ?item ?itemLabel ?itemDescription ?coor ?area_sqkm ?area_scale_km
{
?item wdt:P31/wdt:P279* wd:Q35666 .
OPTIONAL { ?item wdt:P625 ?coor }
OPTIONAL { ?item p:P2046 [ a wikibase:BestRank; psn:P2046/wikibase:quantityAmount ?area_sqm ] .
BIND( ROUND(?area_sqm/10000)/100 as ?area_sqkm)
BIND( strlen(str(ROUND(?area_sqm/1000000))) as ?area_scale_km)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
- sparql + title
# by Jura1, 2021-05-21
#title:Glaciers map
# defaultView:Map{"hide":["?coor","?area_scale_km"], "layer": "?area_scale_km"}
SELECT ?item ?itemLabel ?itemDescription ?coor ?area_sqkm ?area_scale_km
{
?item wdt:P31/wdt:P279* wd:Q35666 .
OPTIONAL { ?item wdt:P625 ?coor }
OPTIONAL { ?item p:P2046 [ a wikibase:BestRank; psn:P2046/wikibase:quantityAmount ?area_sqm ] .
BIND( ROUND(?area_sqm/10000)/100 as ?area_sqkm)
BIND( strlen(str(ROUND(?area_sqm/1000000))) as ?area_scale_km)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
- sparql title translated
# by Jura1, 2021-05-21
#title:Glaciers map
# defaultView:Map{"hide":["?coor","?area_scale_km"], "layer": "?area_scale_km"}
SELECT ?item ?itemLabel ?itemDescription ?coor ?area_sqkm ?area_scale_km
{
?item wdt:P31/wdt:P279* wd:Q35666 .
OPTIONAL { ?item wdt:P625 ?coor }
OPTIONAL { ?item p:P2046 [ a wikibase:BestRank; psn:P2046/wikibase:quantityAmount ?area_sqm ] .
BIND( ROUND(?area_sqm/10000)/100 as ?area_sqkm)
BIND( strlen(str(ROUND(?area_sqm/1000000))) as ?area_scale_km)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}