Data table via SPARQL

Croatia - Average annual percentage point increase needed to reach 50 % recycling by 2020 and past rates achieved

Data table via SPARQL Published 29 Jul 2014 Last modified 19 Apr 2016

Data visualisations

Menu

Learn more
Semantic Data Service (data tables via sparql)
- Croatia - Average annual percentage point increase needed to reach 50 % recycling by 2020 and past rates achieved

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

country	distance_target_2020	yearly_increase_2010_2012	yearly_increase_2006_2012
"Croatia"	"4.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5.4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"2.3"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 1 rows in 0.000 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/croatia-average-annual-percentage-point/daviz.json

For system integrators

Linked Data query (SPARQL)

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.

Are you new to Linked Data technology? visit http://linkeddata.org

SPARQL Endpoint:
semantic.eea.europa.eu/sparql

SPARQL Query:


        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
    #note period 2007-2012 -> 5 years
    round((((sum(?ratio_2012)/10)-(sum(?ratio_2006)/10))/5)*10)/10.0 as ?yearly_increase_2006_2012
      {{
      SELECT
      ?country

      #no data for HR for 2006 -> 2007

      bif:either(year(?date) = 2007, (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:HR))
    } 
    GROUP BY ?date ?country ?ugeo
   }}
ORDER BY ?country