Nitrogen emission intensity of agriculture in Europe

Data table via SPARQL Published 13 Jan 2015 Last modified 29 Jan 2016

Download this dataset

Dataset preview

(Live Query)

country date emission_intensity emission_intensity_without_subsidies difference
"Austria" "2000"^^<http://www.w3.org/2001/XMLSchema#int> "48.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "58"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria" "2008"^^<http://www.w3.org/2001/XMLSchema#int> "20.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "21.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria" "2011"^^<http://www.w3.org/2001/XMLSchema#int> "13.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Belgium" "2000"^^<http://www.w3.org/2001/XMLSchema#int> "89.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Belgium" "2008"^^<http://www.w3.org/2001/XMLSchema#int> "77.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "82.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Belgium" "2011"^^<http://www.w3.org/2001/XMLSchema#int> "85.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "90.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Bulgaria" "2000"^^<http://www.w3.org/2001/XMLSchema#int> "86.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "86.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Bulgaria" "2008"^^<http://www.w3.org/2001/XMLSchema#int> "31.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "32.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Bulgaria" "2011"^^<http://www.w3.org/2001/XMLSchema#int> "38.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "40.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Cyprus" "2000"^^<http://www.w3.org/2001/XMLSchema#int> "77.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "77.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 74 rows in 0.005 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/nitrogen-emission-intensity-of-agriculture-1/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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/> 
PREFIX indic_na: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_na/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX nutrient: <http://dd.eionet.europa.eu/vocabulary/eurostat/nutrient/>
PREFIX indic_ag: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_ag/>
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX itm_newa: <http://dd.eionet.europa.eu/vocabulary/eurostat/itm_newa/>

SELECT 
bif:either (?geo = geo:DE, 'Germany', ?ugeo) as ?country
year(?date) as ?date
round(sum(?aei_pr_gnb)/sum(?nama_nace64_c)*10)/10.0 as ?emission_intensity
round(sum(?aei_pr_gnb)/ ( sum(?nama_nace64_c) - sum(?aact_eaa01) ) *10)/10.0 as ?emission_intensity_without_subsidies
round(( ( sum(?aei_pr_gnb)/ ( sum(?nama_nace64_c) - sum(?aact_eaa01) ) ) - ( sum(?aei_pr_gnb)/sum(?nama_nace64_c) ) )*10)/10.0 as ?difference

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:N .
      _:aei_pr_gnb sdmx-dimension:refArea ?geo . 
      _:aei_pr_gnb property:indic_ag indic_ag:BAL .  
      OPTIONAL { _:aei_pr_gnb sdmx-measure:obsValue ?aei_pr_gnb } 
    } 
  } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_nace64_c.rdf.gz>  { 
      _:nama_nace64_c sdmx-dimension:timePeriod ?date .
      _:nama_nace64_c sdmx-dimension:refArea ?geo . 
      _:nama_nace64_c property:indic_na indic_na:B1G .
      _:nama_nace64_c sdmx-attribute:unitMeasure unit:MIO_EUR . 
      _:nama_nace64_c property:nace_r2 nace_r2:A01 . 
      OPTIONAL { _:nama_nace64_c sdmx-measure:obsValue ?nama_nace64_c } 
    }
  } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/aact_eaa01.rdf.gz>  { 
      _:aact_eaa01 sdmx-dimension:timePeriod ?date .
      _:aact_eaa01 property:itm_newa itm_newa:18000 . 
      _:aact_eaa01 sdmx-dimension:refArea ?geo . 
      _:aact_eaa01 sdmx-attribute:unitMeasure unit:MIO_EUR . 
      _:aact_eaa01 property:indic_ag indic_ag:SUBS . 
      OPTIONAL { _:aact_eaa01 sdmx-measure:obsValue ?aact_eaa01 } 
    }
  }
  FILTER (year(?date) in (2000, 2008, 2011))
  ?geo skos:prefLabel ?ugeo .
  FILTER (?geo in (geo:AT,geo:BE,geo:BG,geo:CH,geo:CY,geo:CZ,geo:DE,geo:DK, geo:EE,geo:ES,geo:FI,geo:FR,geo:GB,geo:GR,geo:HR,geo:HU,geo:IE,geo:IS,geo:IT, geo:LI,geo:LT,geo:LU,geo:LV,geo:MT,geo:NL,geo:NO,geo:PL,geo:PT,geo:RO,geo:SE,geo:SI,geo:SK,geo:TR)) 
}
HAVING sum(?aei_pr_gnb)/sum(?nama_nace64_c) > 0 && sum(?aei_pr_gnb)/ ( sum(?nama_nace64_c) - sum(?aact_eaa01) ) > 0
ORDER BY ?ugeo ?date


Related content

Document Actions