Case Studies
WateReuse Association – National Water Reuse Database (NWRD)
EPIC delivered WateReuse’s NWRD—unifying state/utility data with public access and powerful admin controls.
Introduction
The WateReuse Association—a nonprofit advancing water reclamation, recycling, reuse, and desalination—selected EPIC to assess, design, implement, and support the National Water Reuse Database (NWRD).
Building on a comprehensive needs assessment and gap analysis, EPIC delivered a modern, web‑based platform that unifies diverse state and utility datasets, enables public and member access, and provides administrators with powerful quality control and reporting tools.
Challenge
WateReuse needed a national‑scale system that could:
- Replace a legacy solution that couldn’t track chronological history of utility/facility data
- Standardize and validate submissions from hundreds of utilities and facilities with different formats, hierarchies, and nomenclature
- Support public transparency while protecting members‑only content via the Association’s website
- Integrate with the existing membership database for seamless, role‑based access
- Deliver exportable reports, consistent units of measure (SI/US), and administrator tools to curate data quality
Solution
EPIC partnered closely with WateReuse staff and a large, diverse stakeholder community to deliver NWRD from assessment through production and training.
Assessment & Design
- Stakeholder‑driven needs assessment & gap analysis across utilities, agencies, researchers, and practitioners
- Consensus building on data standards, taxonomy, and historical tracking requirements
- Flexible data model designed to accommodate heterogeneous state survey formats and evolving schemas
Platform & Architecture
- Web application: ASP.NET with SQL Server database
- Membership DB integration: Seamless SSO/entitlement to public vs. members‑only areas
- Scalability & security: Architecture sized for 7,000+ users with granular roles (View, Edit, QC, Admin)
Key Capabilities
- Public transparency: Read‑only access to selected datasets for the general public
- Data onboarding: Integrate data from accessible state systems; authorized users add/edit utilities/facilities
- Data quality controls: Built‑in validations; unit consistency (SI/US); chronological history tracking
- Notifications: Automated email alerts to participating utilities during cycles
- Reporting: Printable, well‑organized reports with hierarchical groupings; admin custom queries
- Change management & training: Train‑the‑trainer program, comprehensive user manual, and production deployment support
- Data migration: Initial migration from three large states (CA, TX, FL) to seed national coverage
Solution highlights
- Public Transparency
- Data onboarding
- Data Quality controls
- Notifications
Insights
≥ 80%
Duplicate & conflict reduction
≥ 95%
Historical completeness
100%
Of edits and approvals captured with user, timestamp, and version history, Auditability
Results
- National platform delivered: A modern, extensible web application that centralizes water reuse data and supports public transparency
- Data you can trust: Flexible schema and QC enforce unit consistency and historical tracking across heterogeneous sources
- Efficient operations: Automated notifications, admin queries, and printable reports streamline data cycles and communication
- Scalable security: 7,000+ user capacity with granular roles protects sensitive functions while promoting broad access
- Sustained adoption: Migration of CA, TX, and FL datasets jump‑started national coverage; train‑the‑trainer and manuals accelerated onboarding
Polk County Utilities
EPIC conducted thorough needs analysis and process mapping, always eager to troubleshoot, provide solutions, and collaborate effectively with all stakeholders.
Seminole County Environmental Services Division
Our partnership with EPIC Engineering & Consulting Group has modernized Seminole County Environmental Services, improving efficiency, data integrity, and project workflows.
City of Orlando
EPIC has been a trusted partner in our digital transformation. With Simplify i3, we eliminated duplicate data, reduced spreadsheets, and streamlined operations in a cloud-based system.
Talk to an expert about your challenge today
contact us