Upper Midwest Environmental Sciences Center
Fisheries Data
Fish File Format Information
File Naming Convention Explanation
- The first three characters denote the data component;
- FSH = fish
- INV = macroinvertebrate
- VEG = vegetation transect
- VGI = vegetation informal
- WTR = water quality
- The fourth character is the field station that collected the data;
- 1 = Lake City, MN (Mississippi River, Pool 4)
2 = Onalaska, WI (Mississippi River, Pool 8)
3 = Bellevue, IA (Mississippi River, Pool 13)
4 = Brighton, IL (Mississippi River, Pool 26)
5 = Jackson, MO (Mississippi River, Open River)
6 = Havana, IL (Illinois River, LaGrange Pool)
Data Descriptions
Field Column Position
- The "Format" column contains the following format specifiers:
- a = alpha character (always UPPER case)
- b = a blank space
- blank = a missing value
- c = alpha character/symbol/digit
- c(xx) = character string where xx represents the maximum number of characters allowed
- 9 = any digit, 0 - 9
- MM/DD/YYYY = date format
- HH:MI = time format
Field Name | Field Position | Format | Value Range/ |
---|---|---|---|
SITE ALIAS | 1:12 |
a(12) |
- |
BARCODE | 13:20 |
99999999 |
1 - 99999999 |
FIELD STATION # | 21:21 |
9 |
0,1,2,3,4,5,6 |
SITE TYPE | 22:22 |
9 |
0,1,2 |
HABITAT CLASS | 23:27 |
aaa-a |
(See Appendix) |
START DATE | 28:35 |
MM/DD/YYYY |
05/01/1992 - Current Date |
START TIME | 36:40 |
HH:MI |
00:00 - 23:59 |
FINISH DATE | 41:48 |
MM/DD/YYYY |
05/01/1992 - To Present |
FINISH TIME | 49:53 |
HH:MI |
00:00 - 23:59 |
POOL/REACH | 54:55 |
aa |
(See Appendix) |
LOCATION CODE | 56:66 |
aa999.9aaaa |
- |
GEAR CODE | 67:68 |
aa |
- |
TIME PERIOD | 69:69 |
9 |
1,2,3 |
REPLICATE | 70:71 |
99 |
For Gear Code = "T": 1 - 99; For Gear Code <> "T": 1,2 |
SUMMARY CODE | 72:72 |
9 |
1,2,3 |
PROJECT CODE | 73:77 |
a-999 |
- |
EFFORT (DISTANCE) | 78:80 |
999 |
1 - 999 |
EFFORT (HOURS) | 81:83 |
HH: |
00: 23: |
EFFORT (MINUTES) | 84:85 |
MI |
00 - 59 |
POWER GOAL | 86:89 |
9999 |
1 - 9999 |
POWER USED | 90:93 |
9999 |
1 - 9999 |
VOLTS | 94:96 |
999 |
1 - 999 |
VOLTS QF | 97:97 |
c |
blank,0,1,2,3,5,9 |
AMPS | 98:103 |
999.99 |
.01 - 999.99 |
AMPS QF | 104:104 |
c |
blank,0,1,2,3,5,9 |
PULSE RATE(HZ) | 105:107 |
999 |
1 - 999 |
PULSE RATE QF | 108:108 |
c |
blank,0,1,2,3,5,9 |
DUTY CYCLE | 109:111 |
999 |
1 - 999 |
DUTY CYCLE QF | 112:112 |
c |
blank,0,1,2,3,5,9 |
UTM ZONE | 113:114 |
99 |
15,16 |
UTM EASTING | 115:121 |
9999999 |
0 - 9999999 |
UTM NORTHING | 122:128 |
9999999 |
0 - 9999999 |
METHOD | 129:129 |
9 |
1,2,3,4 |
ACCURACY | 130:134 |
99.9 |
0 - 99.9 |
SECCHI DISK | 135:137 |
999 |
-9, 0 - 999 |
SECCHI DISK QF | 138:138 |
c |
blank,0,1,2,3,5,9 |
WATER TEMP | 139:142 |
99.9 |
0 - 99.9 |
WATER TEMP QF | 143:143 |
c |
blank,0,1,2,3,5,9 |
WATER DEPTH | 144:147 |
99.9 |
0- 99.9 |
WATER DEPTH QF | 148:148 |
c |
blank,0,1,2,3,5,9 |
CONDUCTIVITY | 149:152 |
9999 |
0 - 9999 |
CONDUCTIVITY QF | 153:153 |
c |
blank,0,1,2,3,5,9 |
WATER VELOCITY | 154:157 |
9.99 |
0 - 9.99 |
WATER VELOCITY QF | 158:158 |
c |
blank,0,1,2,3,5,9 |
DISSOLVED OXYGEN | 159:162 |
99.9 |
0 - 99.9 |
DISSOLVED OXYGEN QF | 163:163 |
c |
blank,0,1,2,3,5,9 |
STAGE HEIGHT | 164:168 |
999.9 |
0 - 999.9 |
STAGE HEIGHT QF | 169:169 |
c |
blank,0,1,2,3,5,9 |
SUBMERSED AQUATIC VEGETATION (92 Only) | 170:170 |
9 |
0,1,2,3 |
DENSITY | 171:171 |
9 |
1,2 |
EMERGENT AQUATIC VEGETATION (92 Only) | 172:172 |
9 |
0,1,2,3 |
EMERGENT SUB AQUATIC VEG | 173:173 |
9 |
0,1,2,3 |
PREDOMINANT SUBSTRATE | 174:174 |
9 |
0,1,2,3,4 |
WOODY DEBRIS/SNAG | 175:175 |
9 |
0,1 |
WINGDAM/DYKE | 176:176 |
9 |
0,1 |
TRIBUTARY MOUTH | 177:177 |
9 |
0,1 |
REVETMENT | 178:178 |
9 |
0,1 |
INLET/OUTLET CHANNEL | 179:179 |
9 |
0,1 |
LOW-HEAD DAM CLOSING STRUCTURE WEIR | 180:180 |
9 |
0,1 |
FLOODED TERRESTRIAL | 181:181 |
9 |
0,1 |
OTHER | 182:182 |
9 |
0,1 |
COMMENTS | 183:262 |
c(80) |
- |
WERE FISH RETURNED TO LAB FOR ID? | 263:263 |
c |
Y,N |
NO. OF CONTAINERS | 264:265 |
99 |
0 - 99 |
NO. OF FISH MEASUREMENT DATA SHEETS | 266:267 |
99 |
0 - 99 |
TOTAL NUMBER FISH COLLECTED | 268:272 |
99999 |
0 - 99999 |
CREW LEADER CODE | 273:276 |
cccc |
- |
ENTRY OPERATOR (COLLECTION SHEET) | 277:279 |
ccc |
000 - 999 |
VERIFY OPERATOR (COLLECTION SHEET) | 280:282 |
ccc |
000 - 999 |
PAGE NUMBER | 283:284 |
99 |
1 - 99 |
RECORDING SITE | 285:285 |
9 |
1,2 |
ROW SEQUENCE NUMBER | 286:287 |
99 |
1 - 30 |
SPECIES CODE | 288:291 |
accc |
- |
LENGTH GRP. MIN. | 292:297 |
999999 |
1 - 999999 |
T F S | 298:298 |
a |
T,F,S |
GRP WIDTH | 299:299 |
9 |
1,2 |
FISH COUNT | 300:304 |
99999 |
1 - 99999 |
IND/AGG. WEIGHT | 305:313 |
999999.99 |
1 - 999999.99 |
PATHOLOGY CODE | 314:314 |
c |
- |
SUBPROJECT CODE | 315:316 |
cc |
- |
USER DEFINED FIELDS | 317:328 |
c(12) |
- |
RECORDER CODE | 329:332 |
cccc |
- |
NUMBER FISH ON SHEET | 333:337 |
99999 |
- |
ENTRY OPERATOR (MEASUREMENT SHEET) | 338:340 |
ccc |
- |
VERIFY OPERATOR (MEASUREMENT SHEET) | 341:343 |
ccc |
- |
ORPHAN FLAG | 344:344 |
9 |
0,1 |
BATCH NUMBER | 345:348 |
cccc |
- |
Historical Summary
Field Descriptions
- SITE ALIAS
- Used to record an optional site alias for field station use.
BARCODE- Identifying barcode for fish data sheets.
FIELD STATION NUMBER- Numeric code identifying the field station number. Listed below are the valid codes and their corresponding field station.
1 = Lake City, MN
2 = Onalaska, WI
3 = Bellevue, IA
4 = Brighton, IL
5 = Jackson, MO
6 = Havana, IL
SITE TYPE- Numeric code identifying the type of sampling site, as follows:
- 0 = Primary randomly selected sampling site
- 1 = Alternate randomly selected sampling site
- 2 = Subjectively chosen permanently fixed site
STRATUM (HABITAT CLASS)- Alphabetic code LTRMP habitat class description:
- BWC-O = Backwater, offshore
- BWC-S = Backwater, shoreline
- MCB-U = Main channel border, unstructured
- MCB-W = Main channel border, wing dam
- IMP-O = Impounded, offshore
- IMP-S = Impounded, shoreline
- SCB = Side channel border
- TWZ = Tailwater zone (permanently fixed sampling sites)
- CTR = Main channel trough (optional sampling only)
START DATE- Date on which a gear collection was initiated (e.g., the date on which a net was set). Eight-digit numeric mm/dd/yyyy format, example April 1, 1995, is represented as 04/01/1995.
START TIME- 2400-h (military) Central Standard Time (CST) at which a gear sample begins (e.g., the time a net was set or an electrofishing run was begun).
FINISH DATE- Date on which a gear sample was completed (e.g., the date on which a net was lifted). Format is the same as "Start Date."
FINISH TIME- 2400-h Central Standard Time (CST) at which a gear sample is completed (e.g., the time that a net is lifted or an electrofishing run [actual shocking time] is completed). This field should be blank for seine samples.
POOL/REACH- Alphanumeric code for the LTRMP study reach or pool number:
- 04 = Pool 4, UMR
- 08 = Pool 8, UMR
- 13 = Pool 13, UMR
- 26 = Pool 26, UMR
- LG = La Grange Pool, Illinois River
- OR = Open Mississippi River
LOCATION CODE- Alphanumeric code for LTRMP Location Code having the format nnnnn.nnnnn. For randomly selected sites enter nnnn.RS, where nnnn is the site number from the sampling map or site list. For permanently fixed sites record rmmm.ma, where r designates the river (M = Mississippi and I = Illinois), mmm.m is the river mile (recorded to the nearest 0.1 mile), and a is an alphabetic code for the relative lateral position across the floodplain.
GEAR CODE- Alphabetic gear code (collection method) summarized below:
- D = Day (1 h after sunrise to 1 h before sunset) electrofishing
- F = Fyke netting
- GR = Gill netting, perpendicular (to shore) set
- GL = Gill netting, parallel (to shore) set
- HS = Hoop netting, small LTRMP net
- HL = Hoop netting, large LTRMP net
- M = Mini fyke netting
- N = Night (1 h after sunset to 1 h before sunrise) electrofishing
- S = Seining
- T = Trawling
- TP = Plankton trawling
- X = Tandem fyke netting
- Y = Tandem mini fyke netting
- TA = Trammel netting, anchored set
- TD = Trammel netting, floating and drifting
TIME PERIOD- Numeric LTRMP Sampling Time Period code. Example: The first sampling time period is coded as 1.
REPLICATE- Code for pseudo-replicated gear deployments at fixed collection sites.
SUMMARY CODE- Numeric code documenting the overall quality of a sample collection as described below:
- 1 = Gear failure; site may be resampled within time period
- 2 = Site cannot be sampled (i.e., site is dry or inaccessible)
- 3 = Sample collected under unusual environmental conditions
- 4 = Weighing equipment may be in error due to wind and waves
- 5 = Normally completed sample; all LTRMP procedures followed
- 6 = Noncritical gear modification (e.g., fyke net lead shortened)
- 7 = Pseudo-shoreline used for shoreline gear
- 8 = Minor gear damage or noncritical gear failure
PROJECT CODE- Alphanumeric LTRMP project code. Format is A-nnn, where A is a letter describing project type and nnn is a special project number. Project types are as follows:
- M = RTA standardized resource monitoring
- B = HREP biological response monitoring
- E = Ad hoc exploratory sampling
- R = Special research project
EFFORT DISTANCE- Numeric field for recording the length (in meters) of an electrofishing run or trawl haul. Completion of this field is required only for electrofishing, trawling, and trammel net drifting.
EFFORT HOURS + EFFORT MINUTES- Used to document actual elapsed time required to capture a sample of fish (actual duration of gear deployment). Format is 2400-h (military) time, hh:mm, where a fyke net set fished for 25 h and 15 min is recorded as 25:15. This field should be blank for seine samples.
POWER GOAL- Field to record the predetermined electrofishing power goal (in watts). Note: For electrofishing only.
POWER USED- Field to record the actual average electrofishing power (in watts) consumption.
VOLTS and QF- Field to record DC volts. The Quality Factor (QF) is a one-digit numeric field as follows:
- Blank = Normal operation/acceptable measurement
- 0 = Voltage meter inoperative
- 1 = Unstable voltage readings (varies by >70 V); equipment questionable
AMPS and QF- Numeric field to record DC current (in amperes). The Quality Factor (QF) is a one-digit numeric field as follows:
- Blank = Normal operation/acceptable current determination
- 0 = Ammeter inoperative
- 1 = Unstable current readings (varies by >10 amps)
PULSE (Hz) and QF- Numeric field to record pulse frequency (Hertz [=cycles/sec]).
DUTY CYCLE and QF- Numeric field to record electrofishing duty cycle (percentage of time current is flowing).
UTM ZONE- Numeric field to record Global Positioning System (GPS) zone. LTRMP data resides in either zone 15 or 16.
UTM EASTING- East UTM (Universal Transverse Mercator) coordinates of collection sites.
UTM NORTHING- North UTM (Universal Transverse Mercator) coordinates of collection sites.
- METHOD
- Numeric code specifying the method used to locate the collection site, as follows:
- 1 = UTMs recorded from cross-reference between base map and site features
- 2 = UTMs recorded from GPS device (Magellan)
- 3 = Latitude (N/S coordinates; degrees, minutes, seconds) and longitude (E/W coordinates; degrees, minutes, seconds) recorded from GPS (Loran)
- 4 = Latitude and longitude recorded from cross-reference between base map and site features
- ACCURACY
- Numeric field to record a measure of positioning accuracy. Record Percent Dilution of Precision (PDOP) from GPS devices and the following codes for base map cross-reference and revisits to marked fixed sites:
- 000.1 = Almost certain accuracy within 100 m because of immediate proximity to uniquely identifiable features (undisturbed marker, wing dam, day mark, etc.).
- 000.2 = High confidence of accuracy within 100 m because of agreement between general site appearance and identifiable features on a base map.
- 000.3 = Other than above.
- SECCHI DISK and QF
- Numeric field for recording measurement of water transparency (in centimeters) using a Secchi disk. Quality Factor (QF) codes are as follows:
- Blank = Normal measurement/no problems
- 0 = Equipment inoperative
- 1 = Equipment in question (i.e., paint discolored)
- 4 = Used proximate measurement - no measurement at this site
- 3 = Reading off scale (high)
- 5 = No sample taken
- 9 = Non-standard method used
- WATER TEMP and QF
- Numeric field to record water temperature measurement to the nearest 0.1 Centigrade degree. Quality Factor (QF) codes are as follows:
- Blank = Normal measurement/no problems
- 0 = Equipment inoperative
- 1 = Equipment in question
- 4 = Used proximate measurement - no measurement at this site
- 5 = No reading taken
- 9 = Non-standard method used
- WATER DEPTH and QF
- Numeric field to record water depth to the nearest 0.1 meter. Quality Factor (QF) codes are as follows:
- Blank = Normal measurement/no problems
- 0 = Equipment inoperative
- 1 = Equipment in question
- 5 = No sample taken
- 9 = Non-standard method used
- CONDUCTIVITY and QF
- Numeric field to record conductivity to the nearest 1 S/cm. Quality Factor (QF) codes are as follows:
- Blank = Normal measurement/no problems
- 0 = Equipment inoperative
- 1 = Equipment in question
- 3 = Reading off scale (high)
- 4 = Used proximate measurement - no measurement at this site
- 5 = No sample taken
- 9 = Non-standard method used
- WATER VELOCITY and QF
- Numeric field to record water velocity to the nearest 0.1 meter/second. Quality Factor (QF) codes are as follows:
- Blank = Normal measurement/no problems
- 0 = Equipment inoperative
- 1 = Equipment in question
- 3 = Reading off scale (high)
- 5 = No sample taken
- 9 = Non-standard method used
- DISSOLVED OXYGEN and QF
- Numeric field to record dissolved oxygen concentration to the nearest 0.1 mg/l. Quality Factor (QF) codes are as follows:
- Blank = Normal measurement/no problems
- 0 = Equipment inoperative
- 1 = Equipment in question
- 3 = Reading off scale (high)
- 4 = Used proximate measurement - no measurement at this site
- 5 = No sample taken
- 9 = Non-standard method used
- STAGE HEIGHT and QF
- Water elevation measurement obtained from local stage height gauge. Quality Factor codes are as follows:
- 1 = Feet relative (local) measure
- 2 = Feet above mean sea level (AMSL)
- 3 = Meters relative (local) measure
- 4 = Meters above mean sea level (AMSL)
- SUBMERSED AQUATIC VEGETATION (1992 Only)
- Numeric field to record qualitative estimate of percent of area within a 100 meter radius in which there is submersed aquatic vegetation, based on visual observation. Values are as follows:
- 0 = 0% (no submersed aquatic vegetation apparent)
- 1 = 1%-19% coverage
- 2 = 20%-49% coverage
- 3 = 50% and over coverage
- DENSITY
- Numeric field to record qualitative estimate of density of both emergent and submersed aquatic vegetation within a 100-m radius, based on visual observation. Values are as follows:
- 1 = Prevailing vegetation is sparse (probably less than 10 stems per square meter) and does not create an "edge" at its perimeter.
- 2 = Prevailing vegetation is dense (probably greater than or equal to 10 stems per square meter) and creates a distinct "edge" at its perimeter.
- EMERGENT AQUATIC VEGETATION (1992 Only)
- Numeric field to record qualitative estimate of percent of area within a 100 meter radius in which there is emergent aquatic vegetation, based on visual observation. Values are as follows:
- 0 = 0% (no emergent aquatic vegetation apparent)
- 1 = 1%-19% coverage
- 2 = 20%-49% coverage
- 3 = 50% and over coverage
- EMERGENT SUB AQUATIC VEG
- Numeric field to record qualitative estimate of percent of area within a 100 meter radius in which there is emergent and/or submersed aquatic vegetation, based on visual observation. Values are as follows:
- 0 = 0% (no emergent/submersed aquatic vegetation apparent)
- 1 = 1%-19% coverage
- 2 = 20%-49% coverage
- 3 = 50% and over coverage
- PREDOMINANT SUBSTRATE
- Numeric field to record qualitative observation of sediments based on visual and tactile observation. Values are as follows:
- 1 = Silt (very fine and very soft sediments that may contain highly hydrated [very soft] clay; sand lacking)
- 2 = Silt/Clay/Little Sand (fine and soft sediments dominated by silt but usually containing little fine sand, with perhaps dehydrated [firm] clay pellets or moderately hydrated clay with little fine sand)
- 3 = Sand/Mostly Sand (firm to very firm, fine to coarse sediments with sand dominant, or entirely sand)
- 4 = Gravel/Rock/Hard Clay (hard substrate consisting of dehydrated [firm] clay, gravel, rock, bedrock, or concrete)
- Other Structures: (WOODY DEBRIS/SNAG, WINGDAM/DYKE, TRIBUTARY_MOUTH, REVETMENT, INLET/OUTLET CHANNEL, LOW-HEAD DAM CLOSING STRUCTURE WEIR, FLOODED TERRESTRIAL, OTHER) Eight check-boxes to record presence of other habitat structure within a 100 meter radius.
- WERE FISH RETURNED TO LAB FOR ID?
- An indicator if some fish were taken back to lab for identification rather than in the field.
- NO. OF CONTAINERS
- Numeric field to record the number of individual containers (whirl-pacs, vials, etc.) containing specimens that were returned to the field station or lab for identification or measurement.
- NO. OF FISH MEASUREMENT DATA SHEETS
- Numeric field to record the total number of Fish Measurement Sheets (recorded in the field and lab) completed for the sample collection.
- TOTAL NUMBER FISH COLLECTED
- Numeric field to record the total number of fish (of all species, whether enumerated in the field or lab) captured in the sample collection. This number is obtained from a manual tally of fish counts on the corresponding Fish Measurement Sheets.
- CREW LEADER CODE
- Alphanumeric field to identify the LTRMP Crew Leader responsible for recording of this collection sheet data. These codes are permanently assigned to LTRMP staff at each station.
- ENTRY OPERATOR (COLLECTION SHEET)
- Alphanumeric field to identify the operator responsible for entering (keying) the data from the collection data sheets into an electronic format.
- VERIFY OPERATOR (COLLECTION SHEET)
- Alphanumeric field to identify the operator responsible for verifying the electronic keyed data from the collection data sheets.
- RECORDING SITE
- Numeric field to record the site at which fish on a particular Fish Measurement Sheet were identified, enumerated, and measured. Valid codes are as follows:
- 1 = Fish Measurement Sheets completed in the field.
- 2 = Fish Measurement Sheets completed in the lab or office.
- SPECIES CODE
-
Alphabetic field to identify the fish species for a particular record of data. Following are the valid codes and the common species name for which they represent:
YOYF = Age-0 fish |
MDDR = Mud darter |
ALSD = Alabama shad | MSKG = Muskellunge |
ALWF = Alewife | NSSB = Ninespine stickleback |
NFSH = No fish caught | |
ASNT = Alligator snapping turtle | NBLP = Northern brook lamprey |
ABLP = American brook lamprey | NHSK = Northern hog sucker |
AMEL = American eel | NTMT = Northern madtom |
BDDR = Banded darter | NTPK = Northern pike |
BDKF = Banded killifish | NRBD = Northern redbelly dace |
BPSF = Banded pygmy sunfish | NTSF = Northern studfish |
BDSP = Banded sculpin | OHSH = Ohio shrimp |
BTSF = Bantam sunfish | OSLE = Orangespotted or longear sunfish |
BECB = Bigeye chub | OSSF = Orangespotted sunfish |
BESN = Bigeye shiner | OTDR = Orangethroat darter |
BHCP = Bighead carp | OMPT = Ouachita map turtle |
BMBF = Bigmouth buffalo | OZMW = Ozark minnow |
BMSN = Bigmouth shiner | PDFH = Paddlefish |
BKBF = Black buffalo | PDSN = Pallid shiner |
BKBH = Black bullhead | |
BKCP = Black crappie | PDSG = Pallid sturgeon |
BCWC = Black x white crappie | PLDC = Pearl dace |
BKRH = Black redhorse | PRPH = Pirate perch |
BCSN = Blackchin shiner | PNMW = Plains minnow |
BNDC = Blacknose dace | PGMW = Pugnose minnow |
BNSN = Blacknose shiner | PNSN = Pugnose shiner |
BSDR = Blackside darter | PNSD = Pumpkinseed |
BPTM = Blackspotted topminnow | PSBG = Pumpkinseed or bluegill |
BTTM = Blackstripe topminnow | PSOS = Pumpkinseed x orangespotted sunfish |
BTSN = Blacktail shiner | PSWM = Pumpkinseed or warmouth |
BLDT = Blanding's turtle | QLBK = Quillback |
BLTR = Bloater | RBDR = Rainbow darter |
BLCF = Blue catfish | RBST = Rainbow smelt |
BUSK = Blue sucker | RBTT = Rainbow trout |
BBDR = Bluebreast darter | RESL = Red-eared slider |
BLGL = Bluegill | RDSN = Red shiner |
BGLE = Bluegill x longear sunfish | RESF = Redear sunfish |
BGOS = Bluegill x orangespotted sunfish | RSWM = Redear sunfish x warmouth |
BGRS = Bluegill x redear sunfish | RFSN = Redfin shiner |
BGWM = Bluegill x warmouth | RBSN = Ribbon shiner |
BHSN = Bluehead shiner | RVCS = River carpsucker |
BNDR = Bluntnose darter | RVCB = River chub |
BNMW = Bluntnose minnow | RCOT = River cooter |
BWFN = Bowfin | RRDR = River darter |
BSMW = Brassy minnow | RVRH = River redhorse |
BDMT = Brindled madtom | RVSN = River shiner |
BKSS = Brook silverside | RKBS = Rock bass |
BKSB = Brook stickleback | RSSN = Rosefin shiner |
BKTT = Brook trout | RYSN = Rosyface shiner |
BNBH = Brown bullhead | RUDD = Rudd |
BNTT = Brown trout | SNSN = Sand shiner |
SGER = Sauger | |
BHMW = Bullhead minnow | SGWE = Sauger x walleye hybrid |
BRBT = Burbot | SELP = Sea lamprey |
SWBS = Shadow bass | |
C*GF = Carp x goldfish hybrid | SHRH = Shorthead redhorse |
CMMW = Central mudminnow | SNGR = Shortnose gar |
CMSR = Central stoneroller | SNPD = Shovelnose x pallid sturgeon |
CLSR = Central stoneroller | SNSG = Shovelnose sturgeon |
CNPK = Chain pickerel | SFCB = Sicklefin chub |
CNCF = Channel catfish | SVCP = Silver carp |
CNSN = Channel shiner | SVCB = Silver chub |
CNLP = Chestnut lamprey | SVLP = Silver lamprey |
CSCO = Cisco | SVRH = Silver redhorse |
CHSM = Coho salmon | SBSN = Silverband shiner |
CARP = Common carp | SJMW = Silverjaw minnow |
CMPT = Common map turtle | SJHR = Skipjack herring |
CMKT = Common musk turtle | SDMT = Slender madtom |
CMSN = Common shiner | SHDR = Slenderhead darter |
CSNT = Common snapping turtle | SYSP = Slimy sculpin |
CKCB = Creek chub | SLDR = Slough darter |
CKCS = Creek chubsucker | SMBS = Smallmouth bass |
CLDR = Crystal darter | SMBF = Smallmouth buffalo |
CPDR = Cypress darter | SRBD = Southern redbelly dace |
DWSP = Deepwater sculpin | SKCB = Speckled chub |
DYDR = Dusky darter | SPSS = Spiny softshell |
ESDR = Eastern sand darter | SFSN = Spotfin shiner |
ERSN = Emerald shiner | SPDR = Spottail darter |
FMPT = False Map Turtle | STSN = Spottail shiner |
FTDR = Fantail darter | STBS = Spotted bass |
FHMW = Fathead minnow | STGR = Spotted gar |
FHCF = Flathead catfish | SPSK = Spotted sucker |
FHCB = Flathead chub | STSF = Spotted sunfish |
FLER = Flier | SGCF = Spring cavefish |
FKMT = Freckled madtom | SHTM = Starhead topminnow |
FWDM = Freshwater drum | SCSN = Steelcolor shiner |
GTSN = Ghost shiner | STCT = Stonecat |
GZSD = Gizzard shad | SDBS = Striped bass |
GLSH = Glass shrimp | SPMT = Striped mullet |
GDRH = Golden redhorse | SBWB = Striped or white bass |
GDSN = Golden shiner | SPSN = Striped shiner |
GDEY = Goldeye | STDR = Stripetail darter |
GDFH = Goldfish | SGCB = Sturgeon chub |
GSCP = Grass carp | SMMW = Suckermouth minnow |
GSPK = Grass pickerel | TPMT = Tadpole madtom |
GVCB = Gravel chub | TFSD = Threadfin shad |
GTRH = Greater redhorse | MGNP = Tiger muskellunge |
GSBG = Green or bluegill sunfish | TTPH = Trout perch |
GSLE = Green or longear sunfish | UNID = Unidentified |
GSOS = Green or orangespotted sunfish | U-ET = Unidentified Etheostoma |
GSPS = Green or pumpkinseed sunfish | U-IL = Unidentified lctalurus (replacing U-IC) |
GSRS = Green or redear sunfish | U-CL = Unidentified shad |
GSWM = Green or warmouth sunfish | U-HI = Unidentified Hionidae |
GNSF = Green sunfish | U-LS = Unidentified gar |
U-LP = Unidentified Lepomis | |
GN*? = Green sunfish x unknown | U-MO = Unidentified Morone |
GSDR = Greenside darter | U-NT = Unidentified Noturus |
HQDR = Harlequin darter | U-PC = Unidentified Percidae |
HFCS = Highfin carpsucker | U-PN = Unidentified Percina |
HHCB = Hornyhead chub | U-PM = Unidentified Pimephales |
IMDT = Illinois mud turtle | U-ST = Unidentified Stizostedion |
IDSS = Inland silverside | U-BF = Unidentified buffalo |
IODR = Iowa darter | U-BH = Unidentified bullhead |
ICSN = Ironcolor shiner | U-CS = Unidentified carpsucker |
JYDR = Johnny darter | U-HY = Unidentified chub |
LKCB = Lake chub | U-DR = Unidentified darter |
LKCS = Lake chubsucker | U-LY = Unidentified lamprey |
LKSG = Lake sturgeon | U-CY = Unidentified minnow |
LMBS = Largemouth bass | U-RH = Unidentified redhorse |
LSSR = Largescale stoneroller | U-NO = Unidentified shiner |
LRVL = Larval fish | U-SG = Unidentified sturgeon |
LBLP = Least brook lamprey | U-CT = Unidentified sucker |
LTDR = Least darter | U-CN = Unidentified sunfish |
LGPH = Logperch | WLYE = Walleye |
LESF = Longear sunfish | WRMH = Warmouth |
LNDC = Longnose dace | WDSN = Weed shiner |
LNGR = Longnose gar | MQTF = Western mosquitofish |
LNST = Longnose or spotted gar (hybrid) | WPTT = Western painted turtle |
LNSK = Longnose sucker | WSDR = Western sand darter |
MPTT = Midland painted turtle | WSMW = Western silvery minnow |
SMSS = Midland smooth softshell | WTBS = White bass |
MMSN = Mimic shiner | WTCF = White catfish |
MMPT = Mississippi map turtle | WTCP = White carppie |
MSSS = Mississippi silverside | WTPH = White perch |
SVMW = Mississippi silvery minnow | WTSK = White sucker |
MNEY = Mooneye | WODT = Wood turtle |
MDSP = Mottled sculpin | YWBS = Yellow bass |
MTMT = Mountain madtom | YLBH = Yellow bullhead |
YWPH = Yellow perch |
- LENGTH
- Numeric field to identify the lower bound of the length group to which a fish record belongs. A length group is defined as all fish of a particular species for a collection which fall within the GRP WIDTH (group width) range. See the GRP WIDTH description.
- T F S
- Alphabetic code to identify system used for length measurement: Following are valid codes:
- T or Blank = Maximum total length measurement; distance from anterior-most extreme of head (jaw closed) to most distant lobe of caudal fin (lobes compressed to achieve maximum length)
- F = Fork length; distance from anterior-most extreme of head (jaw closed) to fork of caudal fin (tip of median fin rays)
- S = Standard length; distance from anterior-most extreme of head (jaw closed) to caudal peduncle (posterior margin of hypural bone)
- GRP WIDTH (Group Width)
- Numeric field to record the range in centimeters of a a length group from within which fish were enumerated or bulk- weighed. For example, if LENGTH is 40 and GRP WIDTH is 1, then the range of lengths for the fish representing this fish record would be from 40 through 49 millimeters. This field should be blank for fish that are unmeasured or individually measured to the nearest 1 millimeter.
- FISH COUNT
- Numeric field to record counts of fish represented by the row of data. Fish Count is 1 for all individually measured lengths and weights and 1 for bulk counts. For example, if a particular fish was measured to the nearest 1 millimeter, then Fish Count is 1. If just one fish of a particular length group is encountered during length group enumeration, then Fish Count is also 1 for that length group. However, if 10 fish of a length group are encountered during group enumeration, then Fish Count is 10 .
- IND/AGG. WEIGHT
- Numeric field to record individual or aggregate weights (in grams). Aggregate weights are distinguished by the presence of a Group Width value. Weights are measured only for special purposes.
- PATHOLOGY CODE
- Represents LTRMP fish health/pathogen codes as follows:
- 0 or blank = No visible abnormality
- 1 = Parasite
- 2 = Skeletal abnormality
- 3 = Tumors
- 4 = Injury
- 5 = Skin/fin/eye
- 6 = Other
- SUBPROJECT CODE
- Two byte length alphanumeric field containing information needed to interpret data in USER DEFINED FIELDS. Codes for each byte are as follows:
- Byte 1:
- 1 = Aging structures (otoliths, scales, etc.) collected, specimen bar code
- 2 = Stomach contents collected
- 3 = Both aging structures and stomach contents collected
- 0 = Continued from previous line Note: When the above codes are used, the specimen bar code number should be recorded in bytes 1-10 of USER DEFINED FIELDS.
- Byte 2:
- 0 = Tag implanted, number follows in bytes 1-11 of USER DEFINED FIELDS, fish released
- 1 = Tag recovered, number follows in bytes 1-11 of USER DEFINED FIELDS, fish released
- 2 = Tag recovered, number follows in bytes 1-11 of USER DEFINED FIELDS, fish not released
- 3 = Tag scar visible, fish released
- 4 = Tag scar visible, fish not released
- 5 = Fin clipped, fin position follows in byte 14 of USER DEFINED FIELDS
- 6 = Fin clip recovered, position follows in byte 14 of USER DEFINED FIELDS, released
- 7 = Fin clip recovered, position follows in byte 14 of USER DEFINED FIELDS, not released
- USER DEFINED FIELDS
- Twelve byte length alphanumeric field containing special information not routinely collected during standardized monitoring activities. Following is a description of what these twelve bytes represent.
- Bytes 1-10: Specimen number (aging structure and/or stomach contents).
- Byte 11: Fin clipping position.
- -- or --
- Bytes 1-11: Tag number.
- Byte 12: Gill net mesh size code as follows:
- 1 = 4"
- 2 = 6"
- 3 = 8"
- 4 = 10"
- -- or --
- Byte 12: Number of seines or trawls
- RECORDER CODE
- Alphanumeric field to identify the LTRMP recorder responsible for recording of this measurement sheet data. These codes are permanently assigned to LTRMP staff at each station.
- NUMBER FISH ON SHEET
- Numeric field to record the total number of fish (sum of Fish Counts) recorded on this Fish Measurement Sheet.
- ENTRY OPERATOR (MEASUREMENT SHEET)
- Alphanumeric field to identify the operator responsible for entering (keying) the data from the measurement data sheets into an electronic format.
- VERIFY OPERATOR (MEASUREMENT SHEET
- Alphanumeric field to identify the operator responsible for verifying the electronic keyed data from the measurement data sheets.
Disclaimer
These data have been generated by State agencies under contract with the Department of the Interior and the Upper Midwest Environmental Sciences Center (UMESC). Although these data have been processed successfully on a computer system at the UMESC, no warranty, expressed or implied, is made regarding the accuracy or utility of the data on any other system or for general or scientific purposes, nor shall the act of distribution constitute any such warranty.
However, error correction is a continuing process, and the UMESC routinely makes changes to data as errors are discovered. The file date is referred to as the release date and should be mentioned in all references to data. These data have been provided as a unit package to ensure that you receive a valid dataset collected in a consistent manner. Methods, purposes, and conditions can vary dramatically among data-collecting efforts and these data should not be combined with other datasets from the UMESC or other sources unless the user fully understands the procedures and purposes used to create each set of data and can verify that data are comparable across sources.
Page Last Modified: April 17, 2018