Historic and projected trends of GHG emissions-distance to target

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 sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ghg_projections: <http://semantic.eea.europa.eu/project/ghg_projections/ghg_projections.tsv#>

SELECT
xsd:integer(?year) as ?year

round(sum(?unfccc_crf_eea33)/1000) AS ?GHG_eea33
round(sum(?unfccc_crf_eu28)/1000) AS ?GHG_eu28
round(sum(?unfccc_crf_eu15)/1000) AS ?GHG_eu15

round(( sum(coalesce(?unfccc_crf_eea33, 0.0)) -  sum(coalesce(?unfccc_crf_eu28, 0.0))      )/1000) as ?GHG_eea33_eu28
round(( sum(coalesce(?unfccc_crf_eu28, 0.0)) -  sum(coalesce(?unfccc_crf_eu15, 0.0))      )/1000) as ?GHG_eu28_eu15

#value for 2013 coming from PROXI
#bif:either(xsd:integer(?year) = 2013, 4464, '') as ?proxy
bif:either(xsd:integer(?year) = 2013, 4464, bif:either(xsd:integer(?year) = 2012, round(sum(?unfccc_crf_eu28)/1000), '')) as ?proxy

#bif:either(xsd:integer(?year) = 2013, '', round(sum(?ghg_projections)/1000)) as ?ghg_projections

bif:either(xsd:integer(?year) >= 2010, round(sum(?wem_ghg_projections)/1000), '') as ?wem_ghg_projections
bif:either(xsd:integer(?year) >= 2010,  round(sum(?wam_ghg_projections)/1000), '') as ?wam_ghg_projections

bif:either(xsd:integer(?year) in (2008, 2009, 2010, 2011, 2012), 3926, '') as ?CP1_targets_eu15
bif:either(xsd:integer(?year) in (2008, 2009, 2010, 2011, 2012), 5339.48, '') as ?CP1_targets_eu28
bif:either(xsd:integer(?year) in (2008, 2009, 2010, 2011, 2012), 5339.48 - 3926, '') as ?CP1_targets_difference

WHERE {
  { 
    GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
    {
      _:unfccc_crf clrtap_nec_unfccc:unit ?unit . FILTER (?unit = 'Gg CO2 equivalent')
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sector:1, sector:2, sector:3, sector:4, sector:6, sector:7))
      _:unfccc_crf clrtap_nec_unfccc:pollutant_name ?pollutant_name . 
      FILTER (?pollutant_name = 'All greenhouse gases - (CO2 equivalent)')
      _:unfccc_crf clrtap_nec_unfccc:year ?year . FILTER (?year != ('KPBY'))

      {
        _:unfccc_crf clrtap_nec_unfccc:country_code ?geo . FILTER (?geo in (geo:EU28))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf_eu28 .
      } UNION {
        _:unfccc_crf clrtap_nec_unfccc:country_code ?geo . FILTER (?geo in (geo:EU15))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf_eu15 .
      } UNION {
        _:unfccc_crf clrtap_nec_unfccc:country_code ?geo . FILTER (?geo in (geo:EEA33))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf_eea33 .
      }
    }
  } UNION {

    GRAPH <http://semantic.eea.europa.eu/project/ghg_projections/ghg_projections.tsv> 
    {
       _:ghg_projections ghg_projections:country_code ?geo . FILTER (?geo != geo:NO and ?geo != geo:CH and ?geo != geo:LI)
       _:ghg_projections ghg_projections:sector ?sector .
       FILTER (?sector in ('Energy total (1)', 'Industrial processes (2)', 'Other (3 + 7)', 'Agriculture (4)', 'Waste (6)'))
       _:ghg_projections ghg_projections:m_r ?m_r .
       _:ghg_projections ghg_projections:year ?year . FILTER (xsd:integer(?year) >= 2010 and xsd:integer(?year) <= 2020)
       _:ghg_projections ghg_projections:pollutant_name ?pollutant_name  . 
       FILTER (?pollutant_name = 'Total GHG (Gg CO2 equivalent)')
       
       {
         _:ghg_projections ghg_projections:scenario ?scenario . FILTER (?scenario = 'WEM')
         _:ghg_projections ghg_projections:emissions ?wem_ghg_projections .
       } UNION {
         _:ghg_projections ghg_projections:scenario ?scenario . FILTER (?scenario = 'WAM')
         _:ghg_projections ghg_projections:emissions ?wam_ghg_projections .
       }
    } 
  }
}
GROUP BY xsd:integer(?year)
ORDER BY xsd:integer(?year)