ProjectBuilder

Transportation Asset Management Project Builder

This repository contains two folders: PbDesktop and PbWeb that host, respectively, development environments for the deskto and web-based versions of TAM-ProjectBuilder system.

TAM-ProjectBuilder (PB) was originally designed and developed by Spy Pond Partners, LLC (SPP) for Pennsylvania Department of Transportation (PennDOT). The purpose of the system is to help the stuff of the agency with creation and scheduling of maintenance and repair projects for transportation infrastructure. The system performs this task by grouping together the treatments prescribed independently by various sources, including PennDOT’s bridge and pavement asset management systems. PennDOT’s Bridge Asset Management System (BAMS) is an implementation of iAM BridgeCare. PennDOT’s Pavement Asset Management System (PAMS) is an implementation of iAM RoadCare.

ProjectBuilder by itself does not employ any engineering knowledge fully relying in this aspect on the treatment prescriptions generated by BAMS and PAMS serving for these two systems as a kind of post-processor. Besides grouping the treatments of PAMS and BAMS ProjectBuilder also allows users to add their own treatments and projects that go beyond the scope of bridge and pavement management, such as, e.g., Safety or Mobility.

When combining the input treatments ProjectBuilder considers their proximity in timing as well as on the ground striving to group activities along contiguous segments of roads, shifting if needed their scheduling staying within existing budgeting constraints. The latter objective is attained via solving the scheduling problem using mixed-integer linear programming.

While having its own fairly compact Microsoft SQL Server ™ database, ProjectBuilder communicates with BAMS and PAMS via Excel documents that also serve as reports for the users.
ProjectBuilder features ample user interface that includes GIS-component that allows projects’ visualization on multi-layered geographical map.

ProjectBuilder is developed in .NET/C# and T-SQL. It embeds third-party components and libraries, such as COIN-OR Symphony and Sylvan Excel, all of which are in the public domain.