Trend in emissions of air pollutants from transport

Data table via SPARQL Last modified 19 Aug 2019
31 min read
Topics: ,

Download this dataset

Dataset preview

(Live Query)

year pollutant_name index emissions emissions_idx
"1990" "NMVOC" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "5881.143611700417"^^<http://www.w3.org/2001/XMLSchema#double> "5881.143611700417"^^<http://www.w3.org/2001/XMLSchema#double>
"1990" "NOx" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "10082.199340139052"^^<http://www.w3.org/2001/XMLSchema#double> "10082.199340139052"^^<http://www.w3.org/2001/XMLSchema#double>
"1990" "SOx" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "1812.7236049284804"^^<http://www.w3.org/2001/XMLSchema#double> "1812.7236049284804"^^<http://www.w3.org/2001/XMLSchema#double>
"1991" "NMVOC" "94.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "5554.032612543321"^^<http://www.w3.org/2001/XMLSchema#double> "5881.143611700417"^^<http://www.w3.org/2001/XMLSchema#double>
"1991" "NOx" "98.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "9961.473574300799"^^<http://www.w3.org/2001/XMLSchema#double> "10082.199340139052"^^<http://www.w3.org/2001/XMLSchema#double>
"1991" "SOx" "95.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1733.546793739497"^^<http://www.w3.org/2001/XMLSchema#double> "1812.7236049284804"^^<http://www.w3.org/2001/XMLSchema#double>
"1992" "NMVOC" "93"^^<http://www.w3.org/2001/XMLSchema#decimal> "5468.580488513581"^^<http://www.w3.org/2001/XMLSchema#double> "5881.143611700417"^^<http://www.w3.org/2001/XMLSchema#double>
"1992" "NOx" "100.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "10100.667782720247"^^<http://www.w3.org/2001/XMLSchema#double> "10082.199340139052"^^<http://www.w3.org/2001/XMLSchema#double>
"1992" "SOx" "95.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "1725.8890574401278"^^<http://www.w3.org/2001/XMLSchema#double> "1812.7236049284804"^^<http://www.w3.org/2001/XMLSchema#double>
"1993" "NMVOC" "88"^^<http://www.w3.org/2001/XMLSchema#decimal> "5176.558242602914"^^<http://www.w3.org/2001/XMLSchema#double> "5881.143611700417"^^<http://www.w3.org/2001/XMLSchema#double>

Received 84 rows in 0.062 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/trend-in-emissions-of-air-12/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://semantic7.eea.europa.eu/sparql

PREFIX clrtap_nec_unfccc: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/schema/>
PREFIX country: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>
PREFIX sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/>

SELECT
?year 
?pollutant_name
#xsd:double((round((sum(?emissions))/sum(?emissions_idx)*1000))/10.0) as ?index

round(sum(xsd:double(?emissions))/sum(xsd:double(?emissions_idx))*1000)/10.0 as ?index
sum(xsd:double(?emissions)) as ?emissions
sum(xsd:double(?emissions_idx)) as ?emissions_idx

WHERE {{  
  GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/clrtap_nfr09_gf.rdf.gz> 
  {
   ?clrtap_nfr09_gf clrtap_nec_unfccc:country_code ?country_code .
   ?clrtap_nfr09_gf clrtap_nec_unfccc:pollutant_name ?pollutant_name .
   ?clrtap_nfr09_gf clrtap_nec_unfccc:year ?year .
   ?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code .
   OPTIONAL { ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?emissions } .
 
   ?clrtap_nfr09_gf_idx clrtap_nec_unfccc:country_code ?country_code .
   ?clrtap_nfr09_gf_idx clrtap_nec_unfccc:pollutant_name ?pollutant_name .
   ?clrtap_nfr09_gf_idx clrtap_nec_unfccc:year '1990' .
   ?clrtap_nfr09_gf_idx clrtap_nec_unfccc:sector_code ?sector_code .
   OPTIONAL { ?clrtap_nfr09_gf_idx clrtap_nec_unfccc:emissions ?emissions_idx } .

   FILTER (?sector_code in (
     sector:1A3bi,
     sector:1A3bii,
     sector:1A3biii,
     sector:1A3biv,
     sector:1A3bv,
     sector:1A3bvi,
     sector:1A3bvii,
     sector:1A3c,
     sector:1A3dii,
     sector:1A4ciii,
     <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1A3di(i)>,
     <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1A3di(ii)>,
     <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1A3aii(i)>,
     <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1A3aii(ii)>,
     <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1A3ai(i)>,
     <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1A3ai(ii)>
   ))
   
   FILTER (?pollutant_name in ('NOx', 'NMVOC', 'SOx'))
   #FILTER (?pollutant_name in ('SOx'))
   #to be changed with EEA33
   FILTER (?country_code in (country:EU28, country:TR, country:NO, country:IS, country:LI, country:CH))
  }
}}
GROUP BY ?year ?pollutant_name
ORDER BY ?year ?pollutant_name


Related content

Temporal coverage

Document Actions
Filed under: