Personal tools

next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Data visualisations / Semantic Data Service (sparql repository) / Trends in total energy intensity, gross domestic product and total energy consumption, EU-27

Trends in total energy intensity, gross domestic product and total energy consumption, EU-27

Topics: ,

Download this dataset

Dataset preview

(Live Query)

No results were found.


http://www.eea.europa.eu/data-and-maps/daviz/sds/trends-in-total-energy-intensity/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

#http://www.eea.europa.eu/data-and-maps/figures/trends-in-total-energy-intensity-4 PREFIX qb: <http://purl.org/linked-data/cube#> PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> PREFIX sdmx-unit: <http://purl.org/linked-data/sdmx/2009/code#> PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> PREFIX i_na: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_na#> PREFIX i_ng: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_nrg#> PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#> PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#> SELECT year(?date) as ?date (round((?obsValue_nrg/?obsValue_nrg_idx)*1000))/10.0 as ?total_energy_consumption (round((?obsValue_gdp/?obsValue_gdp_idx)*1000))/10.0 as ?gross_domestic_product_at_2000_market_prices (round(((?obsValue_nrg/(?obsValue_gdp/1000))/(?obsValue_nrg_idx/(?obsValue_gdp_idx/1000)))*1000))/10.0 as ?total_energy_intensity #GDP Forecast - Annotation Line bif:either(year(?date) = 2011, 'GDP Forecast','') AS ?annotation_line {{ SELECT ?date sum(?obsValue_nrg) as ?obsValue_nrg sum(?obsValue_gdp) as ?obsValue_gdp sum(?obsValue_nrg_idx) as ?obsValue_nrg_idx sum(?obsValue_gdp_idx) as ?obsValue_gdp_idx WHERE { { _:nama_gdp_k qb:dataSet <http://rdfdata.eionet.europa.eu/eurostat/data/nama_gdp_k> . _:nama_gdp_k sdmx-dimension:timePeriod ?date FILTER (?date >= "1995-01-01"^^xsd:date) _:nama_gdp_k property:indic_na i_na:B1GM . _:nama_gdp_k property:unit u:MIO_EUR_CLV2000 . _:nama_gdp_k property:geo geo:EU27 . OPTIONAL { _:nama_gdp_k sdmx-measure:obsValue ?obsValue_gdp . } #index value on 1995 _:nama_gdp_k_idx qb:dataSet <http://rdfdata.eionet.europa.eu/eurostat/data/nama_gdp_k> . _:nama_gdp_k_idx sdmx-dimension:timePeriod ?date_gdp_idx FILTER (?date_gdp_idx = "1995-01-01"^^xsd:date) _:nama_gdp_k_idx property:indic_na i_na:B1GM . _:nama_gdp_k_idx property:unit u:MIO_EUR_CLV2000 . _:nama_gdp_k_idx property:geo geo:EU27 . OPTIONAL { _:nama_gdp_k_idx sdmx-measure:obsValue ?obsValue_gdp_idx . } } UNION { _:nrg_100a qb:dataSet <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a> . _:nrg_100a sdmx-dimension:freq sdmx-unit:freq-A . _:nrg_100a sdmx-dimension:timePeriod ?date FILTER (?date >= "1995-01-01"^^xsd:date) _:nrg_100a property:indic_nrg i_ng:B_100900 . _:nrg_100a property:geo geo:EU27 . _:nrg_100a property:unit u:1000TOE . OPTIONAL { _:nrg_100a sdmx-measure:obsValue ?obsValue_nrg . } #index value on 1995 _:nrg_100a_idx qb:dataSet <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a> . _:nrg_100a_idx sdmx-dimension:freq sdmx-unit:freq-A . _:nrg_100a_idx sdmx-dimension:timePeriod ?date_nrg_idx FILTER (?date_nrg_idx = "1995-01-01"^^xsd:date) _:nrg_100a_idx property:indic_nrg i_ng:B_100900 . _:nrg_100a_idx property:geo geo:EU27 . _:nrg_100a_idx property:unit u:1000TOE . OPTIONAL { _:nrg_100a_idx sdmx-measure:obsValue ?obsValue_nrg_idx . } }} }} GROUP BY ?date ORDER BY ?date


Geographic coverage

Austria Belgium Bulgaria Cyprus Czech Republic Denmark Estonia Finland France Germany Greece Hungary Ireland Italy Latvia Lithuania Luxembourg Malta Netherlands Poland Portugal Romania Slovakia Slovenia Spain Sweden United Kingdom
Document Actions
Filed under: ,

Comments

Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
 
 
 
 
 
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100