All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data table via SPARQL
Received 66 rows in 0.002 seconds.
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.
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#>
PREFIX common_countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>
SELECT
bif:either(year(?date) <2009, 2004, 2015) as ?date
year(?date) as ?date_original
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
#round((sum(coalesce(?RCY_M,0))+sum(coalesce(?RCY_OC,0)))/sum(?GEN)*100) as ?value
round((sum(?RCY_M)+sum(?RCY_OC))/sum(?GEN)*100) as ?value
WHERE {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wasmun.rdf.gz> {
_:env_wasmun sdmx-dimension:timePeriod ?date .
_: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 .
}
{
SELECT
min(?date) as ?date
?geo
sum(?RCY_OC)
sum(?RCY_M)
{
_:env_wasmun sdmx-dimension:timePeriod ?date .
FILTER (year(?date) >= 2004)
_:env_wasmun sdmx-dimension:refArea ?geo .
{
_: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 .
}
}
HAVING sum(?RCY_OC)>0 && sum(?RCY_M) >0
} UNION {
SELECT
max(?date) as ?date
?geo
sum(?RCY_OC)
sum(?RCY_M)
{
_:env_wasmun sdmx-dimension:timePeriod ?date .
FILTER (year(?date) >= 2004)
_:env_wasmun sdmx-dimension:refArea ?geo .
{
_: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 .
}
}
#HAVING sum(?RCY_OC)>0 && sum(?RCY_M) >0
}
}
?geo rdfs:label ?ugeo .
FILTER (?geo != geo:AL && ?geo != geo:TR &&
?geo != geo:CZ && ?geo != geo:IS)
}
GROUP BY ?ugeo ?geo ?date
ORDER BY ?ugeo
For references, please go to https://eea.europa.eu./data-and-maps/daviz/sds/total-municipal-waste-recycled-in-2 or scan the QR code.
PDF generated on 23 Nov 2024, 11:42 AM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others