Trends in emissions of heavy metals and persistant organic pollutants

Data table via SPARQL Published 27 May 2019 Last modified 22 Jul 2019
Topics: ,

Download this dataset

Dataset preview

(Live Query)

year pollutant_name unit index emissions emissions_idx
"1990" "Cd" "Mg" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "196.52159783017353"^^<http://www.w3.org/2001/XMLSchema#double> "196.52159783017353"^^<http://www.w3.org/2001/XMLSchema#double>
"1990" "HCB" "kg" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "8412.496054333016"^^<http://www.w3.org/2001/XMLSchema#double> "8412.496054333016"^^<http://www.w3.org/2001/XMLSchema#double>
"1990" "Hg" "Mg" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "210.10193215204916"^^<http://www.w3.org/2001/XMLSchema#double> "210.10193215204916"^^<http://www.w3.org/2001/XMLSchema#double>
"1990" "PCB" "kg" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "14270.311686811121"^^<http://www.w3.org/2001/XMLSchema#double> "14270.311686811121"^^<http://www.w3.org/2001/XMLSchema#double>
"1990" "Pb" "Mg" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "23365.2057470448"^^<http://www.w3.org/2001/XMLSchema#double> "23365.2057470448"^^<http://www.w3.org/2001/XMLSchema#double>
"1990" "dioxin" "g" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "9617.99167338744"^^<http://www.w3.org/2001/XMLSchema#double> "9617.99167338744"^^<http://www.w3.org/2001/XMLSchema#double>
"1990" "total PAH" "Mg" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "6538.669730773798"^^<http://www.w3.org/2001/XMLSchema#double> "6538.669730773798"^^<http://www.w3.org/2001/XMLSchema#double>
"1991" "Cd" "Mg" "93.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "184.13163383472212"^^<http://www.w3.org/2001/XMLSchema#double> "196.52159783017353"^^<http://www.w3.org/2001/XMLSchema#double>
"1991" "HCB" "kg" "97.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "8170.464722786509"^^<http://www.w3.org/2001/XMLSchema#double> "8412.496054333016"^^<http://www.w3.org/2001/XMLSchema#double>
"1991" "Hg" "Mg" "93.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "196.95389027450926"^^<http://www.w3.org/2001/XMLSchema#double> "210.10193215204916"^^<http://www.w3.org/2001/XMLSchema#double>

Received 196 rows in 0.077 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/trends-in-emissions-of-heavy-persistant-organic-pollutants/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
#?clrtap
#?country_label
?year
?pollutant_name
?unit
round(sum(xsd:double(?emissions))/sum(xsd:double(?emissions_idx))*1000)/10.0 as ?index
sum(xsd:double(?emissions)) as ?emissions
sum(xsd:double(?emissions_idx)) as ?emissions_idx

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 .

      _:clrtap_idx clrtap_nec_unfccc:country_code ?country_code .
      _:clrtap_idx clrtap_nec_unfccc:pollutant_name ?pollutant_name .
      _:clrtap_idx clrtap_nec_unfccc:sector_code ?sector_code .
      _:clrtap_idx clrtap_nec_unfccc:unit ?unit .
      _:clrtap_idx clrtap_nec_unfccc:year '1990' .
      _:clrtap_idx clrtap_nec_unfccc:emissions ?emissions_idx .

      FILTER (?sector_code = sector:NATIONAL_TOTAL)
      FILTER (?country_code in (country:EU28, country:TR, country:NO, 
                                country:LI, country:IS, country:CH))

      FILTER (?pollutant_name in ('Cd', 'Pb', 'Hg', 'HCB', 'PCB', 'dioxin', 'total PAH'))

    }
    ?country_code rdfs:label ?country_label .
  }
}
ORDER BY ?year ?pollutant_name


Temporal coverage

Document Actions