Description
The California Department of Fish and Wildlife (CDFW) is issuing a Request for Information (RFI) to gather insights from vendors on the best approach to build an online California Monitoring Program (CMP) data management system. The system will be used to collect comprehensive data on anadromous salmonid populations to better inform and enhance efforts in salmon and steelhead recovery, conservation, and management. The CMP system needs to allow for efficient data upload and management within CDFW. Key features of the system include:
• Support for batch uploads of CSV, Excel, and Access files
• Integration with Azure AD for user authentication
• Role-based access control with restrictions at the table and field level
• Support for ad-hoc queries and data exports in CSV, Excel, and PDF formats
• A query builder interface for non-technical users
• Data validation and cleanup tools
• Backup and disaster recovery capabilities with daily, monthly, and annual backups
The system should be designed to scale with the growing needs of CDFW, with an expected doubling of the database size every ten years. The RFI is seeking information on the technical approach, costs, and timeline for the project.
Some key points to consider:
• The system will replace the current MS Access databases and SQL database
• The system should support bulk operations and single-record entry
• The system should be accessible to a minimum of 36 users
• The system should have a query builder interface for non-technical users
• The system should support data exports in CSV, Excel, and PDF formats