query-0337442e36e2a6d6a8d250343b6908a7

rq turtle/ttl

Events happened in a certain geo box

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#>
SELECT ?item ?itemLabel ?location ?pointInTime WHERE {
  # Define the modern country (e.g., Russia as wd:Q159)
  VALUES ?modernCountry { wd:Q29 }

  # Get the modern country's bounding points
  ?modernCountry wdt:P1332 ?northernPoint .
  ?modernCountry wdt:P1333 ?southernPoint .
  ?modernCountry wdt:P1334 ?easternPoint .
  ?modernCountry wdt:P1335 ?westernPoint .

  # Subquery to fetch a limited sample of battle items (would time out otherwise for some countries with lots of items)
  {
    SELECT ?item WHERE {
      ?item wdt:P31/wdt:P279* wd:Q178561. # Filter for instances of battles
    } 
    LIMIT 5000
  }

  # Use these points to define the bounding box
  SERVICE wikibase:box {
    ?item wdt:P625 ?location .
    bd:serviceParam wikibase:cornerWest ?westernPoint .
    bd:serviceParam wikibase:cornerEast ?easternPoint .
    bd:serviceParam wikibase:cornerNorth ?northernPoint .
    bd:serviceParam wikibase:cornerSouth ?southernPoint .
  }

  OPTIONAL { ?item wdt:P585 ?pointInTime. }

  # Fetch labels for the final result set
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

• https://www.wikidata.org/wiki/User:Nastoshka/SPARLQ-Queries