Location Levels-ERD.png

The file "Location Levels-ERD.png" appears to be an image related to a database entity-relationship diagram (ERD) for the Corps Water Management System (CWMS).

The associated federal contract opportunity (Solicitation Number W912HQ25R0007) is a solicitation by the Department of the Army Corps of Engineers for developing an authorization scheme for the CWMS Data API. The contract objectives include implementing comprehensive database permissions (read, write, delete, create, and update) across a cloud-based system that will consolidate 32 previously independent geographic databases. The project will transition the current database from isolated systems to a single Oracle RDS instance with an HTTP REST API. The contract has a total performance period of 270 days, with specific task-based periods of performance detailed in the Performance Work Statement. The primary goal is to enhance the USACE's water resources management capabilities by creating a more robust and flexible data authorization framework for their water control and monitoring systems, which currently manage approximately 600 reservoir, lock, and dam projects.