Data table via SPARQL

Contribution of anthropogenic sources to total emissions of CO2, CH4 and N2O in EU28 for 2012

Data table via SPARQL Published 01 Oct 2014 Last modified 20 Apr 2016

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

pollutant_name	stationary_combustion	mobile_combustion	fugitive_fuel_emissions	industrial_processes_and_solvent_use	agriculture	waste_handling	other	total_emissions
"N2O"	"6.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"3.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"0"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"80.9"^^<http://www.w3.org/2001/XMLSchema#decimal>	"4.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"0"^^<http://www.w3.org/2001/XMLSchema#decimal>	"1083"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CH4"	"4.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"0.3"^^<http://www.w3.org/2001/XMLSchema#decimal>	"14.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"0.3"^^<http://www.w3.org/2001/XMLSchema#decimal>	"49.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"31"^^<http://www.w3.org/2001/XMLSchema#decimal>	"0"^^<http://www.w3.org/2001/XMLSchema#decimal>	"18970"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CO2"	"64.8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"29"^^<http://www.w3.org/2001/XMLSchema#decimal>	"0.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5.5"^^<http://www.w3.org/2001/XMLSchema#decimal>	""	"0.1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"0"^^<http://www.w3.org/2001/XMLSchema#decimal>	"3994971"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 3 rows in 0.018 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/contribution-of-anthropogenic-sources-to/daviz.json

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
semantic.eea.europa.eu/sparql

SPARQL Query:


        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/>

SELECT 
?pollutant_name
round(sum(?stationary_combustion)/sum(?total_emissions)*1000)/10.0 as  ?stationary_combustion
round(sum(?mobile_combustion)/sum(?total_emissions)*1000)/10 as  ?mobile_combustion
round(sum(?fugitive_fuel_emissions)/sum(?total_emissions)*1000)/10.0 as  ?fugitive_fuel_emissions
round(sum(?industrial_processes_and_solvent_use)/sum(?total_emissions)*1000)/10.0 as  ?industrial_processes_and_solvent_use
round(sum(?agriculture)/sum(?total_emissions)*1000)/10.0 as  ?agriculture
round(sum(?waste_handling)/sum(?total_emissions)*1000)/10.0 as  ?waste_handling
round(sum(?other)/sum(?total_emissions)*1000)/10.0 as  ?other
sum(?total_emissions) as ?total_emissions

WHERE {
{ 
 GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
  {
  _:unfccc_crf clrtap_nec_unfccc:year ?year . FILTER (?year = '2012')
    _:unfccc_crf clrtap_nec_unfccc:country_code geo:EU28 .
  _:unfccc_crf clrtap_nec_unfccc:pollutant_name ?pollutant_name . 
  FILTER (?pollutant_name in ('CH4', 'CO2', 'N2O'))
  _:unfccc_crf clrtap_nec_unfccc:unit ?unit .
 
  {
    _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code .
    FILTER (?sector_code in (
     sector:1.A.1.A, sector:1.A.1.B, sector:1.A.1.C, sector:1.A.2.A,
     sector:1.A.2.B, sector:1.A.2.C, sector:1.A.2.D, sector:1.A.2.E,
     sector:1.A.2.F, sector:1.A.4.A, sector:1.A.4.B, sector:1.A.4.C,
     sector:1.A.5.A, sector:1.A.5.B))
    _:unfccc_crf clrtap_nec_unfccc:emissions ?stationary_combustion .    
  } UNION {
    _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code .
    FILTER (?sector_code in (
     sector:1.A.3.A, sector:1.A.3.B,
     sector:1.A.3.C, sector:1.A.3.D,
     sector:1.A.3.E, sector:1.C1.A, sector:1.C1.B))
    _:unfccc_crf clrtap_nec_unfccc:emissions ?mobile_combustion .    
  } UNION {
    _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code .
    FILTER (?sector_code in (sector:1.B))
    _:unfccc_crf clrtap_nec_unfccc:emissions ?fugitive_fuel_emissions .
  } UNION {
     _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code .
     FILTER (?sector_code in (
     sector:2.A, sector:2.B, sector:2.C, sector:2.D,
     sector:2.E, sector:2.F, sector:2.G, sector:3))
    _:unfccc_crf clrtap_nec_unfccc:emissions ?industrial_processes_and_solvent_use . 
  } UNION {
    _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code .
    FILTER (?sector_code in (
     sector:4.A, sector:4.B, sector:4.C, sector:4.D,
     sector:4.E,sector:4.F,  sector:4.G))
    _:unfccc_crf clrtap_nec_unfccc:emissions ?agriculture . 
  } UNION {
    _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code .
    FILTER (?sector_code in (
    sector:6.A, sector:6.B, sector:6.C, sector:6.D))
    _:unfccc_crf clrtap_nec_unfccc:emissions ?waste_handling .
  } UNION {
    _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code .
    FILTER (?sector_code in (sector:7))
    _:unfccc_crf clrtap_nec_unfccc:emissions ?other .
  } UNION {
    _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code .
    FILTER (?sector_code in (sector:NT_excl, sector:1.C1.A, sector:1.C1.B)) .
    _:unfccc_crf clrtap_nec_unfccc:emissions ?total_emissions .
  }
  } 
 }
}
GROUP BY ?pollutant_name