Database Metafile

Station_ID (Station ID & Desired Position)   ID  Autonumbered Long Integer Sta_ID  LineSta Text Line CalCOFI Line Text Sta  CalCOFI Station Integer DLat_Dec Desired Position Decimal Latitude Single DLat_Deg Desired Position Lat Degrees Integer DLat_Min Desired Position Lat Minutes Single DLat_Hem Desired Position Lat Hemisphere Text DLon_Dec Desired Position Decimal Longitude Single DLon_Deg Desired Position Lon Degrees Integer DLon_Min Desired Position Lon Minutes Single DLon_Hem Desired Position Lon Hemisphere Text Stnd_Sta ST denotes current standard station Text       Cast_Data (Station Cast Observed Information)   Cst_Cnt Autonumbered - 1 is first sta done Long Integer Sta_ID See Description Text Cast_ID  See Description Text Quarter  1, 2, 3, or 4 Integer Date  Cast Date UTC Date/Time Year  Cast Year UTC Integer Month Cast Month UTC Integer Julian_Day  Cast Julian Day UTC (1=Jan 1) Integer Time  Cast Time UTC Date/Time Lat_Dec Observed Latitude Decimal Degrees Single Lat_Deg Observed Latitude Degrees Integer Lat_Min Observed Latitude Minutes Single Lat_Hem Observed Latitude Hemisphere Text Lon_Dec Observed Longitude Decimal Degrees Single Lon_Deg Observed Longitude Degrees Integer Lon_Min Observed Longitude Minutes Single Lon_Hem Observed Longitude Hemisphere Text Line  IEH-Reported Line Text StndL  Nearest Standard Line Integer CalcLine  Calculated Line Integer Sta  IEH-Reported Station Integer StndS  Nearest Standard Station Integer CalcSta  Calculated Station Integer Bottom_D Bottom Depth meters Integer ShipName Ship's Name Text Ship_Code Ship's NODC Code Text Data_Type  See Description Text Orig_Sta_ID IEH-Reported Station ID Text Cruz_Num YYMM Cruise Designation Text IntChl Integrated Chlorophyll Single       Bottle_Data (Hydrographic Bottle Data)   Cst_Cnt Autonumbered Cast Count Long Integer Btl_Cnt Autonumbered Bottle Count Long Integer Sta_ID  See Description Text Depth_ID See Description Text Depthm  Bottle Depth meters Integer T_degC  Temperature degrees C Single Salnty  Salinity Single O2ml_L  Oxygen ml/L Single STheta  Density as sigma-theta Single O2Sat Oxygen Saturation % Single RecInd Record Indicator Integer       Nutrient_Data  (Bottle Nutrient Data)   Btl_Cnt Autonumbered Bottle Count Long Integer PO4ug Phosphate uM/L Single PO4q Phosphate quality Integer SiO3ug Silicate uM/L Single SiO3q  Silicate quality Integer NO2ug Nitrite uM/L Single NO2q Nitrite quality Integer NO3ug Nitrate uM/L Single NO3q Nitrate quality Integer       Chla_Data  (Chlorophyll Data Table)   Btl_Cnt Autonumbered Bottle Count Long Integer ChlorA  Chlorophyll-a ug/L Single Chlqua  Chlorophyll-a quality Integer Phaeop  Phaeopigments ug/L Single Phaqua  Phaeopigments quality Integer       Bottle_Qual (Bottle Data Precision-Quality Codes)   Btl_Cnt  Autonumbered Bottle Count Long Integer T_prec  Temperature precision Integer T_qual  Temperature quality Integer S_prec  Salinity precision Integer S_qual  Salinity quality Integer O_qual  Oxygen precision Integer SThtaq  Sigma-theta quality Integer O2Satq  Oxygen saturation quality Integer       Prodo_Cast (Primary Productivity Cast Info)   Cst_Cnt Autonumbered Cast Count Long Integer Cast_ID  See Description Text Inc_Str  Incubation Start Time PST Date/Time Inc_End  Incubation End Time PST Date/Time PST_LAN  Local Apparent Noon PST Text Civil_T  Civil Twilight PST Date/Time TimeZone  Timezone (+8) Text IntC14  Integrated C14 Assimilation Single       Prodo_Data (Primary Productivity-C14 Uptake)   Cst_Cnt Autonumbered Cast Count Long Integer Btl_Cnt Autonumbered Bottle Count Long Integer C14As1 C14 Assimilation Sample 1 Single C14A1p C14 Assimilation Sample 1 precision Integer C14A1q C14 Assimilation Sample 1 quality Integer C14As2 C14 Assimilation Sample 2 Single C14A2p C14 Assimilation Sample 2 precision Integer C14A2q C14 Assimilation Sample 2 quality Integer DarkAs  C14 Assimilation Dark Sample  Single DarkAp  C14 Assimilation Dark Samp precision Integer DarkAq  C14 Assimilation Dark Samp quality Integer MeanAs C14 Mean Assimilation Single MeanAp C14 Mean Assimilation precision Integer MeanAq C14 Mean Assimilation quality Integer IncTim Incubation Time Date/Time LightP  Light Level-Percentage Single       Weather_Data  (uses WMO Weather Codes)   Cst_Cnt Autonumbered - 1 is first sta done Long Integer Wave_Dir Wave Direction Code Integer Wave_Ht Wave Height Code Integer Wave_Prd Wave Period Code Integer Wind_Dir Wind Direction Code Integer Wind_Spd Wind Speed Code Integer Barometer Barometric pressure Single Dry_T  Dry Temperature Single Wet_T Wet Temperature Single Wea Weather Code Integer Cloud_Typ Cloud Type Code Integer Cloud_Amt Cloud Amount Code Integer Visibility Visibility Code Integer Secchi Secchi Depth Integer ForelU Forel Color Scale Integer       Rpt_Data (CalCOFI Data Report Data)   Btl_Cnt Autonumbered Bottle Count Long Integer R_Depth Reported Depth meters Integer R_TEMP  Reported Temperature deg C Single R_POTEMP  Reported Potential Temperature Single R_SALINITY  Salinity Single R_SIGMA Sigma-theta Single R_SVA Specific Volume Anomaly Single R_DYNHT  Dynamic Height Single R_O2  Oxygen ml/L Single R_O2Sat Oxygen Saturation % Single R_SIO3  Silicate Single R_PO4  Phosphate Single R_NO3  Nitrate Single R_NO2  Nitrite Single R_CHLA Chlorophyll-a Single R_PHAEO  Phaeopigments Single R_PRES  Pressure db Integer R_SAMP Sample number Integer