PREFIX iisgv: PREFIX sdo: PREFIX rdf: PREFIX andb: PREFIX andb_death: PREFIX iisgv: PREFIX org: prefix geo: PREFIX hg: prefix rdfs: prefix skos: prefix vocab: prefix owl: prefix foaf: prefix time: #this query only displays the persons in the ANDB database for whom a birthplace, place of death, name, gender and final residency is known to have been on a ANDB membership card. There are some duplicates that are the result of there being two membership cards associated with one name. select distinct ?personA ?personB ?birthplace ?deathPlace ?shape ?shapeLabel ?deathDate ?residency ?name #1 link the persons in the ANDB-deathplace/oorlogsleven graph (as personA) to the ANDB-members graph (as personB) WHERE { ?personA rdf:type sdo:Person . BIND(STRAFTER(STR(?personA), "https://druid.datalegend.net/4cc7ac/id/") AS ?uuid) . BIND(URI(CONCAT(STR(andb:), STR(?uuid))) AS ?personB) . #2. select from personA those persons for whom birthplace, deathdate, deathplace, name and gender are known ?personA sdo:deathDate ?deathDate ; sdo:deathPlace ?deathPlace; sdo:name ?name; sdo:birthPlace ?birthplace. #3 select from this subset those PersonB for whom a residency is known in the ANDB graph ?personB sdo:birthPlace ?birthplace ; iisgv:inhabits/sdo:address ?residency; sdo:name ?name . #4 link these residencies to their shapes/geographical location and addresses ?residency owl:sameAs/geo:hasGeometry/geo:asWKT ?shape ; rdfs:label ?address. FILTER NOT EXISTS { ?personB foaf:isPrimayTopicOf/vocab:aboutResidency/vocab:duration/time:after ?duration } #5 write labels containing the name of the person, their address, deathplace and deathdate bind(strdt(concat('

',?name,'

', ?address ,'

', ?deathPlace, '

', ?deathDate, '

'),rdf:HTML) as ?shapeLabel)}

409 map

API

Variables