next
previous
items

Data table via SPARQL

Number of countries reporting at different levels of the MSW management hierarchy

Data table via SPARQL Published 15 Aug 2014 Last modified 19 Apr 2016

Download this dataset

Dataset preview

(Live Query)

date RCY_TOT_25 INC_RCV_25 DSP_D_50 DSP_D_75
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "11"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "15"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "15"^^<http://www.w3.org/2001/XMLSchema#decimal> "8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "12"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "13"^^<http://www.w3.org/2001/XMLSchema#decimal> "8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "16"^^<http://www.w3.org/2001/XMLSchema#decimal> "12"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "11"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "19"^^<http://www.w3.org/2001/XMLSchema#decimal> "14"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "11"^^<http://www.w3.org/2001/XMLSchema#decimal> "8"^^<http://www.w3.org/2001/XMLSchema#decimal> "16"^^<http://www.w3.org/2001/XMLSchema#decimal> "11"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "11"^^<http://www.w3.org/2001/XMLSchema#decimal> "8"^^<http://www.w3.org/2001/XMLSchema#decimal> "16"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2003"^^<http://www.w3.org/2001/XMLSchema#int> "12"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "18"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "14"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "19"^^<http://www.w3.org/2001/XMLSchema#decimal> "8"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 18 rows in 0.040 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/number-of-countries-reporting-at/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.

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



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 sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX unit: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX wst_oper: <http://rdfdata.eionet.europa.eu/eurostat/dic/wst_oper#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>

SELECT
?date
#ugeo
#?RCY_TOT
sum(?RCY_TOT_25) as ?RCY_TOT_25
#?INC_RCV
sum(?INC_RCV_25) as ?INC_RCV_25
#?DSP_D
sum(?DSP_D_50) as ?DSP_D_50
sum(?DSP_D_75) as ?DSP_D_75
{{
  SELECT
  ?date
  ?ugeo
  bif:either(?RCY_TOT >= 25, 1, 0) as ?RCY_TOT_25
  ?RCY_TOT
  bif:either(?INC_RCV >= 25, 1, 0) as ?INC_RCV_25
  ?INC_RCV
  bif:either(?DSP_D >= 50, 1, 0) as ?DSP_D_50
  bif:either(?DSP_D >= 75, 1, 0) as ?DSP_D_75
  ?DSP_D
  {{
    SELECT
    year(?date) as ?date
    bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
    round(sum(?RCY_M) / sum(?GEN)*100) as ?RCY_M
    round(sum(?RCY_OC) / sum(?GEN)*100) as ?RCY_OC
    round(sum(?INC_RCV) / sum(?GEN)*100) as ?INC_RCV
    round(sum(?DSP_D) / sum(?GEN)*100) as ?DSP_D
    round(( ( sum(?RCY_OC) / sum(?GEN) ) + ( sum(?RCY_M) / sum(?GEN) ) ) *100)  as ?RCY_TOT

    WHERE { 
     { 
      GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wasmun.rdf.gz> 
     {    
      _:env_wasmun sdmx-dimension:timePeriod ?date . 
      #FILTER (year(?date) in (2012)) 
      #FILTER (year(?date) in (2001, 2010, 2012)) 
      _:env_wasmun sdmx-attribute:unitMeasure unit:1000T . 
      _:env_wasmun sdmx-dimension:refArea ?geo . 
      {
        _:env_wasmun property:wst_oper wst_oper:GEN .
        _:env_wasmun sdmx-measure:obsValue ?GEN  .
      } UNION {
        _:env_wasmun property:wst_oper wst_oper:DSP_D .
        _:env_wasmun sdmx-measure:obsValue ?DSP_D .
      } UNION {
        _:env_wasmun property:wst_oper wst_oper:INC_RCV .
        _:env_wasmun sdmx-measure:obsValue ?INC_RCV .
      } UNION {
        _:env_wasmun property:wst_oper wst_oper:RCY_M .
        _:env_wasmun sdmx-measure:obsValue ?RCY_M .
      } UNION {
        _:env_wasmun property:wst_oper wst_oper:RCY_OC .
        _:env_wasmun sdmx-measure:obsValue ?RCY_OC .
      }
     }
     FILTER (?geo != geo:EU28 and ?geo != geo:EU27 and ?geo != geo:MK and ?geo != geo:RS and ?geo != geo:BA  and ?geo != geo:HR)
     ?geo rdf-schema:label ?ugeo .
   }} 
 }} 
}}
ORDER BY ?date


Permalinks

Document Actions