next
previous
items

Data table via SPARQL

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


Permalinks

Document Actions