Phosphorus emission intensity of agriculture

Data table via SPARQL Published 02 Dec 2013 Last modified 29 Jan 2016

Download this dataset

Dataset preview

(Live Query)

country 2000 2008
"Germany" "4"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria"@en "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Belgium"@en "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Bulgaria"@en "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "-11"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Switzerland"@en "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Cyprus"@en "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Czech Republic"@en "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Denmark"@en "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "13"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Estonia"@en "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "-28"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Spain"@en "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 30 rows in 0.001 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/phosphorus-emission-intensity-of-agriculture/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 u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#> 
PREFIX indic_na: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_na#>
PREFIX nace_r2: <http://rdfdata.eionet.europa.eu/eurostat/dic/nace_r2#>
PREFIX nutrient: <http://rdfdata.eionet.europa.eu/eurostat/dic/nutrient#>
PREFIX indic_ag: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_ag#>

SELECT 
bif:either (?ugeo = 'DE', 'Germany', ?country_tmp) as ?country
sum(?2000) as ?2000
sum(?2008) as ?2008
{{

SELECT 
?date
?ugeo
?country_tmp

bif:either(year(?date) = 2000, (sum(?aei_pr_gnb)/sum(?nama_nace64_c)),xsd:double(0)) AS ?2000
bif:either(year(?date) = 2008, (sum(?aei_pr_gnb)/sum(?nama_nace64_c)),xsd:double(0)) AS ?2008

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, 2008))
      _:aei_pr_gnb property:indic_ag indic_ag:BAL . 
      _:aei_pr_gnb property:nutrient nutrient:P .
      _:aei_pr_gnb property:geo ?geo . 
      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, 2008))
      _:nama_nace64_c property:indic_na indic_na:B1G . 
      _:nama_nace64_c property:nace_r2 nace_r2:A01 . 
      _:nama_nace64_c property:unit u:MIO_EUR . 
      _:nama_nace64_c property:geo ?geo . 
      OPTIONAL { _:nama_nace64_c sdmx-measure:obsValue ?nama_nace64_c . }
    }
  }
  ?geo skos:prefLabel ?country_tmp .
  ?geo skos:notation ?ugeo . 
  ?eeageo owl:sameAs ?geo . 
  ?eeageo skos:inScheme <http://rdfdata.eionet.europa.eu/eea/countries/> . 
  ?memberOf skos:member ?eeageo . 
  ?memberOf skos:notation ?memberOfcode . FILTER (?memberOfcode IN ('EEA33'))
} 


GROUP BY ?date ?ugeo ?country_tmp

}} 
ORDER BY ?country


Related content

Temporal coverage

Document Actions