next
previous
items

Data table via SPARQL

Economic profit from crops indexed 2010=100

Data table via SPARQL Published 14 Jun 2017 Last modified 14 Sep 2017
36 min read
Topics:

Download this dataset

Dataset preview

(Live Query)

timePeriod refArea date ugeo label index
"2004-12-31"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AT> "2005"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "gross value added from crops" "68.1"^^<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/AT> "2007"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "gross value added from crops" "101.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/AT> "2010"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "gross value added from crops" "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/AT> "2013"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "gross value added from crops" "118.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/BE> "2005"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "gross value added from crops" "112.9"^^<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" "gross value added from crops" "108.5"^^<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" "gross value added from crops" "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" "gross value added from crops" "103.5"^^<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/BG> "2005"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "gross value added from crops" "224.4"^^<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" "gross value added from crops" "81.7"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 119 rows in 0.004 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/economic-profit-from-crops-indexed/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 abs_nace_A011_A013: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2017/abs_nace_A011_A013.tsv#>

SELECT
?date as ?timePeriod
?geo as ?refArea
year(?date) as ?date
?ugeo
#?U_EUR/?ef_oluaareg
#?U_EUR_idx/?ef_oluaareg_idx 
'gross value added from crops' as ?label
round(( (?U_EUR/?ef_oluaareg) / (?U_EUR_idx/?ef_oluaareg_idx))*1000)/10.0 as ?index

{{
SELECT DISTINCT
?date
?geo
?ugeo

( ( sum(?10000_EUR) - (sum(?19010_EUR) + sum(?19040_EUR) + (sum(?19020_EUR) * (sum(?10000_EUR)/sum(?16000_EUR)))  + (sum(?19030_EUR) * (sum(?10000_EUR)/(sum(?10000_EUR)+sum(?13000_EUR))))) ) * (1.0-sum(xsd:decimal(?fadn2017))) )/7.0 as ?U_EUR

( ( sum(?10000_EUR_idx) - (sum(?19010_EUR_idx) + sum(?19040_EUR_idx) + (sum(?19020_EUR_idx) * (sum(?10000_EUR_idx)/sum(?16000_EUR_idx)))  + (sum(?19030_EUR_idx) * (sum(?10000_EUR_idx)/(sum(?10000_EUR_idx)+sum(?13000_EUR_idx))))) ) * (1.0-sum(xsd:decimal(?fadn2017_idx))) )/7.0 as ?U_EUR_idx

sum(?ef_oluaareg) as ?ef_oluaareg
sum(?ef_oluaareg_idx) as ?ef_oluaareg_idx

WHERE {{ 
  {
    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 .
      _:fadn2017_idx fadn2017:geo ?geo .
      _:fadn2017_idx fadn2017:obsValue ?fadn2017_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 ?ef_oluaareg .

      _:ef_oluaareg_idx sdmx-dimension:timePeriod ?date_idx . 
      _: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 ?ef_oluaareg_idx .
    }
  } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/aact_eaa07.rdf.gz>  { 
      _:aact_eaa07_EUR sdmx-dimension:timePeriod ?date . 
      _:aact_eaa07_EUR sdmx-dimension:refArea ?geo . 
      _:aact_eaa07_EUR sdmx-attribute:unitMeasure unit:MIO_EUR . 
      _:aact_eaa07_EUR property:indic_ag indic_ag:PROD_BP . 
      {
        _:aact_eaa07_EUR property:itm_newa itm_newa:19010 . 
        _:aact_eaa07_EUR sdmx-measure:obsValue ?19010_EUR .
      } UNION {
        _:aact_eaa07_EUR property:itm_newa itm_newa:19040 .
        _:aact_eaa07_EUR sdmx-measure:obsValue ?19040_EUR .
      } UNION {
        _:aact_eaa07_EUR property:itm_newa itm_newa:19020.
        _:aact_eaa07_EUR sdmx-measure:obsValue ?19020_EUR .
      } UNION {
        _:aact_eaa07_EUR property:itm_newa itm_newa:19030.
        _:aact_eaa07_EUR sdmx-measure:obsValue ?19030_EUR .
      } UNION {
        _:aact_eaa07_EUR property:itm_newa itm_newa:13000.
        _:aact_eaa07_EUR sdmx-measure:obsValue ?13000_EUR .
      } UNION {
        _:aact_eaa07_EUR property:itm_newa itm_newa:10000.
        _:aact_eaa07_EUR sdmx-measure:obsValue ?10000_EUR .
      } UNION {
        _:aact_eaa07_EUR property:itm_newa itm_newa:16000.
        _:aact_eaa07_EUR sdmx-measure:obsValue ?16000_EUR .
      }

      _:aact_eaa07_EUR_idx sdmx-dimension:timePeriod ?date_idx . 
      _:aact_eaa07_EUR_idx sdmx-dimension:refArea ?geo . 
      _:aact_eaa07_EUR_idx sdmx-attribute:unitMeasure unit:MIO_EUR . 
      _:aact_eaa07_EUR_idx property:indic_ag indic_ag:PROD_BP . 
      {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:19010 . 
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?19010_EUR_idx .
      } UNION {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:19040 .
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?19040_EUR_idx .
      } UNION {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:19020.
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?19020_EUR_idx .
      } UNION {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:19030.
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?19030_EUR_idx .
      } UNION {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:13000.
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?13000_EUR_idx .
      } UNION {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:10000.
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?10000_EUR_idx .
      } UNION {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:16000.
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?16000_EUR_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))
  FILTER (year(?date_idx) in (2010))
 }}
GROUP BY ?ugeo year(?date) ?geo

}}
HAVING (( (?U_EUR/?ef_oluaareg) / (?U_EUR_idx/?ef_oluaareg_idx))) > 0
ORDER BY ?ugeo ?date


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Filed under:
Filed under: economic profit, crop
Document Actions