The City of Bryan has numerous hydraulic and hydrologic studies completed for their watersheds, but needed a way to combine the information from these studies and implement a plan for improvements. This project consists of managing and prioritizing various problems and projects that were identified from various studies, and then develops a ranked capital improvement plan (CIP).
Microsoft Access was used to make the CIP more sustainable and user friendly. The Access database is an electronic tool that can be used to link data from different sources, such as Geo-Informational Systems (GIS) or reports, and organize them into one location. CIPs were selected from previous masterplans, watershed studies, work orders and City input. The CIPs were then entered into the database that the City can continuously update with new projects and data. Using a list of weighted criteria approved by the City, the projects are scored and ranked within the database, which provides the City an objective view of the projects that should be completed with highest priority.