Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
|
|
unique identifier of the GFP from SFP systems. https://www.fishsource.org/faq |
||||||||
| isscfg | varchar | 10 | null |
|
|
gear code adopted by FAO; if a gear type was not recognized by FAO, then the code refers to a SFP internal code. http://www.fao.org/3/a-bt987e.pdf |
||||||||
| stock_name | text | 2147483647 | null |
|
|
name of the biological stock or assessment unit that the gear flag profile is associated with; names are per the assessment organization. https://www.fishsource.org/how/interplay; https://www.fishsource.org/how/structure |
||||||||
| management_unit_name | text | 2147483647 | null |
|
|
management unit name associated with a gear flag profile; names are per FishSource. https://www.fishsource.org/how/interplay; https://www.fishsource.org/how/structure |
||||||||
| name | text | 2147483647 | null |
|
|
name of the gear flag profile; names are per FishSource. https://www.fishsource.org/how/interplay; https://www.fishsource.org/how/structure |
||||||||
| url | varchar | 255 | √ | null |
|
|
webpage of the GFP |
|||||||
| fao_areas | text | 2147483647 | √ | null |
|
|
FAO fishing area code which describes where the fishery takes place. http://www.fao.org/fishery/area/search/en |
|||||||
| species_id | int4 | 10 | null |
|
|
unique identifier of the species/taxa per SFP systems |
||||||||
| iso_alpha3 | varchar | 3 | null |
|
|
|||||||||
| data_last_updated_at | timestamp | 29,6 | √ | null |
|
|
latest update of FS Scores; TBD means that scores have not been developed yet for the GFP |
|||||||
| status | varchar | 40 | null |
|
|
2 possible choices which reflect the status of the GFP in FishSource (1) draft means profile has been developed but it not publicly available (2) live means profile is publically available |
||||||||
| longitude | float8 | 17,17 | √ | null |
|
|
longitude of the centroid of the polygon delineating the boundaries of the GFP |
|||||||
| latitude | float8 | 17,17 | √ | null |
|
|
latitude of the centroid of the polygon delineating the boundaries of the GFP |
|||||||
| t75_seafood_sector | varchar | 2147483647 | √ | null |
|
|
13 choices including (1) Coldwater crab (2) Tuna (3) Large shrimp (4) Octopus (5) Non-T75 (6) Marine Ingredients (7) Salmon (8) Wild classic whitefish (9) Swimming crab (10) Small shrimp (11) Snapper-grouper (12) squid (13) Large Pelagics Note: (1) In the 2018 version of the database, the seafood sector variable was included in the species table. (2) In 2021, there was a revision in the definitions and scope of the following sectors: a) Marine Ingredients; formerly named “Reduction fisheries”, this sector expanded scope and now includes other species that may also partially used for marine ingredients and not already covered by another T75 sector. b) Large Pelagics; This sector now also includes swordfish (Xiphias gladius). c) Wild classic whitefish; This is now a standalone sector (was formerly a subsector of the “Whitefish” sector). It only includes wild production of the “Cods, Hakes, haddocks” ISSCAAP group, and some additional species such as toothfish or New Zealand blue cod. The most recent T75 sector definitions are available in the following webpage: https://sustainablefish.org/impact-initiatives/target-75/t75-sector-definitions/ |
|||||||
| created_at | timestamp | 29,6 | now() |
|
|
|||||||||
| notes | text | 2147483647 | √ | null |
|
|
||||||||
| stock_au_id | int4 | 10 | √ | null |
|
|
SFP FishSource unique identifier of the stock or assessment unit from which the gear flag profile (GFP) is part of. https://www.fishsource.org/faq |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| gfps_pkey | Primary key | Asc | id |