Home Archived October 29, 2018
SOFIA Data Exchange SOFIA homepage Data Exchange homepage
Big Cypress National Preserve Inventory & Monitoring Data
   Location Map
   Sites Listing

Related Project:
   Quant. Sampling of Freshwater Fish Species within the BICY



Big Cypress National Preserve Fish Inventory & Monitoring Data

Data Format

Data are available as Access® Database (.mdb) and as worksheets within Excel® Spreadsheet (.xls). Click on links below to see list of database tables and fields, and list of spreadsheet fields.

Fish Inventory Database | Fish Monitoring and Assessment

Big Cypress National Preserve Fish Inventory Database

Admin_Units: This table lists the administrative divisions of BICY. It is used to populate a field in the Sample Locations table. It contains 2 fields:

Admin_ID- this is a numeric field that serves as the primary key of the table and also links to the "Sample Locations" table

Unit- lists the BICY administrative units

Catch Info: Records of all individuals captured are stored in this table. An individual record represents a single species present in a sample. The total number of individuals of that species is recorded in one of this table's fields. The table contains a total of 24 fields:

Capture_ID- primary key field

Sample_ID- links to Sample Info table, and identifies the sample which generated the capture

Species_ID- this field is populated via a link to the "Speciestable" table. It records the species captured

Number- the total number of individuals of the species present in the sample

Length1 - Length20- the total length of up to 20 individuals of the species captured. If more than 20 individuals were present in a sample, 20 were selected at random and measured, and these measurements were taken to be representative of the overall sample population

Habitat_Types: This table lists the habitat categories used to define the communities sampled in BICY. The habitat types roughly correspond to those defined by Duever et al (1986). It contains 2 fields:

Habitat_ID- primary key field, also links to "Sample Locations" table

Habitat- contains the listing of habitat categories

Sample Info: Each record in this table identifies a single sampling event- for instance, an electrofishing transect or a single deployment of a given type of trap. The table consists of the following eight fields:

Sample ID- primary key field

Gear ID- this field is populated via a link to the "Sampling Gear Types" table. It identifies the method used to acquire the sample

Trip ID- this provides a link to the "Sampling Expedition Info" table and identifies the sampling trip from which each sample was drawn

Repetition Number- lists the repetition number for samples of which multiple repetitions were performed

Total Repetitions- total number of repetitions of a given sampling technique performed during the sampling trip

Duration- the length of time that sampling gear was deployed or used

Water Depth- the depth at which static pieces of sampling gear were deployed

Notes- a memo field for recording any other information regarding a sample

Sample Locations: Data describing the physical location of each sampling site are recorded in this table. The fields are as follows:

Site ID- primary key identifying each sample site

UTM North- the northing coordinate of each site, in UTM zone 17N, NAD83 meters

UTM East- the easting coordinate of each site, in UTM zone 17N, NAD83 meters

Admin ID- populated from the "Administrative Units" table

Habitat ID- populated from the "Habitat Types" table

Region- this field identifies the geographic region of Big Cypress in which a site was located. Any site located north of I-75 is identified as "North", while any site south of US 41 is identified as "South". The remaining sites are identified as "Central".

Sampling Expedition Info: Physical data for each sampling trip are recorded in this table. It consists of the following fields:

Trip ID- primary key identifying each sampling trip

Site ID- provides a link to the geographic information stored in the "Sample Locations" table. This data is segregated into a separate table to allow for the possibility of sampling the same site at different times.

Temperature- water temperature in degrees Celsius

Dissolved Oxygen- Mg/l of water column dissolved oxygen during sampling

Salinity- water column salinity, in PSU

pH- water column pH during sampling

Date- date of sampling trip

Time- time of sampling trip

Notes- memo filed for recording any other relevant information for each sampling trip

Sampling Gear Types: this table lists all sampling methods employed during this study. It contains 3 fields:

Gear ID- primary key

Method- the name of the sampling technique (ie, angling, cast net, etc)

Description- a fuller description of each sampling method

Speciestable: a master list of all species that are expected to occur in BICY. This table contains information that is used to populate fields in the ‘Catch Info" table. It contains these fields:

Species ID- primary key

Species Name- The scientific name of each species, including both genus and species names

Genus- the genus of each species

Family- the family of each species

Common Name- the common name of each species

Voucher Info: this table contains information on all voucher specimens collected during this project. It contains the following fields:

Voucher ID- primary key

Species ID- the species of each voucher, populated via a link to the "Speciestable" table

Sample ID- the sample from which each voucher was drawn

Duever, M. J., J. E. Carlson, J. F. Meeder, L.C. Duever, L. H. Gunderson, L.A. Riopelle, T. R. Alexander, R. L. Myers, and D. P. Spangler. 1986. The Big Cypress National Preserve. National Audubon Society, New York pp 455.

Big Cypress National Preserve Fish Monitoring and Assessment

Sample Locations

UTM-N- for each plot

UTM-E- for each plot

Physical parameters

water temp- Degrees Celsius

dissolved O2- % and concentration in mg/l


Conductivity- uS/cm

weather conditions

Trap type

Drop trap

Array trap

Throw trap

Biological parameters

Species- Scientific name of fishes and invertebrates captured

Length- Standard lengths (mm) for each specimen

Mass- Wet weight (g) for each specimen

To top of page

| Disclaimer | Privacy Statement | Accessibility |

U.S. Department of the Interior, U.S. Geological Survey
This page is: http://sofia.usgs.gov/exchange/loftus_bicy/loftus_bicyformat.html
Comments and suggestions? Contact: Heather Henkel - Webmaster
Last updated: 15 January, 2013 @ 12:42 PM (KP)