Change in Final Energy Consumption for Air transport mode, EEA33, 1990-2016

Data table via SPARQL Last modified 16 Aug 2018
31 min read
Topics: ,

Download this dataset

Dataset preview

(Live Query)

indic_nrg ugeo obsValue
"Rail" "EEA-33" "-20"^^<http://www.w3.org/2001/XMLSchema#decimal>
"International Marine Bunkers" "EEA-33" "26.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Air Domestic/International" "EEA-33" "94.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Domestic Navigation" "EEA-33" "-25.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Road" "EEA-33" "31.7"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 5 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/change-in-final-energy-consumption-13/daviz.json

For system integrators

The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.

Are you new to Linked Data technology? visit http://linkeddata.org



http://semantic.eea.europa.eu/sparql

PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX product: <http://dd.eionet.europa.eu/vocabulary/eurostat/product/>
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT 
?indic_nrg_label as ?indic_nrg
'EEA-33' as ?ugeo
round((( SUM(?last_year)-SUM(?first_year) ) / SUM(?first_year) )*1000)/10.0 as ?obsValue
{{

  SELECT DISTINCT
  bif:either(?indic_nrg in (indic_nrg:B_101931, indic_nrg:B_101932), 'Air Domestic/International', ?indic_nrg_label) as ?indic_nrg_label
 bif:either(year(?date) = 1990, SUM(?obsValue), 0) as ?first_year
  bif:either(year(?date) = 2016, SUM(?obsValue), 0) as ?last_year

  WHERE {
  {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_102a.rdf.gz> 
      { 
        _:nrg_102a sdmx-dimension:timePeriod ?date .
        _:nrg_102a sdmx-attribute:unitMeasure unit:TJ .
        _:nrg_102a sdmx-dimension:refArea ?geo .
        _:nrg_102a property:product ?product . 
        FILTER (?product in (product:3220, product:3234, product:3235,
                             product:3246, product:3247, product:3260,
                             product:3270A))
        _:nrg_102a property:indic_nrg ?indic_nrg .
        _:nrg_102a sdmx-measure:obsValue ?obsValue .
   }
    } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_103a.rdf.gz> 
      { 
        _:nrg_103a sdmx-dimension:timePeriod ?date .
        _:nrg_103a sdmx-attribute:unitMeasure unit:TJ .
        _:nrg_103a sdmx-dimension:refArea ?geo .
        _:nrg_103a property:product product:4100 . 
        _:nrg_103a property:indic_nrg ?indic_nrg .
        _:nrg_103a sdmx-measure:obsValue ?obsValue .
   }
   } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_105a.rdf.gz> 
      { 
        _:nrg_105a sdmx-dimension:timePeriod ?date .
        _:nrg_105a sdmx-attribute:unitMeasure unit:TJ .
        _:nrg_105a sdmx-dimension:refArea ?geo .
        _:nrg_105a property:product product:6000 . 
        _:nrg_105a property:indic_nrg ?indic_nrg .
        _:nrg_105a sdmx-measure:obsValue ?obsValue .
   }
   } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_107a.rdf.gz> 
      { 
        _:nrg_107a sdmx-dimension:timePeriod ?date .
        _:nrg_107a sdmx-attribute:unitMeasure unit:TJ .
        _:nrg_107a sdmx-dimension:refArea ?geo .
        _:nrg_107a property:product ?product . 
        FILTER (?product in (product:5541, product:5542, product:5546,
                             product:5547, product:5548))
        _:nrg_107a property:indic_nrg ?indic_nrg .
        _:nrg_107a sdmx-measure:obsValue ?obsValue .
   }

   } 
   FILTER (?geo in (geo:EU28, geo:LI, geo:NO, geo:CH, geo:TR, geo:IS))
   ?geo rdfs:label ?ugeo .
   FILTER (?indic_nrg in (indic_nrg:B_101931, indic_nrg:B_101932, 
                          indic_nrg:B_100800, indic_nrg:B_101910, 
                          indic_nrg:B_101920, indic_nrg:B_101940)) 
   ?indic_nrg rdfs:label ?indic_nrg_label .
  }

}}
GROUP BY ?indic_nrg_label


Related content

Temporal coverage

Document Actions
Filed under: