Share of transport GHG emissions

Data table via SPARQL Last modified 26 Sep 2018
Topics: ,

Download this dataset

Dataset preview

(Live Query)

ugeo sector total share obsValue
"EU28 (convention)" "Maritime" "1226411"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "167153"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EU28 (convention)" " Railways" "1226411"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "6421"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EU28 (convention)" " Other Transportation" "1226411"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5920"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EU28 (convention)" "Road transport" "1226411"^^<http://www.w3.org/2001/XMLSchema#decimal> "72"^^<http://www.w3.org/2001/XMLSchema#decimal> "883202"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EU28 (convention)" "Aviation" "1226411"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "163715"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 5 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/share-of-transport-ghg-emissions-2/daviz.json

For system integrators

The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.

Are you new to Linked Data technology? visit http://linkeddata.org



http://semantic.eea.europa.eu/sparql

PREFIX clrtap_nec_unfccc: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/schema/>
PREFIX sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/>
PREFIX country: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>

SELECT
?country_name as ?ugeo
bif:substring( ?sector_code, coalesce((bif:strchr( ?sector_code, '-')+2),1) , 100) as ?sector

?total

round((sum(?obsValue)/?total)*1000.0)/10.0 as ?share
sum(?obsValue) as ?obsValue
{{
  SELECT DISTINCT
  ?country_name
  bif:either(bound(?sector_code_dummy), ?sector_code_dummy, ?sector_code) as ?sector_code
  sum(?obsValue/11.0) as ?obsValue
  sum(?total) as ?total
  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 '2016' . 
        _:unfccc_crf clrtap_nec_unfccc:country_code ?geo .
        FILTER (?geo = country:EUA)
        {
          { SELECT 'Aviation' as ?sector_code_dummy {} } .
          _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector .
          FILTER (?sector in (sector:1.A.3.a, sector:1.D.1.a))
          _:unfccc_crf clrtap_nec_unfccc:emissions ?obsValue .
        } UNION {
          { SELECT 'Maritime' as ?sector_code_dummy {} } .
          _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector .
          FILTER (?sector in (sector:1.A.3.d, sector:1.D.1.b))
          _:unfccc_crf clrtap_nec_unfccc:emissions ?obsValue .
        } UNION {
          { SELECT 'Road transport' as ?sector_code_dummy {} } .
          _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector .
          FILTER (?sector in (sector:1.A.3.b.i, 
                   sector:1.A.3.b.ii, sector:1.A.3.b.iii,
                   sector:1.A.3.b.iv, sector:1.A.3.b.v))
          _:unfccc_crf clrtap_nec_unfccc:emissions ?obsValue .
        } UNION {
          _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector .
          FILTER (?sector in (sector:1.A.3.c, sector:1.A.3.e))
          _:unfccc_crf clrtap_nec_unfccc:emissions ?obsValue .
        }

        _:unfccc_crf_total clrtap_nec_unfccc:unit 'Gg CO2 equivalent' . 
        _:unfccc_crf_total clrtap_nec_unfccc:pollutant_name 'All greenhouse gases - (CO2 equivalent)' . 
        _:unfccc_crf_total clrtap_nec_unfccc:year '2016' . 
        _:unfccc_crf_total clrtap_nec_unfccc:country_code ?geo_total .
        FILTER (?geo_total = country:EUA)
        _:unfccc_crf_total clrtap_nec_unfccc:sector_code ?sector_total .
        FILTER (?sector_total in (sector:1.A.3.a, sector:1.D.1.a, sector:1.A.3.c,
                            sector:1.A.3.d, sector:1.D.1.b, sector:1.A.3.e,
                            sector:1.A.3.b.i, sector:1.A.3.b.ii, sector:1.A.3.b.iii,                 
                            sector:1.A.3.b.iv, sector:1.A.3.b.v))
        _:unfccc_crf_total clrtap_nec_unfccc:emissions ?total .

      }
      ?geo rdfs:label ?country_name .
      OPTIONAL { ?sector rdfs:label ?sector_code } .
    }
  }
  GROUP BY ?country_name ?sector_code ?sector_code_dummy
}}
ORDER BY ?country_name


Related content

Temporal coverage

Document Actions
Filed under: ,