Maize - FAO WREI004

Data table via SPARQL Published 23 Jul 2014 Last modified 29 Jan 2016

Download this dataset

Dataset preview

(Live Query)

ugeo crop ef_poirrig_crop ef_oluaareg ratio_of_irrigated_area water_consumption water_consumption_crop water_use_coefficient ef_poirrig_water_used ratio_pps MIO_PPS PROD_PP economic_output economic_output_pps ratio_of_total_water water_use_for_irigation_per_crop ecwp cwi euro_cwi
"AT" "maize" "5510.0"^^<http://www.w3.org/2001/XMLSchema#double> "284230.0"^^<http://www.w3.org/2001/XMLSchema#double> "1.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "4853600000"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.14608E9"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.831623E7"^^<http://www.w3.org/2001/XMLSchema#double> "90.70378151260505"^^<http://www.w3.org/2001/XMLSchema#double> "362.67"^^<http://www.w3.org/2001/XMLSchema#double> "399.84000000000003"^^<http://www.w3.org/2001/XMLSchema#double> "7.751181789395913E8"^^<http://www.w3.org/2001/XMLSchema#double> "7030614.994898499"^^<http://www.w3.org/2001/XMLSchema#double> "3.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "4325009.2464150321381008"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.626"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.615"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.558"^^<http://www.w3.org/2001/XMLSchema#decimal>
"BG" "maize" "17240.0"^^<http://www.w3.org/2001/XMLSchema#double> "335670.0"^^<http://www.w3.org/2001/XMLSchema#double> "5.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "19142240000"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.58592E9"^^<http://www.w3.org/2001/XMLSchema#double> "0.92"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.5560976E8"^^<http://www.w3.org/2001/XMLSchema#double> "225.56553331505347"^^<http://www.w3.org/2001/XMLSchema#double> "658.11"^^<http://www.w3.org/2001/XMLSchema#double> "291.76"^^<http://www.w3.org/2001/XMLSchema#double> "1.498478386510561E9"^^<http://www.w3.org/2001/XMLSchema#double> "3.380050764143355E7"^^<http://www.w3.org/2001/XMLSchema#double> "17.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "61287137.6877974573413184"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.552"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.813"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.09"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CH" "maize" "2030.0"^^<http://www.w3.org/2001/XMLSchema#double> "63660.0"^^<http://www.w3.org/2001/XMLSchema#double> "3.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "4636670000"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.09045E8"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.8931078E8"^^<http://www.w3.org/2001/XMLSchema#double> "69.79575490588707"^^<http://www.w3.org/2001/XMLSchema#double> "87.14"^^<http://www.w3.org/2001/XMLSchema#double> "124.85"^^<http://www.w3.org/2001/XMLSchema#double> "3.981236255105247E8"^^<http://www.w3.org/2001/XMLSchema#double> "2778733.8988375748"^^<http://www.w3.org/2001/XMLSchema#double> "127.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "51988739.3334224777669262"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.053"^^<http://www.w3.org/2001/XMLSchema#decimal> "18.71"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.058"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CZ" "maize" "1310.0"^^<http://www.w3.org/2001/XMLSchema#double> "280790.0"^^<http://www.w3.org/2001/XMLSchema#double> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "2689560000"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.63965E8"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.11469E7"^^<http://www.w3.org/2001/XMLSchema#double> "138.30777323675798"^^<http://www.w3.org/2001/XMLSchema#double> "341.8"^^<http://www.w3.org/2001/XMLSchema#double> "247.13"^^<http://www.w3.org/2001/XMLSchema#double> "1.1529623562092666E8"^^<http://www.w3.org/2001/XMLSchema#double> "1594636.5611310943"^^<http://www.w3.org/2001/XMLSchema#double> "4.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "1094004.7660212079281405"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.458"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.686"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.949"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DE" "maize" "49230.0"^^<http://www.w3.org/2001/XMLSchema#double> "2295490.0"^^<http://www.w3.org/2001/XMLSchema#double> "2.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "77196800000"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.1839815E10"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.9337376E8"^^<http://www.w3.org/2001/XMLSchema#double> "95.83333333333334"^^<http://www.w3.org/2001/XMLSchema#double> "3162.5"^^<http://www.w3.org/2001/XMLSchema#double> "3300.0"^^<http://www.w3.org/2001/XMLSchema#double> "7.077312469233149E9"^^<http://www.w3.org/2001/XMLSchema#double> "6.782424449681768E7"^^<http://www.w3.org/2001/XMLSchema#double> "3.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "44995272.3980061348916233"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.507"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.663"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.636"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DK" "maize" "29590.0"^^<http://www.w3.org/2001/XMLSchema#double> "181300.0"^^<http://www.w3.org/2001/XMLSchema#double> "16.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "61413275000"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.731725E9"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.19246E8"^^<http://www.w3.org/2001/XMLSchema#double> "73.29834067050457"^^<http://www.w3.org/2001/XMLSchema#double> "129.87"^^<http://www.w3.org/2001/XMLSchema#double> "177.18"^^<http://www.w3.org/2001/XMLSchema#double> "2.8917574186431336E9"^^<http://www.w3.org/2001/XMLSchema#double> "2.1196102040816333E7"^^<http://www.w3.org/2001/XMLSchema#double> "3.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "24032324.92242108890087725"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.882"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.134"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.831"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EL" "maize" "157080.0"^^<http://www.w3.org/2001/XMLSchema#double> "167590.0"^^<http://www.w3.org/2001/XMLSchema#double> "93.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "151977720000"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.450448E10"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.89668281E9"^^<http://www.w3.org/2001/XMLSchema#double> "108.76779339826363"^^<http://www.w3.org/2001/XMLSchema#double> "493.61"^^<http://www.w3.org/2001/XMLSchema#double> "453.82"^^<http://www.w3.org/2001/XMLSchema#double> "4.253597804164926E10"^^<http://www.w3.org/2001/XMLSchema#double> "4.6265444716271853E8"^^<http://www.w3.org/2001/XMLSchema#double> "25.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "628290686.1873490403130576"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.736"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.358"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.477"^^<http://www.w3.org/2001/XMLSchema#decimal>
"ES" "maize" "313830.0"^^<http://www.w3.org/2001/XMLSchema#double> "442680.0"^^<http://www.w3.org/2001/XMLSchema#double> "70.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "627777760000"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.527664E10"^^<http://www.w3.org/2001/XMLSchema#double> "0.95"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.66585375E10"^^<http://www.w3.org/2001/XMLSchema#double> "106.40139584419114"^^<http://www.w3.org/2001/XMLSchema#double> "939.12"^^<http://www.w3.org/2001/XMLSchema#double> "882.62"^^<http://www.w3.org/2001/XMLSchema#double> "6.257175264299268E10"^^<http://www.w3.org/2001/XMLSchema#double> "6.657721821631877E8"^^<http://www.w3.org/2001/XMLSchema#double> "25.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "1645554770.1280465872370848"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.405"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.472"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.63"^^<http://www.w3.org/2001/XMLSchema#decimal>
"FR" "maize" "749510.0"^^<http://www.w3.org/2001/XMLSchema#double> "3003840.0"^^<http://www.w3.org/2001/XMLSchema#double> "25"^^<http://www.w3.org/2001/XMLSchema#decimal> "301540800000"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.5589808E11"^^<http://www.w3.org/2001/XMLSchema#double> "0.97"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.71148065E9"^^<http://www.w3.org/2001/XMLSchema#double> "89.07896237172177"^^<http://www.w3.org/2001/XMLSchema#double> "3124.89"^^<http://www.w3.org/2001/XMLSchema#double> "3508.0"^^<http://www.w3.org/2001/XMLSchema#double> "8.753066341749228E10"^^<http://www.w3.org/2001/XMLSchema#double> "7.797140672938639E8"^^<http://www.w3.org/2001/XMLSchema#double> "8.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "1359793396.029285058450856"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.573"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.744"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.554"^^<http://www.w3.org/2001/XMLSchema#decimal>
"HR" "maize" "1570.0"^^<http://www.w3.org/2001/XMLSchema#double> "337500.0"^^<http://www.w3.org/2001/XMLSchema#double> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "2937940000"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.4697E8"^^<http://www.w3.org/2001/XMLSchema#double> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.028117E7"^^<http://www.w3.org/2001/XMLSchema#double> "142.1264336576616"^^<http://www.w3.org/2001/XMLSchema#double> "522.94"^^<http://www.w3.org/2001/XMLSchema#double> "367.94"^^<http://www.w3.org/2001/XMLSchema#double> "1.7116023703703704E8"^^<http://www.w3.org/2001/XMLSchema#double> "2432639.407407408"^^<http://www.w3.org/2001/XMLSchema#double> "10.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "3576198.8178451568077694"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.68"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.47"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.089"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 18 rows in 0.002 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/maize-fao-wrei004/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



http://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 sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#>
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>  
PREFIX nutrient: <http://rdfdata.eionet.europa.eu/eurostat/dic/nutrient#> 
PREFIX indic_ag: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_ag/> 
PREFIX itm_newa: <http://dd.eionet.europa.eu/vocabulary/eurostat/itm_newa/> 
PREFIX indic_ef: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_ef/> 
PREFIX irrig: <http://dd.eionet.europa.eu/vocabulary/eurostat/irrig/> 
PREFIX agrarea: <http://dd.eionet.europa.eu/vocabulary/eurostat/agrarea/> 
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/> 
PREFIX tableFile: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/irrigation_water_use_coefficient_2010.txt#> 
PREFIX fao_irrigation: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2014/fao_irrigation.txt#>

SELECT
?ugeo
'maize' as ?crop
sum(?ef_poirrig_crop) as ?ef_poirrig_crop
sum(?ef_oluaareg) as ?ef_oluaareg
bif:either(sum(?ef_poirrig_crop)/sum(?ef_oluaareg) > 1, 100, round((sum(?ef_poirrig_crop)/sum(?ef_oluaareg))*1000)/10.0) as ?ratio_of_irrigated_area 
sum(?water_consumption) as ?water_consumption
sum(?water_consumption_crop) as ?water_consumption_crop
?water_use_coefficient
sum(?ef_poirrig_water_used) as ?ef_poirrig_water_used
(sum(?MIO_PPS) / sum(?PROD_PP) )*100 as ?ratio_pps
sum(?MIO_PPS) as ?MIO_PPS
sum(?PROD_PP) as ?PROD_PP
sum(?PROD_PP)* ((sum(?ef_poirrig_crop)/sum(?ef_oluaareg))*100 )*1000000 as ?economic_output
( sum(?PROD_PP)* ((sum(?ef_poirrig_crop)/sum(?ef_oluaareg))*100 )*1000000 ) * ( (sum(?MIO_PPS) / sum(?PROD_PP) )*100 )/10000 as ?economic_output_pps
round((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)*10000)/10.0 as ?ratio_of_total_water
sum(?water_consumption_crop)*((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)) as ?water_use_for_irigation_per_crop
round(( ( sum(?PROD_PP)* ((sum(?ef_poirrig_crop)/sum(?ef_oluaareg))*100 )*1000000 ) * ( (sum(?MIO_PPS) / sum(?PROD_PP) )*100 )/10000 ) / ( sum(?water_consumption_crop)*((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)) )*1000)/1000.0 as ?ecwp
round(( round( ( sum(?water_consumption_crop)*((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)))) / round( ( sum(?PROD_PP)* ( IF(sum(?ef_poirrig_crop)/sum(?ef_oluaareg) > 1, 1, sum(?ef_poirrig_crop)/sum(?ef_oluaareg))  *100 )*1000000 ) * ( (sum(?MIO_PPS) / sum(?PROD_PP) )*100 )/10000 ) )*1000)/1000.0 as ?cwi
round(( round( ( sum(?water_consumption_crop)*((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)))) / round( ( sum(?PROD_PP)* ( IF(sum(?ef_poirrig_crop)/sum(?ef_oluaareg) > 1, 1, sum(?ef_poirrig_crop)/sum(?ef_oluaareg))  *100 )*1000000 )  ) )*100000)/1000.0 as ?euro_cwi

{{
  SELECT DISTINCT
  ?ugeo
  COALESCE(sum(xsd:double(?ef_poirrig_crop)), 0) as ?ef_poirrig_crop
  COALESCE(sum(xsd:double(?ef_poirrig))*sum(?value)*10, 0) as ?water_consumption
  COALESCE(sum(xsd:double(?ef_poirrig_crop))*sum(xsd:double(?value))*10, 0) as ?water_consumption_crop
  ?water_use_coefficient
  COALESCE(sum(xsd:double(?ef_oluaareg)), 0) as ?ef_oluaareg
  COALESCE(sum(xsd:double(?ef_poirrig_water_used)),0) as ?ef_poirrig_water_used
  COALESCE(sum(xsd:double(?PROD_PP)),0) as ?PROD_PP
  COALESCE(sum(xsd:double(?MIO_PPS)),0) as ?MIO_PPS
  WHERE {{ 
      {
        GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/aact_eaa01.rdf.gz>  { 
          _:aact_eaa01 sdmx-dimension:timePeriod ?date .
          _:aact_eaa01 sdmx-dimension:refArea ?geo . 
          {
            _:aact_eaa01 sdmx-attribute:unitMeasure unit:MIO_EUR .
            _:aact_eaa01 property:indic_ag indic_ag:PROD_PP .
            _:aact_eaa01 property:itm_newa ?itm_newa . 
            FILTER (?itm_newa in (itm_newa:01500, itm_newa:03100)) .
            OPTIONAL { _:aact_eaa01 sdmx-measure:obsValue ?PROD_PP . }
          } UNION {
            _:aact_eaa01 sdmx-attribute:unitMeasure unit:MIO_PPS .
            _:aact_eaa01 property:indic_ag indic_ag:PROD_PP .
            _:aact_eaa01 property:itm_newa ?itm_newa . 
            FILTER (?itm_newa in (itm_newa:01500, itm_newa:03100)) .
            OPTIONAL { _:aact_eaa01 sdmx-measure:obsValue ?MIO_PPS . }
          }
      } 
     } UNION {
       GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/ef_poirrig.rdf.gz>  {  
          _:ef_poirrig sdmx-dimension:timePeriod ?date .
          _:ef_poirrig sdmx-dimension:refArea ?geo .
          _:ef_poirrig property:irrig irrig:TOTAL .
          {
            _:ef_poirrig property:indic_ef ?indic_ef . 
            FILTER (?indic_ef = indic_ef:M_8_1_2_2_HA) .
            _:ef_poirrig sdmx-measure:obsValue ?ef_poirrig_crop .      
          } UNION {
            _: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 sdmx-measure:obsValue ?ef_poirrig .
          } UNION {
            _:ef_poirrig property:indic_ef ?indic_ef . 
            FILTER (?indic_ef in (indic_ef:M_8_4_M3))
            _:ef_poirrig sdmx-measure:obsValue ?ef_poirrig_water_used .
          }
        }
    } UNION {
      GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/ef_oluaareg.rdf.gz>  {  
        _:ef_oluaareg sdmx-dimension:timePeriod ?date .
        _:ef_oluaareg sdmx-dimension:refArea ?geo .
        _:ef_oluaareg property:indic_ef ?indic_ef . 
        FILTER (?indic_ef in (indic_ef:B_1_1_6_HA, indic_ef:B_1_9_2_1_HA))
        _:ef_oluaareg property:agrarea agrarea:TOTAL .
        _:ef_oluaareg sdmx-measure:obsValue ?ef_oluaareg .
      }
    } UNION {
      GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2014/fao_irrigation.txt>  {  
        _:fao_irrigation fao_irrigation:date ?date .
        _:fao_irrigation fao_irrigation:crop ?crop .
        _:fao_irrigation fao_irrigation:estat_crop ?estat_crop .
        _:fao_irrigation fao_irrigation:indic_ef ?indic_ef .
        _:fao_irrigation fao_irrigation:value ?value .
      }
    }
    ?fao_geo tableFile:geo ?ugeo .
    ?fao_geo tableFile:irrigation_water_use_coefficient ?water_use_coefficient .
    ?geo skos:notation ?ugeo .  
    FILTER (year(?date) in (2010)) 
  }}
  GROUP BY ?ugeo iri(?indic_ef) ?water_use_coefficient
}}
HAVING sum(?ef_oluaareg) > 0 and sum(?PROD_PP) > 0 and sum(?water_consumption) > 0 and sum(?water_consumption_crop) > 0 and sum(?water_consumption) > 0 and sum(?ef_poirrig_water_used) > 0
ORDER BY ?ugeo


Document Actions