Data table via SPARQL
Share of imports in direct use of materials
Download this dataset
Dataset preview
(Live Query)
Received 20 rows in 0.023 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/share-of-imports-in-direct-1/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.
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 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 when running query:
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 561, 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 1241, in https_open
context=self._context)
File "/usr/local/lib/python2.7/urllib2.py", line 1201, in do_open
r = h.getresponse(buffering=True)
File "/usr/local/lib/python2.7/httplib.py", line 1148, in getresponse
response.begin()
File "/usr/local/lib/python2.7/httplib.py", line 448, in begin
version, status, reason = self._read_status()
File "/usr/local/lib/python2.7/httplib.py", line 404, in _read_status
line = self.fp.readline(_MAXLINE + 1)
File "/usr/local/lib/python2.7/socket.py", line 480, in readline
data = self._sock.recv(self._rbufsize)
File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/green/ssl.py", line 194, in recv
return self._base_recv(buflen, flags, into=False)
File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/green/ssl.py", line 227, in _base_recv
read = self.read(nbytes)
File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/green/ssl.py", line 139, in read
super(GreenSSLSocket, self).read, *args, **kwargs)
File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/green/ssl.py", line 119, in _call_trampolining
timeout_exc=timeout_exc('timed out'))
File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/hubs/__init__.py", line 163, in trampoline
return hub.switch()
File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/hubs/hub.py", line 295, in switch
return self.greenlet.switch()
SSLError: ('timed out',)
Permalinks
- Permalink to this version
- dd76ba332a8d416088c4e8baec85f04b
- Permalink to latest version
- 9OZIGSNPXF
Older versions
Geographic coverage
Temporal coverage
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/share-of-imports-in-direct-1 or scan the QR code.
PDF generated on 05 Feb 2023, 12:08 AM
Document Actions
Share with others