Project:SPARQL/gis

GIS export queries

Archaeological Periods and Categories

Exporting data from wikibase to other GIS tools after you run the query you need to download the results as a csv file and then import that file to a GIS tool .

PREFIX wd: <https://timna-database.wikibase.cloud/entity/>
PREFIX wdt: <https://timna-database.wikibase.cloud/prop/direct/>
PREFIX p: <https://timna-database.wikibase.cloud/prop/>
PREFIX ps: <https://timna-database.wikibase.cloud/prop/statement/>
PREFIX geo: <http://www.opengis.net/ont/geosparql#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?entity ?entityLabel ?coordinate (GROUP_CONCAT(DISTINCT ?periodLabel; separator=", ") AS ?periodLabels) (GROUP_CONCAT(DISTINCT ?categoryLabel; separator=", ") AS ?categories) ?longitude ?latitude
WHERE {
  ?entity wdt:P28 ?coordinate .
  
  # Ensure the entity is a smelting site
  ?entity p:P94 ?smeltingStatement .
  ?smeltingStatement ps:P94 wd:Q89 .

  # Get all categories associated with P94
  ?entity p:P94 ?statement .
  ?statement ps:P94 ?category .
  ?category rdfs:label ?categoryLabel .
  FILTER (lang(?categoryLabel) = "en")

  ?entity rdfs:label ?entityLabel .
  FILTER (lang(?entityLabel) = "en")

  # Optional properties for longitude and latitude
  OPTIONAL { ?entity wdt:P26 ?longitude . }
  OPTIONAL { ?entity wdt:P27 ?latitude . }

  # Get the period labels if available
  OPTIONAL {
    ?entity wdt:P93 ?period .
    ?period rdfs:label ?periodLabel .
    FILTER (lang(?periodLabel) = "en")
  }
}
GROUP BY ?entity ?entityLabel ?coordinate ?longitude ?latitude
LIMIT 300

Try it!

GIS queries

Site Polygon

Polygon of site 002.

PREFIX wd: <https://timna-database.wikibase.cloud/entity/>
PREFIX wdt: <https://timna-database.wikibase.cloud/prop/direct/>
PREFIX p: <https://timna-database.wikibase.cloud/prop/>
PREFIX ps: <https://timna-database.wikibase.cloud/prop/statement/>
PREFIX geo: <http://www.opengis.net/ont/geosparql#>

SELECT ?site ?siteLabel ?geojsonFile #?mapLabel
WHERE {
  VALUES ?site { wd:Q507 }  # Site 002
  ?site wdt:P176 ?geojsonFile .  # Retrieve the linked GeoJSON file
  #?site wdt:P177 ?mapLabel .  # Retrieve the label stored in P177

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

LIMIT 300 
##defaultView:Map

Try it!