The URL can be used to link to this page

Home My WebLink AboutWORK ORDER - RFP - P614 PAVEMENT MANAGEMENT PROGRAM (4)11*14,14 191 WORK ORDER FORM PURSUV'UNTT0 AN AGREEMENT BETWEEN. TIJE CITY OF FORT COLLINS .and D6ghton Associates DATED: September 21,2010 Vv ov I ("I"'0 or IN ll it I v ('r, 100- 1 Cif."' ilrid'wc' Prim -'alll gi 2 i (Jin--R.- and direct costs): not to exceed $74,240.00 of thernanagernentof bridges widiin.ATIMS.CT. -!11c"„ ^d devolopiiients of the structures database in dTIMS CT with. an objective of ,,fduta,stored,,enhancing tht.accussiothat data and moving towards fi struct.I.Ir'-s axision support system within, dTIMS CT as per the Bridge Database -601 t1w tl�'rlkts IMd conditiorts ci.ntained i 1.Hieseri'- A�sc�mient'betwt;cra the 1.13 01evvni "onflict betwevlt or uoa% �4'thc Stta-vices AtIreoment, �n0 u ding' the muched forms) .wl i ";s ""iis shall 1 '2 ................ . P The attached fomis consisting; ofsix 0 pages are hereby accepted and incorporated hei-ein by this reference, and Notice to Proceed. is lice-eby,given. City-tT7@�Ft C-i)l By: 44,4111, 1 Dnte: Septenibei-21-2010 / D (clll,-D Deloghton Bridge Database 2010-030 v.2 Fort Collins, CO. Prepared by: Rob mane rob.piafie@deightori.com Friday, AugUst 20, 2010 i s .AaV i od yy if 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 clTIMS CT. To date we have worked with Fort Collins to import an initial set of structures information into clTIMS 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. The goal of this proposed work is to further the development of the structures' database in clTIMS CT with an objective of expanding the amount of data stored, enhancing the access to that data and moving towards configuring a structures decision support system within clTIMS CT. Figure 1 is a summary of the tasks related to training and the associated cost of each task. Purchase (1) cITIMSCTSQL Credit (1) dT1MS CT Desktop Project Initialization Modify dTIMS CT Database Assemble Existing pdfs into sing Update Bridge Data from Source Import Bridoe Data Develop New Toolbar Layout Modify Existing Bridge Toolbar Implement Bridge Reports Document and Implement Workflows Project Initialization $60,000.00 -$40,000.00 $ 8,400.00 $ 2,160.00 $6,720.00 for each Bridge By FTC By FTC e Toolbar Modifications $3,360.00 $8,400.00 $6,720.00 $10,080.00 Figure 1: Bridge Database Cost Proposal Summary Total Proposed Cost 1 $74,240.00 i The above tasks that will be conducted by Deighton are described below. dTIMS CT Upgrade to dTIMS CT SQL Fort Collins currently maintains two Desktop licenses of clTIMS CT. These licenses utilize a MS Jet database engine (MS Access database). This database has size and networking restrictions imposed on it by Microsoft. This proposal offers the upgrade of one (1).of the two licenses to clTIMS CT SQL. Moving to the SQL version of clTIMS CT will give Fort Collins the advantage of being able to manage the combined larger dataset of Pavements and Bridges, exploit the data sharing capabilities offered by an SQL database and take advantage of the latest Work Flow offering from Deighton Associates. Full credit for the existing clTIMS CT Desktop license is offered against the cost of the dTIMS CT SQL software license. Project Initialization This task will give Deighton staff an opportunity to meet with Fort Collins structures staff to discuss the changes to be made to the clTIMS CT database and review the modified and new data. Discussions regarding data that will be required, should Fort Collins decide to implement decision support for bridges in clTIMS CT, will also be discussed. Modify dTIMS CT Database To accommodate the new pdf format proposed and the multiple years of data that will be summarized, modification will need to be made to the dTIMS CT database structure. Deighton will make these modifications and ensure that the new data is available to clTIMS CT and the reporting toolbar. Import Bridge Data Once all the data is collected from all sources and the hardcopy documents are assembled into single pdf format then the bridge information will be loaded into clTIMS CT and the link to the external data file can be established. Develop New Toolbar Layout The existing toolbar that is available via the map based user interface is illustrated in the following image. 2u i 0,ig' iA�: i001 t ,-(.6Gy K { The tool bar allows the user to select a specific structure and access various reports and pdf's for that structure. Only the most recent pdf reports are available at this time through the toolbar. Or proposal is to modify the toolbar to appear as follows. ucture ® �f.1BR00KDR-PARKWDR. .Year Report. 2004 ?_ Structure Plans Inpection History Summary Report Detailed Report This toolbar will allow the user to select a Year that will specify the Summary, Detailed or Inspection Reports that will be returned to the user. The Report pulldown will also be modified to offer the user a section of "static reports" that are independent of the year selected. These reports will be comprised of a link to the plans to the structure and a summary of various inspection attributes from all the years available for the selected structure. The other offerings will be related to the selected year and will produce the reports that were available from the previous toolbar. Modify Existing Toolbar The existing toolbar will be modified in the direction proposed with accommodations made for any suggestions that Fort Collins wishes to make. Implement Bridge Reports The bridge reports that will be accessed by the bridge toolbar will be configured and implemented. Document and Implement Workflows dTIMS wf may be part of the cITIMS CT family of products that are adopted by Fort Collins. cITIMS wf gives users the ability to automate various repetitive tasks that may be required to maintain the Structures database. An example of this would be the addition or removal �e�o�n��oc�eoumba� u��o\evcos,�um�z'xvm��on�^�[aoa�auwoP9 Te|`�ns ��s'66ospax��OE)o»s��s of a structure from the database. This optional task will allow these workflows to be documented and implemented within dTKA5w[ VVelook forward toyour comments and direction with respect tothis proposal. Sincerely, Robert Piane, P. Eng.