Name: Sanitary Sewer Overflow Reports Since 2018

Display Field: EXCURSIONID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <p>This feature represents reported incidents of Sanitary Sewer Overflows (SSOs) occurring since 2018 within a specific geographic area. Each point identifies a location where an overflow event was documented, capturing details critical for understanding and managing these events.</p><p><strong>Key data attributes include:</strong></p><ul><li>Unique identifiers and location data such as latitude, longitude, address, city, state, and zip, which help pinpoint the exact overflow site.</li><li>Event timeline information including start and end dates and times, which aids in assessing the duration and timing of each overflow.</li><li>Quantitative measures such as gallons per minute (GPM) and total volume lost, which are essential for evaluating the severity of each event.</li><li>Descriptive fields covering potential impact, cause, actions taken, and recurrence prevention efforts, providing insights into the nature of the overflows and response strategies.</li></ul><p>This dataset is valuable for municipal, environmental, and public health agencies to monitor, analyze, and manage sanitary sewer systems effectively. By tracking overflow incidents spatially and temporally, agencies can prioritize interventions, investigate causes, and implement measures to reduce the frequency and impact of these overflows.</p>

Copyright Text:

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: 2932721.82666655
YMin: 13729197.3465656
XMax: 3213763.76028741
YMax: 13964102.1464401
Spatial Reference: 102740 (2278)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[153,65,84,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Time Info:

Start Time Field: STARTDATE
End Time Field: null
Track ID Field: null
Time Extent
[1/2/2018 12:00:00 AM UTC, 8/7/2024 5:00:00 AM UTC]

Time Reference: UTC
Time Interval: 0
Time Interval Units:
Has Live Data: false
Export Options:

Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• EXCURSIONID (type: esriFieldTypeDouble, alias: ExcursionID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• STATE (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ZIP (type: esriFieldTypeInteger, alias: Zip, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BASIN (type: esriFieldTypeString, alias: Basin, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MANHOLE (type: esriFieldTypeString, alias: Manhole, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• WWTP (type: esriFieldTypeString, alias: WWTP, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• NOTOBSERVED (type: esriFieldTypeString, alias: Not Observed, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• STARTDATE (type: esriFieldTypeDate, alias: Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• STARTTIME (type: esriFieldTypeDate, alias: Start Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ENDDATE (type: esriFieldTypeDate, alias: End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ENDTIME (type: esriFieldTypeDate, alias: End Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GPM (type: esriFieldTypeDouble, alias: GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTALVOLLOST (type: esriFieldTypeDouble, alias: Total Volume Lost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DURATION (type: esriFieldTypeInteger, alias: Duration, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STRUCTURETYPE (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• FLOWLOCATION (type: esriFieldTypeString, alias: Flow Location, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SYSTEM (type: esriFieldTypeString, alias: System, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• POTENTIALIMPACT (type: esriFieldTypeString, alias: Potential Impact, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• CAUSE (type: esriFieldTypeString, alias: Cause, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true)
• ACTION (type: esriFieldTypeString, alias: Action, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• RECURRENCEPREVENTION (type: esriFieldTypeString, alias: Recurrence Prevention, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• RSSO (type: esriFieldTypeString, alias: RSSO, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SSOOCCURRENCECOUNT (type: esriFieldTypeInteger, alias: SSOOCCURRENCECOUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLOCKAGELOCASSETTYPE (type: esriFieldTypeString, alias: BLOCKAGELOCASSETTYPE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• BLOCKAGELOCUFID (type: esriFieldTypeInteger, alias: BLOCKAGELOCUFID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STOPPAGELOCATION (type: esriFieldTypeString, alias: STOPPAGELOCATION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)

Templates:

Name: SSO_Since_2018
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/15/2026 8:28:11 PM

Schema Last Edit Date: 5/15/2026 8:28:11 PM

Data Last Edit Date: 5/15/2026 8:28:11 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat