Database of the Benthic Invertebrate Collection

Access Office 97-98 (Microsoft Corporation) databases containing the published catalogs are available on 3.5 inch IBM formatted floppies, or they can be ordered compressed with WinZip (Nico Mak Conputing, Inc.). The format and a sample output of the database are as follows:

Description of database format:

SCRIPPS_INST_COLLECTIONS.mdb

PHYLUM Text 50
CLASS Text 18
ORDER Text 30
FAMILY Text 21
TAXA_No Numeric (Calculated from above) 15
GENUS Text 35
SPECIES Text 30
GEN & SPECIES Text (Calculated from above two) 50
AUTHOR Text 35
CATALOG_No [PRIME-KEY] Number (Double) 8
ACCESSION_No's Number (Double) 8
STATION Text 35
LOCATION Text 78
DEG_LAT Number (Single) 4
MIN Number (Single) 4
NS Text 1
DEG_LONG Number (Single) 4
MNTS Number (Single) 4
EW Text 1
DEPTH_START Number (Single) 4
DEPTH_END Number (Single) 4
GEAR_USED Text 30
ECOL_NOTES Text 121
DATE TEXT 25
TIME Text 15
SHIP Text 20
COLLECTOR Text 50
DETERMINER Text 30
TYPE Text 11
NOTES_FIELD_CURATORIAL Text 78
FIXATIVE Text 10
No_SPECIMENS_in_LOT Text 10

Example of a Database Report:

APLACOPHORA

CHAETODERMATIDAE

Falcidens hartmani (Schwabl)

M 1823 R-47. San Diego Trough. 32o26'N 117o27'W 1241-1190m Epibenthic sled. Mud. October 22, 1971 R/V Agassiz. Coll. F. Rokop, S. Luke. Det. A. Scheltema.

M 1843 R-17. San Diego Trough. 32o26.8'N 117o28'W 1241-1199m Epibenthic sled. Mud. January 18, 1971 R/V Agassiz. Coll. F. Rokop. Det. A. Scheltema.

M 1948 R-36. San Diego Trough. 32o26"N 117o27'W 1241-1190m Epibenthic sled. Mud. April 20, 1971 R/V Agassiz. Coll. F. Rokop. Det. A. Scheltema.