This table contains estimated commercial landings of all species from expansions for 1969- current year. It is the Best Available Data.
| name | value |
|---|---|
| name | [dbo].[COM_LANDS] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 276,316 |
| Size of data | 19,056 kb |
| Size of indexes | 8 kb |
| Maximum size of a single row | 64 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| year | char | 4 | 4 | no | no | |||||
| quarter | char | 1 | 1 | no | no | 1=Jan-Mar, 2=Apr-Jun, 3=Jul-Sep, 4=Oct-Dec | ||||
| live | char | 1 | 1 | no | no | Were the fish landed live - Y or N | ||||
| mark_cat | int | 10 | 4 | no | no | Market Category (sort group) the fish were landed as. | ||||
| gear_grp | char | 3 | 3 | no | no | |||||
| port_complex | char | 3 | 3 | no | no | |||||
| species | varchar | 4 | 4 | no | no | |||||
| pounds | numeric | 17 | 9 | yes | no | |||||
| source | varchar | 20 | 20 | no | no | Was this record based on Actual samples, borrowing or treated as Nominal - refer to documentation. | ||||
| species_grp | varchar | 15 | 15 | yes | no | INVERT, OTHER, OTHER_GF, ROCKFISH, ELASMOBRANCH, FLATFISH. SALMONID |
| name | object type | level |
|---|