Average annual percentage point increase needed for the 32 European countries to reach 50 % recycling by 2020 and past rates achieved
Data table via SPARQL
Published 29 Jul 2014
Last modified 20 Apr 2016
Download this dataset
Dataset preview
(Live Query)
Received 35 rows in 0.076 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 21 Oct 2019, 12:54 PM
Document Actions
Share with others