Contribution of the transport sector to total emissions of the main air pollutants

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

( sum(?ntot_national_total_for_the_entire_territory_orig) + sum(?memo_items) ) as ?total_incl_memo_items
sum(?ntot_national_total_for_the_entire_territory_orig) as ?ntot_national_total_for_the_entire_territory
( sum(coalesce(?ntot_national_total_for_the_entire_territory_orig,0)) + sum(coalesce(?memo_items,0)) - sum(coalesce(?road_transport_exhaust_orig,0)) - sum(coalesce(?road_transport_non_exhaust_orig,0)) - sum(coalesce(?railways_orig,0)) - sum(coalesce(?domestic_shipping_orig,0)) - sum(coalesce(?international_shipping_orig,0)) - sum(coalesce(?domestic_aviation_orig,0)) - sum(coalesce(?international_aviation_orig,0)) ) as ?non_transport_sectors
sum(?road_transport_exhaust_orig) as ?road_transport_exhaust
sum(coalesce(?road_transport_non_exhaust_orig,0)) as ?road_transport_non_exhaust
sum(?railways_orig) as ?railways
sum(?domestic_shipping_orig) as ?domestic_shipping
sum(?international_shipping_orig) as ?international_shipping
sum(?domestic_aviation_orig) as ?domestic_aviation
sum(?international_aviation_orig) 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_orig .
   } UNION {
      ?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code .
      FILTER (?sector_code in (sector:1A3bi, sector:1A3bii, sector:1A3biii, sector:1A3biv))
      ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?road_transport_exhaust_orig . 
   } UNION {
      ?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code .
      FILTER (?sector_code in (sector:1A3bv, sector:1A3bvi, sector:1A3bvii))
      ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?road_transport_non_exhaust_orig . 
   } UNION {
      ?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code sector:1A3c .
      ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?railways_orig .
   } UNION {
      ?clrtap_nfr09_gf clrtap_nec_unfccc:sector_code ?sector_code .
      FILTER (?sector_code in (sector:1A3dii, sector:1A4ciii))
      ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?domestic_shipping_orig .
   } 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/1A3di(i)>, <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1A3di(ii)>))
      ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?international_shipping_orig . 
   } 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/1A3aii(i)>, <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1A3aii(ii)>))

      ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?domestic_aviation_orig .
   } 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/1A3ai(i)>, <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/1A3ai(ii)>))
      ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?international_aviation_orig .
   } 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/1A3di(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(ii)>))
      ?clrtap_nfr09_gf clrtap_nec_unfccc:emissions ?memo_items .
   }
   FILTER (?year = '2017')
   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