HomeMy WebLinkAboutRESPONSE - PURCHASE ORDER - 9116052Bridge Database 2011-0021
Fort Collins, CO.
Prepared by: Gary Ruck. P. Eng.
gary.ruck@deighton.com
Friday, October 07, 2011
0
1
Fort Collins has requested that Deighton Associates prepare a proposal for
enhancement and expansion of the previous work done in conjunction with the
management of bridges within dTIMS CT.
To date we have worked with Fort Collins to import an initial set of structures
information into dTIMS CT and have established links to a map based user interface
into the structures information. The information includes graphic, inventory and
condition data. The extent of the work to date has taken the bridge management
initiative to the point of electronic access to the information and initial element and
structure level analyses.
The goal of this proposed work is to further the development of the structures'
database in dTIMS CT with an objective of expanding the amount of data stored,
enhancing the access to that data and the decision support system within CITIMS CT.
Figure 1 is a summary of the tasks related to training and the associated cost of each
task.
Price
i
`Other
Travel.'
. °-Totals
Bridge Toolbar Modifications
Modify Existing Bridge Toolbar to work in ArcView 10
$8,400.00
$8,400.00
Bride Analysis iterations and training
$13,440.00
$3.220.00
$16,660.00
De%elop additional and test existing Workflows
$6,720.00
$2 160.00
$8,880.00
Acquisition of ArcView 10 fortesting purposes
$2,000.00
$2,000.06
Total Proposed Cost
$35,940.00
Figure 1: Bridge Database Cost Proposal Summary
`bask Descriptions
The above tasks that will be conducted by Deighton are described below.
Modify Existing Bridge Toolbar to Work in ArcView 10
Deighton Associates has previously developed a toolbar that resides in ArcView to
provide access to bridge data and reports. A sample of this toolbar is shown below.
Structure Year Report
®- Prf'EROOKDR'P.4RKWDR—� 2004 WI F___
WtIdLIra Plans
Inpecrion History
Detailed Repoii
Wpeclion Rep,
This toolbar allows the user to select a Structure and an inspection year that will
specify the Summary, Detailed or Inspection Reports that will be returned to the user.
This toolbar currently works in ArcView 9.2. Recently the City of Ft Collins upgraded
their version of ArcView to version 10. The toolbar no longer works in this version.
Deighton proposes to ensure that the toolbar works in ArcView 10. It is envisioned
that no functional charges will be made to the toolbar but rather the code that is used
to access the data will be modified.
Bridge Analysis Iterations and Training
This task will further the bridge element and structure analyses that have been
performed under previous contracts. This task can involve loading additional
inspection data, loading additional structures, updating cost information, running
analyses and further testing and/or refinement of the roll up program and the analysis
parameters in dTIMS CT.
Training will be provided so that City staff can perform all necessary tasks from
loading of data to running element and structure analyses.
If time permits, a SQL Report could be developed in place of the MS Access report
that shows structure and element recommendations from dTIMS CT.
Develop Additional and Test Existing Workflows
dTIMS wf is a part of the cITIMS CT family of products that has been adopted by Fort
Collins. dTIMS wf gives users the ability to automate various repetitive tasks that are
required to maintain the Structures database. An example of this would be the
addition of structure inspection data to the database. This task will allow additional
workflows to be created and documented and then implemented within dTIMS wf.
Acquisition of ArcView 10 for Testing Purposes
This work item will allow Deighton to acquire a license of ArcView 10 for testing the
changes made to the toolbar. This license could be transferred to the City following
the completion of this work. This is dependent on the City's policy regarding software
licensing.
We look forward to your comments and.direction with respect to this proposal
Sincerely,
Gary Ruck, P. Eng.
Engineering Manager.