fs_retrospective_scores

89414 rows


Description

Reports the latest retrospective time series of FishSource scores for each GFP

Columns

Column Type Size Nulls Auto Default Children Parents Comments
gfp_id int4 10 null
gfps.id fs_retrospective_scores_gfp_id_fkeyR

unique identifier of the GFP from SFP systems. https://www.fishsource.org/faq

year int4 10 null

year the FS Score refers to

score varchar 40 null

A fishery receives 5 different categories of scores, which evaluate different aspects of the fishery; (1) management stragegy (2) managers compliance (3) fishers compliance (4) current health current stock status future health current fishing pressure. How FishSource works tab at https://www.fishsource.org/how/scores

label varchar 40 null

FishSource score to indicate how the fishery is performing according to globally accepted measures of sustainability. FishSource scores are always numeric, scored on a scale of 0-10, with a score of less than 6 corresponding to to “poor performance”, 6-8 corresponding to “acceptable performance but with improvements needed”, and a score of 8 or above to “strong performance”. When quantitative information is not available for scoring, the scores can be determined qualitatively based on other available information, as ‘categories’ of <6, ≥ 6 or ≥ 8. When information is insufficient to enable scoring, scores may be labelled as “Data Deficient”.More information on the FS scores are developed, and on the stock and management scoring methodology is available at: https://www.fishsource.org/how/scores.

value float8 17,17 null

score to indicate how fishery is performing according to globally accepted measures of sustainability; 3 possible choices for qualitative scores (1) 5.9 assigned to label scores <6 (2) 6.0 assigned to label scores of ? 6 and (3) 8.0 assigned to label scores ? 8. All qualatative scores are per FishSource guidelines. For quantative scores, this variable is the exact score which ranges between 0-10

source_node varchar 40 null

4 possible choices based on the the level at which the FS Score is assigned (1) stock or assessment unit (2) management unit (3) country level (4) GFP (=fishery). Please review infographic at database homepage; also How FishSource works tab at https://www.fishsource.org/how/scores

source_id int4 10 null

unique indentifier of the level the FS Score is being taken from (see infographics in readme file for a more detailed description of how FS Scores are assigned across different levels)

Indexes

Constraint Name Type Sort Column(s)
fs_retrospective_scores_pkey Primary key Asc/Asc/Asc gfp_id + year + score

Relationships