Packaging waste generation per capita and by country
Data table via SPARQL
Published 22 Oct 2013
Last modified 19 Nov 2019
draft used for:
http://www.eea.europa.eu/data-and-maps/figures/packaging-waste-generation-per-capita-and-by-country-12
Download this dataset
Dataset preview
(Live Query)
Received 528 rows in 0.011 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/packaging-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 flow: <http://rdfdata.eionet.europa.eu/eurostat/dic/flow#>
PREFIX waste: <http://rdfdata.eionet.europa.eu/eurostat/dic/waste#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT
?date
(round(sum(?waste)*10000/sum(?population)))/10.0 as ?kg_pro_capita
#((round(sum(?waste)*100/sum(?population))*10000)) as ?kg_pro_capita
sum(?population) as ?population
(sum(?waste)) as ?waste
?ugeo
{{
SELECT
?date
?population
?waste
?ugeo
?memberOfcode
WHERE {{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_waspac.rdf.gz> {
{
_:env_waspac sdmx-dimension:timePeriod ?date . FILTER (?date >= "1997-01-01"^^xsd:date)
_:env_waspac property:geo ?geo .
_:env_waspac property:unit u:T .
_:env_waspac property:wst_oper wst:GEN .
_:env_waspac property:flow flow:DOMESTIC .
_:env_waspac property:waste waste:W1501 .
_:env_waspac 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 >= "1997-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'))
}
GROUP BY ?date ?ugeo ORDER BY ?ugeo ?date
Error when running query:
Query timeout.
Permalinks
- Permalink to this version
- 73da3ad3b63d4c3d8462a16a5627ac25
- Permalink to latest version
- UWK1H4ON2S
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/packaging-waste-generation-per-capita or scan the QR code.
PDF generated on 19 Nov 2019, 03:18 PM
Document Actions
Share with others