Stormwater MS4 Asset Management Software

The Vendor is required to provide an “out-of-the-box,” cloud-based Stormwater Software-as-a-Service (SaaS) solution.
- Software will support the city’s ongoing compliance with the regional municipal separate storm sewer system (MS4) System Permit (MS4 Regional Permit).
- The system will centralize Stormwater data management and support the implementation of the Stormwater Management Program (SWMP) across the City’s Engineering, Operations & Maintenance, and Regulatory Compliance teams.
- Centralized stormwater data management by organizing all essential and required stormwater information into a single GIS-enabled database, including, but not limited to:
•    Outfall inspections and illicit discharge investigations.
•    Construction site inspections, plan reviews, and enforcement actions.
•    Post-construction Best Management Practices (BMPs) tracking, verification, and long-term maintenance.
•    Public education/outreach activities and documentation.
•    Municipal operations, facility inspections, street sweeping, and good housekeeping records.
- Core System Capability
•    Cloud-based SaaS solution with 99.9% uptime
•    ArcGIS integration for spatial data management
•    Mobile-responsive interface for field operations
•    Offline capability for field data collection
•    Role-based access control and user management
- Primary User Roles and Responsibilities
•    Engineering Staff: Asset management, compliance tracking, reporting
•    Field Inspectors: Mobile data collection, inspection workflows
•    Operations & Maintenance Teams: Asset maintenance scheduling, performance tracking
•    Management: Dashboard reporting, budget planning
- Data Management
•    Centralized database for all stormwater program data
•    Import/export capabilities for existing City data
•    Data validation and quality control mechanisms
•    Audit trail for all data modifications
•    Backup and disaster recovery capabilities
- GIS Integration Requirements
•    Native ArcGIS Online/Enterprise integration
•    ArcGIS Field Maps compatibility
•    ArcGIS Workforce integration for task assignment
•    ArcGIS Hub integration for public outreach
- City System Integration Requirements
•    Active Directory authentication
•    City's Amazon Web Services (AWS) environment compatibility
•    Existing asset management system data migration
- System Performance Requirements
•    Support 50+ concurrent users
•    Mobile app response time <3 seconds
•    Report generation <30 seconds for standard reports
•    99.9% system availability during business hours
- Data Performance Requirements
•    Real-time data synchronization between field and office
•    Support for 10,000+ stormwater assets
•    10-year data retention capability
- Map-Based Interface
•    Provide an interactive map utilizing Esri ArcGIS base mapping services to display stormwater asset locations, operational phase, and condition based on the latest inspections.
•    Allow users to select an asset, project, or facility to view detailed information, including design attributes, contributing drainage areas, priority classifications, consequence-of-failure ratings, and other relevant metadata.
•    Display pop-up dialogs showing tabular details, inspection histories, photos, and related documents.
•    Support categorization and querying of assets, projects, and facilities by drainage area, receiving waters, or maintenance zones.
•    Display relevant map layers for stormwater planning, including flow direction, storm drains, outfalls, streams, waterbodies with 303(d) status, land use, and other layers supporting Minimum Control Measure (MCM) compliance.