GHG proxy

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(?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(?1_A_3) + sum(?1_D_1_a) )/1000) as ?transport_incl_aviation


{{
SELECT distinct
?year
bif:either(?sector_code = sectors:Totals_excl_incl, ?unfccc_crf, 0) as ?Totals_excl_incl
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 .
      FILTER (?geo in (unfccc_geo:EUA))
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sectors:Totals_excl_incl, 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 .
    } 
  } UNION {
    { SELECT '2017' AS ?year sector:1.A.3 as ?sector_code 946876 as ?unfccc_crf WHERE {} }
  } UNION {
    { SELECT '2017' AS ?year sector:1.D.1.a as ?sector_code 149836 as ?unfccc_crf WHERE {} }
  } UNION {
    { SELECT '2017' AS ?year sector:1.D.1.b as ?sector_code 119121 as ?unfccc_crf WHERE {} }
  } 

}
}}
GROUP BY ?year
#HAVING (?year in ('2016', '2017'))
HAVING (?year in ('2017'))
ORDER BY ?year