Data table via SPARQL

Environmental protection expenditure by organisation type, in absolute value

Data table via SPARQL Published 01 Sep 2016 Last modified 16 Nov 2016

Data visualisations

Menu

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)

date	category	obsValue
"2003"^^<http://www.w3.org/2001/XMLSchema#int>	"Government"	"69.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int>	"Government"	"71.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int>	"Government"	"78.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int>	"Government"	"84"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int>	"Government"	"84.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int>	"Government"	"84.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int>	"Government"	"90.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int>	"Government"	"86.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"Government"	"85.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int>	"Government"	"84.2"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 39 rows in 0.148 seconds.

JSON Url:
https://eea.europa.eu./data-and-maps/daviz/sds/environmental-protection-expenditure-by-organisation-1/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 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 indic_pi: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_pi/>
PREFIX caparema: <http://dd.eionet.europa.eu/vocabulary/eurostat/ceparema/>
PREFIX nace_r2:<http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX ty: <http://dd.eionet.europa.eu/vocabulary/eurostat/ty/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX age: <http://dd.eionet.europa.eu/vocabulary/eurostat/age/>
PREFIX sex: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX indic_em: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_em/>
PREFIX env_exp: <http://dd.eionet.europa.eu/vocabulary/eurostat/env_exp/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX env_dom: <http://dd.eionet.europa.eu/vocabulary/eurostat/env_dom/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>

#technical debt
SELECT 
?date
?nace_r2_label as ?category
round(sum(xsd:double(?env_ac_exp1r2)) / (sum(?CP_MEUR)/sum(?CLV10_MEUR))/100)/10.0 as ?obsValue

{{

SELECT DISTINCT
year(?date) as ?date
?nace_r2
bif:either(?nace_r2 = nace_r2:B-E36, 'Industry',
bif:either(?nace_r2 = nace_r2:EP_GOV, 'Government',
bif:either(?nace_r2 = nace_r2:EP_SPE, 'Specialised service provider',''))) as ?nace_r2_label

sum(xsd:double(?env_ac_exp1r2)) as ?env_ac_exp1r2
sum(?CP_MEUR) as ?CP_MEUR
sum(?CLV10_MEUR) as ?CLV10_MEUR

#round(sum(xsd:double(?env_ac_exp1r2))/100)/10.0 as ?env_ac_exp1r2
#round(sum(?CP_MEUR)/sum(?CLV10_MEUR)*1000)/10.0 as ?deflator
#round(sum(xsd:double(?env_ac_exp2))*100)/100.0 as ?env_ac_exp2
#round(sum(xsd:double(?env_ac_exp1r2))*100)/100.0 as ?env_ac_exp1r2
#round(sum(?CP_MEUR)/sum(?CLV10_MEUR)*1000)/10.0 as ?deflator
WHERE {
 {
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_exp1r2.rdf.gz>
    {
      _:env_ac_exp1r2 sdmx-dimension:timePeriod ?date . 
      _:env_ac_exp1r2 sdmx-dimension:refArea geo:EU28 . 
      _:env_ac_exp1r2 property:env_dom env_dom:ED1000 . 
      _:env_ac_exp1r2 property:env_exp env_exp:EE1000 .
      _:env_ac_exp1r2 sdmx-attribute:unitMeasure unit:MIO_EUR . 
      _:env_ac_exp1r2 property:nace_r2 ?nace_r2 . 
      FILTER (?nace_r2 in (nace_r2:B-E36, nace_r2:EP_GOV, nace_r2:EP_SPE))

      _:env_ac_exp1r2 sdmx-measure:obsValue ?env_ac_exp1r2 .
    }
 } UNION {
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_10_gdp.rdf.gz>
  {
    {
      SELECT nace_r2:B-E36 as ?nace_r2 {}
    } UNION {
      SELECT nace_r2:EP_GOV as ?nace_r2 {}
    } UNION {
      SELECT nace_r2:EP_SPE as ?nace_r2 {}
    }
    _:nama_10_gdp sdmx-dimension:timePeriod ?date . 
    _:nama_10_gdp property:na_item na_item:B1GQ . 
    _:nama_10_gdp sdmx-dimension:refArea geo:EU28 .
    _:nama_10_gdp sdmx-attribute:unitMeasure ?unit .
    {
      _:nama_10_gdp sdmx-attribute:unitMeasure unit:CLV10_MEUR .
      _:nama_10_gdp sdmx-measure:obsValue ?CLV10_MEUR .
    } UNION {
      _:nama_10_gdp sdmx-attribute:unitMeasure unit:CP_MEUR .
      _:nama_10_gdp sdmx-measure:obsValue ?CP_MEUR .
    }
   }
 }
 FILTER (year(?date) >= 2003)
}
GROUP BY ?nace_r2 ?date

}}
GROUP BY ?nace_r2_label ?date
ORDER BY ?nace_r2_label ?date