prefix dce: prefix das: prefix edm: prefix foaf: prefix geo: prefix misc: prefix owl: prefix ship: prefix wgs84: prefix xsd: prefix rdf: select * { 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),?arrivalImage1,?arrivalImage2) as ?arrivalImageUrl) } bind(if(bound(?arrivalImageUrl),'

','') as ?arrivalImg) bind( as ?kaap) ?kaap wgs84:lat ?latKaap; wgs84:long ?longKaap. bind(strdt(concat('Point(',?longKaap,' ',?latKaap,')'),geo:wktLiteral) as ?restShape) optional { [ dce:creator ?restImageCreator; dce:description ?restImageDescription; foaf:depiction ?restImage; misc:ExternalGeoIdentifier ?kaap; misc:place ?restName; misc:year ?restImageYear]. filter(strends(str(?restImage),'.jpg')) } bind(strdt(if(xsd:integer(?departureLat)>45, concat('LineString(',?departureLong,' ',?departureLat,',3.07966 51.77924,1.34205 50.87258,-2.08131 49.93115,-5.33326 48.67037,-9.77174 43.27050,-11.44166 36.68907,-14.78151 28.71317,-19.00026 18.92025,-23.87345 12.6475,-30.5023 -10.39992,-33.11856 -18.33260,-31.73428 -27.76883,-29.9325 -32.07113,-27.9500 -34.08019,-26.13816 -35.75632,-23.80906 -37.13492,-20.90867 -37.65861,-15.32761 -37.86705,-6.80222 -37.41468,2.64602 -36.71335,8.0073 -36.1831,12.36839 -36.07712,',?longKaap,' ',?latKaap,',18.35680 -35.39930,20.55277 -36.59887,26.11185 -37.56297,36.15953 -37.76297,44.45902 -38.03175,72.07865 -38.13552,97.47012 -38.35985,100.16931 -37.15799,102.45447 -35.40458,103.81677 -33.19029,104.45398 -29.83812,105.09119 -24.40449,104.82752 -17.17519,103.15760 -11.10593,',?arrivalLong,' ',?arrivalLat,')'), concat('LineString(',?departureLong,' ',?departureLat,',74.5229 7.69870,71.78581 7.03825,69.14909 5.55316,65.91911 2.85805,62.66716 -0.83214,60.38200 -4.60650,57.21794 -11.21877,54.93278 -16.42287,52.82341 -21.89969,49.25455 -27.66664,42.75065 -31.18710,36.07096 -33.70848,28.51237 -36.15797,21.65690 -37.14512,',?longKaap,' ',?latKaap,',17.03490 -34.35846,14.92553 -30.50223,11.11303 -23.29844,5.65209 -15.34412,-8.80494 2.39809,-17.59401 10.08075,-22.00026 16.52025,-28.7247 30.78764,-26.85550 37.54813,-21.58206 43.00792,-17.01175 46.65251,-12.0898 48.75189,-6.03727 49.37919,-0.956103 50.02224,2.53750 51.63169,',?arrivalLong,' ',?arrivalLat,')')), geo:wktLiteral) as ?shape3) ?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(strdt(if(bound(?departureImageDescription), '''

Vertrokken op {{departureDate}}

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

''', '''

Vertrokken op {{departureDate}}

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

Aangekomen op {{arrivalDate}}

{{arrivalImageDescription}} door {{arrivalImageCreator}}, {{arrivalImageYear}} [Herkomstcollectie: Nationaal Archief].

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

Aangekomen op {{arrCapeDate}}
Vertrokken op {{depCapeDate}}

“{{restImageDescription}}” door {{restImageCreator}}, {{restImageYear}} [Herkomstcollectie: Nationaal Archief].

''',rdf:HTML) as ?restShapeLabel) bind(if(strends(str(?voyage),'6'),'green','red') as ?shape3Color) }

Documentation

Triply