next
previous
items

Data table via SPARQL

Aggregated GHG emissions by sector, EU-28

Data table via SPARQL Published 30 Aug 2016 Last modified 16 Sep 2016

Download this dataset

Dataset preview

(Live Query)

year sectors obsValue
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Transport" "786"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "Transport" "792"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "Transport" "816"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "Transport" "821"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "Transport" "826"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "Transport" "839"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Transport" "865"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "Transport" "877"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "Transport" "905"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "Transport" "924"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 175 rows in 0.039 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/aggregated-ghg-emissions-by-sector/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 sectors: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/Sectors/>
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 skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX common_countries: <http://rdfdata.eionet.europa.eu/eea/countries/>

SELECT DISTINCT
xsd:int(?year) as ?year
bif:substring( ?sectors_label, (coalesce( xsd:integer(bif:strchr( ?sectors_label, '-')), -2) +3) , 50) as ?sectors
round(sum(?unfccc_crf)/1000) as ?obsValue

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

      _:unfccc_crf clrtap_nec_unfccc:unit 'Gg CO2 equivalent' . 
      _:unfccc_crf clrtap_nec_unfccc:pollutant_name 'All greenhouse gases - (CO2 equivalent)' .
      {
        _:unfccc_crf clrtap_nec_unfccc:sector_code ?sectors .
        FILTER (?sectors in (sector:2, sector:1.A.3, 
                           sector:3, sector:5, sector:6))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
      } UNION {
        { SELECT '1.x.x - Energy supply' as ?sectors_label {}}
        _:unfccc_crf clrtap_nec_unfccc:sector_code ?sectors_x .
        FILTER (?sectors_x in (sector:1.A.1, sector:1.B))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
      } UNION {
        { SELECT '1.A.4.x - Households and services' as ?sectors_label {}}
        _:unfccc_crf clrtap_nec_unfccc:sector_code ?sectors_x .
        FILTER (?sectors_x in (sector:1.A.4.a, sector:1.A.4.b))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
      }
    }
  }
  OPTIONAL { ?sectors rdfs:label ?sectors_label } .

  ?geo skos:notation ?geo_id .
  ?eeageo skos:notation ?geo_id .
  ?eeageo skos:inScheme common_countries: .
  common_countries:EU28 skos:member ?eeageo .
}
GROUP BY ?year ?sectors_code ?sectors_label
HAVING xsd:int(?year) >= 1990
ORDER BY ?sectors_label  ?year


Permalinks

Document Actions