Gross nutrient balance on agricultural land

Data table via SPARQL Last modified 17 May 2018
Topics: ,

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.022 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


Related content

Visualisations produced

Temporal coverage

Document Actions
Filed under: