next
previous
items

Data table via SPARQL

Switzerland - Organic agriculture

Data table via SPARQL Published 14 Aug 2014 Last modified 19 Apr 2016

Download this dataset

Dataset preview

(Live Query)

country 2000 2006 2012 change
"Switzerland" "7.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "11"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 1 rows in 0.001 seconds.


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

#no data in eurostat for 2000 and 2012
xsd:decimal(7.7) as ?2000
#no data for 2006 for Switzerland -> 2005
sum(xsd:decimal(?2005)) as ?2006
xsd:decimal(11.3) as ?2012
( (xsd:decimal(11.3) ) - sum(xsd:decimal(?2005)) ) 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) = 2005)
    _:food_in_porg1 sdmx-measure:obsValue ?2005 .
   }
  } 
  ?geo rdf-schema:label ?ugeo . FILTER (?geo = geo:CH)
}
} 
GROUP BY ?geo ?ugeo
ORDER BY ?ugeo


Permalinks

Document Actions