dTIMS CT

107 Pages·2006·7.22 MB·English

Table of Contents
...........................................................................................
Table of Contents i
................................................................................................
List of Figures v
..
..............................................................................................
List of Tables vtt
..........................................................................................
List of Equations ix
. .........................................................................................
1 Introduction 1
.....................................................................................................
1.1 Scope of Work 1
...........................................................................................................
1.2 This Report 1
. - .........................................................
2 The PMS Database dTIMS CT 3
...............................................................................................
2.1 Perspective Types 3
2.1.1 Section Perspective .............................................................................................................4..
2.1.2 Point Perspective ............................................................................................................... 4
2.1.3 Lane Perspective .................................................................................................................. 4
2.1.4 Historic Perspective ............................................................................................................. 5
2.1.5 Repeating Point Perspective. .............................................................................................5..
2.1.6 Exclusive Point Perspective. ..............................................................................................5..
2.1.7 Many to One Perspective. .................................................................................................. 6
2.1.8 One to Many Perspective. ..................................................................................................7..
2.1.9 Independent Perspective ................................... .... .............................................................7.
..............................................................................................
2.2 Database Structure 8
2.2.1 The Roads Perspective .........................................................................................................8
2.2.2 The Inventory Perspective. ................................................................................................9..
2.2.3 The Condition-Current Perspective. ..............................................................................1..1
2.2.4 The REMARKS Perspective .............. . ............................................................................1. 4
2.2.5 The Aset-Network Perspective ........................................................................................ 15
2.2.6 The ASET-Network-Variables Perspective ..................................................................1..6
2.2.7 The ASET-Network-Budgets Perspective ...................................................................... 16
2.2.8 The ASET-Network-Treatments Perspective ................................................................. 17
...............................................................................................
2.3 Data Preparation 17
................................................................................................
2.4 Transformations 19
2.4.1 Perspective Transformation .............................................................................................. 20
2.4.2 Formula Transformation. .................................................................................................2..1
2.4.3 Cross-Tab Transformation. ..............................................................................................2.5.
2.4.4 Curve Transformation ....................................................................................................... 27
2.4.5 Batch Transformations. ...................................................................................................... 30
by: Deighton Associates Ltd . Powell River PMS Final Report
. .
2.4.5.1 The CPI Batch Transformation ................................................................................................... 31
I . - ....................................................
I 3 The PMS Parameters dTIMS CT 35
j
.............................................................................................
3.1 Condition Indices 35
............... .........................................................................
3.2 Pavement Distresses : 36
j
.................................................................................................
3.3 CPI Calculation 37
...............................................................
I 3.4 Performance Curves Development 41
. .
I 3.4.1 Pavement Famhes. ............................................................................................................. 42
3.4.2 Curve Development ..........................................................................................................4. 3
. - ........................................................
I 4 The PMS Analysis dTIMS CT 45
I
............................................................................................
4.1 Analysis Variables 45
4.1.1 The Static Analysis Variable. .......................................................................................... 45
4.1.2 The Annual Analysis Variable ....................................................................................... 46
4.1.3 The Dynamic Analysis Variable ............................. ............ .............................................. 46
4.1.4 The Compilation Analysis Variable ................................................................................. 46
.................................................................................................
4.2 The Treatments 50
4.2.1 Treatments and Costs ........................................................................................................ 52
4.2.2 Treatment Rese .............................................................. 53
............................................................................................
4.3 The Trigger Limits 55
.................................................................................
4.4 The Traffic Growth Rate 56
.......................................................................................................
4.5 Analysis Set 57
.............................................................................................
4.6 Budget Categories 61
..............................................................................................
4.7 Budget Scenarios 61
...........................................................................................
4.8 Benefit Calculation 63
5. The Results of the dTIMS CTAnalysis ........................................ 67
.................................................
5.1 The Recommended Construction Program 67
..
5.1.1 The Do-Nothing Strategy ..................... ........................................................................ 68
5.1.2 Maintenance Only Strategy ...........................6 8
5.1.3 The Strategy List .................. .. ......................................................................................6.8.
5.1.4 Optimization .....................................................................................................................7..0
5.1.5 The Five Year Powell River Construction Program ....................................................... 72
...........................................................................
5.2 Budget Scenario Summaries 73
..........................................................................
5.3 Average Network Condition 76
......................................................................................
5.4 Return on Investment 78
. ................................................
6 Recommendations and Conclusions 80
..............................................
6.1 Recommendations for future improvements 81
..
6.1.1 Software Upgrades ................................ .......................................................................8 1
6.1.2 Historical Database ........................................................................................................... 82
Powell River PMS Final Report by: Deighton Associates Ltd .
. .
6.1.3 Condibon Surveys .............................................................................................................. 82
6.1.4 Future Model Development .............................................................................................8. 3
6.1.5 Security. ................................................................................................................................ 84
........................................................................................................
6.2 Conclusions 85
.
by: Deighton Associates Ltd Powell River PMS Final Report
List of Figures
Figure 1: Example of Inventom elements along a route ......................................................................... 11
Figure 2: Example of Condition Current elements along a route ........................................................ 14
Figure 3: Sorted List of Transformations in Batch ..................................................................................1 9
Figure 4: Perspective Transformation Property Window ...................................................................... 21
Figure 5: Formula Transformation Property 14~indow.. .......................................................................2..5
Figure 6: Cross-Tab Transformation Property Window. ........................................................................ 26
Figure 7: Cross-Tab Values Editing Window .......................................................................................... 27
Figure 8: Curve Transformation Property Window ............................................................................... 28
Fiqure 9: Curve Point Values Editing Window ......................................................................................2. 9
Figure 10: Plot of Curve Values Window .............. . ............................................................................. 30
Fimre 11: Plot of Performance Curves used in dTIMS CT .................................................................... 44
Figure 12: Analysis Variable Propertv Screen for nCND CPI .............................................................4. 8
Figure 13: Analysis Set Window and Setup ............................................................................................ 58
Figure 14: Budgrt Allocation bv Bude.e t Category and Budget Scenario ............................................6 2
Figure 15: Efficiency Frontier on the Browse Strateeies Screen ............................................................ 63
Figure 16: Do-Nothing Stratem Performance ........................................................................................6. 8
Figure 17: Typical Stratem List for One Network Section. ................................................................. 69
Figure 18: Typical Strategv Performance ................................................................................................ 69
Figure 19: Treatment List for a stratem. ............... .. .............................................................................. 70
Figure 20: Efficiencv Frontier for a Tvpical Section ................................................................................7 2
Figure 21: $2 Million Road Network Condition Distribution ................................................................ 73
Figure 22: Network Condition Category Window ................................................................................ 74
Figure 23: $2 Million Network Travel Distribution ............................................................................. 75
Figure 24: Averave Network Condition for Road Network ........................... .... ............................7 7
Figure 25: Return on Investment for Road Network .............................................................................. 79
.
Powell River PMS Final Report by: Deighton Associates Ltd
List of Tables
Table 1: dTIMS CT Perspective Setup ......................................................................................................... 8
Table 2 : Inventory Perspective Attributes ............................................................................................... 10
Table 3 : Condition-Current Perspective Attributes ............................................................................... 13
Table 4: REMARKS Perspective Example ................................................................................................ 15
Table 5: dTIMS CT Strategy Perspective Attributes ............................................................................... 15
Table 6: dTIMS CT Analysis Variables Perspective Attributes ............................................................. 16
Table 7: dTIMS CT Analysis Budgets Perspective Attributes ............................................................. 17
Table 8: dTIMS CT Analysis Treatments Perspective Attributes .......................................................... 17
Table 9: Perspective Transformation Summary. ...................................................................................... 20
Table 10: Cross-Tab Transformation Summary .................. . ............................................................... 27
Table 11: Batch Transformation in dTIMS CT ........................................................................................ 31
Table 12: "Cm" batch transformation contents .................................................................................... 33
Table 13: Pavement distresses being surveyed .................................. .. ................................................3. 6
Table 14: Pavement distress density calculations. ...................................................................................3 8
Table 15: Pavement distress density weight calculations ....................................................................3..9.
Table 16: Pavement distress weights for distress severity level. ......................................................... 39
Table 17: CPI equation ................................................................................................................................ 40
Table 18: Overall CPI weights for each distre .....s................s................. ...
Table 19: Pavement types in the PMS ................................................................................................. 43
Table 20: Performance Cunres as defined for Powell River ................................................................... 44
Table 21: Analysis variables used in Powell River .............................................................................. 47
Table 22: Treatment descriptions and Budget Categories. ..................................................................... 51
Table 23: Treatments and Cost Expressions ............................................................................................. 53
Table 24: Treatment reset expressions ...................................................................................................5..4.
...........
Table 25: CPI Ranges and Descriptions ............................ ............................................................. 60
Table 26: Budget Scenarios ......................................................................................................................... 61
Table 27: Projected Condition Distribution
Table 28: Projected Travel Distribution for
Table 29: $2 Million Budget Expenditure and Predicted Average Network Condition .................... 77
by: Deighton Associates Ltd . Powell River PMS Final Report
List of Equations
Equation 1: General form of deterioration equation ..............................................................................4. 3
Equation 2: Generic treatment reset equation. ......................................................................................... 54
Equation 3: AADT growth equation ........................................................................................................ 57
Equation 4: Area Under the Curve Benefits equation ...........................................................................6. 3
Equation 5: PV Benefit equation used in dTIMS CT ............................................................................... 64
Powell River PMS Final Report by: Deighton Associates Ltd.
Chapter 1. Introduction
1. Introduction
Deighton Associates Limited (Deighton) entered into an Agreement with EBA
Engineering Consultants Ltd. (EBA) to supply the Corporation of the District of
Powell River (Powell River) a pavement management solution. The detailed
scope of services and terms of the Agreement were developed as part of
negotiations between EBA and Powell River.
1.1 Scope of Work
The scope of work on this project for Deighton includes the customization and
implementation of a computer based pavement management system (PMS) for
the production of a recommended, multi-year, optimized list of Powell River
street rehabilitation work.
The goal of this project is the implementation of an automated system for the
management of the paved elements of Powell River's road network. The
objective of the project is the production of an optimized, recommended
pavement rehabilitation program based on data and analysis parameters specific
to Powell River. The project is structured to direct all activities towards
addressing each of these issues.
1.2 This Report
This report is intended to explain the development of Powell River's PMS and
summarize the results of the initial network analysis.
by: Deighton Associates Ltd. Powell River PMS Final Report
Chapter 1. Introduction
I
1
The main elements of the report are the following:
I
* a description of the dTIMS CT software and its implementation as both
the data repository and the analysis component of the PMS;
a presentation of the results of the PMS analysis, and;
a series of conclusions and recommendations made by Deighton
regarding the continued maintenance and enhancement of the PMS.
Powell River PMS Final Report by: Deighton Associates Ltd.
Chapter 2: The PMS Database - dTIMS CT
-
2. The PMS Database dTIMS CT
dTlMS CT, a 32 bit WindowsT~a pplication, is a flexible database manager
developed exdusively to handle problems which are associated with linear
infrastructure.
Data for the PMS is maintained by dTIMS CT. In dTIMS CT, the user is allowed to
define a number of Perspectives. A perspective can be thought of as a view of the
network that is used to store section limits and point location information.
Therefore, the database can have an inventory perspective that defines pavement
inventory sections, a traffic perspective to define traffic sections, a bridge
perspective to define the location of bridges and so on. Each perspective is then
subdivided into a number of Attributes or database Fields that contain the specific
records relating to the perspective.
This multi level approach to the database will be used to develop a logical database
structure that will be used to store historical and current data. The structure of the
database is at all times open to the user for modification and expansion as required.
dTIMS CT also allows data to be accessed using ODBC. This permits dTIMS CT to
access data in external files and yet keep the data in its native database format, such
as Oracle or Microsoft Access. dTIMS CT then is used to maintain the location
referencing. The ODBC component of dTIMS CT was not utilized in this project.
2.1 Perspective Types
In dTIMS CT there are nine perspective types: (1)s ection, (2) point, (3) lane, (4)
historic, (5) repeating point, (6) exclusive point, (7) many to one, (8) one to many and
by: Deighton Associates Ltd. Powell River PMS Final Report