Water Distribution GIS System Update
DU~%duE
~<Ik-~
MEMORANDUM
January 28, 2005
TO:
FROM:
The Honorable Mayor and City Council Members
Michael C. Van Milligen, City Manager
SUBJECT: Water Distribution Geographical Information System (GIS) Update
Contract Award
A Request for Proposals was issued by the Water Department for services to assist in
converting previous and current data that remain in various paper copy formats into the
Geographical Information System.
Water Department Manager Bob Green is recommending that Missman Stanley and
Associates be selected to perform this service at a cost of $34,900.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
(l1~( ~,/J;L
Michael C. Van Milligen
MCVM/jh
Attachment
cc: Barry Lindahl, Corporation Counsel
Cindy Steinhauser, Assistant City Manager
Bob Green, Water Department Manager
\
.~
CITY OF DUBUQUE, IOWA
MEMORANDUM
January 26, 2005
FROM:
Michael C. Van Milligen, City Manager
Bob Green, Water Department Manager 8.
TO:
SUBJECT: Water Distribution Geographical Information System (GIS) Update
Contract Award
INTRODUCTION
The purpose of this memorandum is to request your authorization through the signing
of the attached contract to hire Missman Stanley and Associates of Rock Island, IL to
perform the work of updating the G.I.S. maps in the City's Water Distribution Division in
the amount not to exceed total of $34,900.
DISCUSSION
The City of Dubuque has been actively using a Geographical Information System
(G.I.S.) since 1996. During the past four years the City's Water Distribution Division
has worked to create various water utility layers. Conversion for the most part of this
operation was outsourced.
The City Water Distribution Division is in need of assistance in converting previous and
current data that remain in various paper copy formats into the Geographical
Information System (G.I.S.).
The funds to support this task was budgeted and approved through our FY05 C.I.P.
budget proceeding with City Council.
In support of this project staff and Information Services Manager Chris Kohlman
reviewed and have created a scope of services focusing on the department's needs.
This R.F.P. of services was created and distributed to six vendors. Those vendors are
).
as follows with their fees to complete this project.
. Missman Stanley & Associates
1011 2ih Avenue
P.O. Box 6040
Rock Island, IL 61204-6040
Total cost not to exceed $34,900
. Patrick Engineering
613 Williamson Street, Suite 201
Madison, WI 53703
Estimated Total $40,545
. MSA Professional Services
1605 Associates Drive, Suite 102
Dubuque, IA 52002
Total cost not to exceed $57,800
. Wind Lake Solutions
831 N. Grand Avenue, Suite 200
Waukesha, WI 53186
Total estimated cost $100,187
. ASI Wisconsin
741 North Grand Avenue
Waukesha, WI 53816
Total estimated cost $104,664
. Cartegraph
3600 Digital Drive
Dubuque, IA 52003
No Response
RECOMMENDATION
In review of the proposals provided for this project of their variables, altematives and
fees, it is staff's recommendation to award this project to the lowest bidder, Missman
Stanley & Associates of Rock Island, Illinois. This vendor currently is contracted by the
City of Dubuque Planning Department to provide quarterly G.I.S. zoning data updates.
In reviewing Missman Stanley credentials, staff depth and past experience indicates to
us that they are very capable of being able to complete our requested project. We have
been in contact with staff in the planning department and their response is that the
quality, attitude and response time from Missman Stanley & Associates have been
excellent.
Funds to support the project are currently budgeted in the amount of $70,000 and the
proposed fee to perform these services is $34,900.
The contract has been reviewed and approved by Corporation Counsel Barry Lindahl
and the insurance forms attached have been reviewed and approved by Finance
Director Ken TeKippe.
. j
Therefore, with the above process being completed, I am requesting your authorization
through the signing of the attached contract to proceed with this project.
Staff and I are available at your convenience to discuss this project with you, should
you have any questions.
vie
Attachments
cc: Dawn Lang, Budget Director
Barry Lindahl, Corporation Counsel
Ken TeKippe, Finance Director
Chris Kohlmann, Information Services Manager
Michael Brekke, Water Distribution Supervisor
File
4("" !!1!Ev" A8S!!,!~Q ~
January 13, 2005
Mr. Michael Brekke
Water Distribution Supervisor
City of Dubuque
505 Adams Street
Dubuque, IA 52001
Missman, Stanley & Associates (Missman) is pleased to provide the following Contract
regarding the "Water Distribution GIS Update".
Water Distribution GIS Update
Stated below is the project scope and approach. The approach is fashioned to what information is currently
available. After the project is initialized, the order of data update may need revised or, a combination of data may
need entered before another set of data can be entered. For this proposal the approach shows I set of items at a time.
Project Scope
Part 1: Update of Tap Slip Data:
All Tap Slips (1585) will undergo the same process. The first step is scanning. The slips will be scanned on a sheet-
fed scanner. They will be reviewed and a detennination made as to scanning the second side of the slip. Ifboth
sides are scanned, two files will be created; they will not be combined in one TIF. All scans will be 220 DPI and
saved as TIF files. The naming convention will follow the existing naming for the Tap Slips. After scanning, the
data from the front of the Tap Slip will be entered into the database. Missman will try to use the same entry form as
used by the Water Distribution Division. Ifthe existing form will not work, Missman will design a custom form for
the entering of the Tap Slip data. The data will be entered into a database with the same data structrue as the existing
Tap Slip database. Vector updates will be completed as the final process of Tap Slip updates. The vector updates
includes points and lines which need updated. The vector updates will be based on the dimensions and sketches as
described on the Tap Slips. The vector process will also verify the ability to access the scans and data from the
vector datasets. Quality assurance and quality control will be addressed during this process.
The software used for the Tap Slip updates includes HP scanning software, Microsoft Access and ESRI ArcGIS 9.
Additional software may be utilized; but not expected.
1011 27" Avenue, P.O. Box 6040 . Rock Island, Illinois 61204-6040
Phone: 309.788.7644. Fax: 309.788.7691 . www.msa-pc.com
C !T!!~~~!!!~':l ~
1/13/05
Page 2 of?
Part 2: Update of Development Review Plans:
Development Review Plans (162) will start with a visual review. This review will determine which sheets need to be
scanned. Missman anticipates 8 hours of city staff time for this review. The second step is scanning. The Review
Plans will be scanned on a bed scanner by a sub-contractor of Missman. All scans will be 220 DPI and saved as TIF
files. The naming convention will follow the existing naming for Review Plans. The scans will be georeferenced to
the base map where possible/practical. The vector information will be updated in a "heads-up" digitization process
from the georeferenced plans. Vector data, where applicable, will be entered by Review Plan measurements. The
associated attribute data will be entered from the Review Plans through a custom form into a database with the same
data structrue as the existing Review Plan database. Quality assurance and quality control will be addressed during
this process.
The software used for the Review Plans updates includes HP scanning software, Microsoft Access and ESRI ArcGIS
9. Additional software may be utilized by the sub-contractor.
Part 3: Update of Engineering and Project As-Builts:
Engineering As-Builts (104) will start with a visual review. The review will determine which sheets will need
scanned, either as 24x36 documents or other various sizes. Missman anticipates 8 hours of city staff time for this
review. The second step is scanning. The 24 x36 Engineering As-Builts will be scanned on a bed scanner by a sub-
contractor of Missman. The other sheets will be scanned on a sheet-fed scanner. All scans will be 220 DPI and
saved as TIF files. The naming convention will follow the existing naming for Engineering As-Builts. The scans
will be georeferenced to the base map where possible/practical. The vector information will be updated in a "heads-
up" digitization process from the georeferenced plans. Vector data, where applicable, will be entered by
Engineering As-Built measurements. The associated attribute data will be entered from the Engineering As-Builts
through a custom form into a database with the same data structure as the existing Engineering As-Builts database.
Review time from city staff on this process is anticipated to be approximately 30 to 40 hours (not continuous). Many
of these As-Builts are in the "Orange Book" and may need to be reviewed before the data is ready for input. Quality
assurance and quality control will be addressed during this process.
Project As-Builts; Street, Subdivision, Water Main will follow the same process as the Engineering As-Builts. The
difference is the number of projects. With (54) the initial visual review time will be about 4 hours and the review
time for the "Orange Book" is anticipated to be 15 to 20 hours (not continuous). Missman will try to keep the city
stafftime during this phase as minimal as possible.
The software used for the Engineering and Project As-Builts updates includes HP scanning software, Microsoft
Access and ESRI ArcGIS 9.
Rock Island, IL . Rockford, IL . Bettendorf, IA . Des Moines, 'A
C /J1~~~!!!~Q ~
1/13/05
Page 3 of?
Part 4: Update of Water Distribution Sketches:
Water Distribution Sketches (295) will start with a visual review. The review will determine which sheets will need
scanned, Missman anticipates 2 hours of city staff time for this review. The second step is scanning. The sheets will
be scanned on a sheet-fed scanner. All scans will be 220 DPI and saved as TIF files. The naming convention will
follow the existing naming for Water Distribution Sketches. Vector data, where applicable, will be entered by Water
Distribution Sketches measurements. The associated attribute data will be entered from the Water Distribution
Sketches through a custom form into a database with the same data structure as the existing database. Quality
assurance and quality control will be addressed during this process. The scanning of Water Distribution Sketches
may not always produce a scan with "desirable" data. If this is the case a determination will need to be made as to
the validity of maintaining the sketch scans. This does not impact the project other than less storage space for the
scans will be required. The software used for the Engineering and Project As-Builts updates includes HP scanning
software, Microsoft Access and ESRI ArcGIS 9.
SCHEDULE
Missman anticipates the following schedule; however changes in the project start date may impact the completion
date. The schedule may also be adjusted to meet changes in project scope.
Task
Start Pro' ect
Dates & Duration
Februa 1, 2005
Ta
Ta
Ta
Februa
Februa
Februa
Develo ment Review Plans
Februa 28 - A ril15
March 21 - A ril 29
Water Distribution Sketches
A ri118- Ma 20
Mid- oint Data Review b Ci
A ri14-7
ue
Februa 24
March 16
A ril7
Ma 2
Ma 19
June 2
June 16, 2005
Rock Island, IL . Rockford, IL . Bettendorf, IA . Des Moines, fA
~ !!1~~~m~Q ~
1/13/05
Page 4 of7
COST BREAKDOWN
Missman anticipates the following cost breakdown for each task. The breakdown may vary to meet changes in
project scope. The costs are listed as not to exceed amonnts.
Tap Slips Number Hours Position Title Hourly Rate Total Cost
Scanning 1585 63 GIS Specialist I $35 - $50 $2,268.00
Data Entry 1585 122 GIS Specialist I $35 - $50 $4,392.00
Vector File Creation 1585 144 GIS Specialist II $45 - $65 $8,640.00
Subtotal $15,300.00
Development Review Plans 162 81 GIS Specialist II $45 - $65 $4,860.00
As-Builts
Engineering 104 52 GIS Specialist II $45 - $65 $3,120.00
Street Projects 13 7 GIS Specialist II $45 - $65 $390.00
Subdivision 20 10 GIS Specialist II $45 - $65 $600.00
Water Main 21 11 GIS Specialist II $45 - $65 $630.00
Subtotal $4,740.00
Water Distribution Sketches 295 98 GIS Specialist II $45 - $65 $5,900.00
Total 587 Subtotal $30,800.00
Outside Scanning Services
Quad City Reprographics $1,800.00
Project Management $30 - $85 $1,500.00
Training GIS Specialist II $45 - $65 $800.00
Total Cost
Not to Exceed: $34,900.00
Rock Island, IL . Rockford, IL . Bettendorf, IA . Des Moines, IA
~ !T!!~~~!!!~':l ~
1/13/05
Page 5 of7
Part 7: City Time Requirements:
Missman anticipates that hours will be required from City staff for this project. The following table shows the
approximate breakdown of city staffing hours in addition to those outlined in the Project proposal.
Department Task Estimated Hours
Information Services Initial data downloads 16-20
Department
Water Distribution Division Initial data downloads 5-7
Information Services Project Meetings 3-5
Department
Water Distribution Division Project Meetings 3-5
Information Services Data Review 8-10
Department Sessions
Water Distribution Division Data Review 8-10
Sessions
Water Distribution Division Weekly 1-3
Requirements
Estimated total hours for the Information Services Department:
Estimated total hours for the Water Distribution Division:
31 Hours
50 Hours
Part 8: Additional updates and follow-up:
Missman anticipates that when the project is completed some streamlining of the Water Distribution GIS processes
may be desired. At that time Missman would make recommendations based on staff input and our own analysis of
the system.
Part 9: Immediate Response Time:
Missman GIS staff will respond to City emergencies and questions within 1 business day during the project. This
includes the need for onsite emergency visits. (Exceptions to the 1 business day may exist but are not anticipated)
Scheduling
The project schedule is contingent upon proper review and acceptance of the planned deliverab1es. Any changes in
the delivery schedule, due to changes made by either party, will be documented. A written explanation as to the
reason for the change, cost adjustment and a revised time schedute will be provided to the client. An example of the
Change Request Document is provided as Attachment 01.
Rock Island, IL . Rockford, IL . Bettendorf, IA . Des Moines, IA
< !T!!!.~~m:!!'Q ~
1/13/05
Page 6 of?
Data Security
The data transferred with this project is the sole property of The City of Dubuque and shall not be sold or given to
other entities without expressed written consent of The City of Dubuque. Missman will maintain a copy of the data
for record purposes.
Project Start Date
Missman can begin work on this project as soon as received. Start and completion dates will be assigned after we
have received a signed agreement from the client. The start date and stated completion dates are contingent upon the
following:
. Missman will receive a signed contract and notice to proceed by February 15, 2005.
. If Missman receives a signed agreement prior to this we will be able to begin work on this project at
an earlier date, thus ensuring an earlier completion date.
. Data from the City is available and delivered in a timely manner.
Acceptance
Acceptance is an important part of the delivery process. Acceptance is contingent upon proper review and
acceptance of the planned tasks. The client is expected to thoroughly review our work within 10 working days, or
other mutually agreed upon period of time, of receipt of a deliverable. Missman will divide items delivered into
separate tasks and deliver them as they are completed. The client will need to review each deliverable as it is
received and inform Missman in writing of any necessary changes. An acceptance document will be provided for
your signature affirming that the work was performed satisfactorily, following examination of the product by the
client. An example of the Acceptance Document is provided as Attaclunent 02. Failure by the client to accept a
deliverable may cause a delay in the delivery of further documents.
Client Communications
Missman will use a variety of methods to communicate with the City. Conference calling, direct calls and fax
transmittals and e-mail will provide instantaneous feedback in a verbal or hard copy format. Problem resolution and
critical response issues can be handled by this method. Communication is an important part of this agreement. Mr.
Joseph Miller will act as your primary point of contact throughout this project.
Rock Island, II. . Rocktord, II. . Bettendorf, IA . Des Moines, IA
~ !'1~~~!!!.!!!!1 ~
1/13/05
Page 7 of?
Additional Services
Any additional customization or other means of support outside the scope of the agreement will be billed at the
current hourly rate. The customer will be notified if any work will be billable above and beyond the scope of the
project and what the estimated cost ofthis work would be. The City will be given an opportunity to approve in
writing of any additional work before it is done. Hourly rates for this project through the end of June 2005 are listed
below.
GIS Specialist I 55.00
GIS Specialist II 70.00
GIS Specialist III 90.00
If you have any technical questions regarding this Agreement, please contact Mr. Joseph Miller in our Rock
Island office at (309) 283-1590. Contractual questions may be addressed to me at (309) 283-1584. This proposal is
open for acceptance until February 15, 2005. Thank you for your time and consideration.
Sincerely,
MISSMAN, STANLEY & ASSOCIATES, PROF. CORP.
(/ ~,,-.
Ke~ . Koski, President
By
Accepted this
day of
,2005
CITY OF DUBUQUE
/)li.) (", J/(.,.
CITY MANAGER MICHAEL C. VAN MILLIGEN
By
Rock Island, IL . Rockford, IL . Bettendorf, IA . Des Moines, IA
\\SrvOlrr6a-ri\MissmanGIS\CompProposal\Dubuque-Water GIS_doc
~ !!.!~~!J!!!!!~Q ~,,---
Water Distribution GIS Update Project
CHANGE REQUEST DOCUMENT
Customer: Dubuque, IA Pal!:e 1 of 1
Pro,iect: GIS Project Manaller: Miller
Pro.iect Code: A-05-COlO Date: May 24, 2005
Change Requested:
Additional Cost: Plus Minus Schedule Chanlle: I Yes No
Amount: $ If yes, see attached modified schedule.
Approved By:
Title:
Date Approved:
Sillnature:
Comments:
Proiect Manal!:er: Mr. Joseph Miller
Proiect: GIS
Date Received:
Sillnature:
Comments:
Rock Island, IL . Rockford, IL . Bettendorf, IA . Des Moines, IA ATTACHMENT 01
c !T!!L~~!f:!!!!~a ~
Water Distribution GIS Update Project
DELIVERABLE ACCEPTANCE DOCUMENT
Customer: Dubuque, IA Pal!:e 1 ofl
Proiect: GIS Proiect Manal!er: Miller
Proiect Code: A-05-COIO Date: May 24, 2005
Acknowledge:
Acceptor:
Title:
Date Accepted:
Sil!uature:
Comments:
ProJect Manal!:er: Mr. Joseph Miller
Proiect: GIS
Date Received:
Sil!nature:
Comments:
Rock Island, IL . Rockford, IL . Bettendorf, IA . Des Moines, IA ATTACHMENT 02
~ m,ssman >______
.TANLEY .. "'..DCIATE8, ...C.
CERTIFICA TES OF INSURANCE
- ----_._.__._-----~--~~_._~---_._- ...---. -- ----------.--- --.-.. -- i ------
ACQRP. CERTIFICATE OF LIABILITY INSURANCE DATEtIftllOOlYVYY)
11/2.4104
PIlOOUCIEI'I THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION
Ruhl & Ruhl, IRe ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE
700 Putnam Building HOLDER. THIS CER11F1CATE DOES NOT AMEND, EXTEND OR
i 215 N. Main street Ai. TER THE COVERAGE AFFORDED BY THE POl.ICIES BELOW.
~.nport, IA 528.' INSURERS AFFORDlNG COVERAGE HAle.
IMSUllfD INSURER A Allied Pro,.,rtv & Casualtv 42579
I Missm.n, Stanley, & Anoclat... P.C. INSUR~RIl
1011 27th Avenue -
INSU/.lERC
! Rock Island, It 61201..0040 ~~p--~-- -- -- ----------.---
, "'------~ ""SURER, ----
en.ntt'. 6652
MISSMSTA
COVERAGES
THIC POLICIES OF INSURANCE L1STEO BELOW HAVE BEEN ISSueD TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED_ NOTWITHSTANDING
ANY REQUIREMENT, TERM OR CONOITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSl,IEO OR
MAY PERTAIN. THE INSURANCE AFFORDEO BY THE POLICIES DESCRIBEO HEREIN IS SUBJECT TO ALL THE TERMS, EXCLUSIONS AND CONDITIONS OF SUCH
POLICIES AGGREGATE LIMITS SHOWN MAY HAVE SEEN REDUCED BY PAID CLAIMS
I~---~ -~;~OI'}ItSUR"'~E POUC...ItL*8E~ - POLICYE "feTlVE POI.ICYEXf'lAATlON
~.
A I OENE1W.LWULITY ACP710169581B
:g~O~HC~L<'E~l~ L~~lry
I ~i ~~~~~A~::~~,~!~ _~:~:
ptl i-=o.-,,-;..I '~-A~-~~~T-E-l~~~~~~~E~-~~
~,~D j~g _[.lu~
A ~~TOM06ll.fll...aUTY ACP7101695018
, .n;M'YA,rrO
I. . i ~lLO'II'NU!Al;l(,:>
, '--1
, t -. -.1. ~'-'''~l!tJlfDAUI{l'-'
X.oI'R[DA,]I(l<;
i 1t1>lON-OWNEOMJTOS
l-j
l':~:=~~ ---- - ____n~__~_
l _ _
EJ(CESSlUM8REl.LAUABlLIT'I ACP7101695018
-]""LlR OiIA',",SMAOF
, ,
I I I OEOU'~TllllE
: 1 R~Tt"rWJN \
A 1 ~E;SC~PE~...n~~~~-- n ACP7101695818
IEIIPl.OYEllrUAa1UTY
ANYPROPRIETORlP^RT~RifXECUTlVE
I "H'CER,"'E...OEREXCLUOED">
, I' t~., d~""noo uooar
A F::.::~:::"-- -. ACP71016:50i.- ~- ffi261"---1iI2.iO'-~-~f~~::"u."
DESl;RIPTlOM Of OPfAATIOf4S II..OC...TlOIIIS 1Vl:lllCLE81 EJ(ClUSlOMS AOOEIlIIY E~88ft"'T I SPECIAL PltOVlSlOfo!S
CerUficate holder Is an additional insured as respects their Interest In
the above captioned general liability polley. Govemmentallmmunltles
endorsement on General Uablllty and Waiver of Subrogat60n on Worker'.
Compensation to apply.
.!'I'_"!:SOI>W ~A~\lI!'lJUR(
(;EHEil!,~_A(;i;~!:('''''fI
~~~~~~i~~---- !j-L~~____
..rJll:.MCi~rnmlll _ 9.99.QQ9_
MEO FXP I"'"y'-"'" 1><1"""'1 s~D9:9__.~.__ ____
$1 000 000
~~.LQ9.Q..91J~~_ ___
PRODucr';-CO"PiOf>AGG ~LOOO
11126J0.4
11126105
11126/04
11126/05
(:OMIIINEOS,NGlElIMIT
,E..co_,ll
S1,ooo,ooO
IJOI!It:"fi,jI!['Y
,p"'p-,,,'
BOOllYINJlJlh
;I'~,,,"c.,j,,,,q
nj
I
A j
i
I
-.+------- -~_._-- -~--~._-_.__._-_.
!
,
!
111126104
!
~~'~~c~,\lAI.w;! S
-~-~--- ~.------~--
AurOONlY-E^ACCIOCI'!-T...... !........._
OlliERTIiAN E"'M:C S
I\UTOONLY
..~(K.
L_,._,.
$5000000
s5000 000
11/26105
~~CURREJiCE
"'G(;REG"'T~
______~~___~ L~_
.
11/26104
11126/05
WeSTAll1--
--
Et FAO-1A(;CIOnlT
El.OISEI\SE.EAEMPUJYEE ,500000
QTli-
.... ...
.... ...
CERTIFICATE HOLDER
CANCELLAnoN
City of Dubuque
cIa City Clertl;s Office
1st Floor City Hall
50 West 13th Street
Dubuque, IA 52001
lIHOUUIAIITOFTlIEolaovEDESCllIfIEDPOUClli'SaEC"NCElUOIlEFOIIETHEUPlIIAl'lON
D"TI'. TlII!,""Of', TME ISI!IUlI<il'lIM_l!lI: WIl-L IU.DE..VOIl to......L .,,jUL. DIOY'lI WRfTTf:"
NOTICE TOTHI! CERTIFICATE HOLDER NAilED TO THE UFT, IIUT ......lHIE TO 00 ISO ISHAU.
~E NO 08U0ATlDM 0fI L....BLIT'I Of' .....y KIND UPo'" THE INSURER. rrll AGEIfTIIOIt
REPREM:NTJ'TlYal ~~
AUTltORIZI!DlI:ItPAltlliElfT..nve
"
JAP
o ACORD CORPORATION 1918
ACORD 25 (2001/00) 1 of 2
ts392351M39077
Rock Island, IL . Rockford, IL . Bettendorf, IA . Des Moines, IA
~ !T!!!~~mf!!.a ~
CERTIFICA TES OF INSURANCE
ACORO.
CERTIFICATE OF LIABILITY INSURANCE
OP 10 D DATE [MMIDDIVY'tY}
MISSM-l 12 07 04
THIS CERTIFICATE IS ISSUED AS A MAneR OF INFORMATION
ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE
HOLDER. THIS CERTIFICATE DOES NOT AMEND, EXTEND OR
AL fER THE COVERAGE AFFORDED BY THE POLICIES BELOW.
PRODUCER
M.G. WeIbel & Associates, Inc.
Michael WeIbel
633 Skokis Blvd., Suite 470
Northbrook IL 60062
Phone: 847-412-1414 Fax:847-412-1013
iI<iS.UR-e-o--
~r~~?thSl~~ley & Associates
Rock Island IL 61204-6040
i INSURERS AFFORDING COVERAGE
>---. -.-.
iY'!.S_U!l~!'~_ __ __St. _ _ ~~u~_ ~_i_;:~__~ _ ~'=-~!1e
~ l.!t_~~~~~~
ilNSURERC
'INSURERD
r-----
INSURERI,'
HAle"
COVERAGES
fHE POUCIES OF INSUI~Ct' Llsrw llELOW HAVE BEEN ISSUEO TO THE ltiSUREO NAMEOAtlOVe FOR THE POliCY PERIOD INDICATED NOTWInlSTANDING
NOY REOUIRfMENT fUll" OR CON DillON OF ANY CONTRACT OR OTIiER DOCUMENT WlIH "'EsnCT TO 'MilCH THIS CERTIFICATE MAY ElE ISSUED OR
MAY PERTAIN IHllNSURANCl AFfOROl"D BY THE POLICIES OESCRIBEO HEREIN IS SUMCIIO ALL ffie TERMS, EXCLUSIONS AND CONDITIONS OF SUCIi
POLII.:I($ A(',GREGAl E LIMITS SIiO'Ml MAY HAVE BEEN REOUCW BY PAID CLAIMS
IRSR ------
L TR NSRO TYPE OF INSURANCE
GENERAlLIABIUTY
POUCY NUMBER
il'OUCY U~~IIY1O !P01JCVU'lltl'flONT"-
, DATI! M ; DATI! MMIDDI'fY
LIMITS
r;()MMFRC~lGFNERA\ llAElllITY
EACH OCCURRENCE
~'---
!'.~E_~~~ (!'~_~~L
_-L~
'MEDEXP(A:1y"',~P"'SOO) $
! PFRSONAL&ADV-;-~~R;- 1 $
GENEIlAlAGGRf.GATE
PRODUCTS COMP/OPAG?_! $
CI,AIMSMADc
OCCUR
GE'n AGGREGATE LIMIT APPLIES PER
ceo
POLICY J[Cl lOC
AUTOl,lOBllElIABllITY
MNAUTO
AlIO\l\'NEDAUt0S
SCHFOULEDAUT0S
HtREDA\JTOS
NONOVIINfOAlJTOS
COMlItNf.DSINGLlUMtT
\E~acc,d&mi
BOQILYINJIJRY
{Pe'p"'''''''i
BODILY INJURY
IPe,acctdenl)
PROPERTY DAMAGE
IP9,acctdenll
GARIlGEL1AB1LITY
ANY AUTO
; AUTOONLY.EAACCIDENT S
,------,-,- ---tw
EAACcis
OTtlERHIAN
A.lJTOONlY
AOO
EXCESSlUI,IBRElLALIABILlT'I'
OCCUR
nNMSMAlll'
EACIiOCCURRENCE
AGGREGATE
OlOUCI19l[
REffoNrlON
WDRI\ERS(;0~PENSA110NANO
EMPLOYERS-LIABILITY
ANY PR()PRIE Hl/l.'PAfI fNER'[."(~,CU LII[
OFFOCER/Ml:M6U,I:XCLUllEO?
Irye., ~e.c.t;bo1""j..,
SPECIALPROVISIONSt-eIC""
OTHER
-'
".,!:Q!!,!~_r_s
EI.FACl'A(:CIOFNT
I ElL
El DISEASE EAEMPlO'r'EEj $
EIDISEASE.f'OlICYIIMIl S
A Professional Liab
i QP03802110
10/04/04
10/04/05
Per Claim
re ate
1,000,000
1 000 000
DESCRIP110f< OF OPERAnoNS IlOCATIONSIVEtiICLES I exCLUSIONS ADDEO 8'1' ENOOftSEMENT J SPECIAL PROVISIONS
Re: Water Distribution GIS Update
CERTIFICATE HOLDER
Ci ty of Dubuque
1st Floor, City Hall
50 w. 13th St.
Dubuque IA 52001
CANCELLATION
CITYDUB SHOUlD AHY OF THE ABOVE DESCRlBEO POUCIES BE CANCEllED BEFORE THE EXPIRATION
DATE THEREOF. THEISSUIHGINSURERW\ll..ENOEAVORTOMAll ~_ OAYSWRlfTEN
NOTlCI! TO THIl CERTIFICATE HOlDeR HAMED TO THE lEFT. BUT f....LURE TO DO SO SHALL
IMPOSE NO OBLIGATION OR L1A8ILlT'l' OF AfN IUNO UPON TtlE INSURER, ITSAGENT'S OR
RIPMSENTATlVES.
A :;kPR!
@ACORDCORPORATION 1988
ACORD 25 (2001/08)
Rock Island, IL . Rockford, IL . Bettendorf, IA . Des Moines, IA
ACORD,. CERTIFICATE OF LIABILITY INSURANCE I DAlE ,.M/lJDm'YT)
1112A104
PRIODUCE.R THIS CERTFICATE IS ISSUED AS A MATTER OF "FORMATION
Ruhl & Ruhl,lnc ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE
700 Putnam Building IIDUlER. THIS CERTIFICATE DOES NOT AMEND, EXTEND OR
ALTER THE COIIERAGE AFFORDED IIY THE POUCIES IIELOW.
215 N. Main StnuJt
DllVonpart, IA 52801 INSURERS AFFORDING COVERAGE NAIC .
INOllRED 1.'lJI''''''' Alli.d Pro..."" I, C...ualtv 42!57l1
Miuman, Stanley, i Aaaociatee, P.c. INSJREftB;
lOll 27th Avenue INSURERt:;
Rook Island,lL 61201-6040 l/"laJREFt. c:
INSURER E~
Clionlll' 6652
MlSSIIIST A.
COVERAGES
TtE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN IssueD TO THE INSURED NAMED ABOVE FOR THE POLlCYPERIOO INDICATED. NOlWITHST~DING
ANY REQUIREMENT. TERM OR CONorrlON OF AMY CONTRACT OR Oll-tER DOCUMENT WITll RESPECT TOWHICH ll-l1S CERTIFICATE MAY BE ISSUEDCR
MAY PERTAIN, THE INSURANCE AFFORDED BY THE POUCIES CESCRlBED HEREIN IS SUBJECT TO All THE TERMS, EXCLUSIONS AND CONJITIQNS CF SUCH
POliCIES. AOQRE,eATE LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID ClAIMS. .~
~ TYPE O'F 'NauR...MCE rtlI..1CYNLlMBER B FF uom.
A ~aw. U..,UTT ACP7101695018 1112&104 11/261ll5 EACH OCCURRENCE '1 000 DOO
0AtJ.AG'E TO RENTED
.l!.. pERaAL GENEIW. LIMILrtY PRE"" ~ '3DO DOD
- CLANI MH)E [i] OCCUR MEDE)Cpl~lYgn.PIilr1llll) 15 000
- P!MONAL. & ADV INJUR"I ,UIOO ODO
- GENERAL AGGREGATE. 12..000 DOO
~~~G"TElINIT,llPnLFm:: PRDOUCTS-OOWPrOPAGG s2JlOO ODO
POI.ICVI I~ coo
A ~TOIl108ILE. UABlLITY AC P71 01695018 11126104 11/26/05 COMBlNEDSfNQLE lJM/T
~ ANY AUTD iEuecidBrtl 11.000,000
- ~L.OV"IMI:DAUTOS BODIlY INJURY
(pOI'pctmn) .
f- .&CI-IEDUlED Mo&
~ tiRED AUT08 DODIL,,( INJU"'"
.
~ NOIKM'NWAUTOS (Per8lXilWll)
PROPERTY OAMAQE .
(pl!Irl!llXilSl'lnl:]
=F" UA..... AUTOONL'f' .iAAOODE.NT .
AN'ro'\UTl) OT~~ lllAN EAf'<:<> I
IiJJTOONLY: Am .
A D:I8IUM8~ LMIUTY ACP710189!l018 11/28104 11/28105 EACH OCCURRENCE .SJlOO DOO
OCCUR 0 ~SIrlMDE AOOREGATE 15 ODO DOO
.
R tEDOOTIBLE I .
AETEIl'T1ON I .
A WORKERS COMPENMTIOH AIID ACP7101695018 1112&104 11/261ll5 I:wcs;r~I~' IO~
EIIPL.O'ft:RS"UiIUILI1Y $510.000
NlY PACPRET'QRlPARTf'ERtE)ECUTI'tIE E.L~ACa)!NT
OFFICBVMEMBER EXCLUCEO? E.L DISEASE. EA EMPlOYEE I .!lOO ODO
~~=~8bclaw EL DISEASE _ PCLICV UMIT .500 ODO
A ornER Buikfing ACP710169D018 1112&104 11/261ll8 B . $66l.OOD
por.onal Property PP $502,500
DUc::RPllON OF OPERATlOI'tS/ UX:ATlJKli/VEHICL.E.lI EXCLUIIGMS ADDED BY ENDDRSEIlIENTISPECIALPRCYl&ICWS
1l1e City 01 D"'uqua, Including all Its .I....d and appolntod oft'clal&,
all its .mploy..s and volunteers, all its boards, commissions ...d/or
authoritiea and their bORrd membera~ employe.. and volunte.. are an
additional in.ured as respects their interest in the Bbove captioned
(Soe Attachad Descriptions)
CERTIFICATE HOLDER
CANCELLATION
Cityaf Dubuque
C/O City Clorb Offico
lot Floor City Hall
ao Wosl13th street
Dubuque.1A 52001
&HDULD AH'r OF THE ABCJ'lIE DESCRIBED POlICIES ECANCELLED IEFORE'" OPltA.T1DN
DA.1E THEREOF. TKE ISSU"O INSURERWIU.........A:l;;IJ.KS.1MlL .....3IL DA.Y8WR1TTEN
NOTIlOE TO TKE.GER11F1CATE. HOLDER NAtE) ToO THE LIiFT,....a JItllllnUHLagll~
...lJtI__..RM:III"'MlUIJOCI:*IX......INfCr .1 D~VJ(
ACORD 25 (2DO'1lli11 ol3
"'S4004lIIN39077
JAP
" ACORD CORPORA T.oN 118a
IMPORTANT
ij Ihe certifKlala holdar is an ADDITIONAL INSURED, lhe polioy(ies} roost be endorsed. A statement
on tnls cenlficate does not confer rlgl1ts to the OBnl'f1cat8 holder 1n lieu of such endorsemen({s).
If SUBROGATION IS WAIVED, subiecl to lheterrnsand conditions"fthe polioy, c..-lein policies may
require an endoraemenl. A atatement on this certificate does not confer rights to the certificale
hold81' il'l Hflu of suCh endlltsement(s).
DISCLAIMER
The Gertlftcate of Insurance on the reverse side of Ihls fonn does not constitute a contract between
the issuing lnsurer(s), aul~d rapresentati.....e or prooucer. ard the certifICate holder r nor d08& it
affirmatively or negativQjy amend. extend or alter the coveragQ afforded by the polcies listed thereon.
ACORD 2!l-ll (2001108) 2 on
1tS4OO4D/M39077
!:.."~..~:;':'::..,:'.;:;'.:"..:'.'~"i'.':..".::~;"..";;':'!;p~$~ijl~,.tQN~:(~9W~i~ij~~'ffpm..#'ii9ii'~I.'~.':';'.;..!','...;,!..!...;...'.;,;......;..';:~..:..;.
. ......................................".....................,.................."...........__...........,.................,..,..'.......................u.,...................,......."'....,.'......
,..,.......,.............,.....",...
. ,. __..... . ... .. ... .d . .d' _. .... ... .. u... ... ... ..... --.. ....... ... ......
generalliabilily pOlicy. General LiabilKy Coverage is primary and non
cc:ntributary. Govemmenlallmmunllies endorsement an Gener.1I
Liability and WaIVer 01 Subrogalon on WollCe~. Compensation to apply.
AMS 25.3 (21101108)
3 of3
1tS4OO401M39077
D
Allied
Insurance
AMCO INSURANCE COMPANY
a Nationwide- company
On Your Side~
CHANGE OF DECLARATIONS ENDORSEMENT
POLICY NUMBER ACP BPO 7101S9501S
NAMED INSURED: MISSMAN STANLEY AND ASSOCIATES
- PLEASE READ CAREFULLY.
PREMIER BUSINESSOWNERS
MAILING ADDRESS: 1011 27TH AVE
ROCK ISLAND, IL 61201-5231
AGENT NAME: RUHL & RUHL, INC,
AGENT ADDRESS: DAVENPORT IA 52801
POLICY PERIOD: FROM 11-26-04 TO 11-26-05
EFFECTIVE DATE OF CHANGE: 12-10-04
NOT A STATEMENT - YOUR BILLING WILL FOLLOW
14 01135
NO CHARGE
12:01 A.M. Standard Time
12:01 A.M. Standard Time
TOTAL PREMIUM
******.................... ADDITIONAL INSURED .................. NO. 002000
THE CITY OF DUBUQUE
ADDED NAME
THE CITY OF DUBUQUE
ADDED
INTEREST
CITY HALL. DUBUQUE IA 52003
ADDED
FORM NUMBER
PB6003
PREMIUM CHANGE
MUNICIPALITY CHANGE
.............................. ENDORSEMENT ................................
ADDED ENDORSEKENT FORM
FORM PB6003 EDITION DATE 0101
A COPY OF THIS FORM IS ATTACHED
CHANGED ENDORSEKENT FORM
FORM PB6003
A COPY OF THIS FORM IS ATTACHED
CHANGED ENDORSEKENT FORM
FORM PB6003
A COpy OF THIS FORM IS ATTACHED
ADDED ENDORSEKENT FORM
FORM PB2500 EDITION DATE 0101
A COPY OF THIS FORM IS ATTACHED
~
~
~
~
'DIRECT BILL LEVY 05025
AGENT COPY
ALLIED SERIES
POLICY
$
.00
$
.00
804627800 74 05431
EFFECTIVE DATE: 12:01 AM Standard Time,
<at your principal place of business)
BUSINESSOWNERS
PB 25 00 (01-01)
THIS ENDORSEMENT CHANGES THE POLICY. PLEASE READ IT CAREFULLY.
PB6003
ADDTIONAL INSURED
All terms and conditions of this policy apply unless modified by this endorsement.
PB 25 00 ,01-01)
ACP BPO 7101695018
AGENT COPY
74 05432
EFFECTIVE DATE: 12:01 AM Standard Time,
(at your principal place of business)
BUSINESSOWNERS
PB 60 03 (01-01)
THIS ENDORSEMENT CHANGES THE POLICY. PLEASE READ IT CAREFULLY,
ADDITIONAL INSURED - MUNICIPALITIES OR PUBLIC AGENCY
INSURED PROVIDING PROFESSIONAL SERVICES
This endorsement modifies insurance provided under the following:
PREMIER BUSINESSOWNERS LIABILITY COVERAGE FORM
SCHEDULE
Municipality and/or Public Agency:
THE CITY OF DUBUQUE
The following is added to Section II. WHO IS AN IN-
SURED:
This insurance, including any duty we have to de-
fend "suits", does not apply to "bodily injury'"
"property damage" or "personal and advertising in-
jury" that arises out of, in whole or in part. or is a
result of, in whole or in part, the active or primary
negligence of the municipality and/or public agency
designated in the Schedule of this endorsement,
whether or not such negligence has assumed by you
in a contract or agreement.
The municipality and/or publiC agency designated in
the Schedule of this endorsement is also an insured,
but only with respect to liability arising out of your
operations, other than the rendering of or the failure
to render professional services. advice of instruc-
tion, subject to the following additional exclusion:
All terms and conditions of this policy apply unless modified by this endorsement.
PB 60 03 (01-01)
ACP BPO 7101695018
AGENT COPY
74 05433
D
Allied
Insurance
AMCO INSURANCE COMPANY
a Nationwide- company
On YourSide~
CHANGE OF DECLARATIONS ENDORSEMENT
POLICY NUMBER ACP BPO 7101695018
NAMED INSURED: MISSMAN STANLEY AND ASSOCIATES
ALLIED SERIES
- PLEASE READ CAREFULLY.
PREMIER BUSINESSOWNERS
POLICY
MAILING ADDRESS: 1011 27TH AVE
ROCK ISLAND, IL 61201-5231
AGENT NAME: RUHL & RUHL, INC. 14 01135 NO CHARGE $ .00
AGENT ADDRESS: DAVENPORT IA 52801
POLICY PERIOD: FROM 11-26-04 TO 11-26-05 12:01 A.M. Standard Time
EFFECTIVE DATE OF CHANGE: 12-10-04 12:01 A.M. Standard Time TOTAL PREMIUM
NOT A STATEMENT - YOUR BILLING WILL FOLLOW
************.****..***..**.*** ENDORSEMENT .****..******...*****.**********
CHANGED ENDORSEMENT FORM
FORM PB2500 EDITION DATE 0101
A COPY OF THIS FORM IS ATTACHED
CHANGED ENDORSEMENT FORM
FORM PB2500 EDITION DATE 0101
A COPY OF THIS FORM IS ATTACHED
CHANGED ENDORSEMENT FORM
FORM PB2500 EDITION DATE 0101
A COPY OF THIS FORM IS ATTACHED
CHANGED ENDORSEMENT FORM
FORM PB2500 EDITION DATE 0101
A COpy OF THIS FORM IS ATTACHED
CHANGED ENDORSEHENT FORM
FORM PB2500 EDITION DATE 0101
A COpy OF THIS FORM IS ATTACHED
CHANGED ENDORSEMENT FORM
FORM PB2500 EDITION DATE 0101
A COpy OF THIS FORM IS ATTACHED
CHANGED ENDORSEMENT FORM
FORM PB2500 EDITION DATE 0101
A COPY OF THIS FORM IS ATTACHED
CHANGED ENDORSEMENT FORM
FORM PB2500 EDITION DATE 0101
A COFY OF THIS FORM IS ATTACHED
CHANGED ENDORSEMENT FORM
FORM PB2500 EDITION DATE 0101
A COpy OF THIS FORM IS ATTACHED
ADDED ENDORSEMENT FORM
FORM PB2500 EDITION DATE 0101
A COPY OF THIS FORM IS ATTACHED
~
ll!
.
~
nlRECT BILL LEVY 05026 AGENT COpy 804627600 74 08301
EFFECTIVE DATE: 12:01 AM Standard Time,
(at your principal place of business)
BUSINESSOWNERS
PB 25 00 (01-01)
THIS ENDORSEMENT CHANGES THE POLICY. PLEASE READ IT CAREFULLY.
PB6003
ADDTIONAL INSURED
THE CITY OF DUBUQUE, INCLUDING ALL ITS ELECTED AND APPOINTED
OFFICIALS, ALL ITS EMPLOYEES AND VOLUNTEERS, ALL ITS BOARDS
COMMISSIONS AND/OR AUTHORITIES AND THEIR BOARD MEMEBERS,
EMPLOYEES AND VOLUNTEERS.
All terms and conditions of this policy apply unless modified by this endorsement.
PB 25 00 (01-01)
ACP SPO 7101695018
AGENT COPY
74 08302
EFFECTIVE DATE: 12:01 AM Standard Time.
(at your principal place of business)
BUSINESSOWNERS
PB 25 00 (01-01)
THIS ENDORSEMENT CHANGES THE POLICY. PLEASE READ IT CAREFULLY.
THIS ENDORSMENT CHANGES THE POLICY, PLEASE READ IT CAREFULLY
WAIVER OF GOVERNMENTAL IMMUNITY
THIS ENDORSEMENT MODIFIES INSURANCE PROVIDED UNDER THE
FOLLOWING:
ALLIED PREMIER BUSINESSOWNERS POLICY
WE WILL WAIVE BOTH IN THE ADJUSTMENT OF CLAIMS AND IN THE
DEFENSE OF "SUITS' AGAINST THE INSURED,ANY GOVERNMENTAL
IMMUNITY OF THE INSURED, UNLESS THE INSURED REQUESTS IN
WRITING THAT WE NOT DO SO.
WAIVER OF IMMUNITY AS A DEFENSE WILL NOT SUBJECT US TO LIABILITY
FOR ANY PORTION OF A CLAIM OR JUDGEMENT IN EXCESS OF THE
APPLICABLE LIMIT OF INSURANCE.
All terms and conditions of this policy apply unless modified by this endorsement.
PB 25 00 (01-01)
ACP SPO 7101695018
AGENT COPY
74 08303
we 00 03 13 (04-84l
WORKERS COMPENSATION AND EMPLOYERS LIABILITY INSURANCE POLICY
WAIVER OF OUR RIGHT TO RECOVER FROM OTHERS ENDORSEMENT
We have the right to recover our payments from anyone liable fa an injury covered by this policy, We..;1I not enforce
our rig,t against l1e person or organization named in the Sdledule. (This agreement aw1ies only to the extent that
you perform work under a wri1ten Ca11ract that requires you to obtain this agreement from us.)
This a\Teement shall not operate directiy or indirectly to benefil anyone not named in the Schedule,
Schedule
CITY OF DUBUQUE
This endorsement manges the pdicy to vd1idl it is aUached and is effective on the date issued unless otherwise
stated.
(The InfonnatlOll below Ie required Ully when thl. endorsement Is Issued subsequent to preparation of the pdiq.)
Endorsement Effective
Endorsement No.
Insured
Pdicy No.
Premium $
Countersigned By
WC 00 03 13 (04-84)
ACP WCA 7101695018
74pe
AGENTS COPY
704 0008310