Transport emissions of GHGs

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 unfccc_geo: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>
PREFIX sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/>
PREFIX sectors: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/Sectors/>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>

SELECT
?year
round( sum(?Totals_incl_excl)/1000) as ?all_sectors_excl_LULUCF
round( sum(?1_A_1_a)/1000) as ?Public_Electricity_and_Heat_Production
round( sum(?1_A_3)/1000) as ?Transport
round( sum(?1_D_1_a)/1000) as ?International_aviation
round( sum(?1_D_1_b)/1000) as ?International_maritime_transport
round(( sum(?Totals_incl_excl) - sum(?1_D_1_a) - sum(?1_D_1_b) )/1000) as ?all_sectors_excl_LULUCF_excl_bunkers
round(( sum(?1_A_3) + sum(?1_D_1_a) )/1000) as ?transport_incl_aviation


{{
SELECT distinct
xsd:integer(?year) as ?year
bif:either(?sector_code = sectors:Totals_incl_excl, ?unfccc_crf, 0) as ?Totals_incl_excl
bif:either(?sector_code = sector:1.A.1.a, ?unfccc_crf, 0) as ?1_A_1_a
bif:either(?sector_code = sector:1.A.3, ?unfccc_crf, 0) as ?1_A_3
bif:either(?sector_code = sector:1.A.3.B, ?unfccc_crf, 0) as ?1_A_3_B
bif:either(?sector_code = sector:1.D.1.a, ?unfccc_crf, 0) as ?1_D_1_a
bif:either(?sector_code = sector:1.D.1.b, ?unfccc_crf, 0) as ?1_D_1_b

WHERE {
  { 
    GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
    {
      _:unfccc_crf clrtap_nec_unfccc:unit 'Gg CO2 equivalent' .
      _:unfccc_crf clrtap_nec_unfccc:pollutant_name 'All greenhouse gases - (CO2 equivalent)' .
      _:unfccc_crf clrtap_nec_unfccc:year ?year .
      _:unfccc_crf clrtap_nec_unfccc:country_code ?geo .
      #waiting for EU28 agregate
      FILTER (?geo in (unfccc_geo:AT, unfccc_geo:BE, unfccc_geo:BG, 
                       unfccc_geo:CY, unfccc_geo:CZ, unfccc_geo:DE, 
                       unfccc_geo:DK, unfccc_geo:EE, unfccc_geo:ES,
                       unfccc_geo:FI, unfccc_geo:FR, unfccc_geo:GB, 
                       unfccc_geo:GR, unfccc_geo:HU, unfccc_geo:IE, 
                       unfccc_geo:IT, unfccc_geo:LT, unfccc_geo:LU, 
                       unfccc_geo:LV, unfccc_geo:MT, unfccc_geo:NL, 
                       unfccc_geo:PL, unfccc_geo:PT, unfccc_geo:RO, 
                       unfccc_geo:SE, unfccc_geo:SI, unfccc_geo:SK, 
                       unfccc_geo:HR))
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sectors:Totals_incl_excl, sector:1.A.1.a, 
                               sector:1.A.3, sector:1.A.3.B, 
                               sector:1.D.1.a, sector:1.D.1.b))
      _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
    }
  }
}
}}
GROUP BY xsd:integer(?year)
HAVING xsd:integer(?year) >= 1990
ORDER BY ?year