In July 2007, a plan to generate this database was developed in consultation with IWR’s Navigation Data Center’s staff and contractor resources based on a preliminary analysis of existing databases (P2, CEFMS NERI, ORM, Hydropower, Environmental Stewardship, etc). Based on a limited understanding of the ecosystem restoration business process, the analysis found that none of the existing databases met HQ requirements for an ecosystem restoration database. An ecosystem restoration database could be developed as a module to OMBIL, similar to ORM, capitalizing on existing software and hardware assets and compliance with the Corps’ corporate data and spatial standards. Integrating with OMBIL also has the potential of data-linking with the OMBIL Environmental Stewardship and Inspection of Completed Works modules, providing an opportunity for program management forecasting. This project will integrate the ecosystem restoration database as an OMBIL module using the Navigation Data Center as the system architect coordinator and adviser to ensure conformance and integration within the corporate data framework.
The plan uses existing Navigation Data Center contracts with SAM personnel to maximize efficiency and manage costs, thereby avoiding duplication and ensuring integration and data linking within the Corps’ enterprise structure. Due to the size and complexity of the work, the project was broken down into two phases, with each phase broken down further into smaller goal-associated stages. Phase I concentrated on creating and populating the new database, building an upward reporting tool to access the database and generating reports on a national, division and district level. The ERBL database uses a combination of three types of fields: those already found in the USACE P2 OFA (Oracle Financial Analyzer) database; those already found in the NOAA National Estuarine Restoration Inventory (NERI) database; and newly created fields based on the customer’s needs. Phase I concluded in the spring of FY 2010. Phase II (FY 2010) focused on refining the database based on a field test of the beta version. Phase II also consisted of the development of a mitigation database for civil works projects. FY 11 will see the continued refinements of the ERBL and Mitigation databases, the development of various reports and analyses, and additional activities as needed by management.