Name: Wastewater Historical Spills
Display Field: CALLER_NAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: The WCAP Sanitary Sewer Overflow map and GeoForm were created to be able to accurately locate all sanitary sewer overflows (SSO) within the state and to be able to associate those spills to a specific wastewater treatment plant or individually/privately owned wastewater collection systems. The tool will also be able to quickly pinpoint any spills that occurred within a one mile radius of a DOH Beach Monitoring Site that could potentially be associated with a routine bacteriological sampling failure. Additionally, recording data in this manner will further standardize the reported data collection process, and the information will readily be available to the public through Department links. Statewide data will be stored in a single file location eliminating the possibility of duplicative records and easing the retrieval of data during records requests.
All data reported to the SWO will be monitored and entered daily into the ArcGIS GeoForm by Tallahassee WCAP Staff. Spills reported to the individual district offices will be entered directly by them into the GeoForm. Data can be made available in an Excel format in addition to the map. All data whether entered by Tallahassee or the district offices will undergo rigorous QA/QC protocol for data consistency and mapping accuracy.
Copyright Text: FDEP, RM
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -9744241.5816162
YMin: 2816495.32635916
XMax: -8888683.04330374
YMax: 3634582.4609287
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[245,122,182,255],"size":3,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.52499999999999991}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- INCIDENT_ID (type: esriFieldTypeString, alias: Incident ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- DATE_REPORTED (type: esriFieldTypeDate, alias: Date Reported, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- DESCRIPTION (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 500, nullable: false, editable: true)
- INCIDENT_DATE (type: esriFieldTypeDate, alias: Incident Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- INCIDENT_LOCATION (type: esriFieldTypeString, alias: Incident Location, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- COUNTY (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true, Coded Values: [ALACHUA, FL: ALACHUA, FL], [BAKER, FL: BAKER, FL], [BAY, FL: BAY, FL], ... 82 more ...)
- DISTRICT (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 200, nullable: false, editable: true, Coded Values: [Central: Central], [Northeast: Northeast], [Northwest: Northwest], ... 3 more ...)
- CALLER_NAME (type: esriFieldTypeString, alias: Caller Name, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
- AFFILIATION (type: esriFieldTypeString, alias: Affiliation, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
- RESP_FACILITY_NAME (type: esriFieldTypeString, alias: Permitted Utility Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- PERMITTED_FACILITY (type: esriFieldTypeString, alias: Permitted Facility, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [UNK: Unknown])
- RESP_FACILITY_PERMIT_ID (type: esriFieldTypeString, alias: Permitted Utility ID, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- FACILITY_TYPE (type: esriFieldTypeString, alias: Facility Type, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true, Coded Values: [DW: Domestic Wastewater], [IW: Industrial Wastewater])
- WASTEWATER_CHARACTERISTICS (type: esriFieldTypeString, alias: Wastewater Characteristics, SQL Type: sqlTypeOther, length: 200, nullable: false, editable: true, Coded Values: [Biosolids: Biosolids], [Partially Treated: Partially Treated], [Reuse: Reuse], ... 3 more ...)
- CAUSE (type: esriFieldTypeString, alias: Cause, SQL Type: sqlTypeOther, length: 200, nullable: false, editable: true, Coded Values: [Accident: Accident], [Blockage: Blockage], [Break-in-Line: Break-in-Line], ... 13 more ...)
- SPILL_VOLUME (type: esriFieldTypeDouble, alias: Initial Spill Volume, SQL Type: sqlTypeOther, nullable: false, editable: true)
- VOLUME_RECOVERED (type: esriFieldTypeDouble, alias: Volume Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WATERBODY_AFFECTED (type: esriFieldTypeString, alias: Water Body Affected, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- CLEANUP_ACTIONS (type: esriFieldTypeString, alias: Clean-up Actions, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
- CLEANUP_STATUS (type: esriFieldTypeString, alias: Clean-up Status, SQL Type: sqlTypeOther, length: 200, nullable: false, editable: true, Coded Values: [Complete: Complete], [In-progress: In-progress], [Planned: Planned], ... 1 more ...)
- CREATED_BY (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: false)
- CREATION_DATE (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- EDITED_BY (type: esriFieldTypeString, alias: EditedBy, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: false)
- EDIT_DATE (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- POINT_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
- POINT_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
- INCIDENTNAME (type: esriFieldTypeString, alias: INCIDENT NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SWOINCIDENTID (type: esriFieldTypeString, alias: SWO INCIDENT ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- NONPERMITTEDUTILITY (type: esriFieldTypeString, alias: Non Permitted Satellite Collection Systems, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- FINALSPILLVOLUME (type: esriFieldTypeDouble, alias: Final Spill Volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: Wastewater Historical Spills
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- DESCRIPTION:
- COUNTY:
- DISTRICT:
- CALLER_NAME:
- AFFILIATION:
- FACILITY_TYPE: DW
- WASTEWATER_CHARACTERISTICS:
- CAUSE:
- SPILL_VOLUME: 0
- CLEANUP_STATUS:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/7/2020 3:43:57 PM
Schema Last Edit Date: 10/7/2020 3:43:57 PM
Data Last Edit Date: 10/7/2020 3:43:57 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat