%%%%%%%%%%%%%%%%%%%%% % Predicates %%%%%%%%%%%%%%%%%%%%% pho:quai and ((cidoc:P53_has_former_or_current_location value pho:mar_del_plata) or (cidoc:P53_has_former_or_current_location value pho:rosario)) time:Instant and (pho:hasBeginningOf some (cidoc:E79_Part_Addition and (cidoc:P110_augmented some pho:quai_brest))) time:Instant and (pho:hasBeginningOf some (cidoc:E79_Part_Addition and (cidoc:P110_augmented some (pho:quai_brest and pho:profondeur value 7)))) pho:quai and ((pho:profondeur value 7) or (pho:profondeur value 6) or (pho:profondeur value 5)) pho:quai and (pho:profondeur some xsd:decimal [> "7"^^xsd:decimal]) ------------------------------------------------------------------------ -- SPARQL QUERIES ------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 1 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: SELECT ?quai ?profondeur WHERE { ?quai rdf:type pho:quai. ?quai pho:profondeur ?profondeur. } ORDER BY ?profondeur ----------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 2 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: SELECT ?super_quai ?quai ?profondeur ?longueur WHERE { ?quai rdf:type pho:quai. ?quai rdfs:subClassOf pho:quai_brest. ?quai pho:profondeur ?profondeur. ?quai pho:longueur ?longueur. } ORDER BY ?quai ?profondeur ?longueur -------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 3 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: SELECT ?quai ? WHERE { ?quai_grande_profondeur } ORDER BY ?super_quai ------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 4 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: SELECT ?quai ?profondeur WHERE { ?quai rdf:type pho:quai. ?quai pho:profondeur ?profondeur FILTER (?profondeur <3) ------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 5 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?date ?quai_brest ?profondeur WHERE { ?date rdf:type time:Instant. ?quai_brest rdf:type pho:quai_brest. ?addition rdf:type cidoc:E79_Part_Addition. ?addition cidoc:P110_augmented ?quai_brest. ?date pho:hasBeginningOf ?addition. ?quai_brest pho:profondeur ?profondeur. } ORDER BY ?date %%%%%%%%%%%%%%%%%%%% % Query 5 BIS SG %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?date ?quai_brest ?profondeur WHERE { ?quai_brest rdf:type pho:quai_brest. ?addition cidoc:P110_augmented ?quai_brest. ?addition rdf:type cidoc:E79_Part_Addition. ?date pho:hasBeginningOf ?addition. ?quai_brest pho:profondeur ?profondeur. } ORDER BY ?date ----------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 6 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?date ?quai_brest ?profondeur WHERE { ?instant rdf:type time:Instant. ?quai_brest rdf:type pho:quai_brest. ?addition rdf:type cidoc:E79_Part_Addition. ?addition cidoc:P110_augmented ?quai_brest. ?instant pho:hasBeginningOf ?addition. ?instant time:inXSDgYear ?date. ?quai_brest pho:profondeur ?profondeur. ?quai_brest pho:longueur ?longueur. } ORDER BY ?date ------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 7 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT (SUM(?longueur) AS ?sum) WHERE { ?quai_brest rdf:type pho:quai_brest. ?quai_brest pho:profondeur ?profondeur FILTER (?profondeur >2.9) FILTER (?profondeur <5.1) ?quai_brest pho:longueur ?longueur. } ----------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 8 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT (?longueur_add - ?longueur_sous) AS ?longueur_cumul WHERE { ?date rdf:type time:Instant. ?quai_brest rdf:type pho:quai_brest. ?addition rdf:type cidoc:E79_Part_Addition. ?addition cidoc:P110_augmented ?quai_brest. ?date pho:hasBeginningOf ?addition. ?quai_brest pho:longueur ?longueur_add. ?date pho:hasEndOf ?addition. ?quai_brest pho:longueur ?longueur_sous. } ORDER BY ?date ------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 9 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?longueur_add ?longueur_sous ?date WHERE { ?instant rdf:type time:Instant. ?quai_brest rdf:type pho:quai_brest. ?addition rdf:type cidoc:E79_Part_Addition. ?soustraction rdf:type cidoc:E80_Part_Removal. ?addition cidoc:P110_augmented ?quai_brest. ?quai_brest pho:longueur ?longueur_add. ?soustraction cidoc:P112_diminished ?quai_brest. ?quai_brest pho:longueur ?longueur_sous. } ORDER BY ?date ------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 10 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?quai_brest ?longueur_ad ?longueur_sous WHERE { ?quai_brest rdf:type pho:quai_brest. ?addition rdf:type cidoc:E79_Part_Addition. ?addition cidoc:P110_augmented ?quai_brest. ?quai_brest pho:longueur ?longueur_ad. OPTIONAL{ ?soustraction cidoc:P112_diminished ?quai_brest. ?quai_brest pho:longueur ?longueur_sous.} } ORDER BY ?quai_brest ------------------------------------------------------------------------ %%%%%%%%%%%%%%%%%%%% % Query 11 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT DISTINCT ?quai_brest WHERE { ?date_ad rdf:type time:Instant. ?date_sous rdf:type time:Instant. ?quai_brest rdf:type pho:quai_brest. } ------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 12 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?quai_brest ?longueur_ad ?longueur_sous WHERE { ?quai_brest rdf:type pho:quai_brest. ?addition rdf:type cidoc:E79_Part_Addition. ?addition cidoc:P110_augmented ?quai_brest. ?quai_brest pho:longueur ?longueur_ad. MINUS { ?soustraction cidoc:P112_diminished ?quai_brest. ?quai_brest pho:longueur ?longueur_sous.} } ORDER BY ?quai_brest ------------------------------------------------------------------------------------ %%%%%%%%%%%%%%%%%%%% % Query 13 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT DISTINCT ?date ?quai_brest ?longueur_ad ?date_s ?longueur_sous WHERE { ?instant rdf:type time:Instant. ?quai_brest rdf:type pho:quai_brest. ?addition rdf:type cidoc:E79_Part_Addition. ?addition cidoc:P110_augmented ?quai_brest. ?instant pho:hasBeginningOf ?addition. ?instant time:inXSDgYear ?date. ?instant_s pho:hasBeginningOf ?soustraction. ?instant_s time:inXSDgYear ?date_s. ?quai_brest pho:longueur ?longueur_ad. FILTER (?date <1860). FILTER (?date_s<1860) OPTIONAL { ?soustraction cidoc:P112_diminished ?quai_brest. ?quai_brest pho:longueur ?longueur_sous.} } ORDER BY ?date ?date_s ---------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 14 : Version 2 optimisée SG %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?quai ?constructeur ?ingenieur ?lieu ?date WHERE { ?quai rdf:type pho:quai. ?quai cidoc:P108i_was_produced_by ?construction. ?construction cidoc:P11_had_participant ?constructeur. ?construction cidoc:P11_had_participant ?ingenieur. ?constructeur rdf:type pho:constructeur. ?ingenieur rdf:type pho:ingénieur. ?quai cidoc:P53_has_former_or_current_location ?lieu. ?lieu rdf:type pho:lieu. ?construction time:hasBeginning ?instant. ?instant rdf:type time:Instant. ?instant time:inXSDgYear ?date. } ------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 15 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?date ?lieu ?quai ?profondeur ?constructeur ?ingenieur WHERE { ?quai rdf:type pho:quai. ?constructeur rdf:type pho:constructeur. ?ingenieur rdf:type pho:ingénieur. ?lieu rdf:type pho:lieu. ?instant rdf:type time:Instant. ?quai cidoc:P108i_was_produced_by ?construction. ?construction cidoc:P11_had_participant ?constructeur. ?construction cidoc:P11_had_participant ?ingenieur. ?quai cidoc:P53_has_former_or_current_location ?lieu. ?construction time:hasBeginning ?instant. ?instant time:inXSDgYear ?date. ?quai pho:profondeur ?profondeur. FILTER (?profondeur >6) FILTER (?profondeur <8) } ORDER BY ?lieu ------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 15 : version 2 optimisée, SG %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?date ?lieu ?quai ?profondeur ?constructeur ?ingenieur WHERE { ?quai rdf:type pho:quai. ?quai cidoc:P108i_was_produced_by ?construction. ?construction cidoc:P11_had_participant ?constructeur. ?construction cidoc:P11_had_participant ?ingenieur. ?quai cidoc:P53_has_former_or_current_location ?lieu. ?construction time:hasBeginning ?instant. ?instant time:inXSDgYear ?date. ?quai pho:profondeur ?profondeur. FILTER (?profondeur >6) FILTER (?profondeur <8) } ORDER BY ?lieu --------------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Query 16 : Requêtes avec un PB. ?port rdf:type pho:port. ??? %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?quai ?date ?datEnd WHERE { ?quai rdf:type pho:quai_brest. ?port rdf:type pho:port. ?addition rdf:type cidoc:E79_Part_Addition. ?port cidoc:P110i_was_augmented_by ?addition. ?addition cidoc:P110_augmented ?quai. ?addition time:hasBeginning ?instant. ?instant time:inXSDgYear ?date. OPTIONAL{ ?addition time:hasEnd ?inst_end. ?inst_end time:inXSDgYear ?datEnd. } } --------------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 17 : Ne fonctionne pas %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?date ?quai ?profondeur ?longueur WHERE { ?date rdf:type time:Instant. ?quai rdf:type pho:quai. ?addition rdf:type cidoc:E79_Part_Addition. ?addition cidoc:P110_augmented ?quai. ?addition time:hasBeginning ?date . ?quai pho:profondeur ?profondeur. ?quai pho:longueur ?longueur. } ORDER BY ?date --------------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Query 17: version 2 Optimisée, SG, Ne fonctionne pas %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?date ?quai ?profondeur ?longueur WHERE { ?addition rdf:type cidoc:E79_Part_Addition. ?addition cidoc:P110_augmented ?quai. ?quai rdf:type pho:quai. ?addition time:hasBeginning ?date . ?quai pho:profondeur ?profondeur. ?quai pho:longueur ?longueur. ?date rdf:type time:Instant. } ORDER BY ?date --------------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 18 : Cette requête est erronée %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?longueur ?longueur_f ( ?longueur-?longueur_f AS ?total) WHERE { ?instant rdf:type time:Instant. ?instant_f rdf:type time:Instant. ?quai rdf:type pho:quai_brest. ?addition rdf:type cidoc:E79_Part_Addition. ?addition cidoc:P110_augmented ?quai. ?addition time:hasBeginning ?instant . ?instant time:inXSDgYear ?date. ?quai pho:profondeur ?profondeur. ?quai pho:longueur ?longueur. ?addition time:hasBeginning ?instant_f . ?instant_f time:inXSDgYear ?date_f. ?quai pho:longueur ?longueur_f. FILTER (?date<1930) FILTER (?profondeur >6) FILTER (?profondeur <10) } --------------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Query 18 : requête corrigée ???, pas possible de corriger %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?longueur ?longueur_f ( ?longueur-?longueur_f AS ?total) WHERE { ?quai rdf:type pho:quai_brest. ?quai pho:profondeur ?profondeur. ?quai pho:longueur ?longueur. ?addition rdf:type cidoc:E79_Part_Addition. ?addition cidoc:P110_augmented ?quai1. ?addition time:hasBeginning ?instant . ?instant rdf:type time:Instant. ?instant time:inXSDgYear ?date. ?addition time:hasBeginning ?instant_f . ?instant_f rdf:type time:Instant. ?instant_f time:inXSDgYear ?date_f. ?quai1 pho:longueur ?longueur_f. FILTER (?date<1930) FILTER (?profondeur >6) FILTER (?profondeur <10) } --------------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 19 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT DISTINCT ?date ?lieu ?quai ?profondeur ?longueur ?constructeur ?technologie WHERE { ?quai rdf:type pho:quai. ?constructeur rdf:type pho:constructeur. ?ingenieur rdf:type pho:ingénieur. ?lieu rdf:type pho:lieu. ?technologie rdf:type pho:technologie_fondation_quai. ?instant rdf:type time:Instant. ?quai cidoc:P108i_was_produced_by ?construction. ?construction cidoc:P11_had_participant ?constructeur. ?quai cidoc:P53_has_former_or_current_location ?lieu. ?construction time:hasBeginning ?instant. ?instant time:inXSDgYear ?date. ?quai pho:profondeur ?profondeur. ?quai pho:longueur ?longueur. ?construction cidoc:P16_used_specific_object ?technologie FILTER (?profondeur >6) } ORDER BY ?date --------------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%% % Query 20 %%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT DISTINCT ?date ?quai ?grue ?nombre_grue ?puissance_kg WHERE { ?quai rdf:type pho:quai. ?grue rdf:type pho:grue. ?entrepot rdf:type pho:entrepot. ?addition rdf:type cidoc:E79_Part_Addition. ?quai cidoc:P110i_was_augmented_by ?addition. ?addition cidoc:P110_augmented ?grue. OPTIONAL {?grue pho:nombre_grue ?nombre_grue. ?grue pho:capacite_max_levage ?puissance_kg.} ?addition time:hasBeginning ?instant . ?instant time:inXSDgYear ?date.} ORDER BY ?date ----------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Query 19 : Version 2 optimisée ??? SG %%%%%%%%%%%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT DISTINCT ?date ?lieu ?quai ?profondeur ?longueur ?constructeur ?technologie WHERE { ?quai rdf:type pho:quai. ?quai pho:profondeur ?profondeur. ?quai pho:longueur ?longueur. ?quai cidoc:P53_has_former_or_current_location ?lieu. ?lieu rdf:type pho:lieu. ?quai cidoc:P108i_was_produced_by ?construction. ?construction time:hasBeginning ?instant. ?instant rdf:type time:Instant. ?instant time:inXSDgYear ?date. ?construction cidoc:P11_had_participant ?constructeur. ?constructeur rdf:type pho:constructeur. ?ingenieur rdf:type pho:ingénieur. ?construction cidoc:P16_used_specific_object ?technologie. ?technologie rdf:type pho:technologie_fondation_quai. FILTER (?profondeur >6) } ORDER BY ?date -------------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Query 20 : Version 2 Optimisée ??? SG % supprimé ?entrepot rdf:type pho:entrepot. qui % nétait pas utilisé/lié %%%%%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT DISTINCT ?date ?quai ?grue ?nombre_grue ?puissance_kg WHERE { ?quai rdf:type pho:quai. ?quai cidoc:P110i_was_augmented_by ?addition. ?addition rdf:type cidoc:E79_Part_Addition. ?addition time:hasBeginning ?instant. ?instant time:inXSDgYear ?date. ?addition cidoc:P110_augmented ?grue. ?grue rdf:type pho:grue. OPTIONAL {?grue pho:nombre_grue ?nombre_grue. ?grue pho:capacite_max_levage ?puissance_kg.} } ORDER BY ?date ------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Query 21 : longueur des quais >5m de tous les ports ; date de début et de fin d'utilisation %%%%%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?date ?lieu ?quai ?longueur ?date_f WHERE { ?quai rdf:type pho:quai. ?quai pho:profondeur ?profondeur. ?quai pho:longueur ?longueur. ?addition cidoc:P110_augmented ?quai. ?addition rdf:type cidoc:E79_Part_Addition. ?addition time:hasBeginning ?instant . ?instant rdf:type time:Instant. ?instant time:inXSDgYear ?date. OPTIONAL { ?addition time:hasEnd ?instant_f. ?instant_f rdf:type time:Instant. ?instant_f time:inXSDgYear ?date_f.} ?lieu rdf:type pho:lieu. ?quai cidoc:P53_has_former_or_current_location ?lieu. FILTER (?profondeur >5)} ORDER BY ?date ------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Query 22 : Tous les quais présents en France %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?quai ?lieu WHERE { ?quai rdf:type pho:quai. ?lieu rdf:type pho:lieu. ?quai cidoc:P53_has_former_or_current_location ?lieu. ?lieu cidoc:P89_falls_within pho:France. } ORDER BY ?lieu -------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Query 23 : Tous les ingénieurs et leurs écoles ayant travaillé en Argentine. %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT DISTINCT ?ingenieur ?lieu ?ecole WHERE { ?ingenieur rdf:type pho:ingénieur. ?quai rdf:type pho:quai. ?ecole rdf:type pho:Ecole. ?ingenieur cidoc:P11i_participated_in ?construction. ?construction cidoc:P108_has_produced ?quai. ?quai cidoc:P53_has_former_or_current_location ?lieu. ?lieu cidoc:P89_falls_within pho:argentine. ?ingenieur cidoc:P107i_is_current_or_former_member_of ?ecole. } ORDER BY ?lieu ------------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Querry 24 : Quels ingénieurs ont participé à la construction des ports argentins ? Pour chaque ingénieur, on cherchera a savoir de quelle école il est issu ainsi que le port dans lequel il a exercé son activité. %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT DISTINCT ?port ?date ?entreprise ?technologie WHERE { ?port rdf:type pho:port. ?port cidoc:P110i_was_augmented_by ?addition. ?addition cidoc:P110_augmented ?quai. ?quai cidoc:P108i_was_produced_by ?construction. ?entreprise rdf:type pho:entreprise. ?construction cidoc:P11_had_participant ?entreprise. ?construction cidoc:P16_used_specific_object ?technologie. ?construction time:hasBeginning ?instant. ?instant time:inXSDgYear ?date. } ORDER BY ?date --------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Querry 25 : A quelles dates a t-on construit des quais dans les ports ? Pour chaque port, on cherchera l'entreprise constructrice ainsi que la technologie mise en oeuvre. %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT DISTINCT ?port ?date ?entreprise ?technologie WHERE { ?port rdf:type pho:port. ?port cidoc:P110i_was_augmented_by ?addition. ?addition cidoc:P110_augmented ?quai. ?quai cidoc:P108i_was_produced_by ?construction. ?entreprise rdf:type pho:entreprise. ?construction cidoc:P11_had_participant ?entreprise. ?construction cidoc:P16_used_specific_object ?technologie. ?construction time:hasBeginning ?instant. ?instant time:inXSDgYear ?date. } ORDER BY ?technologie ?date ------------------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Querry 26 : A quelles dates a t-on ajouté des grues dans le port de Brest? On cherchera le nombre de grues ainsi que la technologie mise en oeuvre. %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?technologie ?nb_grues ?date_debut ?date_fin WHERE {?grues rdf:type pho:grue_brest. ?grues pho:nombre_grue ?nb_grues. ?grues cidoc:P110i_was_augmented_by ?addition. ?addition time:hasBeginning ?date_debut. OPTIONAL {?addition time:hasEnd ?date_fin} ?addition cidoc:P16_used_specific_object ?technologie } ORDER BY ?date_debut ---------------------------------------------------------------------------- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Querry 27 : A quelles dates a t-on ajouté des grues dans les ports Pour chaque port, on cherchera le nombre de grues, la puissance et la technologie. %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% PREFIX owl: PREFIX rdf: PREFIX rdfs: PREFIX cidoc: PREFIX pho: PREFIX time: SELECT ?port ?date ?nb_grues ?puissance ?technologie WHERE {?port rdf:type pho:port. ?port cidoc:P110i_was_augmented_by ?addition. ?grues rdf:type pho:grue. ?addition cidoc:P110_augmented ?grues. ?grues pho:nombre_grue ?nb_grues. ?addition time:hasBeginning ?date. OPTIONAL { ?grues pho:capacite_max_levage ?puissance.} ?addition cidoc:P16_used_specific_object ?technologie } ORDER BY ?date