Data table via SPARQL
Trend in emissions of air pollutants from transport, PM2.5
Data table via SPARQL
Published 19 Aug 2019
Last modified 24 Jun 2020
41
min read
Topics:
Air pollution
Download this dataset
Dataset preview
(Live Query)
Received 18 rows in 0.002 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/trend-in-emissions-of-air-11/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.
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
#sum(?emissions) as ?emissions
#sum(?emissions_idx) as ?emissions_idx
xsd:double((round((sum(?emissions))/sum(?emissions_idx)*1000))/10.0) as ?index
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 .
?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?emissions .
FILTER(xsd:integer(?year) >= 2000)
?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 ?year_idx .
?clrtap_nfr09_gf_idx clrtap_nec_unfccc:sector_code ?sector_code .
?clrtap_nfr09_gf_idx clrtap_nec_unfccc:emissions ?emissions_idx .
FILTER(?year_idx = '2000')
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 ('SOx'))
FILTER (?pollutant_name in ('PM2.5'))
#to be changed with EEA33
FILTER (?country_code in (country:EU28, country:TR, country:NO, country:IS, country:LI, country:CH))
#FILTER (?country_code in (country:EEA33))
}
}}
GROUP BY ?year ?pollutant_name
ORDER BY ?year ?pollutant_name
Permalinks
- Permalink to this version
- 07a4b93d76d847c5a618e3ee96d50be3
- Permalink to latest version
- 0EB6SAQDPF
Older versions
Geographic coverage
Temporal coverage
2000-2016
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/trend-in-emissions-of-air-11 or scan the QR code.
PDF generated on 04 Dec 2020, 07:16 AM
Topics
Topics:
Air pollution
Tags
Filed under:
air pollutants
Document Actions
Share with others