Organic agriculture

Data table via SPARQL Published 11 Mar 2014 Last modified 19 Apr 2016
Topics: ,

Download this dataset

Dataset preview

(Live Query)

country 2000 2006 2012 change
"Austria" "13.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "16.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "18.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Belgium" "1.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Bulgaria" "" "0.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Croatia" "" "" "2.4"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"Czech Republic" "" "7.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Denmark" "5.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Estonia" "" "9.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"European Union (15 countries)" "3"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""
"European Union (25 countries)" "" "4.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "" ""
"European Union (27 countries)" "" "3.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "2"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 30 rows in 0.003 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/organic-agriculture/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



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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>

SELECT 
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?country
sum(xsd:decimal(?2000)) as ?2000
sum(xsd:decimal(?2006)) as ?2006
sum(xsd:decimal(?2012)) as ?2012

( sum(xsd:decimal(?2012)) - sum(xsd:decimal(?2006)) ) as ?change

WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/food_in_porg1.rdf.gz> 
  {
   _:food_in_porg1 property:geo ?geo .
   _:food_in_porg1 property:cropitem <http://dd.eionet.europa.eu/vocabulary/eurostat/cropitem/C_00> .
   _:food_in_porg1 property:variable <http://dd.eionet.europa.eu/vocabulary/eurostat/variable/PCT_ORG_UAA> .

   {
    _:food_in_porg1 sdmx-dimension:timePeriod ?date . FILTER (year(?date) = 2000)
    _:food_in_porg1 sdmx-measure:obsValue ?2000 .
   } UNION {
    _:food_in_porg1 sdmx-dimension:timePeriod ?date . FILTER (year(?date) = 2006)
    _:food_in_porg1 sdmx-measure:obsValue ?2006 .
   } UNION {
    _:food_in_porg1 sdmx-dimension:timePeriod ?date . FILTER (year(?date) = 2012)
    _:food_in_porg1 sdmx-measure:obsValue ?2012 .
   }
  } 
  ?geo rdf-schema:label ?ugeo . FILTER (?geo != geo:NO and ?geo != geo:CH and ?geo != geo:MK and ?geo != geo:EL and ?geo != geo:CY)
}
} 
GROUP BY ?geo ?ugeo
ORDER BY ?ugeo


Temporal coverage

Document Actions
Filed under: