Data table via SPARQL

Crop Water Intensity of agriculture

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

38 min read

Topics: Water and marine environment

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)

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.003 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/crop-water-intensity-of-agriculture/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 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

Permalinks

Permalink to this version: ec0199904d5a4627bb2760eab5d57ddd
Permalink to latest version: OUKP397H4R

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