Do something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data table via SPARQL
Received 18 rows in 0.030 seconds.
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.
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
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 07 Dec 2023, 08:28 PM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others