next
previous
items

Data table via SPARQL

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


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Document Actions