Database

1949- 2006 (0610) MS Access Database ( 1949-2006 CalCOFI Hydrographic Data Report Database includes final hydrographic data from 1949- 2006 (0610). This database includes final, published data only. A research version with preliminary data is available by request from the CalCOFI data manager. Latest changes include removal of Ship Code from the Cruz_Sta value. This allows data collected on different ships occupying the same station to link. Some older cruises performed the hydrographic work and biological work on separate ships.

Newest fixes and additions:

8 Sep 2006

Cruz_Sta value does not include Ship Code. Current format is CCYYMMLLLLSSSS where CC is century (19 or 20); YYMM is the usual year-month cruise designation (ex 0602);LLLL is Line; SSSS is Sta. Line & Sta format include the "tenths" value ie Lines are not rounded: line 93 is reported as 93.3, line 87 is 86.7. Santa Barbara Basin is 81.8 46.9, not 82 47. These changes were necessary to distinguish SCCOOS stations from standard stations. This change is reflected in the 0602 IEH file. Please note that current IEH data does not include data collected above line 77.

Order_Occ column added to Cast table. This will be backfilled from the zooplankton database since IEH data does not include this value until 2000.

20 Jan 2006

Added a standard station field to the Station_ID table. ST in the Stnd_Sta column flags the current 66 quarterly-sampled stations.

Fixed Cast_Data Table: Cruz_Num & Int_Chl errors fixed. Parsing error combined the fields for several 80s cruises.

Metafile Description - definitions and format
Design Notes - comments on establishing a standard format and tables for the 50+ years of data
Relationships Tables - relational database links between tables

Comments - CalCOFI IEH-formatted ascii files were sorted by date (not cruise), parsed into comma-delimited ascii files, combined with CalCOFI Data Report values, then imported into Access. Some corrections still needed are: the cruise designation such as 9801 are extracted from the IEH field. If the field was empty (common in early IEHs) the cruise designation (variable Cruz_Nam) was generated from Year and Month automatically. Any query that uses the cruise designation (Cruz_Nam) may not pull all data collected on that cruise - use date and ship instead. Other correction - Gulf of California station latitude & longitudes generate an erroneous Line.Sta number using the standard algorithm. These data were not excluded so the Line.Sta field is not a numeric but text since a “G” designation was reported in many IEHs for those stations. The standard algorithm calculates them as negative station values. See design notes for additional info.
JRW 12/18/2003