Municipal waste recycling

Data table via SPARQL Published 15 Oct 2014 Last modified 29 Jan 2016

Download this dataset

Dataset preview

(Live Query)

ugeo 2007 2008 2012
"Austria" "60.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "63"^^<http://www.w3.org/2001/XMLSchema#decimal> "59.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Belgium" "56.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "56.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "57.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Bosnia and Herzegovina" "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Bulgaria" "20.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "19"^^<http://www.w3.org/2001/XMLSchema#decimal> "25"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Croatia" "3.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Cyprus" "5.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "21.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Czech Republic" "10.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Denmark" "37.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "42"^^<http://www.w3.org/2001/XMLSchema#decimal> "45"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Estonia" "23.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "20"^^<http://www.w3.org/2001/XMLSchema#decimal> "31.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"European Union (27 countries)" "35.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "36.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "41.5"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 39 rows in 0.051 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/municipal-waste-recycling/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 wst_oper: <http://dd.eionet.europa.eu/vocabulary/eurostat/wst_oper/>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>

SELECT 
?ugeo 
sum(?2007) as ?2007
sum(?2008) as ?2008 
sum(?2012) as ?2012
{{
  SELECT DISTINCT
  #year(?date) as ?date
  bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
  #sum(?generated_waste) as ?generated_waste
  #sum(?material_recycling) as ?material_recycling
  bif:either(year(?date) = 2007, round((sum(?material_recycling)/sum(?generated_waste))*1000)/10.0, 0) as ?2007
  bif:either(year(?date) = 2008, round((sum(?material_recycling)/sum(?generated_waste))*1000)/10.0, 0) as ?2008 
  bif:either(year(?date) = 2012, round((sum(?material_recycling)/sum(?generated_waste))*1000)/10.0, 0) as ?2012 

  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_oper . FILTER (?wst_oper in (wst_oper:GEN)) .
        _:env_wasmun sdmx-measure:obsValue ?generated_waste .
      } UNION {
        _:env_wasmun property:wst_oper ?wst_oper . FILTER (?wst_oper in (wst_oper:RCY_M, wst_oper:RCY_OC)) .
        _:env_wasmun sdmx-measure:obsValue ?material_recycling .
      }
    }}
    ?geo rdf-schema:label ?ugeo .
  }}
  GROUP BY ?ugeo ?geo ?date
}}
ORDER BY ?ugeo


Related content

Visualisations produced

Document Actions