Project:SPARQL/starters: Difference between revisions
From Timna Valley Database
Guygreenberg (talk | contribs) (→People) |
Guygreenberg (talk | contribs) |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==Place== | ==Place== | ||
===Where Timna sites are located=== | ===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 | 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 16 remove # and choose *Qxx*) to look for other places or regions. | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
PREFIX wd: <https://timna-database.wikibase.cloud/entity/> | PREFIX wd: <https://timna-database.wikibase.cloud/entity/> | ||
| Line 15: | Line 15: | ||
FILTER (STRSTARTS(?entityLabel, "Site")) | FILTER (STRSTARTS(?entityLabel, "Site")) | ||
FILTER (STRSTARTS(STR(?entity), "https://timna-database.wikibase.cloud/entity/Q")) | FILTER (STRSTARTS(STR(?entity), "https://timna-database.wikibase.cloud/entity/Q")) | ||
?entity wdt:P28 ?coordinate . | ?entity wdt:P28 ?coordinate . | ||
OPTIONAL { | |||
# VALUES ?filterEntity { wd:Q523 } # Replace wd:Q523 with the specific item you want to filter by, or leave it empty | |||
} | |||
# Apply filter if ?filterEntity is specified | |||
FILTER (!BOUND(?filterEntity) || ?entity = ?filterEntity) | |||
} | } | ||
LIMIT 300 | LIMIT 300 | ||
| Line 21: | Line 29: | ||
</sparql> | </sparql> | ||
== | ==Archaeological Periods== | ||
=== | ===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 shows sites from the early iron age. | ||
To show other periods replace in line 15 and line 19 Q115 with a different period QXXX | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# Query for sites from late bronze and iron age | # Query for sites from late bronze and iron age | ||
| Line 33: | Line 42: | ||
PREFIX geo: <http://www.opengis.net/ont/geosparql#> | PREFIX geo: <http://www.opengis.net/ont/geosparql#> | ||
SELECT DISTINCT ?entity ?entityLabel ?coordinate | SELECT DISTINCT ?entity ?entityLabel ?coordinate ?q115Label | ||
WHERE { | WHERE { | ||
?entity rdfs:label ?entityLabel . | ?entity rdfs:label ?entityLabel . | ||
| Line 43: | Line 52: | ||
?statement1 ps:P93 wd:Q115 . | ?statement1 ps:P93 wd:Q115 . | ||
?entity wdt:P28 ?coordinate . | ?entity wdt:P28 ?coordinate . | ||
wd:Q115 rdfs:label ?q115Label . | |||
FILTER (lang(?q115Label) = "en") | |||
} | } | ||
LIMIT | LIMIT 300 | ||
</sparql> | </sparql> | ||
==People== | ==People== | ||
Latest revision as of 07:12, 18 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 16 remove # and choose *Qxx*) 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 .
OPTIONAL {
# VALUES ?filterEntity { wd:Q523 } # Replace wd:Q523 with the specific item you want to filter by, or leave it empty
}
# Apply filter if ?filterEntity is specified
FILTER (!BOUND(?filterEntity) || ?entity = ?filterEntity)
}
LIMIT 300
##defaultView:Map
Archaeological Periods
Sites from Archaeological periods
One way into the data is through the archeological periods that were found. This query shows sites from the early iron age. To show other periods replace in line 15 and line 19 Q115 with a different period QXXX
# 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 ?q115Label
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 wdt:P28 ?coordinate .
wd:Q115 rdfs:label ?q115Label .
FILTER (lang(?q115Label) = "en")
}
LIMIT 300
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
