next
previous
items

Data table via SPARQL

Sugarbeet - JRC WREI004

Data table via SPARQL Published 25 Jul 2014 Last modified 02 Feb 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" "sugarbeet" "44760"^^<http://www.w3.org/2001/XMLSchema#decimal> "4750"^^<http://www.w3.org/2001/XMLSchema#decimal> "757931040"^^<http://www.w3.org/2001/XMLSchema#decimal> "82"^^<http://www.w3.org/2001/XMLSchema#decimal> "90"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "9550938"^^<http://www.w3.org/2001/XMLSchema#decimal> "91.111111111111111111"^^<http://www.w3.org/2001/XMLSchema#decimal> "8701966.04110813226030938784"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "87.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"BE" "sugarbeet" "59300"^^<http://www.w3.org/2001/XMLSchema#decimal> "170"^^<http://www.w3.org/2001/XMLSchema#decimal> "30373827"^^<http://www.w3.org/2001/XMLSchema#decimal> "114"^^<http://www.w3.org/2001/XMLSchema#decimal> "126"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "361214"^^<http://www.w3.org/2001/XMLSchema#decimal> "90.47619047619047619"^^<http://www.w3.org/2001/XMLSchema#decimal> "326812.81618887015143827993"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.94"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CZ" "sugarbeet" "56370"^^<http://www.w3.org/2001/XMLSchema#decimal> "1090"^^<http://www.w3.org/2001/XMLSchema#decimal> "11284372"^^<http://www.w3.org/2001/XMLSchema#decimal> "118"^^<http://www.w3.org/2001/XMLSchema#decimal> "85"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "1643605"^^<http://www.w3.org/2001/XMLSchema#decimal> "138.823529411764705882"^^<http://www.w3.org/2001/XMLSchema#decimal> "2281710.12950150789391419904"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.95"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DE" "sugarbeet" "364120"^^<http://www.w3.org/2001/XMLSchema#decimal> "34830"^^<http://www.w3.org/2001/XMLSchema#decimal> "8965198679"^^<http://www.w3.org/2001/XMLSchema#decimal> "565"^^<http://www.w3.org/2001/XMLSchema#decimal> "590"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "56436614"^^<http://www.w3.org/2001/XMLSchema#decimal> "95.762711864406779661"^^<http://www.w3.org/2001/XMLSchema#decimal> "54045232.34098648796899043447"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "165.88"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DK" "sugarbeet" "39070"^^<http://www.w3.org/2001/XMLSchema#decimal> "60"^^<http://www.w3.org/2001/XMLSchema#decimal> "857500"^^<http://www.w3.org/2001/XMLSchema#decimal> "73"^^<http://www.w3.org/2001/XMLSchema#decimal> "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "153571"^^<http://www.w3.org/2001/XMLSchema#decimal> "73"^^<http://www.w3.org/2001/XMLSchema#decimal> "112106.47555669311485"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.13"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.65"^^<http://www.w3.org/2001/XMLSchema#decimal>
"ES" "sugarbeet" "48580"^^<http://www.w3.org/2001/XMLSchema#decimal> "42260"^^<http://www.w3.org/2001/XMLSchema#decimal> "1203000160"^^<http://www.w3.org/2001/XMLSchema#decimal> "126"^^<http://www.w3.org/2001/XMLSchema#decimal> "118"^^<http://www.w3.org/2001/XMLSchema#decimal> "87"^^<http://www.w3.org/2001/XMLSchema#decimal> "102648827"^^<http://www.w3.org/2001/XMLSchema#decimal> "106.779661016949152542"^^<http://www.w3.org/2001/XMLSchema#decimal> "109608069.16426512968259724166"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.09"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.98"^^<http://www.w3.org/2001/XMLSchema#decimal>
"FI" "sugarbeet" "14620"^^<http://www.w3.org/2001/XMLSchema#decimal> "320"^^<http://www.w3.org/2001/XMLSchema#decimal> "46067505"^^<http://www.w3.org/2001/XMLSchema#decimal> "14"^^<http://www.w3.org/2001/XMLSchema#decimal> "17"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "372093"^^<http://www.w3.org/2001/XMLSchema#decimal> "82.352941176470588235"^^<http://www.w3.org/2001/XMLSchema#decimal> "306429.5485636114910589056"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "150.34"^^<http://www.w3.org/2001/XMLSchema#decimal>
"FR" "sugarbeet" "383590"^^<http://www.w3.org/2001/XMLSchema#decimal> "40970"^^<http://www.w3.org/2001/XMLSchema#decimal> "2667888992"^^<http://www.w3.org/2001/XMLSchema#decimal> "739"^^<http://www.w3.org/2001/XMLSchema#decimal> "830"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "88649600"^^<http://www.w3.org/2001/XMLSchema#decimal> "89.036144578313253012"^^<http://www.w3.org/2001/XMLSchema#decimal> "78930185.8755442008370072773"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "33.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"HU" "sugarbeet" "15510"^^<http://www.w3.org/2001/XMLSchema#decimal> "860"^^<http://www.w3.org/2001/XMLSchema#decimal> "2119625"^^<http://www.w3.org/2001/XMLSchema#decimal> "41"^^<http://www.w3.org/2001/XMLSchema#decimal> "24"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "1330754"^^<http://www.w3.org/2001/XMLSchema#decimal> "170.833333333333333333"^^<http://www.w3.org/2001/XMLSchema#decimal> "2273372.01805286911664556415"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.07"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.93"^^<http://www.w3.org/2001/XMLSchema#decimal>
"IT" "sugarbeet" "58650"^^<http://www.w3.org/2001/XMLSchema#decimal> "24530"^^<http://www.w3.org/2001/XMLSchema#decimal> "1165270227"^^<http://www.w3.org/2001/XMLSchema#decimal> "133"^^<http://www.w3.org/2001/XMLSchema#decimal> "136"^^<http://www.w3.org/2001/XMLSchema#decimal> "41.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "56881159"^^<http://www.w3.org/2001/XMLSchema#decimal> "97.794117647058823529"^^<http://www.w3.org/2001/XMLSchema#decimal> "55626427.96248934356321578346"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.05"^^<http://www.w3.org/2001/XMLSchema#decimal> "20.95"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 16 rows in 0.033 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/sugarbeet-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
'sugarbeet' 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:02400 .
         _: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:02400 .
         _: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:B_1_4_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_6_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 'SUGB' .
     _: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


Permalinks

Document Actions