Municipal solid waste generation

Data table via SPARQL Published 18 Mar 2013 Last modified 25 Jun 2019
The query replicates the charts 2.0 "MSW generation for the period 2001-2010" published here: http://www.eea.europa.eu/publications/managing-municipal-solid-waste/ Extended up to 2011

Download this dataset

Dataset preview

(Live Query)

date region solid_waste_generation unit_label
"2002-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "608"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2010-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "558"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2006-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "640"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2008-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "599"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2003-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "607"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2005-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "616"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2007-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "596"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2001-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "576"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2009-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "588"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2011-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Austria"@en "552"^^<http://www.w3.org/2001/XMLSchema#decimal> ""

Received 379 rows in 0.010 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/municipal-solid-waste-generation/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#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>


SELECT 
   ?date 
?country as ?region
sum(?obsValue) as ?solid_waste_generation
?unit_label
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 ?unit FILTER (?unit = u:KG_HAB)
        OPTIONAL { ?unit rdfs:label ?unit_label . }
        _:x property:wst_oper wst:GEN .
        _:x sdmx-measure:obsValue ?obsValue .
  } 
  ?ugeo skos:prefLabel ?country .
} GROUP BY ?country ?date ?unit_label ORDER BY ?country

Error when running query:

Query timeout. 


Document Actions
Filed under: