7,354
edits
Project:SPARQL/examples: Difference between revisions
→All places (by coordinate location on wikidata)
| Line 537: | Line 537: | ||
</sparql> | </sparql> | ||
===All places (by coordinate location on wikidata)=== | ===All places (by coordinate location on wikidata), filtering out places already listed as instance of location=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# All places (by coordinate location on wikidata) | # All places (by coordinate location on wikidata), filtering out places already listed as instance of location | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
| Line 559: | Line 559: | ||
WHERE { | WHERE { | ||
?place bnwdt:P33 ?admin_area . #select items with 'located in the administrative territorial entity' statements | ?place bnwdt:P33 ?admin_area . #select items with 'located in the administrative territorial entity' statements | ||
FILTER NOT EXISTS {?place bnwdt:P12 bnwd:Q2144 .} #filter out places already listed as instance of location | |||
?place bnwdt:P117 ?Qnumber . #get wikidata ID | ?place bnwdt:P117 ?Qnumber . #get wikidata ID | ||