The URL can be used to link to this page

Home My Public Portal AboutResolution 2022-03-02 Authorizing Expenditure from Water Fund for Scada System UpgradesTOWN OF FRASER RESOLUTION NO. 2022-03-02 A RESOLUTION AUTHORIZING THE EXPENDITURE FROM THE WATER FUND FOR SCADA System Upgrades. WHEREAS, the 2022 Budget provides for certain water system projects. THEREFORE, BE IT RESOLVED BY THE BOARD OF TRUSTEES OF THE TOWN OF FRASER, COLORADO THAT: 1. The Town Board of Trustees, Fraser, Colorado hereby authorizes Staff to expend up to $13,550.00 from the Water Fund Engineering Account 50-40-330 for services and hardware necessary to host the SCADA system in the cloud. 2. Said purchases must be completed in year 2022 or the approval will no longer be effective. READ, PASSED ON ROLL CALL VOTE, AND ADOPTED BY THE BOARD OF TRUSTEES THIS 2nd DAY OF March 2022. Votes in favor: Votes opposed: Absent: Abstained: 2 0 BOARD OF TRUSTEES OF THE SER, COLS;; ADO 0 O BY: Mayor ATTEST: 0-4Ja-f-Nj. 1W -(A9 Town Clerk Town of Fraser PO Box 370, Fraser, CO 80442 office 970-726-5491 fax 970-726-5518 www.frasercolorado.com MEMO TO: Mayor Vandernail and the Board of Trustees FROM: Adam Cwiklin, Water and Wastewater Superintendent and Russell Pennington, P.E., Public Works Director DATE: March 2, 2022 SUBJECT: Cloud Hosted SCADA System SUBJECT: SCADA System Upgrades DEPARTMENT: Public Works PRESENTER/PREPARER: Russell Pennington, Public Works Director Adam Cwiklin, Water and Wastewater Superintendent FISCAL INFORMATION: Cost as Recommended: $13,550 Balance Available: $30,000 Fund: Water Budget Line-Item Number: 50-40-330 Engineering New Appropriation Required: No REQUESTED ACTON: Approve the Resolution 2022-03-02 to appropriate funding to execute priorities 21 of the SCADA Master Plan and authorize the appropriate Town officer to expend said funds. SUMMARY AND BACKGROUND OF SUBJECT MATTER: SCADA stands for System Control and Data Acquisition. It ultimately controls water system automation and maintains operating records for the Town. Upgrades to the system started in 2014 when the PLCs and touchscreens were replaced at the water treatment plants, pump stations and storage tanks. The Fraser well field wells and were upgraded in 2019 and Town Hall hardware and software in 2021. To date, The Town has completed 20 of 21 priorities listed in the SCADA master plan (attached). Number 21, the final priority, is to relocate SCADA system from a desktop server to the Cloud. The SCADA system is more robust than it was a few years ago, but there is still potential for a single point of failure. The SCADA CPU is currently a desktop server computer located in Town Hall. If there were an event that Fraser Town Hall is compromised, Fraser would operate its water system in hand or Town of Fraser PO Box 370, Fraser, CO 80442 office 970-726-5491 fax 970-726-5518 www.frasercolorado.com manually until the situation is remedied. Moving the SCADA system software client to the cloud and utilizing the desktop server as the backup would eliminate a single point of failure situation and allow Fraser to operate via direct connection to the software in the cloud from any Microsoft device. Moving from a desktop to the cloud requires two annual expenses and hardware changes. The annual expenses are the cloud hosting service and a corresponding server maintenance service. The hardware changes are due to proprietary compatibility issues. Apple vs Microsoft. Currently, Utility operators use Ipads for remote desktop connection to a desktop server, the primary SCADA computer. The cloud server cannot support Remote Desktop Connections. Remote Desktop services require Active Directory (AD) and a cloud-based Windows OS server cannot provide AD. The iPads cannot go directly to the cloud server. They are limited to connect to the desktop server. Surface tablets are made by Microsoft and use Windows 10 OS. The Ignition client can be installed on the Surface Tablets and then the Surface can connect directly to the cloud server. To function in the cloud, Utilities needs to replace the iPads with Surface Tablets. SCOPE OF WORK: There are three components need to complete the transfer to the cloud and maintain full operations. 1. Azure services. This is an annual subscription for cloud hosted SCADA system. 2. Annual SCADA Server Maintenance Plan 3. Change from iPad to Surface Tablet. Replace the iPads with Surface Tablets. Surface tablets are made by Microsoft and use Windows 10 OS. We can install the Ignition client on the Surface Tablets and then the Surface can connect directly to the cloud server. The Surface tablets are similar in cost to an iPad. They can also be purchase with a built-in LTE cellular card for internet access. Annual Azure Services Browns Hill $4,650.00 Annual SCADA server maintenance Browns Hill $1,700.00 Microsoft Tablets (4 at $1500) Executec $6,000.00 Subtotal $12,350.00 Contingency (20%on hardware) $1,200.00 Total $13,550.00 The engineer’s estimate for the project is $12,350.00. The project funding includes contingency amounts for a total of $13,550.00 which can be used towards unforeseen changes during installation and programing. PROJECT SCHEDULE Notice of Award March 3, 2022 Notice to Proceed March 3, 2022 Improvements complete May 1, 2022 Town of Fraser PO Box 370, Fraser, CO 80442 office 970-726-5491 fax 970-726-5518 www.frasercolorado.com ATTACHMENTS: SCADA Master Plan Job# 21-754 SQ01 Job#22-023 SQ02 REV 1 Email, Cloud SCADA access JWalker Resolution No. 2022-03-02 STAFF RECOMMENDATION: Motion to approve Resolution No. 2022-03-02 authorizing the Staff to complete SCADA Master Plan priority number 21 using the Engineering Account (50 -40-330) of the 2022 Water Fund in an amount not to exceed $13,550. Priority Site Issue Commments Cost Implementation Date Century Link Verizon Cellular 1 Yellow Zone Tank Yellow Zone Tank Communications are not reliable with existing serial radio connection to Town Hall Internet Connection at YZT Completed 2019 X 2 Maryvale WTP Install Internet connection to receive Yellow Zone Tank Communications Completed 2019 X 3 Maryvale WTP/YZT Modify Communications to allow Yellow Zone Tank Level to go directly to Maryvale WTP. Modify HMI to receive YZT Tank Level from Maryvale WTP Completed 2019 4 Well 8 Install Internet Connection for direct communications with other sites. Included in Well 8 Rehab Included in Well 8 Rehab Planned for Aug. 2019 Refer to Quote 18-023 SQ01 X 5 Fraser WTP Install Internet Connection for direct communications with other sites. Fraser WTP internet connection will be shared with Well 2 $3,633 Approval of Quote 19-023 SQ17 X 6 Blue Zone Tank Install Internet Connection for direct communications with other sites. $3,052 Approval of Quote 19-023 SQ18 X 7 Fraser WTP/BZT Modify Communications to allow Blue Zone Tank Level to go directly to Fraser WTP. Modify HMI to receive BZT Level from Fraser WTP $1,500 Approval of Quote 19-023 SQ19 8 Green Zone PS Install Internet Connection for direct communications with other sites. $3,640 Approval of Quote 19-023 SQ09 X 9 Red Zone PS Install Internet Connection for direct communications with other sites. $3,640 Approval of Quote 19-023 SQ10 X 10 Green Zone PS Reprogram Green Zone PLC to obtain YZT and GZT Levels directly from these tanks for Pump Station Control. Modify Green Zone OIT to display data directly from Maryvale WTP & Red Zone PS $1,808 Approval of Quote 19-023 SQ11 11 Red Zone PS Modify Red Zone OIT to display data directly from Maryvale WTP & Green Zone PS $950 Approval of Quote 19-023 SQ12 12 Town Hall/ Maryvale WTP Revise communications failure alarming for updated communications paths. Modify Maryvale OIT to display data directly from Green Zone PS & Red Zone PS $2,068 Approval of Quote 19-023 SQ13 13 Town Hall HMI Modify existing HMI configuration for direct access to Maryvale WTP, GZPS, RZPS PLCs. Update OIT and HMI setpoint tags for direct access. Remove PLC messaging at Town Hall $6,580 Approval of Quote 19-023 SQ14 14 Well 1 Existing PLC is scheduled for End of Life in 2021 and does not support Ethernet communications. Replace existing PLC. Install Internet Connection and VPN for direct communications with other sites. Modify Fraser WTP PLC/OIT and Town Hall HMI computer for direct communications with Well. Well 1 internet connection will be shared with Well 3B $10,500 Approval of Quote 19-023 SQ15 X May 9, 2019 Town of Fraser - SCADA Master Plan 15 Well 2 Existing PLC is scheduled for End of Life in 2021 and does not support Ethernet communications. Replace existing PLC. Install Internet Connection and VPN for direct communications with other sites. Modify Fraser WTP PLC/OIT and Town Hall HMI computer for direct communications with Well. Well 2 will utilize radio connection to access internet connection at Fraser WTP $10,500 Approval of Quote 19-023 SQ16 16 Well 3B Existing PLC is scheduled for End of Life in 2021 and does not support Ethernet communications. Replace existing PLC. Install Internet Connection and VPN for direct communications with other sites. Modify Fraser WTP PLC/OIT and Town Hall HMI computer for direct communications with Well. Well 3B will utilize radio connection to access internet connection at Well 1 $10,500 Similar to Quote 19- 023 SQ16 17 Well 5R Existing PLC is scheduled for End of Life in 2021 and does not support Ethernet communications. Replace existing PLC. Install Internet Connection and VPN for direct communications with other sites. Modify Fraser WTP PLC/OIT and Town Hall HMI computer for direct communications with Well. $10,500 Similar to Quote 19- 023 SQ15 X 18 Well 7 Existing PLC is scheduled for End of Life in 2021 and does not support Ethernet communications. Replace existing PLC. Install Internet Connection and VPN for direct communications with other sites. Modify Fraser WTP PLC/OIT and Town Hall HMI computer for direct communications with Well. Well 7 internet connection will be shared with Well 9 $10,500 Similar to Quote 19- 023 SQ15 X 19 Well 9 Existing PLC is scheduled for End of Life in 2021 and does not support Ethernet communications. Replace existing PLC. Install Internet Connection and VPN for direct communications with other sites. Modify Fraser WTP PLC/OIT and Town Hall HMI computer for direct communications with Well. Well 9 will utilize radio connection to access internet connection at Well 7 $10,500 Similar to Quote 19- 023 SQ16 20 Town Hall HMI Computer + Software Phase 1: Replace exsiting Genesis-32 software with Ignition software. Installed Locally on new new computer, provided by Town. Gen-32 will be discontinued in 2020 and existing HMI is due for replacement. $21,000 Plan to Implement in 2020 21 Town Hall HMI Computer + Software Phase 2: Add Microsoft Azure Cloud Services to provide redundancy HMI screens can be accessed from Town Hall or Internet $8,000 Plan to Implement in 2021 $89,871