next
previous
items

Data table via SPARQL

Emissions of the main air pollutants by sector group

Data table via SPARQL Published 03 Jun 2019 Last modified 23 Jul 2019
Topics:

Download this dataset

Dataset preview

(Live Query)

sector_name_eea pollutant_name unit share emissions emissions_total
"Energy production and distribution" "CO" "Gg (1000 tonnes)" "3.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "765.4259335984029"^^<http://www.w3.org/2001/XMLSchema#double> "22565.61220808778"^^<http://www.w3.org/2001/XMLSchema#double>
"Non-road transport" "CO" "Gg (1000 tonnes)" "1.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "424.33060904894575"^^<http://www.w3.org/2001/XMLSchema#double> "22565.61220808778"^^<http://www.w3.org/2001/XMLSchema#double>
"Waste" "CO" "Gg (1000 tonnes)" "1.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "250.53875222543954"^^<http://www.w3.org/2001/XMLSchema#double> "22565.61220808778"^^<http://www.w3.org/2001/XMLSchema#double>
"Other" "CO" "Gg (1000 tonnes)" "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.3091506"^^<http://www.w3.org/2001/XMLSchema#double> "22565.61220808778"^^<http://www.w3.org/2001/XMLSchema#double>
"Energy use in industry" "CO" "Gg (1000 tonnes)" "12.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "2779.5713066056423"^^<http://www.w3.org/2001/XMLSchema#double> "22565.61220808778"^^<http://www.w3.org/2001/XMLSchema#double>
"Agriculture" "CO" "Gg (1000 tonnes)" "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "122.64891101826501"^^<http://www.w3.org/2001/XMLSchema#double> "22565.61220808778"^^<http://www.w3.org/2001/XMLSchema#double>
"Road transport" "CO" "Gg (1000 tonnes)" "18.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "4103.05571060844"^^<http://www.w3.org/2001/XMLSchema#double> "22565.61220808778"^^<http://www.w3.org/2001/XMLSchema#double>
"Industrial processes and product use" "CO" "Gg (1000 tonnes)" "11.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "2528.585222872608"^^<http://www.w3.org/2001/XMLSchema#double> "22565.61220808778"^^<http://www.w3.org/2001/XMLSchema#double>
"Commercial, institutional and households" "CO" "Gg (1000 tonnes)" "49.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "11180.459868417007"^^<http://www.w3.org/2001/XMLSchema#double> "22565.61220808778"^^<http://www.w3.org/2001/XMLSchema#double>
"Road transport" "NH3" "Gg (1000 tonnes)" "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "55.5206284674491"^^<http://www.w3.org/2001/XMLSchema#double> "4787.48726674671"^^<http://www.w3.org/2001/XMLSchema#double>

Received 63 rows in 0.003 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/emissions-of-the-main-air/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://semantic7.eea.europa.eu/sparql

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX clrtap_nec_unfccc: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/schema/>
PREFIX country: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>
PREFIX sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/clrtap_nec_nfr09_sector/>

SELECT DISTINCT
?sector_name_eea
?pollutant_name
?unit
round((round(sum(xsd:double(?emissions)))/?emissions_total)*1000)/10.0 as ?share
sum(xsd:double(?emissions)) as ?emissions
?emissions_total

WHERE {
  { 
    GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/clrtap_nfr09_gf.rdf.gz> 
    {
      ?clrtap clrtap_nec_unfccc:country_code ?country_code .
      ?clrtap clrtap_nec_unfccc:pollutant_name ?pollutant_name .
      ?clrtap clrtap_nec_unfccc:sector_code ?sector_code .
      ?clrtap clrtap_nec_unfccc:unit ?unit .
      ?clrtap clrtap_nec_unfccc:year ?year .
      ?clrtap clrtap_nec_unfccc:emissions ?emissions .

      {
        SELECT DISTINCT
          
          ?pollutant_name
          
          sum(xsd:double(?emissions_total)) as ?emissions_total
        {
          ?clrtap_total clrtap_nec_unfccc:country_code ?country_code .
          ?clrtap_total clrtap_nec_unfccc:pollutant_name ?pollutant_name .
          ?clrtap_total clrtap_nec_unfccc:sector_code ?sector_code .
          ?clrtap_total clrtap_nec_unfccc:year ?year .
          ?clrtap_total clrtap_nec_unfccc:emissions ?emissions_total .

          FILTER (?year = '2017')
          FILTER (?pollutant_name in ('CO', 'NH3', 'NMVOC', 'NOx', 'PM10', 'PM2.5', 'SOx'))
          FILTER (?country_code in (country:EU28, country:TR, country:NO, 
                                    country:LI, country:IS, country:CH))
          FILTER (?sector_code = sector:NATIONAL_TOTAL)

        }
      }

      FILTER (?year = '2017')
      FILTER (?pollutant_name in ('CO', 'NH3', 'NMVOC', 'NOx', 'PM10', 'PM2.5', 'SOx'))
          FILTER (?country_code in (country:EU28, country:TR, country:NO, 
                                    country:LI, country:IS, country:CH))  
      FILTER (?sector_code != sector:NATIONAL_TOTAL)


    }
    ?sector_code clrtap_nec_unfccc:sector_name_eea ?sector_name_eea .
  }
}
ORDER BY ?year ?pollutant_name


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Document Actions