HomeMy WebLinkAboutProWest_&_Associates_-_SidewalkUpdates_-_10.6.2025Docusign Envelope ID: 377E1D49-EFF1-47E3-BBBC-21846B7574E4
PROJECT ESTIMATE PROWEST
S.. ASSOCIATES
GIS CONSULTING I DATA SERVICES I APPLICATIONS
City of Waterloo, IA
Sidewalk Inspection Application Updates
Date: 9/23/2025
Client: Ben Wagner
GIS Director
715 Mulberry St
Waterloo, IA 50703
PROJECT DESCRIPTIO
Pro -West proposes an update to the City's existing Sidewalk Inspection application. An initial inspection will
be submitted to the system by a field user. This will then initiate the SQL Trigger to evaluate the stacked
parcels and insert a new point for each intersected parcel. Parcel information will be inserted with the
inspection along with the details collected by field staff. Each point will be stacked and manually moved by
city staff to the site address associated with the inspection point.
PROJECT MANAGEMENT
Pro -West & Associates Project Manager: Name: Paul Rairamo
Phone: 320-207-6855
Email: prairamo@prowestgis.com
Client Project Manager (PM):
Project Schedule: TBD
Name: Ben Wagner
Phone: 319-291-4522
Email: ben.wagner@waterloo-ia.org
CLIENT RESPONSIBILITIES
IMP
III
• All email correspondence will be sent to the PWA PM and Technical Lead, as well as any additional
stakeholders for the Block Hour Support.
• The client will provide Pro -West with remote connection to servers as needed.
• Additional responsibilities will be identified as tasks are issued.
*If assistance is needed with client responsibilities, additional costs may apply
It's important to know
8239 State 371 NW I PO Box 812 I Walker, MN 56484
PH 320.207.6868 I FX 320.207.6869 I www.prowestgis.com
I
consult@prowestgis.com
Docusign Envelope ID: 377E1D49-EFF1-47E3-BBBC-21846B7574E4
PROWEST
6 ASSOCIATES
Remote Connection
Pro -West uses Beyond Trust to facilitate remote connections. Team members connect to a session with a
custom session key and portable installer and maintain temporary access needed for the duration of the
project (minutes to days). When the project is complete, or the connection is no longer needed, PWA team
members close the tool and it removes itself from the system —The session key is then no longer valid and if
additional work is needed, team members will be provided a new key for a new connection.
Optionally, we can maintain access after the initial project is complete, with authorization from the client.
DELIVERABL
SQL Server Trigger
• Using the SQL Server, PWA will create a Trigger that will insert additional inspection points for each
parcel that is overlapping.
Indexing Script
• Nightly script that will rebuild indexes in the Sidewalk Inspection Database.
o This will assure the best performance of the Trigger and services.
PROJECT COMPLETION & POST PROJECT SUPPORT
Project Completion:
The project will be completed when:
1. All updates have been deployed
2. The project close out call has been completed
Upon project close, the Sidewalk Manager application will be managed and maintained by the City of
Waterloo.
Post Project Support
PWA understands that support requests and/or general support inquiries will occur after the project is
completed. We welcome those inquiries and look forward to supporting you in the future! Below are
common inquiries related to general support requests.
1. If there are issues with the deliverables or if clarification is needed regarding the deliverables, contact
the PWA Project Manager listed in this scope.
2. If the PWA Project Manager is contacted, after the project is completed, you may be invoiced for that
call or email. The PM will discuss invoicing needs during the call. If you contact anyone other than
the PWA Project Manager, after the project is completed, an invoice will be sent based on current
hourly rates.
2
Docusign Envelope ID: 377E1D49-EFF1-47E3-BBBC-21846B7574E4
PROWEST
ASSOCIATES
3. If the Project Manager is contacted after the project is completed, they are not available to respond,
and the need is urgent (ie: the Project Manager is on vacation or is attending a workshop); contact
PWA's main office number for assistance: 320-207-6868 or follow directions listed on the Project
Managers out of office reply (if email is used).
a. There may be an invoice sent for the support request based on current hourly rates if
Technical staff are contacted directly. The PWA Project Manager will follow up when they
are available to discuss invoicing.
4. PWA asks that both the PWA Project Manager and the Technical person be copied on emails to
ensure prompt service and clarification on needs and any additional fees. If at any time there is a
question about an invoice or support need, contact the PWA Project Manager.
5. If there are general questions about any topic related to GIS and/or PWA Services, contact the PWA
Project Manager listed in this scope. You may be invoiced for that call or email. The PM will discuss
invoicing needs on the call.
PROJECT RISKS & MITIGATION
1. Stakeholders are not identified at the beginning of the project
a. Mitigation: Client and PWA will identify stakeholders at the project kick off. If changes in
stakeholders occur, they will be communicated to the stakeholders immediately to eliminate
and/or minimize timeline and budget changes.
2. Stakeholders change throughout the project
a. Mitigation: Maintain the same project stakeholders throughout the project. If stakeholders do
change, it is the client's responsibility to communicate the purpose of the project to the new
stakeholder or for PWA to communicate changes to the client. If the project changes due to a
change in stakeholders, additional charges may apply and the timeline may be affected.
PROJECT ASSUMPTIONS
• The Trigger relies on stacked parcels.
1. If a Condo exists, but there are not stacked parcels, the trigger will not create multiple points.
• Initial Inspection Details will be the same for each inserted point
1. Details can be individually modified after the points are created.
• The Trigger will create stacked points representing inspection records for each parcel. The points will
need to be manually moved to each residence.
COST ESTIMAT
3
Docusign Envelope ID: 377E1D49-EFF1-47E3-BBBC-21846B7574E4
PRDWEST
E. A55C C IAT E5
$3,835.80
Invoicing Schedule: PWA will invoice monthly based on percent of project completed.
If the scope, objectives, or timeline change significantly before the project is completed, we will agree to
discuss any necessary modifications to our agreed -upon fee or to the scope, objectives, or timeline of the
project.
* Payment is due within 45 days of an invoice date. If payments are not received within 45 days of the invoice
date, a late fee of 1.5% of the invoice amount will be charged for each 45 day cycle that the payment is late.
** 3% convenience fee will be added for payment by credit card
To proceed with the described services in this estimate, please sign and date below and return to the Project
Manager listed above.
CLIENT
c41a�utgneao Signature:
at -Whin, hV?
UUSLSU tlAA(,6449...
Estimate valid for 90 days
Date: 10/6/2025
Pro -West & Associates
Signature
Date:
9/24/2025
4