Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Get a count of mints with and without geographic coordinates for Seleucid Monograms
PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
PREFIX dcmitype: <http://purl.org/dc/dcmitype/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX nm: <http://nomisma.org/id/>
PREFIX nmo: <http://nomisma.org/ontology#>
PREFIX org: <http://www.w3.org/ns/org#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT DISTINCT ?symbol (count(DISTINCT ?mint) as ?certainCount) (count(DISTINCT ?uncertainMint) as ?uncertainCount) WHERE {
?type a nmo:TypeSeriesItem ;
dcterms:source nm:seleucid_coins ;
nmo:hasObverse/nmo:hasControlmark|nmo:hasReverse/nmo:hasControlmark ?symbol .
?symbol a nmo:Monogram .
{?type nmo:hasMint ?mint .
?mint a nmo:Mint ; geo:location ?loc}
UNION {?type nmo:hasMint ?uncertainMint .
?uncertainMint a nmo:Mint .
FILTER NOT EXISTS{?uncertainMint geo:location ?uncertainLoc}
FILTER NOT EXISTS{?uncertainMint skos:broader ?broader . ?broader a nmo:Mint}}
} GROUP BY ?symbol HAVING (?certainCount = 1 && ?uncertainCount = 1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment