Indexed crop water intensity of agriculture per country

Data table via SPARQL Published 23 Jun 2017 Last modified 01 Aug 2017
Topics: ,

Download this dataset

Dataset preview

(Live Query)

timePeriod refArea date ugeo region AA_MT AA_MT_idx index
"2009-12-31"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AT> "2010"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "(Western)" "12.48"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.48"^^<http://www.w3.org/2001/XMLSchema#decimal> "100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004-12-31"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE> "2005"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "(Western)" "2.66"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.87"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006-12-31"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE> "2007"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "(Western)" "2.69"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.87"^^<http://www.w3.org/2001/XMLSchema#decimal> "93.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009-12-31"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE> "2010"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "(Western)" "2.87"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.87"^^<http://www.w3.org/2001/XMLSchema#decimal> "100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012-12-31"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE> "2013"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "(Western)" "2.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.87"^^<http://www.w3.org/2001/XMLSchema#decimal> "101"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006-12-31"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BG> "2007"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "(Eastern)" "14.01"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.26"^^<http://www.w3.org/2001/XMLSchema#decimal> "114.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009-12-31"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BG> "2010"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "(Eastern)" "12.26"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.26"^^<http://www.w3.org/2001/XMLSchema#decimal> "100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012-12-31"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BG> "2013"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "(Eastern)" "13.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.26"^^<http://www.w3.org/2001/XMLSchema#decimal> "113.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004-12-31"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/CY> "2005"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "(Southern)" "4.05"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.28"^^<http://www.w3.org/2001/XMLSchema#decimal> "94.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006-12-31"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/CY> "2007"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "(Southern)" "3.94"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.28"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.1"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 91 rows in 0.062 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/indexed-crop-water-intensity-of/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 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 
?timePeriod
?refArea
?date
?ugeo
concat('(', ?region,')') as ?region

?AA_MT
?AA_MT_idx
round((?AA_MT/?AA_MT_idx)*1000)/10.0 as ?index

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

round(( (sum(xsd:double(?abs_nace_A011_A013_idx)) + sum(coalesce(?env_wat_use_idx,0)) + sum(xsd:double(?swbewa2017_idx)) ) / ( ( sum(xsd:double(?10000_PPS_idx)/7.0) - (sum(xsd:double(?19010_PPS_idx)/7.0) + sum(xsd:double(?19040_PPS_idx)/7.0) + (sum(xsd:double(?19020_PPS_idx)/7.0) * (sum(xsd:double(?10000_PPS_idx)/7.0)/sum(xsd:double(?16000_PPS_idx)/7.0)))  + (sum(xsd:double(?19030_PPS_idx)/7.0) * (sum(xsd:double(?10000_PPS_idx)/7.0)/(sum(xsd:double(?10000_PPS_idx)/7.0)+sum(xsd:double(?13000_PPS_idx)/7.0))))) ) * (1.0-sum(xsd:double(?fadn2017_idx))) ) )*100.0)/100.0 as ?AA_MT_idx

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 .

      _:abs_nace_A011_A013_idx env_wat_abs_abs_nace_A011_A013:geo ?geo .
      _:abs_nace_A011_A013_idx env_wat_abs_abs_nace_A011_A013:date ?date_idx .
      FILTER (year(?date_idx) = 2010)
      _:abs_nace_A011_A013_idx env_wat_abs_abs_nace_A011_A013:obsValue ?abs_nace_A011_A013_idx .
    }
  } 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 .

      _:env_wat_use_idx sdmx-dimension:timePeriod ?date_idx .
      FILTER (year(?date_idx) = 2010)
      _:env_wat_use_idx sdmx-dimension:refArea ?geo . 
      _:env_wat_use_idx property:wat_proc wat_proc:ABS_AGR_IR . 
      _:env_wat_use_idx sdmx-attribute:unitMeasure unit:MIO_M3 . 
      _:env_wat_use_idx property:wat_src ?wat_src_idx .
      FILTER (?wat_src_idx in (wat_src:RUW, wat_src:DSW, wat_src:NFW))
      _:env_wat_use_idx sdmx-measure:obsValue ?env_wat_use_idx .
    }
  } 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:AGRAREA_HA . 
      _:ef_oluaareg property:agrarea agrarea:TOTAL . 
      _:ef_oluaareg sdmx-measure:obsValue ?AGRAREA_HA .

      _:ef_oluaareg_idx sdmx-dimension:timePeriod ?date_idx .
      FILTER (year(?date_idx) = 2010)
      _:ef_oluaareg_idx sdmx-dimension:refArea ?geo . 
      _:ef_oluaareg_idx property:indic_ef indic_ef:AGRAREA_HA . 
      _:ef_oluaareg_idx property:agrarea agrarea:TOTAL . 
      _:ef_oluaareg_idx sdmx-measure:obsValue ?AGRAREA_HA_idx .
    }
  } 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 .

      _:swbewa2017_idx swbewa2017:date ?date_idx .
      FILTER (year(?date_idx) = 2010)
      _:swbewa2017_idx swbewa2017:geo ?geo .
      _:swbewa2017_idx swbewa2017:obsValue ?swbewa2017_idx .
    }
  } 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 .

      _:fadn2017_idx fadn2017:date ?date_idx .
      FILTER (year(?date_idx) = 2010)
      _:fadn2017_idx fadn2017:geo ?geo .
      _:fadn2017_idx fadn2017:obsValue ?fadn2017_idx .
    }
  } 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 .
      }

      _:aact_eaa07_PPS_idx sdmx-dimension:timePeriod ?date_idx .
      FILTER (year(?date_idx) = 2010)
      _:aact_eaa07_PPS_idx sdmx-dimension:refArea ?geo . 
      _:aact_eaa07_PPS_idx sdmx-attribute:unitMeasure unit:MIO_PPS . 
      _:aact_eaa07_PPS_idx property:indic_ag indic_ag:PROD_BP . 
      {
        _:aact_eaa07_PPS_idx property:itm_newa itm_newa:19010 . 
        _:aact_eaa07_PPS_idx sdmx-measure:obsValue ?19010_PPS_idx .
      } UNION {
        _:aact_eaa07_PPS_idx property:itm_newa itm_newa:19040 .
        _:aact_eaa07_PPS_idx sdmx-measure:obsValue ?19040_PPS_idx .
      } UNION {
        _:aact_eaa07_PPS_idx property:itm_newa itm_newa:19020.
        _:aact_eaa07_PPS_idx sdmx-measure:obsValue ?19020_PPS_idx .
      } UNION {
        _:aact_eaa07_PPS_idx property:itm_newa itm_newa:19030.
        _:aact_eaa07_PPS_idx sdmx-measure:obsValue ?19030_PPS_idx .
      } UNION {
        _:aact_eaa07_PPS_idx property:itm_newa itm_newa:13000.
        _:aact_eaa07_PPS_idx sdmx-measure:obsValue ?13000_PPS_idx .
      } UNION {
        _:aact_eaa07_PPS_idx property:itm_newa itm_newa:10000.
        _:aact_eaa07_PPS_idx sdmx-measure:obsValue ?10000_PPS_idx .
      } UNION {
        _:aact_eaa07_PPS_idx property:itm_newa itm_newa:16000.
        _:aact_eaa07_PPS_idx sdmx-measure:obsValue ?16000_PPS_idx .
      }
    }
  }

  ?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))
 }}

}}
HAVING ?AA_MT > 0 && (?AA_MT/?AA_MT_idx) > 0
ORDER BY ?ugeo ?date


Temporal coverage

Document Actions