Data table via SPARQL

EEA static figures to be converted to Daviz

Data table via SPARQL Published 13 Jun 2016 Last modified 29 Jul 2024

A list of possible candidates of static figures that can be converted to interactive charts (DaViz).

Content activity and overviews — Site Administration

Menu

Indicators
- EEA static figures to be converted to Daviz

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

code	EEAfigure	data_label	data_creator
"CLIM048"	<http://www.eea.europa.eu/data-and-maps/figures/placing-on-the-market-of-hfcs>	"Fluorinated greenhouse gases 2020"@en	"orbeirat"
"CLIM048"	<http://www.eea.europa.eu/data-and-maps/figures/eu-progress-under-the-montreal>	"Fluorinated greenhouse gases 2020"@en	"orbeirat"
"CLIM049"	<http://www.eea.europa.eu/data-and-maps/figures/consumption-of-controlled-ozone-depleting-1>	"Ozone-depleting substances 2021"@en	"gabpeder"
"CLIM049"	<http://www.eea.europa.eu/data-and-maps/figures/consumption-of-controlled-ozone-depleting-2>	"Ozone-depleting substances 2021"@en	"gabpeder"
"CLIM050"	<http://www.eea.europa.eu/data-and-maps/figures/eu-27-effort-sharing-ets-1>	"Greenhouse gas emissions under the Effort Sharing Decision (ESD)"@en	"orbeirat"
"CLIM050"	<http://www.eea.europa.eu/data-and-maps/figures/eu-27-effort-sharing-ets-1>	"Greenhouse gas emissions under the Effort Sharing Decision (ESD)"@en	"perezrod"
"CLIM050"	<http://www.eea.europa.eu/data-and-maps/figures/figure-1-historical-trends-and>	"Member States' greenhouse gas (GHG) emission projections"@en	"orbeirat"
"CLIM050"	<http://www.eea.europa.eu/data-and-maps/figures/figure-1-historical-trends-and>	"Member States' greenhouse gas (GHG) emission projections"@en	"perezrod"
"CLIM050"	<http://www.eea.europa.eu/data-and-maps/figures/figure-1-historical-trends-and>	"Member States' greenhouse gas (GHG) emission projections"@en	"esparjav"
"CLIM050"	<http://www.eea.europa.eu/data-and-maps/figures/eu-27-effort-sharing-ets-1>	"Member States' greenhouse gas (GHG) emission projections"@en	"orbeirat"

Received 49 rows in 0.002 seconds.

JSON Url:
https://www.eea.europa.eu/content-activity/indicators/eeafigures-to-be-converted-to-daviz/daviz.json

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


        PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf-syntax: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX s: <http://www.eea.europa.eu/portal_types/Specification#>
PREFIX a: <http://www.eea.europa.eu/portal_types/Assessment#>
PREFIX ap: <http://www.eea.europa.eu/portal_types/AssessmentPart#>
PREFIX fig: <http://www.eea.europa.eu/portal_types/EEAFigure#>
PREFIX data: <http://www.eea.europa.eu/portal_types/Data#>

SELECT DISTINCT
?code
#?s_title
#?s
#?a
#?ap
#?ap_type
?ap_related_items as ?EEAfigure
#?ap_related_items_type
#?data
?data_label
?data_creator
#?ap_related_items_figuretype
WHERE {
  ?s dcterms:title ?s_title .
  ?s s:codes ?code .
  ?s rdf-syntax:type ?type . FILTER (?type = s:Specification)
  OPTIONAL { ?s dcterms:isReplacedBy ?isReplacedBy . }
  FILTER (!bound(?isReplacedBy))

  ?s dcterms:hasPart ?a .
  ?a a:id ?a_id .
  ?a rdf-syntax:type ?a_type . FILTER (?a_type = a:Assessment) 
  OPTIONAL { ?a dcterms:isReplacedBy ?a_isReplacedBy . }
  FILTER (!bound(?a_isReplacedBy))

  ?a dcterms:hasPart ?ap .
  ?ap rdf-syntax:type ?ap_type . FILTER (?ap_type = ap:AssessmentPart) 
  ?ap ap:relatedItems ?ap_related_items .
  ?ap_related_items rdf-syntax:type ?ap_related_items_type . FILTER (?ap_related_items_type = fig:EEAFigure)
  ?ap_related_items fig:figureType ?ap_related_items_figuretype .  FILTER (str(?ap_related_items_figuretype)  = 'graph')

  ?ap_related_items fig:relatedItems ?data .
  ?data rdf-syntax:type ?data_type . FILTER (?data_type = data:Data) 
  ?data rdfs:label ?data_label .
  ?data dcterms:creator ?data_creator .
} 
ORDER BY ?code

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 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 435, in open
    response = meth(req, response)
  File "/usr/local/lib/python2.7/urllib2.py", line 548, in http_response
    'http', request, response, code, msg, hdrs)
  File "/usr/local/lib/python2.7/urllib2.py", line 473, in error
    return self._call_chain(*args)
  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 556, in http_error_default
    raise HTTPError(req.get_full_url(), code, msg, hdrs, fp)
HTTPError: HTTP Error 308: Permanent Redirect