next
previous
items

Data table via SPARQL

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.006 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


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Document Actions