Changes in wastewater treatment in European Countries

Data table via SPARQL Published 02 Aug 2013 Last modified 16 Jul 2019

Download this dataset

Dataset preview

(Live Query)

country ugeo prefLabel date obsValue
"Austria"@en "AT" "Urban wastewater treatment, of which with primary treatment only"@en "1970"^^<http://www.w3.org/2001/XMLSchema#int> "12"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria"@en "AT" "Urban wastewater treatment, of which with secondary treatment"@en "1970"^^<http://www.w3.org/2001/XMLSchema#int> "5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria"@en "AT" "Urban wastewater treatment, of which with tertiary treatment"@en "1970"^^<http://www.w3.org/2001/XMLSchema#int> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria"@en "AT" "Urban wastewater treatment, of which with primary treatment only"@en "1980"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria"@en "AT" "Urban wastewater treatment, of which with secondary treatment"@en "1980"^^<http://www.w3.org/2001/XMLSchema#int> "25"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria"@en "AT" "Urban wastewater treatment, of which with tertiary treatment"@en "1980"^^<http://www.w3.org/2001/XMLSchema#int> "3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria"@en "AT" "Urban wastewater treatment, of which with primary treatment only"@en "1985"^^<http://www.w3.org/2001/XMLSchema#int> "7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria"@en "AT" "Urban wastewater treatment, of which with secondary treatment"@en "1985"^^<http://www.w3.org/2001/XMLSchema#int> "53"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria"@en "AT" "Urban wastewater treatment, of which with tertiary treatment"@en "1985"^^<http://www.w3.org/2001/XMLSchema#int> "5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria"@en "AT" "Urban wastewater collecting system without treatment"@en "1985"^^<http://www.w3.org/2001/XMLSchema#int> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 1547 rows in 0.210 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/changes-in-wastewater-treatment-in-1/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



semantic.eea.europa.eu/sparql

PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX s: <http://rdfdata.eionet.europa.eu/eurostat/dic/src#> 

SELECT DISTINCT
?country
?ugeo 
?prefLabel
year(?date) as ?date
?obsValue
WHERE {{

 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_watq4.rdf.gz> {  
    _:env_watq4 sdmx-dimension:freq ?freq . 
    _:env_watq4 sdmx-dimension:timePeriod ?date . 
    _:env_watq4 sdmx-dimension:refArea ?geo . 
    _:env_watq4 sdmx-attribute:unitMeasure u:PC . 
    _:env_watq4 property:src ?src FILTER (?src IN (s:WW0_5, s:WW0_2_3, s:WW0_2_1, s:WW0_2_2))
    _:env_watq4 sdmx-measure:obsValue ?obsValue .
     
} 
?src skos:prefLabel ?prefLabel .
?geo skos:notation ?ugeo .
?geo skos:prefLabel ?country .
}} order by ?ugeo ?date

Error when running query:

Query timeout. 


Document Actions