next
previous
items

Data table via SPARQL

Gross nutrient balance on agricultural land

Data table via SPARQL Published 17 May 2018 Last modified 24 Jun 2020

Download this dataset

Dataset preview

(Live Query)

date ugeo nutrient_label obsValue
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Nitrogen" "44.0"^^<http://www.w3.org/2001/XMLSchema#double>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "Nitrogen" "190.0"^^<http://www.w3.org/2001/XMLSchema#double>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "Nitrogen" "28.0"^^<http://www.w3.org/2001/XMLSchema#double>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Switzerland" "Nitrogen" "61.0"^^<http://www.w3.org/2001/XMLSchema#double>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "Nitrogen" "186.0"^^<http://www.w3.org/2001/XMLSchema#double>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Czech Republic" "Nitrogen" "65.0"^^<http://www.w3.org/2001/XMLSchema#double>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "Nitrogen" "110.0"^^<http://www.w3.org/2001/XMLSchema#double>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Denmark" "Nitrogen" "132.0"^^<http://www.w3.org/2001/XMLSchema#double>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Greece" "Nitrogen" "82.0"^^<http://www.w3.org/2001/XMLSchema#double>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Spain" "Nitrogen" "40.0"^^<http://www.w3.org/2001/XMLSchema#double>

Received 975 rows in 0.020 seconds.


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

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

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

    } UNION {
      SELECT xsd:date("2000-01-01") as ?date
             nutrient:N as ?nutrient
             geo:EU as ?geo
             xsd:double(62.7) as ?obsValue WHERE {}
    } UNION {
      SELECT xsd:date("2001-01-01") as ?date
             nutrient:N as ?nutrient
             geo:EU as ?geo
             xsd:double(60.5) as ?obsValue WHERE {}
    } UNION {
      SELECT xsd:date("2002-01-01") as ?date
             nutrient:N as ?nutrient
             geo:EU as ?geo
             xsd:double(59.1) as ?obsValue WHERE {}
    } UNION {
      SELECT xsd:date("2003-01-01") as ?date
             nutrient:N as ?nutrient
             geo:EU as ?geo
             xsd:double(65.1) as ?obsValue WHERE {}

    }}
    ?nutrient rdfs:label ?nutrient_label . 
    ?geo rdfs:label ?ugeo .
    FILTER (year(?date) >= 2000)
  }
}
GROUP BY ?date ?nutrient_label ?ugeo ?geo ?nutrient
ORDER BY ?date


Permalinks

Geographic coverage

Temporal coverage

Tags

Filed under:
Filed under: agriculture
Document Actions