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 824 rows in 0.131 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 FishStatUnpivot: <http://semantic.eea.europa.eu/project/CSI033/FishStatUnpivot2019.tsv#>
PREFIX wri_coastline: <http://semantic.eea.europa.eu/project/CSI033/wri_coastline.tsv#>
PREFIX countrygroups: <http://dd.eionet.europa.eu/vocabulary/common/countrygroups/>
PREFIX countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>
select
xsd:integer(?year) as ?year
?country
?group
?wri_coastline
round((sum(coalesce(xsd:double(?FishStatUnpivot),0))/?wri_coastline)*100)/100.0 as ?obsValue
round(sum(coalesce(xsd:double(?FishStatUnpivot),0))/10.0)/100.0 as ?FishStatUnpivot
{{
SELECT DISTINCT
?year
?country
?iso2
?group
?FishStatUnpivot
?wri_coastline
WHERE {
_:FishStatUnpivot FishStatUnpivot:country ?country .
_:FishStatUnpivot FishStatUnpivot:iso2 ?iso2 .
_:FishStatUnpivot FishStatUnpivot:group ?group .
_:FishStatUnpivot FishStatUnpivot:environment ?environment .
_:FishStatUnpivot FishStatUnpivot:year ?year .
_:FishStatUnpivot FishStatUnpivot:obsValue ?FishStatUnpivot .
FILTER (?group IN ('PISCES', 'MOLLUSCA'))
FILTER (?environment = 'Marine')
#FILTER (xsd:integer(?year) = 2016)
FILTER (xsd:integer(?year) >= 1990)
?member skos:inScheme countries: .
?member skos:notation ?iso2 .
?geoarea_uri skos:member ?member.
?geoarea_uri ?o countrygroups: .
FILTER (?geoarea_uri in (countrygroups:EEA33))
_:wri_coastline wri_coastline:geo ?iso2 .
_:wri_coastline wri_coastline:obsValue ?wri_coastline .
}
}}
ORDER BY xsd:integer(?year) ?country ?environment
For references, please go to https://eea.europa.eu./data-and-maps/daviz/sds/marine-aquaculture-production-relative-to-1 or scan the QR code.
PDF generated on 23 Nov 2024, 07:54 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