This project created a reusable database and GIS map layers for roads and road-related assets in the town of Boxborough. Team members used a GPS unit to locate and evaluate the condition of all roads and road-related assets that had not already been inventoried and evaluated by the town. The information for each asset was entered into tables in the database and reports were created that calculate the values of the roads and assets so that a financial statement could be produced to satisfy the GASB Statement 34 reporting requirements. Our project also demonstrates the flexibility and reusability of the database for future use by the town for preventative maintenance, snow plowing, and budgeting predictions.
Worcester Polytechnic Institute
Interactive Qualifying Project
All authors have granted to WPI a nonexclusive royalty-free license to distribute copies of the work, subject to other agreements. Copyright is held by the author or authors, with all rights reserved, unless otherwise noted.