User:Andree.sk/Wikidata Tests

From Wikivoyage
Jump to navigation Jump to search

wikidata query for WP:en around the item:

# Select the ItemId, label and coordinate location
SELECT ?place ?placeLabel ?location
WHERE {
 # Select the coordinate location(P625) of Q1544186 as the centeral coordinate ?mainLoc
 wd:Q1544186 wdt:P625 ?mainLoc . 
  
 # Use the around service
 SERVICE wikibase:around { 
   # Looking for items with coordinate locations(P625)
   ?place wdt:P625 ?location . 
   # That are in a circle with a centre of ?mainLoc
   bd:serviceParam wikibase:center ?mainLoc . 
   # Where the circle has a radius of 10km
   bd:serviceParam wikibase:radius "2" . 
 }

  FILTER EXISTS {
   ?article schema:about ?place .
   ?article schema:isPartOf <https://en.wikipedia.org/>.
  }
  
 # Use the label service to get the English label
 SERVICE wikibase:label {
   bd:serviceParam wikibase:language "en" . 
 }
}
LIMIT 20


# Select the ItemId, label and coordinate location
SELECT ?place ?placeLabel ?location
WHERE {
 # Select the coordinate location(P625) of Q1544186 as the centeral coordinate ?mainLoc
 wd:Q11811375 wdt:P625 ?mainLoc . 
  
 # Use the around service
 SERVICE wikibase:around { 
   # Looking for items with coordinate locations(P625)
   ?place wdt:P625 ?location . 
   # That are in a circle with a centre of ?mainLoc
   bd:serviceParam wikibase:center ?mainLoc . 
   # Where the circle has a radius of 10km
   bd:serviceParam wikibase:radius "15" . 
 }

  FILTER EXISTS {
   ?article schema:about ?place .
   ?article schema:isPartOf <https://sl.wikipedia.org/>.
  }
  
  MINUS{?place wdt:P31/wdt:P279? wd:Q15284}
  MINUS{?place wdt:P31/wdt:P279? wd:Q123964505}
  
 # Use the label service to get the English label
 SERVICE wikibase:label {
   bd:serviceParam wikibase:language "en" . 
 }
}
LIMIT 200