prefix dce: prefix das: prefix edm: prefix foaf: prefix geo: prefix misc: prefix owl: prefix ship: prefix wgs84: prefix xsd: prefix rdf: select ?ship ?eventLabel (?arrivalDate as ?eventEnd) (?departureDate as ?eventStart) ?days ?arrivalName (SAMPLE(?arrivalShapeLabel) as ?eventDescription) (SAMPLE(?arrivalImageDescription) as ?arrivalImageDescription) (SAMPLE(?arrivalImageCreator) as ?arrivalImageCreator) (SAMPLE(?arrivalImageYear) as ?arrivalImageYear )(SAMPLE(?arrivalImageUrl) AS ?eventMedia) { bind(ship:DAS_ship0010 as ?ship)# 't Vliegend Hart' == DAS_ship0010 ?voyage das:shipid ?ship; das:voyarrivalplaceid [ das:toponym_original ?arrivalName; owl:sameAs [ wgs84:lat ?arrivalLat; wgs84:long ?arrivalLong]]; das:voydepartureplaceid [ das:toponym_original ?departureName; owl:sameAs [ wgs84:lat ?departureLat; wgs84:long ?departureLong]]. bind(strdt(concat('Point(',?arrivalLong,' ',?arrivalLat,')'),geo:wktLiteral) as ?arrivalShape) bind(strdt(concat('Point(',?departureLong,' ',?departureLat,')'),geo:wktLiteral) as ?departureShape) optional { [ dce:creator ?departureImageCreator; dce:description ?departureImageDescription; foaf:depiction ?departureImage1; misc:place ?departureName; misc:year ?departureImageYear]. optional { [ edm:isShownAt ?departureImage1; edm:isShownBy ?departureImage2; edm:provider ?departureProvider]. } bind(if(bound(?departureImage1)&&strends(str(?departureImage1),'.jpg'),?departureImage1,?departureImage2) as ?departureImageUrl) } bind(if(bound(?departureImageUrl),'

','') as ?departureImg) optional { [ dce:creator ?arrivalImageCreator; dce:description ?arrivalImageDescription; foaf:depiction ?arrivalImage1; misc:place ?arrivalName; misc:year ?arrivalImageYear]. optional { [ edm:isShownAt ?arrivalImage1; edm:isShownBy ?arrivalImage2]. } bind(if(bound(?arrivalImage1)&&strends(str(?arrivalImage1),'.jpg'),?arrivalImage1,?arrivalImage2) as ?arrivalImageUrl) } bind(if(bound(?arrivalImageUrl),'

','') as ?arrivalImg) ?voyage das:voydepartureedtf ?departureDate; das:voycapedepartureedtf ?depCapeDate; das:voyarrivaldateedtf ?arrivalDate; das:voycapearrivaledtf ?arrCapeDate. bind((?arrivalDate-?departureDate) / (24*60*60) as ?days) bind(strdt(''' Vertrokken van {{departureName}}: {{departureDate}}
Aangekomen op {{restName}}: {{arrCapeDate}}
Vertrokken van {{restName}}: {{depCapeDate}}
Aangekomen in {{arrivalName}}: {{arrivalDate}}
Duur van de reis: {{days}} dagen ''',rdf:HTML) as ?shape3Label) bind(if(bound(?departureImageDescription), strdt('''

Vertrokken op {{departureDate}}

"{{departureImageDescription}}" door {{departureImageCreator}}, {{departureImageYear}} [Herkomstcollectie: {{departureProvider}}].

''', '''

Vertrokken op {{departureDate}}

'''),rdf:HTML) as ?departureShapeLabel) bind(strdt('''

Aangekomen op {{eventEnd}}

{{arrivalImageDescription}} door {{arrivalImageCreator}}, {{arrivalImageYear}} [Herkomstcollectie: Nationaal Archief]. ''',rdf:HTML) as ?arrivalShapeLabel) bind(concat(?departureName, " - ", ?arrivalName) as ?eventLabel) } GROUP BY ?ship ?eventLabel ?arrivalDate ?departureDate ?days ?arrivalName

Documentation

Triply