All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo 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 39 rows in 0.002 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 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/>
PREFIX common_countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>
SELECT DISTINCT
year(?date) as ?date
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
round(sum(xsd:double(?obsValue))*100)/100.0 as ?obsValue
WHERE {
{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_exp2.rdf.gz>
{
_:env_ac_exp2 sdmx-dimension:timePeriod ?date .
#FILTER (year(?date) in (2012, 2013))
_:env_ac_exp2 sdmx-dimension:refArea geo:EU28 .
_:env_ac_exp2 property:env_dom env_dom:ED1000 .
_:env_ac_exp2 property:env_exp env_exp:EE1000 .
_:env_ac_exp2 sdmx-attribute:unitMeasure unit:PC_GDP .
_:env_ac_exp2 property:nace_r2 ?nace_r2 .
FILTER (?nace_r2 in (nace_r2:B-E36, nace_r2:EP_GOV, nace_r2:EP_SPE))
_:env_ac_exp2 sdmx-measure:obsValue ?obsValue .
}
}
}
GROUP BY ?date ?category ?nace_r2
ORDER BY ?date
For references, please go to https://eea.europa.eu./data-and-maps/daviz/sds/environmental-protection-expenditure-by-organisation-type or scan the QR code.
PDF generated on 23 Nov 2024, 12:30 PM
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