prefix bgb: prefix das: prefix dce: prefix edm: prefix foaf: prefix misc: prefix owl: prefix rol: prefix schema: prefix ship1: prefix ship2: prefix wgs84: prefix rdf: select ?arrivalShape (sample(?arrivalShapeLabel) as ?arrivalShapeLabel) ?departureShape (strdt(concat('

',?departureName," ⇨ ",?arrivalName,'

', '', '', group_concat(distinct ?row;separator=""), '

Type	Hoeveelheid	Waarde

'),rdf:HTML) as ?departureShapeLabel) { bind(ship2:4415 as ?ship) # 't Vliegend hart == 4415 bind(ship1:DAS_ship0010 as ?das_ship) # "t Vliegend hart = DAS_ship0010 ?zeerol rol:das_shipid ?das_ship; rol:totaal_opvarenden ?totaal. bind(concat('
Aantal opvarenden (juli 1733): ',?totaal) as ?s1) optional { ?zeerol rol:zeevarenden_europees ?europees. bind(concat('
Aantal Europeese opvarenden (juli 1733): ',?europees) as ?s2) } optional { ?zeerol rol:zeevarenden_aziatisch ?asiatisch. bind(concat('
Aantal Aziatische opvarenden (juli 1733): ',?asiatisch) as ?s3) } ?voy bgb:ship ?ship; bgb:voyarrivalplaceid/schema:name ?arrivalName. [ misc:place ?arrivalName; dce:creator ?imageCreator; dce:description ?imageDesc; foaf:depiction ?image1; misc:year ?imageYear; misc:ExternalGeoIdentifier ?arrivalGeo]. optional { [ edm:isShownAt ?image1; edm:isShownBy ?image2; edm:provider ?provider]. } bind(if(bound(?image1)&&strends(str(?image1),'.jpg'),?image1,?image2) as ?imageUrl) bind(if(bound(?imageUrl), concat('

', '“',str(?imageDesc),'” door ',str(?imageCreator),', ',str(?imageYear), ' [Herkomstcollectie: ', if(bound(?provider),str(?provider),'Nationaal Archief'), '].', '

'), '') as ?figure) ?voy bgb:voydepartureplaceid/schema:name ?departureName. [ das:toponym_original ?departureName; owl:sameAs ?departureGeo]. ?cargo bgb:voyageid ?voy; bgb:productid/schema:name ?type; bgb:quantity ?quantity. optional { ?cargo bgb:unitid/schema:name ?unit. } optional { ?cargo bgb:valuelicht ?value. } ?arrivalGeo wgs84:long ?lonArr; wgs84:lat ?latArr. ?departureGeo wgs84:long ?lonDep; wgs84:lat ?latDep. bind(concat('Polygon((',str(?lonArr),' ',str(?latArr),',' ,str(?lonDep),' ',str(?latDep) ,'))') as ?departureShape) bind(concat('Point(',str(?lonArr),' ',str(?latArr),')') as ?arrivalShape) bind(concat('',?type,'',?quantity,if(bound(?unit),concat(' ',?unit),''),'',?value,'') as ?row) bind(strdt(concat('

',?arrivalName,'

',if(bound(?s1),?s1,''),if(bound(?s2),?s2,''),if(bound(?s3),?s3,''),?figure),rdf:HTML) as ?arrivalShapeLabel) } group by ?departureName ?departureShape ?arrivalName ?arrivalShape

Documentation

Triply