Department for Transport Treaty work packages before Parliament

29 May 2002 -

Treaty work packages currently before Parliament led by Department for Transport.

There are 0 work packages.

Organisation accountable to Parliament identifier

https://id.parliament.uk/XouN12Ow

SPARQL queries used by this page

PREFIX : <https://id.parliament.uk/schema/>
          PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
          PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
          PREFIX id: <https://id.parliament.uk/>
          SELECT distinct (COUNT(DISTINCT ?WorkPackage) AS ?count) WHERE {
           { ?Organisations a :GovernmentOrganisation.}
           UNION {
          ?Organisations a :ArmsLengthBody.
                          }
            ?Organisations :name ?Name;
                           :leadGovernmentOrganisationHasTreaty ?treaty.
            ?treaty :name ?TreatyName;
                    :workPackagedThingHasWorkPackage ?WorkPackage.
              OPTIONAL
            {
              ?treaty :treatyHasCountrySeriesMembership ?treatyHasCountrySeriesMembership .
              ?treatyHasCountrySeriesMembership :seriesItemCitation ?countrySeriesItemCitation .
            }
            OPTIONAL
            {
              ?treaty :treatyHasEuropeanUnionSeriesMembership ?treatyHasEuropeanUnionSeriesMembership .
              ?treatyHasEuropeanUnionSeriesMembership :seriesItemCitation ?europeanSeriesItemCitation .
            }
            OPTIONAL
            {
              ?treaty :treatyHasMiscellaneousSeriesMembership ?treatyHasMiscellaneousSeriesMembership .
              ?treatyHasMiscellaneousSeriesMembership :seriesItemCitation ?miscSeriesItemCitation .
            }
 
             filter (?Organisations in (id:XouN12Ow))
         optional {?WorkPackage :workPackageHasBusinessItem ?businessItem .
                      ?businessItem :businessItemHasProcedureStep ?step;
                             :businessItemDate ?businessItemDate.
                      filter (?step in (id:isWn7s3K, id:cspzmb6w, id:ITNO9JWr, id:otscOTzB))}
                      ?WorkPackage :workPackageHasProcedure ?procedure.
                    ?procedure :name ?procedureName.
                         optional { ?WorkPackage :workPackageHasCalculationStyle ?calculationStyle. 
               ?calculationStyle :name ?calculationStyleName. }
        MINUS {  ?WorkPackage   :workPackageHasBusinessItem ?bi2.
      ?bi2 :businessItemHasProcedureStep ?stepId2.
        ?stepId2 :procedureStepHasProcedureStepCollectionMembership/:procedureStepCollectionMembershipHasProcedureStepCollection id:TRohjSuI}
          }

PREFIX : <https://id.parliament.uk/schema/>
                   PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
                   PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
                   PREFIX id: <https://id.parliament.uk/>
                   SELECT distinct ?workPackage ?procedure ?procedureName ?treaty ?TreatyName ?treatyHasCountrySeriesMembership ?countrySeriesItemCitation ?treatyHasEuropeanUnionSeriesMembership ?europeanSeriesItemCitation ?treatyHasMiscellaneousSeriesMembership ?miscSeriesItemCitation ?combinedDate ?calculationStyle ?calculationStyleName (BOUND(?stepId3) AS ?hasCommitteeConcernsFlag)   
     (BOUND(?stepId4) AS ?hasMotionTabledFlag) WHERE {
                    { ?Organisations a :GovernmentOrganisation.}
                    UNION {
                   ?Organisations a :ArmsLengthBody.
                                   }
                     ?Organisations :name ?Name;
                                    :leadGovernmentOrganisationHasTreaty ?treaty.
                     ?treaty :name ?TreatyName;
                             :workPackagedThingHasWorkPackage ?workPackage.
               ?workPackage :workPackageHasProcedure ?procedure.
               ?procedure :name ?procedureName.
                       OPTIONAL
                     {
                       ?treaty :treatyHasCountrySeriesMembership ?treatyHasCountrySeriesMembership .
                       ?treatyHasCountrySeriesMembership :seriesItemCitation ?countrySeriesItemCitation .
                     }
                     OPTIONAL
                     {
                       ?treaty :treatyHasEuropeanUnionSeriesMembership ?treatyHasEuropeanUnionSeriesMembership .
                       ?treatyHasEuropeanUnionSeriesMembership :seriesItemCitation ?europeanSeriesItemCitation .
                     }
                     OPTIONAL
                     {
                       ?treaty :treatyHasMiscellaneousSeriesMembership ?treatyHasMiscellaneousSeriesMembership .
                       ?treatyHasMiscellaneousSeriesMembership :seriesItemCitation ?miscSeriesItemCitation .
                     }
 
                      filter (?Organisations in (id:XouN12Ow))
                  optional {   ?workPackage :workPackageHasBusinessItem ?businessItem .
                    ?businessItem :businessItemHasProcedureStep ?step;
                           :businessItemDate ?businessItemDate.
             filter (?step in (id:isWn7s3K, id:cspzmb6w, id:ITNO9JWr, id:otscOTzB))}
             optional {    ?workPackage :workPackageHasBusinessItem ?businessItem2 .
                    ?businessItem2 :businessItemHasProcedureStep ?step2;
                                   :businessItemDate ?businessItemDate2.
             filter (?step2 in (id:AmYrFxwO))}
                               ?workPackage :workPackageHasProcedure ?procedure.
                             ?procedure :name ?procedureName.
                                  optional { ?workPackage :workPackageHasCalculationStyle ?calculationStyle. 
                        ?calculationStyle :name ?calculationStyleName. }
           MINUS {  ?workPackage   :workPackageHasBusinessItem ?bi2.
               ?bi2 :businessItemHasProcedureStep ?stepId2.
                 ?stepId2 :procedureStepHasProcedureStepCollectionMembership/:procedureStepCollectionMembershipHasProcedureStepCollection id:TRohjSuI}
      OPTIONAL {
        ?workPackage :workPackageHasBusinessItem ?bi3 .
        ?bi3 :businessItemHasProcedureStep ?stepId3 .
        ?stepId3 :procedureStepHasProcedureStepCollectionMembership/
                 :procedureStepCollectionMembershipHasProcedureStepCollection id:7CBVQcZF
      }
 
        OPTIONAL {
        ?workPackage :workPackageHasBusinessItem ?bi4 .
        ?bi4 :businessItemHasProcedureStep ?stepId4 .
        ?stepId4 :procedureStepHasProcedureStepCollectionMembership/
                 :procedureStepCollectionMembershipHasProcedureStepCollection id:l3g2umNB
      }
         BIND(COALESCE(?businessItemDate, ?businessItemDate2) AS ?combinedDate)
         } Order by desc(?combinedDate)                
      
                   offset 0 limit 20