Do something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data table via SPARQL
Received 6 rows in 0.022 seconds.
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.
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
?pollutant_name
round(( sum(?ntot_national_total_for_the_entire_territory) + sum(?memo_items) - sum(?road_transport_exhaust) - sum(?road_transport_non_exhaust) - sum(?railways) - sum(?domestic_shipping) - sum(?international_shipping) - sum(?domestic_aviation) - sum(?international_aviation) ) / ( sum(?ntot_national_total_for_the_entire_territory) + sum(?memo_items) )*100) as ?non_transport_sectors_share
round( sum(?road_transport_exhaust) / ( sum(?ntot_national_total_for_the_entire_territory) + sum(?memo_items) )*100) as ?road_transport_exhaust_share
round( sum(?road_transport_non_exhaust) / ( sum(?ntot_national_total_for_the_entire_territory) + sum(?memo_items) )*100) as ?road_transport_non_exhaust_share
round( sum(?railways) / ( sum(?ntot_national_total_for_the_entire_territory) + sum(?memo_items) )*100) as ?railways_share
round( sum(?domestic_shipping) / ( sum(?ntot_national_total_for_the_entire_territory) + sum(?memo_items) )*100) as ?domestic_shipping_share
round( sum(?international_shipping) / ( sum(?ntot_national_total_for_the_entire_territory) + sum(?memo_items) )*100) as ?international_shipping_share
round( sum(?domestic_aviation) / ( sum(?ntot_national_total_for_the_entire_territory) + sum(?memo_items) )*100) as ?domestic_aviation_share
round( sum(?international_aviation) / ( sum(?ntot_national_total_for_the_entire_territory) + sum(?memo_items) )*100) as ?international_aviation_share
( sum(?ntot_national_total_for_the_entire_territory) + sum(?memo_items) ) as ?total_incl_memo_items
sum(?ntot_national_total_for_the_entire_territory) as ?ntot_national_total_for_the_entire_territory
( sum(?ntot_national_total_for_the_entire_territory) + sum(?memo_items) - sum(?road_transport_exhaust) - sum(?road_transport_non_exhaust) - sum(?railways) - sum(?domestic_shipping) - sum(?international_shipping) - sum(?domestic_aviation) - sum(?international_aviation) ) as ?non_transport_sectors
sum(?road_transport_exhaust) as ?road_transport_exhaust
sum(?road_transport_non_exhaust) as ?road_transport_non_exhaust
sum(?railways) as ?railways
sum(?domestic_shipping) as ?domestic_shipping
sum(?international_shipping) as ?international_shipping
sum(?domestic_aviation) as ?domestic_aviation
sum(?international_aviation) as ?international_aviation
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 <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/NATIONAL_TOTAL> .
?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?ntot_national_total_for_the_entire_territory .
} UNION {
?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code .
FILTER (?sector_code in (sector:1_A_3_b_i, sector:1_A_3_b_ii, sector:1_A_3_b_iii, sector:1_A_3_b_iv))
?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?road_transport_exhaust .
} UNION {
?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code .
FILTER (?sector_code in (sector:1_A_3_b_v, sector:1_A_3_b_vi, sector:1_A_3_b_vii))
?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?road_transport_non_exhaust .
} UNION {
?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code sector:1_A_3_c .
?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?railways .
} UNION {
?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code .
FILTER (?sector_code in (sector:1_A_3_d_ii, sector:1_A_4_c_iii))
?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?domestic_shipping .
} UNION {
?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code .
FILTER (?sector_code in (<http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1_A_3_d_i_(i)>, <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1_A_3_d_i_(ii)>))
?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?international_shipping .
} UNION {
?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code .
FILTER (?sector_code in (<http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1_A_3_a_ii_(i)>, <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1_A_3_a_ii_(ii)>))
?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?domestic_aviation .
} UNION {
?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code .
FILTER (?sector_code in (<http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1_A_3_a_i_(i)>, <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1_A_3_a_i_(ii)>))
?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?international_aviation .
} UNION {
?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code .
FILTER (?sector_code in (<http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1_A_3_d_i_(i)>, <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1_A_3_a_ii_(ii)>, <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1_A_3_a_i_(ii)>))
?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?memo_items .
}
FILTER (?year = '2012')
FILTER (?pollutant_name in ('SOx', 'PM2.5', 'PM10', 'NOx', 'NMVOC', 'CO'))
#to be changed with EEA33
#FILTER (?country_code in (country:EU28, country:TR, country:IS, country:NO, country:LI, country:CH))
FILTER (?country_code in (country:EEA33))
}
}}
GROUP BY ?pollutant_name
ORDER BY ?pollutant_name
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/contribution-of-the-transport-sector or scan the QR code.
PDF generated on 30 Dec 2024, 06:31 PM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others