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 840 rows in 0.020 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 tableFile: <http://semantic.eea.europa.eu/project/CSI033/FishStatUnpivot2019.tsv#>
PREFIX countrygroups: <http://dd.eionet.europa.eu/vocabulary/common/countrygroups/>
PREFIX countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>
SELECT DISTINCT
xsd:integer(?year) as ?year
?geoarea
?area
bif:either(?speciesGroup = 'PISCES', 'Miscellaneous fishes', ?speciesGroup) as ?species
round(sum(xsd:double(?obsValue))/10.0)/100.0 as ?obsValue
WHERE {
_:rec tableFile:iso2 ?iso2 .
{
_:rec tableFile:speciesGroup ?speciesGroup .
} UNION {
_:rec tableFile:species ?speciesGroup .
} UNION {
_:rec tableFile:group ?speciesGroup .
}
FILTER (?speciesGroup in ('Atlantic salmon', 'European seabass', 'Gilthead seabream',
'Atlantic bluefin tuna', 'Sea trout', 'Rainbow trout',
'European eel', 'Brown seaweeds', 'Mussels', 'Oysters',
'Carps, barbels and other cyprinids', 'PISCES'))
_:rec tableFile:area ?area .
_:rec tableFile:environment ?environment .
_:rec tableFile:unit ?unit .
_:rec tableFile:year ?year .
?member skos:inScheme countries: .
?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, countrygroups:EEA39 ))
FILTER (xsd:integer(?year) > 1992)
}
ORDER BY ?geoarea xsd:integer(?year) ?group ?species ?area
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/annual-aquaculture-production-of-main-species-1 or scan the QR code.
PDF generated on 05 Jul 2024, 10:29 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