Cereals - FAO WREI004

Data table via SPARQL Published 23 Jul 2014 Last modified 01 Feb 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" "cereals" "860"^^<http://www.w3.org/2001/XMLSchema#decimal> "612190"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.14"^^<http://www.w3.org/2001/XMLSchema#decimal> "4853600000"^^<http://www.w3.org/2001/XMLSchema#decimal> "151360000"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "18316230"^^<http://www.w3.org/2001/XMLSchema#decimal> "90.70544712335757"^^<http://www.w3.org/2001/XMLSchema#decimal> "711.04"^^<http://www.w3.org/2001/XMLSchema#double> "453.65999999999997"^^<http://www.w3.org/2001/XMLSchema#double> "63729822.44074551992682"^^<http://www.w3.org/2001/XMLSchema#decimal> "5780642039.580009431031452"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "571193.4590407120483936"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.012"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.99"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.8963"^^<http://www.w3.org/2001/XMLSchema#decimal>
"BG" "cereals" "1220"^^<http://www.w3.org/2001/XMLSchema#decimal> "1460470"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.08"^^<http://www.w3.org/2001/XMLSchema#decimal> "19142240000"^^<http://www.w3.org/2001/XMLSchema#decimal> "214720000"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.92"^^<http://www.w3.org/2001/XMLSchema#decimal> "355609760"^^<http://www.w3.org/2001/XMLSchema#decimal> "225.5665503903562"^^<http://www.w3.org/2001/XMLSchema#decimal> "1901.12"^^<http://www.w3.org/2001/XMLSchema#double> "547.96"^^<http://www.w3.org/2001/XMLSchema#double> "45773702.98602504646768"^^<http://www.w3.org/2001/XMLSchema#decimal> "10325016281.150416702857654"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "3669790.2363476792678944"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2814"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.55"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.0172"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CH" "cereals" "1960"^^<http://www.w3.org/2001/XMLSchema#decimal> "134610"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.46"^^<http://www.w3.org/2001/XMLSchema#decimal> "4636670000"^^<http://www.w3.org/2001/XMLSchema#decimal> "334180000"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "589310780"^^<http://www.w3.org/2001/XMLSchema#decimal> "69.80261944290721"^^<http://www.w3.org/2001/XMLSchema#decimal> "189.2"^^<http://www.w3.org/2001/XMLSchema#double> "237.19"^^<http://www.w3.org/2001/XMLSchema#double> "345362454.49817992702453"^^<http://www.w3.org/2001/XMLSchema#decimal> "24107203981.204810800081893"^^<http://www.w3.org/2001/XMLSchema#decimal> "127.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "42473558.9249180985469848"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.0568"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.62"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.2983"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CY" "cereals" "1920"^^<http://www.w3.org/2001/XMLSchema#decimal> "33260"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "6833440000"^^<http://www.w3.org/2001/XMLSchema#decimal> "337920000"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "91509600"^^<http://www.w3.org/2001/XMLSchema#decimal> "112.7016129032258"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.18"^^<http://www.w3.org/2001/XMLSchema#double> "9.92"^^<http://www.w3.org/2001/XMLSchema#double> "57265183.40348767287328"^^<http://www.w3.org/2001/XMLSchema#decimal> "6453878532.772098246709204"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "4525235.3180828396798976"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1426"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.9022"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CZ" "cereals" "1530"^^<http://www.w3.org/2001/XMLSchema#decimal> "1350570"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.11"^^<http://www.w3.org/2001/XMLSchema#decimal> "2689560000"^^<http://www.w3.org/2001/XMLSchema#decimal> "260865000"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "11146900"^^<http://www.w3.org/2001/XMLSchema#decimal> "138.3087849852504"^^<http://www.w3.org/2001/XMLSchema#decimal> "1345.62"^^<http://www.w3.org/2001/XMLSchema#double> "863.49"^^<http://www.w3.org/2001/XMLSchema#double> "97820897.84313289884669"^^<http://www.w3.org/2001/XMLSchema#decimal> "13529489526.850012718186522"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "1081156.7946058091268705"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.2514"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.1052"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DE" "cereals" "100260"^^<http://www.w3.org/2001/XMLSchema#decimal> "6128860"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.64"^^<http://www.w3.org/2001/XMLSchema#decimal> "77196800000"^^<http://www.w3.org/2001/XMLSchema#decimal> "20402910000"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "293373760"^^<http://www.w3.org/2001/XMLSchema#decimal> "95.83322981366459"^^<http://www.w3.org/2001/XMLSchema#decimal> "6171.66"^^<http://www.w3.org/2001/XMLSchema#double> "5737.0"^^<http://www.w3.org/2001/XMLSchema#double> "9384969145.974944765568"^^<http://www.w3.org/2001/XMLSchema#decimal> "899391904960.368382303383042"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "77537908.5874233127495362"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.1599"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.86"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.8262"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DK" "cereals" "153730"^^<http://www.w3.org/2001/XMLSchema#decimal> "1460040"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.53"^^<http://www.w3.org/2001/XMLSchema#decimal> "61413275000"^^<http://www.w3.org/2001/XMLSchema#decimal> "29593025000"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "219246000"^^<http://www.w3.org/2001/XMLSchema#decimal> "73.2999104085615"^^<http://www.w3.org/2001/XMLSchema#decimal> "1194.51"^^<http://www.w3.org/2001/XMLSchema#double> "1629.62"^^<http://www.w3.org/2001/XMLSchema#double> "17158535560.66957069551642"^^<http://www.w3.org/2001/XMLSchema#decimal> "1257719119339.196098190491797"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "105647392.34554744056997025"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.1905"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.84"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.6157"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EL" "cereals" "66530"^^<http://www.w3.org/2001/XMLSchema#decimal> "848770"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.84"^^<http://www.w3.org/2001/XMLSchema#decimal> "151977720000"^^<http://www.w3.org/2001/XMLSchema#decimal> "8781960000"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "3896682810"^^<http://www.w3.org/2001/XMLSchema#decimal> "108.7667377684464"^^<http://www.w3.org/2001/XMLSchema#decimal> "973.93"^^<http://www.w3.org/2001/XMLSchema#double> "403.0299999999999"^^<http://www.w3.org/2001/XMLSchema#double> "3159110937.0029564364816"^^<http://www.w3.org/2001/XMLSchema#decimal> "343606190866.431557689800056"^^<http://www.w3.org/2001/XMLSchema#decimal> "25.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "225167956.0011006876321252"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1526"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.55"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.1276"^^<http://www.w3.org/2001/XMLSchema#decimal>
"ES" "cereals" "630350"^^<http://www.w3.org/2001/XMLSchema#decimal> "5830960"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.81"^^<http://www.w3.org/2001/XMLSchema#decimal> "627777760000"^^<http://www.w3.org/2001/XMLSchema#decimal> "110941600000"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.95"^^<http://www.w3.org/2001/XMLSchema#decimal> "16658537500"^^<http://www.w3.org/2001/XMLSchema#decimal> "106.402234329426"^^<http://www.w3.org/2001/XMLSchema#decimal> "3866.87"^^<http://www.w3.org/2001/XMLSchema#double> "2685.6"^^<http://www.w3.org/2001/XMLSchema#double> "29032405641.6096148813728"^^<http://www.w3.org/2001/XMLSchema#decimal> "3089112828225.495640150599899"^^<http://www.w3.org/2001/XMLSchema#decimal> "25.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "2796719915.204546270497712"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.1105"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.05"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.6331"^^<http://www.w3.org/2001/XMLSchema#decimal>
"FI" "cereals" "790"^^<http://www.w3.org/2001/XMLSchema#decimal> "1001670"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.08"^^<http://www.w3.org/2001/XMLSchema#decimal> "2221230000"^^<http://www.w3.org/2001/XMLSchema#decimal> "143385000"^^<http://www.w3.org/2001/XMLSchema#decimal> "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "4369230"^^<http://www.w3.org/2001/XMLSchema#decimal> "83.79421221864951"^^<http://www.w3.org/2001/XMLSchema#decimal> "390.9"^^<http://www.w3.org/2001/XMLSchema#double> "466.5"^^<http://www.w3.org/2001/XMLSchema#double> "36792057.2643685042905"^^<http://www.w3.org/2001/XMLSchema#decimal> "3082961454.371199787387181"^^<http://www.w3.org/2001/XMLSchema#decimal> "2"^^<http://www.w3.org/2001/XMLSchema#decimal> "282042.8517307978011567"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.0931"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.91"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.7666"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 20 rows in 0.071 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/cereals-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
'cereals' as ?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 * ?ratio_pps ) as ?economic_output_pps
#round((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)*1000)/100.0 as ?ratio_of_total_water
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(( ?economic_output * ?ratio_pps ) / ( sum(?water_consumption_crop)*((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)) ))/10000.0 as ?ecwp
round(( ( sum(?water_consumption_crop)*((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)) / ( ?economic_output * ?ratio_pps ) ))*1000000)/100.0 as ?cwi

round(( ( sum(?water_consumption_crop)*((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)) / ( ?economic_output ) ))*1000000)/10000.0 as ?euro_cwi

{{
  SELECT
  ?ugeo
  sum(?ef_poirrig_crop) as ?ef_poirrig_crop
  COALESCE((sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize)), 0) as ?ef_oluaareg
  ( sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize) ) as ?test
  round((sum(?ef_poirrig_crop)/ ( sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize) ) )*10000)/100.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
  xsd:decimal((COALESCE(sum(?MIO_PPS_cereals),0)-COALESCE(sum(?MIO_PPS_maize_rice),0) ) / ( COALESCE(sum(?PROD_PP_cereals ),0)-COALESCE(sum(?MIO_PPS_maize_rice),0) )*100) as ?ratio_pps
  (sum(?MIO_PPS_cereals)-sum(?MIO_PPS_maize_rice)) as ?MIO_PPS
  (sum(?PROD_PP_cereals)-sum(?PROD_PP_maize_rice)) as ?PROD_PP
  xsd:decimal((COALESCE(sum(?PROD_PP_cereals)-sum(?PROD_PP_maize_rice),0))*((sum(?ef_poirrig_crop)/COALESCE((sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize)), 0))*100 )*1000000) as ?economic_output
  {{
    SELECT DISTINCT
    ?ugeo
    COALESCE(sum(?ef_poirrig_crop), 0) as ?ef_poirrig_crop
    COALESCE(sum(?ef_poirrig)*sum(?value)*10, 0) as ?water_consumption
    COALESCE(sum(?ef_poirrig_crop)*sum(?value)*10, 0) as ?water_consumption_crop
    ?water_use_coefficient
    COALESCE(sum(?ef_oluaareg_cereals),0) as ?ef_oluaareg_cereals
    COALESCE(sum(?ef_oluaareg_rice_maize),0) as ?ef_oluaareg_rice_maize
    COALESCE(sum(?ef_poirrig_water_used),0) as ?ef_poirrig_water_used
    COALESCE(sum(xsd:double(?PROD_PP_cereals)),0) as ?PROD_PP_cereals 
    COALESCE(sum(xsd:double(?PROD_PP_maize_rice)),0) as ?PROD_PP_maize_rice
    COALESCE(sum(xsd:double(?MIO_PPS_cereals) ),0) as ?MIO_PPS_cereals
    COALESCE(sum(xsd:double(?MIO_PPS_maize_rice)),0) as ?MIO_PPS_maize_rice
    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 property:indic_ag indic_ag:PROD_PP .
          {
            _:aact_eaa01 sdmx-attribute:unitMeasure unit:MIO_EUR .
            {
              _:aact_eaa01 property:itm_newa ?itm_newa . 
              FILTER (?itm_newa in (itm_newa:01000)) .
              OPTIONAL { _:aact_eaa01 sdmx-measure:obsValue ?PROD_PP_cereals . }
            } UNION {
              _:aact_eaa01 property:itm_newa ?itm_newa . 
              FILTER (?itm_newa in (itm_newa:01500, itm_newa:01600)) .
              OPTIONAL { _:aact_eaa01 sdmx-measure:obsValue ?PROD_PP_maize_rice . }
            }
          } UNION {
            _:aact_eaa01 sdmx-attribute:unitMeasure unit:MIO_PPS .
            {
              _:aact_eaa01 property:itm_newa ?itm_newa . 
              FILTER (?itm_newa in (itm_newa:01000)) .
              OPTIONAL { _:aact_eaa01 sdmx-measure:obsValue ?MIO_PPS_cereals . }
            } UNION {
              _:aact_eaa01 property:itm_newa ?itm_newa . 
              FILTER (?itm_newa in (itm_newa:01500, itm_newa:01600)) .
              OPTIONAL { _:aact_eaa01 sdmx-measure:obsValue ?MIO_PPS_rice . }
            }
          }
        } 
       } 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_1_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:agrarea agrarea:TOTAL .
          {
            _:ef_oluaareg property:indic_ef ?indic_ef . 
            FILTER (?indic_ef in (indic_ef:B_1_1_HA))
            _:ef_oluaareg sdmx-measure:obsValue ?ef_oluaareg_cereals .
          } UNION {
            _:ef_oluaareg property:indic_ef ?indic_ef . 
            FILTER (?indic_ef in (indic_ef:B_1_1_6_HA, indic_ef:B_1_1_7_HA)) .
            _:ef_oluaareg sdmx-measure:obsValue ?ef_oluaareg_rice_maize .      
          }
        }
      } 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 (?geo in (geo:MT)) 
      FILTER (year(?date) in (2010)) 
    }}
    GROUP BY ?ugeo iri(?indic_ef) ?water_use_coefficient
  }}
  HAVING ( sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize) ) > 0
}}
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 and ?ratio_of_irrigated_area > 0
ORDER BY ?ugeo


Document Actions