Sector split of emissions of selected heavy metals and persistent organic pollutants

Data table via SPARQL Published 28 May 2019 Last modified 23 Jul 2019
Topics: ,

Download this dataset

Dataset preview

(Live Query)

sector_name_eea pollutant_name unit share emissions emissions_total
"Non-road transport" "Cd" "Mg" "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.20540426386920685"^^<http://www.w3.org/2001/XMLSchema#double> "69.80904390955595"^^<http://www.w3.org/2001/XMLSchema#double>
"Other" "Cd" "Mg" "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1536"^^<http://www.w3.org/2001/XMLSchema#double> "69.80904390955595"^^<http://www.w3.org/2001/XMLSchema#double>
"Industrial processes and product use" "Cd" "Mg" "33.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.196998809285727"^^<http://www.w3.org/2001/XMLSchema#double> "69.80904390955595"^^<http://www.w3.org/2001/XMLSchema#double>
"Waste" "Cd" "Mg" "2.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.6534237057339296"^^<http://www.w3.org/2001/XMLSchema#double> "69.80904390955595"^^<http://www.w3.org/2001/XMLSchema#double>
"Road transport" "Cd" "Mg" "3.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.3680679675755654"^^<http://www.w3.org/2001/XMLSchema#double> "69.80904390955595"^^<http://www.w3.org/2001/XMLSchema#double>
"Energy use in industry" "Cd" "Mg" "24.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "16.899279237991603"^^<http://www.w3.org/2001/XMLSchema#double> "69.80904390955595"^^<http://www.w3.org/2001/XMLSchema#double>
"Commercial, institutional and households" "Cd" "Mg" "21.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.890957081122128"^^<http://www.w3.org/2001/XMLSchema#double> "69.80904390955595"^^<http://www.w3.org/2001/XMLSchema#double>
"Energy production and distribution" "Cd" "Mg" "13.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.271470356874396"^^<http://www.w3.org/2001/XMLSchema#double> "69.80904390955595"^^<http://www.w3.org/2001/XMLSchema#double>
"Agriculture" "Cd" "Mg" "1.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.16984248688892"^^<http://www.w3.org/2001/XMLSchema#double> "69.80904390955595"^^<http://www.w3.org/2001/XMLSchema#double>
"Industrial processes and product use" "HCB" "kg" "44.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "129.87289556161556"^^<http://www.w3.org/2001/XMLSchema#double> "289.6143793956362"^^<http://www.w3.org/2001/XMLSchema#double>

Received 61 rows in 0.003 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/sector-split-of-emissions-of/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((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 ('Cd', 'Pb', 'Hg', 'HCB', 'PCB', 'dioxin', 'total PAH'))
          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 ('Cd', 'Pb', 'Hg', 'HCB', 'PCB', 'dioxin', 'total PAH'))
          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


Temporal coverage

Document Actions