calcom -  tables

This table contains information on how age expansions were done

This table contains expanded age compositions from commercial landings for aged species.

This table contains estimated commercial landings of all species from expansions for 1969- current year.  It is the Best Available Data.

This table contains expanded length compositions for commercial species.

This table contains information about how borrowing was done to produce year end species specific landings found in the COM_LANDS table. Real_ =strata that was expanded, Used_ were the strata borrowed from.

codes used by CDFG on landing receipts for live, dresed, etc...

This table contains landings from 1931-1968 by CDFG block for all species by month.  This is part of the catch reconstruction program.

This table contains trawl log summary data by year and CDFG block for the trawl fishery from 1925-2009.

This table contains trawl effort by month and CDFG block from 1930-1952.  It is part of the Catch Recon program.

This table hold ages for fish collected during the current sample year - it is virtually never used

This table hold cluster data for samples collected during the current year

This table holds individual fish data for samples collected during the current year

this table contaons sample header data for samples collected during the current year

This table contains information about key events and activities in the CCGS.

codes used by CDFG on landing receipts includes live, research, personal use, ...

This table contains age data for flatfish Bin samples (samples based on number of fish, not weight). These are rescued samples.

This table contains cluster data for flatfish Bin samples (samples based on number of fish, not weight). These are rescued sample

This table contains individual fish data for BIN samples (samples based on number of fish not weight)

This table contains header data for flatfish Bin samples (samples based on number of fish, not weight). These are rescued samples.

a code look up table which also shows gear group designations

a list of grade (size) codes used by CDFG on receipts

This table contains information about how borrowing was done to perform length expansions.

This table holds length conversion factors for rockfish. It allows conversion between tl, fl, and sl. Refer to the documentation for usage. The data comes from Echeverria and Lenarz, 1983.  The conversions are: length=a+(b * length) where length is cm.

This table contains descriptions of the market categories (sort groups) used by CDFG and CALCOM.

This table contains ages for fish often with multiple ages.  The Best_age is stored in the MASTER_FISH table.

This table contains cluster data for all port samples except those from the current year.

this table contains individual fish data for all port samples except those caught in the current year.

This table contains sample header data for all port samples except those from the current year

this table contains the maturity codes used in the port samples.  Rockfish use different codes than sablefish. Flatfish maturity codes are no longer used (unreliable).

This table is used when a fish was used but the sample data was incomplete. The age may be okay; however, some key information is missing.

This table contains an inventory of all of the otoliths are in our collection.  Note that some otoliths are stored in coin envelopes, while others are stored in trays.  Those stored in trays give us the ability to track down otoltihs for a specific fish.

a list of port complex codes used in CALCOM

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.

This table contains recreational data from the catch reconstruction project. It includes only rockfish from 1928-1980.

This table contains location data for all commercial groundfish regulations.  It joins on LOCATION_ID in other tables.

This table contains all regulations for federally managed groundfish.

This table contains OYs, ABCs, etc... for groundfish included the commercial regulations component of the database

This table contains the rough boundaries, year of implementation, gear type, and area description of Rockfish Conservation Areas as part of the commercial regulations component of the database

This table allows fulltext queries to retrieve regulations for a species when they may have been managed as part of a group and not just as a separate species.

This table contains CDFG Region codes and descriptions.

This table contains definitions of size sort groups used ijn port samples.

this table contains all species codes used in the CALCOM database