MisterGardner
commented
8 years ago You can also check [REHAB].[GIS].[COSTEST_ActionYears] should you want to see the projected spot repairs, failure years, lining years and whole pipe replace years for the APW spot repair option (liner option and whole pipe option are straight forward: today, 60 or 120 years from today).
[APWLineAtYear] is the minimum of the [APWWindowBSegFailureYear] for all segments of a pipe. [APWWindowBSegFailureYear] is the failure year of spots that are beyond the current 20 year window. [APWReplaceAtYear] is just 120 years from [APWLineAtYear].
The stored procedure REHAB.dbo.FinalTimes outputs a table that represents the current construction durations (construction + mobilization). The results are presented in hours, and are compared against the previous cost estimator times for whole pipe actions.
The table represents values for a pipe overall, and is broken down by compkey.
SpotTimeA is the time required to repair all spots within the primary window (20 years). SpotLineTimeB is the time required to repair all remaining spots (after the 20 year window) and line the pipe. If there are no spots in window B, this is just the amount of time required to line. WholePipeTime is the time required to replace a whole pipe, either through open cut or bore/jack. SpotLineTimeA is the time required to spot and line a pipe right now (in window A).
Streets specifically (lateral bypass mobility on liners) are what I am most concerned about right now.