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 64 rows in 0.049 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
year(?date) as ?date_original
bif:either(year(?date) <2009, 2004, 2017) as ?date
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
round((sum(coalesce(?RCY_M, 0))+sum(coalesce(?RCY_C_D,0)))/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_C_D .
_:env_wasmun sdmx-measure:obsValue ?RCY_C_D .
}
{
SELECT
min(?date) as ?date
?geo
{
_:env_wasmun sdmx-dimension:timePeriod ?date .
FILTER (?date >= "2004-01-01"^^xsd:dateTime)
_: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_C_D .
_:env_wasmun sdmx-measure:obsValue ?RCY_C_D .
}
}
} UNION {
SELECT
max(?date) as ?date
?geo
{
_:env_wasmun sdmx-dimension:timePeriod ?date .
FILTER (?date >= "2004-01-01"^^xsd:dateTime)
_: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_C_D .
_:env_wasmun sdmx-measure:obsValue ?RCY_C_D .
}
}
}
}
?geo rdfs:label ?ugeo .
FILTER (?geo != geo:AL && ?geo != geo:CZ && ?geo != geo:ME &&
?geo != geo:IS && ?geo != geo:PL &&
?geo != geo:EU27 && ?geo != geo:MK)
}
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-6 or scan the QR code.
PDF generated on 23 Nov 2024, 07:50 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