query-e82a09e583325b6fd856f9abaa11b4c6
Wolfgang8741(P625)coordinate location (P590)GNIS Feature ID (P590)GNIS Feature ID
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX geo: <http://www.opengis.net/ont/geosparql#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Map
SELECT DISTINCT ?place ?placeLabel ?location ?layer ?distance WHERE {
{
{
SELECT ?place ?gnisPt ?distance WHERE {
VALUES (?place ?name ?gnisPt ?gnisid ?distance) {
(wd:Q7363321 "Shadehill Reservoir" "Point(-102.2572521,45.731476)"^^geo:wktLiteral "1261165" "4.883"^^xsd:double )
(wd:Q6475393 "Lake Claiborne" "Point(-92.9607898,32.7581515)"^^geo:wktLiteral "553994" "5.434"^^xsd:double )
(wd:Q7331554 "Somerville Lake" "Point(-96.5862171,30.3115649)"^^geo:wktLiteral "1376179" "5.846"^^xsd:double )
(wd:Q6477811 "Lake Springfield" "Point(-89.6079334,39.706848)"^^geo:wktLiteral "419006" "5.884"^^xsd:double )
(wd:Q6476037 "Lake Greeson" "Point(-93.789557,34.2410144)"^^geo:wktLiteral "75726" "6.39"^^xsd:double )
(wd:Q6475467 "Lake Corpus Christi" "Point(-97.8646671,28.0435748)"^^geo:wktLiteral "1861919" "6.615"^^xsd:double )
(wd:Q5181892 "Cranberry Lake" "Point(-74.8852263,44.125427)"^^geo:wktLiteral "976197" "7.143"^^xsd:double )
(wd:Q6477632 "Lake San Antonio" "Point(-120.9011529,35.8082364)"^^geo:wktLiteral "254200" "7.638"^^xsd:double )
(wd:Q451522 "Lake Havasu" "Point(-114.3128939,34.4343676)"^^geo:wktLiteral "243280" "8.447"^^xsd:double )
(wd:Q6477985 "Lake Tawakoni" "Point(-95.9923037,32.8821102)"^^geo:wktLiteral "1376396" "10.617"^^xsd:double )
}
FILTER EXISTS { ?place wdt:P590 [] }
}
} ?place wdt:P625 ?location.
BIND( 'wiki' as ?layer )
} UNION {
{
SELECT ?place ?gnisPt ?distance WHERE {
VALUES (?place ?name ?gnisPt ?gnisid ?distance) {
(wd:Q7363321 "Shadehill Reservoir" "Point(-102.2572521,45.731476)"^^geo:wktLiteral "1261165" "4.883"^^xsd:double )
(wd:Q6475393 "Lake Claiborne" "Point(-92.9607898,32.7581515)"^^geo:wktLiteral "553994" "5.434"^^xsd:double )
(wd:Q7331554 "Somerville Lake" "Point(-96.5862171,30.3115649)"^^geo:wktLiteral "1376179" "5.846"^^xsd:double )
(wd:Q6477811 "Lake Springfield" "Point(-89.6079334,39.706848)"^^geo:wktLiteral "419006" "5.884"^^xsd:double )
(wd:Q6476037 "Lake Greeson" "Point(-93.789557,34.2410144)"^^geo:wktLiteral "75726" "6.39"^^xsd:double )
(wd:Q6475467 "Lake Corpus Christi" "Point(-97.8646671,28.0435748)"^^geo:wktLiteral "1861919" "6.615"^^xsd:double )
(wd:Q5181892 "Cranberry Lake" "Point(-74.8852263,44.125427)"^^geo:wktLiteral "976197" "7.143"^^xsd:double )
(wd:Q6477632 "Lake San Antonio" "Point(-120.9011529,35.8082364)"^^geo:wktLiteral "254200" "7.638"^^xsd:double )
(wd:Q451522 "Lake Havasu" "Point(-114.3128939,34.4343676)"^^geo:wktLiteral "243280" "8.447"^^xsd:double )
(wd:Q6477985 "Lake Tawakoni" "Point(-95.9923037,32.8821102)"^^geo:wktLiteral "1376396" "10.617"^^xsd:double )
}
FILTER EXISTS { ?place wdt:P590 [] }
}
} BIND( ?gnisPt AS ?location )
BIND( 'gnis' as ?layer )
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?label
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v9("?distance"):::projected
v9("?gnisPt")
v9("?gnisid")
v1("?label")
v9("?layer"):::projected
v9("?location"):::projected
v9("?name")
v9("?place"):::projected
a1((" "))
a2((" "))
c4(["bd:serviceParam"]):::iri
c6(["#91;AUTO_LANGUAGE#93;,en"]):::literal
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
f0[[" "]]
subgraph f0e0["Exists Clause"]
e0v1 --"wdt:P590"--> e0a1
e0v1("?place"):::projected
e0a1((" ")):::projected
end
f0--EXISTS--> f0e0
f0 --> v9
f0 --> c1
f0 --> a2
v9 --"wdt:P590"--> a2
bind1[/VALUES ?distance ?gnisPt ?gnisid ?name ?place/]
bind1-->v9
bind1-->v9
bind1-->v9
bind1-->v9
bind1-->v9
bind10(["wd:Q7363321"])
bind10 --> bind1
bind11(["Shadehill Reservoir"])
bind11 --> bind1
bind12([sPoint(-102.2572521,45.731476)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind12 --> bind1
bind13(["1261165"])
bind13 --> bind1
bind14(["4.883^^xsd:double"])
bind14 --> bind1
bind15(["wd:Q6475393"])
bind15 --> bind1
bind16(["Lake Claiborne"])
bind16 --> bind1
bind17([sPoint(-92.9607898,32.7581515)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind17 --> bind1
bind18(["553994"])
bind18 --> bind1
bind19(["5.434^^xsd:double"])
bind19 --> bind1
bind110(["wd:Q7331554"])
bind110 --> bind1
bind111(["Somerville Lake"])
bind111 --> bind1
bind112([sPoint(-96.5862171,30.3115649)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind112 --> bind1
bind113(["1376179"])
bind113 --> bind1
bind114(["5.846^^xsd:double"])
bind114 --> bind1
bind115(["wd:Q6477811"])
bind115 --> bind1
bind116(["Lake Springfield"])
bind116 --> bind1
bind117([sPoint(-89.6079334,39.706848)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind117 --> bind1
bind118(["419006"])
bind118 --> bind1
bind119(["5.884^^xsd:double"])
bind119 --> bind1
bind120(["wd:Q6476037"])
bind120 --> bind1
bind121(["Lake Greeson"])
bind121 --> bind1
bind122([sPoint(-93.789557,34.2410144)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind122 --> bind1
bind123(["75726"])
bind123 --> bind1
bind124(["6.39^^xsd:double"])
bind124 --> bind1
bind125(["wd:Q6475467"])
bind125 --> bind1
bind126(["Lake Corpus Christi"])
bind126 --> bind1
bind127([sPoint(-97.8646671,28.0435748)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind127 --> bind1
bind128(["1861919"])
bind128 --> bind1
bind129(["6.615^^xsd:double"])
bind129 --> bind1
bind130(["wd:Q5181892"])
bind130 --> bind1
bind131(["Cranberry Lake"])
bind131 --> bind1
bind132([sPoint(-74.8852263,44.125427)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind132 --> bind1
bind133(["976197"])
bind133 --> bind1
bind134(["7.143^^xsd:double"])
bind134 --> bind1
bind135(["wd:Q6477632"])
bind135 --> bind1
bind136(["Lake San Antonio"])
bind136 --> bind1
bind137([sPoint(-120.9011529,35.8082364)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind137 --> bind1
bind138(["254200"])
bind138 --> bind1
bind139(["7.638^^xsd:double"])
bind139 --> bind1
bind140(["wd:Q451522"])
bind140 --> bind1
bind141(["Lake Havasu"])
bind141 --> bind1
bind142([sPoint(-114.3128939,34.4343676)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind142 --> bind1
bind143(["243280"])
bind143 --> bind1
bind144(["8.447^^xsd:double"])
bind144 --> bind1
bind145(["wd:Q6477985"])
bind145 --> bind1
bind146(["Lake Tawakoni"])
bind146 --> bind1
bind147([sPoint(-95.9923037,32.8821102)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind147 --> bind1
bind148(["1376396"])
bind148 --> bind1
bind149(["10.617^^xsd:double"])
bind149 --> bind1
bind2[/"?gnisPt"/]
v9 --o bind2
bind2 --as--o v9
bind3[/"'gnis'"/]
bind3 --as--o v9
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
f4[[" "]]
subgraph f4e1["Exists Clause"]
e1v1 --"wdt:P590"--> e1a1
e1v1("?place"):::projected
e1a1((" ")):::projected
end
f4--EXISTS--> f4e1
f4 --> v9
f4 --> c1
f4 --> a1
v9 --"wdt:P590"--> a1
bind5[/VALUES ?distance ?gnisPt ?gnisid ?name ?place/]
bind5-->v9
bind5-->v9
bind5-->v9
bind5-->v9
bind5-->v9
bind50(["wd:Q7363321"])
bind50 --> bind5
bind51(["Shadehill Reservoir"])
bind51 --> bind5
bind52([sPoint(-102.2572521,45.731476)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind52 --> bind5
bind53(["1261165"])
bind53 --> bind5
bind54(["4.883^^xsd:double"])
bind54 --> bind5
bind55(["wd:Q6475393"])
bind55 --> bind5
bind56(["Lake Claiborne"])
bind56 --> bind5
bind57([sPoint(-92.9607898,32.7581515)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind57 --> bind5
bind58(["553994"])
bind58 --> bind5
bind59(["5.434^^xsd:double"])
bind59 --> bind5
bind510(["wd:Q7331554"])
bind510 --> bind5
bind511(["Somerville Lake"])
bind511 --> bind5
bind512([sPoint(-96.5862171,30.3115649)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind512 --> bind5
bind513(["1376179"])
bind513 --> bind5
bind514(["5.846^^xsd:double"])
bind514 --> bind5
bind515(["wd:Q6477811"])
bind515 --> bind5
bind516(["Lake Springfield"])
bind516 --> bind5
bind517([sPoint(-89.6079334,39.706848)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind517 --> bind5
bind518(["419006"])
bind518 --> bind5
bind519(["5.884^^xsd:double"])
bind519 --> bind5
bind520(["wd:Q6476037"])
bind520 --> bind5
bind521(["Lake Greeson"])
bind521 --> bind5
bind522([sPoint(-93.789557,34.2410144)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind522 --> bind5
bind523(["75726"])
bind523 --> bind5
bind524(["6.39^^xsd:double"])
bind524 --> bind5
bind525(["wd:Q6475467"])
bind525 --> bind5
bind526(["Lake Corpus Christi"])
bind526 --> bind5
bind527([sPoint(-97.8646671,28.0435748)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind527 --> bind5
bind528(["1861919"])
bind528 --> bind5
bind529(["6.615^^xsd:double"])
bind529 --> bind5
bind530(["wd:Q5181892"])
bind530 --> bind5
bind531(["Cranberry Lake"])
bind531 --> bind5
bind532([sPoint(-74.8852263,44.125427)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind532 --> bind5
bind533(["976197"])
bind533 --> bind5
bind534(["7.143^^xsd:double"])
bind534 --> bind5
bind535(["wd:Q6477632"])
bind535 --> bind5
bind536(["Lake San Antonio"])
bind536 --> bind5
bind537([sPoint(-120.9011529,35.8082364)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind537 --> bind5
bind538(["254200"])
bind538 --> bind5
bind539(["7.638^^xsd:double"])
bind539 --> bind5
bind540(["wd:Q451522"])
bind540 --> bind5
bind541(["Lake Havasu"])
bind541 --> bind5
bind542([sPoint(-114.3128939,34.4343676)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind542 --> bind5
bind543(["243280"])
bind543 --> bind5
bind544(["8.447^^xsd:double"])
bind544 --> bind5
bind545(["wd:Q6477985"])
bind545 --> bind5
bind546(["Lake Tawakoni"])
bind546 --> bind5
bind547([sPoint(-95.9923037,32.8821102)^^<http://www.opengis.net/ont/geosparql#wktLiteral>"])
bind547 --> bind5
bind548(["1376396"])
bind548 --> bind5
bind549(["10.617^^xsd:double"])
bind549 --> bind5
v9 --"wdt:P625"--> v9
bind6[/"'wiki'"/]
bind6 --as--o v9
end
union0r <== or ==> union0l
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c4 --"wikibase:language"--> c6
end