Area covered by each of the main irrigated crops

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

Download this dataset

Dataset preview

(Live Query)

country cereals maize rice pulses potatoes sugar_beet rape_and_turnip_rape sunflower textile_crops fresh_vegetables_melons_strawberries temporary_and_permanent_grass other_crops_on_arable_land fruit_and_berry_plantations citrus_plantations olive_plantations vineyards total
"Germany" "27.34"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.43"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.36"^^<http://www.w3.org/2001/XMLSchema#decimal> "22.33"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.39"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.02"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.74"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.79"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.57"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.27"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.23"^^<http://www.w3.org/2001/XMLSchema#decimal> "366690"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Austria"@en "3.27"^^<http://www.w3.org/2001/XMLSchema#decimal> "20.93"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.11"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.23"^^<http://www.w3.org/2001/XMLSchema#decimal> "18.05"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.23"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "26.71"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.48"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.53"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.29"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.15"^^<http://www.w3.org/2001/XMLSchema#decimal> "26320"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Belgium"@en "11.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "28.36"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.71"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.62"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "16.22"^^<http://www.w3.org/2001/XMLSchema#decimal> "20.12"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.52"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.16"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "24050"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Bulgaria"@en "1.36"^^<http://www.w3.org/2001/XMLSchema#decimal> "19.27"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.61"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.82"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.12"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.76"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.46"^^<http://www.w3.org/2001/XMLSchema#decimal> "24.97"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.35"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.56"^^<http://www.w3.org/2001/XMLSchema#decimal> "89470"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Switzerland"@en "7.09"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.34"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.07"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.46"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.69"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.36"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.82"^^<http://www.w3.org/2001/XMLSchema#decimal> "45.24"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.41"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.92"^^<http://www.w3.org/2001/XMLSchema#decimal> "27650"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Cyprus"@en "5.63"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.09"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.32"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.41"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.35"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.38"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "19.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.76"^^<http://www.w3.org/2001/XMLSchema#decimal> "24.46"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.93"^^<http://www.w3.org/2001/XMLSchema#decimal> "34090"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Czech Republic"@en "9.57"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "20.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.82"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "30.04"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.13"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.13"^^<http://www.w3.org/2001/XMLSchema#decimal> "18.34"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "2"^^<http://www.w3.org/2001/XMLSchema#decimal> "15980"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Denmark"@en "47.76"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.49"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.57"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.02"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.43"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.05"^^<http://www.w3.org/2001/XMLSchema#decimal> "25.71"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.49"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "321880"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Estonia"@en "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.68"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "54.84"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "22.58"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "310"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Spain"@en "20.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.34"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.83"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.09"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.26"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.39"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.09"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.58"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.42"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.15"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.87"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.71"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.96"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.83"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.69"^^<http://www.w3.org/2001/XMLSchema#decimal> "3035100"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 28 rows in 0.053 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/area-covered-by-each-of/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://rdfdata.eionet.europa.eu/eurostat/dic/irrig#>
PREFIX indic_ef: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_ef#>

SELECT
bif:either (?ugeo = 'DE', 'Germany', ?country) as ?country
(round((sum(?cereals)/sum(?total))*10000))/100.0 as ?cereals
(round((sum(?maize)/sum(?total))*10000))/100.0 as ?maize
(round((sum(?rice)/sum(?total))*10000))/100.0 as ?rice
(round((sum(?pulses)/sum(?total))*10000))/100.0 as ?pulses
(round((sum(?potatoes)/sum(?total))*10000))/100.0 as ?potatoes
(round((sum(?sugar_beet)/sum(?total))*10000))/100.0 as ?sugar_beet
(round((sum(?rape_and_turnip_rape)/sum(?total))*10000))/100.0 as ?rape_and_turnip_rape
(round((sum(?sunflower)/sum(?total))*10000))/100.0 as ?sunflower
(round((sum(?textile_crops)/sum(?total))*10000))/100.0 as ?textile_crops
(round((sum(?fresh_vegetables_melons_strawberries)/sum(?total))*10000))/100.0 as ?fresh_vegetables_melons_strawberries
(round((sum(?temporary_and_permanent_grass)/sum(?total))*10000))/100.0 as ?temporary_and_permanent_grass
(round((sum(?other_crops_on_arable_land)/sum(?total))*10000))/100.0 as ?other_crops_on_arable_land
(round((sum(?fruit_and_berry_plantations)/sum(?total))*10000))/100.0 as ?fruit_and_berry_plantations
(round((sum(?citrus_plantations)/sum(?total))*10000))/100.0 as ?citrus_plantations
(round((sum(?olive_plantations)/sum(?total))*10000))/100.0 as ?olive_plantations
(round((sum(?vineyards)/sum(?total))*10000))/100.0 as ?vineyards

#(sum(?cereals)+sum(?rice)+sum(?maize)+sum(?pulses)+sum(?potatoes)+sum(?sugar_beet)+sum(?rape_and_turnip_rape)+sum(?sunflower)+sum(?textile_crops)+sum(?fresh_vegetables_melons_strawberries)+sum(?temporary_and_permanent_grass)+sum(?other_crops_on_arable_land)+sum(?fruit_and_berry_plantations)+sum(?citrus_plantations)+sum(?olive_plantations)+sum(?vineyards)) as ?check 

sum(?total) as ?total
{{
SELECT DISTINCT
?ugeo
?country
bif:either(?indic_ef = indic_ef:M_8_1_2_1_HA, sum(?ef_poirrig),0) AS ?cereals
bif:either(?indic_ef = indic_ef:M_8_1_2_2_HA, sum(?ef_poirrig),0) AS ?maize
bif:either(?indic_ef = indic_ef:M_8_1_2_3_HA, sum(?ef_poirrig),0) AS ?rice
bif:either(?indic_ef = indic_ef:M_8_1_2_4_HA, sum(?ef_poirrig),0) AS ?pulses
bif:either(?indic_ef = indic_ef:M_8_1_2_5_HA, sum(?ef_poirrig),0) AS ?potatoes
bif:either(?indic_ef = indic_ef:M_8_1_2_6_HA, sum(?ef_poirrig),0) AS ?sugar_beet
bif:either(?indic_ef = indic_ef:M_8_1_2_7_HA, sum(?ef_poirrig),0) AS ?rape_and_turnip_rape
bif:either(?indic_ef = indic_ef:M_8_1_2_8_HA, sum(?ef_poirrig),0) AS ?sunflower
bif:either(?indic_ef = indic_ef:M_8_1_2_9_HA, sum(?ef_poirrig),0) AS ?textile_crops
bif:either(?indic_ef = indic_ef:M_8_1_2_10_HA, sum(?ef_poirrig),0) AS ?fresh_vegetables_melons_strawberries
bif:either(?indic_ef = indic_ef:M_8_1_2_11_HA, sum(?ef_poirrig),0) AS ?temporary_and_permanent_grass
bif:either(?indic_ef = indic_ef:M_8_1_2_12_HA, sum(?ef_poirrig),0) AS ?other_crops_on_arable_land
bif:either(?indic_ef = indic_ef:M_8_1_2_13_HA, sum(?ef_poirrig),0) AS ?fruit_and_berry_plantations
bif:either(?indic_ef = indic_ef:M_8_1_2_14_HA, sum(?ef_poirrig),0) AS ?citrus_plantations
bif:either(?indic_ef = indic_ef:M_8_1_2_15_HA, sum(?ef_poirrig),0) AS ?olive_plantations
bif:either(?indic_ef = indic_ef:M_8_1_2_16_HA, sum(?ef_poirrig),0) AS ?vineyards
sum(?ef_poirrig) as ?total
{{
SELECT distinct
?geo
?ugeo
?country
?ef_poirrig
?indic_ef

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 FILTER (?indic_ef in (indic_ef:M_8_1_2_1_HA,indic_ef:M_8_1_2_2_HA,indic_ef:M_8_1_2_3_HA,indic_ef:M_8_1_2_4_HA,indic_ef:M_8_1_2_5_HA,indic_ef:M_8_1_2_6_HA,indic_ef:M_8_1_2_7_HA,indic_ef:M_8_1_2_8_HA,indic_ef:M_8_1_2_9_HA,indic_ef:M_8_1_2_10_HA,indic_ef:M_8_1_2_11_HA,indic_ef:M_8_1_2_12_HA,indic_ef:M_8_1_2_13_HA,indic_ef:M_8_1_2_14_HA,indic_ef:M_8_1_2_15_HA,indic_ef:M_8_1_2_16_HA)) 
    _:ef_poirrig property:irrig irrig:TOTAL .
    _:ef_poirrig property:geo ?geo . 
    _:ef_poirrig sdmx-measure:obsValue ?ef_poirrig .
    }
   
  ?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 ?country ?ugeo ?indic_ef
HAVING sum(?ef_poirrig) != 0
}}
GROUP BY ?country ?ugeo
ORDER BY ?country


Related content

Temporal coverage

Document Actions