Trend of recycling municipal waste by country

Data table via SPARQL Published 17 Feb 2015 Last modified 29 Jan 2016

Download this dataset

Dataset preview

(Live Query)

date ugeo material_recycling composting_and_digestion total_recycling waste_generated material_recycling_perc composting_and_digestion_perc total_recycling_perc
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "1125"^^<http://www.w3.org/2001/XMLSchema#decimal> "1855"^^<http://www.w3.org/2001/XMLSchema#decimal> "2980"^^<http://www.w3.org/2001/XMLSchema#decimal> "4634"^^<http://www.w3.org/2001/XMLSchema#decimal> "24.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "40"^^<http://www.w3.org/2001/XMLSchema#decimal> "64.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "1115"^^<http://www.w3.org/2001/XMLSchema#decimal> "1955"^^<http://www.w3.org/2001/XMLSchema#decimal> "3070"^^<http://www.w3.org/2001/XMLSchema#decimal> "4914"^^<http://www.w3.org/2001/XMLSchema#decimal> "22.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "39.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "62.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2003"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "1110"^^<http://www.w3.org/2001/XMLSchema#decimal> "2055"^^<http://www.w3.org/2001/XMLSchema#decimal> "3165"^^<http://www.w3.org/2001/XMLSchema#decimal> "4932"^^<http://www.w3.org/2001/XMLSchema#decimal> "22.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "41.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "64.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "1116"^^<http://www.w3.org/2001/XMLSchema#decimal> "1902"^^<http://www.w3.org/2001/XMLSchema#decimal> "3018"^^<http://www.w3.org/2001/XMLSchema#decimal> "5047"^^<http://www.w3.org/2001/XMLSchema#decimal> "22.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "59.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "1100"^^<http://www.w3.org/2001/XMLSchema#decimal> "1917"^^<http://www.w3.org/2001/XMLSchema#decimal> "3017"^^<http://www.w3.org/2001/XMLSchema#decimal> "5072"^^<http://www.w3.org/2001/XMLSchema#decimal> "21.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "59.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "1259"^^<http://www.w3.org/2001/XMLSchema#decimal> "2021"^^<http://www.w3.org/2001/XMLSchema#decimal> "3280"^^<http://www.w3.org/2001/XMLSchema#decimal> "5293"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "38.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "62"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "1318"^^<http://www.w3.org/2001/XMLSchema#decimal> "1661"^^<http://www.w3.org/2001/XMLSchema#decimal> "2979"^^<http://www.w3.org/2001/XMLSchema#decimal> "4951"^^<http://www.w3.org/2001/XMLSchema#decimal> "26.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "33.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "60.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "1476"^^<http://www.w3.org/2001/XMLSchema#decimal> "1683"^^<http://www.w3.org/2001/XMLSchema#decimal> "3159"^^<http://www.w3.org/2001/XMLSchema#decimal> "4997"^^<http://www.w3.org/2001/XMLSchema#decimal> "29.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "33.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "63.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "1492"^^<http://www.w3.org/2001/XMLSchema#decimal> "1553"^^<http://www.w3.org/2001/XMLSchema#decimal> "3045"^^<http://www.w3.org/2001/XMLSchema#decimal> "4921"^^<http://www.w3.org/2001/XMLSchema#decimal> "30.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "31.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "61.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "1272"^^<http://www.w3.org/2001/XMLSchema#decimal> "1521"^^<http://www.w3.org/2001/XMLSchema#decimal> "2793"^^<http://www.w3.org/2001/XMLSchema#decimal> "4701"^^<http://www.w3.org/2001/XMLSchema#decimal> "27.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "32.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "59.4"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 419 rows in 0.116 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/recycling-of-municipal-waste/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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/> 
PREFIX wst: <http://dd.eionet.europa.eu/vocabulary/eurostat/wst_oper/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>


SELECT
year(?date) as ?date
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
sum(?RCY_M) as ?material_recycling 
sum(?RCY_OC) as ?composting_and_digestion 
( sum(?RCY_OC)+sum(?RCY_M) ) as ?total_recycling 
sum(?GEN) as ?waste_generated

round(( sum(?RCY_M)/ sum(?GEN) )*1000)/10.0 as ?material_recycling_perc
round(( sum(?RCY_OC)/ sum(?GEN) )*1000)/10.0 as ?composting_and_digestion_perc
round(( ( sum(?RCY_OC)+sum(?RCY_M) ) / sum(?GEN) )*1000)/10.0 as ?total_recycling_perc


WHERE { 
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wasmun.rdf.gz> 
  { 
        _:env_wasmun sdmx-dimension:timePeriod ?date . FILTER (year(?date) > 2000)
	_:env_wasmun sdmx-dimension:refArea ?geo .
        _:env_wasmun sdmx-attribute:unitMeasure unit:THS_T .
        { 
	  _:env_wasmun property:wst_oper wst:GEN.
          _:env_wasmun sdmx-measure:obsValue ?GEN. 
	} UNION { 
	  _:env_wasmun property:wst_oper wst:RCY_M.
          _:env_wasmun sdmx-measure:obsValue ?RCY_M. 
        } UNION { 
	  _:env_wasmun property:wst_oper wst:RCY_OC . 
          _:env_wasmun sdmx-measure:obsValue ?RCY_OC . 
	} 
  } 
  ?geo rdfs:label ?ugeo . 

} 
GROUP BY ?date ?ugeo ?geo
ORDER BY ?ugeo ?date


Document Actions