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 19 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 geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX indic_ef: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_ef/>
PREFIX ontology: <http://rdfdata.eionet.europa.eu/eea/ontology/>
PREFIX countries: <http://rdfdata.eionet.europa.eu/eea/countries/>
PREFIX legtype: <http://dd.eionet.europa.eu/vocabulary/eurostat/legtype/>
PREFIX agrarea: <http://dd.eionet.europa.eu/vocabulary/eurostat/agrarea/>
SELECT DISTINCT
bif:either(?indic_ef = indic_ef:HOLD_HOLD, 'Number of holdings', 'Utilised agricultural area') as ?category
#?agrarea
bif:either(?agrarea = agrarea:HA0, 1,
(bif:either(?agrarea = agrarea:HA_LT2, 2,
(bif:either(?agrarea = agrarea:HA2-4, 3,
(bif:either(?agrarea = agrarea:HA5-9, 4,
(bif:either(?agrarea = agrarea:HA10-19, 5,
(bif:either(?agrarea = agrarea:HA20-29, 6,
(bif:either(?agrarea = agrarea:HA30-49, 7,
(bif:either(?agrarea = agrarea:HA50-99, 8,
(bif:either(?agrarea = agrarea:HA_GE100, 9, 10))))))))))))))))) as ?order
?agrareaLabel
round(((?obsValue_last-?obsValue_first)/sum(?obsValue_first))*10000.0)/100.0 as ?obsValue
{{
SELECT DISTINCT
?indic_ef
?agrarea
?agrareaLabel
sum(?obsValue_first) as ?obsValue_first
sum(?obsValue_last) as ?obsValue_last
WHERE {{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/ef_kvaareg.rdf.gz> {{
_:ef_kvaareg_first sdmx-dimension:timePeriod ?date_first .
FILTER (year(?date_first)= 2005)
_:ef_kvaareg_first property:legtype legtype:TOTAL .
_:ef_kvaareg_first property:indic_ef ?indic_ef .
_:ef_kvaareg_first sdmx-dimension:refArea ?geo .
_:ef_kvaareg_first property:agrarea ?agrarea .
_:ef_kvaareg_first sdmx-measure:obsValue ?obsValue_first .
_:ef_kvaareg_last sdmx-dimension:timePeriod ?date_last .
FILTER (year(?date_last)= 2010)
_:ef_kvaareg_last property:legtype legtype:TOTAL .
_:ef_kvaareg_last property:indic_ef ?indic_ef .
_:ef_kvaareg_last sdmx-dimension:refArea ?geo .
_:ef_kvaareg_last property:agrarea ?agrarea .
_:ef_kvaareg_last sdmx-measure:obsValue ?obsValue_last .
FILTER (?indic_ef in (indic_ef:HOLD_HOLD, indic_ef:AGRAREA_HA))
}}
?eeageo owl:sameAs ?geo .
?eeageo ontology:memberOf countries:EU28 .
?agrarea rdfs:label ?agrareaLabel .
}}
GROUP BY ?indic_ef ?agrareaLabel ?agrarea
HAVING (sum(?obsValue_last)-sum(?obsValue_first)) != 0
}}
For references, please go to https://eea.europa.eu./data-and-maps/daviz/sds/percentual-change-in-the-number or scan the QR code.
PDF generated on 23 Nov 2024, 11:37 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