Do 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 20 rows in 0.001 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 material: <http://dd.eionet.europa.eu/vocabulary/eurostat/material/>
PREFIX indic_env: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_env/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
SELECT
year(?date) as ?date
round((?IMP_total/?DMI_total)*1000)/10.0 as ?total
round((?IMP_MF1/?DMI_MF1)*100) as ?biomass
round((?IMP_MF2/?DMI_MF2)*100) as ?metal_ores_gross_ores
round((?IMP_MF3/?DMI_MF3)*100) as ?non_metallic_minerals
round((?IMP_MF4/?DMI_MF4)*100) as ?fossil_energy_materials_carriers
round(?IMP_total/10000)/100.0 as ?IMP_total
round(?DMC_total/10000)/100.0 as ?DMC_total
{{
SELECT
?date
sum(?IMP_total) as ?IMP_total
sum(?IMP_MF1) as ?IMP_MF1
sum(?IMP_MF2) as ?IMP_MF2
sum(?IMP_MF3) as ?IMP_MF3
sum(?IMP_MF4) as ?IMP_MF4
sum(?DMI_total) as ?DMI_total
sum(?DMI_MF1) as ?DMI_MF1
sum(?DMI_MF2) as ?DMI_MF2
sum(?DMI_MF3) as ?DMI_MF3
sum(?DMI_MF4) as ?DMI_MF4
sum(?DMC_total) as ?DMC_total
WHERE {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_mfa.rdf.gz>
{
_:env_ac_mfa sdmx-dimension:timePeriod ?date .
_:env_ac_mfa sdmx-dimension:refArea geo:EU28 .
_:env_ac_mfa sdmx-attribute:unitMeasure unit:THS_T .
{
_:env_ac_mfa property:indic_env indic_env:IMP_XEU .
{
_:env_ac_mfa property:material material:TOTAL .
_:env_ac_mfa sdmx-measure:obsValue ?IMP_total .
} UNION {
_:env_ac_mfa property:material material:MF1 .
_:env_ac_mfa sdmx-measure:obsValue ?IMP_MF1 .
} UNION {
_:env_ac_mfa property:material material:MF2 .
_:env_ac_mfa sdmx-measure:obsValue ?IMP_MF2 .
} UNION {
_:env_ac_mfa property:material material:MF3 .
_:env_ac_mfa sdmx-measure:obsValue ?IMP_MF3 .
} UNION {
_:env_ac_mfa property:material material:MF4 .
_:env_ac_mfa sdmx-measure:obsValue ?IMP_MF4 .
}
} UNION {
_:env_ac_mfa property:indic_env indic_env:DMI .
{
_:env_ac_mfa property:material material:TOTAL .
_:env_ac_mfa sdmx-measure:obsValue ?DMI_total .
} UNION {
_:env_ac_mfa property:material material:MF1 .
_:env_ac_mfa sdmx-measure:obsValue ?DMI_MF1 .
} UNION {
_:env_ac_mfa property:material material:MF2 .
_:env_ac_mfa sdmx-measure:obsValue ?DMI_MF2 .
} UNION {
_:env_ac_mfa property:material material:MF3 .
_:env_ac_mfa sdmx-measure:obsValue ?DMI_MF3 .
} UNION {
_:env_ac_mfa property:material material:MF4 .
_:env_ac_mfa sdmx-measure:obsValue ?DMI_MF4 .
}
} UNION {
_:env_ac_mfa property:indic_env indic_env:DMC .
{
_:env_ac_mfa property:material material:TOTAL .
_:env_ac_mfa sdmx-measure:obsValue ?DMC_total .
}
}
}
} GROUP BY ?date
}
} ORDER BY ?date
Error. Traceback (most recent call last):
File "/plone/buildout-cache/eggs/Products.ZSPARQLMethod-2.3-py2.7.egg/Products/ZSPARQLMethod/Method.py", line 287, in run_with_timeout
ret = func(*args, **kwargs)
File "/plone/buildout-cache/eggs/Products.ZSPARQLMethod-2.3-py2.7.egg/Products/ZSPARQLMethod/Method.py", line 215, in query_and_get_result
result = sparql.query(*args, timeout = kwargs.get("timeout", 0) or 0)
File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 747, in query
return s.query(query, timeout, raw=raw)
File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 416, in query
return q.query(query, timeout, raw=raw)
File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 571, in query
response = self._request(statement, timeout)
File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 558, in _request
response = self._build_response(query, opener, buf, timeout)
File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 543, in _build_response
timeout if timeout > 0 else None)
File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 514, in _get_response
response = opener.open(request, timeout=timeout)
File "/usr/local/lib/python2.7/urllib2.py", line 429, in open
response = self._open(req, data)
File "/usr/local/lib/python2.7/urllib2.py", line 447, in _open
'_open', req)
File "/usr/local/lib/python2.7/urllib2.py", line 407, in _call_chain
result = func(*args)
File "/usr/local/lib/python2.7/urllib2.py", line 1228, in http_open
return self.do_open(httplib.HTTPConnection, req)
File "/usr/local/lib/python2.7/urllib2.py", line 1198, in do_open
raise URLError(err)
URLError: <urlopen error [Errno -2] No address found>
For references, please go to https://eea.europa.eu./data-and-maps/daviz/sds/share-of-imports-in-direct-1 or scan the QR code.
PDF generated on 23 Nov 2024, 10:26 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