Data table via SPARQL
No information in development of MSW management
Data table via SPARQL
Published 31 Aug 2015
Last modified 28 Jul 2021
Download this dataset
Dataset preview
(Live Query)
Received 656 rows in 0.014 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/no-information-in-development-of-1/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.
http://semantic.eea.europa.eu/sparql
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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 wst_oper: <http://dd.eionet.europa.eu/vocabulary/eurostat/wst_oper/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
SELECT
year(?date) as ?date
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
'No information' as ?wst_oper_label
bif:either(( sum(?GEN) - (sum(?RCY) + sum(?DSP_L) + sum(?INC_RCV) )) > 0, round(( sum(?GEN) - (sum(?RCY) + sum(?DSP_L) + sum(?INC_RCV) ))), '') as ?env_wasmun
#round(( sum(?GEN) - (sum(?RCY) + sum(?DSP_D) + sum(?INC_RCV) ))) as ?env_wasmun
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 sdmx-dimension:refArea ?geo .
_:env_wasmun sdmx-attribute:unitMeasure unit:THS_T .
{
_:env_wasmun property:wst_oper ?wst_oper . FILTER (?wst_oper in (wst_oper:RCY_M, wst_oper:RCY_OC))
_:env_wasmun sdmx-measure:obsValue ?RCY .
} UNION {
_:env_wasmun property:wst_oper wst_oper:DSP_L .
_:env_wasmun sdmx-measure:obsValue ?DSP_L .
} 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:GEN .
_:env_wasmun sdmx-measure:obsValue ?GEN .
}
}
?geo rdfs:label ?ugeo .
FILTER (?geo != geo:BA && ?geo != geo:MK && ?geo != geo:ME && ?geo != geo:XK)
}
GROUP BY ?ugeo ?date ?geo
ORDER BY ?ugeo ?date
Permalinks
- Permalink to this version
- 088ad78bc7664511930dae382c135250
- Permalink to latest version
- VA4KNMS38C
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/no-information-in-development-of-1 or scan the QR code.
PDF generated on 17 Sep 2021, 02:48 AM
Document Actions
Share with others