All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo 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 17 rows in 0.003 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 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 jrc_irrigation: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2014/jrc_irrigation.txt#>
SELECT
?ugeo
'maize' as ?crop
sum(?ef_oluaareg) as ?ef_oluaareg
sum(?ef_poirrig) as ?ef_poirrig
sum(?jrc_irrigation) as ?jrc_irrigation
sum(?MIO_PPS) as ?MIO_PPS
sum(?PROD_PP) as ?PROD_PP
round((sum(?ef_poirrig)/sum(?ef_oluaareg))*1000)/10.0 as ?ratio_of_irrigated_area
round(( (sum(?ef_poirrig)/sum(?ef_oluaareg))*sum(?PROD_PP) )*1000000) as ?economic_output
(sum(?MIO_PPS) / sum(?PROD_PP) )*100 as ?ratio_pps
(( (sum(?ef_poirrig)/sum(?ef_oluaareg))*sum(?PROD_PP) )*1000000 * (sum(?MIO_PPS) / sum(?PROD_PP) )) as ?economic_output_pps
round( ( ( (sum(?MIO_PPS) / sum(?PROD_PP) )*100 ) * round(( (sum(?ef_poirrig)/sum(?ef_oluaareg))*sum(?PROD_PP) )*100) ) / ( sum(?jrc_irrigation) )*10000)/100.0 as ?ecwp
round(( sum(?jrc_irrigation) / ( ( (sum(?MIO_PPS) / sum(?PROD_PP) )*100 ) * round(( (sum(?ef_poirrig)/sum(?ef_oluaareg))*sum(?PROD_PP) )*1000000) ) )*10000)/100.0 as ?wui
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 sdmx-attribute:unitMeasure unit:MIO_EUR .
_:aact_eaa01 property:indic_ag indic_ag:PROD_PP .
_:aact_eaa01 property:itm_newa ?itm_newa
FILTER (?itm_newa in (itm_newa:01500, itm_newa:03100)) .
_:aact_eaa01 sdmx-measure:obsValue ?PROD_PP .
} UNION {
_:aact_eaa01 sdmx-attribute:unitMeasure unit:MIO_PPS .
_:aact_eaa01 property:indic_ag indic_ag:PROD_PP .
_:aact_eaa01 property:itm_newa ?itm_newa .
FILTER (?itm_newa in (itm_newa:01500, itm_newa:03100))
_:aact_eaa01 sdmx-measure:obsValue ?MIO_PPS .
}
}
} 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 .
FILTER (?indic_ef in (indic_ef:B_1_1_6_HA, indic_ef:B_1_9_2_1_HA))
_:ef_oluaareg property:agrarea agrarea:TOTAL .
_:ef_oluaareg sdmx-measure:obsValue ?ef_oluaareg .
}
} 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:M_8_1_2_2_HA .
_:ef_poirrig sdmx-measure:obsValue ?ef_poirrig .
}
} UNION {
GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2014/jrc_irrigation.txt> {
_:jrc_irrigation jrc_irrigation:DATE ?date .
#_:jrc_irrigation jrc_irrigation:NUTS2_ID ?ugeo .
_:jrc_irrigation jrc_irrigation:COUNTRY ?ugeo.
_:jrc_irrigation jrc_irrigation:jrc_crop ?jrc_crop . FILTER (?jrc_crop in ('MAIF', 'MAIZ'))
_:jrc_irrigation jrc_irrigation:value ?jrc_irrigation .
}
}
?geo skos:notation ?ugeo .
FILTER (year(?date) = 2010)
}}
GROUP BY str(?ugeo)
HAVING sum(?ef_oluaareg) > 0 and sum(?MIO_PPS) > 0 and sum(?PROD_PP) > 0 and sum(?ef_poirrig) > 0 and sum(?jrc_irrigation) > 0
ORDER BY ?ugeo
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/maize-jrc-wrei004 or scan the QR code.
PDF generated on 08 Dec 2024, 07:45 PM
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