next
previous
items

Contribution of anthropogenic sources to total emissions of NOx, NMVOC, SO2, NH3 and PM2.5 in EU28 for 2012

Data table via SPARQL Published 01 Oct 2014 Last modified 01 Feb 2016

Download this dataset

Dataset preview

(Live Query)

pollutant_name stationary_combustion mobile_combustion fugitive_fuel_emissions industrial_processes_and_solvent_use agriculture waste_handling other total_emissions
"PM2.5" "60.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "25.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "1394"^^<http://www.w3.org/2001/XMLSchema#decimal>
"NH3" "0.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "93.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "3669"^^<http://www.w3.org/2001/XMLSchema#decimal>
"NMVOC" "19.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "51.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "6793"^^<http://www.w3.org/2001/XMLSchema#decimal>
"NOx" "39.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "56.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "2"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "10723"^^<http://www.w3.org/2001/XMLSchema#decimal>
"SOx" "66.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "27.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "5377"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 5 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/contribution-of-anthropogenic-sources-to-2/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/clrtap_nec_nfr09_sector/>

SELECT DISTINCT
?pollutant_name
round(sum(?stationary_combustion)/sum(?total_emissions)*1000)/10.0 as ?stationary_combustion 
#sum(?stationary_combustion)/sum(?total_emissions) as ?stationary_combustion_abs
#sum(?stationary_combustion) as ?stationary_combustion_1
round(sum(?mobile_combustion)/sum(?total_emissions)*1000)/10.0 as ?mobile_combustion 
#sum(?mobile_combustion)/sum(?total_emissions) as ?mobile_combustion_abs
#sum(?mobile_combustion) as ?mobile_combustion_1
round(sum(?fugitive_emissions)/sum(?total_emissions)*1000)/10.0 as ?fugitive_fuel_emissions 
#sum(?fugitive_emissions)/sum(?total_emissions) as ?fugitive_fuel_emissions_abs
#sum(?fugitive_emissions) as ?fugitive_fuel_emissions
round(sum(?industrial_processes_and_solvent_use)/sum(?total_emissions)*1000)/10.0 as ?industrial_processes_and_solvent_use 
#sum(?industrial_processes_and_solvent_use)/sum(?total_emissions) as ?industrial_processes_and_solvent_use_abs
#sum(?industrial_processes_and_solvent_use) as ?industrial_processes_and_solvent_use
round(sum(?agriculture)/sum(?total_emissions)*1000)/10.0 as ?agriculture 
#sum(?agriculture)/sum(?total_emissions) as ?agriculture_abs
#sum(?agriculture) as ?agriculture
round(sum(?waste_handling)/sum(?total_emissions)*1000)/10.0 as ?waste_handling 
#sum(?waste_handling)/sum(?total_emissions) as ?waste_handling_abs
#sum(?waste_handling) as ?waste_handling
round(sum(?other)/sum(?total_emissions)*1000)/10.0 as ?other 
#sum(?other)/sum(?total_emissions) as ?other_abs
#sum(?other) as ?other
sum(?total_emissions) as ?total_emissions

WHERE {{  
  GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/clrtap_nfr09_gf.rdf.gz> 
  {
   ?clrtap_nfr09_gf clrtap_nec_unfccc:country_code geo:EU28 .
   ?clrtap_nfr09_gf clrtap_nec_unfccc:pollutant_name ?pollutant_name .
   FILTER (?pollutant_name in ('NOx', 'NMVOC', 'SOx', 'NH3', 'PM2.5'))
   #FILTER (?pollutant_name = 'NOx')
   ?clrtap_nfr09_gf clrtap_nec_unfccc:year ?year .    FILTER(?year = '2012')
   #?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code .
   {
    ?clrtap_nfr09_gf 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_i, sector:1_A_2_f_ii, 
		sector:1_A_4_a_i, sector:1_A_4_a_ii, sector:1_A_4_b_i, sector:1_A_4_b_ii, sector:1_A_4_c_i, sector:1_A_4_c_ii, sector:1_A_4_c_iii,
sector:1_A_5_a,sector:1_A_5_b)) 
    ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?stationary_combustion .    
   } UNION {
    ?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code . 
    FILTER (regex(str(?sector_code),"/1_A_3_a") || regex(str(?sector_code),"/1_A_3_b") || 
            ?sector_code = sector:1_A_3_c || regex(str(?sector_code),"/1_A_3_d") || 
            ?sector_code =  sector:1_A_3_e || regex(str(?sector_code),"/1_A_3_a") )
    ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?mobile_combustion .
   } UNION {
    ?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code . 
    FILTER (regex(str(?sector_code),"/1_B_"))
    ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?fugitive_emissions .   
   } UNION {
    ?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code . 
    FILTER (regex(str(?sector_code),"/2_") || regex(str(?sector_code),"/3_"))
    ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?industrial_processes_and_solvent_use .   
   } UNION {
    ?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code . 
    FILTER (regex(str(?sector_code),"/4_"))
    ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?agriculture .   
   } UNION {
    ?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code . 
    FILTER (regex(str(?sector_code),"/6_"))
    ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?waste_handling .   
   } UNION {
    ?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code . 
    FILTER (regex(str(?sector_code),"/7_A"))
    ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?other .   
   } UNION {
    ?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code . 
    FILTER (?sector_code != sector:NATIONAL_TOTAL and ?sector_code != sector:11_A and ?sector_code != sector:11_B and ?sector_code != sector:11_C and ?sector_code != sector:7_B)
    ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?total_emissions .
  }
  }
 }}
GROUP BY ?pollutant_name


Permalinks

Document Actions