This table contains trawl log summary data by year and CDFG block for the trawl fishery from 1925-2009.
| name | value |
|---|---|
| name | [dbo].[CR_TRAWL_BLOCK_SUMMARY] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 128,738 |
| Size of data | 8,608 kb |
| Size of indexes | 48 kb |
| Maximum size of a single row | 64 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| year | int | 10 | 4 | no | composite PK | no | ||||
| mark_cat | int | 10 | 4 | no | composite PK | no | ||||
| species | varchar | 4 | 4 | yes | no | |||||
| block | int | 10 | 4 | no | composite PK | no | CDFG block number - refer to documentation. Note that 100, 200,400,500,600, 700, and 800 are generic. | |||
| pounds | int | 10 | 4 | no | composite PK | no | ||||
| region_caught | int | 10 | 4 | no | composite PK | no | CDFG region codes - refer to documentation. | |||
| area | varchar | 25 | 25 | yes | no | A general description of where the fishing occurred | ||||
| species_grp | varchar | 15 | 15 | yes | no | INVERT, OTHER, OTHER_GF, ELASMOBRANCH, SALMONID, ROCKFISH, FLATFISH |