Sunflower - 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
"BG" "sunflower" "732500"^^<http://www.w3.org/2001/XMLSchema#decimal> "2790"^^<http://www.w3.org/2001/XMLSchema#decimal> "482457120"^^<http://www.w3.org/2001/XMLSchema#decimal> "933"^^<http://www.w3.org/2001/XMLSchema#decimal> "414"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "1576874"^^<http://www.w3.org/2001/XMLSchema#decimal> "225.362318840579710144"^^<http://www.w3.org/2001/XMLSchema#decimal> "3553679.18088737201239537392"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "135.76"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EL" "sunflower" "27770"^^<http://www.w3.org/2001/XMLSchema#decimal> "10430"^^<http://www.w3.org/2001/XMLSchema#decimal> "456581976"^^<http://www.w3.org/2001/XMLSchema#decimal> "68"^^<http://www.w3.org/2001/XMLSchema#decimal> "63"^^<http://www.w3.org/2001/XMLSchema#decimal> "37.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "23661865"^^<http://www.w3.org/2001/XMLSchema#decimal> "107.936507936507936507"^^<http://www.w3.org/2001/XMLSchema#decimal> "25539791.14151962549445840475"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.06"^^<http://www.w3.org/2001/XMLSchema#decimal> "17.88"^^<http://www.w3.org/2001/XMLSchema#decimal>
"ES" "sunflower" "781820"^^<http://www.w3.org/2001/XMLSchema#decimal> "78440"^^<http://www.w3.org/2001/XMLSchema#decimal> "13229203904"^^<http://www.w3.org/2001/XMLSchema#decimal> "333"^^<http://www.w3.org/2001/XMLSchema#decimal> "313"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "31403290"^^<http://www.w3.org/2001/XMLSchema#decimal> "106.389776357827476038"^^<http://www.w3.org/2001/XMLSchema#decimal> "33409889.7444424547818036502"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "395.97"^^<http://www.w3.org/2001/XMLSchema#decimal>
"FR" "sunflower" "691890"^^<http://www.w3.org/2001/XMLSchema#decimal> "26060"^^<http://www.w3.org/2001/XMLSchema#decimal> "1247651904"^^<http://www.w3.org/2001/XMLSchema#decimal> "615"^^<http://www.w3.org/2001/XMLSchema#decimal> "691"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "26026478"^^<http://www.w3.org/2001/XMLSchema#decimal> "89.001447178002894356"^^<http://www.w3.org/2001/XMLSchema#decimal> "23163942.2451545765944484934"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.02"^^<http://www.w3.org/2001/XMLSchema#decimal> "53.86"^^<http://www.w3.org/2001/XMLSchema#decimal>
"IT" "sunflower" "107940"^^<http://www.w3.org/2001/XMLSchema#decimal> "5130"^^<http://www.w3.org/2001/XMLSchema#decimal> "2590792941"^^<http://www.w3.org/2001/XMLSchema#decimal> "51"^^<http://www.w3.org/2001/XMLSchema#decimal> "52"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "2471373"^^<http://www.w3.org/2001/XMLSchema#decimal> "98.076923076923076923"^^<http://www.w3.org/2001/XMLSchema#decimal> "2423846.58143413007219809894"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "1068.88"^^<http://www.w3.org/2001/XMLSchema#decimal>
"PT" "sunflower" "21320"^^<http://www.w3.org/2001/XMLSchema#decimal> "4090"^^<http://www.w3.org/2001/XMLSchema#decimal> "86949590"^^<http://www.w3.org/2001/XMLSchema#decimal> "2"^^<http://www.w3.org/2001/XMLSchema#decimal> "2"^^<http://www.w3.org/2001/XMLSchema#decimal> "19.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "383677"^^<http://www.w3.org/2001/XMLSchema#decimal> "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "383677.2983114446529"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "226.62"^^<http://www.w3.org/2001/XMLSchema#decimal>
"RO" "sunflower" "758820"^^<http://www.w3.org/2001/XMLSchema#decimal> "10400"^^<http://www.w3.org/2001/XMLSchema#decimal> "4790750688"^^<http://www.w3.org/2001/XMLSchema#decimal> "738"^^<http://www.w3.org/2001/XMLSchema#decimal> "366"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "5016209"^^<http://www.w3.org/2001/XMLSchema#decimal> "201.639344262295081967"^^<http://www.w3.org/2001/XMLSchema#decimal> "10114651.69605440025280930971"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "473.64"^^<http://www.w3.org/2001/XMLSchema#decimal>
"SK" "sunflower" "88720"^^<http://www.w3.org/2001/XMLSchema#decimal> "150"^^<http://www.w3.org/2001/XMLSchema#decimal> "671879492"^^<http://www.w3.org/2001/XMLSchema#decimal> "85"^^<http://www.w3.org/2001/XMLSchema#decimal> "57"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "96371"^^<http://www.w3.org/2001/XMLSchema#decimal> "149.122807017543859649"^^<http://www.w3.org/2001/XMLSchema#decimal> "143710.55004508566254988165"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "4675.21"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 8 rows in 0.054 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/sunflower-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
'sunflower' 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:02120 .
              _: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:02120 .
              _: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_6_5_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_8_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 'SUNF' .
          _: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