Share of treatment methods of municipal waste

Data table via SPARQL Last modified 19 Nov 2018
32 min read

Download this dataset

Dataset preview

(Live Query)

date label share
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "Other" "5.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "Total incineration (including energy recovery)" "17.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "Landfill" "46.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "Recycling (incl. composting/digestion)" "30.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Other" "6.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Total incineration (including energy recovery)" "18.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Recycling (incl. composting/digestion)" "31.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Landfill" "42.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int> "Landfill" "42.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int> "Recycling (incl. composting/digestion)" "32.9"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 52 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/share-of-treatment-methods-of-2/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



http://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 wst_oper: <http://dd.eionet.europa.eu/vocabulary/eurostat/wst_oper/>
PREFIX stk_flow: <http://dd.eionet.europa.eu/vocabulary/eurostat/stk_flow/>
PREFIX waste: <http://dd.eionet.europa.eu/vocabulary/eurostat/waste/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>

SELECT DISTINCT
year(?date) as ?date

bif:either(?label = 'Recycling', 'Recycling (incl. composting/digestion)', ?label) as ?label
bif:either(?label = 'Other', round(((?GEN-sum(?obsValue))/?GEN)*1000)/10.0, round((sum(?obsValue)/?GEN)*1000)/10.0) as ?share

#sum(?obsValue) as ?obsValue
#sum(?obsValue_other)
#?GEN

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 . 
    {
       {SELECT 'Landfill' as ?label {}}
       _:env_wasmun property:wst_oper wst_oper:DSP_L_OTH .
       _:env_wasmun sdmx-measure:obsValue ?obsValue  .
    } UNION {
       {SELECT 'Total incineration (including energy recovery)' as ?label {}}
       _:env_wasmun property:wst_oper wst_oper:DSP_I_RCV_E .
       _:env_wasmun sdmx-measure:obsValue ?obsValue  .
    } UNION {
       {SELECT 'Recycling' as ?label {}}
       _:env_wasmun property:wst_oper wst_oper:RCY_M .
       _:env_wasmun sdmx-measure:obsValue ?obsValue  .
    } UNION {
       {SELECT 'Recycling' as ?label {}}
       _:env_wasmun property:wst_oper wst_oper:RCY_C_D .
       _:env_wasmun sdmx-measure:obsValue ?obsValue  .
    } UNION {
       {SELECT 'Other' as ?label {}}
       _:env_wasmun property:wst_oper ?wst_oper .
       FILTER (?wst_oper IN (wst_oper:DSP_L_OTH, wst_oper:DSP_I_RCV_E, 
                            wst_oper:RCY_M, wst_oper:RCY_C_D))
       _:env_wasmun sdmx-measure:obsValue ?obsValue  .
    }

    _:env_wasmun_total sdmx-dimension:timePeriod ?date . 
    _:env_wasmun_total sdmx-dimension:refArea ?geo . 
    _:env_wasmun_total property:wst_oper ?wst_oper_total . 
    _:env_wasmun_total sdmx-attribute:unitMeasure unit:THS_T .
    _:env_wasmun_total property:wst_oper wst_oper:GEN .
    _:env_wasmun_total sdmx-measure:obsValue ?GEN .
   }
  }
 }
 ?geo rdf-schema:label ?ugeo .
 FILTER (?geo in (geo:EU27))
 FILTER (year(?date) > 2003) 
}

ORDER BY ?date


Related content

Temporal coverage

Document Actions
Filed under: