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)

year EEA33 EEA32 EU28 EU27 EU15 EFTA4 NMS13 NMS12 NMS10 TR WB7
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "465"^^<http://www.w3.org/2001/XMLSchema#decimal> "469"^^<http://www.w3.org/2001/XMLSchema#decimal> "462"^^<http://www.w3.org/2001/XMLSchema#decimal> "466"^^<http://www.w3.org/2001/XMLSchema#decimal> "496"^^<http://www.w3.org/2001/XMLSchema#decimal> "603"^^<http://www.w3.org/2001/XMLSchema#decimal> "347"^^<http://www.w3.org/2001/XMLSchema#decimal> "362"^^<http://www.w3.org/2001/XMLSchema#decimal> "331"^^<http://www.w3.org/2001/XMLSchema#decimal> "445"^^<http://www.w3.org/2001/XMLSchema#decimal> "NULL"
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "483"^^<http://www.w3.org/2001/XMLSchema#decimal> "487"^^<http://www.w3.org/2001/XMLSchema#decimal> "480"^^<http://www.w3.org/2001/XMLSchema#decimal> "484"^^<http://www.w3.org/2001/XMLSchema#decimal> "520"^^<http://www.w3.org/2001/XMLSchema#decimal> "607"^^<http://www.w3.org/2001/XMLSchema#decimal> "344"^^<http://www.w3.org/2001/XMLSchema#decimal> "359"^^<http://www.w3.org/2001/XMLSchema#decimal> "340"^^<http://www.w3.org/2001/XMLSchema#decimal> "471"^^<http://www.w3.org/2001/XMLSchema#decimal> "NULL"
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "498"^^<http://www.w3.org/2001/XMLSchema#decimal> "501"^^<http://www.w3.org/2001/XMLSchema#decimal> "496"^^<http://www.w3.org/2001/XMLSchema#decimal> "498"^^<http://www.w3.org/2001/XMLSchema#decimal> "536"^^<http://www.w3.org/2001/XMLSchema#decimal> "606"^^<http://www.w3.org/2001/XMLSchema#decimal> "358"^^<http://www.w3.org/2001/XMLSchema#decimal> "364"^^<http://www.w3.org/2001/XMLSchema#decimal> "352"^^<http://www.w3.org/2001/XMLSchema#decimal> "503"^^<http://www.w3.org/2001/XMLSchema#decimal> "NULL"
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "494"^^<http://www.w3.org/2001/XMLSchema#decimal> "499"^^<http://www.w3.org/2001/XMLSchema#decimal> "491"^^<http://www.w3.org/2001/XMLSchema#decimal> "496"^^<http://www.w3.org/2001/XMLSchema#decimal> "540"^^<http://www.w3.org/2001/XMLSchema#decimal> "622"^^<http://www.w3.org/2001/XMLSchema#decimal> "327"^^<http://www.w3.org/2001/XMLSchema#decimal> "341"^^<http://www.w3.org/2001/XMLSchema#decimal> "343"^^<http://www.w3.org/2001/XMLSchema#decimal> "510"^^<http://www.w3.org/2001/XMLSchema#decimal> "NULL"
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "508"^^<http://www.w3.org/2001/XMLSchema#decimal> "513"^^<http://www.w3.org/2001/XMLSchema#decimal> "506"^^<http://www.w3.org/2001/XMLSchema#decimal> "510"^^<http://www.w3.org/2001/XMLSchema#decimal> "554"^^<http://www.w3.org/2001/XMLSchema#decimal> "617"^^<http://www.w3.org/2001/XMLSchema#decimal> "339"^^<http://www.w3.org/2001/XMLSchema#decimal> "353"^^<http://www.w3.org/2001/XMLSchema#decimal> "349"^^<http://www.w3.org/2001/XMLSchema#decimal> "463"^^<http://www.w3.org/2001/XMLSchema#decimal> "NULL"
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "523"^^<http://www.w3.org/2001/XMLSchema#decimal> "526"^^<http://www.w3.org/2001/XMLSchema#decimal> "520"^^<http://www.w3.org/2001/XMLSchema#decimal> "523"^^<http://www.w3.org/2001/XMLSchema#decimal> "568"^^<http://www.w3.org/2001/XMLSchema#decimal> "637"^^<http://www.w3.org/2001/XMLSchema#decimal> "357"^^<http://www.w3.org/2001/XMLSchema#decimal> "361"^^<http://www.w3.org/2001/XMLSchema#decimal> "346"^^<http://www.w3.org/2001/XMLSchema#decimal> "458"^^<http://www.w3.org/2001/XMLSchema#decimal> "NULL"
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "517"^^<http://www.w3.org/2001/XMLSchema#decimal> "522"^^<http://www.w3.org/2001/XMLSchema#decimal> "516"^^<http://www.w3.org/2001/XMLSchema#decimal> "521"^^<http://www.w3.org/2001/XMLSchema#decimal> "572"^^<http://www.w3.org/2001/XMLSchema#decimal> "545"^^<http://www.w3.org/2001/XMLSchema#decimal> "324"^^<http://www.w3.org/2001/XMLSchema#decimal> "338"^^<http://www.w3.org/2001/XMLSchema#decimal> "322"^^<http://www.w3.org/2001/XMLSchema#decimal> "457"^^<http://www.w3.org/2001/XMLSchema#decimal> "NULL"
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "523"^^<http://www.w3.org/2001/XMLSchema#decimal> "528"^^<http://www.w3.org/2001/XMLSchema#decimal> "522"^^<http://www.w3.org/2001/XMLSchema#decimal> "527"^^<http://www.w3.org/2001/XMLSchema#decimal> "576"^^<http://www.w3.org/2001/XMLSchema#decimal> "566"^^<http://www.w3.org/2001/XMLSchema#decimal> "333"^^<http://www.w3.org/2001/XMLSchema#decimal> "347"^^<http://www.w3.org/2001/XMLSchema#decimal> "320"^^<http://www.w3.org/2001/XMLSchema#decimal> "450"^^<http://www.w3.org/2001/XMLSchema#decimal> "NULL"
"2003"^^<http://www.w3.org/2001/XMLSchema#int> "511"^^<http://www.w3.org/2001/XMLSchema#decimal> "516"^^<http://www.w3.org/2001/XMLSchema#decimal> "510"^^<http://www.w3.org/2001/XMLSchema#decimal> "515"^^<http://www.w3.org/2001/XMLSchema#decimal> "563"^^<http://www.w3.org/2001/XMLSchema#decimal> "565"^^<http://www.w3.org/2001/XMLSchema#decimal> "321"^^<http://www.w3.org/2001/XMLSchema#decimal> "335"^^<http://www.w3.org/2001/XMLSchema#decimal> "313"^^<http://www.w3.org/2001/XMLSchema#decimal> "445"^^<http://www.w3.org/2001/XMLSchema#decimal> "NULL"
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "513"^^<http://www.w3.org/2001/XMLSchema#decimal> "515"^^<http://www.w3.org/2001/XMLSchema#decimal> "512"^^<http://www.w3.org/2001/XMLSchema#decimal> "514"^^<http://www.w3.org/2001/XMLSchema#decimal> "563"^^<http://www.w3.org/2001/XMLSchema#decimal> "567"^^<http://www.w3.org/2001/XMLSchema#decimal> "329"^^<http://www.w3.org/2001/XMLSchema#decimal> "331"^^<http://www.w3.org/2001/XMLSchema#decimal> "310"^^<http://www.w3.org/2001/XMLSchema#decimal> "421"^^<http://www.w3.org/2001/XMLSchema#decimal> "NULL"

Received 18 rows in 0.003 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.

Are you new to Linked Data technology? visit http://linkeddata.org



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


Related content

Document Actions