Municipal waste generation per capita in Europe
Data table via SPARQL
Published 21 Oct 2013
Last modified 19 Apr 2016
draft for:
http://www.eea.europa.eu/data-and-maps/figures/municipal-waste-generation-per-capita-in-western-europe-eu-15-new-member-states-eu-12-eu-countries-eu-27-and-total-in-europe-eu-27-turkey-croatia-norway-iceland-switzerland-7
Download this dataset
Dataset preview
(Live Query)
Received 18 rows in 0.059 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/municipal-waste-generation-per-capita/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.
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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#>
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX g: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX a: <http://rdfdata.eionet.europa.eu/eurostat/dic/age#>
PREFIX s: <http://rdfdata.eionet.europa.eu/eurostat/dic/sex#>
PREFIX wst: <http://rdfdata.eionet.europa.eu/eurostat/dic/wst_oper#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT
year(?date) as ?year
sum(?EEA33) as ?EEA33
sum(?EEA32) as ?EEA32
sum(?EU28) as ?EU28
sum(?EU27) as ?EU27
sum(?EU15) as ?EU15
sum(?EFTA4) as ?EFTA4
sum(?NMS13) as ?NMS13
sum(?NMS12) as ?NMS12
sum(?NMS10) as ?NMS10
sum(?TR) as ?TR
#sum(?WB7) as ?WB7
IF(sum(?WB7) <200, 'NULL', sum(?WB7)) as ?WB7
{{
SELECT
?date
bif:either(?memberOfcode = 'EEA33', ?kg_pro_capita,0) AS ?EEA33
bif:either(?memberOfcode = 'EEA32', ?kg_pro_capita,0) AS ?EEA32
bif:either(?memberOfcode = 'EU28', ?kg_pro_capita,0) AS ?EU28
bif:either(?memberOfcode = 'EU27', ?kg_pro_capita,0) AS ?EU27
bif:either(?memberOfcode = 'EU15', ?kg_pro_capita,0) AS ?EU15
bif:either(?memberOfcode = 'EFTA4', ?kg_pro_capita,0) AS ?EFTA4
bif:either(?memberOfcode = 'NMS13', ?kg_pro_capita,0) AS ?NMS13
bif:either(?memberOfcode = 'NMS12', ?kg_pro_capita,0) AS ?NMS12
bif:either(?memberOfcode = 'NMS10', ?kg_pro_capita,0) AS ?NMS10
bif:either(?memberOfcode = 'TR', ?kg_pro_capita,0) AS ?TR
bif:either(?memberOfcode = 'WB7', ?kg_pro_capita,0) AS ?WB7
{{
SELECT
?date
((round((sum(?waste)*1000000)/sum(?population))*100)/100) as ?kg_pro_capita
sum(?population) as ?population
(sum(?waste)*1000) as ?waste_tons
?memberOfcode
{{
SELECT
?date
?population
?waste
?ugeo
(if( (?ugeo = 'TR'), 'TR', ?memberOfcode)) as ?memberOfcode
WHERE {{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wasmun.rdf.gz> {
{
_:env_wasmun sdmx-dimension:timePeriod ?date . FILTER (?date >= "1995-01-01"^^xsd:date)
_:env_wasmun property:geo ?geo .
_:env_wasmun property:unit u:1000T .
_:env_wasmun property:wst_oper wst:GEN .
_:env_wasmun sdmx-measure:obsValue ?waste .
}}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/demo_pjan.rdf.gz> {
{
_:demo_pjan sdmx-dimension:timePeriod ?date . FILTER (?date >= "1995-01-01"^^xsd:date)
_:demo_pjan property:geo ?geo .
_:demo_pjan sdmx-dimension:age a:TOTAL .
_:demo_pjan property:sex s:T .
_:demo_pjan sdmx-measure:obsValue ?population .
}}
}
?geo skos:prefLabel ?country .
?geo skos:notation ?ugeo .
?eeageo owl:sameAs ?geo .
?eeageo skos:inScheme <http://rdfdata.eionet.europa.eu/eea/countries/> .
?memberOf skos:member ?eeageo .
?memberOf skos:notation ?memberOfcode .
}
}
FILTER (?memberOfcode IN ('EEA33','EEA32','EU28','EU27','EU15','EFTA4','NMS13','NMS12','NMS10','TR','WB7'))
}
}}
GROUP BY ?date ?memberOfcode ORDER BY ?memberOfcode ?date
}} GROUP BY ?date ORDER BY ?date
Permalinks
- Permalink to this version
- 3965e6f636884eb284e9cbb38f89a9da
- Permalink to latest version
- 95OVWGERXJ
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/municipal-waste-generation-per-capita or scan the QR code.
PDF generated on 22 Oct 2019, 04:56 PM
Document Actions
Share with others