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 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/indicators/gap_filling_data/ghg_projections_092013.tsv#>
PREFIX CP1_targets_EU28: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CP1_targets_for_EU28_052014.tsv#>
PREFIX CP1_targets_EU15: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CP1_targets_for_EU15_052014.tsv#>

SELECT
?year
round( sum(?NT_incl)/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_C1_A)/1000) as ?International_aviation
round( sum(?1_C1_B)/1000) as ?International_maritime_transport
round(( sum(?NT_incl) - sum(?1_C1_A) - sum(?1_C1_B) )/1000) as ?all_sectors_excl_LULUCF_excl_bunkers
round(( sum(?1_A_3) + sum(?1_C1_A) )/1000) as ?transport_incl_aviation
#?2030_tr_target
#?2050_tr_target
#?2050_m_target

{{
SELECT distinct
xsd:integer(?year) as ?year
bif:either(?sector_code = sector:NT_incl, ?unfccc_crf, 0) as ?NT_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.C1.A, ?unfccc_crf, 0) as ?1_C1_A
bif:either(?sector_code = sector:1.C1.B, ?unfccc_crf, 0) as ?1_C1_B
#transport 60 value for 1990
#'888' as ?2030_tr_target
#transport 20 value for 2008
#341 as ?2050_tr_target
#maritime 40 value for 2005
#'100' as ?2050_m_target

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:pollutant_name ?pollutant_name . 

      FILTER (?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 (geo:EU28))
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sector:NT_incl, sector:1.A.1.A, sector:1.A.3, sector:1.A.3.B, sector:1.C1.A, sector:1.C1.B))
      _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
    }
    ?sector_code rdf-schema:label ?sector_code_label .
  }
}

}}
GROUP BY xsd:integer(?year) ?2030_tr_target ?2050_tr_target ?2050_m_target
ORDER BY ?year