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 42 rows in 0.002 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 tableFile: <http://semantic.eea.europa.eu/project/CSI033/FishStatUnpivot.csv#>
PREFIX countrygroups: <http://dd.eionet.europa.eu/vocabulary/common/countrygroups/>
PREFIX countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>
SELECT
?year
?geoarea
?group
?environment
sum(xsd:decimal(?obsValue)) as ?obsValue
{{
SELECT DISTINCT
?year
?geoarea
?group
bif:either(?environment = 'Brackishwater', 'Marine', ?environment) as ?environment
sum(xsd:decimal(?obsValue))/1000 as ?obsValue
WHERE {
_:rec tableFile:country ?country .
_:rec tableFile:continent ?continent .
_:rec tableFile:iso2 ?iso2 .
_:rec tableFile:speciesGroup ?speciesGroup .
_:rec tableFile:species ?species .
_:rec tableFile:group ?group .
_:rec tableFile:area ?area .
_:rec tableFile:environment ?environment .
_:rec tableFile:unit ?unit .
_:rec tableFile:year ?year .
{
_:rec tableFile:continent ?geoarea .
FILTER (?geoarea != 'Europe')
_:rec tableFile:obsValue ?obsValue .
} UNION {
?member skos:notation ?iso2 .
?geoarea_uri skos:member ?member.
?geoarea_uri ?o countrygroups: .
?geoarea_uri skos:notation ?geoarea .
_:rec tableFile:obsValue ?obsValue .
FILTER (?geoarea_uri in (countrygroups:EU28 ))
} UNION {
{ SELECT 'EEA39' as ?geoarea {} } .
?member skos:notation ?iso2 .
?geoarea_uri skos:member ?member.
?geoarea_uri ?o countrygroups: .
_:rec tableFile:obsValue ?obsValue .
FILTER (?geoarea_uri in (countrygroups:EEA33) ||
?member in (countries:AL, countries:BA, countries:MK,
countries:ME, countries:RS, countries:XK, countries:CS))
}
FILTER (?group in ('PLANTAE AQUATICAE', 'CRUSTACEA', 'PISCES', 'MOLLUSCA'))
FILTER (?year = 2015)
}
GROUP BY ?year ?group ?environment ?geoarea
}}
ORDER BY ?group ?geoarea
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/relative-importance-of-aquaculture-production or scan the QR code.
PDF generated on 05 Jul 2024, 10:28 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