next
previous
items

Data table via SPARQL

Share of transport GHG emissions for road transport

Data table via SPARQL Published 29 Aug 2019 Last modified 24 Jun 2020
Topics:

Download this dataset

Dataset preview

(Live Query)

ugeo sector obsValue total share
"EU28 (convention)" " Other Road Transportation" "453.1003000000000003636"^^<http://www.w3.org/2001/XMLSchema#decimal> "1225600.0328199998"^^<http://www.w3.org/2001/XMLSchema#double> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EU28 (convention)" " Motorcycles" "10737.8165599999999998181"^^<http://www.w3.org/2001/XMLSchema#decimal> "1225600.0328199998"^^<http://www.w3.org/2001/XMLSchema#double> "0.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EU28 (convention)" " Heavy duty trucks and buses" "235158.0227600000000000909"^^<http://www.w3.org/2001/XMLSchema#decimal> "1225600.0328199998"^^<http://www.w3.org/2001/XMLSchema#double> "19.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EU28 (convention)" " Light duty trucks" "106254.3594900000000003636"^^<http://www.w3.org/2001/XMLSchema#decimal> "1225600.0328199998"^^<http://www.w3.org/2001/XMLSchema#double> "8.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EU28 (convention)" " Cars" "543183.8551200000000004545"^^<http://www.w3.org/2001/XMLSchema#decimal> "1225600.0328199998"^^<http://www.w3.org/2001/XMLSchema#double> "44.3"^^<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-5/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
?obsValue
?total
round((?obsValue/?total)*1000.0)/10 as ?share
{{
  SELECT DISTINCT
  ?country_name
  ?sector
  ?sector_code
  sum(xsd:double(?obsValue)/11.0) as ?obsValue
  sum(xsd:double(?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 '2017' . 
        _:unfccc_crf clrtap_nec_unfccc:country_code ?geo .
        FILTER (?geo = country:EUA)
        _: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 .

        _: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 } .
    }
  ?sector rdfs:label ?sector_code .
  }

}}


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Filed under:
Filed under: ghg emissions, transport
Document Actions