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 28 rows in 0.363 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 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-unit: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#>
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX irrig: <http://rdfdata.eionet.europa.eu/eurostat/dic/irrig#>
PREFIX indic_ef: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_ef#>
SELECT
bif:either (?ugeo = 'DE', 'Germany', ?country) as ?country
(round((sum(?cereals)/sum(?total))*10000))/100.0 as ?cereals
(round((sum(?maize)/sum(?total))*10000))/100.0 as ?maize
(round((sum(?rice)/sum(?total))*10000))/100.0 as ?rice
(round((sum(?pulses)/sum(?total))*10000))/100.0 as ?pulses
(round((sum(?potatoes)/sum(?total))*10000))/100.0 as ?potatoes
(round((sum(?sugar_beet)/sum(?total))*10000))/100.0 as ?sugar_beet
(round((sum(?rape_and_turnip_rape)/sum(?total))*10000))/100.0 as ?rape_and_turnip_rape
(round((sum(?sunflower)/sum(?total))*10000))/100.0 as ?sunflower
(round((sum(?textile_crops)/sum(?total))*10000))/100.0 as ?textile_crops
(round((sum(?fresh_vegetables_melons_strawberries)/sum(?total))*10000))/100.0 as ?fresh_vegetables_melons_strawberries
(round((sum(?temporary_and_permanent_grass)/sum(?total))*10000))/100.0 as ?temporary_and_permanent_grass
(round((sum(?other_crops_on_arable_land)/sum(?total))*10000))/100.0 as ?other_crops_on_arable_land
(round((sum(?fruit_and_berry_plantations)/sum(?total))*10000))/100.0 as ?fruit_and_berry_plantations
(round((sum(?citrus_plantations)/sum(?total))*10000))/100.0 as ?citrus_plantations
(round((sum(?olive_plantations)/sum(?total))*10000))/100.0 as ?olive_plantations
(round((sum(?vineyards)/sum(?total))*10000))/100.0 as ?vineyards
#(sum(?cereals)+sum(?rice)+sum(?maize)+sum(?pulses)+sum(?potatoes)+sum(?sugar_beet)+sum(?rape_and_turnip_rape)+sum(?sunflower)+sum(?textile_crops)+sum(?fresh_vegetables_melons_strawberries)+sum(?temporary_and_permanent_grass)+sum(?other_crops_on_arable_land)+sum(?fruit_and_berry_plantations)+sum(?citrus_plantations)+sum(?olive_plantations)+sum(?vineyards)) as ?check
sum(?total) as ?total
{{
SELECT DISTINCT
?ugeo
?country
bif:either(?indic_ef = indic_ef:M_8_1_2_1_HA, sum(?ef_poirrig),0) AS ?cereals
bif:either(?indic_ef = indic_ef:M_8_1_2_2_HA, sum(?ef_poirrig),0) AS ?maize
bif:either(?indic_ef = indic_ef:M_8_1_2_3_HA, sum(?ef_poirrig),0) AS ?rice
bif:either(?indic_ef = indic_ef:M_8_1_2_4_HA, sum(?ef_poirrig),0) AS ?pulses
bif:either(?indic_ef = indic_ef:M_8_1_2_5_HA, sum(?ef_poirrig),0) AS ?potatoes
bif:either(?indic_ef = indic_ef:M_8_1_2_6_HA, sum(?ef_poirrig),0) AS ?sugar_beet
bif:either(?indic_ef = indic_ef:M_8_1_2_7_HA, sum(?ef_poirrig),0) AS ?rape_and_turnip_rape
bif:either(?indic_ef = indic_ef:M_8_1_2_8_HA, sum(?ef_poirrig),0) AS ?sunflower
bif:either(?indic_ef = indic_ef:M_8_1_2_9_HA, sum(?ef_poirrig),0) AS ?textile_crops
bif:either(?indic_ef = indic_ef:M_8_1_2_10_HA, sum(?ef_poirrig),0) AS ?fresh_vegetables_melons_strawberries
bif:either(?indic_ef = indic_ef:M_8_1_2_11_HA, sum(?ef_poirrig),0) AS ?temporary_and_permanent_grass
bif:either(?indic_ef = indic_ef:M_8_1_2_12_HA, sum(?ef_poirrig),0) AS ?other_crops_on_arable_land
bif:either(?indic_ef = indic_ef:M_8_1_2_13_HA, sum(?ef_poirrig),0) AS ?fruit_and_berry_plantations
bif:either(?indic_ef = indic_ef:M_8_1_2_14_HA, sum(?ef_poirrig),0) AS ?citrus_plantations
bif:either(?indic_ef = indic_ef:M_8_1_2_15_HA, sum(?ef_poirrig),0) AS ?olive_plantations
bif:either(?indic_ef = indic_ef:M_8_1_2_16_HA, sum(?ef_poirrig),0) AS ?vineyards
sum(?ef_poirrig) as ?total
{{
SELECT distinct
?geo
?ugeo
?country
?ef_poirrig
?indic_ef
WHERE {
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/ef_poirrig.rdf.gz> {
_:ef_poirrig sdmx-dimension:timePeriod ?date FILTER (year(?date) = 2010)
_: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 property:irrig irrig:TOTAL .
_:ef_poirrig property:geo ?geo .
_:ef_poirrig sdmx-measure:obsValue ?ef_poirrig .
}
?geo skos:prefLabel ?country .
?geo skos:notation ?ugeo .
?eeageo owl:sameAs ?geo .
?eeageo skos:inScheme <http://rdfdata.eionet.europa.eu/eea/countries/> .
?memberOf skos:member ?eeageo .
?memberOf skos:notation ?memberOfcode . FILTER (?memberOfcode IN ('EEA33'))
}
}}
GROUP BY ?country ?ugeo ?indic_ef
HAVING sum(?ef_poirrig) != 0
}}
GROUP BY ?country ?ugeo
ORDER BY ?country
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/area-covered-by-each-of or scan the QR code.
PDF generated on 10 Dec 2024, 12:06 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