This table contains commercial landings by year and CDFG region from 1916-1968. These are the reconstructed landing estimates. This table is used by the website.
| name | value |
|---|---|
| name | [dbo].[RECON_COM_LANDS] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 23,395 |
| Size of data | 1,912 kb |
| Size of indexes | 768 kb |
| Maximum size of a single row | 635 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| year | char | 4 | 4 | no | composite PK | no | Rockfish 1916-1968, all species 1931-1968 | |||
| species | nvarchar | 50 | 200 | no | composite PK | no | ||||
| region_caught | int | 10 | 4 | no | composite PK | no | CDFG Region (1-8) | |||
| gear | nvarchar | 50 | 200 | no | composite PK | no | ||||
| pounds | float | 15 | 4 | no | no | |||||
| source | nvarchar | 50 | 200 | yes | no | RECON1=Reconstruction, Don Block=Block Summary, Don Interp=Interpolated from Block Summary | ||||
| species_grp | varchar | 15 | 15 | yes | no | |||||
| region | nvarchar | 2 | 8 | yes | no |
| name | object type | level |
|---|