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

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

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.002 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/percentage-of-irrigated-areas-applying/daviz.json

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
semantic.eea.europa.eu/sparql

SPARQL Query:


        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