The URL can be used to link to this page

Home My WebLink AboutProWest & Associates - Professional Services Agreement - ArcGis - digital sidewalk solution - 6.20.2022PROJECT ESTIMATE PROWEST S.. ASSOCIATES GISCONSULTNG [ DATA SERVICES I APPIJ CATIONS City of Waterloo, IA As -Built Reprot Date: 05/23/2022 Client: Ben Wagner GIS Coordinator 715 Mulberry St. Waterloo, IA 50703 PROJECT DESCRIPTION Pro -West will assist the City of Waterloo, Iowa with the creation of an as built Report for the existing Sidewalk Inspector solution at the city. This report will enable field workers to complete "as built" inspections. Pro -West & Associates Project Manager: Name: Paul Rairamo Phone: 952-250-1022 Email: prairamo@prowestgis.com Client Project Manager (PM): Project Schedule: TBD Name: Ben Wagner Phone: 319-291-4598 Email: ben.wagner@waterloo-ia.org 1Ir' •III 1F.yI • Client will provide Pro -West with ArcGIS Online access • Client will attend all meetings/calls associated with this project • Client will have necessary licensing • Client will provide feedback on report *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 PRDWEST 6. ASSOCIATES DELIVERABLES 1) Update siPanels feature class a) Add new attribute 'completedby' to represent who completed the panel and set to use the domain described below. b) Add new domain siPanelCompletedBy with values/options of "Assessment Program" and "Private Property Owner". 2) Update map services a) Include new 'completedby' attribute in map documents and republish map services (viewing, editing, field inventory). 3) Update web maps and apps a) Update configuration of web maps and apps to include 'completedby' attribute (Mobile Viewer, Viewer). b) Update configuration of Survey123 form to include 'completedby' attribute. Relevant when Resolved ='Yes'; required question. 4) Add an As -Built button to the inspection report widget. Inspection Reports G \ A • • • ' Di.R.ny.. prom r� Coss Esirmmcs Proposed Assessments CanuaaorMap Pages Proposed AssassmentsSpreadsheel Repair Summary r.t y S-rovr Pop -Up r 5) Add an option to select the inspection year when running the As -Built report 6) Create a new set of views in sql to support the As -Built report 2 PRDWEST A C B C C I A T E S a) Views will be identical to the existing set used for the Proposed Assessments and Contractor Map Pages i) Filter by the new assessment field instead of the status field ii) Add the inspection year to the views 7) Create a new As -Built report a) Contractor Map Pages report with the following adjustments. i) Change the title to "As -Built" ii) Remove the "Be" from "Area to be repaired" iii) Only show inspections where one or more panels is covered by the assessment program iv) Only shows the panels covered by the assessment program CITY OF WATERLOO, IOWA SIDEWALK I NSPECTION RE PORT PROPERTY AOOREsi 1011 E LTMOSE ET C..:1 5411}S13Fi004 Tom EM.0 Como A. Re.ks Mow— •- A FIneYl LCCAIYS4 Of i+ LwM WIDTH Ca SIDE144R OE PT ri OF SaOEMIALR AMA TO id REPAIRED (OQE F - IAl(I#S COO! 6 N41f 0 Flom Two Dads 1h16 ❑ FM! ❑S FYI ▪ .Vd,p ❑e,.se.t +'-V7.43409 S-000S%Ft Wm/S4fwA1S hLQI WATER VALVE CAP lERACE UWE RECORE6 Q loo WATT11 VALVE ADJUST PENT 10EMAR EC. ❑ nw u❑ - MAs4 PE+Nl1FAEkT READ.. If Cod ME 6 Elm ❑4a ❑ O1" w s.1 P.m ❑ 4 k#ye ❑ °.00 ❑ CAW A. 4`-444a F1 Qr..A4Q44RFk EN. ua. N$q.raF—la.prl Amon m.M1ad rM ,F ion b. row Rd by Aiding .i a r.+l p li d. ..tt I forrly. 1,1 lam N.i.. thy tat kale R.eta[ Fa. Mpandn Md. B. FORNEP PORED Training Al aim m.r Moils. ..p.i.J brdocwwuchona? Cute 14431421 LXIM.-ElE4 1. Pro -West will conduct one 1 hour training session with the city to review functionality and set up 3 PRDWEST A C S CIC I A T E 5 PROJECT COMPLETION & POST PROJECT SUPPORT Project Completion: The project will be completed when: 1. The Report has been deployed 2. The project close out call has been completed Upon project close, the report 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. 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 4 PRDWEST A C 5 C C I A T E 8 1. Stakeholders are not identified at the beginning of the project a. Mitigation: County 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. $3,950.99 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 Acceptance Signature: Quet 1Itz 9-LaarE Estimate valid for 90 days Date: June 20, 2022 Pro -West & Associates Signature: _ Date: 6/8/2022 5