HomeMy WebLinkAbout5.D.2. Consultant Extension Agreement for 2009 GIS/CMMS Work Plan
s. O.:L ·
CITY OF SHAKOPEE
Memorandum
TO: Mayor & City Council en ~I \:rf;~T
Mark McNeill, City Administrator UM~~~~'c :g~ f
, ~1I"
FROM: Bruce Loney, Public Works Director
SUBJECT: Authorize Consultant Extension Agreement for
2009 GIS/CMMS Work Plan
DATE: February 17,2009
INTRODUCTION:
This agenda item is for the City Council to consider authorizing a consultant extension
agreement for 2009 Geographic Information System (GIS) and Computerized
Maintenance Management Services (CMMS) to support the Public Works GIS/CMMS.
BACKGROUND:
Included with this memo is a 2009 GIS/CMMS work plan proposal from WSB &
Associates, Inc. needed to support continued development of the GIS/CMMS. The level
of support is decreasing as the system is developed and being maintained by our GIS
Specialist.
The work pIan consists of GIS/CMMS coordination with our GIS Specialist and testing
and development of Cartegraph Version 8 and on-going support for utilities, park and
street modules. Also, two projects have been identified for 2009 being SIGNview
Development and implement Outfall Inspection Reporting System. The cost of the 2009
work pIan is as follows:
Item Cost
GIS/CMMS Coordination $10,160.00
SIGNview Development $ 1,344.00
Implement Outfall Inspection Report System $ 3.424.00
Total $14,928.00
Funding for this consultant work was included in the 2009 Budget and as follows:
Fundine: Source Amount
Engineering $ 1,000.00
Street $ 2,500.00
Park $ 2,500.00
Sanitary $ 6,000.00
Storm $ 6.000.00
Total $18,000.00
Sufficient funds exist in the budget to meet this 2009 GIS/CMMS work plan by the
consultant.
ALTERNATIVES:
1. Authorize the appropriate City officials to execute the consultant extension
agreement from WSB & Associates, Inc. for GIS/CMMS in 2009.
2. Do not authorize the appropriate City officials to execute the consultant extension
agreement from WSB & Associates, Inc. for GIS/CMMS in 2009.
3. Table for additional information.
RECOMMENDATION:
Staff would recommend Alternative No. 1 in order to authorize consultant GIS/CMMS
for 2009.
ACTION REOUESTED:
1. Authorize the appropriate City officials to execute the consultant extension
agreement from WSB & Associates, Inc. for 2009 GIS/CMMS in an amount not
to exceed $14,928.00. ~~.
Public Works . rector
BUpmp
ENGR/2009-PROJECTS/2009-COUNCILIGlS-CMMS
.
.\ ~
WSB
'&AS'socii1tcil. file: Infrastructure _ Engineering _ Planning _ Construction 701 Xenia Avenue South
Suite 300
Minneapolis, MN 55416
Tel: 763 541.4800
Fax: 763541.1700
February 5, 2009
Mr. Jeff Weyandt, PE
Assistant City Engineer
City of Shakopee
129 Holmes Street South
Shakopee,~ 55379-1328
Re: 2009 GIS/CMMS Work Plan
City of Shakopee, MN
Dear Mr. Weyandt:
I am pleased to submit this work plan on behalf of WSB & Associates, Inc. to support and continue
the development of the Geographic Information System (GIS) and Computerized Maintenance
Management System (CMMS) for the City of Shakopee. Having completed the .initial
implementation of the City's GIS/CMMS, we now need to continue to refine an~ develop the
individual modules and components of the CMMS.
GIS/CMMS Coordination
The continued operation of the GIS and the CMMS will be supported as needed during this phase
of the project The overall goal will be for the City's GIS Specialist to handle the bulk of this
task with high level support from WSB staff as necessary. It is estimated that 50% ofthe support
hours required in 2008 will be needed in 2009. It is recommended this be roughly allocated in
four- hour blocks every other week. Major activities covered under this task: include testing and
migration ofthe database to Cartegraph 8, testing and deploying the mobile framework if
required, programming support, and the ongoing support of the utility, park, and street modules.
Cost: $10,160
SIGNview Development
With the configuration and collection of the majority of the sign information complete, it is time
to shift the focus to the utilization and maintenance of this data. This will require implementing a
mobile SIGNview PDA, training staff to analyze SIGNview data, and integrating the remaining
GPS based sign data.
Cost: $1,344
Implement Outfall Insoection Reoortin!! Svstem
U sing the information being collected based on the GPS data collection forms, a system will be
developed to generate an outfall inspection report for inclusion in the City's MS4 report. This
includes modifying the collection forms as requested by staff, modifying the Carte graph data
model to better suit the City's needs, integrating the GPS data into GIS andiCartegraph, and
developing the inspection reports. This task will be jointly completed with jthe City's GIS
Specialist. I
I Cost: $3,424
ACEC 2008 Firm of the Year
F.\ WPWIMGIS<kJdShak\2009\LTR PROP1 weyandt.fJ20509.<kJc
,
, Mr. Jeff Weyandt, PE
February 5, 2009
Page 2
Cost Summary
It is proposed that this project be completed on a cost not to exceed basis, with total cost not
exceeding $14,928. If you are in agreement with the terms as outlined above, please sign where
indicated on this page and return one copy to our office.
Thank you for this opportunity to continue to develop the GIS/CMMS for the City of Shakopee. I
am confident that the level of service on this project will meet or exceed your expectations. If you
should have any questions regarding this proposal, please contact me at 763-287-7194.
Sincerely,
WSB & Associates, Inc.
]1~
IS Project Manager
Attachments
ACCEPTED BY:
City of Shakopee
By:
Title:
Date:
F.1 WPWIMGl&dod8hakl2009ILTR PROP-j weyandt.(J20509.doc
I
,
, Attachment 1
2009 Budget
I~~.~...~.~;..~I.~!gMM.~...gQQI~!.n.~~.!Qn......... ............. ... ........ .............~Q... .....;... ..~.9. ........ ..l,$~,949.
I~!.~...~.!l.:...~rQgr~I!I.I!I.i.':'g...~l::IPPQr.t:....... ...... ............................. ........ ......... .... ..1 ........?O ...........L... . 7.9.J$J,fi?9.
I~!~~;.~I~~yi~~!?!y!l!?pr.!l.~~t,.. . . .;......1..4..... .....;..........99...........J. ....11.,.~.44...... ...
I~!.~.~~:Ql::I!f~I!!I)~p~~~iQn8~PQr.t:.ing.~)l~~~m ; 23 ; 96 ; $2 208
""" ""',,,.,.~,,,'~,,. ..,..............;.. .....,..,..................... ............,............. ............,..........................,.......,..,.................
Task 3b: Outfall Inspection Reporting S stem 16 76 $1,216
Total 163 $14,928