Crop Water Intensity of agriculture

Data table via SPARQL Published 14 Jun 2017 Last modified 04 Dec 2017
38 min read

Download this dataset

Dataset preview

(Live Query)

refArea date ugeo region AA_MT AB_MT
<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AT> "2010"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "(Western)" "6.18"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.61"^^<http://www.w3.org/2001/XMLSchema#decimal>
<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE> "2005"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "(Western)" "1.66"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.52"^^<http://www.w3.org/2001/XMLSchema#decimal>
<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE> "2007"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "(Western)" "1.69"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.54"^^<http://www.w3.org/2001/XMLSchema#decimal>
<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE> "2010"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "(Western)" "1.81"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.65"^^<http://www.w3.org/2001/XMLSchema#decimal>
<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE> "2013"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "(Western)" "1.86"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BG> "2007"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "(Eastern)" "14.89"^^<http://www.w3.org/2001/XMLSchema#decimal> "32.92"^^<http://www.w3.org/2001/XMLSchema#decimal>
<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BG> "2010"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "(Eastern)" "9.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "20.33"^^<http://www.w3.org/2001/XMLSchema#decimal>
<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BG> "2013"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "(Eastern)" "10.81"^^<http://www.w3.org/2001/XMLSchema#decimal> "23.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/HR> "2013"^^<http://www.w3.org/2001/XMLSchema#int> "Croatia" "(Eastern)" "3.32"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.78"^^<http://www.w3.org/2001/XMLSchema#decimal>
<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/CY> "2005"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "(Southern)" "4.37"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.78"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 90 rows in 0.056 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/crop-water-intensity-of-agriculture/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
#?date as ?timePeriod
?geo as ?refArea
year(?date) as ?date
?ugeo

concat('(', 
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(xsd:double(?abs_nace_A011_A013)) + sum(coalesce(?env_wat_use,0)) + sum(xsd:double(?swbewa2017)) ) / ( ( sum(xsd:double(?10000_PPS)) - (sum(xsd:double(?19010_PPS)) + sum(xsd:double(?19040_PPS)) + (sum(xsd:double(?19020_PPS)) * (sum(xsd:double(?10000_PPS))/sum(xsd:double(?16000_PPS))))  + (sum(xsd:double(?19030_PPS)) * (sum(xsd:double(?10000_PPS))/(sum(xsd:double(?10000_PPS))+sum(xsd:double(?13000_PPS)))))) ) * (1.0-sum(xsd:double(?fadn2017))) ) )*100.0)/100.0 as ?AA_MT

round(( (sum(xsd:double(?abs_nace_A011_A013)) + sum(coalesce(?env_wat_use,0)) + sum(xsd:double(?swbewa2017)) ) / ( ( sum(xsd:double(?10000_EUR)) - (sum(xsd:double(?19010_EUR)) + sum(xsd:double(?19040_EUR)) + (sum(xsd:double(?19020_EUR)) * (sum(xsd:double(?10000_EUR))/sum(xsd:double(?16000_EUR))))  + (sum(xsd:double(?19030_EUR)) * (sum(xsd:double(?10000_EUR))/(sum(xsd:double(?10000_EUR))+sum(xsd:double(?13000_EUR)))))) ) * (1.0-sum(xsd:double(?fadn2017))) ) )*100.0)/100.0 as ?AB_MT

WHERE {{ 
  {
    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/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:AT .
      _: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 .
      }
    }
  } 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_EUR . 
      _: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_EUR .
      } UNION {
        _:aact_eaa07_PPS property:itm_newa itm_newa:19040 .
        _:aact_eaa07_PPS sdmx-measure:obsValue ?19040_EUR .
      } UNION {
        _:aact_eaa07_PPS property:itm_newa itm_newa:19020.
        _:aact_eaa07_PPS sdmx-measure:obsValue ?19020_EUR .
      } UNION {
        _:aact_eaa07_PPS property:itm_newa itm_newa:19030.
        _:aact_eaa07_PPS sdmx-measure:obsValue ?19030_EUR .
      } UNION {
        _:aact_eaa07_PPS property:itm_newa itm_newa:13000.
        _:aact_eaa07_PPS sdmx-measure:obsValue ?13000_EUR .
      } UNION {
        _:aact_eaa07_PPS property:itm_newa itm_newa:10000.
        _:aact_eaa07_PPS sdmx-measure:obsValue ?10000_EUR .
      } UNION {
        _:aact_eaa07_PPS property:itm_newa itm_newa:16000.
        _:aact_eaa07_PPS sdmx-measure:obsValue ?16000_EUR .
      }
    }
  }

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


Related content

Visualisations produced

Temporal coverage

Document Actions