Data table via SPARQL

Total waste excluding major mineral wastes - treatment of waste

Data table via SPARQL Published 15 Oct 2014 Last modified 01 Feb 2016

Data visualisations

Menu

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)

date	type	share
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"Total waste excluding major mineral wastes"	"39.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int>	"Total waste excluding major mineral wastes"	"38.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int>	"Total waste excluding major mineral wastes"	"39.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int>	"Total waste excluding major mineral wastes"	"38.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int>	"Total waste excluding major mineral wastes"	"41.9"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 5 rows in 0.023 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/total-waste-excluding-major-mineral/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 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 rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX waste: <http://dd.eionet.europa.eu/vocabulary/eurostat/waste/>
PREFIX hazard: <http://dd.eionet.europa.eu/vocabulary/eurostat/hazard/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>

SELECT
year(?date) as ?date
'Total waste excluding major mineral wastes' as ?type
bif:either(year(?date) > 2008, round(( ( sum(?wastrt_TOT_X_MIN)-sum(?W09_W124) ) / ( sum(?wasgen_TOT_X_MIN) - sum(?W124_W09) ) )*1000)/10.0, round(( ( sum(?TOTAL)-sum(?W09_W12_X_127NH) ) / ( sum(?wasgen_TOT_X_MIN) - sum(?W124_W09) ) )*1000)/10.0) as ?share
WHERE {{
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wastrt.rdf.gz> 
    {{ 
      _:env_wastrt sdmx-dimension:timePeriod ?date . 
      _:env_wastrt property:hazard hazard:TOTAL . 
      _:env_wastrt sdmx-dimension:refArea ?geo . FILTER (?geo in (geo:EU27, geo:HR)) 
      _:env_wastrt property:wst_oper wst_oper:RCV_NE . 
      _:env_wastrt sdmx-attribute:unitMeasure unit:T . 
      {
        _:env_wastrt property:waste waste:TOTAL . 
        _:env_wastrt sdmx-measure:obsValue ?TOTAL
      } UNION {
        _:env_wastrt property:waste waste:TOT_X_MIN .
        _:env_wastrt sdmx-measure:obsValue ?wastrt_TOT_X_MIN .
      } UNION {
        _:env_wastrt property:waste ?waste . FILTER (?waste in (waste:W09, waste:W12_X_127NH)) 
        _:env_wastrt sdmx-measure:obsValue ?W09_W12_X_127NH
      } UNION {
        _:env_wastrt property:waste ?waste . FILTER (?waste in (waste:W09, waste:W124)) 
        _:env_wastrt sdmx-measure:obsValue ?W09_W124
      }
    }}
    } UNION { 
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wasgen.rdf.gz> 
    {{ 
        _:env_wasgen sdmx-dimension:timePeriod ?date . 
        _:env_wasgen sdmx-dimension:refArea ?geo . FILTER (?geo in (geo:EU27, geo:HR, geo:NO))
        _:env_wasgen property:nace_r2 nace_r2:TOTAL_HH . 
        _:env_wasgen property:hazard hazard:TOTAL . 
        _:env_wasgen sdmx-attribute:unitMeasure unit:T . 
        {
          _:env_wasgen property:waste waste:TOT_X_MIN . 
          _:env_wasgen sdmx-measure:obsValue ?wasgen_TOT_X_MIN .

        } UNION {
          _:env_wasgen property:waste ?waste . FILTER (?waste in (waste:W124, waste:W09)) . 
          _:env_wasgen sdmx-measure:obsValue ?W124_W09
        }
    }}
}}
GROUP BY ?date 
ORDER BY ?date