HeavyRainfall (type: esriFieldTypeString, alias: Has there been heavy rainfall(>2 in) in the past week?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
PublicUseWater (type: esriFieldTypeString, alias: Is the lake or waterbody used by the public (wells, irrigation, reuse etc.), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
HealthEffects (type: esriFieldTypeString, alias: Have any health effects from pets, wildlife, or humans been reported or observed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
OutsideContact (type: esriFieldTypeString, alias: Have any local or state organizations been contacted on this issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
PS_SpillType (type: esriFieldTypeString, alias: Select the type of pollutant discharged, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Petroleum_based: Petroleum Based], [Chemical_Hazardous: Chemical/Hazardous Waste], [Wastewater: Wastewater (sewer, septic, lift stations, etc.)], ... 1 more ...)
PS_P_ReportingGuidelines (type: esriFieldTypeString, alias: Events to Report:
• Spills into or involving state waterways (any amount)
• Spills greater than 25 gallons on land (or potential 25 gallons)
• Spills requiring any state/federal notification or assistance
• Spills that may involve health issues, injuries or fatalities; or require
protective actions, evacuations, or sheltering of victims (in-place or
other), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PS_Haz_ReportingGuidelines (type: esriFieldTypeString, alias: Events to Report:
• All Extremely Hazardous Substances (EHS) spills and releases.
• All EPCRA Section 304 chemicals that are spilled or released that
meet or exceed their reportable quantity (RQ) must be reported to
the State Watch Office by the facilities owner or operator.
• All spills or releases that may involve health issues, injuries or
fatalities; or require protective actions, evacuations, or sheltering of
affected population (in-place or other)In addition, federal/EPA reporting may be required from the responsible party (though can be submitted from elsewhere). A full list of EPA definied hazardous substances and their reportable quantities (RQ) can be found here., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PS_Subtype (type: esriFieldTypeString, alias: What type of pollutant was discharged?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PS_Status (type: esriFieldTypeString, alias: At time of reporting has the release been stopped?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Ongoing: Ongoing], [Stopped: Stopped])
FK_ColorChange (type: esriFieldTypeString, alias: Is there evidence of algae bloom conditions (shift to green water, murky water column, surface scum), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
FK_AlgaeDesc (type: esriFieldTypeString, alias: Please describe the algae bloom conditions, and genus, if known., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
FK_ChemicalActivity (type: esriFieldTypeString, alias: Has there been any known pesticide, herbicide, or fertilizer applications on or near the lake or waterbody?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Pesticide: Pesticide], [Herbicide_Aquatic: Herbicide (in-lake)], [Herbicide_Land: Herbicide (lakeshore)], ... 3 more ...)
FK_ChemicalActivityNotes (type: esriFieldTypeString, alias: Please describe the scale of application & responsible party, and where it took place, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
FK_Lesions_Sores (type: esriFieldTypeString, alias: Are there any lesions or sores on the fish bodies?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
FK_O2_Signs (type: esriFieldTypeString, alias: Are fish displaying signs of oxygen deprivation? ('sucking' at the water surface, jumping out of water, crowding around shallow areas etc.), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
FK_O2Level (type: esriFieldTypeDouble, alias: Enter the recorded DO level (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
BloomLocale (type: esriFieldTypeString, alias: Where is the bloom predominantly present (e.g. center of lake, boat dock, shorelines), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PublicProximity (type: esriFieldTypeString, alias: If the bloom is located near a public shore or park, please list these locations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BloomExtent (type: esriFieldTypeInteger, alias: Estimate the size of the bloom (sq.ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
BloomType (type: esriFieldTypeString, alias: What type of bloom is occurring?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Surface_filamentous: Surface (filamentous)], [Water_column: Water column], [Surface_and_Column: Both on the surface and in the water column])
BloomColor (type: esriFieldTypeString, alias: What color is the bloom?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Green: Green], [Blue: Blue], [Red: Red], ... 4 more ...)
BloomGenus (type: esriFieldTypeString, alias: If known, or guessed, enter the genus of the algae bloom species, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BloomCertainty (type: esriFieldTypeString, alias: Is this genus known or guessed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Guessed: Guessed], [Known: Known])
AdditionalNotes (type: esriFieldTypeString, alias: Please record any additional notes here:, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
PS_Source (type: esriFieldTypeString, alias: Select the source of pollutant to the lake, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Direct: Direct discharge to lake from shoreline], [Boat: Boat in the water], [Stormwater: Via stormwater system], ... 1 more ...)