Changes in Phosphorus balance and GVA of agriculture

Data table via SPARQL Published 10 Dec 2014 Last modified 29 Jan 2016

Download this dataset

Dataset preview

(Live Query)

country change_p change_gva
"Austria" "-168.92"^^<http://www.w3.org/2001/XMLSchema#decimal> "20.65"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Belgium" "-74.26"^^<http://www.w3.org/2001/XMLSchema#decimal> "-31.77"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Bulgaria" "284.39"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.33"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Cyprus" "-7.69"^^<http://www.w3.org/2001/XMLSchema#decimal> "19.33"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Czech Republic" "-273.39"^^<http://www.w3.org/2001/XMLSchema#decimal> "38.76"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Denmark" "-55.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "-30.64"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Estonia" "-53.15"^^<http://www.w3.org/2001/XMLSchema#decimal> "105.26"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Finland" "-51.98"^^<http://www.w3.org/2001/XMLSchema#decimal> "-0.64"^^<http://www.w3.org/2001/XMLSchema#decimal>
"France" "-75.51"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.18"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Germany" "-42.11"^^<http://www.w3.org/2001/XMLSchema#decimal> "-12.85"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 26 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/changes-in-phosphorus-balance-and-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/>

SELECT 
bif:either (?geo = geo:DE, 'Germany', ?ugeo) as ?country

(round( (sum(?p_2011)-sum(?p_2000)) / sum(?p_2000)*10000))/100.0 as ?change_p
(round( (sum(?gva_2011)-sum(?gva_2000)) / sum(?gva_2000)*10000))/100.0 as ?change_gva

{{
	SELECT 
	?ugeo
	?geo
	bif:either(year(?date) = 2000, sum(xsd:integer(?nama_nace64_c)),0) AS ?gva_2000
	bif:either(year(?date) = 2000, sum(?aei_pr_gnb),0) AS ?p_2000
	
	bif:either(year(?date) = 2011, sum(?nama_nace64_c),0) AS ?gva_2011
	bif:either(year(?date) = 2011, sum(?aei_pr_gnb),0) AS ?p_2011
	
	WHERE { 
	    {
	    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/aei_pr_gnb.rdf.gz>  { 
	      _:aei_pr_gnb sdmx-dimension:timePeriod ?date . FILTER (year(?date) in (2000, 2011))
	      _:aei_pr_gnb property:nutrient nutrient:P .
	      _: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 FILTER (year(?date) in (2000, 2011))
	      _: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 } 
	    }
	  }
	  ?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))
	
	}
	GROUP BY ?ugeo ?date ?geo
}}
GROUP BY ?geo ?ugeo
HAVING(sum(?p_2000) != 0 && sum(?gva_2000) != 0)
ORDER BY ?ugeo


Related content

Temporal coverage

Document Actions