Change 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)

country_label pollutant_name unit change emissions emissions_idx
"Czech Republic" "Cd" "Mg" "-71.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.16738658605409"^^<http://www.w3.org/2001/XMLSchema#double> "4.05921229811034"^^<http://www.w3.org/2001/XMLSchema#double>
"Germany" "Cd" "Mg" "-57"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.087835064069"^^<http://www.w3.org/2001/XMLSchema#double> "30.4474063079323"^^<http://www.w3.org/2001/XMLSchema#double>
"Denmark" "Cd" "Mg" "-35.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.775168191590829"^^<http://www.w3.org/2001/XMLSchema#double> "1.20605867769779"^^<http://www.w3.org/2001/XMLSchema#double>
"Estonia" "Cd" "Mg" "-82.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.803646"^^<http://www.w3.org/2001/XMLSchema#double> "4.504147"^^<http://www.w3.org/2001/XMLSchema#double>
"Spain" "Cd" "Mg" "-83.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.22101603634576"^^<http://www.w3.org/2001/XMLSchema#double> "26.081083062122"^^<http://www.w3.org/2001/XMLSchema#double>
"EU28" "Cd" "Mg" "-64.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "68.166884232773"^^<http://www.w3.org/2001/XMLSchema#double> "191.219067536106"^^<http://www.w3.org/2001/XMLSchema#double>
"Finland" "Cd" "Mg" "-85.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.955890242483463"^^<http://www.w3.org/2001/XMLSchema#double> "6.66998615822178"^^<http://www.w3.org/2001/XMLSchema#double>
"France" "Cd" "Mg" "-84.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.16814492304906"^^<http://www.w3.org/2001/XMLSchema#double> "20.686926238896"^^<http://www.w3.org/2001/XMLSchema#double>
"United Kingdom" "Cd" "Mg" "-82.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.048882515062"^^<http://www.w3.org/2001/XMLSchema#double> "23.535639864555"^^<http://www.w3.org/2001/XMLSchema#double>
"Greece" "Cd" "Mg" "-17.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.45580512200144"^^<http://www.w3.org/2001/XMLSchema#double> "1.76813178347263"^^<http://www.w3.org/2001/XMLSchema#double>

Received 232 rows in 0.009 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/change-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://semantic.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_idx)) - sum(xsd:double(?emissions)))/((sum(xsd:double(?emissions_idx)) )))*-1000)/10.0 as ?change
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 '2017' .
      ?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 (?pollutant_name in ('Cd', 'Pb', 'Hg', 'HCB', 'PCB', 'dioxin', 'total PAH'))

    }
    ?country_code rdfs:label ?country_label .
  }
}
GROUP BY ?pollutant_name ?unit ?country_label ?year
HAVING sum(xsd:double(?emissions_idx)) > 0 
ORDER BY ?year ?pollutant_name


Related content

Temporal coverage

Document Actions