Project:SPARQL/starters: Difference between revisions
From Timna Valley Database
Guygreenberg (talk | contribs) (→People) |
Guygreenberg (talk | contribs) |
||
Line 22: | Line 22: | ||
==Time== | ==Time== | ||
=== | ===Sites from Archaeological periods=== | ||
One way into the data is through the archeological periods | One way into the data is through the archeological periods that were found. This query sites from the late bronze age as well as the iron age. | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# Query for sites from late bronze and iron age | # Query for sites from late bronze and iron age |
Revision as of 12:43, 17 July 2024
Place
Where Timna sites are located
One way into the data is through the locations of archeological sites This query does that for all the sites but could be adapted (on lines *xx* and *xx* TBD) to look for other places or regions.
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 DISTINCT ?entity ?entityLabel ?coordinate
WHERE {
?entity rdfs:label ?entityLabel .
FILTER (lang(?entityLabel) = "en")
FILTER (STRSTARTS(?entityLabel, "Site"))
FILTER (STRSTARTS(STR(?entity), "https://timna-database.wikibase.cloud/entity/Q"))
?entity wdt:P28 ?coordinate .
}
LIMIT 300
##defaultView:Map
Time
Sites from Archaeological periods
One way into the data is through the archeological periods that were found. This query sites from the late bronze age as well as the iron age.
# Query for sites from late bronze and iron age
# 1 row per site and coordinatesd.
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 DISTINCT ?entity ?entityLabel ?coordinate
WHERE {
?entity rdfs:label ?entityLabel .
FILTER (lang(?entityLabel) = "en")
FILTER (STRSTARTS(?entityLabel, "Site"))
FILTER (STRSTARTS(STR(?entity), "https://timna-database.wikibase.cloud/entity/Q"))
?entity p:P93 ?statement1 .
?statement1 ps:P93 wd:Q115 .
?entity p:P93 ?statement2 .
?statement2 ps:P93 wd:Q114 .
?entity p:P93 ?statement3 .
?statement3 ps:P93 wd:Q120 .
?entity wdt:P28 ?coordinate .
}
LIMIT 100
People
This query returns members of the CTV excavations. As such it is a relatively straightforward query.
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 ?P110Label ?Instance
WHERE {
?entity rdfs:label ?entityLabel .
FILTER (lang(?entityLabel) = "en")
FILTER (STRSTARTS(STR(?entity), "https://timna-database.wikibase.cloud/entity/Q"))
?entity p:P110 ?statement1 .
?entity wdt:P110 ?Instance .
?Instance rdfs:label ?P110Label .
FILTER (lang(?P110Label) = "en")
}
LIMIT 300