Potatoes - 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" "potatoes" "22170"^^<http://www.w3.org/2001/XMLSchema#decimal> "3220"^^<http://www.w3.org/2001/XMLSchema#decimal> "125395840"^^<http://www.w3.org/2001/XMLSchema#decimal> "69"^^<http://www.w3.org/2001/XMLSchema#decimal> "76"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "11038340"^^<http://www.w3.org/2001/XMLSchema#decimal> "90.789473684210526315"^^<http://www.w3.org/2001/XMLSchema#decimal> "10021650.8795669824081228552"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.08"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.51"^^<http://www.w3.org/2001/XMLSchema#decimal>
"BE" "potatoes" "81760"^^<http://www.w3.org/2001/XMLSchema#decimal> "2680"^^<http://www.w3.org/2001/XMLSchema#decimal> "86838741"^^<http://www.w3.org/2001/XMLSchema#decimal> "408"^^<http://www.w3.org/2001/XMLSchema#decimal> "453"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "14848826"^^<http://www.w3.org/2001/XMLSchema#decimal> "90.066225165562913907"^^<http://www.w3.org/2001/XMLSchema#decimal> "13373776.90802348336443771526"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.15"^^<http://www.w3.org/2001/XMLSchema#decimal> "6.49"^^<http://www.w3.org/2001/XMLSchema#decimal>
"BG" "potatoes" "13550"^^<http://www.w3.org/2001/XMLSchema#decimal> "5210"^^<http://www.w3.org/2001/XMLSchema#decimal> "29863648"^^<http://www.w3.org/2001/XMLSchema#decimal> "137"^^<http://www.w3.org/2001/XMLSchema#decimal> "61"^^<http://www.w3.org/2001/XMLSchema#decimal> "38.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "23454613"^^<http://www.w3.org/2001/XMLSchema#decimal> "224.590163934426229508"^^<http://www.w3.org/2001/XMLSchema#decimal> "52676752.76752767527645385977"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.76"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.57"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CZ" "potatoes" "25410"^^<http://www.w3.org/2001/XMLSchema#decimal> "3320"^^<http://www.w3.org/2001/XMLSchema#decimal> "3730881"^^<http://www.w3.org/2001/XMLSchema#decimal> "128"^^<http://www.w3.org/2001/XMLSchema#decimal> "93"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "12151122"^^<http://www.w3.org/2001/XMLSchema#decimal> "137.634408602150537634"^^<http://www.w3.org/2001/XMLSchema#decimal> "16724124.36048799685115035025"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.48"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.22"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DE" "potatoes" "254370"^^<http://www.w3.org/2001/XMLSchema#decimal> "81900"^^<http://www.w3.org/2001/XMLSchema#decimal> "2117916149"^^<http://www.w3.org/2001/XMLSchema#decimal> "1314"^^<http://www.w3.org/2001/XMLSchema#decimal> "1371"^^<http://www.w3.org/2001/XMLSchema#decimal> "32.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "441423517"^^<http://www.w3.org/2001/XMLSchema#decimal> "95.842450765864332603"^^<http://www.w3.org/2001/XMLSchema#decimal> "423071116.87699021110047622125"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.01"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DK" "potatoes" "38140"^^<http://www.w3.org/2001/XMLSchema#decimal> "27570"^^<http://www.w3.org/2001/XMLSchema#decimal> "276945445"^^<http://www.w3.org/2001/XMLSchema#decimal> "86"^^<http://www.w3.org/2001/XMLSchema#decimal> "117"^^<http://www.w3.org/2001/XMLSchema#decimal> "72.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "84574987"^^<http://www.w3.org/2001/XMLSchema#decimal> "73.504273504273504273"^^<http://www.w3.org/2001/XMLSchema#decimal> "62166229.68012585212247351074"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.22"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.45"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EL" "potatoes" "20630"^^<http://www.w3.org/2001/XMLSchema#decimal> "20050"^^<http://www.w3.org/2001/XMLSchema#decimal> "1516606776"^^<http://www.w3.org/2001/XMLSchema#decimal> "346"^^<http://www.w3.org/2001/XMLSchema#decimal> "318"^^<http://www.w3.org/2001/XMLSchema#decimal> "97.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "309059622"^^<http://www.w3.org/2001/XMLSchema#decimal> "108.805031446540880503"^^<http://www.w3.org/2001/XMLSchema#decimal> "336272418.80756180319647293262"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.22"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.51"^^<http://www.w3.org/2001/XMLSchema#decimal>
"ES" "potatoes" "61890"^^<http://www.w3.org/2001/XMLSchema#decimal> "38290"^^<http://www.w3.org/2001/XMLSchema#decimal> "928601920"^^<http://www.w3.org/2001/XMLSchema#decimal> "622"^^<http://www.w3.org/2001/XMLSchema#decimal> "585"^^<http://www.w3.org/2001/XMLSchema#decimal> "61.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "361926806"^^<http://www.w3.org/2001/XMLSchema#decimal> "106.324786324786324786"^^<http://www.w3.org/2001/XMLSchema#decimal> "384817902.73065115526974451122"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.41"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.41"^^<http://www.w3.org/2001/XMLSchema#decimal>
"FI" "potatoes" "25150"^^<http://www.w3.org/2001/XMLSchema#decimal> "3990"^^<http://www.w3.org/2001/XMLSchema#decimal> "4641846"^^<http://www.w3.org/2001/XMLSchema#decimal> "79"^^<http://www.w3.org/2001/XMLSchema#decimal> "95"^^<http://www.w3.org/2001/XMLSchema#decimal> "15.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "15071571"^^<http://www.w3.org/2001/XMLSchema#decimal> "83.157894736842105263"^^<http://www.w3.org/2001/XMLSchema#decimal> "12533200.79522862823009620278"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.37"^^<http://www.w3.org/2001/XMLSchema#decimal>
"FR" "potatoes" "161150"^^<http://www.w3.org/2001/XMLSchema#decimal> "62670"^^<http://www.w3.org/2001/XMLSchema#decimal> "2443740416"^^<http://www.w3.org/2001/XMLSchema#decimal> "1489"^^<http://www.w3.org/2001/XMLSchema#decimal> "1672"^^<http://www.w3.org/2001/XMLSchema#decimal> "38.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "650227986"^^<http://www.w3.org/2001/XMLSchema#decimal> "89.055023923444976076"^^<http://www.w3.org/2001/XMLSchema#decimal> "579060688.79925535214974107911"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.24"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.22"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 23 rows in 0.081 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/potatoes-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 qb: <http://purl.org/linked-data/cube#>
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
'potatoes' 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:05000 .
         _: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:05000 .
         _: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_3_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_5_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 'POTA' .
     _: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