Mineral waste from construction and demolition, waste treatment

Data table via SPARQL Published 05 Dec 2019 Last modified 13 Dec 2019

Download this dataset

Dataset preview

(Live Query)

date geo wst_oper absoluteObsValue obsValue
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Netherlands" "energy recovery " "1380"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Portugal" "recycling" "361451"^^<http://www.w3.org/2001/XMLSchema#decimal> "41.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "energy recovery " "1036141"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Czechia" "recycling" "3372750"^^<http://www.w3.org/2001/XMLSchema#decimal> "68.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "landfill and other " "65535"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Slovenia" "energy recovery " "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "landfill and other " "75448"^^<http://www.w3.org/2001/XMLSchema#decimal> "16"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Spain" "energy recovery " "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Slovakia" "landfill and other " "191660"^^<http://www.w3.org/2001/XMLSchema#decimal> "46.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2016"^^<http://www.w3.org/2001/XMLSchema#int> "Czechia" "landfill and other " "409372"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.4"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 164 rows in 0.005 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/mineral-waste-from-construction-and/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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX waste: <http://dd.eionet.europa.eu/vocabulary/eurostat/waste/>
PREFIX hazard: <http://dd.eionet.europa.eu/vocabulary/eurostat/hazard/>
PREFIX wst_oper: <http://dd.eionet.europa.eu/vocabulary/eurostat/wst_oper/>

SELECT 
year(?date ) as ?date
?geo
?wst_oper
?obsValue as ?absoluteObsValue
round((?obsValue/?rtr)*1000.0)/10.0 as ?obsValue
#?rtr
{
  SELECT DISTINCT
    ?date 
    bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?geo
    if(contains(?wst_oper_label, '('), STRBEFORE(?wst_oper_label, '('), ?wst_oper_label) as ?tmp
    lcase(REPLACE(REPLACE(?tmp, 'Recovery - ','' ), 'Disposal - ','')) as ?wst_oper

    sum(?obsValue) as ?obsValue
    sum(?obsValue_tot) as ?rtr
  WHERE {{
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wastrt.rdf.gz> { 
    {
      _:env_wastrt sdmx-dimension:timePeriod ?date .
      _:env_wastrt property:hazard hazard:HAZ_NHAZ .
      _:env_wastrt property:waste waste:W121 .
      _:env_wastrt sdmx-dimension:refArea ?geo .
      _:env_wastrt property:wst_oper ?wst_oper .
      FILTER (?wst_oper in (wst_oper:DSP_L_OTH, wst_oper:DSP_I, 
                            wst_oper:RCV_E, wst_oper:RCV_R, wst_oper:RCV_B))
      _:env_wastrt sdmx-attribute:unitMeasure unit:T .
      _:env_wastrt sdmx-measure:obsValue ?obsValue .

      _:env_wastrt_tot sdmx-dimension:timePeriod ?date .
      _:env_wastrt_tot property:hazard hazard:HAZ_NHAZ .
      _:env_wastrt_tot property:waste waste:W121 .
      _:env_wastrt_tot sdmx-dimension:refArea ?geo .
      _:env_wastrt_tot property:wst_oper wst_oper:TRT .
      _:env_wastrt_tot sdmx-attribute:unitMeasure unit:T .
      _:env_wastrt_tot sdmx-measure:obsValue ?obsValue_tot .
    }
  }}
  ?geo rdfs:label  ?ugeo .
  ?wst_oper rdfs:label ?wst_oper_label .
  #FILTER (?geo in (geo:EU28))
  FILTER (year(?date) = 2016) 
 }
}
GROUP BY ?date ?geo ?wst_oper ?obsValue ?rtr
HAVING (?rtr > 0)
ORDER BY ?ugeo


Related content

Temporal coverage

Document Actions
Filed under: , ,