Do something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data table via SPARQL
Received 24 rows in 0.002 seconds.
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.
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/>
SELECT
year(?date) as ?year
round(sum(?road_gasoline)/100000)/10.0 as ?road_gasoline
round(sum(?road_diesel)/100000)/10.0 as ?road_diesel
round(sum(?rail_gas_diesel_oil)/100000)/10.0 as ?rail_gas_diesel_oil
round(sum(?rail_residual_fuel_oil)/100000)/10.0 as ?rail_residual_fuel_oil
round(sum(?rail_electricity)/100000)/10.0 as ?rail_electricity
round(sum(?aviation_gasoline)/100000)/10.0 as ?aviation_gasoline
round(sum(?aviation_kerosene)/100000)/10.0 as ?aviation_kerosene
round(sum(?ship_diesel_gas_oil)/100000)/10.0 as ?ship_diesel_gas_oil
round(sum(?ship_residual_fuel_oil)/100000)/10.0 as ?ship_residual_fuel_oil
round(sum(?ship_gasoline)/100000)/10.0 as ?ship_gasoline
round(sum(?biogasoline)/100000)/10.0 as ?biogasoline
round(sum(?biodiesel)/100000)/10.0 as ?biodiesel
round(sum(?natural_gas)/100000)/10.0 as ?natural_gas
round(sum(?lpg)/100000)/10.0 as ?lpg
round((sum(?road_gasoline)+sum(?road_diesel)+sum(?rail_gas_diesel_oil)+sum(?rail_residual_fuel_oil)+sum(?aviation_gasoline)+sum(?aviation_kerosene)+sum(?ship_diesel_gas_oil)+sum(?ship_residual_fuel_oil)+sum(?ship_gasoline)+sum(?lpg))/100000)/10.0 as ?oil_derived_fuels
round((sum(?road_gasoline)+sum(?road_diesel)+sum(?rail_gas_diesel_oil)+sum(?rail_residual_fuel_oil)+sum(?aviation_gasoline)+sum(?aviation_kerosene)+sum(?ship_diesel_gas_oil)+sum(?ship_residual_fuel_oil)+sum(?ship_gasoline)+sum(?lpg))/100000)/10.0*0.3 AS ?annotation_line_computed
#use of the computed value for 2008 as constant for all the years
xsd:decimal(5.19) as ?annotation_line
round(sum(?liquid_biofuels)/100000)/10.0 as ?liquid_biofuels
WHERE {
{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_102a.rdf.gz>
{
_:nrg_102a sdmx-dimension:refArea ?geo .
_:nrg_102a sdmx-attribute:unitMeasure unit:TJ .
_:nrg_102a sdmx-dimension:timePeriod ?date .
{
_:nrg_102a property:indic_nrg indic_nrg:B_101920 .
{
_:nrg_102a property:product product:3234 .
_:nrg_102a sdmx-measure:obsValue ?road_gasoline .
} UNION {
_:nrg_102a property:product product:3260 .
_:nrg_102a sdmx-measure:obsValue ?road_diesel .
} UNION {
_:nrg_102a property:product product:3220 .
_:nrg_102a sdmx-measure:obsValue ?lpg .
}
} UNION {
_:nrg_102a property:indic_nrg indic_nrg:B_101910 .
{
_:nrg_102a property:product product:3260 .
_:nrg_102a sdmx-measure:obsValue ?rail_gas_diesel_oil .
} UNION {
_:nrg_102a property:product product:3270A .
_:nrg_102a sdmx-measure:obsValue ?rail_residual_fuel_oil .
}
} UNION {
_:nrg_102a property:indic_nrg ?indic_nrg FILTER (?indic_nrg IN (indic_nrg:B_101931,indic_nrg:B_101932)) .
{
_:nrg_102a property:product product:3235 .
_:nrg_102a sdmx-measure:obsValue ?aviation_gasoline .
} UNION {
_:nrg_102a property:product product:3247 .
_:nrg_102a sdmx-measure:obsValue ?aviation_kerosene .
}
} UNION {
_:nrg_102a property:indic_nrg ?indic_nrg FILTER (?indic_nrg IN (indic_nrg:B_101940,indic_nrg:B_100800)) .
{
_:nrg_102a property:product product:3260 .
_:nrg_102a sdmx-measure:obsValue ?ship_diesel_gas_oil .
} UNION {
_:nrg_102a property:product product:3270A .
_:nrg_102a sdmx-measure:obsValue ?ship_residual_fuel_oil .
} UNION {
_:nrg_102a property:product product:3234 .
_:nrg_102a sdmx-measure:obsValue ?ship_gasoline .
}
}
}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_105a.rdf.gz>
{
_:nrg_105a sdmx-dimension:refArea ?geo .
_:nrg_105a sdmx-dimension:timePeriod ?date .
_:nrg_105a sdmx-attribute:unitMeasure unit:TJ .
_:nrg_105a property:indic_nrg indic_nrg:B_101910 .
_:nrg_105a property:product product:6000 .
_:nrg_105a sdmx-measure:obsValue ?rail_electricity .
}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_107a.rdf.gz>
{
_:nrg_107a sdmx-dimension:refArea ?geo .
_:nrg_107a sdmx-dimension:timePeriod ?date .
_:nrg_107a sdmx-attribute:unitMeasure unit:TJ .
_:nrg_107a property:indic_nrg ?indic_nrg FILTER(?indic_nrg in (indic_nrg:B_101900, indic_nrg:B_101940)) .
{
_:nrg_107a property:product product:5546 .
_:nrg_107a sdmx-measure:obsValue ?biogasoline .
} UNION {
_:nrg_107a property:product product:5547 .
_:nrg_107a sdmx-measure:obsValue ?biodiesel .
} UNION {
_:nrg_107a property:product product:5545.
_:nrg_107a sdmx-measure:obsValue ?liquid_biofuels .
}
}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_103a.rdf.gz>
{
_:nrg_103a sdmx-dimension:refArea ?geo .
_:nrg_103a sdmx-dimension:timePeriod ?date .
_:nrg_103a sdmx-attribute:unitMeasure unit:TJ .
_:nrg_103a property:indic_nrg indic_nrg:B_101920 .
_:nrg_103a property:product product:4100 .
_:nrg_103a sdmx-measure:obsValue ?natural_gas .
}
}
?geo skos:notation ?ugeo FILTER (?ugeo in ('EU28')) .
} GROUP BY YEAR(?date)
ORDER BY ?date
For references, please go to https://eea.europa.eu./data-and-maps/daviz/sds/transport-energy-consumption-eea-1 or scan the QR code.
PDF generated on 23 Nov 2024, 10:24 AM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others