Maize - 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" "maize" "284230"^^<http://www.w3.org/2001/XMLSchema#decimal> "5510"^^<http://www.w3.org/2001/XMLSchema#decimal> "3180000"^^<http://www.w3.org/2001/XMLSchema#decimal> "363"^^<http://www.w3.org/2001/XMLSchema#decimal> "400"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "7754284"^^<http://www.w3.org/2001/XMLSchema#decimal> "90.75"^^<http://www.w3.org/2001/XMLSchema#decimal> "7037012.27878830524409"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.21"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.45"^^<http://www.w3.org/2001/XMLSchema#decimal>
"BE" "maize" "238840"^^<http://www.w3.org/2001/XMLSchema#decimal> "6820"^^<http://www.w3.org/2001/XMLSchema#decimal> "293188830"^^<http://www.w3.org/2001/XMLSchema#decimal> "111"^^<http://www.w3.org/2001/XMLSchema#decimal> "123"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "3512226"^^<http://www.w3.org/2001/XMLSchema#decimal> "90.243902439024390243"^^<http://www.w3.org/2001/XMLSchema#decimal> "3169569.5863339474121683043"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"BG" "maize" "335670"^^<http://www.w3.org/2001/XMLSchema#decimal> "17240"^^<http://www.w3.org/2001/XMLSchema#decimal> "2298953920"^^<http://www.w3.org/2001/XMLSchema#decimal> "658"^^<http://www.w3.org/2001/XMLSchema#decimal> "292"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "14997110"^^<http://www.w3.org/2001/XMLSchema#decimal> "225.342465753424657534"^^<http://www.w3.org/2001/XMLSchema#decimal> "33794858.04510382220510302082"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "68.03"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CZ" "maize" "280790"^^<http://www.w3.org/2001/XMLSchema#decimal> "1310"^^<http://www.w3.org/2001/XMLSchema#decimal> "62000"^^<http://www.w3.org/2001/XMLSchema#decimal> "342"^^<http://www.w3.org/2001/XMLSchema#decimal> "247"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "1152356"^^<http://www.w3.org/2001/XMLSchema#decimal> "138.461538461538461538"^^<http://www.w3.org/2001/XMLSchema#decimal> "1595569.64279354677655468143"^^<http://www.w3.org/2001/XMLSchema#decimal> "25.68"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.04"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DE" "maize" "2295490"^^<http://www.w3.org/2001/XMLSchema#decimal> "49230"^^<http://www.w3.org/2001/XMLSchema#decimal> "2143269844"^^<http://www.w3.org/2001/XMLSchema#decimal> "3163"^^<http://www.w3.org/2001/XMLSchema#decimal> "3300"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "70773125"^^<http://www.w3.org/2001/XMLSchema#decimal> "95.848484848484848484"^^<http://www.w3.org/2001/XMLSchema#decimal> "67834967.69752863222464950076"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "31.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DK" "maize" "181300"^^<http://www.w3.org/2001/XMLSchema#decimal> "29590"^^<http://www.w3.org/2001/XMLSchema#decimal> "1617488180"^^<http://www.w3.org/2001/XMLSchema#decimal> "130"^^<http://www.w3.org/2001/XMLSchema#decimal> "177"^^<http://www.w3.org/2001/XMLSchema#decimal> "16.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "28888196"^^<http://www.w3.org/2001/XMLSchema#decimal> "73.446327683615819209"^^<http://www.w3.org/2001/XMLSchema#decimal> "21217319.36017650303358857528"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "76.23"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EL" "maize" "167590"^^<http://www.w3.org/2001/XMLSchema#decimal> "157080"^^<http://www.w3.org/2001/XMLSchema#decimal> "37512189480"^^<http://www.w3.org/2001/XMLSchema#decimal> "494"^^<http://www.w3.org/2001/XMLSchema#decimal> "454"^^<http://www.w3.org/2001/XMLSchema#decimal> "93.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "425528492"^^<http://www.w3.org/2001/XMLSchema#decimal> "108.810572687224669603"^^<http://www.w3.org/2001/XMLSchema#decimal> "463019989.25950235693638925592"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "81.02"^^<http://www.w3.org/2001/XMLSchema#decimal>
"ES" "maize" "442680"^^<http://www.w3.org/2001/XMLSchema#decimal> "313830"^^<http://www.w3.org/2001/XMLSchema#decimal> "47369515648"^^<http://www.w3.org/2001/XMLSchema#decimal> "939"^^<http://www.w3.org/2001/XMLSchema#decimal> "883"^^<http://www.w3.org/2001/XMLSchema#decimal> "70.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "625986921"^^<http://www.w3.org/2001/XMLSchema#decimal> "106.342015855039637599"^^<http://www.w3.org/2001/XMLSchema#decimal> "665687110.32800216860687158647"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "71.16"^^<http://www.w3.org/2001/XMLSchema#decimal>
"FR" "maize" "3003840"^^<http://www.w3.org/2001/XMLSchema#decimal> "749510"^^<http://www.w3.org/2001/XMLSchema#decimal> "81343739968"^^<http://www.w3.org/2001/XMLSchema#decimal> "3125"^^<http://www.w3.org/2001/XMLSchema#decimal> "3508"^^<http://www.w3.org/2001/XMLSchema#decimal> "25"^^<http://www.w3.org/2001/XMLSchema#decimal> "875306634"^^<http://www.w3.org/2001/XMLSchema#decimal> "89.08209806157354618"^^<http://www.w3.org/2001/XMLSchema#decimal> "779741514.1951635239986027032"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "104.32"^^<http://www.w3.org/2001/XMLSchema#decimal>
"HU" "maize" "1108180"^^<http://www.w3.org/2001/XMLSchema#decimal> "39560"^^<http://www.w3.org/2001/XMLSchema#decimal> "329071820"^^<http://www.w3.org/2001/XMLSchema#decimal> "1716"^^<http://www.w3.org/2001/XMLSchema#decimal> "1024"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "36554928"^^<http://www.w3.org/2001/XMLSchema#decimal> "167.578125"^^<http://www.w3.org/2001/XMLSchema#decimal> "61258062.76958616830868"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.19"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.37"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 17 rows in 0.159 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/maize-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
'maize' as ?crop
sum(?ef_oluaareg) as ?ef_oluaareg
sum(?ef_poirrig) as ?ef_poirrig
sum(?jrc_irrigation) as ?jrc_irrigation
sum(?MIO_PPS) as ?MIO_PPS
sum(?PROD_PP) as ?PROD_PP
round((sum(?ef_poirrig)/sum(?ef_oluaareg))*1000)/10.0 as ?ratio_of_irrigated_area
round(( (sum(?ef_poirrig)/sum(?ef_oluaareg))*sum(?PROD_PP) )*1000000) as ?economic_output
(sum(?MIO_PPS) / sum(?PROD_PP) )*100 as ?ratio_pps
(( (sum(?ef_poirrig)/sum(?ef_oluaareg))*sum(?PROD_PP) )*1000000 * (sum(?MIO_PPS) / sum(?PROD_PP) )) as ?economic_output_pps
round( ( ( (sum(?MIO_PPS) / sum(?PROD_PP) )*100 ) * round(( (sum(?ef_poirrig)/sum(?ef_oluaareg))*sum(?PROD_PP) )*100) ) / ( sum(?jrc_irrigation) )*10000)/100.0 as ?ecwp
round(( sum(?jrc_irrigation) / ( ( (sum(?MIO_PPS) / sum(?PROD_PP) )*100 ) * round(( (sum(?ef_poirrig)/sum(?ef_oluaareg))*sum(?PROD_PP) )*1000000) ) )*10000)/100.0 as ?wui

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)) .
         _: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)) 
         _:aact_eaa01 sdmx-measure:obsValue ?MIO_PPS . 
       }
     } 
  } 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://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_2_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 ('MAIF', 'MAIZ'))
     _:jrc_irrigation jrc_irrigation:value ?jrc_irrigation .
    }
  }
?geo skos:notation ?ugeo .
FILTER (year(?date) = 2010)
}}
GROUP BY str(?ugeo)
HAVING sum(?ef_oluaareg) > 0 and sum(?MIO_PPS) > 0 and sum(?PROD_PP) > 0 and sum(?ef_poirrig) > 0 and sum(?jrc_irrigation) > 0
ORDER BY ?ugeo


Related content

Document Actions