query-d1edaefd3f7a9e039fcedf40b2ac4490
Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100 Population of cities and towns in Denmark and their OSM relation id
This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } VALUES ?town_or_city { wd:Q3957 wd:Q515 } ?city (wdt:P31/(wdt:P279*)) ?town_or_city; wdt:P17 wd:Q35. OPTIONAL { ?city wdt:P1082 ?population. } OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. } } LIMIT 100
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Population of cities and towns in Denmark and their OSM relation id
# This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
VALUES ?town_or_city {
wd:Q3957
wd:Q515
}
?city (wdt:P31/(wdt:P279*)) ?town_or_city;
wdt:P17 wd:Q35.
OPTIONAL { ?city wdt:P1082 ?population. }
OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. }
}
LIMIT 100
Query found at
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ar
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/be-tarask
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ca
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/cs
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/da
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/de
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/en
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/en-gb
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/eo
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/es
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/eu
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/fr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/he
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/hy
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/id
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/it
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ja
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ko
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/lb
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/lt
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ms
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/nl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/pl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/pt-br
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ro
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ru
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/si
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/sv
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/th
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/tr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/uk
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/vec
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/zh