next
previous
items

Data table via SPARQL

Historic and projected trends of GHG emissions-distance to target

Data table via SPARQL Published 23 Oct 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_eea33 GHG_eu28 GHG_eu15 GHG_eea33_eu28 GHG_eu28_eu15 proxy wem_ghg_projections wam_ghg_projections CP1_targets_eu15 CP1_targets_eu28 CP1_targets_difference
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "5922"^^<http://www.w3.org/2001/XMLSchema#decimal> "5626"^^<http://www.w3.org/2001/XMLSchema#decimal> "4262"^^<http://www.w3.org/2001/XMLSchema#decimal> "295"^^<http://www.w3.org/2001/XMLSchema#decimal> "1364"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" "" "" ""
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "5829"^^<http://www.w3.org/2001/XMLSchema#decimal> "5522"^^<http://www.w3.org/2001/XMLSchema#decimal> "4279"^^<http://www.w3.org/2001/XMLSchema#decimal> "307"^^<http://www.w3.org/2001/XMLSchema#decimal> "1243"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" "" "" ""
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "5641"^^<http://www.w3.org/2001/XMLSchema#decimal> "5325"^^<http://www.w3.org/2001/XMLSchema#decimal> "4190"^^<http://www.w3.org/2001/XMLSchema#decimal> "316"^^<http://www.w3.org/2001/XMLSchema#decimal> "1135"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" "" "" ""
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "5550"^^<http://www.w3.org/2001/XMLSchema#decimal> "5223"^^<http://www.w3.org/2001/XMLSchema#decimal> "4124"^^<http://www.w3.org/2001/XMLSchema#decimal> "327"^^<http://www.w3.org/2001/XMLSchema#decimal> "1099"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" "" "" ""
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "5522"^^<http://www.w3.org/2001/XMLSchema#decimal> "5199"^^<http://www.w3.org/2001/XMLSchema#decimal> "4127"^^<http://www.w3.org/2001/XMLSchema#decimal> "323"^^<http://www.w3.org/2001/XMLSchema#decimal> "1072"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" "" "" ""
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "5597"^^<http://www.w3.org/2001/XMLSchema#decimal> "5253"^^<http://www.w3.org/2001/XMLSchema#decimal> "4171"^^<http://www.w3.org/2001/XMLSchema#decimal> "344"^^<http://www.w3.org/2001/XMLSchema#decimal> "1082"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" "" "" ""
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "5730"^^<http://www.w3.org/2001/XMLSchema#decimal> "5361"^^<http://www.w3.org/2001/XMLSchema#decimal> "4253"^^<http://www.w3.org/2001/XMLSchema#decimal> "369"^^<http://www.w3.org/2001/XMLSchema#decimal> "1108"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" "" "" ""
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "5643"^^<http://www.w3.org/2001/XMLSchema#decimal> "5261"^^<http://www.w3.org/2001/XMLSchema#decimal> "4184"^^<http://www.w3.org/2001/XMLSchema#decimal> "382"^^<http://www.w3.org/2001/XMLSchema#decimal> "1077"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" "" "" ""
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "5607"^^<http://www.w3.org/2001/XMLSchema#decimal> "5221"^^<http://www.w3.org/2001/XMLSchema#decimal> "4205"^^<http://www.w3.org/2001/XMLSchema#decimal> "385"^^<http://www.w3.org/2001/XMLSchema#decimal> "1016"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" "" "" ""
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "5499"^^<http://www.w3.org/2001/XMLSchema#decimal> "5111"^^<http://www.w3.org/2001/XMLSchema#decimal> "4141"^^<http://www.w3.org/2001/XMLSchema#decimal> "387"^^<http://www.w3.org/2001/XMLSchema#decimal> "970"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" "" "" ""

Received 31 rows in 0.006 seconds.


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

SELECT
xsd:integer(?year) as ?year

round(sum(?unfccc_crf_eea33)/1000) AS ?GHG_eea33
round(sum(?unfccc_crf_eu28)/1000) AS ?GHG_eu28
round(sum(?unfccc_crf_eu15)/1000) AS ?GHG_eu15

round(( sum(coalesce(?unfccc_crf_eea33, 0.0)) -  sum(coalesce(?unfccc_crf_eu28, 0.0))      )/1000) as ?GHG_eea33_eu28
round(( sum(coalesce(?unfccc_crf_eu28, 0.0)) -  sum(coalesce(?unfccc_crf_eu15, 0.0))      )/1000) as ?GHG_eu28_eu15

#value for 2013 coming from PROXI
#bif:either(xsd:integer(?year) = 2013, 4464, '') as ?proxy
bif:either(xsd:integer(?year) = 2013, 4464, bif:either(xsd:integer(?year) = 2012, round(sum(?unfccc_crf_eu28)/1000), '')) as ?proxy

#bif:either(xsd:integer(?year) = 2013, '', round(sum(?ghg_projections)/1000)) as ?ghg_projections

bif:either(xsd:integer(?year) >= 2010, round(sum(?wem_ghg_projections)/1000), '') as ?wem_ghg_projections
bif:either(xsd:integer(?year) >= 2010,  round(sum(?wam_ghg_projections)/1000), '') as ?wam_ghg_projections

bif:either(xsd:integer(?year) in (2008, 2009, 2010, 2011, 2012), 3926, '') as ?CP1_targets_eu15
bif:either(xsd:integer(?year) in (2008, 2009, 2010, 2011, 2012), 5339.48, '') as ?CP1_targets_eu28
bif:either(xsd:integer(?year) in (2008, 2009, 2010, 2011, 2012), 5339.48 - 3926, '') 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 {
        _:unfccc_crf clrtap_nec_unfccc:country_code ?geo . FILTER (?geo in (geo:EEA33))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf_eea33 .
      }
    }
  } UNION {

    GRAPH <http://semantic.eea.europa.eu/project/ghg_projections/ghg_projections.tsv> 
    {
       _:ghg_projections ghg_projections:country_code ?geo . FILTER (?geo != geo:NO and ?geo != geo:CH and ?geo != geo:LI)
       _:ghg_projections ghg_projections:sector ?sector .
       FILTER (?sector in ('Energy total (1)', 'Industrial processes (2)', 'Other (3 + 7)', 'Agriculture (4)', 'Waste (6)'))
       _:ghg_projections ghg_projections:m_r ?m_r .
       _:ghg_projections ghg_projections:year ?year . FILTER (xsd:integer(?year) >= 2010 and xsd:integer(?year) <= 2020)
       _:ghg_projections ghg_projections:pollutant_name ?pollutant_name  . 
       FILTER (?pollutant_name = 'Total GHG (Gg CO2 equivalent)')
       
       {
         _:ghg_projections ghg_projections:scenario ?scenario . FILTER (?scenario = 'WEM')
         _:ghg_projections ghg_projections:emissions ?wem_ghg_projections .
       } UNION {
         _:ghg_projections ghg_projections:scenario ?scenario . FILTER (?scenario = 'WAM')
         _:ghg_projections ghg_projections:emissions ?wam_ghg_projections .
       }
    } 
  }
}
GROUP BY xsd:integer(?year)
ORDER BY xsd:integer(?year)


Permalinks

Document Actions