Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| fip_uuid | varchar | 36 | null |
|
|
unique identifier of the FIP from SFP systems |
||
| status | varchar | 40 | null |
|
|
Currently, there are seven possible categories and refers to the status of the FIP at a given time point; (1) active FIPs are currently ongoing, (2) completed FIPs have met their objectives (3) In assessment FIPs have apparently met their objectives and underoing MSC Full assesment. In assessment status was only developed in 2024 (4) inactive FIPs are no longer active because of missed reporting or implementer chose to end (5) pre-FIP FIPs only have an evaluation (are at Stage 1) (6) intended FIPs have publically acknowledged they want to implement a FIP (Stage 0) (7) NA means a FIP existed but its stage rating was not recorded in a given year. https://drive.google.com/file/d/1AWDDJmwuJ7j-AOpgru5bE7-d5BO6q4wc/view; https://www.fishsource.org/improvement-project; https://fisheryprogress.org/ |
||
| year | int4 | 10 | null |
|
|
Year that the FIP information (status, reported volume, rating, etc) refers to. Same as the dB version year |
||
| volume | float8 | 17,17 | √ | null |
|
|
Volume of catch (thousands of mt) covered by the FIP as reported by the FIP implementer to fisheryprogress.org or other FIP related page; data from 2016 and 2017 is NA because volume is a static variable reported for the most recent year. Data is blank for intended FIPs, FIPs reporting to fisheryprogress.org as of November 2024 but with no volume data, or those not reporting in other FIP pages but not publishing FIP volumes publicly. |
|
| progress_rating | varchar | 40 | √ | null |
|
|
Ten possible categories and refer to the frequency of FIP improvements in a given year (1) A, advanced progress (2) B, good progress, (3) C, some recent progress (4) D, some past progress (5) E, neglibible progress (6) intended FIPs (7) pre-FIPs, (8) completed FIPs (9) in assessment (10) inactive FIPs. See Status variable for definition of 6-10. https://drive.google.com/file/d/1AWDDJmwuJ7j-AOpgru5bE7-d5BO6q4wc/view |
|
| type | varchar | 40 | √ | null |
|
|
Two possible categories (1) Basic FIPs are those that were started to address a select number of specific issues in a fishery, typically disregarding certain other issues (2) Comprehensive FIPs are established after a comprehensive review of overall fishery sustainability (based on MSC indicators), and the issues needing improvement are included in the resulting FIP workplan. https://www.sustainablefish.org/Media/Files/FIP-Toolkit/FIP-Evaluation-A-standardized-tool-for-measuring-FIP-progress-2017; https://improvements.msc.org/database/streamlining/documents/MSC_Performance_Indicators_Explained_v1.pdf/view; http://solutionsforseafood.org/wp-content/uploads/2015/03/Alliance-FIP-Guidelines-3.7.15.pdf |
|
| created_at | timestamp | 29,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fips_stats_pkey | Primary key | Asc/Asc | fip_uuid + year |
Diagram producer might be missing
No diagrams were produced please see application output for any errors