Recycling of MSW - 2001- current year

Data table via SPARQL Published 22 Apr 2013 Last modified 14 May 2019
Managing municipal solid waste - a review of achievements in 32 European countries Fig 1. Line chart, dropdown box for country selection

Download this dataset

Dataset preview

(Live Query)

date country recycling_excluding_compost Recycling_of_MSW organic_recycling_compost_and_other_biological_treatment
"2001-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "24.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "57.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "33"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2002-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "22.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "55.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "32.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2003-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "22.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "57.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "34.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "22.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "52.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "30.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "21.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "52.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "30.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "23.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "55"^^<http://www.w3.org/2001/XMLSchema#decimal> "31.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "26.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "53.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "26.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "29.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "56.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "26.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "30.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "54.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "24.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "27"^^<http://www.w3.org/2001/XMLSchema#decimal> "52.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "25.5"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 379 rows in 0.014 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/recycling-of-msw-2001-current-year/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 sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#> 
PREFIX g: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#> 
PREFIX wst: <http://rdfdata.eionet.europa.eu/eurostat/dic/wst_oper#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>

SELECT
    ?date
    ?country 
    #(round((  (sum(?RCY_M)+sum(?RCY_OC))/sum(?GEN) )*1000))/10.0 as ?Recycling_of_MSW
    #(round((  (sum(?RCY_OC))/sum(?GEN) )*1000))/10.0 as ?organic_recycling_compost_and_other_biological_treatment
    (round((  (sum(?RCY_M))/sum(?GEN) )*1000))/10.0 as ?recycling_excluding_compost
    
    #Compensation +7% for Austria
    bif:either(?geo= 'AT', ((round((  (sum(?RCY_M)+sum(?RCY_OC))/sum(?GEN) )*1000))/10.0)-7,(round((  (sum(?RCY_M)+sum(?RCY_OC))/sum(?GEN) )*1000))/10.0) as ?Recycling_of_MSW
    bif:either(?geo= 'AT', ((round((  (sum(?RCY_OC))/sum(?GEN) )*1000))/10.0)-7,(round((  (sum(?RCY_OC))/sum(?GEN) )*1000))/10.0) AS ?organic_recycling_compost_and_other_biological_treatment

WHERE { 
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wasmun.rdf.gz> { 
        _:x sdmx-dimension:timePeriod ?date . FILTER (?date > "2000-01-01"^^xsd:date)
	_:x property:geo ?ugeo .
        _:x property:unit u:1000T .
       
        { 
	_:x property:wst_oper wst:GEN .
        _:x sdmx-measure:obsValue ?GEN . 
	} UNION { 
	_:x property:wst_oper wst:RCY_M . 
        _:x sdmx-measure:obsValue ?RCY_M . 
	} UNION { 
	_:x property:wst_oper wst:RCY_OC .
        _:x sdmx-measure:obsValue ?RCY_OC .
	} 
  } 
  ?ugeo skos:prefLabel ?country .
  ?ugeo skos:notation ?geo .
} GROUP BY ?date ?country ?geo ORDER BY ?country ?date

Error when running query:

Query timeout. unknown url type: timed out


Document Actions