National emissions (non-ETS)/EU

Data table via SPARQL Published 15 Jun 2016 Last modified 27 Oct 2016

Download this dataset

Dataset preview

(Live Query)

date ESD ETS
"1985"^^<http://www.w3.org/2001/XMLSchema#int> "" ""
"1986"^^<http://www.w3.org/2001/XMLSchema#int> "" ""
"1987"^^<http://www.w3.org/2001/XMLSchema#int> "" ""
"1988"^^<http://www.w3.org/2001/XMLSchema#int> "" ""
"1989"^^<http://www.w3.org/2001/XMLSchema#int> "" ""
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "" ""
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "" ""
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "" ""
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "" ""
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "" ""

Received 31 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/national-emissions-non-ets-eu-3/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 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 CITL_v: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CITL_v21.tsv#>
PREFIX sectors: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/Sectors/>

SELECT 
xsd:integer(?year) as ?date

round((( sum(?domestic_scope_without_aviation)/1000 - sum(?nf3 )/1000 -sum(?1_A_3_a)/1000 ) - sum(?CITL_v/1000000))) as ?ESD
sum(?CITL_v/1000000) as ?ETS


WHERE {
  { 
  GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
    {
      _:unfccc_crf clrtap_nec_unfccc:unit ?unit . 
      _:unfccc_crf clrtap_nec_unfccc:year ?year . 
      _:unfccc_crf clrtap_nec_unfccc:country_code ?geo . 

      {
        _:unfccc_crf clrtap_nec_unfccc:pollutant_name 'All greenhouse gases - (CO2 equivalent)' . 
        _:unfccc_crf clrtap_nec_unfccc:sector_code ?sectors .
        FILTER (?sectors in (sectors:Totals_excl_incl))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?domestic_scope_without_aviation .
      } UNION {
         _:unfccc_crf clrtap_nec_unfccc:pollutant_name 'NF3 - (CO2 equivalent)'  .
         _:unfccc_crf clrtap_nec_unfccc:sector_code ?sectors .
         FILTER (?sectors in (sectors:Totals_excl_incl))
         _:unfccc_crf clrtap_nec_unfccc:emissions ?nf3 .
      } UNION {
         _:unfccc_crf clrtap_nec_unfccc:pollutant_name 'CO2'  .
         _:unfccc_crf clrtap_nec_unfccc:sector_code ?sectors .
         FILTER (?sectors in (sector:1.A.3.a))
         _:unfccc_crf clrtap_nec_unfccc:emissions ?1_A_3_a .
      }

      FILTER (?geo in (geo:AT, geo:BE, geo:BG, geo:CY, geo:CZ, geo:DE, geo:DK, geo:EE, geo:ES,
             geo:FI, geo:FR, geo:GB, geo:GR, geo:HU, geo:IE, geo:IT, geo:LT, geo:LU, geo:LV,
             geo:MT, geo:NL, geo:PL, geo:PT, geo:RO, geo:SE, geo:SI, geo:SK, geo:HR))
    }
    } UNION {  
    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CITL_v21.tsv> 
    {
      _:CITL_v CITL_v:country_code ?geo .
      _:CITL_v CITL_v:main_activity_sector_name ?main_activity_sector_name . 
      FILTER (?main_activity_sector_name = '20-99 All stationary installations')
      _:CITL_v CITL_v:ETS_information ?ETS_information . 
      FILTER (?ETS_information in ('2. Verified emissions', 
      '3. Estimate to reflect current ETS scope for allowances and emissions'))

      _:CITL_v CITL_v:year ?year .
      _:CITL_v CITL_v:value ?CITL_v .
      _:CITL_v CITL_v:unit ?unit .
      FILTER (?geo in (geo:AT, geo:BE, geo:BG, geo:CY, geo:CZ, geo:DE, geo:DK, geo:EE, geo:ES,
               geo:FI, geo:FR, geo:GB, geo:GR, geo:HU, geo:IE, geo:IT, geo:LT, geo:LU, geo:LV,
               geo:MT, geo:NL, geo:PL, geo:PT, geo:RO, geo:SE, geo:SI, geo:SK, geo:HR))
    } 
 }
}
GROUP BY xsd:integer(?year)
HAVING xsd:integer(?year) != ''
ORDER BY ?year


Related content

Document Actions