next
previous
items

Data table via SPARQL

Total GHG emissions and Kyoto (or burden-sharing) targets

Data table via SPARQL Published 12 Nov 2014 Last modified 29 Jan 2016

Download this dataset

Dataset preview

(Live Query)

country average perc_target
"Austria" "5" "-13"^^<http://www.w3.org/2001/XMLSchema#int>
"Belgium" "-14" "-7"^^<http://www.w3.org/2001/XMLSchema#int>
"Bulgaria" "-53" "-8"^^<http://www.w3.org/2001/XMLSchema#int>
"Croatia" "-8" "-5"^^<http://www.w3.org/2001/XMLSchema#int>
"Cyprus" "" "0"^^<http://www.w3.org/2001/XMLSchema#int>
"Czech Republic" "-30" "-8"^^<http://www.w3.org/2001/XMLSchema#int>
"Denmark" "-15" "-19"^^<http://www.w3.org/2001/XMLSchema#int>
"EEA33" "" ""
"EU15" "-12" "-8"^^<http://www.w3.org/2001/XMLSchema#int>
"EU28" "" ""

Received 37 rows in 0.001 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/total-ghg-emissions-and-kyoto/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 CP1_targets: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CP1_targets_112014.tsv#>

SELECT distinct
?country
#IF(sum(?unfccc_crf_by)>0, round(((sum(?unfccc_crf_avg)/5)/ sum(?unfccc_crf_by)-1)*100), '') as ?average

#Iceland has a different agreement
IF(sum(?unfccc_crf_by)>0, IF(?country_code != geo:IS, round(((sum(?unfccc_crf_avg)/5)/ sum(?unfccc_crf_by)-1)*100), round(((3466)/ sum(?unfccc_crf_by)-1)*100) ), '') as ?average

sum(xsd:integer(?perc_target)) as ?perc_target

WHERE {
  { 
    GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
    {
      _:unfccc_crf clrtap_nec_unfccc:country_code ?country_code .
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sector:NT_excl))
      _: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 in ('Kyoto Base-year'))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf_by .
      } UNION {
        _:unfccc_crf clrtap_nec_unfccc:year ?year . FILTER (?year in ('2008','2009','2010','2011','2012'))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf_avg .
      }
    }
    } UNION { 
    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CP1_targets_112014.tsv> 
    { 
      _:CP1_targets CP1_targets:country ?country_code . 
      _:CP1_targets CP1_targets:perc_target ?perc_target . 
    } 
  }
?country_code rdf-schema:label ?country .
}
GROUP BY ?country ?country_code
ORDER BY ?country


Permalinks

Document Actions