Cereals - JRC WREI004

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

Download this dataset

Dataset preview

(Live Query)

ugeo crop ef_oluaareg ef_poirrig jrc_irrigation MIO_PPS PROD_PP ratio_of_irrigated_area economic_output ratio_pps economic_output_pps ecwp wui
"AT" "cereals" "612190"^^<http://www.w3.org/2001/XMLSchema#decimal> "860"^^<http://www.w3.org/2001/XMLSchema#decimal> "15269472"^^<http://www.w3.org/2001/XMLSchema#decimal> "711"^^<http://www.w3.org/2001/XMLSchema#decimal> "454"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.140479262973913327"^^<http://www.w3.org/2001/XMLSchema#decimal> "63777585.390156650458"^^<http://www.w3.org/2001/XMLSchema#decimal> "90.6887755102041"^^<http://www.w3.org/2001/XMLSchema#decimal> "57839111.240307892422972"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.04"^^<http://www.w3.org/2001/XMLSchema#decimal> "26.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"BE" "cereals" "276570"^^<http://www.w3.org/2001/XMLSchema#decimal> "2680"^^<http://www.w3.org/2001/XMLSchema#decimal> "8448000"^^<http://www.w3.org/2001/XMLSchema#decimal> "473"^^<http://www.w3.org/2001/XMLSchema#decimal> "460"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.969013269696640995"^^<http://www.w3.org/2001/XMLSchema#decimal> "445746104.0604548577"^^<http://www.w3.org/2001/XMLSchema#decimal> "90.2671755725191"^^<http://www.w3.org/2001/XMLSchema#decimal> "402362418.35991447544804"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.48"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"BG" "cereals" "1460470"^^<http://www.w3.org/2001/XMLSchema#decimal> "1220"^^<http://www.w3.org/2001/XMLSchema#decimal> "35763552"^^<http://www.w3.org/2001/XMLSchema#decimal> "1901"^^<http://www.w3.org/2001/XMLSchema#decimal> "548"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.083534752511177908"^^<http://www.w3.org/2001/XMLSchema#decimal> "45777044.376125493584"^^<http://www.w3.org/2001/XMLSchema#decimal> "225.5041518386714"^^<http://www.w3.org/2001/XMLSchema#decimal> "103229135.657194019949032"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "34.64"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DE" "cereals" "6128860"^^<http://www.w3.org/2001/XMLSchema#decimal> "100260"^^<http://www.w3.org/2001/XMLSchema#decimal> "318394250"^^<http://www.w3.org/2001/XMLSchema#decimal> "6172"^^<http://www.w3.org/2001/XMLSchema#decimal> "5737"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.635867029104923264"^^<http://www.w3.org/2001/XMLSchema#decimal> "9384969145.974944765568"^^<http://www.w3.org/2001/XMLSchema#decimal> "95.8385093167702"^^<http://www.w3.org/2001/XMLSchema#decimal> "8994414529.341206110537041"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.28"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.54"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DK" "cereals" "1460040"^^<http://www.w3.org/2001/XMLSchema#decimal> "153730"^^<http://www.w3.org/2001/XMLSchema#decimal> "6956411245"^^<http://www.w3.org/2001/XMLSchema#decimal> "1195"^^<http://www.w3.org/2001/XMLSchema#decimal> "1630"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.529163584559327141"^^<http://www.w3.org/2001/XMLSchema#decimal> "17162536642.83170323983"^^<http://www.w3.org/2001/XMLSchema#decimal> "73.3128834355828"^^<http://www.w3.org/2001/XMLSchema#decimal> "12582350483.54839214299611"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.02"^^<http://www.w3.org/2001/XMLSchema#decimal> "55.29"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EL" "cereals" "848770"^^<http://www.w3.org/2001/XMLSchema#decimal> "66530"^^<http://www.w3.org/2001/XMLSchema#decimal> "10300561728"^^<http://www.w3.org/2001/XMLSchema#decimal> "974"^^<http://www.w3.org/2001/XMLSchema#decimal> "403"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.838401451512188225"^^<http://www.w3.org/2001/XMLSchema#decimal> "3158875784.959411854675"^^<http://www.w3.org/2001/XMLSchema#decimal> "108.8268156424581"^^<http://www.w3.org/2001/XMLSchema#decimal> "3437703926.872030313585554"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "299.63"^^<http://www.w3.org/2001/XMLSchema#decimal>
"ES" "cereals" "5830960"^^<http://www.w3.org/2001/XMLSchema#decimal> "630350"^^<http://www.w3.org/2001/XMLSchema#decimal> "57306009216"^^<http://www.w3.org/2001/XMLSchema#decimal> "3867"^^<http://www.w3.org/2001/XMLSchema#decimal> "2685"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.810398287760505988"^^<http://www.w3.org/2001/XMLSchema#decimal> "29025919402.63695857778"^^<http://www.w3.org/2001/XMLSchema#decimal> "106.4116675839296"^^<http://www.w3.org/2001/XMLSchema#decimal> "30886964867.913364644855571"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "185.53"^^<http://www.w3.org/2001/XMLSchema#decimal>
"FI" "cereals" "1001670"^^<http://www.w3.org/2001/XMLSchema#decimal> "790"^^<http://www.w3.org/2001/XMLSchema#decimal> "20625"^^<http://www.w3.org/2001/XMLSchema#decimal> "391"^^<http://www.w3.org/2001/XMLSchema#decimal> "467"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.078868289955773857"^^<http://www.w3.org/2001/XMLSchema#decimal> "36831491.409346391219"^^<http://www.w3.org/2001/XMLSchema#decimal> "83.7259100642398"^^<http://www.w3.org/2001/XMLSchema#decimal> "30837501.372707567518649"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.95"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.07"^^<http://www.w3.org/2001/XMLSchema#decimal>
"FR" "cereals" "7589440"^^<http://www.w3.org/2001/XMLSchema#decimal> "252860"^^<http://www.w3.org/2001/XMLSchema#decimal> "9156082080"^^<http://www.w3.org/2001/XMLSchema#decimal> "10446"^^<http://www.w3.org/2001/XMLSchema#decimal> "9058"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.331734620736180798"^^<http://www.w3.org/2001/XMLSchema#decimal> "30178852194.628325668284"^^<http://www.w3.org/2001/XMLSchema#decimal> "89.0764901509337"^^<http://www.w3.org/2001/XMLSchema#decimal> "26882262302.812939285960164"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "34.06"^^<http://www.w3.org/2001/XMLSchema#decimal>
"HU" "cereals" "1337790"^^<http://www.w3.org/2001/XMLSchema#decimal> "13740"^^<http://www.w3.org/2001/XMLSchema#decimal> "404324847"^^<http://www.w3.org/2001/XMLSchema#decimal> "2798"^^<http://www.w3.org/2001/XMLSchema#decimal> "709"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.027067028457381203"^^<http://www.w3.org/2001/XMLSchema#decimal> "728190523.176283272927"^^<http://www.w3.org/2001/XMLSchema#decimal> "167.5449101796407"^^<http://www.w3.org/2001/XMLSchema#decimal> "1220046157.992359504138134"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "33.14"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 18 rows in 0.002 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/cereals-jrc-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 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 jrc_irrigation: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2014/jrc_irrigation.txt#>

SELECT
?ugeo
'cereals' as ?crop
?ef_oluaareg
?ef_poirrig
?jrc_irrigation
?MIO_PPS
?PROD_PP
?ratio_of_irrigated_area
?economic_output
?ratio_pps*100 as ?ratio_pps
(?economic_output * ?ratio_pps ) as ?economic_output_pps
round(((?economic_output * ?ratio_pps ) / ?jrc_irrigation))/100.0 as ?ecwp
round((?jrc_irrigation / (?economic_output * ?ratio_pps ))*10000)/100.0 as ?wui
{{
  SELECT 
  ?ugeo
  COALESCE((sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize)), 0) as ?ef_oluaareg
  sum(?ef_poirrig) as ?ef_poirrig
  (sum(?ef_poirrig)/ ( sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize) ) )*100 as ?ratio_of_irrigated_area
  sum(?jrc_irrigation) as ?jrc_irrigation
  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) )) 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)/COALESCE((sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize)), 0))*100 )*1000000) as ?economic_output
  {{
    SELECT
    ?ugeo
    sum(?ef_oluaareg) as ?ef_oluaareg
    sum(?ef_poirrig) as ?ef_poirrig
    sum(?jrc_irrigation) as ?jrc_irrigation
    COALESCE(sum(?ef_oluaareg_cereals),0) as ?ef_oluaareg_cereals
    COALESCE(sum(?ef_oluaareg_rice_maize),0) as ?ef_oluaareg_rice_maize
    COALESCE(sum(?PROD_PP_cereals ),0) as ?PROD_PP_cereals 
    COALESCE(sum(?PROD_PP_maize_rice),0) as ?PROD_PP_maize_rice
    COALESCE(sum(?MIO_PPS_cereals ),0) as ?MIO_PPS_cereals
    COALESCE(sum(?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_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://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:M_8_1_2_1_HA .
          _:ef_poirrig sdmx-measure:obsValue ?ef_poirrig .
        }
        } UNION {
         GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2014/jrc_irrigation.txt>  {  
         _:jrc_irrigation jrc_irrigation:DATE ?date .
         #_:jrc_irrigation jrc_irrigation:NUTS2_ID ?ugeo .
         _:jrc_irrigation jrc_irrigation:COUNTRY ?ugeo.
         _:jrc_irrigation jrc_irrigation:jrc_crop ?jrc_crop .
         FILTER (?jrc_crop in ('BARL', 'WHET', 'OCER'))
         _:jrc_irrigation jrc_irrigation:value ?jrc_irrigation .
        }
      }
    ?geo skos:notation ?ugeo .
    FILTER (year(?date) = 2010)
    }}
    GROUP BY str(?ugeo)
  }}
  HAVING ( sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize) ) > 0 and ( COALESCE(sum(?PROD_PP_cereals ),0)-COALESCE(sum(?MIO_PPS_maize_rice),0)) > 0
}}
HAVING sum(?ef_oluaareg) > 0 and sum(?PROD_PP) > 0 and ?jrc_irrigation > 0 and ?ratio_pps > 0 and ?economic_output > 0
ORDER BY ?ugeo


Related content

Document Actions