Sewer Overflow A Miami-Dade County

About This Dataset

This dataset has not yet been AI-described.

Key Metadata

Columns / Fields

Name Type Description
OBJECTID integer SewerOverflow: OBJECTID
INCIDENTID text A unique identification number assigned to this sewer overflow incident for tracking and reference purposes. AI
INCDNTDATE date The date and time when the sewer overflow incident occurred. AI
STATOWNER text The name or agency that owns and operates the pump station involved in the overflow. AI
STATNUM text The identification number assigned to the pump station involved in or responsible for the overflow. AI
UTILPHONE text The phone number of the utility company that manages the sewer system where the overflow took place. AI
JURISDCTN text The governmental jurisdiction or agency responsible for the sewer system where the overflow took place. AI
MUNIC text A code identifying which municipality in Miami-Dade County is associated with this sewer overflow incident. AI
HNUM text The house or building number associated with the street address where the overflow occurred. AI
PDIR text The directional indicator (such as North, South, East, or West) for the primary street or location of the sewer overflow. AI
STRNAME text The name of the street where the sewer overflow incident took place. AI
PSTRTYPE text The type of primary street (such as Avenue, Boulevard, Street, or Road) where the sewer overflow occurred. AI
SSTRTYPE text The type of secondary street (e.g., Street, Avenue, Road, Boulevard) for the address where the overflow occurred. AI
SDIR text The secondary direction component of the street address (e.g., North, South, East, West) for the location where the overflow occurred. AI
UNITNUM text An internal unit number or subdivision identifier for the location of the overflow. AI
ZIP text The five-digit postal zip code for the location where the sewer overflow occurred. AI
STRID integer A unique numerical identifier assigned to the street where the overflow occurred. AI
INTPRDIR1 text The directional indicator (such as North, South, East, or West) for the primary street at the intersection where the sewer overflow occurred. AI
INTSNAME1 text The name of the first secondary street at the intersection where the sewer overflow occurred. AI
INTPSTRTYPE1 text The type of primary street at the intersection (such as Avenue, Boulevard, Street, or Road) for the first street location. AI
INTSSTRTYPE1 text The type of secondary street (such as Avenue, Boulevard, Street, or Road) for the first intersecting street. AI
INTSDIR1 text The directional indicator (such as North, South, East, or West) for the first secondary street at the intersection. AI
INTPDIR2 text The compass direction or relative position of the second or alternative intersection near the overflow location. AI
INTSTNAME2 text The name of the second secondary street at the intersection where the sewer overflow occurred. AI
INTPSTTYPE2 text The type of primary street at the intersection (such as Avenue, Boulevard, Street, or Road) for the second street location. AI
INTSSTRTYPE2 text The type of secondary street (such as Avenue, Boulevard, Street, or Road) for the second intersecting street. AI
INTSDIR2 text The directional indicator (such as North, South, East, or West) for the second secondary street at the intersection. AI
ADDRESS text The street address where the sewer overflow incident occurred, provided as a text description of the location. AI
STARTDATE date The date and time when the sewer discharge or overflow began. AI
STOPDATE date The date and time when the sewer discharge or overflow stopped and was brought under control. AI
QUANDSCHRG integer The estimated volume of sewage that was discharged during the overflow, measured in gallons. AI
RPTNAME text The full name of the person who reported the sewer overflow incident to authorities. AI
RPTTITLE text The job title or position of the person who reported the sewer overflow incident. AI
RPTPHONE text The phone number of the person who reported the sewer overflow incident. AI
WEATHERCND text The weather conditions at the time of the overflow (e.g., rain, dry, storms), which may have contributed to the incident. AI
SPILLCONTAINED text Whether the sewer spill was contained (Y/N), meaning the overflow did not spread beyond a controlled area. AI
AREACLEANED text Indicator of whether the affected area was cleaned up following the sewer overflow incident (typically Y/N or Yes/No). AI
AREADISINFECT text Indicator of whether the affected area was disinfected after the sewer overflow to remove contamination (typically Y/N or Yes/No). AI
DISINFECTMETHOD text The technique or chemical used to disinfect the affected area after the sewer overflow. AI
TRACKNUM text A unique tracking or reference number assigned by the utility company to monitor this overflow incident. AI
VERSIONNUM text A version number indicating which iteration or update of the incident report this record represents. AI
UTILITYNAME text The name of the water or sewer utility company responsible for managing the infrastructure where the overflow occurred. AI
METHUSEDEST text The method or technique used to estimate how much sewage was discharged during the overflow. AI
ASBUILTATTACH text Reference or indicator for attached as-built drawings or technical documents related to the sewer infrastructure at this location. AI
NOASBUILT text An indicator (typically Yes/No) showing whether original construction plans (as-built drawings) are unavailable for the affected sewer infrastructure. AI
PIPEDIAMETER text The width of the sewer pipe where the overflow occurred, typically measured in inches. AI
PIPEMATERIAL text The material composition of the sewer pipe (such as PVC, concrete, clay, or cast iron). AI
PSMALFUNCTION text An indicator (typically Yes/No) showing whether a pump station malfunction was the cause of the sewer overflow. AI
WATDISCTYPE text The type or method of water discharge from the overflow (e.g., into a waterway, onto land, combined sewer). AI
WATDISCOTHER text Additional information about other water discharge locations or methods not covered by standard categories. AI
FLOWPATH text The general direction or route that the overflowed sewage flowed from the discharge point. AI
FLOWPATHDET text Detailed information about the specific path the sewage took as it flowed away from the overflow location. AI
DISCCAUSECAT text The broad category explaining what caused the sewer overflow to happen (such as blockage, infiltration, or equipment failure). AI
DISCCATDESC text A category description classifying the type or severity of the sewer discharge that occurred. AI
DISCHARGECAUSE text Specific details about what caused the sewer to overflow at this location. AI
ADDWATERCAUSE text Additional explanation of what caused excess water to enter the sewer system during this incident. AI
ESTGALRECOVER integer Estimated number of gallons of sewage that was recovered or contained during cleanup efforts. AI
DISCSURFWAT text Indicator of whether the overflow discharged into a surface water body like a canal, river, or bay (typically Y/N or Yes/No). AI
WATBODYTYPE text The type of surface water body (e.g., canal, river, bay, inlet) where the overflow discharged. AI
WATBODYOTHER text Additional details or alternative name for the surface water body that received the overflow discharge. AI
SURFWATNAME text The name of the surface water body (such as a canal, river, or bay) where the overflow discharged. AI
DISTTOSURFWAT integer The distance in feet from the overflow location to the nearest surface water body such as a canal or bay. AI
DISCSTORMWATER text Indicator of whether the overflow discharged into the stormwater drainage system (typically Y/N or Yes/No). AI
DRAINSIMPACTED integer The number of stormwater drains or catch basins that were affected by the sewer overflow. AI
DISTTOSTORMDRAIN text The distance, typically measured in feet, from the overflow location to the nearest stormwater drain. AI
STORMDRAINDIR text The compass direction (e.g., North, South, East, West) toward which stormwater was draining during the overflow. AI
DISCINPUBACCESS text Indicator of whether sewage discharged into an area accessible to the public, such as a street or park (typically Y/N or Yes/No). AI
SMARTCOVERBASIN text Indicates whether a smart cover basin system is present at the overflow location, used to monitor and detect sewer issues. AI
PUBLICNOTIFIED text An indicator (typically Yes/No) showing whether the public was informed about the sewer overflow incident. AI
NOTIFICATIONMETHOD text How the public was informed about the sewer overflow (such as email, phone, website notice, or media). AI
NOTIFICATIONDATE date The date when the public was notified about the sewer overflow incident. AI
DATEACTTAKEN date The date when corrective action was taken to stop or remediate the sewer overflow. AI
SPILLOBSERVED text Whether an active sewer spill was visually observed (Y/N) at the time of the incident. AI
REPSSOLOC text An indicator (typically Yes/No) showing whether this location has had multiple sewer overflows (SSO) incidents. AI
DATEATLOC date The date when staff were last present at the location where the sewer overflow occurred. AI
GALLONSATLOC text Amount of sewage, measured in gallons, that was released at the overflow location. AI
REPAIRTYPE text The category or type of repair that was performed to fix the sewer system problem that caused the overflow. AI
STEPSTOPREVENT text A description of the actions or measures taken to prevent or stop the sewer overflow from continuing. AI
IMPACTONPUBLIC text Description of how the sewer overflow affected nearby residents and the public, such as property damage or health concerns. AI
ENFTICKETNUM text Reference number of any enforcement or violation ticket issued in response to this sewer overflow incident. AI
COMMENTS text Additional notes and details about the sewer overflow incident recorded by staff. AI
MODIFIEDBY text The name or ID of the person or system that last updated this sewer overflow record. AI
MODIFIEDDATE date The date when this sewer overflow record was last modified or updated. AI
CREATEDBY text Name or identifier of the person who created this incident record in the system. AI
CREATEDDATE date The date when this incident record was first entered into the system. AI
POINT_X number The X-coordinate (easting value) of the sewer overflow location in a coordinate system used for mapping. AI
POINT_Y number The Y-coordinate (northing value) of the sewer overflow location in a coordinate system used for mapping. AI
LON number The longitude coordinate (a number between -180 and 180) indicating the east-west location of the sewer overflow on Earth. AI
LAT number The latitude coordinate (a number between -90 and 90) indicating the north-south location of the sewer overflow on Earth. AI
GlobalID text SewerOverflow: GlobalID

Related Datasets

Quality Breakdown

A Composite Score: 96%
100%
86%
100%

Findings

  • Row count not available