Project:SPARQL/starters: Difference between revisions
Guygreenberg (talk | contribs) |
Guygreenberg (talk | contribs) |
||
Line 14: | Line 14: | ||
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 . } LIMIT 300 ##defaultView:Map | ?entity wdt:P28 ?coordinate . } | ||
LIMIT 300 | |||
##defaultView:Map | |||
[https://timna-database.wikibase.cloud/query/index.html#PREFIX%20wd%3A%20%3Chttps%3A%2F%2Ftimna-database.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Ftimna-database.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0APREFIX%20p%3A%20%3Chttps%3A%2F%2Ftimna-database.wikibase.cloud%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttps%3A%2F%2Ftimna-database.wikibase.cloud%2Fprop%2Fstatement%2F%3E%0APREFIX%20geo%3A%20%3Chttp%3A%2F%2Fwww.opengis.net%2Font%2Fgeosparql%23%3E%0A%0ASELECT%20DISTINCT%20%3Fentity%20%3FentityLabel%20%3Fcoordinate%0AWHERE%20%7B%0A%20%20%3Fentity%20rdfs%3Alabel%20%3FentityLabel%20.%0A%20%20FILTER%20(lang(%3FentityLabel)%20%3D%20%22en%22)%0A%20%20FILTER%20(STRSTARTS(%3FentityLabel%2C%20%22Site%22))%0A%20%20FILTER%20(STRSTARTS(STR(%3Fentity)%2C%20%22https%3A%2F%2Ftimna-database.wikibase.cloud%2Fentity%2FQ%22))%0A%20%20%0A%20%20%3Fentity%20wdt%3AP28%20%3Fcoordinate%20.%0A%7D%0ALIMIT%20300%0A%23#defaultView:Map Try it!] | [https://timna-database.wikibase.cloud/query/index.html#PREFIX%20wd%3A%20%3Chttps%3A%2F%2Ftimna-database.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Ftimna-database.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0APREFIX%20p%3A%20%3Chttps%3A%2F%2Ftimna-database.wikibase.cloud%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttps%3A%2F%2Ftimna-database.wikibase.cloud%2Fprop%2Fstatement%2F%3E%0APREFIX%20geo%3A%20%3Chttp%3A%2F%2Fwww.opengis.net%2Font%2Fgeosparql%23%3E%0A%0ASELECT%20DISTINCT%20%3Fentity%20%3FentityLabel%20%3Fcoordinate%0AWHERE%20%7B%0A%20%20%3Fentity%20rdfs%3Alabel%20%3FentityLabel%20.%0A%20%20FILTER%20(lang(%3FentityLabel)%20%3D%20%22en%22)%0A%20%20FILTER%20(STRSTARTS(%3FentityLabel%2C%20%22Site%22))%0A%20%20FILTER%20(STRSTARTS(STR(%3Fentity)%2C%20%22https%3A%2F%2Ftimna-database.wikibase.cloud%2Fentity%2FQ%22))%0A%20%20%0A%20%20%3Fentity%20wdt%3AP28%20%3Fcoordinate%20.%0A%7D%0ALIMIT%20300%0A%23#defaultView:Map Try it!] |
Revision as of 12:26, 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
When Timna excavations took place
One way into the data is through the dates the archeological excavations took place. This query does that for CTV of 2024 but could be adapted (on lines *xx* and *xx* TBD) to look for different dates.
Try it!
People
This query returns members of the CTV excavations. As such it is a relatively straightforward query.
Try it!