7,354
edits
Project:SPARQL/examples: Difference between revisions
→All places (by coordinate location on wikidata), filtering out places already listed as instance of location
| 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 | ||
?place bnwdt:P117 ?Qnumber . #get wikidata ID | |||
FILTER NOT EXISTS {?place bnwdt:P12 bnwd:Q2144 .} #filter out places already listed as instance of location | FILTER NOT EXISTS {?place bnwdt:P12 bnwd:Q2144 .} #filter out places already listed as instance of location | ||
#create reference to Wikibase entity | #create reference to Wikibase entity | ||