Upper Midwest Environmental Sciences Center

Upper Midwest Environmental Sciences Center - Fish File Format Information
folder.gif Long Term Resource Monitoring Program
 Fisheries Data

Fish File Format Information

line-c.gif


Last updated on April 11, 2006
The detailed information in these sections provides the data users with information about file name significance and a description of the data. The file naming convention explanation section describes the type of data, field station that collected the data, year of collection and data batch number, while the data descriptions include field column positions, historical summary, and field descriptions. Data from 1992 or earlier are sorted by date and time, location code, gear code, sampling time period, replicate, page number and row sequence number in that order. Data from 1993 or later are sorted by barcode only. The detailed data description section described below is available in downloadable ASCII form.

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)
The fifth and sixth characters denotes the year the data is from. The seventh and eighth characters denotes that years sequential batch of data.

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/
Default Value

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.
uparrow

BARCODE
Identifying barcode for fish data sheets.
uparrow

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
uparrow

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
uparrow

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)
uparrow

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.
uparrow

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).
uparrow

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."
uparrow

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.
uparrow

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
uparrow

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.
uparrow

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
uparrow

TIME PERIOD
Numeric LTRMP Sampling Time Period code. Example: The first sampling time period is coded as 1.
uparrow

REPLICATE
Code for pseudo-replicated gear deployments at fixed collection sites.
uparrow

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
uparrow

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
uparrow

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.
uparrow

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.
uparrow

POWER GOAL
Field to record the predetermined electrofishing power goal (in watts). Note: For electrofishing only.
uparrow

POWER USED
Field to record the actual average electrofishing power (in watts) consumption.
uparrow

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
uparrow

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)
uparrow

PULSE (Hz) and QF
Numeric field to record pulse frequency (Hertz [=cycles/sec]).
uparrow

DUTY CYCLE and QF
Numeric field to record electrofishing duty cycle (percentage of time current is flowing).
uparrow

UTM ZONE
Numeric field to record Global Positioning System (GPS) zone. LTRMP data resides in either zone 15 or 16.
uparrow

UTM EASTING
East UTM (Universal Transverse Mercator) coordinates of collection sites.
uparrow

UTM NORTHING
North UTM (Universal Transverse Mercator) coordinates of collection sites.
uparrow
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
uparrow
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.
uparrow
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
uparrow
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
uparrow
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
uparrow
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
uparrow
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
uparrow
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
uparrow
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)
uparrow
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
uparrow
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.
uparrow
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
uparrow
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
uparrow
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.
uparrow
COMMENTS
Eighty-character field to record miscellaneous comments and observations.
uparrow
WERE FISH RETURNED TO LAB FOR ID?
An indicator if some fish were taken back to lab for identification rather than in the field.
uparrow
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.
uparrow
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.
uparrow
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.
uparrow
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.
uparrow
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.
uparrow
VERIFY OPERATOR (COLLECTION SHEET)
Alphanumeric field to identify the operator responsible for verifying the electronic keyed data from the collection data sheets.
uparrow
PAGE NUMBER
Numeric field to record the page number of the Fish Measurement Sheet.
uparrow
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.
uparrow
ROW SEQUENCE NUMBER
Numeric field to identify, isolate, and sort individual fish detail records.
uparrow
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
uparrow
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.
uparrow
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)
uparrow
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.
uparrow
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 .
uparrow
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.
uparrow
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
uparrow
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
uparrow
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
uparrow
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.
uparrow
NUMBER FISH ON SHEET
Numeric field to record the total number of fish (sum of Fish Counts) recorded on this Fish Measurement Sheet.
uparrow
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.
uparrow
VERIFY OPERATOR (MEASUREMENT SHEET
Alphanumeric field to identify the operator responsible for verifying the electronic keyed data from the measurement data sheets.
uparrow
ORPHAN FLAG
Administrative field used to identify fish detail records missing a corresponding collection (header) record.
uparrow
BATCH NUMBER
Administrative field used to track keyed data batches.
uparrow

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