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.069 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


Related content

Temporal coverage

Document Actions