This table contains landings from 1931-1968 by CDFG block for all species by month. This is part of the catch reconstruction program.
| name | value |
|---|---|
| name | [dbo].[CR_BLOCK_SUMMARY] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 442,895 |
| Size of data | 35,416 kb |
| Size of indexes | 344 kb |
| Maximum size of a single row | 78 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 | |||||
| month | int | 10 | 4 | no | composite PK | no | ||||
| block | int | 10 | 4 | no | composite PK | no | CDFG block (10 nm x 10 nm usually) - refer to documentation | |||
| pounds | numeric | 17 | 9 | no | composite PK | no | ||||
| area | varchar | 25 | 25 | no | composite PK | no | general description of the area where the fish were caught | |||
| imported | char | 1 | 1 | no | composite PK | no | Whether the fish were imported - legacy from reconstruction - only non imported fish are in this table | |||
| region_caught | int | 10 | 4 | no | composite PK | no | CDFW region code where fish were caught | |||
| assigned_block | int | 10 | 4 | no | composite PK | no | generic CDFW block where fish were caught | |||
| species_grp | varchar | 15 | 15 | no | composite PK | no | Elasmobranch, Flatfish, Invert, Other, Other_GF, Rockfish, Salmonid, UNK |