next
previous
items

Data table via SPARQL

Percentage of irrigated areas applying different irrigation methods

Data table via SPARQL Published 03 Dec 2013 Last modified 20 Apr 2016

Download this dataset

Dataset preview

(Live Query)

country drop_irrigation sprinker_irrigation surface_irrigation total
"Germany" "20.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "79.23"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "30620"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria"@en "29.12"^^<http://www.w3.org/2001/XMLSchema#decimal> "56.76"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.12"^^<http://www.w3.org/2001/XMLSchema#decimal> "6800"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Belgium"@en "19.64"^^<http://www.w3.org/2001/XMLSchema#decimal> "65.71"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.64"^^<http://www.w3.org/2001/XMLSchema#decimal> "5600"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Bulgaria"@en "3.59"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.69"^^<http://www.w3.org/2001/XMLSchema#decimal> "93.72"^^<http://www.w3.org/2001/XMLSchema#decimal> "179420"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Switzerland"@en "15.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "77.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.41"^^<http://www.w3.org/2001/XMLSchema#decimal> "20780"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Cyprus"@en "75.95"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.35"^^<http://www.w3.org/2001/XMLSchema#decimal> "19.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "63860"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Czech Republic"@en "29.52"^^<http://www.w3.org/2001/XMLSchema#decimal> "58.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.38"^^<http://www.w3.org/2001/XMLSchema#decimal> "2100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Denmark"@en "4.16"^^<http://www.w3.org/2001/XMLSchema#decimal> "95.84"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "11060"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Estonia"@en "45.45"^^<http://www.w3.org/2001/XMLSchema#decimal> "54.55"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "440"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Spain"@en "47.42"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.95"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.63"^^<http://www.w3.org/2001/XMLSchema#decimal> "860380"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 28 rows in 0.027 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/percentage-of-irrigated-areas-applying/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 skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX sdmx-unit: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX irrig: <http://dd.eionet.europa.eu/vocabulary/eurostat/irrig/>
PREFIX indic_ef: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_ef/>

SELECT bif:either (?ugeo = 'DE', 'Germany', ?country) as ?country 
(round((sum(?drop_irrigation)/sum(?total))*10000))/100.0 as ?drop_irrigation 
(round((sum(?sprinker_irrigation)/sum(?total))*10000))/100.0 as ?sprinker_irrigation (round((sum(?surface_irrigation)/sum(?total))*10000))/100.0 as ?surface_irrigation 
sum(?total) as ?total 
{{
  SELECT distinct
  ?geo
  ?ugeo
  ?country
  sum(?drop_irrigation) as ?drop_irrigation
  sum(?surface_irrigation) as ?surface_irrigation
  sum(?sprinker_irrigation) as ?sprinker_irrigation
  (sum(?drop_irrigation)+sum(?surface_irrigation)+sum(?sprinker_irrigation)) as ?total
  WHERE {
     GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/ef_poirrig.rdf.gz>  { 
      _:ef_poirrig sdmx-dimension:timePeriod ?date FILTER (year(?date) = 2010)
      {
        _:ef_poirrig property:indic_ef indic_ef:M_8_2_3_EQ_Y_HOLD .
        _:ef_poirrig sdmx-measure:obsValue ?drop_irrigation .
      } union {
        _:ef_poirrig property:indic_ef indic_ef:M_8_2_2_EQ_Y_HOLD .
        _:ef_poirrig sdmx-measure:obsValue ?sprinker_irrigation .
      } union {
        _:ef_poirrig property:indic_ef indic_ef:M_8_2_1_EQ_Y_HOLD .
        _:ef_poirrig sdmx-measure:obsValue ?surface_irrigation .
      }
        _:ef_poirrig property:irrig irrig:TOTAL .
        _:ef_poirrig property:geo ?geo . 
      }
    ?geo skos:prefLabel ?country .
    ?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 ?geo ?ugeo ?country
}} GROUP BY ?country ?ugeo 
HAVING sum(?total) > 0
ORDER BY ?country


Permalinks

Temporal coverage

Document Actions