Occurrence

Florida Fish and Wildlife Conservation Commission - Freshwater Fishes of Florida - 1956-2000

Latest version published by United States Geological Survey on 12 June 2018 United States Geological Survey
This dataset consists of fisheries collection information from the Florida Fish and Wildlife Conservation Commission's Division of Fisheries regional and field offices. The dataset was developed to identify and map freshwater species occurrences throughout Florida. These data are the results of data collection/processing by the Florida Fish and Wildlife Conservation Commission for many federally funded fisheries projects. These data were compiled into a comprehensive and standardized fisheries database for the Florida Fish and Wildlife Conservation Commission from various data programs and paper files. Collection location coordinates were based upon limited global positioning system (GPS) information, written information, the use of digital orthophoto quadrangles, digital raster graphic ma... More
Publication date:
12 June 2018
License:
CC0 1.0

Description

This dataset consists of fisheries collection information from the Florida Fish and Wildlife Conservation Commission's Division of Fisheries regional and field offices. The dataset was developed to identify and map freshwater species occurrences throughout Florida. These data are the results of data collection/processing by the Florida Fish and Wildlife Conservation Commission for many federally funded fisheries projects. These data were compiled into a comprehensive and standardized fisheries database for the Florida Fish and Wildlife Conservation Commission from various data programs and paper files. Collection location coordinates were based upon limited global positioning system (GPS) information, written information, the use of digital orthophoto quadrangles, digital raster graphic maps, and ArcView programs to obtain an estimated latitude and longitude for each fish collection site.

Data Records

The data in this occurrence resource has been published as a Darwin Core Archive (DwC-A), which is a standardized format for sharing biodiversity data as a set of one or more data tables. The core data table contains 69,111 records.

This IPT archives the data and thus serves as the data repository. The data and resource metadata are available for download in the downloads section. The versions table lists other versions of the resource that have been made publicly available and allows tracking changes made to the resource over time.

Downloads

Download the latest version of this resource data as a Darwin Core Archive (DwC-A) or the resource metadata as EML or RTF:

Data as a DwC-A file download 69,111 records in English (4 MB) - Update frequency: not planned
Metadata as an EML file download in English (41 kB)
Metadata as an RTF file download in English (38 kB)

Versions

The table below shows only published versions of the resource that are publicly accessible.

How to cite

Researchers should cite this work as follows:

Florida Fish and Wildlife Conservation Commission (FWC). 2018. Freshwater Fishes of Florida - 1956-2000. Dataset. Florida Fish and Wildlife Conservation Commission, Division of Fisheries. Tallahassee, FL, USA. (Accessed through Biodiversity Information Serving Our Nation (BISON), https://bison.usgs.gov, YYYY-MM_DD)

Rights

Researchers should respect the following rights statement:

The publisher and rights holder of this work is United States Geological Survey. To the extent possible under law, the publisher has waived all rights to these data and has dedicated them to the Public Domain (CC0 1.0). Users may copy, modify, distribute and use the work, including for commercial purposes, without restriction.

GBIF Registration

This resource has been registered with GBIF, and assigned the following GBIF UUID: c5126b60-6dc3-428b-b479-15a921199da1.  United States Geological Survey publishes this resource, and is itself registered in GBIF as a data publisher endorsed by U.S. Geological Survey.

Keywords

Freshwater fishes; Occurrence; Family; Genus; Species; Subspecies; Metadata; Observation

Contacts

Who created the resource:

Theodore Hoehn
Biologist
Florida Fish and Wildlife Conservation Commission
620 S. Meridian Street, MS 5B5
32399-1600 Tallahassee
Florida
US
(850) 488-8792
http://myfwc.com/
Eric Nagid
Subsection Leader
FWC - Fisheries Field Office
7922 NW 71st Street
32653 Gainesville
Florida
US
(352) 273-3651
http://myfwc.com/

Who can answer questions about the resource:

Theodore Hoehn
Biologist
Florida Fish and Wildlife Conservation Commission
620 S. Meridian Street, MS 5B5
32399-1600 Tallahassee
Florida
US
(850) 488-8792
http://myfwc.com/
Eric Nagid
Subsection Leader
FWC - Fisheries Field Office
7922 NW 71st Street
32653 Gainesville
Florida
US
(352) 273-3651
http://myfwc.com/

Who filled in the metadata:

Elizabeth Martin
Biologist
United States Geological Survey
7920 NW 71st Street
32653 Gainesville
Florida
US
(352) 264-3485
https://www.usgs.gov/
Theodore Hoehn
Biologist
Florida Fish and Wildlife Conservation Commission
620 S. Meridian Street, MS 5B5
32399-1600 Tallahassee
Florida
US
(850) 488-8792
http://myfwc.com/

Who else was associated with the resource:

Content Provider
Theodore Hoehn
Biologist
Florida Fish and Wildlife Conservation Commission
620 S. Meridian Street, MS 5B5
32399-1600 Tallahassee
Florida
US
(850) 488-8792
http://myfwc.com/
Processor
Eric Nagid
Subsection Leader
FWC - Fisheries Field Office
7922 NW 71st Street
32653 Gainesville
Florida
US
(352) 273-3651
http://myfwc.com/

Geographic Coverage

Statewide geographic extent for the State of Florida

Bounding Coordinates South West [24.514, -87.659], North East [31.001, -80.006]

Taxonomic Coverage

Fishes captured in sample collections were identified to family and species.

Kingdom  Animalia
Class  Teleostei,  Holostei,  Chondrostei,  Chondrichthyes,  Cephalaspidomorphi

Temporal Coverage

Start Date / End Date 1956-01-01 / 2000-01-01

Project Data

These data are the results of data collection/processing by the Florida Fish and Wildlife Conservation Commission (FWC) for many federally funded fisheries projects. All available data, contained in the original field data information, were entered into an Access database. The database was developed using Microsoft Access 2000. Vernacular names were cross-referenced to the Integrated Taxonomic Information System (ITIS) standard scientific nomenclature. Lake location information was processed using GPS when available or ArcView software in combination with USGS drg 1:100,000 scale maps or 1:24,000 DOQQs. Spatial point and river reach information is an estimate based upon written descriptions. Accuracy has not been statistically determined. Electronic data were compared against hard copies of the original data.

Title Freshwater Fishes of Florida Database - 1956-2000
Funding USGS State Partnership grant 99HQAG0049

The personnel involved in the project:

Processor
William Sheaffer
Metadata Provider
Ted Hoehn
Processor
Eric Nagid

Sampling Methods

Sampling method - Electrofishing: Backpack electrofishing was conducted in wadable streams. Boat mounted electrofishing was conducted in the rivers and lakes. Backpack electrofishing was conducted in three consecutive 100 meter reaches of the streams for a total of 300 meter sampling reach. At the end of the three hundred meter reaches, fish were identified and released or preserved. Boat mounted electrofishing was conducted in three ten minute transects for a total of 30 minutes of pedal time. Fish were identified, weighed, measured, and some preserved for separate otolith analysis at the end of each transect. Sampling method - Block Net: Nets covering usually 0.25 acres, or in some cases up to one acre, were set at sites along the lakeshore or within the river/stream. For rotenone sampling, rotenone was introduced into the sampling area and fish are collected every day for a period of three days. Fish were identified and weighed, with the second and third day fish weights extrapolated due to decomposition. Often marked fish were introduced into the sampling area for purposes of measuring sampling efficiency.

Study Extent Geographic extent: State of Florida. Temporal extent: beginning date - 1956, ending date - 2000. The original data entry into the database started in 2000 incorporating first records from the 1990-2000 period and then going back in time.

Method step description:

  1. Original compilation of the FLA_FISHES database by Florida Fish and Wildlife Conservation Commission staff: Data that contained all species samples were obtained from the Florida Fish and Wildlife Conservation Commission (FWC) field offices. The priority were data from 1990 to 2000, however, all data prior to this period were also obtained if possible. Data collected in the 1990-2000 period were generally electronically available, whereas, data prior to 1990 were generally available through hard copies. Electrofishing and block net gears were the only data obtained for lakes and reservoirs, although other gears were obtained for river and stream data. Data from the field offices were copied onto 3.5" diskettes and labeled. The data were then copied to the main computer containing the fisheries database. The data were manipulated with the following headers in the fisheries database to relate to the database input format (the following are field names in original FLA_FISHES.mdb database): FCODE; FISHCODE; NO; TL_CM; TL_MM; SL_MM; WT_GR; CALC_WT; MARKED; REMOVED. Each waterbody was given a unique numbered FCODE, and individual fish species were given a unique four-lettered FISHCODE. Data manipulations included ensuring total lengths were in cm units, and individual weights were given in grams. When data were properly organized, sample information was written down which included information such as month, year, date, pedal time or net area, vegetative info, and comments for example. The file was then given a new file name and saved as a .dbf file format. The program used for the data entry was opened. Upon choosing the correct waterbody for data entry, sample information was entered and then the program asked for the file name from where the data were to be retrieved and the data were automatically entered into the database. The database consisted of several files that were linked by a common field. The .dbf files were EF_SAMPL, EF_DATA, BN_SAMPL, BN_DATA, FISHLIST, AND WATERBDY. Each waterbody that had sample information was identified. Field notes and maps were used to determine sampling locations. If GPS coordinates were obtained, the latitude and longitude in decimal degrees were entered into the corresponding fields in the WATERBDY table. If no GPS coordinates were provided, coordinates were obtained using ArcView software and USGS 1:100,000 drg maps and 1:24,000 DOQQs. Once the sampling location was determined, the USGS 8-digit HUC, NHD reach identifier, and the unique watershed number contained in the Florida Department of Environmental Protection's drainage basin 1995 GIS coverage was also entered into the appropriate fields. Spatial Reference Information in original metadata of Access database: Horizontal_Coordinate_System_Definition Geographic: - Latitude_Resolution: .0588 - Longitude_Resolution: .0681 - Geographic_Coordinate_Units: Decimal degrees Geodetic_Model: - Horizontal_Datum_Name: North American Datum of 1983 - Ellipsoid_Name: Geodetic Reference System 80 - Semi-major_Axis: 6378137 - Denominator_of_Flattening_Ratio: 298.257
  2. Processing of FLA_FISHES database by U.S. Geological Survey staff for submission to Biodiversity Information Serving Our Nation (BISON) and the Global Biodiversity Information Facility (GBIF): Step 1 - File conversion of original MS Access database The original Access database (FLA_FISHES.mdb) was converted from an older format (MS Access 2000) into a newer MS Access 2010 database format (FLA_FISHES.accdb) that could be opened by a current version of the Microsoft Access software. Step 2 - Data processing in MS Access The FLA_FISHES.accdb database contained a set of files/tables linked together by common fields for each of the sampling methods of block net and electrofishing. Processing of the data in Access was done separately for each sampling method. Processing included correcting a couple of identified items in the original database per communications with FWC staff. In the EF_DATA table those corrections included: correcting the SCODE for record FWCEF24284 from '542400002481' to the correct SCODE of '542400002591', and correcting a FISHCODE from 'EF_S' to correct FISHCODE of 'SUBA'. In the BN_SAMPL table corrections included correcting an AVG_DEPM of '6800' to '0' to be consistent with other samples in the same area, and in the COLLECTOR field replacing all instances of the 'GFC' acronym with 'Game and Fish Commission' since potential users of these data may not know what the acronym stands for (former name of the Florida Fish and Wildlife Conservation Commission). In the EF_SAMPL table, the 'GFC' acronym was replaced with 'Game and Fish Commission' in the COLLECTOR field. To create a flat table for the combined block net data, sequential queries of BN_Data with BN_SAMPL, FISHLIST and WATERBDY where conducted in that order in Access to create a flat table that contained the relevant data from each of the original database files (tables). Similarly, sequential queries of EF_Data, EF_SAMPL, FISHLIST and WATERBDY were conducted to generate a flat table of the combined electrofishing data. From both of the resulting flat tables, records that had a FISHCODE of TOTL (Grand Total), UNSP (unidentified species), OFF (Other freshwater species) and OSF (Other saltwater species) were removed from the tables since those records were not identified to the genus or species scientific name level. The resulting flat tables for each method were exported as EF_Full_Flat.csv and BN_Full_Flat.csv files for further processing with RStudio.
  3. Processing of FLA_FISHES database by U.S. Geological Survey staff for submission to Biodiversity Information Serving Our Nation (BISON) and the Global Biodiversity Information Facility (GBIF): Step 3 - Data processing in RStudio of individual block net and electrofishing tables A comma delimited text file for each sampling method (Block net - BN_Full_Flat.csv; Electrofishing - EF_Full_Flat.csv) was uploaded into RStudio for further processing. Because the two sampling methods were different, some of the fields in each table were different between the two files. In addition, the tables had several fields that were outside the standard fields that could be mapped with a one-to-one correspondence in BISON. For these reasons, several of these different or non-standard fields were concatenated in each table into new fields developed during data processing for BISON that could be mapped to fields in the DarwinCore data exchange schema standard when submitting the data to the Global Biodiversity Information Facility (GBIF) or at least to the general_comments field which is available in BISON. The following derived fields were created in the flat tables during data processing for BISON. These derived fields were based (except when noted) on original fields in the tables for the block net and electrofishing methods. For the block net method, the derived field 'samplingProtocol' is a concatenation of the following fields: - Method - Field added to the dataset during BISON processing to denote the sampling method. A value of 'Block Net' was added to all records that originated from the BN_data block net table of the original database. - SCODE - Unique code used to link the block net data (Bn_data table) to the Bn_sample table in the original MS Access database. During creation of the original database by FWC, the data entry program calculated the SCODE based upon the Watrbody code and number of sampling events. - PROJECT_NO - FWC project number indicating the FWC biologist collecting the data. This was determined by the FWC based upon grants or other project funding. - SAMPLE_NO - Name or number of the block net sample. - NO_NETS - Number of block nets included in the sample. - NETSIZE_HA - Total net size in hectares. This is a calculated value. - GEAR - Method used to kill the fish. BB = Blocknet Blasting, BR = Blocknet Rotenone, CB = Cove blasting, CR = Cove Rotenone. - PER_EM - Percent of the blocknet that is covered by emergent vegetation. - PER_SUB - Percent of the blocknet that is covered by submerged vegetation. - LIT_LIM - Whether the net is set in the littoral or limnetic area of the waterbody. Lit = Littoral areas, Lim = Limnetic area. - AVG_DEPM - Average depth of the net in meters. For the electrofishing method, the derived field 'samplingProtocol' is a concatenation of the following fields: - Method - A value of 'electrofishing' was added to all records that originated from the EF_data electrofishing table of the original database. - SCODE - Unique code used to link the electrofishing data (EF_data table) to the EF_sample table in the original MS Access database. During creation of the original database by FWC, the data entry program calculated the SCODE based upon the Watrbody code and number of sampling events. - PROJECT_NO - FWC project number indicating the FWC biologist collecting the data. This is determined by the FWC based upon grants or other project funding. - SAMPLE_NO - Name of the particular sample. - NO_TRANS - Number of electrofishing transects included in the sample. - PT_SEC - Pedal time in seconds. - GEAR - Method of Electrofishing used in the sample. Electrofishing gear - backpack, shocker boat. - TIME_DAY - Time of sampling event. Day, Night. - NO_DIPS - Number of people dipping used to collect the fish. - SEASON - Season of year. The season of the year: SP = Spring, SU = Summer, FL = Fall, WR = Winter. For the block net method, the derived field 'occurrenceRemarks' is a concatenation of the following fields: - MIN_CM - minimum total length (cm) for the particular species collected during the sample. - MAX_CM - Maximum total length (cm) for the particular species collected during the sample. - NUMBER - Total number of the particular species collected during the sample. - WT_GRAMS - Total weight (g) of the particular species collected during the sample. - PERCENT_NO - Percent of the total number that this species makes up for the sample. - PERCENT_WT - Percent of the total by weight that the species makes up for the sample. - HARNO_HA - Harvestable number of the particular species collected per hectare. - HARWTKG_HA - Harvestable weight (kilograms) of the particular species per hectare. - NUM_HARV - Number of the particular species that are of harvestable size. - WT_HARV - Weight (g) of the particular species that are of harvestable size. - PER_HARVNO - Percent of the harvestable number that the species makes up for the sample. - PER_HARVWT - Percent of the harvestable weight that this species makes up for the sample. - DATA_TYPE - Whether the data collected in the sample was in English (E) or Metric (M) units. - TOTNO_HA - Total number of fish collected per hectare. - TOTWTKG_HA - Total weight in kilograms of fish collected per hectare. For the electrofishing method, the derived field 'occurrenceRemarks' is a concatenation of the following fields: - MIN_CM - Minimum total length (cm) for the particular species collected during the sample. - MAX_CM - Maximum total length (cm) for the particular species collected during the sample. - NUMBER - Total number of the particular species collected during the sampling event. - WT_GRAMS - Total weight (g) of the particular fish species collected during the sampling event. - PERCENT_NO - Percent of the total by number that this species makes up for the sample. - PERCENT_WT - Percent of the total by weight that the species makes up for the sample. - HARNO_MN - Harvestable number of the particular species collected per minute of pedal time. - HARWTG_MN - Harvestable weight (g) of the particular species per minute of pedal time. - NUM_HARV - Number of the particular species that are of harvestable size. - WT_HARV - Weight of the particular species that are of harvestable size. - PER_HARVNO - Percent of the harvestable number that this species makes up for the sample. - PER_HARVWT - Percent of the harvestable weight that this species makes up for the sample. - DATA_TYPE - Whether the data collected in the sample was in English (E) or Metric (M) units. - TOTNO_MN - Total number of the particular species collected per minute of electrofishing pedal time. - TOTWTG_MN - Total weight (g) of the particular species collected per minute of electrofishing pedal time. For the block net method, the derived field 'habitat' is a concatenation of the following fields: - Watrbody_TYPE - Type of waterbody: lake, stream, canal. - FLOWS_INTO - Waterbody that the stream flows into; or downstream connecting stream/river. - TROPHIC - Trophic state of the waterbody. - VEG1_COMMON - Primary habitat in block net. Based on Pcode field from pltname data table of original database. - VEG1_SPECIES -Scientific name of species in primary habitat. Source: Aquatic Plant database - FDEP-Bureau of Aquatic Plants. - VEG1_HAB - General type of aquatic plant in primary habitat. E = Emergent plant, F = Floating plant, S = Submersed. - VEG1_ORIG - Whether the plant in primary habitat is native or exotic. N = Native plant, E = Exotic species. Source: FDEP-Bureau of Aquatic Plants. - VEG2_COMMON - Secondary habitat in block net. Based on Pcode field from pltname data table of original database. - VEG2_SPECIES - Scientific name of species in secondary habitat. Source: Aquatic Plant database - FDEP-Bureau of Aquatic Plants. - VEG2_HAB - General type of aquatic plant in secondary habitat. E = Emergent plant, F = Floating plant, S = Submersed. - VEG2_ORIG - Whether the plant in secondary habitat is native or exotic. N = Native plant, E = Exotic species. Source: FDEP-Bureau of Aquatic Plants. - VEG3_COMMON - Tertiary habitat in the block net. Based on Pcode field from pltname data table of original database. - VEG3_SPECIES - Scientific name of species in tertiary habitat. Source: Aquatic Plant database - FDEP-Bureau of Aquatic Plants. - VEG3_HAB - General type of aquatic plant in tertiary habitat. E = Emergent plant, F = Floating plant, S = Submersed. - VEG3_ORIG - Whether the plant in tertiary habitat is native or exotic. N = Native plant, E = Exotic species. Source: FDEP-Bureau of Aquatic Plants. For the electrofishing method, the derived field 'habitat' is a concatenation of the following three fields: - Watrbody_TYPE - Type of waterbody: lake, stream, canal. - FLOWS_INTO - Waterbody that the stream flows into; or downstream connecting stream/river. - TROPHIC - Trophic state of the waterbody. The derived field 'taxonRemarks' is a concatenation of the following fields for both the block net and the electrofishing methods: - FISHCODE - Unique FWC code for fish species used to link the fishlist table to the Ef_data and BN_data tables of the original Access database. - provided_scientific_name - label/name of this field was changed to 'provided_scientific_name' during BISON processing, but this field is based on the field 'SCIENTIFIC' in the original Access database. The original field 'SCIENTIFIC' in the Access database provides the scientific name of the fish species. - Fishlist_TYPE - Type of fish. Freshwater = Freshwater species of fish, Saltwater = Saltwater species of fish, Exotic = Non-native to Florida. - CATEGORY - Whether the species is a sportfish or other fish species. - HARV1_MM - Harvestable size, total length in mm for sportfish. The derived 'verbatimLocality' field is a concatenation of the following fields for both the block net and electrofishing methods: - LOCATION - a written description of the physical location of the sample, where the sample was taken. - WATER_BODY - Name of lake, river, stream, canal, or reservoir. This is the recognized name given to the waterbody. - Sta_description - The name-location of the sampling station. This is the name or station number that identifies the sampling location. - Watrbody_STA - Station identification code. - REGION - FWC region where waterbody or sample is located. These are the FWC regions: Northwest, Northeast, Central, South, Everglades. - HUC - USGS Hydrologic Unit 8-digit Code. - pk_basin - Unique drainage basin code that links to the Florida Department of Environmental Protection "drainage basin 1995" GIS coverage. - Rch_code - Unique reach code used to link data to the National Hydrologic Dataset (NHD). Source: USGS-EPA. The derived 'general_comments' field is a concatenation of the derived fields 'samplingProtocol', 'occurrenceRemarks', 'habitat', and 'taxonRemarks', concatenated with the original 'COMMENTS' field from the dataset. These various fields are separated by a pipe (|) symbol in the 'general_comments' field of the processed dataset. This ‘general_comments’ field was only added to the dataset that was incorporated into Biodiversity Information Serving Our Nation (BISON) and not to the dataset that was submitted to the Global Biodiversity Information Facility (GBIF) since the derived variables that were concatenated could be mapped individually to the schema of GBIF but not the schema of BISON. The derived field 'associatedTaxa' was added only to the block net flat table for the combined dataset submitted to the Global Biodiversity Information Facility (GBIF) in order to list the scientific name of plant species associated with a fish collection sample. This derived field only has data for the block net method as the original fields for vegetation only appeared in the BN_sample table of the original Access database. There is no actual data in this derived field for the electrofishing method (EF_sample table). This field is a concatenation (when there is more than 1 associated species) of species scientific names obtained from the original fields of VEG1_SPECIES, VEG2_SPECIES, and VEG3_SPECIES, which were used in the original database to describe habitats in the block net. This field was added to the dataset submitted to GBIF because the DarwinCore data exchange schema standard has an associatedTaxa field to which this derived field can be mapped. This field was not added to the dataset submitted to BISON because the original vegetation data is already included in the general_comments field in BISON and an associatedTaxa field could not be mapped to the BISON schema. After all the derived fields were generated, new tables (BN_Table, EF_Table) were created for the block net and electrofishing methods, which included the original fields that could be mapped to the BISON schema and the derived fields generated in RStudio during the processing described above. These new tables were used in subsequent processing in R described in the next step.
  4. Processing of FLA_FISHES database by U.S. Geological Survey staff for submission to Biodiversity Information Serving Our Nation (BISON) and the Global Biodiversity Information Facility (GBIF): Step 4 - Processing in RStudio of combined BN and EF tables The BN_Table and EF_Table were merged in RStudio to generate a single flat table of the dataset that contained the processed data for additional joint processing with R. The following fields were added to the new combined dataset: - clean_provided_scientific_name - new field based on provided_scientific_name field, but with removal of taxonomic rank indicators / qualifiers, abbreviations and other special characters. The provided scientific name of the hybrids 'Morone chrysops x M. saxatilis' and 'Morone saxatilis x M. chrysops' was resolved in the clean_provided_scientific_name field to 'Morone saxatilis Morone chrysops' which is the name accepted in the Integrated Taxonomic Information System (ITIS). The provided scientific names 'Moxostoma n. sp. cf poecilurum' and 'Macrhybopsis n. sp. cf aestivalis' were resolved to the genus level of 'Moxostoma' and 'Macrhybopsis' respectively. And the provided name of 'Tilapia hybrid' was resolved to the genus 'Tilapia' in the clean_provided_scientific_name field. There were 10 species for which the provided scientific name did not match valid scientific names for the species in ITIS, but rather differed by one letter or just to the species level in cases were a subspecies epithet was provided. Therefore the following invalid provided names were resolved to the valid names for clean_provided_scientific_name: Belonesox belizianus to Belonesox belizanus, Ctenogobius bolesoma to Ctenogobius boleosoma, Cyprinodon variegatus hubbsi to Cyprinodon hubbsi, Etheostoma olmstedi maculaticeps to Etheostoma olmstedi, Fundulus olivaceous to Fundulus olivaceus, Gobiosoma bosci to Gobiosoma bosc, Hemichromis letourneauxi to Hemichromis letourneuxi, Microphis brachyurus lineatus to Microphis brachyurus, Nocomis leptocephalus bellicus to Nocomis leptocephalus, Opsopoedus emiliae to Opsopoeodus emiliae. - basis_of_record - new field added with a value of 'observation' for all records. Mapped to Human Observation for submission into GBIF. - occurrence_date - new field based on the original DATE field of the database but reformatted to an ISO standard. Reformatting of this field included removal of the timestamp from the DATE field and conversion to the YYYY-MM-DD format. Also, 7 records had a typo originally in the provided date of the occurrence. The typo in the year for '1098-03-24' was corrected to '1998-03-24' based on the correct year that was given in the provided year field. - provider - new field added with a value of 'BISON'. - provider_url - new field added with a value of 'https://bison.usgs.gov' - resource - new field added with a value of 'FWC - Freshwater Fishes of Florida - 1956-2000' - resource_url - new field added with a value of 'https://bison.usgs.gov/ipt/resource?r=fwc-floridafreshwaterfishes'. - provided_tsn - field based on original TSN field of the database. The TSN field includes the Taxonomic Serial Number from ITIS associated with scientific names. Two of these codes do not represent actual ITIS TSNs but where modified by FWC (added an extra digit) for maintaining the database linkages between the data tables and fishlist table of the original Access database. The codes that are not actual TSNs in the provided_tsn field are: 1000006 for 'Moxostoma n. sp. cf poecilurum', 1676801 for 'Morone saxatilis x M. chrysops'. - latitude - new field based on the LATDD original field but with replacement of values that had an original value of '0' with a missing/blank value instead. The field LATDD was the latitude in decimal degrees for the sampling site or midpoint of the lake. - longitude - new field based on the LONDD original field but with replacement of values that had an original value of '0' with a missing/blank value instead. The field LONDD was the longitude in decimal degrees of the sampling site or midpoint of the lake. - provided_county_name - new field based on the field COUNTY in original database but standardizing all county names to first letter uppercase and rest of letters in a word to lowercase. The original field COUNTY was the name of the county where a waterbody or sample is located. - provided_state_name - new field added with a value of 'Florida' since the original database is all for the state of Florida. - provider_id - new field added with a value of '440' to represent BISON. - resource_id - new field added with a value of '100076' to represent the id for this dataset in BISON. - provided_common_name - field based on the COMMON field of the original database. The original field COMMON listed the common name of the fish species. - kingdom - new field added with a value of 'Animalia'. - geodetic_datum - new field added with a value of 'NAD83'. The original metadata for the MS Access database provided the datum as 'North American Datum of 1983'. - iso_country_code - new field added with a value of 'US'. - license - new field added with a value of 'http://creativecommons.org/publicdomain/zero/1.0/legalcode' The following two corrections were made to the taxonomic family names in the FAMILY original field of the database as that field is mapped to the DarwinCore schema for submission to GBIF. The original provided family name of 'Morinidae' was corrected to 'Moronidae', and the original provided family name of 'Trigidae' was corrected to 'Triglidae' to correspond to the family names provided in ITIS. A new table of all relevant fields, including those added to the combined table, was generated into a csv file (rev_FWC_FL_Fishes.csv). Relevant columns were extracted into csv files for mapping and submission of the dataset into BISON (rev_BISON_FWC_FL_Fishes.csv) and GBIF (IPT_FWC_FL_Fishes.csv).

Additional Metadata

Alternative Identifiers c5126b60-6dc3-428b-b479-15a921199da1
https://bison.usgs.gov/ipt/resource?r=fwc-floridafreshwaterfishes