Percentual change in the number of holdings and utilised agricultural area (UAA) by size class

Data table via SPARQL Published 09 Nov 2017 Last modified 09 Nov 2017
30 min read
Topics: ,

Download this dataset

Dataset preview

(Live Query)

category order agrareaLabel obsValue
"Number of holdings" "4"^^<http://www.w3.org/2001/XMLSchema#int> "From 5 to 9.9 ha" "-17.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Utilised agricultural area" "8"^^<http://www.w3.org/2001/XMLSchema#int> "From 50 to 99.9 ha" "-1.53"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Utilised agricultural area" "3"^^<http://www.w3.org/2001/XMLSchema#int> "From 2 to 4.9 ha" "-21.41"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Number of holdings" "2"^^<http://www.w3.org/2001/XMLSchema#int> "Less than 2 ha" "-19.37"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Utilised agricultural area" "6"^^<http://www.w3.org/2001/XMLSchema#int> "From 20 to 29.9 ha" "-7.64"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Number of holdings" "9"^^<http://www.w3.org/2001/XMLSchema#int> "100 ha or over" "10.94"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Number of holdings" "8"^^<http://www.w3.org/2001/XMLSchema#int> "From 50 to 99.9 ha" "-1.82"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Utilised agricultural area" "5"^^<http://www.w3.org/2001/XMLSchema#int> "From 10 to 19.9 ha" "-12.07"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Number of holdings" "5"^^<http://www.w3.org/2001/XMLSchema#int> "From 10 to 19.9 ha" "-12.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Number of holdings" "10"^^<http://www.w3.org/2001/XMLSchema#int> "Total" "-17.05"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 19 rows in 0.077 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/percentual-change-in-the-number/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.

Are you new to Linked Data technology? visit http://linkeddata.org



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 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
}}


Related content

Temporal coverage

Document Actions