All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo 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 49 rows in 0.026 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 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 nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX hazard: <http://dd.eionet.europa.eu/vocabulary/eurostat/hazard/>
PREFIX waste: <http://dd.eionet.europa.eu/vocabulary/eurostat/waste/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
SELECT DISTINCT
year(?date) as ?date
?category
round((sum(?obsValue)/sum(?total))*1000)/10.0 as ?share
round(sum(?obsValue)/100000)/10.0 as ?obsValue
round(sum(?total)/100000)/10.0 as ?total
WHERE {{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wasgen.rdf.gz>
{{
_:env_wasgen sdmx-dimension:timePeriod ?date .
_:env_wasgen property:hazard hazard:HAZ_NHAZ .
_:env_wasgen property:waste waste:TOT_X_MIN .
_:env_wasgen sdmx-dimension:refArea geo:EU28 .
_:env_wasgen sdmx-attribute:unitMeasure unit:T .
{
{ SELECT 'Agriculture, forestry and fishing' as ?category {} }
_:env_wasgen property:nace_r2 nace_r2:A .
_:env_wasgen sdmx-measure:obsValue ?obsValue .
} UNION {
{ SELECT 'Energy and extraction' as ?category {} }
_:env_wasgen property:nace_r2 ?nace_r2 .
FILTER (?nace_r2 in (nace_r2:B, nace_r2:D))
_:env_wasgen sdmx-measure:obsValue ?obsValue .
} UNION {
{ SELECT 'Manufacturing' as ?category {} }
_:env_wasgen property:nace_r2 ?nace_r2 .
FILTER (?nace_r2 in (nace_r2:C10-C12, nace_r2:C13-C15,
nace_r2:C16, nace_r2:C17_C18, nace_r2:C19,
nace_r2:C20-C22, nace_r2:C23, nace_r2:C24_C25,
nace_r2:C26-C30, nace_r2:C31-C33))
_:env_wasgen sdmx-measure:obsValue ?obsValue .
} UNION {
{ SELECT 'Water and waste sector' as ?category {} }
_:env_wasgen property:nace_r2 ?nace_r2 .
FILTER (?nace_r2 in (nace_r2:E36_E37_E39, nace_r2:E38, nace_r2:G4677))
_:env_wasgen sdmx-measure:obsValue ?obsValue .
} UNION {
{ SELECT 'Construction' as ?category {} }
_:env_wasgen property:nace_r2 nace_r2:F .
_:env_wasgen sdmx-measure:obsValue ?obsValue .
} UNION {
{ SELECT 'Services' as ?category {} }
_:env_wasgen property:nace_r2 nace_r2:G-U_X_G4677 .
_:env_wasgen sdmx-measure:obsValue ?obsValue .
} UNION {
{ SELECT 'Households' as ?category {} }
_:env_wasgen property:nace_r2 nace_r2:EP_HH .
_:env_wasgen sdmx-measure:obsValue ?obsValue .
}
_:env_wasgen_total sdmx-dimension:timePeriod ?date .
_:env_wasgen_total property:hazard hazard:HAZ_NHAZ .
_:env_wasgen_total property:waste waste:TOT_X_MIN .
_:env_wasgen_total sdmx-dimension:refArea geo:EU28 .
_:env_wasgen_total sdmx-attribute:unitMeasure unit:T .
_:env_wasgen_total property:nace_r2 nace_r2:TOTAL_HH .
_:env_wasgen_total sdmx-measure:obsValue ?total .
}}
}}
GROUP BY ?geo ?category ?date
ORDER BY ?date ?category
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/generation-of-waste-excluding-major-3 or scan the QR code.
PDF generated on 01 Sep 2024, 05:58 AM
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