next
previous
items

Data table via SPARQL

Gross nutrient balance on agricultural land

Data table via SPARQL Published 23 May 2017 Last modified 29 Jun 2017
This is an old version, kept for reference only.

Go to latest version

Download this dataset

Dataset preview

(Live Query)

date ugeo nutrient_label obsValue
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Nitrogen" "41.0"^^<http://www.w3.org/2001/XMLSchema#double>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "Nitrogen" "272.0"^^<http://www.w3.org/2001/XMLSchema#double>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "Nitrogen" "93.0"^^<http://www.w3.org/2001/XMLSchema#double>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Switzerland" "Nitrogen" "81.0"^^<http://www.w3.org/2001/XMLSchema#double>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "Nitrogen" "171.0"^^<http://www.w3.org/2001/XMLSchema#double>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Czech Republic" "Nitrogen" "93.0"^^<http://www.w3.org/2001/XMLSchema#double>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "Nitrogen" "139.0"^^<http://www.w3.org/2001/XMLSchema#double>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Denmark" "Nitrogen" "178.0"^^<http://www.w3.org/2001/XMLSchema#double>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Greece" "Nitrogen" "117.0"^^<http://www.w3.org/2001/XMLSchema#double>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Spain" "Nitrogen" "31.0"^^<http://www.w3.org/2001/XMLSchema#double>

Received 1397 rows in 0.020 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/gross-nutrient-balance-on-agricultural-land-2/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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX nutrient: <http://dd.eionet.europa.eu/vocabulary/eurostat/nutrient/>

SELECT DISTINCT
year(?date) as ?date
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
?nutrient_label
sum(xsd:double(?obsValue)) as ?obsValue

WHERE {
{
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/t2020_rn310.rdf.gz> 
    {{
      _:t2020_rn310 sdmx-dimension:timePeriod ?date . 
      _:t2020_rn310 property:nutrient ?nutrient . 
      _:t2020_rn310 sdmx-dimension:refArea ?geo . 
      #FILTER (?geo = geo:EU28)
      _:t2020_rn310 sdmx-attribute:unitMeasure ?unit . 
      _:t2020_rn310 property:indic_ag ?indic_ag . 
      _:t2020_rn310 sdmx-measure:obsValue ?obsValue .

    } UNION {
      SELECT xsd:date("2014-01-01") as ?date
             nutrient:N as ?nutrient
             geo:EU28 as ?geo
             xsd:double(50.57) as ?obsValue WHERE {}
    } UNION {
      SELECT xsd:date("2000-01-01") as ?date
             nutrient:N as ?nutrient
             geo:EU28 as ?geo
             xsd:double(62.71) as ?obsValue WHERE {}
    } UNION {
      SELECT xsd:date("2001-01-01") as ?date
             nutrient:N as ?nutrient
             geo:EU28 as ?geo
             xsd:double(60.51) as ?obsValue WHERE {}
    } UNION {
      SELECT xsd:date("2002-01-01") as ?date
             nutrient:N as ?nutrient
             geo:EU28 as ?geo
             xsd:double(59.07) as ?obsValue WHERE {}
    } UNION {
      SELECT xsd:date("2003-01-01") as ?date
             nutrient:N as ?nutrient
             geo:EU28 as ?geo
             xsd:double(65.09) as ?obsValue WHERE {}
    }}
    ?nutrient rdfs:label ?nutrient_label . 
    ?geo rdfs:label ?ugeo .
  }
}
GROUP BY ?date ?nutrient_label ?ugeo ?geo ?nutrient
ORDER BY ?date


Permalinks

Geographic coverage

Temporal coverage

Tags

Filed under:
Filed under: agriculture
Document Actions