Economic profit rom crops vs water input

Data table via SPARQL Published 22 Jun 2017 Last modified 05 Dec 2017
38 min read
Topics: ,

Download this dataset

Dataset preview

(Live Query)

timePeriod refArea date ugeo region profit water share_irrigated_area
"2010"^^<http://www.w3.org/2001/XMLSchema#int> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AT> "2010"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "Western" "831.95"^^<http://www.w3.org/2001/XMLSchema#decimal> "5140.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.89"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE> "2005"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "Western" "2911.83"^^<http://www.w3.org/2001/XMLSchema#decimal> "4824.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.64"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE> "2007"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "Western" "2786.52"^^<http://www.w3.org/2001/XMLSchema#decimal> "4698.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.91"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE> "2010"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "Western" "2556.15"^^<http://www.w3.org/2001/XMLSchema#decimal> "4615.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.74"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE> "2013"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "Western" "2603.03"^^<http://www.w3.org/2001/XMLSchema#decimal> "4831.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BG> "2007"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "Eastern" "382.89"^^<http://www.w3.org/2001/XMLSchema#decimal> "5703.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.27"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BG> "2010"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "Eastern" "672.26"^^<http://www.w3.org/2001/XMLSchema#decimal> "6182.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.75"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BG> "2013"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "Eastern" "529.66"^^<http://www.w3.org/2001/XMLSchema#decimal> "5726.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.77"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/HR> "2013"^^<http://www.w3.org/2001/XMLSchema#int> "Croatia" "Eastern" "1441.21"^^<http://www.w3.org/2001/XMLSchema#decimal> "4787.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.47"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/CY> "2005"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "Southern" "1672.54"^^<http://www.w3.org/2001/XMLSchema#decimal> "7311.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "20.36"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 90 rows in 0.008 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/economic-profit-rom-crops-vs/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 skos: <http://www.w3.org/2004/02/skos/core#>
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 wat_proc: <http://dd.eionet.europa.eu/vocabulary/eurostat/wat_proc/>
PREFIX wat_src: <http://dd.eionet.europa.eu/vocabulary/eurostat/wat_src/>
PREFIX countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>
PREFIX crops: <http://dd.eionet.europa.eu/vocabulary/eurostat/crops/>
PREFIX strucpro: <http://dd.eionet.europa.eu/vocabulary/eurostat/strucpro/>
PREFIX swbewa2017: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2017/swbewa2017.tsv#>
PREFIX fadn2017: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2017/fadn2017.tsv#>
PREFIX env_wat_abs_abs_nace_A011_A013: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2017/env_wat_abs_abs_nace_A011_A013.tsv#>

SELECT DISTINCT
year(?date) as ?timePeriod
?geo as ?refArea
year(?date) as ?date
?ugeo
 
bif:either(?geo in (geo:AL, geo:CY, geo:EL, geo:ES, geo:IT, geo:ME, geo:MT, geo:PT, geo:TR), 'Southern',
bif:either(?geo in (geo:AT, geo:BE, geo:CH, geo:DE, geo:DK, geo:FR, geo:IE, geo:LI, geo:LU, geo:NL, geo:UK, geo:SE, geo:FI, geo:IS, geo:NO), 'Western',
'Eastern')) as ?region

round(( ( sum(?10000_PPS) - (sum(?19010_PPS) + sum(?19040_PPS) + (sum(?19020_PPS) * (sum(?10000_PPS)/sum(?16000_PPS)))  + (sum(?19030_PPS) * (sum(?10000_PPS)/(sum(?10000_PPS)+sum(?13000_PPS))))) ) * (1.0-sum(xsd:double(?fadn2017))) / sum(xsd:double(?AGRAREA_HA)))*100000.0)/100.0 as ?profit

round(( sum(xsd:double(?abs_nace_A011_A013)) + sum(coalesce(?env_wat_use,0)) + sum(xsd:double(?swbewa2017)) ) / sum(xsd:double(?AGRAREA_HA))*10000.0)/10.0 as ?water




round(sum(?ef_poirrig) / sum(xsd:double(?AGRAREA_HA))/1000.0 *10000)/100.0 as ?share_irrigated_area

WHERE {{ 
  {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wat_abs.rdf.gz>  { 
      _:env_wat_abs sdmx-dimension:timePeriod ?date . 
      _:env_wat_abs sdmx-dimension:refArea ?geo . 
      _:env_wat_abs sdmx-attribute:unitMeasure unit:MIO_M3 . 
      _:env_wat_abs property:wat_src wat_src:FRW . 
      _:env_wat_abs property:wat_proc wat_proc:ABS_AGR_IR . 
      _:env_wat_abs sdmx-measure:obsValue ?env_wat_abs .
    }
  } UNION {
    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2017/env_wat_abs_abs_nace_A011_A013.tsv>  
    {  
      _:abs_nace_A011_A013 env_wat_abs_abs_nace_A011_A013:geo ?geo .
      _:abs_nace_A011_A013 env_wat_abs_abs_nace_A011_A013:date ?date .
      _:abs_nace_A011_A013 env_wat_abs_abs_nace_A011_A013:obsValue ?abs_nace_A011_A013 .
    }
  } 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 .
      FILTER (?indic_ef IN (indic_ef:B_6_2_2_HA, indic_ef:B_4_7_7_2_8_2_HA))
      _:ef_poirrig sdmx-measure:obsValue ?ef_poirrig .
    }
  } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wat_use.rdf.gz>  { 
      _:env_wat_use sdmx-dimension:timePeriod ?date . 
      _:env_wat_use sdmx-dimension:refArea ?geo . 
      _:env_wat_use property:wat_proc wat_proc:ABS_AGR_IR . 
      _:env_wat_use sdmx-attribute:unitMeasure unit:MIO_M3 . 
      _:env_wat_use property:wat_src ?wat_src .
      FILTER (?wat_src in (wat_src:RUW, wat_src:DSW, wat_src:NFW))
      _:env_wat_use sdmx-measure:obsValue ?env_wat_use .
    }
  } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/apro_acs_a.rdf.gz>  
    {
      _:apro_acs_a sdmx-dimension:timePeriod ?date .
      _:apro_acs_a property:crops ?crops .
      FILTER (?crops in (crops:ARA, crops:PECR))
      _:apro_acs_a sdmx-dimension:refArea ?geo .
      _:apro_acs_a property:strucpro strucpro:MA .
      _:apro_acs_a sdmx-measure:obsValue ?apro_acs_a .
      _:apro_acs_a sdmx-measure:obsValue ?AGRAREA_HA .
    }
  } UNION {
    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2017/swbewa2017.tsv>  
    {  
      _:swbewa2017 swbewa2017:date ?date .
      _:swbewa2017 swbewa2017:geo ?geo .
      _:swbewa2017 swbewa2017:obsValue ?swbewa2017 .
    }
  } UNION {
    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2017/fadn2017.tsv>  
    {  
      _:fadn2017 fadn2017:date ?date .
      _:fadn2017 fadn2017:geo ?geo .
      _:fadn2017 fadn2017:obsValue ?fadn2017 .
    }
  } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/aact_eaa07.rdf.gz>  { 
      _:aact_eaa07_PPS sdmx-dimension:timePeriod ?date . 
      _:aact_eaa07_PPS sdmx-dimension:refArea ?geo . 
      _:aact_eaa07_PPS sdmx-attribute:unitMeasure unit:MIO_PPS . 
      _:aact_eaa07_PPS property:indic_ag indic_ag:PROD_BP . 
      {
        _:aact_eaa07_PPS property:itm_newa itm_newa:19010 . 
        _:aact_eaa07_PPS sdmx-measure:obsValue ?19010_PPS .
      } UNION {
        _:aact_eaa07_PPS property:itm_newa itm_newa:19040 .
        _:aact_eaa07_PPS sdmx-measure:obsValue ?19040_PPS .
      } UNION {
        _:aact_eaa07_PPS property:itm_newa itm_newa:19020.
        _:aact_eaa07_PPS sdmx-measure:obsValue ?19020_PPS .
      } UNION {
        _:aact_eaa07_PPS property:itm_newa itm_newa:19030.
        _:aact_eaa07_PPS sdmx-measure:obsValue ?19030_PPS .
      } UNION {
        _:aact_eaa07_PPS property:itm_newa itm_newa:13000.
        _:aact_eaa07_PPS sdmx-measure:obsValue ?13000_PPS .
      } UNION {
        _:aact_eaa07_PPS property:itm_newa itm_newa:10000.
        _:aact_eaa07_PPS sdmx-measure:obsValue ?10000_PPS .
      } UNION {
        _:aact_eaa07_PPS property:itm_newa itm_newa:16000.
        _:aact_eaa07_PPS sdmx-measure:obsValue ?16000_PPS .
      }
    }
  }

  ?geo skos:notation ?geoNotation  .
  ?geo skos:exactMatch ?eeauri .
  ?eeauri skos:inScheme countries: .
  ?eeauri rdfs:label ?ugeo .
  FILTER (strlen(?geoNotation) = 2)
  #FILTER (?geo = geo:DK)
  FILTER (year(?date) in (2005, 2007, 2010, 2013))
 }}
GROUP BY ?geo ?ugeo year(?date)
HAVING ( sum(xsd:double(?abs_nace_A011_A013)) + sum(coalesce(?env_wat_use,0)) + sum(xsd:double(?swbewa2017)) ) / sum(?AGRAREA_HA) > 0 && round(( ( sum(?10000_PPS) - (sum(?19010_PPS) + sum(?19040_PPS) + (sum(?19020_PPS) * (sum(?10000_PPS)/sum(?16000_PPS)))  + (sum(?19030_PPS) * (sum(?10000_PPS)/(sum(?10000_PPS)+sum(?13000_PPS))))) ) * (1.0-sum(xsd:double(?fadn2017))) / sum(?AGRAREA_HA))*1000.0) > 0
ORDER BY ?ugeo ?date


Related content

Temporal coverage

Document Actions