Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
gfp_id | int4 | 10 | null |
|
|
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 |