Nitrogen input and balance on agricultural land

Data table via SPARQL Published 30 Sep 2014 Last modified 01 Feb 2016

Download this dataset

Dataset preview

(Live Query)

date ugeo INP_NT BAL_UAA
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "412555"^^<http://www.w3.org/2001/XMLSchema#decimal> "39"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "430992"^^<http://www.w3.org/2001/XMLSchema#decimal> "45"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "406853"^^<http://www.w3.org/2001/XMLSchema#decimal> "50"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "381387"^^<http://www.w3.org/2001/XMLSchema#decimal> "38"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "421988"^^<http://www.w3.org/2001/XMLSchema#decimal> "45"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "419788"^^<http://www.w3.org/2001/XMLSchema#decimal> "45"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "395981"^^<http://www.w3.org/2001/XMLSchema#decimal> "39"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "392181"^^<http://www.w3.org/2001/XMLSchema#decimal> "31"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "401054"^^<http://www.w3.org/2001/XMLSchema#decimal> "36"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "386398"^^<http://www.w3.org/2001/XMLSchema#decimal> "30"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 682 rows in 0.017 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/nitrogen-input-and-balance-on-agricultural-land/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 qb: <http://purl.org/linked-data/cube#> 
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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX nutrient: <http://dd.eionet.europa.eu/vocabulary/eurostat/nutrient/>
PREFIX indic_ag: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_ag/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>

SELECT DISTINCT
year(?date) as ?date
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
sum(?INP_NT) as ?INP_NT
sum(?BAL_UAA) as ?BAL_UAA

WHERE { 
  _:aei_pr_gnb qb:dataSet <http://rdfdata.eionet.europa.eu/eurostat/data/aei_pr_gnb>. 
  _:aei_pr_gnb sdmx-dimension:timePeriod ?date . 
  _:aei_pr_gnb property:nutrient nutrient:N . 
  _:aei_pr_gnb sdmx-dimension:refArea ?geo . 
  {
    _:aei_pr_gnb property:indic_ag indic_ag:INP_NT . 
    _:aei_pr_gnb sdmx-measure:obsValue ?INP_NT .
  } UNION {
    _:aei_pr_gnb property:indic_ag indic_ag:BAL_UAA . 
    _:aei_pr_gnb sdmx-measure:obsValue ?BAL_UAA .
  }
  ?geo rdfs:label ?ugeo .
  FILTER (?geo != geo:EU15 && ?geo != geo:NMS13)

}
GROUP BY ?date ?geo ?ugeo
ORDER BY ?ugeo ?date


Related content

Document Actions