next
previous
items

Data table via SPARQL

Trends in domestic material consumption by category

Data table via SPARQL Published 23 Aug 2018 Last modified 24 Jun 2020

Download this dataset

Dataset preview

(Live Query)

year ugeo material_label share env_ac_mfa env_ac_mfa_idx
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Biomass" "19.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "36.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "186"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Metal ores (gross ores)" "3.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "186"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Non-metallic minerals" "63.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "118.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "186"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Fossil energy materials/carriers" "12.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "24"^^<http://www.w3.org/2001/XMLSchema#decimal> "186"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Biomass" "20.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "36.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "180.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Metal ores (gross ores)" "3.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "180.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Non-metallic minerals" "62.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "112.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "180.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Fossil energy materials/carriers" "13.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "24.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "180.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Biomass" "19.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "36.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "193.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Metal ores (gross ores)" "3.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "193.9"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 2088 rows in 0.236 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/use-of-resorces-domestic-material-7/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



http://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 sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX indic_env: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_env/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX material: <http://dd.eionet.europa.eu/vocabulary/eurostat/material/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>

SELECT 
year(?date) as ?year

bif:either(?geo = geo:DE, 'Germany', 
bif:either(?geo = geo:EU28, 'European Union', 
?ugeo)) as ?ugeo

?material_label
round(( ?env_ac_mfa/?env_ac_mfa_idx )*1000)/10.0 as ?share
round(?env_ac_mfa/100)/10.0 as ?env_ac_mfa
round(?env_ac_mfa_idx/100)/10.0 as ?env_ac_mfa_idx


WHERE {{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_mfa.rdf.gz> 
  {
  _:env_ac_mfa sdmx-dimension:refArea ?geo .
  _:env_ac_mfa sdmx-dimension:timePeriod ?date .
  _:env_ac_mfa property:indic_env indic_env:DMC .
  _:env_ac_mfa sdmx-attribute:unitMeasure unit:THS_T .
  _:env_ac_mfa property:material ?material . 
  FILTER (?material in (material:MF1, material:MF2, material:MF3, material:MF4)) .
  _:env_ac_mfa sdmx-measure:obsValue ?env_ac_mfa .

  _:env_ac_mfa_idx sdmx-dimension:refArea ?geo .
  _:env_ac_mfa_idx sdmx-dimension:timePeriod ?date .
  _:env_ac_mfa_idx property:indic_env indic_env:DMC .
  _:env_ac_mfa_idx sdmx-attribute:unitMeasure unit:THS_T .
  _:env_ac_mfa_idx property:material ?material_idx . 
  FILTER (?material_idx in (material:TOTAL)) .
  _:env_ac_mfa_idx sdmx-measure:obsValue ?env_ac_mfa_idx .
 }
 ?material rdf-schema:label ?material_label .
 ?geo rdf-schema:label ?ugeo .

 FILTER (year(?date) >= 2000)

  FILTER (?geo in (geo:EU28, geo:AT, geo:BE, geo:BG, geo:HR, geo:CY, geo:CZ, geo:DK, geo:EE, geo:FI, geo:FR, geo:DE, geo:EL, geo:FR, geo:HU, geo:IE, geo:IT, geo:LV, geo:LT, geo:LU, geo:MT, geo:NL, geo:PL, geo:PT, geo:RO, geo:SK, geo:SI, geo:ES, geo:SE, geo:UK))
}}
ORDER BY ?ugeo ?date


Permalinks

Geographic coverage

Temporal coverage

Tags

Document Actions