Historic and projected trends of GHG emissions-distance to target

Data table via SPARQL expired Published 27 May 2014 Last modified 26 Aug 2017
This is an old version, kept for reference only.

Go to latest version
This page was archived on 26 Aug 2017 with reason: A new version has been published

Download this dataset

Dataset preview

(Live Query)

year GHG_eu28 GHG_eu15 GHG_difference ghg_projections CP1_targets_eu15 CP1_targets_eu28 CP1_targets_difference
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "5626"^^<http://www.w3.org/2001/XMLSchema#decimal> "4262"^^<http://www.w3.org/2001/XMLSchema#decimal> "1364"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "5522"^^<http://www.w3.org/2001/XMLSchema#decimal> "4279"^^<http://www.w3.org/2001/XMLSchema#decimal> "1243"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "5325"^^<http://www.w3.org/2001/XMLSchema#decimal> "4190"^^<http://www.w3.org/2001/XMLSchema#decimal> "1135"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "5223"^^<http://www.w3.org/2001/XMLSchema#decimal> "4124"^^<http://www.w3.org/2001/XMLSchema#decimal> "1099"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "5199"^^<http://www.w3.org/2001/XMLSchema#decimal> "4127"^^<http://www.w3.org/2001/XMLSchema#decimal> "1072"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "5253"^^<http://www.w3.org/2001/XMLSchema#decimal> "4171"^^<http://www.w3.org/2001/XMLSchema#decimal> "1082"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "5361"^^<http://www.w3.org/2001/XMLSchema#decimal> "4253"^^<http://www.w3.org/2001/XMLSchema#decimal> "1108"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "5261"^^<http://www.w3.org/2001/XMLSchema#decimal> "4184"^^<http://www.w3.org/2001/XMLSchema#decimal> "1077"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "5221"^^<http://www.w3.org/2001/XMLSchema#decimal> "4205"^^<http://www.w3.org/2001/XMLSchema#decimal> "1016"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "5111"^^<http://www.w3.org/2001/XMLSchema#decimal> "4141"^^<http://www.w3.org/2001/XMLSchema#decimal> "970"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""

Received 31 rows in 0.006 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/historic-and-projected-trends-of/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



semantic.eea.europa.eu/sparql

PREFIX clrtap_nec_unfccc: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/schema/>
PREFIX geo: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>
PREFIX sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ghg_projections: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/ghg_projections_092013.tsv#>
PREFIX CP1_targets_EU28: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CP1_targets_for_EU28_052014.tsv#>
PREFIX CP1_targets_EU15: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CP1_targets_for_EU15_052014.tsv#>

SELECT
xsd:integer(?year) as ?year

round(sum(?unfccc_crf_eu28)/1000) as ?GHG_eu28
round(sum(?unfccc_crf_eu15)/1000) as ?GHG_eu15
round((sum(?unfccc_crf_eu28) - sum(?unfccc_crf_eu15))/1000) as ?GHG_difference
round(sum(?ghg_projections)/1000) as ?ghg_projections
round(sum(?CP1_targets_eu15)) as ?CP1_targets_eu15
round(sum(?CP1_targets_eu28)) as ?CP1_targets_eu28

round(sum(?CP1_targets_eu28) - (sum(?unfccc_crf_eu28)/1000)) as ?CP1_targets_difference

WHERE {
  { 
    GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
    {
      _:unfccc_crf clrtap_nec_unfccc:unit ?unit . FILTER (?unit = 'Gg CO2 equivalent')
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sector:1, sector:2, sector:3, sector:4, sector:6, sector:7))
      _:unfccc_crf clrtap_nec_unfccc:pollutant_name ?pollutant_name . 
      FILTER (?pollutant_name = 'All greenhouse gases - (CO2 equivalent)')
      _:unfccc_crf clrtap_nec_unfccc:year ?year . FILTER (?year != ('KPBY'))

      {
        _:unfccc_crf clrtap_nec_unfccc:country_code ?geo . FILTER (?geo in (geo:EU28))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf_eu28 .
      } UNION {
        _:unfccc_crf clrtap_nec_unfccc:country_code ?geo . FILTER (?geo in (geo:EU15))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf_eu15 .
      }
    }
  } UNION {

    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/ghg_projections_092013.tsv> 
    {
      _:ghg_projections ghg_projections:country ?country  .
      _:ghg_projections ghg_projections:year ?year . FILTER (xsd:integer(?year) > 2012)
      _:ghg_projections ghg_projections:value ?ghg_projections .
    } 
  } UNION {
    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CP1_targets_for_EU28_052014.tsv> 
    {
      _:CP1_targets_EU28 CP1_targets_EU28:geo ?geo .
      _:CP1_targets_EU28 CP1_targets_EU28:year ?year .
      _:CP1_targets_EU28 CP1_targets_EU28:value ?CP1_targets_eu28 .
    } 
  } UNION {
    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CP1_targets_for_EU15_052014.tsv> 
    {
      _:CP1_targets_EU15 CP1_targets_EU15:geo ?geo .
      _:CP1_targets_EU15 CP1_targets_EU15:year ?year .
      _:CP1_targets_EU15 CP1_targets_EU15:value ?CP1_targets_eu15 .
    } 
  }
}
GROUP BY xsd:integer(?year)
ORDER BY xsd:integer(?year)


Related content

Document Actions