query_14.txt

Budget volume in percentage of contracts awarded by each of the procedures provided for in the legislation.

PREFIX pproc: <http://contsem.unizar.es/def/sector-publico/pproc#>
PREFIX pc: <http://purl.org/procurement/public-contracts#>
PREFIX gr: <http://purl.org/goodrelations/v1#>
SELECT ?openPrice*100/?totalPrice as ?OpenProcedures ?negotiatedPrice*100/?totalPrice as ?NegotiatedProcedures ?minorPrice*100/?totalPrice as ?MinorProcedures
{

{SELECT SUM(distinct ?impAdjudicacionConIVA) as ?totalPrice
WHERE {
  ?uriCont a pproc:Contract;
  pproc:contractProcedureSpecifications ?procedureType;
  pc:tender ?tender.
  ?procedureType pproc:procedureType ?procedure.
  ?tender pproc:formalizedDate ?formalizedDate.
  ?uriCont pproc:contractObject/pproc:contractEconomicConditions ?cce.
  ?cce pproc:budgetPrice ?priceVAT .
  ?priceVAT gr:hasCurrencyValue ?impAdjudicacionConIVA;
  gr:valueAddedTaxIncluded "true"^^xsd:boolean.
  FILTER (regex(?formalizedDate, "2014") AND ?procedure IN (pproc:RegularOpen, pproc:Negotiated, pproc:Minor))
}}

{SELECT SUM(distinct ?impAdjudicacionConIVA) as ?openPrice
WHERE {
  ?uriCont a pproc:Contract;
  pproc:contractProcedureSpecifications ?procedureType;
  pc:tender ?tender.
  ?tender pproc:formalizedDate ?formalizedDate.
  ?procedureType pproc:procedureType ?procedure.
  ?uriCont pproc:contractObject/pproc:contractEconomicConditions ?cce.
  ?cce pproc:budgetPrice ?priceVAT .
  ?priceVAT gr:hasCurrencyValue ?impAdjudicacionConIVA;
  gr:valueAddedTaxIncluded "true"^^xsd:boolean.
  FILTER (regex(?formalizedDate, "2014")
         AND (?procedure = pproc:RegularOpen) )
}}

{SELECT SUM(distinct ?impAdjudicacionConIVA) as ?negotiatedPrice
WHERE {
  ?uriCont a pproc:Contract;
  pproc:contractProcedureSpecifications ?procedureType;
  pc:tender ?tender.
  ?tender pproc:formalizedDate ?formalizedDate.
  ?procedureType pproc:procedureType ?procedure.
  ?uriCont pproc:contractObject/pproc:contractEconomicConditions ?cce.
  ?cce pproc:budgetPrice ?priceVAT .
  ?priceVAT gr:hasCurrencyValue ?impAdjudicacionConIVA;
  gr:valueAddedTaxIncluded "true"^^xsd:boolean.
  FILTER (regex(?formalizedDate, "2014")
         AND (?procedure = pproc:Negotiated) )
}}

{SELECT SUM(distinct ?impAdjudicacionConIVA) as ?minorPrice
WHERE {
  ?uriCont a pproc:Contract;
  pproc:contractProcedureSpecifications ?procedureType;
  pc:tender ?tender.
  ?tender pproc:formalizedDate ?formalizedDate.
  ?procedureType pproc:procedureType ?procedure.
  ?uriCont pproc:contractObject/pproc:contractEconomicConditions ?cce.
  ?cce pproc:budgetPrice ?priceVAT .
  ?priceVAT gr:hasCurrencyValue ?impAdjudicacionConIVA;
  gr:valueAddedTaxIncluded "true"^^xsd:boolean.
  FILTER (regex(?formalizedDate, "2014")
         AND (?procedure = pproc:Minor) )
}}

}