Do something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data table via SPARQL
Received 20 rows in 0.040 seconds.
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.
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 nutrient: <http://rdfdata.eionet.europa.eu/eurostat/dic/nutrient#>
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 tableFile: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/irrigation_water_use_coefficient_2010.txt#>
PREFIX fao_irrigation: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2014/fao_irrigation.txt#>
SELECT
?ugeo
'cereals' as ?crop
?ef_poirrig_crop
?ef_oluaareg
?ratio_of_irrigated_area
?water_consumption
?water_consumption_crop
?water_use_coefficient
?ef_poirrig_water_used
?ratio_pps
?MIO_PPS
?PROD_PP
?economic_output
( ?economic_output * ?ratio_pps ) as ?economic_output_pps
#round((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)*1000)/100.0 as ?ratio_of_total_water
round((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)*10000)/10.0 as ?ratio_of_total_water
sum(?water_consumption_crop)*((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)) as ?water_use_for_irigation_per_crop
round(( ?economic_output * ?ratio_pps ) / ( sum(?water_consumption_crop)*((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)) ))/10000.0 as ?ecwp
round(( ( sum(?water_consumption_crop)*((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)) / ( ?economic_output * ?ratio_pps ) ))*1000000)/100.0 as ?cwi
round(( ( sum(?water_consumption_crop)*((sum(?ef_poirrig_water_used)*?water_use_coefficient)/sum(?water_consumption)) / ( ?economic_output ) ))*1000000)/10000.0 as ?euro_cwi
{{
SELECT
?ugeo
sum(?ef_poirrig_crop) as ?ef_poirrig_crop
COALESCE((sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize)), 0) as ?ef_oluaareg
( sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize) ) as ?test
round((sum(?ef_poirrig_crop)/ ( sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize) ) )*10000)/100.0 as ?ratio_of_irrigated_area
sum(?water_consumption) as ?water_consumption
sum(?water_consumption_crop) as ?water_consumption_crop
?water_use_coefficient
sum(?ef_poirrig_water_used) as ?ef_poirrig_water_used
xsd:decimal((COALESCE(sum(?MIO_PPS_cereals),0)-COALESCE(sum(?MIO_PPS_maize_rice),0) ) / ( COALESCE(sum(?PROD_PP_cereals ),0)-COALESCE(sum(?MIO_PPS_maize_rice),0) )*100) as ?ratio_pps
(sum(?MIO_PPS_cereals)-sum(?MIO_PPS_maize_rice)) as ?MIO_PPS
(sum(?PROD_PP_cereals)-sum(?PROD_PP_maize_rice)) as ?PROD_PP
xsd:decimal((COALESCE(sum(?PROD_PP_cereals)-sum(?PROD_PP_maize_rice),0))*((sum(?ef_poirrig_crop)/COALESCE((sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize)), 0))*100 )*1000000) as ?economic_output
{{
SELECT DISTINCT
?ugeo
COALESCE(sum(?ef_poirrig_crop), 0) as ?ef_poirrig_crop
COALESCE(sum(?ef_poirrig)*sum(?value)*10, 0) as ?water_consumption
COALESCE(sum(?ef_poirrig_crop)*sum(?value)*10, 0) as ?water_consumption_crop
?water_use_coefficient
COALESCE(sum(?ef_oluaareg_cereals),0) as ?ef_oluaareg_cereals
COALESCE(sum(?ef_oluaareg_rice_maize),0) as ?ef_oluaareg_rice_maize
COALESCE(sum(?ef_poirrig_water_used),0) as ?ef_poirrig_water_used
COALESCE(sum(xsd:double(?PROD_PP_cereals)),0) as ?PROD_PP_cereals
COALESCE(sum(xsd:double(?PROD_PP_maize_rice)),0) as ?PROD_PP_maize_rice
COALESCE(sum(xsd:double(?MIO_PPS_cereals) ),0) as ?MIO_PPS_cereals
COALESCE(sum(xsd:double(?MIO_PPS_maize_rice)),0) as ?MIO_PPS_maize_rice
WHERE {{
{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/aact_eaa01.rdf.gz> {
_:aact_eaa01 sdmx-dimension:timePeriod ?date .
_:aact_eaa01 sdmx-dimension:refArea ?geo .
_:aact_eaa01 property:indic_ag indic_ag:PROD_PP .
{
_:aact_eaa01 sdmx-attribute:unitMeasure unit:MIO_EUR .
{
_:aact_eaa01 property:itm_newa ?itm_newa .
FILTER (?itm_newa in (itm_newa:01000)) .
OPTIONAL { _:aact_eaa01 sdmx-measure:obsValue ?PROD_PP_cereals . }
} UNION {
_:aact_eaa01 property:itm_newa ?itm_newa .
FILTER (?itm_newa in (itm_newa:01500, itm_newa:01600)) .
OPTIONAL { _:aact_eaa01 sdmx-measure:obsValue ?PROD_PP_maize_rice . }
}
} UNION {
_:aact_eaa01 sdmx-attribute:unitMeasure unit:MIO_PPS .
{
_:aact_eaa01 property:itm_newa ?itm_newa .
FILTER (?itm_newa in (itm_newa:01000)) .
OPTIONAL { _:aact_eaa01 sdmx-measure:obsValue ?MIO_PPS_cereals . }
} UNION {
_:aact_eaa01 property:itm_newa ?itm_newa .
FILTER (?itm_newa in (itm_newa:01500, itm_newa:01600)) .
OPTIONAL { _:aact_eaa01 sdmx-measure:obsValue ?MIO_PPS_rice . }
}
}
}
} UNION {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/ef_poirrig.rdf.gz> {
_:ef_poirrig sdmx-dimension:timePeriod ?date .
_:ef_poirrig sdmx-dimension:refArea ?geo .
_:ef_poirrig property:irrig irrig:TOTAL .
{
_:ef_poirrig property:indic_ef ?indic_ef .
FILTER (?indic_ef = indic_ef:M_8_1_2_1_HA) .
_:ef_poirrig sdmx-measure:obsValue ?ef_poirrig_crop .
} UNION {
_:ef_poirrig property:indic_ef ?indic_ef .
FILTER (?indic_ef in (
indic_ef:M_8_1_2_1_HA, indic_ef:M_8_1_2_2_HA,
indic_ef:M_8_1_2_3_HA, indic_ef:M_8_1_2_4_HA,
indic_ef:M_8_1_2_5_HA, indic_ef:M_8_1_2_6_HA,
indic_ef:M_8_1_2_7_HA, indic_ef:M_8_1_2_8_HA,
indic_ef:M_8_1_2_9_HA, indic_ef:M_8_1_2_10_HA,
indic_ef:M_8_1_2_11_HA, indic_ef:M_8_1_2_12_HA,
indic_ef:M_8_1_2_13_HA, indic_ef:M_8_1_2_14_HA,
indic_ef:M_8_1_2_15_HA, indic_ef:M_8_1_2_16_HA)
)
_:ef_poirrig sdmx-measure:obsValue ?ef_poirrig .
} UNION {
_:ef_poirrig property:indic_ef ?indic_ef .
FILTER (?indic_ef in (indic_ef:M_8_4_M3))
_:ef_poirrig sdmx-measure:obsValue ?ef_poirrig_water_used .
}
}
} 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:agrarea agrarea:TOTAL .
{
_:ef_oluaareg property:indic_ef ?indic_ef .
FILTER (?indic_ef in (indic_ef:B_1_1_HA))
_:ef_oluaareg sdmx-measure:obsValue ?ef_oluaareg_cereals .
} UNION {
_:ef_oluaareg property:indic_ef ?indic_ef .
FILTER (?indic_ef in (indic_ef:B_1_1_6_HA, indic_ef:B_1_1_7_HA)) .
_:ef_oluaareg sdmx-measure:obsValue ?ef_oluaareg_rice_maize .
}
}
} UNION {
GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2014/fao_irrigation.txt> {
_:fao_irrigation fao_irrigation:date ?date .
_:fao_irrigation fao_irrigation:crop ?crop .
#_:fao_irrigation fao_irrigation:estat_crop ?estat_crop .
_:fao_irrigation fao_irrigation:indic_ef ?indic_ef .
_:fao_irrigation fao_irrigation:value ?value .
}
}
?fao_geo tableFile:geo ?ugeo .
?fao_geo tableFile:irrigation_water_use_coefficient ?water_use_coefficient .
?geo skos:notation ?ugeo .
#FILTER (?geo in (geo:MT))
FILTER (year(?date) in (2010))
}}
GROUP BY ?ugeo iri(?indic_ef) ?water_use_coefficient
}}
HAVING ( sum(?ef_oluaareg_cereals)-sum(?ef_oluaareg_rice_maize) ) > 0
}}
HAVING sum(?ef_oluaareg) > 0 and sum(?PROD_PP) > 0 and sum(?water_consumption) > 0 and sum(?water_consumption_crop) > 0 and sum(?water_consumption) > 0 and sum(?ef_poirrig_water_used) > 0 and ?ratio_of_irrigated_area > 0
ORDER BY ?ugeo
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/cereals-fao-wrei004 or scan the QR code.
PDF generated on 19 Apr 2024, 07:40 AM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others