Data table via SPARQL

Indexed crop water intensity of agriculture per geographical region

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

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

timePeriod	refArea	date	ugeo	region	AA_MT	AA_MT_idx	index
"2004-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	""	"2005"^^<http://www.w3.org/2001/XMLSchema#int>	"Eastern"	"(Eastern)"	"16.62375"^^<http://www.w3.org/2001/XMLSchema#decimal>	"21.002"^^<http://www.w3.org/2001/XMLSchema#decimal>	"79.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	""	"2007"^^<http://www.w3.org/2001/XMLSchema#int>	"Eastern"	"(Eastern)"	"14.355"^^<http://www.w3.org/2001/XMLSchema#decimal>	"21.002"^^<http://www.w3.org/2001/XMLSchema#decimal>	"68.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	""	"2010"^^<http://www.w3.org/2001/XMLSchema#int>	"Eastern"	"(Eastern)"	"21.002"^^<http://www.w3.org/2001/XMLSchema#decimal>	"21.002"^^<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>	""	"2013"^^<http://www.w3.org/2001/XMLSchema#int>	"Eastern"	"(Eastern)"	"14.525454545454545"^^<http://www.w3.org/2001/XMLSchema#decimal>	"21.002"^^<http://www.w3.org/2001/XMLSchema#decimal>	"69.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	""	"2005"^^<http://www.w3.org/2001/XMLSchema#int>	"Southern"	"(Southern)"	"5.4425"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5.955"^^<http://www.w3.org/2001/XMLSchema#decimal>	"91.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	""	"2007"^^<http://www.w3.org/2001/XMLSchema#int>	"Southern"	"(Southern)"	"5.745"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5.955"^^<http://www.w3.org/2001/XMLSchema#decimal>	"96.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	""	"2010"^^<http://www.w3.org/2001/XMLSchema#int>	"Southern"	"(Southern)"	"5.955"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5.955"^^<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>	""	"2013"^^<http://www.w3.org/2001/XMLSchema#int>	"Southern"	"(Southern)"	"5.456666666666667"^^<http://www.w3.org/2001/XMLSchema#decimal>	"5.936666666666667"^^<http://www.w3.org/2001/XMLSchema#decimal>	"91.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	""	"2005"^^<http://www.w3.org/2001/XMLSchema#int>	"Western"	"(Western)"	"14.26375"^^<http://www.w3.org/2001/XMLSchema#decimal>	"12.538"^^<http://www.w3.org/2001/XMLSchema#decimal>	"113.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	""	"2007"^^<http://www.w3.org/2001/XMLSchema#int>	"Western"	"(Western)"	"11.52"^^<http://www.w3.org/2001/XMLSchema#decimal>	"12.538"^^<http://www.w3.org/2001/XMLSchema#decimal>	"91.9"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 12 rows in 0.001 seconds.

JSON Url:
https://eea.europa.eu./data-and-maps/daviz/sds/indexed-crop-water-intensity-of-1/daviz.json

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


        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
'' as ?refArea
?date
?region as ?ugeo
concat('(', ?region,')') as ?region

avg(?AA_MT) as ?AA_MT
avg(?AA_MT_idx) as ?AA_MT_idx
round((avg(?AA_MT)/avg(?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 avg(?AA_MT) > 0 && (avg(?AA_MT)/avg(?AA_MT_idx)) > 0
ORDER BY ?ugeo ?date

Permalinks

Permalink to this version: 5eb31e57485540a3b5008b514ac42c8a
Permalink to latest version: 6HBUVOC348

Geographic coverage

Austria Belgium Bulgaria Croatia Cyprus Czechia Denmark Estonia Finland France Germany Greece Hungary Ireland Italy Latvia Lithuania Luxembourg Malta Netherlands Poland Portugal Romania Slovakia Slovenia Spain Sweden United Kingdom