Creating a reusable road infrastructure asset and maintenance tracking system for better management and financial reporting in Boxborough, Massachusetts

Lashmit, Matthew; Lashmit, Thomas C.

Student Work

Creating a reusable road infrastructure asset and maintenance tracking system for better management and financial reporting in Boxborough, Massachusetts

Public

Our project was to create 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 were not already 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 made 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, budgeting predictions, etc.

This report represents the work of one or more WPI undergraduate students submitted to the faculty as evidence of completion of a degree requirement. WPI routinely publishes these reports on its website without editorial or peer review.

Creator

Subject

Publisher