Distribution of Utilised Agricultural Area (UAA) by category

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

Download this dataset

Dataset preview

(Live Query)

date cropsLabel ugeo obsValue
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Arable land" "Albania" "413"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Arable land" "Austria" "1346.02"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Arable land" "Bosnia and Herzegovina" "587"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Arable land" "Belgium" "836.37"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Arable land" "Bulgaria" "3494.08"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Arable land" "Switzerland" "397.52"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Arable land" "Cyprus" "98.24"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Arable land" "Czech Republic" "2495.93"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Arable land" "Germany" "11846.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Arable land" "Denmark" "2348.69"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 232 rows in 0.007 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/distribution-of-utilised-agricultural-area/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 crops: <http://dd.eionet.europa.eu/vocabulary/eurostat/crops/>

SELECT 
year(?date) as ?date
?cropsLabel
bif:either(?geo=geo:DE, 'Germany', ?ugeo) as ?ugeo
bif:either(?obsValue<0, 0, ?obsValue) as ?obsValue
{
    {
    SELECT DISTINCT
      ?date
      ?cropsLabel
      ?geo
      ?obsValue
        WHERE {{ 
          GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/tag00025.rdf.gz>  {{
            _:tag00025 sdmx-dimension:timePeriod ?date .
            FILTER (year(?date) = 2015)
            _:tag00025 property:crops ?crops .
            _:tag00025 sdmx-dimension:refArea ?geo .
            _:tag00025 property:strucpro ?strucpro .
            OPTIONAL { _:tag00025 sdmx-measure:obsValue ?obsValue }
        }}
        ?crops rdfs:label ?cropsLabel .
      }}
  } UNION {
    SELECT DISTINCT
      ?date
      'Other' as ?cropsLabel
      ?geo
      (?obsValue_UAA - sum(?obsValue_OTHERS)) as ?obsValue
      WHERE {{ 
        GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/tag00025.rdf.gz>  {{
          _:tag00025_UAA sdmx-dimension:timePeriod ?date .
          FILTER (year(?date) = 2015)
          _:tag00025_UAA property:crops crops:UAA .
          _:tag00025_UAA sdmx-dimension:refArea ?geo .
          _:tag00025_UAA property:strucpro ?strucpro .
          OPTIONAL { _:tag00025_UAA sdmx-measure:obsValue ?obsValue_UAA }
          _:tag00025_OTHERS sdmx-dimension:timePeriod ?date .
          FILTER (year(?date) = 2015)
          _:tag00025_OTHERS property:crops ?crops_OTHERS .
          FILTER (?crops_OTHERS in (crops:ARA, crops:J0000, crops:PECR))
          _:tag00025_OTHERS sdmx-dimension:refArea ?geo .
          _:tag00025_OTHERS property:strucpro ?strucpro .
          OPTIONAL { _:tag00025_OTHERS sdmx-measure:obsValue ?obsValue_OTHERS }
        }}
      }}
   }
   ?geo rdfs:label ?ugeo .
}


Related content

Temporal coverage

Document Actions