Trends in domestic material consumption by category

Data table via SPARQL Published 19 Jul 2017 Last modified 20 Jul 2017
This is an old version, kept for reference only.

Go to latest version

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.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "36.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "185.7"^^<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> "185.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Non-metallic minerals" "63.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "118"^^<http://www.w3.org/2001/XMLSchema#decimal> "185.7"^^<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> "185.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Biomass" "20.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "36.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "180.2"^^<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.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "180.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Non-metallic minerals" "61.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "111.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "180.2"^^<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.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "180.2"^^<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.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Metal ores (gross ores)" "3.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "193.2"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 2200 rows in 0.069 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/use-of-resorces-domestic-material-6/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', ?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 != geo:EA19 && ?geo != geo:EA && ?geo != geo:EA12 && ?geo != geo:EA17 && ?geo != geo:EA18 && ?geo != geo:EU15 && ?geo != geo:JP && ?geo != geo:MK && ?geo != geo:US  && ?geo != geo:ME && ?geo != geo:AL && ?geo != geo:AD && ?geo != geo:AM && ?geo != geo:AZ && ?geo != geo:EA16 && ?geo != geo:EEA30 && ?geo != geo:EEA31 && ?geo != geo:EFTA && ?geo != geo:ME && ?geo != geo:UA && ?geo != geo:RU && ?geo != geo:MD && ?geo != geo:DE_TOT && ?geo != geo:BY && ?geo != geo:BA && ?geo != geo:FX && ?geo != geo:GE) 
}}
ORDER BY ?ugeo ?date


Related content

Temporal coverage

Document Actions