_id File Column Name Description 1 Fish_Surveys Id Unique Id for each fish survey 2 Fish_Surveys StartDate Date fish survey was started 3 Fish_Surveys EndDate Date fish survey was completed 4 Fish_Surveys County Indiana county where fish survey was completed 5 Fish_Surveys WaterbodyId Unique Id for associated waterbody. Used for joins with the Waterbody table. 6 Fish_Surveys WaterbodyName Waterbody name 7 Fish_Surveys WaterbodyType Type of waterbody. Includes Borrow Pit, Creek, Ditch, Farm Pond, Impoundment, Marsh, Municipal Pond, Natural Lake, Oxbow, Quarry, River, Run, Strip Pit, and Unknown. 8 Fish_Surveys SurveyType The type of fish survey data collected. Community, River & Stream, Status & Trend, and Targeted. 9 Fish_Surveys HasBatchRecords Whether the survey has batch records associated with it. True or False. 10 Fish_Surveys BatchFishCount Total number of batch fish counted 11 Batch_Fish_Records Id Unique Id for each batch fish record 12 Batch_Fish_Records FishSurveyId Unique Id for associated fish survey. Used for joins with the Fish_Surveys table. 13 Batch_Fish_Records GearId Unique Id for associated gear record. Used for joins with the Fish_Gear table. 14 Batch_Fish_Records SpeciesName Common name of the target species 15 Batch_Fish_Records ScientificName Scientific name of the traget species 16 Batch_Fish_Records Count Total number of fish counted 17 Batch_Fish_Records MinLengthIn Minimum fish length in inches 18 Batch_Fish_Records MaxLengthIn Maximum fish length in inches 19 Batch_Fish_Records TotalWeightLb Total batch weight in pounds 20 Fish_Records Id Unique Id for each fish record 21 Fish_Records FishSurveyId Unique Id for associated fish survey. Used for joins with the Fish_Surveys table. 22 Fish_Records GearId Unique Id for associated gear record. Used for joins with the Fish_Gear table. 23 Fish_Records SpeciesName Common name of the target species 24 Fish_Records ScientificName Scientific name of the traget species 25 Fish_Records LengthIn Fish length in inches 26 Fish_Records WeightLb Fish weight in pounds 27 Fish_Records AgeYrs Fish age in years 28 Fish_Records AgingStructure Biological structure used to age the fish. Anal Spine, Dorsal Spine, Operculum, Otolith, Pectoral Fin, PIT tag, Scales. 29 Fish_Records Latitude Record location. Latitude in decimal degrees. 30 Fish_Records Longitude Record location. Longitude in decimal degrees. 31 Fish_Gear Id Unique Id for each gear record 32 Fish_Gear FishSurveyId Unique Id for associated fish survey. Used for joins with the Fish_Surveys table. 33 Fish_Gear EffortAmount Numeric value of effort amount 34 Fish_Gear EffortUnit Effort unit. Hooks, Hours, or Lifts. 35 Fish_Gear GearGroup Type of sampling gear used 36 Fish_Gear StartLatitude Gear start location. Latitude in decimal degrees. 37 Fish_Gear StartLongitude Gear start location. Longitude in decimal degrees. 38 Fish_Gear EndLatitude Gear end location. Latitude in decimal degrees. 39 Fish_Gear EndLongitude Gear end location. Longitude in decimal degrees. 40 Fish_Gear DaySet Date gear was set 41 Fish_Gear DayRan Date gear was run 42 Water_Quality_Surveys Id Unique Id for each water quality survey 43 Water_Quality_Surveys StartDate Date water quality survey was started 44 Water_Quality_Surveys County Indiana county where water quality survey was completed 45 Water_Quality_Surveys WaterbodyId Unique Id for associated waterbody. Used for joins with the Waterbody table. 46 Water_Quality_Surveys WaterbodyName Waterbody name 47 Water_Quality_Surveys WaterbodyType Type of waterbody. Includes Borrow Pit, Creek, Ditch, Farm Pond, Impoundment, Marsh, Municipal Pond, Natural Lake, Oxbow, Quarry, River, Run, Strip Pit, and Unknown. 48 Water_Quality_Surveys SecchiDepthIn Secchi depth in inches 49 Water_Quality_Surveys AlkalinitySurfacePPM Alkalinity at the waterbody surface in parts per million 50 Water_Quality_Surveys AlkalinityBottomPPM Alkalinity at the waterbody bottom in parts per million 51 Water_Quality_Surveys PhSurface Ph at the waterbody surface 52 Water_Quality_Surveys PhBottom Ph at the waterbody bottom 53 Water_Quality_Surveys AirTempF Air temperature in degrees fahrenheit 54 Water_Quality_Surveys ConductivitymSv Waterbody conductivity in millisieverts 55 Water_Quality_Records Id Unique Id for each water quality record 56 Water_Quality_Records WaterQualitySurveyId Unique Id for associated fish survey. Used for joins with the Fish_Surveys table. 57 Water_Quality_Records DepthFt Record depth in feet 58 Water_Quality_Records TemperatureF Record temperature in degrees fahrenheit 59 Water_Quality_Records DissolvedOxygenPPM Record dissolved oxygen in parts per million 60 Water_Quality_Records Latitude Record location. Latitude in decimal degrees. 61 Water_Quality_Records Longitude Record location. Longitude in decimal degrees. 62 Waterbodies FID Unique Id for each waterbody 63 Waterbodies Shape Each polygon was copied from the NHD Lakes, Ponds, Marshes, etc layer or traced from a base layer 64 Waterbodies area_acres Polygon area in acres squared 65 Waterbodies aread_m2 Polygon area in meters squared 66 Waterbodies permieter_ Polygon permieter in meters 67 Waterbodies lat_calcu Waterbody centroid location. Latitude in decimal degrees. 68 Waterbodies long_calcu Waterbody centroid location. Longitude in decimal degrees. 69 Waterbodies utm_x_calc Waterbody centroid location. UTM X coordinate. NAD 83 / UTM zone 16N. 70 Waterbodies utm_y_calc Waterbody centroid location. UTM Y coordinate. NAD 83 / UTM zone 16N. 71 Waterbodies name Waterbody name 72 Waterbodies finfo_id Unique Id for associated FINFO Waterbody table. Used for joins with the Waterbody table. 73 Waterbodies county Indiana county(ies) where the waterbody occurs 74 Waterbodies district The IDNR fisheries district where the waterbody occurs 75 Waterbodies owner_type The type of owner. Includes Federal, Municipal, Nonprofit, Private, and State 76 Waterbodies owner Waterbody owner 77 Waterbodies location Desciption of waterbody location