20211108 15204900 1.0 FALSE EFF_Popup_Table 002 20220902 11584000 20240719 8411000 150000000 5000 FGDC Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362 EFF_Popup_Table 2024-07-19T00:00:00 2024-07-19T00:00:00 GISLibrarian Florida Fish and Wildlife Research Institute St. Petersburg FL 33701 727-896-8626 Freshwater Fisheries Research Florida Fish and Wildlife Research Institute This table was created by Florida Fish and Wildlife Research Institute GIS staff to support the What's Happening on my Lake web application. <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN STYLE="font-size:12pt">The table contains water analysis info and vegetation information for waterbodies participating in the institute's Freshwater Fishery Section's Long Term Monitoring Program. The data include analysis results obtained from water and bottom sampling, vegetation type and coverage, and date sampled.</SPAN></P></DIV></DIV></DIV> Florida Fish and Wildlife Research Institute's Freshwater Fisheries section. Florida lakes waterbodies fishing electrofishing vegetation Florida Fish and Wildlife Research Institute's Center for Spatial Analysis GIS section. lakes, waterbodies, monitoring, fishing, research Florida File Geodatabase Table dataset EFF_Popup_Table Table 0 Table containing sampling results for waterbodies participating in the Florida Fish and Wildlife Research Institute's Freshwater Fisheries Section's Long-Term Monitoring Program FWRI OBJECTID OBJECTID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. SchemaMasterID SchemaMasterID String 12 0 0 Unique numerical value FWRI Text MinDepthFt Min Depth (Ft) Single 4 0 0 Minimum sample depth FWRI Decimal value MaxDepthFt Max Depth (Ft) Single 4 0 0 Maximum sample depth FWRI Decimal value AvgDepthFt Avg Depth (Ft) Single 4 0 0 Average sample depth FWRI Decimal value SecchiDepth Secchi Depth Single 4 0 0 Water clarity depth FWRI Decimal value Temperature Temperature Single 4 0 0 Sample temperature FWRI Decimal value pH pH Single 4 0 0 Sample pH value FWRI Decimal value DissOxygen Dissolved Oxygen Single 4 0 0 Sample dissolved oxygen value FWRI Decimal value WaterBody Waterbody String 255 0 0 Name of waterbody FWRI Text WaterBodyID Waterbody ID String 8 0 0 Waterbody unique id FWRI Text Year Year SmallInteger 2 0 0 Sampling year FWRI Numerical value Site Site String 10 0 0 Sampling site number FWRI Text Date Date Date 8 0 0 Date of sampling FWRI Date BottomType Bottom Type String 10 0 0 Bottom type at sampling location FWRI Text PerTotal_cover Per Total Cover SmallInteger 2 0 0 Percent total vegetation cover (includes submersed and emergent) FWRI Decimal value PerSubmersed Per Submersed SmallInteger 2 0 0 Percent submersed vegetation FWRI Decimal value PerEmergent Per Emergent SmallInteger 2 0 0 Percent emergent vegetation FWRI Decimal value Month_int Month Integer SmallInteger 2 0 0 Numerical representation of month sampled FWRI Numeric value USID USID String 20 0 0 Unique Waterbody/Site identifier FWRI Text 20240719 GISLibrarian Florida Fish and Wildlife Research Institute St. Petersburg FL 33701 727-896-8626 GISLibrarian SQL database table. Florida Fish and Wildlife Research Institute Freshwater Fisheries Section 2024-07-19T00:00:00 2024-07-19T00:00:00 The data were pulled from a SQL server database table maintain by Florida Fish and Wildlife Conservation Commission OIT and Fish and Wildlife Research Institute's Freshwater Fisheries Section. A SQL query was used to pull the relevant fields and date range if applicable into an ArcGIS GDB table. A new "USID" field was added and calculated by concatenating the 'WaterbodyID' and 'Site' fields and this field was then used to join a field of the same name from another feature layer that containing the related geometry. The 'joined' field was then used to select only those records of this table for which geometry existed and the selected records were exported to a new gdb table. A new "Month_int" field was added and calculated as a numerical representation of the sampling month. The "Month_int" field was used to select all records where it's value was <= 5. The selected records were exported to a new table. 2024-07-19T00:00:00 Center for Spatial Analysis GIS Section Florida Fish and Wildlife Research Institute St. Petersburg FL 33701 727-896-8626 Center for Spatial Analysis GIS Section Florida Fish and Wildlife Research Institute St. Petersburg FL 33701 727-896-8626 Center for Spatial Analysis GIS Section The data were inspected as per Florida Fish and Wildlife Research Institute Quality Control standards and determined to by conceptually consistent. The data were inspected against trusted data sources and were found to be accurate and complete.