Documentation For the CALCOM Database

 

CALCOM is the database used by the California Cooperative Groundfish Survey. It is the repository for all raw and processed data from the program. Some of these data are available from PacFIN; however, PacFIN is not updated as often as CALCOM and does include all of the datasets available. Most of the data is for groundfish; however, we have landings for all commercial species from California from 1916 through the current year. The data managers are committed to making the data readily available to all users. To this end, we support three methods of obtaining data from the system: 1) via this website, 2) through direct connections to the database, and 3) by requesting us to extract the data for you. Note that data governed by confidentiality is not available through this website.

Direct access using Open DataBase Connectivity (ODBC) is a technology that allows a huge variety of programs, working on on virtually any operating system, to directly access relational databases. Some of the programs that can use this technology are: Microsoft Access, Excel, R, SAS, Matlab, Visual Studio and ARC View. For more information about making ODBC connections to CALCOM, contact Don Pearson (NMFS).

The third method of access is by contacting the data managers and having us extract the data for you. This is the appropriate method for one time access, or for complicated data requests. The data managers will respond as promptly as possible.

 

Summary of Available Data

Master Database Documentation

CDFG Blocks, Port Complexes and Coastal Regions Charts

Code lists

User access forms and otolith request form

Useful Literature

 

DATA ACCESS PAGES

RETURN TO HOME PAGE