Data table via SPARQL
Average annual percentage point increase needed for the 32 European countries to reach 50 % recycling by 2020 and past rates achieved
Download this dataset
Dataset preview
(Live Query)
Received 35 rows in 0.025 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/average-annual-percentage-point-increase/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://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX wst: <http://rdfdata.eionet.europa.eu/eurostat/dic/wst_oper#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
SELECT
?country
round(((50-(sum(?ratio_2012)/10))/8)*10)/10.0 as ?distance_target_2020
round((((sum(?ratio_2012)/10)-(sum(?ratio_2010)/10))/2)*10)/10.0 as ?yearly_increase_2010_2012
round((((sum(?ratio_2012)/10)-(sum(?ratio_2006)/10))/6)*10)/10.0 as ?yearly_increase_2006_2012
#sum(?ratio_2006)/10 as ?ratio_2006
#sum(?ratio_2010)/10 as ?ratio_2010
#sum(?ratio_2012)/10 as ?ratio_2012
{{
SELECT
bif:either(?ugeo = geo:DE, 'Germany', ?country) as ?country
bif:either(year(?date) = 2006, (sum(?RCY)/sum(?GEN))*1000, 0) as ?ratio_2006
bif:either(year(?date) = 2010, (sum(?RCY)/sum(?GEN))*1000, 0) as ?ratio_2010
bif:either(year(?date) = 2012, (sum(?RCY)/sum(?GEN))*1000, 0) as ?ratio_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 property:geo ?ugeo .
_:env_wasmun property:unit unit:1000T .
{
_:env_wasmun property:wst_oper wst:GEN .
_:env_wasmun sdmx-measure:obsValue ?GEN .
} UNION {
_:env_wasmun property:wst_oper ?wst_oper FILTER (?wst_oper in (wst:RCY_M, wst:RCY_OC)) .
_:env_wasmun sdmx-measure:obsValue ?RCY .
}
}
?ugeo rdfs:label ?country . FILTER (?ugeo != (geo:IS) and ?ugeo != (geo:HR))
}
GROUP BY ?date ?country ?ugeo
}}
ORDER BY ?country
Permalinks
- Permalink to this version
- 8c931399e8884af5b12eaf4182d7f075
- Permalink to latest version
- 02YEIM4HO6
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/average-annual-percentage-point-increase or scan the QR code.
PDF generated on 06 Feb 2023, 06:21 AM
Document Actions
Share with others