{
  "fields": [{"id":"_id","type":"int"},{"id":"File","type":"text"},{"id":"Column Name","type":"text"},{"id":"Description","type":"text"}],
  "records": [
    [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"]
]}