Data table via SPARQL
Total municipal waste recycled in each European country in 2004 and 2012, stated in percentage
Data table via SPARQL
Published 16 Jul 2014
Last modified 26 Aug 2017
This is an old version, kept for reference only.
Go to latest version
Go to latest version
This page was archived on 26 Aug 2017 with reason:
A new version has been published
Download this dataset
Dataset preview
(Live Query)
Received 34 rows in 0.001 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/total-municipal-waste-recycled-in/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.
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 unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX wst: <http://dd.eionet.europa.eu/vocabulary/eurostat/wst_oper/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#>
SELECT
?country
sum(?2004) as ?2004
sum(?2012) as ?2012
{{
SELECT
?geo
bif:either(?ugeo = 'DE', 'Germany', ?country) as ?country
bif:either(year(?date) = 2004, round((sum(?RCY_M)+sum(?RCY_OC))/sum(?GEN)*100), 0) as ?2004
bif:either(year(?date) = 2012, round((sum(?RCY_M)+sum(?RCY_OC))/sum(?GEN)*100), 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) in (2004, 2012))
_: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 skos:prefLabel ?country .
?geo skos:notation ?ugeo . FILTER (?ugeo != 'RS' and ?ugeo != 'MK' and ?ugeo != 'HR' and ?ugeo != 'PL' and ?ugeo != 'IS')
}
GROUP BY ?country ?ugeo ?geo ?date
}}
GROUP BY ?country
ORDER BY ?country
Permalinks
- Permalink to this version
- b99ffc6159c648f8a02c24893a96c2a4
- Permalink to latest version
- SRG1XPVTQY
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/total-municipal-waste-recycled-in or scan the QR code.
PDF generated on 19 Jan 2021, 12:33 AM
Document Actions
Share with others