HomeMy WebLinkAboutProWest - Professional Services Agreement - ARcGis programming - 12.20.2021 PROJECT ESTIMATE PROWEST
E. A S S O C IAT E S
GISCONSULTING I DATASERVICES I APPLJCATIONS
City of Waterloo, IA
Sidewalk Inspector Updates- Itemized
Date: 11/18/2021
Client: Ben Wagner
GIS Coordinator
715 Mulberry St
Waterloo, IA 50703
PROJECT
Pro-West will make discussed updates to the functionality of the Sidewalk Inspector Solution. These updates have
been itemized and can made individually as needed.
Pro-West&Associates Project Manager: Name: Paul Rairamo
Phone: 952-250-1022
Email: prairamo@prowestgis.com
Client Project Manager (PM): Name: Ben Wagner
Phone: 319-291-4598
Email: ben.wagner@waterloo-ia.org
Project Schedule: TBD
RESPONSIBILITIES.CLIENT
1. Provide access to parcel data (attributes to include the tax address and PIN).
2. Provide access to the Zone layer
3. Provide access to enterprise geodatabase and SQL server for inspection form development and
report generation
4. Provide the cost calculation values to generate cost spreadsheet
5. Provide Schedule calculations to generate schedule final pdf
6. Provide access to the City data currently used in the Cost Est.— Parcel Query spreadsheet
7. Provide property valuation numbers to be used in generating the schedule
8. Provide feedback when asked in a timely matter
9. Provide Pro-West with the City's ArcGIS Online/Portal login information with Admin rights, or provide
Pro-West with an account
10. Provide AGO and/or Portal named user licenses for staff as needed,to support the proposed project
11. Provide GPS capabilities to support the project
It's important to know 8239 State 371 NW I PO Box 812 1 Walker, MN 56484
PH 320.207.6868 1 FX 320.207.6869 1 www.prowestgis.com I consult@prowestgis.com
PROWEST
6. A S,5 O C IAT E S
12. Provide mobile devices to support the project, and configure VPN access, if needed
13. Provide wireless service on mobile devices to support the project
14. Provide PWA feedback if there going to be a fee associated with the "Other'. If there is it would
need to be added as an input field when the other option is selected.
*If assistance is needed with client responsibilities, additional costs may apply
Sidewalk Inspector Updates
1. Remove "Problem" points and combine/consolidate into the "Panel" points.
a. Merge Problem points and Panel points
i. Result in one feature class
ii. Update Type attribute domain values
b. Identify and resolve any data merge issues
i. Updates to schema
ii. Share any merge issues with city to get resolution
c. Update sql views that are using the problem points
2. Update the property owner information in for the open inspections and identify options for
automating property owner information.
a. PWA will setup a call to discuss options for approaching both issues as there are various
options
3. [DEPANDANT ON COMPLETION OF#1 ABOVE]Add "Paid by City"field to the Panel points and have
formula ignore these points for the price calculation.
a. The City came across properties where the City will cover the cost of a panel or two due to a
city manhole causing the issue, but the remaining panels will still be the property owner's
responsibility.The City-paid panel will still be in the spreadsheet so users can keep track of
costs.
4. Add new fields to the Survey123 form. We have had dimensions accidentally left blank on the form,
so it was not able to calculate a price based on the volume.
a. Update Survey123 Configuration
i. Additional questions, removal of unneeded ones
5. Update Web Application Configurations
a. Update popups, styles, widget
2
PROWEST
6 A F,S O C 1 1\T E S
6. [DEPANDANT ON COMPLETION OF#1 ABOVE] Update Map Services
a. Update symbology using Type attribute
b. Publish map service for viewing
c. Required questions
7. Report Updates
a. Add highlighted items back into the reports.
i. Stump Removal
ii. New 4" Sidewalk
iii. Brick Repair
iv. ADA Ramp
V. Add "other"fees as directed by client
b. Update symbology so users can easily which problem code each panel point has
i. PWA has a couple options to approach this request, however,we cannot guarantee
that the symbology can be changed significantly.
c. Change "Class F Sidewalk Patch"to "Sidewalk Patch" on Cost Estimate and Proposed
Assessment.
i. Change the label for the fee in the report.
d. Add an option to create a "Proposed Assessment W/Map"which would be the Proposed
Assessment, plus the map page from the Cost Estimate. Map will be used to print for the
city's contractor to use in the field.
e. The text in the notes field for completed panel points are still showing up on the forms even
though the panel has been completed. Need to have all attribute fields for completed panel
points to be ignored when generating a report.
**Pro-West&Associates suggests that the city begin updates with line item one, as it needs to be complete
before other items can be accomplished.
PROJECT COMPLETION & POST PROJ ECT SU PPORT
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 inspector solution will be managed and maintained by the City of Waterloo.
3
PROWEST
6 A S,S O C 1 1\T E S
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.
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
Md
1. Stakeholders are not identified at the beginning of the project
a. Mitigation: City 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.
4
PROWEST
6. A F,5 O C IAT E S
Item Cost
1. Remove "Problem" points and $3075.93
combine/consolidate into the "Panel" points
2. Update the property owner information in for $1169.82
the open inspections and identify options for
automating property owner information.
3. Add "Paid by City"field to the Panel points and $805.11
have formula ignore these points for the price
calculation
4. Add new fields to the Survey123 form. We have $1317.76
had some dimensions accidentally left blank on
the form, so it was not able to calculate a price
based on the volume.
5. Update Web Application Configurations $1132.05
6. Update Map Services $953.05
7. Report Update $2842.03
Total $11295.75
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 Pro-West&Associates
Acceptance Signature: Signature:
0e1+11 H114
12-8-21Date: � Date:
Estimate valid for 90 days
5