2020/12/02 Council Agenda Packet

P hase 5, Task 17: CivicPlus Integration U tilizing the methodology outlined above Timmons Group will design and develop the integration between CivicPlus and Cityworks. The integration will imitate the current "Public Works Service Request Form" available on the City's CivicPlus website. The integration will enable functionality so that when requests are submitted online, a matching service request is created in Cityworks. Phase 5, Task 17: City Responsibility: • City will schedule and provide attendance at discovery workshop for integration functional requirements & design. (8-16 hours) • Review of design documents once designed (2-4 FTE hours) Phase 5, Task 17: Timmons Group Responsibilities and Deliverables: • Develop integration per functional requirements • Create a service request in Cityworks when a request is taken through the Public Works Service Request form on the City's website. Phase 5, Task 17: Assumptions: • City IT will provide assistance for Timmons staff in support of this effort. • Assistance from CivicPlus may be necessary for the completion of this task. The City will be responsible for aiding communication between all parties involved. • City will provide review comments within 10 business days or a mutually agreed upon timeframe • Everett does not currently have a 311 system in place and have been looking into Open311 options. • Everett would like to integrate with a public facing 311 system like SeeClickFix or RockSolid in the future. This would be a phase 2 task. Phase 5, Task 17: Estimated Timeframe: • The development of the integration will require approximately 6-10 weeks P hase 5, Task 18: CIS Infinity Integration U tilizing the methodology outlined above Timmons Group will design and develop the integration between CIS Infinity and Cityworks. Phase 5, Task 18: City Responsibility: • City will schedule and provide attendance at discovery workshop for integration functional requirements & design. (8-16 hours) • Review of design documents once designed (2-4 FTE hours) Phase 5, Task 18: Timmons Group Responsibilities and Deliverables: • Develop integration per functional requirements • Design a solution for performing transmission line shutdowns that will include the following. Solution to be mix of workflow design as well as data transfer from Cityworks to GIS: o Ability for a user to select the location of the .shutdown and identify ■ Valves that need to be turned off ■ Customers that will be affected by shutdown o A method to output contact information (from CIS Infinity) for customers that will be affected in a shutdown so that notifications can be printed. • Provide GIS & Cityworks users the ability to view customer and meter information from service location points in GIS maps. Map users need to be able to select a point and view the current customer and meter information. • Upload customer information from CIS Infinity into Cityworks customer accounts daily. This will make the customer list available to call takers as a caller lookup during service request creation in Cityworks. Phase 5, Task 18: Assumptions: • City will provide review comments within 10 business days or a mutually agreed upon timeframe • This does not include integration of workflows for meter related activities like installs and change -outs. Phase 5, Task 18: Estimated Timeframe: • The development of the integration will require approximately 10-14 weeks P hase 5, Task 19: Wonderware/SCADA Integration U tilizing the methodology outlined above Timmons Group will design and develop the integration between Wonderware (SCADA) and Cityworks to send asset readings into Cityworks to automatically create work orders in Cityworks for operations staff based on the readings from SCADA. Work orders would be 27'Page