Base year and average 2008-2012 GHG emissions

Data table via SPARQL Published 02 Jun 2014 Last modified 20 Apr 2016

Download this dataset

Dataset preview

(Live Query)

geo unfccc_crf_KPBY unfccc_crf_avg
"Austria" "79"^^<http://www.w3.org/2001/XMLSchema#int> "82"^^<http://www.w3.org/2001/XMLSchema#int>
"Belgium" "145"^^<http://www.w3.org/2001/XMLSchema#int> "125"^^<http://www.w3.org/2001/XMLSchema#int>
"Bulgaria" "132"^^<http://www.w3.org/2001/XMLSchema#int> "62"^^<http://www.w3.org/2001/XMLSchema#int>
"Croatia" "31"^^<http://www.w3.org/2001/XMLSchema#int> "28"^^<http://www.w3.org/2001/XMLSchema#int>
"Cyprus" "0"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#int>
"Czech Republic" "194"^^<http://www.w3.org/2001/XMLSchema#int> "136"^^<http://www.w3.org/2001/XMLSchema#int>
"Denmark" "69"^^<http://www.w3.org/2001/XMLSchema#int> "58"^^<http://www.w3.org/2001/XMLSchema#int>
"Estonia" "42"^^<http://www.w3.org/2001/XMLSchema#int> "19"^^<http://www.w3.org/2001/XMLSchema#int>
"Finland" "71"^^<http://www.w3.org/2001/XMLSchema#int> "67"^^<http://www.w3.org/2001/XMLSchema#int>
"France" "563"^^<http://www.w3.org/2001/XMLSchema#int> "507"^^<http://www.w3.org/2001/XMLSchema#int>

Received 30 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/base-year-and-average/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#>

SELECT 
?geo

(round(sum(?unfccc_crf_KPBY)/100))/10  as ?unfccc_crf_KPBY
(round((avg(?unfccc_crf_avg))/100))/10 as ?unfccc_crf_avg

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:unit ?unit . FILTER (?unit = 'Gg CO2 equivalent')
      _: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_KPBY .
      } 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 .
      }
    }
    ?country_code rdf-schema:label ?geo .
    FILTER (?country_code != geo:EEA33 and ?country_code != geo:EU28 and ?country_code != geo:EU15 and ?country_code != geo:TR and ?country_code != geo:EURO and ?country_code != geo:NO and ?country_code != geo:CH)
  }
}
GROUP BY ?geo
ORDER BY ?geo


Related content

Document Actions