The URL can be used to link to this page

Home My WebLink AboutRESPONSE - RFP - 8161 FLOOD WARNING SYSTEMOneRaia=-,, The Rainfall Company RESPONSE TO RFP 8161 FLOOD WARNING SYSTEM SOFTWARE FOR THE CITY OF FORT COLLINS Submitted to City of Fort Collins Purchasing Division 215 North Mason Street, end Floor Fort Collins, Colorado 80524 Submitted by OneRain Incorporated 1531 Skyway Drive, Unit D, Longmont, CO 80504 Contact: James Logan I Email: james.logan@onerain.com 1.800.758.RAIN (7246) or 303.774.2033 Due: October 23, 2015 by 3:00 P.m. Mountain Time The proposed implementation, illustrated above, has two independent base station servers hosted on - premise —one at the City of Fort Collins IT facilities and the other Poudre Fire Authority facilities —each server running licensed Contrail Base Station software, and replicating their database updates in real time. The secondary Contrail Base Station provides public URL Web access and specific user level privilege views of the data. Although both servers are hosted by the City`s facilities, they should be in geographically disparate locations for the purpose of survivability of local system failures. A Custom Serial-to-IP Connection Kit is available to purchase from OneRain, if required. The devices would be pre-programmed and pre -configured by OneRain for your specific site requirements for ease of installation and setup. We have included pricing for this under section 4.2 Additional Optional Services/ Deliverables. Note: An alternative option for the City would have the secondary base station, Contrail Cloud Server, hosted by OneRain in our data center. Contrail Cloud Server is a OneRain-hosted virtual server resource running the full version of Contrail Base Station software in our secure industrial data center. (Pricing for this option is not included in this proposal). 2.2.2 Login and Access Privileges Contrail has full role -based permissions, including read-only, and varying rights for editing content. The following roles are defined and combinations of these privileges and can be assigned individually to each user: ■ "Account Admin" ■ "Normal User Access" ■ "System Admin" ■ "View Alarms" ■ "View Invalid Data" ■ "View Raw Data" ■ "Web Content Admin" Security and Encryption Data between the browser and Contrail are encrypted. This is important for transmitting sensitive data like username and password. TLS/SSL (Transport Layer Security/Secure Sockets Layer) authenticates and secures the data transfers by using certificate -based authentication and symmetric encryption keys. For Contrail Base Station, a TLS/SSL certificate is required to enable encryption and authentication on your site domain and use the HTTPS protocol. (Reference June 8, 2015 White House M-15-13 Memorandum for the Heads of Executive Department and Agencies "Policy to Require Secure Connections across Federal Websites and Web Services" here: https://www.whitehouse.gov/sites/default/files/omb/memoranda/ 2015/m-15-13.pdf). 2.2.3 Mobile and Web -based Solution Contrail is fully Web based and provides desktop and mobile access for unlimited users and administrators. All system users and administrators can use the Web to access everything the application offers; there is no client software required besides a standard Web browser. Contrail's adaptive, responsive platform gives users easy access to what they need and brings full capabilities and accessibility to all devices (desktop, mobile, tablet) for a rich, engaging, context -relevant user experience any Web - enabled device. Contrail is almost entirely Web -administered, as are its field operations. The City of Fort Collins will have its own, branded Web interface. You can create multiple views/websites to serve as many entities as required, including individual agencies and the public separately, should you so choose. Each licensed Contrail Base Station is licensed to host up to 5 client websites, individually branded for each client agency. Each Web view can be handed off to its own administrator/agency, such that they manage their own look -and -feel, content, links, users and alarms. OneRain Incorporated I Response to RFP 8161 FWS Software Page 8 Unlimited Number of Users Using licensed Contrail Base Station you can support an unlimited number of users via a single or multiple website(s), each either username-password securable or public. For example, if your website is set up with alarms and notifications specific to your needs, you can choose to support a sub -client (e.g. Office of Emergency Management or Water Quality) with their own, individually -branded website. There are also options for a shared or public website. Some examples of agencies showing public -facing views of Contrail (no login/password required) may be viewed by visiting OneRain's corporate website at https://onerain.com/contrail-customers. 2.2.4 Environment and Operating Platform Virtual Machine Hosting Platform Contrail is designed to operate on a virtual machine platform. Agencies across the U.S. are running Contrail Software on virtual machines hosted by VMware, Oracle Virtual Box, RTS Hypervisor, and Citrix XenServer. The use of virtual machine hosting platforms allows the Contrail software to be hosted on base server and base hosting operating systems that match the Agency's requirements. Operating Platform Contrail operates on a Linux-based server running MySQL enterprise database. The Linux operating system we support is Red Hat 6 Enterprise -class 64bit (x86) Linux Distribution (RPM Based). We support both the commercial licensed version and CentOS 6, the free open source version of Red Hat 6. Unless otherwise required by our clients, OneRain installs the CentOS free open source version of Red Hat 6. (If commercial Red Hat 6 Enterprise is preferred, it must be purchased, licensed, and maintained separately by the client). Environment Server virtualization can be used in place of a dedicated physical server. Server hardware is not included in this proposal. Server hardware must meet the minimum requirement specifications required by the Contrail platform. See "Addendum II — Additional Information" to refer to our "Contrail Base Station Pre -Installation Planning" document that provides specific platform, network, and operating system requirements, as well as information for the software implementation process for virtualized hardware. OneRain does not provide specific images for virtualization platforms. One (i) Contrail Base Station software license is required per server. An unlimited number of users are supported per server license. Additional Contrail Base Station licenses may be purchased for deployment on each additional server. Database Storage OneRain's Contrail software is hosted on a MySQL database platform that is fully ODBC compliant. The proposed solution uses a two -server configuration, with real-time MySQL database replication that keeps the two servers in synch with each other. Each server is a hot backup of the other server, ready to take over operations should the other server become unavailable. The software performs scheduled automated backups at each server which maintains redundant copies so that the databases can be restored from either server. Exporting of Data via Other Database ODBC Communications to other City Outlets OneRain's Contrail software runs on a MySQL, which is fully ODBC compliant, but OneRain recommends that agencies use its Data Exchange API for sharing data with other applications. The Data Exchange API uses XML for exchange of data and is designed to be data model independent. OneRain will add features and performance improvements to Contrail as client requirements change. Those changes will likely result in improvements to the internal data model, which could impact any direct queries of the database. OneRain will maintain the standard Data Exchange API compatibility throughout any internal data model changes. Once the City implements their data feeds to the other City outlets via the Data Exchange API, those interfaces should be expected to work. 2.2.5 Implementation and Project Schedule OneRain has completed numerous Contrail implementations across many agency sizes and technology environments —we have a dedicated and experienced team to get things done right. As a result of our OneRain Incorporated I Response to RFP 8161 FWS Software Page 9 experience over the years, we've developed an implementation methodology that assists all of the relevant stakeholders with the Contrail deployment. We will assign a dedicated Project Manager to you, and assemble a team of in-house implementation experts with decades of combined experience. From there, we will work closely with you to construct a plan and timeline for the Contrail implementation and deployment. The "Contrail Base Station Pre - Installation Planning" document discusses pre -installation considerations and provides guidelines to ensure that your installation of Contrail Base Station proceeds smoothly (see Addendum II — Additional Information). We will work closely in partnership with the City through every phase of the transition, training and support to ensure your complete satisfaction. The approach we will take is to perform a standard dual architecture (primary and secondary) Contrail® Base Station installation. The OneRain team will work closely with the City's Information Technology Department for installation and configuration of the software hosted in a virtualized server environment, should that be the path the City chooses. We will first get the standard ALERT, USGS and METAR data feeds up and running. The ALERT site and sensor configurations will be extracted from your DIADvisor" implementation and converted into Contrail site and sensor configurations. All of the alarm definitions and contacts will be converted into Contrail contacts and alarm deliveries. The standard implementation directly addresses all of the requirements specified for the base station software. The USGS and METAR site and sensor configurations will be derived from the respective government agency websites. The CDWR (Colorado Division of Water Resources) interface will require OneRain to write a Data Agent to automatically retrieve the real-time data from the CDWR website. Once the CDWR data agent is developed, those sites and sensors will be configured in the Contrail web interface. System Setup using Virtual Server -Supported Base Station Hosts An overview of the Contrail software implementation process for virtualized hardware is provided in the "Contrail Base Station Pre -Installation Planning" (see Addendum II). i) Information Gathering (City -specific information for base station implementation) a. Extract ALERT site and sensor metadata from existing base station b. Identify USGS sites c. Identify METAR sites d. Identify CDWR sites e. Get map boundary information f. Identify server configuration and location (server vs. virtual machine) i. IP addresses, open ports, firewalls g. Identify branding look and feel colors and logos 2) Load Contrail Software onto Servers a. Load standard Contrail Base Station software modules i. Database ii. Web Software iii. Data Services Modules iv. Data Collectors and Data Agents v. Data Exchange API 3) Configure City -Specific Client Websites, as needed a. Create and install maps b. Setup ALERT data collection i. Configure ALERT sites and sensors I Enable ALERT IP Collector iii. Verify ALERT data collection c. Setup USGS data collection i. Configure USGS sites and sensors I Enable USGS data agent iii. Verify USGS data collection d. Setup METAR data collection i. Configure METAR sites and sensors OneRain Incorporated I Response to RFP 8161 FWS Software Page io I Enable METAR data agent iii. Verify METAR data collection e. Configure City -specific Look and Feel 4) Training on new software a. Administrator Training b. Server Admin Training c. End User Training 5) On -site Equipment Maintenance Training Additional Steps for City customization: 6) Transfer existing calibrations, alarm settings, notification recipient settings a. Identify existing calibration and extract from existing base station b. Identify existing site and sensors alarm settings c. Identify contacts for alarm notifications d. Identify delivery notification methods and setting e. Load data into Contrail f. Enable and test alarm settings and notifications g. Verify data transfer 7) Historical Data Migration and Loading h. Export historical data from existing base station into flat files i. Process historical data into standard formats for loading j. Load data into Contrail historical data tables k. Verify historical data load 8) Develop CDWR data collection interface a. Establish contact with CDWR system b. Develop CDWR Data Agent c. Enable and test CDWR software collector d. Verify CDWR data collection 2.2.6 Schedule The City has outlined their goals for the project schedule that includes the necessary tasks including planning, deployment, and testing, which would facilitate a fully operational base system and completion of the project by April 1, 2oi6. We have taken this requested scope, along with the targeted timeline and created a preliminary Project Plan. The Project Plan is depicted in Gantt chart format below: OneRain Incorporated I Response to RFP 8161 FWS Software Page 11 Flood Warning System Software City of Fort Collins, Colorado 11/22/2015 122/2015 12/12/2015 12/22/2015 1/1/2016 1/11/2016 1/21/2016 1/31/2016 2/10/2016 Sign Contract Information Gathering Setup Preinstall Document (network, ports, configuration) Get current and all archive DIADvisor databases Identify USGS, CDWR, and METAR sites Identify server condiguration and locations Identify branding (look and feel of user websites) Contrail Software Installation Configure Servers Load standard software Contrail Software Configuration Configure an port existing site and sensor configurations Configure ALERT data collection Configure USGS Data Collection Configure METAR configuration Contrail Web Configured and Operational Configure and port ALARMS Historical Data Load Training Admin./Server Training User Training Develop CDWR System Interface Project Management Figure 4 - Gantt Chart: Flood Warning System Software Implementation Schedule 2.3 Deliverables We believe that our proposed Contrail solution addresses the required services and deliverables specified by the City in this RFP. We have completed the FWS SOFTWARE DELIVERABLES spreadsheet as required and have attached it in Addendum I — RFP Documents and Forms. If the City of Fort Collins determines that OneRain's response is deficient in any way, OneRain respectfully requests to be promptly notified and be given the opportunity to correct any such deficiency. 2.4 Training and Documentation The Contrail Base Station package includes the software, documentation, set-up and on -site installation, as well as training. Users and administrators will always have access the latest Help documentation incorporated in the software. OneRain will provide in-depth end -user, system administrator and server administrator training on site with the City's own system and data. OneRain's appointed Project Manager will coordinate the training schedule with the City once the system is set up and data is being collected. On -site training will take place over two (2) consecutive days and includes: i. System Administration Training: Detailed training on server access and usage. Full description and details of the architecture of the system, how all the components interface and details of each component. Troubleshooting and problem solving processes are covered. This advanced training is designed for those responsible for maintaining the servers, applying software upgrades and performing system failovers. OneRain Incorporated I Response to RFP 8161 FWS Software Page 12 2. Contrail Administrator Interface: Setting up users and authorizing privilege levels, establishing sites and sensors, creating validation formulas, setting thresholds and creating alarm rules and notifications, acknowledging and clearing alarms, accessing alarm logs, accessing standard maintenance reports, modifying themes, adding content and links. 3. Contrail User Training: Detailed user interface, viewing data with map view and site lists; drilling down to sensor data. Use of single and multiple graphs. Retrieving historical data and exporting data. Overview of detailed help system. Ongoing and Refresher Training In addition to on -site training, OneRain offers a variety of on -going online training sessions for our software and solutions. We provide a monthly complimentary online live webinar training series for Contrail system administrators who want to refresh or expand their knowledge of the software. Users and administrators are also invited to sign up for other online training sessions that are periodically scheduled as new features are introduced. Customized live webinar training or additional on -site training that is exclusively tailored for your agency may be arranged at any time at an additional cost. OneRain Incorporated I Response to RFP 8161 FWS Software Page 13 3 Assigned Personnel and Firm Capability 3.1 Primary Contact Information Below is the primary contact for OneRain in relation to this RFP and is the person authorized to contractually obligate and negotiate for the company. Name: Title: Company: Mailing Address: Telephone: Email: James R. Logan Chief Executive Officer OneRain Incorporated 1531 Skyway Drive, Unit D Longmont, CO 80504 (303) 774-2033 james.logan@onerain.com Exhibit A, Proposal Acknowledgement form, has been completed as required and is included in Addendum I — RFP Documents and Forms. 3.2 Company History and Capabilities OneRain Incorporated was started in 1992 as DIAD Inc. to integrate automated, telemetered monitoring stations and provide software for collecting real-time environmental data. The founders were among the earliest implementers of automated, telemetered monitoring stations and software for real-time environmental data, having started in the domain in the 1970s. In 2003, DIAD acquired NEXRAIN in order to increase the accuracy of rainfall estimates by using rain gauge data to calibrate NEXRAD data. At that time the company name became OneRain. Since its inception, OneRain has provided rainfall and related environmental information for agencies with critical missions. Today, OneRain's offerings include nationwide, 24/7-supported enterprise data collection, archiving, notification and Web visualization services. Our products include local data collection software, telemetry system integration, rain and other hydrometeorological gauging and professional services, real-time satellite and IP telemetry services, gauge -adjusted radar -rainfall estimates, storm properties analyses and consulting services. OneRain is a recognized industry leader providing professional services, software applications and data services in the ALERT/ALERT2 real-time monitoring domain. The OneRain team has established its flood -warning domain leadership through years of demonstrated expertise and successful projects. We serve local, state and federal agencies with solutions that enable either and/or both widespread public access of real-time information and secure information systems for operations, emergency and engineering uses. OneRain is a recognized industry leader providing professional services, software applications and data services in the ALERT/ALERT2 real-time monitoring domain. OneRain has contributed to the fundamentals of the industry in its 23 years of existence and is today helping to shape the next generation of real-time hydrometeorological monitoring technology and systems. We are the software innovators that introduced graphical and map -based user -knowledge interfaces, we led the development and implementation of the new ALERT2TM open standard protocol, and we are among a couple pioneers in measuring rainfall using gauge and radar data. We are the first enterprise to provide both licensed software and 24/7-hosted professional services so our customers can operate robust, geographically -distributed environmental monitoring decision support systems cost effectively. We have designed and built, evaluated, rehabilitated, and maintained real-time monitoring systems for small and large agencies across the U.S. since 1992. A distinguishing characteristic of our company is its expertise from instrumentation and maintenance through software and dissemination, with emphasis on accurate, verifiable and reliable data collection of rainfall and related hydrological data. OneRain's professional services and solutions start in the field, integrate using appropriate telecommunications, and encompass data stored locally using mission critical OneRain Incorporated I Response to RFP 8161 FWS Software Page 14 software and/or centrally in OneRain data centers with live notification to agency customers about their concerns. We are continually adding records to our hosted data center Contrail® enterprise (about 15,000,00o new data records are added each month from 32,00o across the U.S., most of them in real time) and we perform historical analyses as well. Our customers feel secure in having the option to have all their data stored at both their place and ours to provide them redundancy and easy access. OneRain has led the real-time hydrologic monitoring domain with involvement since its inception. We brought the first unit -pricing contract maintenance model to the table when we began working with Denver's Urban Drainage and Flood Control District (UDFCD) in the mid-198os. We brought the first Microsoft® Windows -based ALERT base station software (DIADvisorTm, formerly known as "StormWatch") to market in the mid-199os, including the introduction of map -based displays with graphical rainfall overlays and open standard database access. We leveraged the Internet to support host - clients real-time data dissemination in 1997, before anyone else. We co -invented the complementary encoding transmission scheme that enables ALERT to perform control functions (gates and flashers). We began offering gauge -calibrated radar rainfall as a real-time and historical data service in the late 199os. Today, OneRain is a recognized industry -leading provider of real-time and historical rainfall and hydrologic -related data and professional services to local, state and federal government agencies across the country. Application areas include flood warning, reservoir operations, dam safety programs, irrigation, water quality, wastewater and stormwater collection, planning, modeling, and forensic analyses. OneRain has 16 full-time salaried employees. OneRain is a Colorado subchapter S corporation and is certified as a small and/or woman -owned business by a variety of entities. 3.3 Prior Experience with Similar Systems OneRain has over 20 years' experience working on similar successful flood warning projects. The OneRain team provides unmatched depth and breadth of experience in successfully implementing systems similar to the requirements of the City. The outcome of this project will be a flood monitoring system that fully serves the City's needs by combining the best available technology and software tools with common sense practices that have served flood warning needs across the country. With an estimated more than 140 U.S. agencies using our real-time environmental data collection and decision support applications, the OneRain team offers a broad range of experience and expertise in delivering real-time environmental information systems to customers with mission critical applications. We have successfully designed and/or implemented similar flood warning systems for a variety of agencies such as public works, flood control districts, and sewer authorities in a number of cities and counties across the country. The following is a partial representative sample of clients specifically using the proposed Contrail software, many of whom are prior DIADvisorTM users like the City of Fort. ■ Alameda County, CA 5 Marin County, CA ■ Aurora, CO, City of — Public Works/Utilities ■ Boulder County, CO — Office of Emergency Management (OEM) ■ Boulder, CO, City of ■ Bureau of Indian Affairs (BIA) Safety of Dams National Monitoring Program ■ Bureau of Reclamation (BOR), Loveland, CO ■ Charlotte -Mecklenburg County, NC - Storm Water Services ■ Denver Water, CO ■ Dominion Water and Sanitation District, CO ■ Dona Ana Flood Control District, NM ■ Douglas County, CO — Department of Public Works ■ Monterey County, CA — Water Resources Agency ■ Napa County, CA — Flood Control District (FCD) ■ North Carolina Emergency Management FIMAN ■ Overland Park, KS ■ Ohio Office of Emergency Management (Statewide System) ■ Papio-Missouri River NRD, NE ■ Placer County, CA ■ Prince George's County, MD ■ Sacramento County, CA - Dept. of Water Resources ■ San Diego County, CA ■ San Jacinto River Authority, TX ■ San Joaquin County, CA OneRain Incorporated I Response to RFP 8161 FWS Software Page 15 ■ East Bay Dischargers Authority, CA ■ Elephant Butte Irrigation District, Las Cruces, NM ■ Entergy Corporation, AK ■ Fairfax County Department of Public Works and Environmental Services, VA ■ Harris County Flood Control District, TX ■ Howard County, MD — Public Works ■ Kennedy Space Center, FL ■ Louisville/Jefferson County, KY — MSD 3.4 Client References and Contacts ■ Santa Barbara County, Flood Control District, CA ■ Santa Cruz County, CA — Flood Control and Water Conservation District ■ Trinity River Authority of Texas - Livingston Lake ■ Truckee River Flood Management Authority, NV ■ Tulsa, OK, City of ■ Urban Drainage & Flood Control District, CO ■ U. S. Army Corps of Engineer, Portland, OR ■ Wichita, City of, KS ■ WEST Consultants, Inc. The following six (6) selected Contrail Base Station implementations are provided as reference and all have requirements similar to the City of Fort Collins. The selected projects are intended to highlight OneRain's experience designing and supporting and maintaining real-time monitoring networks with secure and reliable data management: Harris County Flood Control District, TX Regional Flood ALERT System OneRain upgraded the Harris County Flood Control District's (HCFCD) regional ALERT network, which included ALERT2 upgrades to the three primary repeater sites in the network, base station upgrade to a 3-server Contrail Base Station implementation, and full support for nine (9) partner agencies. The HCFCD Contrail Base Station can be accessed via the URL http://alert.hcfed.onerain.com Contact(s): Jeff Lindner, Harris County, Flood Watch Manager /Meteorologist Harris County Flood Control District 99oo Northwest Freeway, Houston TX 77092 Tel: (713) 684-4165 Email: jeffrey.lindner@hcfcd.org Jim Greeson, Flood Alert Manager Harris County Flood Control District 99oo Northwest Freeway, Houston TX 77092 Tel: (713) 684-4165 Email: jim.greeson@hcfcd.org r CONTRAIL SUFiIh'ARE OneRain Incorporated I Response to RFP 8161 FWS Software Page 16 City of Overland Park and Johnson County (OP/JoCo), KS, and KCMO Metropolitan Area System Implemented in a dual server arrangement; Contrail Base Station solution with a primary server at City Hall and a backup server at the Fire Station emergency management center. This implementation was completed as part of an overall ALERT upgrade to support the ALERT2TI protocol. This was the r7 first production implementation of an ALERT2-based system. Contact(s): City of Overland Park, KS Daniel Miller, P.E., City Engineer, 8500 Santa Fe, Overland Park KS 66212 Tel: (913) 895-6032 Email: Daniel.Miller@opkansas.org Johnson County, KS Kent Lage, P.E., Manager, Urban Services Division, 1800 West 56 Highway, Olathe KS 66o6i Tel: (913) 715-8333 Email: Kent.Lage@jocogov.org Kansas City, MO James Walton, P.E., Civil Engineer, Stormwater Division, 4800 East 63rd Street, Kansas City MO 64130 Tel: (816) 513-0384 Email: James_Walton@kcmo.org North Carolina Division of Emergency Management, Statewide Rain and Stream Gauging Monitoring Network NCEM implemented a dual server Contrail Base Station solution with servers running on virtual machines in two independent data centers owned by the State. These servers collect data from the North Carolina statewide ALERT network consisting of approximately 196 sites and 640 sensors. They also collect and integrate data from 345 USGS sites and 1 METAR site. Referred to as the North Carolina Inundation Mapping and Alert Network (FIMAN), this system supports the mission of North Carolina Office of Emergency Management. USGS sites are integrated via an LRGS interface, which accesses their data from the GOES downlink site at Wallops Island via the Internet. Contact(s): David Herlong Management Engineer, Floodplain Mapping Program North Carolina Emergency Management 83o-B Tillery Place 4719 Mail Service Center Raleigh NC 27699-4719 Tel: (919) 825-2322 Email: dherlong@ncem.org "OneRain's base station software application is the backbone of Overland Park's Flood Warning System. It provides the primary source for our data analysis and flood event operations, and will continue to be in the future. Their [OneRain] assistance in enhancing our hardware to meet current and future standards of innovation has helped Overland Park become the leading agency in the flood warning community in the field of technology." - City Engineer, OP ®� ,. ... .,... "The goal of the system is to reduce the loss of life and flood -related property damage by providing emergency managers and the public with more timely, detailed and accurate information." - NC Flood Warning Program OneRain Incorporated I Response to RFP 8161 FWS Software Page 17 One Rain The Rainfall Company October 21, 2015 Ms. Pat Johnson, CPPB Senior Buyer City of Fort Collins Purchasing Division 215 North Mason Street, end Floor Fort Collins, Colorado 80524 Re: Response to Request for Proposal for Flood Warning Data Management Software Reference: RFP 8161 Dear Ms. Johnson, As the individual authorized to contractually obligate and negotiate for OneRain, I am pleased to submit our response to the City of Fort Collins ("the City") request for proposals for Flood Warning Data Management Software for use by the Stormwater Division and partner agencies of the City of Fort Collins. We acknowledge receipt of RFP Addendum No. i, issued October 15, 2015. OneRain has successfully demonstrated that it is a trusted and reliable vendor and partner. We are honored to have served the City of Fort Collins for more than 15 years supporting the City's Flood Warning program. Our experience working in partnership with the City over the years allows us to fully understand and appreciate the City's requirements and goals described under this RFP. For more than 20 years, OneRain (formerly DIAD) has been providing private and public sector clients across the United States and around the world with solutions to optimize water management, heighten regulatory compliance, achieve successful civil works, and save lives. We support and serve several government agencies, metropolitan districts, municipalities and engineering firms across the U.S. The software solution we are proposing, Contrail®, has been in use since 2005 and is designed to meet the demands of a mission -critical flood early warning system. Contrail will enable the City's Stormwater and Emergency Response personnel meet their goals and carry out their mission with a heightened effectiveness. Our proposal includes a representative sample of clients, whose focus, like yours, is hydrologic monitoring and flood early warning. We hope the enclosed credentials illustrate similar systems and services performed and our comprehensive experience. Thank you for giving us the opportunity to respond to this RFP. We look forward to the possibility of continuing to support the City and its partners during this evolution in your program. Sin ely, Jam Logan Chie Executive Officer 303-774-2033 (main) 303-774-2035 (direct) james.logan@onerain.com Dona Ana County Flood Commission, Las Cruces, New Mexico Regional Real-time Hydrologic Monitoring New Regional Real-time Hydrologic Monitoring ALERT2TM Network Built from the Ground Up In 2013, the Dofia Ana County Flood Commission contracted with a team of experts which included OneRain, to provide an implementation Flood Warning Master Plan for deployment over the next five years. As part of Phase 11 of the Dona Ana County Flood Warning Master Plan, OneRain was contracted to create a new regional real-time hydrologic monitoring network. The tasks contracted include the complete design of a robust and dependable ALERT2 network architecture, planned deployment including prioritizing site installations, and complete implementation of the system. OneRain implemented in a primary and secondary dual server Contrail Base Station arrangement. Additionally, OneRain has helped Dona Ana County aggregate a number of additional gauging sources from other agencies, including USGS and local irrigation districts, into their software collection platform. Full implementation of the Flood Warning Master Plan is estimated to be completed in year 2017. Contact(s): John Gwynne, P.E., CFM Engineer Supervisor Dona Ana County Flood Commission 845 N. Motel Boulevard, Las Cruces, NM, 88o07 Tel: (575) 525-5554 Email: johngw@donaanacounty.org City of Wichita, KS Early Flood Warning System A 3-server Contrail Base Station implementation for the City of Wichita; with a primary and secondary server collecting and serving data. The third server has the primary role of supporting a public website, while the primary and secondary servers support storm water operations. Wichita hosts a combination of ALERT, SCADA Wonderware, USGS and METAR sites and sensors on their base stations, and use the system primarily for flood warning, emergency management, and stormwater operations. Their website can be accessed via http_//rainfall.wichita.gov Contact(s): Terry Kelley City of Wichita, Public Works & Utilities Storm Water Management City Hall - 8th Floor 455 N. Main Street, Wichita, KS, 67202 Tel: (316) 268-4026 Email: tkelley@wichita.gov Pa::an sanco�a aP rpooa w,a co�mn__•,I MSaea N2Q _ 235R.e fi3es nrton weamW s Lzsnz o s[mRi au B - w w�,�stmon Nanw_Ba.:r_we� stariana Newa ea.�or Weak weam MW�aBY_Pivv � tzs03 0 ®Beano Pond Nortn� tzsoa Beta Pan 6 Zotlm Mao Benna PDnd South t2505 � Dona w,a co„rLv Hone canalm Dam cabaao_Dam Ps C_ =.ano" W.�= tzsoz 0 Dona ana coonn- PSLnmin9 10)MN 6 LSty a{taaC n're Dona n,•a waamg seep Dona_Ma weatne<_wwn :: a®orl�a B�n.!wo El Paso rtl,P c P15N6 Emory Pa=_ eaMx S[ Emory_Paae_WeaOur_B[a0an2 N M CG f Havnor Bn - HdYBPr_Bndgv Ntit%.M65K4_H934LRndi40DE Hnlloman AFO 0.lam000rtlo. NM rHMN � o rw - NWS WeaNer Forec t evoorL eashurcN er cable Leaaburq_0.rver_Cahle picaclt.9 _W et c F hn W athtt Statron F'a�ae wea�rt:^.-- ather_Ratron � Pladtas_WeaMer_4aeon E I�SS�•";r`�si— anronvNamerstahoD � Rvaor�weatner_sraeon Ro GWM Fl caC= 0836d000 RIG GRANGE BLW_ZB@gL1L4D6N.bM 003b2500 • River PWn• MeeitlaDam Wver Below Mesilla_Dam 'rs G. t _ � WI¢.Dhlilala wyB,u ...ate d.a_. i OneRain Incorporated I Response to RFP 8161 FWS Software Page 18 Fairfax County, VA Early Flood Warning System Fairfax Implemented in a dual server arrangement: Contrail Base Station solution with a primary server at Government Center and a backup server at a secondary government center. The system also provides basin average rainfall values using OneRain's Gauge - Adjusted Radar Rainfall (GARR). This implementation was done as part of a data collection software platform upgrade to increase flood warning capabilities and allow for a much more accurate determination of the actual county -wide distribution of rainfall during intense weather events. Contact(s): Don Lacquement, Engineer III, P.E. Maintenance and Stormwater Management Div. Fairfax County Dept. of Public Works and Environmental Services io635 West Drive Fairfax, VA 22030 Tel: 703-877-28og (direct) Email: don.lacquement@fairfaxcounty.gov 3.5 Key Personnel Assigned to this Contract sa` t.. A. m The Fairfax system's performance was tested during hurricane Sandy in October 2012. During the storm our engineers were out in the field verifying gauges and the ability to access everything through mobile phone was invaluable." - Maintenance & Stormwater Div. OneRain's team is unmatched in its abilities and experience; providing the City of Fort Collins with a value-added service that will provide comprehensive and innovative solutions for the diversity of needs of the agency and its affiliates. All work under this contract will be performed and delivered by the assigned experienced OneRain team. OneRain manages all its projects by having a clearly assigned Project Manager who is responsible for making sure tasks are completed and customer's expectations are met or exceeded. The Project Manager will be the point of contact for keeping the lines of communication open between our organizations and is responsible for all deliveries and official communications. The Project Manager will manage the contract, establish and maintain the project schedules to meet the requirements stated in the RFP, and monitor and assess performance during the contract period to ensure that project requirements are met. The project manager will be responsible for progress and status reporting, review and change requests. OneRain has identified several key personnel for this project— all of whom have a consistent record of successful leadership and project management and technical experience in the area of flood early warning systems and understanding hydrologic data management. The following team organization, depicted in Figure 5, will support this contract. All members are located in Longmont, CO, and will travel to City of Fort Collins for specific installation and training tasks. OneRain Incorporated I Response to RFP 8161 FWS Software Page 19 Figure 5 - Project Organization Chart James Logan, Chief Executive Officer M.S./Computer Science, University of Colorado, Denver, CO B.S./Geophysical Engineering, Colorado School of Mines, Golden, CO Mr. Logan will oversee all aspects of the Project. James Logan has led the creation and successful use of innovative technology in multiple domains over several decades. As CEO of OneRain he is responsible for the success of the company for its customers and its shareholders. His creative approach is built on a foundation of rational process and continuous improvement. He leads productivity by helping people focus on doing the right things for themselves and their families, their workplace and their customers. Mr. Logan promotes ongoing innovation in OneRain's products and services. His technical leadership guides data services, field services, and environmental radar rainfall, and he continues to oversee the development and delivery of new OneRain products. His engineering vision helps shape the sales, marketing and finance systems and processes that support the company in its service to customers. Since joining OneRain in 2004, Mr. Logan has served in leadership roles that included chief of operations, engineering and software development. He has been an active member of the National Hydrologic Warning Council's technical working group for the ALERT2" standard protocol since its formation and he presided over the protocol's first implementations in three major U.S. metropolitan hydrologic monitoring networks. Mr. Logan's professional life prior to joining OneRain was designing, building and operating software systems in the environmental, telecommunications, defense, and healthcare industries starting in 1986. During that time he acquired executive experience in the large corporation environment along with hands on experience with startup companies. Mr. Logan holds four patents in distributed database architecture, distributed processing, graphical layout, and software library architecture. OneRain Incorporated I Response to RFP 8161 FWS Software Page 20 Mike Zucosky, Director of Operations B.S./Electrical Engineering, Case Western Reserve University, Cleveland, Ohio M.B.A./Master of Business Administration, Colorado State University, Fort Collins, CO Mr. Zucosky will be OneRain's primary lead and provide direction for the project team deploying the software, implementing the system, and performing the services. As Director of Operations, Mike Zucosky brings valuable experience in Program and Project Management. Mike has managed installation and maintenance operations of flood alert systems for many government municipalities and districts at a local and national level to ensure high -quality operational hydrologic gauge instrumentation for functionality and public safety. He brings a unique blend of technical and business knowledge and is skilled in job costing, cash flow analysis and critical path scheduling. In summary he: directs the development, testing and implementation of real-time data collection systems for high accuracy meteorological and hydrological gauging stations, serves as the technical liaison between multiple clients and OneRain's software development team, contributes to development of data collection and visualization software, develops and leads training for software products and field training programs for instrumentation hardware, designs, organizes, schedules and manages projects with local and national government organizations, emergency management personnel and engineering firms. He is experienced with Linux, PHP, MySQL, Perl, Python, and other platforms. Rick Jensen, Sr. Software Systems Engineer B.S. Business Information Systems University of Phoenix A.S./Avionics Systems Technology, Community College of the Air Force, Mr. Jensen will be responsible for deploying the software, implementing the system, and per the services. For more than 13 years, Rick Jensen has been designing, building, and operating robust software systems for clients with critical missions in the flood warning, dam safety and water resource management domains. Mr. Jensen started his career in the United States Air Force inspecting, testing and calibrating avionics equipment, and evolved into advanced programming and Web -based visualization. As OneRain's Software Systems Engineer, Rick is the software architect responsible for all aspects of design, development, programming, deployment, and the continual evolution and sustainment of OneRain's enterprise -level software products and data services. He provides oversight and guidance of new product initiatives and the planning and implementation of the enterprise architecture and environment that support them. Mr. Jensen has exemplary computational and technical knowledge and is experienced in a broad range of technologies. He possesses strong communications skills and a keen understanding of essential client requirements to deliver successful and relevant technical solutions. Charles Yost, Meteorologist — Rainfall Analyst M.S./Atmospheric Science, Colorado State University, Fort Collins, CO Concentration: Extreme Rainfall. Thesis: Investigation into a Displacement Bias in Numerical Weather Prediction Models' Forecasts of Mesoscale Convective Systems B.S./Physical Geography, Louisiana State University, Baton Rouge, LA Concentration: Climatology (GPA in Major: 3.8). Undergraduate Project: Climate Division Precipitation Anomalies Under a Varying PDO Diagnostic Framework. Mr. Yost will utilize his expertise, as needed, in precipitation estimate techniques to assist the agency with any post -storm event analysis essential for hydrologic model calibration and planning. Charles Yost's experience in the area of atmospheric science, precipitation estimate techniques and verification metrics in operational forecast models supports OneRain's continued commitment to advancing the technologies that analyze the spatial characteristics of storms using radar -rainfall data. Charles Yost serves as OneRain's lead research and development resource for OneRain's next generation of StormDatall and radar -rainfall products. Charles' particular focus and interests are in radar -derived precipitation estimate techniques, new techniques in extreme -rain events that often cause flooding, OneRain Incorporated I Response to RFP 8161 FWS Software Page 21 mesoscale convective systems, verification of precipitation using traditional and current metrics, societal impacts of weather. 3.6 Availability We understand how critical it is that your expectations are met. OneRain is committed to providing dependable professional services and timely delivery of the proposed Contrail solution within the scheduled scope and the provisional implementation schedule outlined in this RFP. The key technical resources identified in our organization chart for this contract represent a small portion of our available professional resources. We have examined our workloads based on current and future projections and are confident that we have the resources necessary to complete the requirements of this contract as they arise within the projected time requirements. We are accustomed to meeting stringent schedule requirements and client -required scope changes. OneRain Incorporated I Response to RFP 8161 FWS Software Page 22 4 Proposal Cost and Work Hours 4.1 Required Services/Deliverables The following table outlines the licenses and fees associated with the implementation of the core system requirements for this project. It includes Contrail® Base Station software licensing and Standard Software Maintenance and Technical Support for the City of Fort Collins for a period of 5 years. Item Description Qty. Unit Unit Price Sub Total Total 4 Year Support, New Software Licenses $40,000 $40,000 - Primary Contrail Base Station' i Ea. $20,000 $20,000 - Secondary Contrail Base Station' i Ea. $20,000 $20,000 Installation and Setup2 $10,500 - Server Setup, Installation and 40 Hrs. $125 $5,000 Configuration - Migration of Historical Archive 44 Hrs. $125 $5,500 Gauge Data On -Site Training2 $4,000 - 2-Day Training for Users and 1 Ea. $ 4,000 $4,000 Administrators Customization $5,040 - Develop Contrail CDWR Data Agent 36 Hrs. $140 $5,040 OneRain Upgrade Discount ($20,000) ($10,000) - Discount for DIADvisorTM licenses 1 Ea. ($20,000) Total $39,540 $30,000 NOTES: ' One software license is required per server. (Each license includes: Contrail Inventory, Contrail Insight, and Contrail ALERT2 TDMA Manager). The Annual Technical support and maintenance for the primary and secondary software licenses (imposed after the first year) is 25% of the list price. First year support is included with purchase of new software license. Discount shown is for DIADvisor customer loyalty upgrade. 2 Price proposal includes two trips by OneRain staff to the City; one for the entire installation and final configuration and the second to conduct training and any follow-up. 4.2 Additional Optional Services/Deliverables The following are optional components for this project and are priced as follows: Item Description Qty. Unit Unit Sub Total Total Price Optional Hardware $3,000 - OneRain Custom Serial-to-IP 2 Ea. $1,500 $ 3,000 Connection Kit Optional Software Escrow $10,000 Third -party Software Escrow 5 Yr. $2,000 $10,000 Total $13,000 OneRain Incorporated I Response to RFP 8161 FWS Software Page 23 4.3 Schedule of Rates Below are OneRain's hourly labor rates. Any project efforts that have not been unit-costed can be built up from these labor rates. Other as-yet-uncosted projects will be quoted on a time -and -materials basis, if appropriate. OneRain's rate for additional on -site training is $125 per hour. Staff Level Per Hour Level I — Technical Field Services $110.00 Skill level required is BS in Science or Engineering, or equivalent combination of education and experience. Level II — Software Services $125.00 Skill level required is BS in Science or Engineering and five+ years' experience, or equivalent combination of education and experience. Level III — Engineering/Programming Services $140.00 Skill level required is MS in Science or Engineering and five+ years' experience, or equivalent combination of education and experience. Level IV — Project Management/ Sr. Engineering/Consulting Services $180.00 Skill level required is MS in Science or Engineering and ten+ years' experience, or equivalent combination of education and experience. Level V — Principal/Expert Witness $250.00 Skill level required is Masters/PhD in Science or industry/subject matter expert (SME) consultant in the specific field and five+ years' experience, or equivalent combination of education and experience. 4.4 Milestones Listed below are the project milestone tasks with estimated completion from Notice to Proceed (NTP). Project Tasks Contrail Software Activation License Keys Issued 5 days Installation and Setup 23 days Customization: CDWR Data Agent 4o days Historical Data Load 45 days On -Site Training 55 days OneRain Incorporated I Response to RFP 8161 FWS Software Page 24 5 Sustainability/TBL Methodology 5.1 "Managing Water for Good" OneRain's mission is to provide industry leading solutions that empower our clients to perform their critical missions. From the beginning, OneRain's purpose has always been to "Manage Water for Good". It's a principal that extends to our employees, our clients and the communities we serve. We are proud that our solutions and services positively impact our clients, citizens, communities, and the environment and benefit our company at the same time. OneRain strives to grow our organization in a sustainable manner and is committed to making a positive impact on the world around us and to be financially successful. We recognize that how we conduct our business has the opportunity to make a positive impact on society. Focus On Our People and Work Environment The company offers health care, good working hours, a healthy, safe place to work, opportunities for advancement and education. OneRain considers and addresses many different aspects of the work environment. The most significant ones are listed below: ■ Facilities ■ Health and safety ■ Environmental Laws and Regulations ■ Housekeeping and cleanliness ■ Work ethics ■ Working environmental factors such as temperature and humidity control, noise, lighting, ESD, etc. ■ Authorized building access Reducing Our Impact on the Environment In maintaining our operations, we promote a recycling and reuse principle and aim for minimal environmental impact. We are always exploring opportunities to become more sustainable. Some examples of the activities at our facility include: ■ Waste Disposal: Recycle program ■ Minimized paper use with electronic document scanning and central storage ■ Reusable Dishware: Use of ceramic plates, cups, and stainless utensils ■ Reduce Paper Waste: Avoid printing, print double -sided, reuse scrap paper ■ Reuse of shipping/packing materials ■ Electronics Recycling — a minimum of once per year ■ Donations: Unwanted products — printers, computers, vehicles ■ Reduce Travel/Transportation: Hold webinar meetings/conference calls, telecommuting ■ Energy Consumption: Use of energy -efficient products. Thermostatically programmed and controlled environment to reduce energy (varied temperature dependent on occupancy times). Lights turned off when not needed — natural daylight used when possible ■ Cleaning: Non -toxic, bio-degradable environmental friendly products used OneRain Incorporated I Response to RFP 8161 FWS Software Page 25 Benefiting the Communities Where We Do Business Our products and professional services help our clients accomplish their missions to manage water effectively, protect and improve the environment, and save lives. OneRain strives to develop and provide the very best available solutions and services that increase the ability to understand, detect and provide timely, accurate and reliable warnings of threatening weather conditions that impact the environment, and the safety of citizen's lives and property in our communities. We have a responsibility to share our knowledge, expertise and resources to help communities during or after extreme storm or flood events. During the September 2013 flood event here in the Front Range of Colorado, we have volunteered our services and resources to the Boulder County office of emergency management to help them in assessing data and providing assistance to coordinators and first responders. When disasters such as floods or wildfires occur anywhere in the U.S., OneRain redirects its resources to support emergency project triage to rapidly repair gauge network sites damaged by the disaster. Since its inception, OneRain has provided rainfall and related environmental information for agencies with critical missions. The market for OneRain's services continues to grow, as understanding rainfall and its consequences is becoming increasingly critical in the 21st century to protecting our global fresh water resources. OneRain Incorporated I Response to RFP 8161 FWS Software Page 26 6 Addendum I — RFP Documents and Forms 6.1 FWS Software Deliverables Spreadsheet OneRain has completed the FWS Software Deliverables spreadsheet, attached. 6.2 Exhibit A — Proposal Acknowledgement OneRain has completed the Exhibit A — Proposal Acknowledgement form, attached. 6.3 RFP Addenda We acknowledge receipt of RFP Addendum No. 1, issued October 15, 2015. OneRain Incorporated I Response to RFP 8161 FWS Software Page 27 Contents 1 Executive Summary....................................................................................................... 2 2 Scope of Services and Functionality............................................................................... 4 2.1 Overview of Proposed Solution..........................................................................................................4 2.2 Methods and Approach......................................................................................................................7 2.3 Deliverables.......................................................................................................................................12 2.4 Training and Documentation...........................................................................................................12 3 Assigned Personnel and Firm Capability......................................................................14 3.1 Primary Contact Information...........................................................................................................14 3.2 Company History and Capabilities..................................................................................................14 3.3 Prior Experience with Similar Systems...........................................................................................15 3.4 Client References and Contacts........................................................................................................16 3.5 Key Personnel Assigned to this Contract.........................................................................................19 3.6 Availability.........................................................................................................................................22 4 Proposal Cost and Work Hours.................................................................................... 23 4.1 Required Services/Deliverables.......................................................................................................23 4.2 Additional Optional Services/Deliverables.....................................................................................23 4.3 Schedule of Rates..............................................................................................................................24 4.4 Milestones.........................................................................................................................................24 5 Sustainability/TBL Methodology.................................................................................. 25 5.1 "Managing Water for Good".............................................................................................................25 6 Addendum I — RFP Documents and Forms.................................................................. 27 6.1 FWS Software Deliverables Spreadsheet.........................................................................................27 6.2 Exhibit A — Proposal Acknowledgement......................................................................................... 27 6.3 RFP Addenda....................................................................................................................................27 7 Addendum II — Additional Information....................................................................... 28 7.1 OneRain's DUNS Number, Certs and Reps Information...............................................................28 7.2 OneRain Supporting Documentation..............................................................................................28 Table of Figures Figure 1- Contrail's Alarm Manager..................................................................................................................6 Figure 2 - Contrail Alarms and Status................................................................................................................6 Figure 3 - Proposed Contrail Base Station Architecture for the City of Fort Collins.......................................7 Figure 4 - Gantt Chart: Flood Warning System Software Implementation Schedule...................................12 Figure 5 - Project Organization Chart ............................................................................................................. 20 OneRain Incorporated I Response to RFP-2015-PW-142 Page 1 City of F6rt Collins Finance Vendor: OneRain Incorporated Contact: James Logan james.logan@onerain.com (303)774-2033 1531 Skyway Drive, Unit D, Longmont, CO Instructions to Vendors: 1. Columns A-G are for information only. Vendor shall complete the fields in Yellow (Columns H-K). 2. Categories shown in columns B, C, and D are M - Mandatory, I - Important, D - Desired. For more information see PROPOSAL SUBMITTAL REQUIREMENTS and Required Services/Deliverables Sections of 3. For each Function below, Vendor shall mark an "X" in Column H, I or J to indicate if the proposed system is Compliant, Partially Compliant or Not Compliant. For more information see PROPOSAL 4. Please use Column K, Comments, to provide clarifying information. FWS Software - Functional Requirements Category c Q c a 5 o a Comments No. Function E ; E Z E (attach additional sheets as necessary) U d U U M I D 1.0 FWS Software GeneralRequirements -` Hosting and Operation If City hosted, software must operate from two separate and independent servers that connect to the x X base stations. If City hosted, software needs to be able to run fully supported on the City of FC's virtual server X environment X X Web -accessible retrieval and viewing of information x Database storage of system gage infrastructure data (gage locations, elevations, sensor types, sensor X calibrations, rating curves) X X Alarms must be visually displayed on map. X Alarms must be determined via a selection of methods: rate of change, level, digital status, timeout, X selectable NWS guidance X X Multiple alarm thresholds configurable specific to each sensor X X Capture of Standard ALERT protocol data reports X X Capture of ALERT 2 protocol data reports x X Open -sourced platform X Ability to send Alarm and status notifications to text, phone, email, pager, web applications and other X devices hosted by software and/or performed through fully compatible third party software X X Need to be able to copy existing data (in an Access database) into Software database X X Software database compatible with mySQL databases via ODBC X X Rating curves can be user -edited X X Customizable queries of database records X X Customizable reporting from software database x X Ability to receive data from web -based sources (USGS, Colorado Division of Water Resources, other ndependent providers of on-line data) X Display Interface X X Dynamically update the sensor rating curves sourced from websites (USGS, CDWR, etc.) Remote access to map displays of information. X X USGS Ratings automatically updated. CDWR flow available directly from website. X Remote access tooperational database X X Interactive display map(s) are configurable with base maps of aerial, topgraphic and line features. X X Interactive display map(s) of gage and sensor data to include dynamic updating of sensor values X X Sensor data can be visualized in text or graphical format X X Interactive display map(s) capable of displaying multiple sensor type data simultaneously X I Related sensor data are displayed when selecting the icon on the map page to display sensor details. X Interactive display map(s) to include display of cumulative totals for rainfall for selected time intervals X X Interactive display map(s) to include selectable of streamflow units of depth and flow x X Interactive display map(s) to include weather sensor data of atmospheric pressure, temperature, dewpoint temperature, humidity, relative humidity, wndidrection, wind speed, peak wind speed X X Interactive display map(s) to include other sensor data displays that may include ALERT decoding statistics (number of data reports received, decoding ratios), sensor positional (analog) or dispositional (digital) status, and is customizable to display other analog sensor data inputs X Contrail offers many ALERT analysis tools. Known and unknown IDs, sensor performance, ratios of lost data reports. X Interactive display map(s) are configurable with base maps of aerial, topgraphic and line features X X Interactive display map(s) are configurable to display other source information (radar overlays). x X Interactive display map(s) include sensor pop up windows for rainfall hyetographs, streamflow hydrogprahs, and other digital and analog sensor values over selectable time periods. x X Interactive display map(s) are scalable X X Interactive map(s) have pan and zoom map capability X X Map permissions levels can be set to vary functionality among software viewers, users and administrators, for data and map viewing, data retrieval or data editing. X X I IVisual display of alarm levels and conditions on map(s) and via summary tables X X Interactive map(s) displays can be customized according to user access privileges X Sensor Data Management X Pre -established queries for varying durations of rainfall totals and streamflow records. Daily, monthly, yearly etc. x X Customizable querying of data X Customizable reports, not ad hoc queries. X Data records can be marked for preliminary/qualified status or QA'ed status X This can be managed with a process, Reporting - Query Requirements Reports & Queries IGenerate summary reports of rainfall totals for differing time periods x X X I Generate summary reports of sensor performance x X I Pre -established queries for duration of rainfall totals and streamflow records x X I Customizable querying of data x X Data records can be marked for preliminary/qualified status or QA'ed status x This can be managed with a process. i Public Access Requirements Displays are web enabled X X X Displays are mobile -device enabled x X I lAbilityfor the public to select and download data in tabular or flat file format (csv) X X Other Documentation of successful installations of the vendor's product in other jurisdictions x X X Mobile (Field) calibration sensor entry via remote access X X Ability to convert data from Access 2003 and Access 2010 and store in software database x OneRain will support the conversions of all legacy data into new system. Housekeeping X Automated archiving of data X SeCiltLISt Re u » Security �Iiy. 0a .a x X I ISystem authenticates users at login X I ISupports multiple configurable user roles - Data Entry, Auditors, Managers, etc. x X I I Provides access control by user class for system screens x X I I Set data editing rights according to user class x X I lAbilityto controls stem security through user access rights x X I I user authenticates using active directory for internal users x Validation is via authentication, not active directory. X I jAbility to assign access rights by user, group of users and/or department x X I JAIbility to grant or restrict access to specific features, functions and fields x X Ability to restrict configuration capabilities to certain users (i.e.: department heads or Administrators) such as new field creation x X I jAbilityto date and time -stamp all notes and comment fields x X I jAbilityto limit modification and deletion rights x X I jAbilityto secure and authorize access to the underlying data and databases of the application x X I ISystem tracks date, time -stamp and user ID of each record when updated x Support/Trainin Provide maintenance support for any quoted hardware and all proposed software components x _ X X Provide support for users & technical staff during regular business hours x X Provide training upon initial install x X Provide department personnel with training in the use of configuration tools employed in the application X X L ser mama, rrovlcec X onfiguration Requirements Configuration X Software is supported internal) or full/ compatible with third party notifications software X X Existing notification recipient information can be imported into software X Implementation plan will include importing existing contacts. Technical Requirements Server Platform: Windows platform, Windows Server 2008 R2 x Software can be hosted on a virtual environment running Ron Windows Server 2008 R2. X X Database: Oracle 1 ig or SQL Server 2012 X M SQL an open source database managed by Oracle. X VMWare compatible, VMWare 5 x X Ability to operate with new Windows based operating systems as they become available x X Client software runs on Windows 7 Operating System if required x X Software is easily deployed to desktops x Browser -based, no client install required. X Ability for public facing module to operate in following browsers (describe any known version or other limitations) without the use of Flash x X Microsoft Internet Explorer x X Firefox X X Goo le Chrome x X Safari X X Others (define) X ISystern is fault -tolerant x Redundant replicated servers give a hot standby. X System is ODBC compliant X M SQL is ODBC compliant. X System interfaces with SMTP Protocol for email functionality. x X System works in conjunction with ESRI's technology for the storage of all spatial data, ESRI's ArcGIS technology for client side mapping and web based mapping functionality x OneRain will work with Fort Collins' GIS staff to support integration. Many agencies across the US have integrated their ESRI to Contrail. X The Vendor must provide a solution for redundant capabilities x IThe proposed architecture is redundant. X Desktop and web -enabled functionality X X JAbility to include hyperlinks on a page to direct customers to other related sites? X X I I JAbility to have multiple screens open, ability to have more than one session open x EXHIBIT A PROPOSAL ACKNOWLEDGEMENT Consultant hereby acknowledges receipt of the City of Fort Collins Utilities' Request for Proposal and acknowledges that it has read and agrees to be fully bound by all of the terms, conditions and other provisions set forth in the RFP. Additionally, the Consultant hereby makes the following representations to Utilities: a. All of the statements and representations made in this proposal are true to the best of the Consultant's knowledge and belief. b. The Consultant has obtained all necessary authorizations and approvals that will enable the Consultant to commit to the terms provided in this proposal. c. This proposal is a firm and binding offer, for a period of 180 days from the date hereof. d. I further agree that the method of award is acceptable to my company. e. I also agree to complete the proposed Agreements with the City of Fort Collins within 30 days of notice of award. f. If contract is not completed and signed within 30 days, City reserves the right to cancel and award to the next highest rated firm. g. I acknowledge receipt of 1 addenda. Consultant Firm Name: OneRain Incorporated Physical Address: 1531 Skyway Drive, Unit D, Longmont, CO 80504 Remit to Address: 1531 Skyway Drive, Unit D, Longmont, CO 80504 Phone (303) 774-2033 Authorized Agent of Firm Name: Ja gan Signature of Authorized Agent: Primary Contact for Project: James R. Logan Title: Chief Executive Officer Email Address: james.logan@onerain.com Phone: (303) 774-2033 Cell Phone: (303) 324-5505 RFP 8161 FWS Software Page 16 of 31 7 Addendum II — Additional Information 7.1 OneRain's DUNS Number, Certs and Reps Information Corporate Office OneRain Incorporated 1531 Skyway Drive, Unit D Longmont, CO 80504 T: 303-774-2033, (Toll Free) 1-800-758-RAIN (7246) F: 303-774-2037 DUNS Number 012548983 Federal Tax Identification Number (TIN) 84-1187013 CAGE Code 1MKP1 System for Award Management (SAM) Status Registration Status: Active All Certs and Reps are current and available online in SAM (www.sam.gov) Point of Contact Name: Brian Loflin (email: brian.loflinPonerain.com) National Women's Business Enterprise Certification WBENC National Certificate Number 239317 7.2 OneRain Supporting Documentation Additional documentation to support this RFP is included: ■ Contrail® Product Brochures ■ Contrail Training ■ OneRain Levels of Support ■ Contrail Pre -Installation Planning ■ OneRain Corporate Profile OneRain Incorporated I Response to RFP 8161 FWS Software Page 28 ® One Rai Contrail Base Station The Rainfall Company Total Control of Your Hydrometeorological Contrail's adaptive, responsive, and Network Data and Information Distribution contextual design delivers meaningful data ° that's easy to understand and gives users instant access to what they need, when they need it, on any Web -enabled device Contrail Base Station is the visualization tool of choice when managing and controlling access to your hydrologic data is critical. Contrail supports memo the real-time data collection, processing, archiving and dissemination of your hydrometeorological and � 7.n ® ° water resources data in one place. - ®� HIGHLIGHTS ■ On -premises enterprise edition of Contrail collects, validates and makes data available inside your organization ■ Supports an unlimited number of users via a single or multiple web sites ■ You control user access; expose your data as needed ■ Makes available historical and real- time data ■ View real-time and historical gauge - adjusted radar rainfall ■ Access outside information such as USGS, HADS and METAR, as well as neighboring systems OPTIONAL Contrail collects, validates, processes for alarming and notification, displays on maps, graphs and tables, archives, exports and disseminates hydrometeorological data and information, including gauge -adjusted radar rainfall and inundation maps. Encompassed are tools and reports for sensor management, rainfall and stream -related reporting, maintenance, and custom alarm and notification features. OneRain's solutions enable management of and quick access to water -related emergency action plan content, links to any outside resources, webcam video feeds from difficult sites, and many other web -hosted tools. Makes Decision -Critical Support Data Highly Available Contrail is used for operational decision support and emergency operations, post - event analysis, model calibration and planning in flood early warning, dam safety and operations, stormwater and wastewater management. The Contrail application is configurable to suit specific user needs, for multiple user groups and different types of users simultaneously. The user interface is a common web browser —all recent browsers are supported. Real-time data exchange with other applications is also web/http-based, making firewall issues less problematic when exchanging data among agencies. Contrail's smart interface is adaptive and responsive with optimized performance for Web -enabled mobile devices. ■ 24/7 system health monitoring Scalable and Reliable Software Architecture ■ Automated problem notification Running on Linux' and using a MySQL® database engine, a base station can receive ■ Data backup and recovery data from any number of sources, sensors and sensor types, and serve any number of different uses. Most licensed server implementations operate at least two servers that ■ Redundant, replicated databases are geographically separated, with automated real-time replication of the databases ■ Remote troubleshooting and technical between the two providing redundancy. The database is not limited in size and can support grow across multiple servers and disks. Contrail Base Station is the same software that ■ On-line software upgrades runs behind OneRain's reliable enterprise level SaaS solution, Contrail Web. WOterDis rct Multiple Data Exchange Options Multiple formats are available for automated exchange of data with other systems. Contrail's application programming interface (API) can enable many output data formats for use by other systems such as XML, Standard Hydrologic Exchange Format 1- (SHEF), Hydstra, AQUARIUS, ASCII text, Excel. There's also a standard data exchange ■ " "" interface that can be accessed by authorized processes using scripts (e.g., Python, Perl, Java, VB.NET, etc.) on other platforms that wish to retrieve data from or offer data to Contrail. 8 aepuHs m Contrail includes Data Collectors and Data Agents. Data Collectors receive real-time ALERT, ALERT2"% satellite, cellular and TCP/IP data. Data Agents actively retrieve, automatically and periodically, web -resident data sources such as USGS, NWIS, METAR, HADS,TIDES, RWIS and other sites of interest. You Control Who Sees Your Data The database architecture is multi -tenant, which means it can be configured for privacy of data within secured user domains. Each user domain is completely under the control of its own administrator(s), who in turn control user access (username/ password secured, public "guest) and user privileges. Different privileges can be assigned as appropriate to individual users (viewing data only, alarms viewing, alarms creation, maintenance of sensor and site data, web -site content editing, style and colors, fonts, display icons used, etc.). Easily Configurable for Diverse Users An agency operating a base station can configure one Contrail to meet the needs of many and different users. Multiple web sites are easily created and supported, each with its own branding, logos, content, user accounts, maps, alarms and views of data. Any data view can be for authorized users only, presented to the public, or instantiated as one of each. Within each web site, different user privileges control who sees what. For example, perhaps one web site is for tracking wastewater pump station activities and flow meters along with rainfall from multiple sources including gauge -adjusted radar rainfall; another serves dam operators with dam -related Information including inflow, lake levels, gate positions, power production and generator operations, and/or dam safety parameters such as seismic and internal water pressure information; yet another one serves staff who have water quality responsibilities with rainfall, water temperature, dissolved 02, pH, turbidity and other data points. Powerful Data Analysis and Reporting Tools There are numerous reports and reporting tools available of interest to (1) people interested in rainfall and hydrology events (Contrail Insight reports), and (2) people tasked with maintaining and operating real-time monitoring networks (Contrail Insight and also Contrail Inventory). Custom reports can be created either by OneRain or by qualified agency staff. These reports can be run as needed. Contrail Insight - Suite of Integrated Data -Analysis Tools Contrail Insight provides a comprehensive toolset that helps you quickly analyze Contrail data sets, identity and highlight trends and changes, and gain true insight into the performance of your hydromet sensor network. It reduces mountains of data into simple visual displays and presents complex information in easy to analyze visual charts and graphics. Bulk event and time -series exporting. Both static and pan -and -zoom maps are supported for data display. Flood warning implementations may include inundation maps that are user controlled layers on the map display. High -resolution, custom maps clearly define sensors and their status. Point and click drill -down to sensor data. At the site or sensor level, Webcam and web video data can be linked into Contrail by authorized administrative users with bookmarks and tailored supporting content. Real -Time Displays and Post -Event Reports Contrail real-time displays and post -event reports characterize rainfall and its consequences for its users. For example, the Rainfall Summary table shows rain gauge totals in real time for gauges that can be grouped by area/basin. The Water Level Summary table shows water levels in real time with respect to channel bottom, flood alert level, flood level and historic record levels. Rainfall Intensity reports in Contrail Insight can summarize, grouped by basin or region and individually as gauges, the recurrence probability of a rainfall event over different durations (e.g., 5-year 1-hour rainfall, 5-year 24-hour rainfall, etc.). Multigraphs and Hyetographs Multigraphs showing stream flow or levels together with hyetographs from nearby rain gauges can be user -created and bookmarked for repeated use. Any graph in use (can be multiple ones in new windows) will update with new data according to the base station's configured refresh rate (e.g., once a minute). Graphical displays can also show various alarm and historical thresholds. Build Custom Definable Alarms and Delivery Notifications Create user definable rules for alarms to notify via text messages and e-mail. Contrail provides a powerful Boolean equation tool set for identifying conditions of interest. Writing equations in the Alarm rule functions are at your finger-tips. Administrators can create customized rules to trigger an alarm for any sensor or group of sensors within your program. You can have different messages delivered to different people all from the same triggered event —send a short mobile -text message to your on -call staff, send a longer descriptive email to managers, including action plans, send a message to a different department, or send no messages at all; the icons still change color and the Alarm Manager still maintains your event history. Contrail Inventory plus - Centralized Web -based Asset Tracking & Maintenance Knowing the equipment model and all the relevant information associated with a gauge sensor —its geographical map location, configuration, firmware, cables, spare parts, repair and maintenance records, etc., can be invaluable to your field maintenance operations. Contrail Inventory supports mobile data collection for your field service technicians and engineers to track and manage inventory in the field, create Work Orders for maintenance management, and updates back to the centralized database. Contact Us For more information about OneRain's Contrail software, visit onerain.com or call 1-800-758-RAIN (7246) or 303-774-2033. We're happy to arrange a demonstration and show real life examples of Contrail in action. Contrail® Base Station Features • Enterprise software application deployed on your organization's network for Intranet/ Internet browser -based access for both Users and Administrators • Responsive and Adaptive design for optimal use across a wide range of devices such as desktops, laptops, tablets, mobile phones • Unlimited number of Users with role -based privileges and security settings • Onsite Mission Critical Base Station • Local / On -Site Data • Web Content Management • Web Styling and Branding - customizable theme colors and logo • Public website(s) • Highly scalable, Linux*-based server running a MySQL enterprise database • Read Only Server Option • Redundant Server Replication • Multi -Client (first 5 client Web sites) • Administrator Managed Database Backups • Custom Configured Data Services • Custom Defined Cache and Refresh Controls • Reload Metadata - Sync Configuration • Data Collectors / Control: Serial or TCP/IP Connection options, Two-way ALERT (Flasher and Repeater Control), ALERT2'"', StormLink-Cellular, StormLink IP (logging / queuing)„ StormLink Satellite, RWIS / NTCIP, Modbus•, Custom Collector Programming • Data Agents / Data Exchange: DIADvisor'"`, USGS, METAR, HADS, CDEC, LRGS /GOES, NOAATides, RAWS, Rugid (EVENTS), Wonderware, Campbell Scientific, ORBCOMM, GoData, Custom Data Agent, SHEF .A, SHEF .E, Tabular, XML, Hydstra... • Unlimited Sensors • Unlimited Online Data File and Image Management • Advanced Alarm Management: Boolean / Expert Equation toolset • Flexible Alarm Delivery Notifications: Contacts and Groups management for user definable alarms notify via pager, cell phone, and e-mail • Value to text translations - define translation tables to map numeric values to text strings for Contrail data display. Useful for intrusion sensors on doors, float switches, road way sensors • Online Reports: standard built-in reports and custom online reports • Map View: Static and Pan -and -Zoom • Rain Gauge Display • Graphing: real time graphs that keep data on the graphs current with new data. Graphs auto refresh automatically at timed intervals. Easy to use Date Range buttons. Style thresholds with different lines, colors, and markers. • Bookmarks: save links to your favorite graphs or any other Contrail web pages for easy access in the future • File Export / Sensor Data Export (MS Excel / CSV) • Data Editing (with audit trail) • Data Revalidation (with audit trail) • Services: scheduled reports via email, database backups, Data Exchange API • Contrail Inventory plus: Field maintenance operations and inventory management • Contrail Insight: Network Performance, Rainfall Intensity Analysis, Mass Balance Rainfall Analysis, Sensor Network Monitoring,Time Series Export, Event Data Bulk Export • Contrail TDMA Manager. ALERT/ALERT2'" network design and provisioning Copyright ® 2015, CneRain Incorporated. All rights reserved.This document is provided for information purposes only and the contents hereof are subject to change without notice. Rev 2.0 System Requirements • CPU: Dual Core 2.0 GHz • RAM: 2 Gb DDR-2 • Optical Drive: 1 24x IDE CD-ROM • Data Storage: 80 Gb • Operating System: CentOS 6, or Red Hat' Enterprise Linux* (RHEL) 6 • Incoming Network Ports: Some open network ports are required as follows: 80 Web Access to Contrail Web on the server 8080 Contrail Data Exchange interface 8181 Contrail Inventory application 3306 MySQL access 22 Default ssh port (sometimes moved to an off port for security) 60001 - 60010 Reserved for Stormlink IP (logging queuing ALERT data collection) 60011 - 60020 Reserved for ALERT2 (feed from decoder to base station, usually via a serial to IP conversion) 60021 - 60030 Reserved for ALERT data collection (usually via a serial to IF converter) 60031-60040 Reserved 60041 - 60050 Reserved for StormLink cellular data collection 60051 - 60060 Reserved for StormLink Satellite (IDP) collection 60061 - 60070 Reserved for ALERT two-way service • Outgoing Network Ports: Outgoing ports to support data feeds and software updates: 25 SMTP (Simple Mail Transfer Protocol). Required for Contrail to send emails and text messages from alarms. Also used to send reports and notifications of system events. 80 and 8080 Allows data agents to bring in data like USGS, METAR, or FFG IP Outgoing Required for software updates: Redhat (or CentOS), and Access / 443: OneRain (handled by allowing IP outgoing access to specific IP or ranges of IP addresses) • Supported Web Browsers: Microsoft Internet Explorer, Mozilla Firefox, Apple Safari, or Google Chrome (latest versions). • Note., OneRain does not test or certify Controil Bose Stotion to run on specific virtualization solutions. One RaiV The Rainfall Company T: 303-774-2033 Toll Free: 800-758-RAIN (7246) Email: sales@onerain.com www.onerain.com Sin Sersor 5- 15 30 1- 2 3- 6- 12 1 2- 4 M min 1 min hour how hour hour hour day day day HOf"On 1000 '.0.2 ',. Tram- 0 3 0.4 0.6 1.0 12 1.5 1.7 1 9 1.9 2.7 D109 , Gully 0 South M Gregor WaY DIOD Bray, Bayou 0 410 .0.7 1.3 3.7 (2vmdale 5veet Bayou a 420 0.6 2.4 South M In '., Street .....' DI00 Brays &you£% 430 06 5 elia L nk Road r OneRai 1. The Rainfall Company �� 2704�_- fthlands Ranch WTP Yhnd ••ladb mmamum ( i ii _-_i i I I nano mph 528 0:15.00 i 2711 Highlands Ranch WTP Relative humdty J- m.axa Wu 420 10002; 2710 Highlands Ranch WTP Precipitation accumuladon """-"-- -\ 1 aa.a In 30 88.9 12:00.00 j kp[u, - Highlands Ranch WTP Battery voltage V 29 ® 32:0001 �. n Period 5'm10 l $4.0 , 0:3000 2'Year 1$-,nin Nr tamper-, _. � .� _}. �d"f 414 5year 0.7 I.I 30- min 1-hod, Year 1,9 l5 2 2.0 r 3-h0ur nn•axrt.a mph 519 999.0 No Imar 5. D.9 .9 ].5 1.9 5 2 9 4 2.5 6-hour 2 7 1 12-hour n I�2 asps deg 519 999.0 r. No rimer 0-year 50-Veer 1.7 ? 4 2.9 3.5 q 3.8 2da y 13 12:00 00 300-year Ili 1.9 3 7 3.4 9 9.2 5,3 9 5aY q�Y Color 5.3 ,5 'Year I.2 2.1 2.7 9,9 5.3 _ 6.9 b.2 2 7,5 11:59 59 _. 1.9 3.0 3.8 50 5.1 6.6 64 7,8 8.7 3520 25 3.J 93 57 5.9 7.7 8.0 9'0 14 9.8 ]0,5 A"459 Iz:oo ao 1522 ,.- M con lake 77 6.8 9,1 9 9.5 17.2 12.9 a 0:t459 1521 Ma-- lake Relative humtdiry ,q�--+ ]59 I4.8 .._'658 1193 15.1 I6 9 0:1459 x-a�-�ypa 20 7 I 22.3 Contrail° Insight Suite of flexible integrated data -analysis tools that extends the power of Contrail Contrail Insight provides a comprehensive toolset that helps you quickly analyze Contrail data sets, identify and highlight trends and changes, and gain true insight into the performance of your hydromet sensor network. HIGHLIGHTS ■ Reduces mountains of data into a simple, visual display ■ Discover trends in precipitation events with rainfall frequency and distribution information ■ Provides the analyses you need to make better decisions and improve the management of your hydromet network • Presents complex information in easy to analyze visual charts and graphics to Insightful views reveal the essential information you need to manage your sensor network IS Bulk event data exporting IS Time -Series Export Included only with Contrail Base Station and Contrail Server (not available with Contrail Web) Powerful Data Analysis and Reporting Tools Contrail Insight delivers powerful web -based data analysis and reporting tools including hydro -meteorological trends, telemetry system activity and maintenance performance: • Rainfall Intensities: rainfall event analysis reports classify the amounts of accumulated rainfall by recurrance intervals overtime • Mass Balance Rainfall Analysis: plots and compares multiple rain gauges • Sensor Network Monitoring: sensor activity and performance overtime • Bulk Exporting: event data • Time Series Data Export: rainfall and other sensors Identify Patterns, Trends and Extreme Storm Events It's easy to generate sensor -level snapshots of hydro -meteorologic activity over periods of interest to quickly answer questions such as: • How much did it rain this spring? • What were the high and low temperatures at this site last year? • Which stream showed the greatest change in stage last July? :- Executive Summary OneRain appreciates the opportunity to respond to the City of Fort Collins' (City) Request for Proposal for the upgrade of their flood warning system (FWS) software. With a relationship that spans more than 15 years as a primary participant in the original Fort Collins ALERT network design, implementation and maintenance, and having provided and supported the City's legacy FWS base station software, DIADvisorTM—a solution that has been operating reliably and successfully for many years—OneRain is a company uniquely prepared to comprehend and satisfy the City's needs as described in this RFP. OUR UNDERSTANDING OF YOUR GOALS The City of Fort Collins has long used OneRain's DIADvisorTM software to collect and disseminate real- time data from its own ALERT gauge network to manage real-time hydrometeorological data collection, processing, monitoring, and dissemination for the purpose of advanced flood -threat detection and decision support. The Agency is currently relying on a combination of legacy applications and data transfer methods to support their current operations. Over the years, technology and the City's operation's demands have changed, making these mission -critical systems increasingly difficult to maintain and stretching your legacy systems beyond their functional limits. The City of Fort Collins' Stormwater Department, in partnership with the Information Technology Department, seeks to upgrade its existing data collection system, DIADvisorTM, with a more robust, highly available and modern Flood Warning Data Management Software program. It is highly important to the City that it maintains its current high performance standard. OUR PROPOSED SOLUTION The solution we are proposing today is Contrail®, our next generation software platform that was first introduced in 2005 as OneRain's modern successor to DIADvisor (now almost 20 years mature). Contrail is designed to meet the demands of a mission -critical flood early warning system and will enable the City's Stormwater and Emergency Response personnel meet their goals and carry out their mission with a heightened effectiveness. The software is capable of meeting the RFP requirements to collect, store, analyze and disseminate data from the City's gauge network monitoring system and other regional sources and provides the decision -support tools that help those tasked with assessing flood risk and protecting the lives and property of its citizens and communities. CONTRAIL© - AN ENTERPRISE SOLUTION FOR MISSION -CRITICAL ENVIRONMENTS OneRain's Contrail software platform is designed to keep pace with the ever -changing technologies and evolving requirements of our clients and is the leading innovative software in the industry. The Flood Warning Data Management Software is essential to all aspects of the City of Fort Collins' flood early warning program. OneRain's proposed solution, Contrail, will meet the expectations of the City and will: Allow the City of Fort Collins' personnel to continue to manage the FWS gauge report data and disseminate emergency notifications to other public outlets for the purpose of protecting community life/safety. Enable the City to maintain its current high performance standard well into the future, vital to the mission -critical nature of flood warning data used by emergency management, responders and the public, thereby maintaining the protection the system's advanced early detection, measurement and warning capability provides to its citizens. Reliably serve the City's needs now, and the City's evolving needs well into the future. AVAILABILTI'Y FOR INTERVIEW/DEMONSTRATION Our response to your current request for proposal addresses all requirements in your scope of services. We sincerely appreciate the opportunity to present our solution in support of the City of Fort Collin's requirements and would welcome the opportunity demonstrate our software and our abilities on November 12 or 13, 2015. OneRain Incorporated I Response to RFP 8161 FWS Software Page 2 76 f_ss c. gg g p fQ p S. E$ a >o@ r n'_ u 11.2 y [ O= .2 `mN E r E w m m 2 = �C J N O W 01 H W Ot O'c O O` .� •I� } (1 (/ fI I\ 1 I I ? y g V pt 3 3 o T 5 f o° Y a C C L N y 0 `I I� + L W W y° W ' o N p N 0 OI N n C $ c«0�a J Neu $$ qb'yy Eo�«�a tL L >`cv a W O •N u a�oLAA m O pi 75= >O! Y3p CJoT3 ami3 O�0m3u N0 n m ) d"O p 01 C ZL mOm cw `p=�oLc C .... n B u C C N d W m X= u Lu �• s .�E m nv E Q w a �`v 41 c O 01 a N C e e n $ M pi to (�0 O> 722a� �IIn111111�111 j1111^I�111g�-11a Eq� V or = 1111-IIill2 11g q - v •m E ° a=�v IIIII11111�11I$ rgo2 w a J Uo L ;� N 1111-Illll��lld N r C w=�Y N�� 111111111=dlll� Jim Tyr e E '8 ��Q _� o a� t s � vLC� a ��w 1111 V- IF T mYT a- ai`� iO Ec- t 3 0 o �tm gbt aIJ1 3 v u SnR�a$"sn� �- a c E o 'C p E �b E a m v mJ, -' a L TZ CL >w o o a ? wf w mom F C = C 3 > N L� m � L01666�QS L y_ a � q V T ++ f. IE LF N T r O N Ci9L 3k p ei p g ie �R a y O .�' it y g fi O d,p m�y m a=i A9 a:u `m c t b¢°•g3•6� _38fi� ,,, ai C ,C O G LL> = O V N T V e N E O O c E 0 c t O V Plan Predictive Maintenance `O9' Contrail Insight uses data analysis to track system performance and plan predictive maintenance. By monitoring gauge and telemetry performance, maintenance planners are able to analyze trends in performance and provide awareness of 21ll10i25.10.a�7n �°�P��°H° COMPLETE cMae^ ;R:.- $(1110?.161 ♦ Swor P<r'vn°rtt COMhFTE GneRen irregularities before they affect operations. S S 09 Seemr Pefv^ume COMPLETE OrcPein Preventive maintenance is a common activity for remote measurement stations. ,nlr SRp9tN G4 Reu luntlees Ey View COMPLETE O^RReln =12-23M,22.m Ev—R' T u•ie D°u Ey Yrtw M COMPLETE o Le Frequency based maintenance helps us to know that things are working as designed. 2012-12-25 MIA 11 Smsw Pef°frtwMe CIXIPIETE CneR°n - Unfortunately, preventive maintenance doesn't catch all problems and breakdown maintenance becomes a necessity. Breakdown maintenance can be time consuming, costly and causes increased risk while the site is down. Effective predictive maintenance uses many techniques, some which are field activities and some based solely on telemetered data. Contrail Base Station keeps a history of sensor data available to conduct performance analyses that support predictive maintenance activities. Contrail Insight uses three different approaches to analyze environmental monitoring data, including hydro -meteorological trends, telemetry system activity and maintenance performance. These analyses generate graphs and reports on data source availability and data trends that enable you either to have confidence in your system and maintenance provider, or to know that neither the system nor provider are performing as they should. Contrail Insight helps to detect both common and rare failure modes before problems occur. By distilling the data into manageable reports and presenting the critical metrics of a system's health, Contrail Insight improves performance, increases system confidence and reduces costs. One Rai� The Rainfall Company �- Copyright 0 2014, OneRain Incorporated. All rights reserved. -This document is provided for information purposes only and the T: 303-774-2033 contents hereofare subject to change without notice. Rev 1.2 Toll Free: 800-758-RAIN (7246) Email: sales@onerain.com ' www.onerain.com �, One.Rai The Rainfall Company �� Contrail° Inventoryp/us Centralized Web -based Asset Tracking and Maintenance Management Tool for Real-time Monitoring Networks Contrail Inventory plus helps you manage, maintain, and keep track of your gauge sensor network equipment via your desktop or mobile device from anywhere you have an Internet connection. HIGHLIGHTS • Manage inventory and maintenance in one place • Multi-user, password protected access • Centralized updates - everyone works off the same data • Detailed visibility of inventory adjustments and life cycle history • Store site and hardware images for easy identification • Add support documentation so it's available when you need it • Powerful search options to help you find things easily • Useful built-in reports and audit tracking • Export data options Supports All Field Maintenance Operations in One Place Contrail Inventory plus is ideal for people tasked with maintaining and operating real- time monitoring networks. It functions as either a web -based desktop application, or can be accessed via your smartphone without any special client software to install. Equipment Tracking Knowing all the relevant information associated IJ Items with a gauge sensor —its location (geo-mapping), configuration, firmware, cables, spare parts, repair and Ell Manufacturers maintenance records, etc. —can be invaluable to your ?= Categories field maintenance operations. Contrail Inventory plus supports mobile information collection for your field 0: Models service technicians and engineers to track and manage V Tags inventory in the field, and updates back to the centralized 06 Reports database. :iModels9D t Add model e, Category Part Number Manufacturer 100M Bubbler Tubing Bubbler Senmr 9942010095 Hach Environmental -- --- 1 OW Solar Pane: Solar Panel sx 305V BP Solar 10W Solar Panel Solar Panel BSP-1012-L Power Up 12 V 35 arit1 hr Osep dyde battery Ma'y WKDC1235J Warier 12v 1aAh ADM Ban ry WKAl2-IBNB Welker 20:1 Voltage D'Mder Telemetry CVD20 Campbell Sci•ntlao, In.. 20W Soler Palrel - - - Solar Panel Sx 320 M SP Solar Equipment Maintenance Management A Maintenance Contrail Inventory plus links your inventory management and maintenance together. The Maintenance Management module with Contrail Inventory plus handles ® Dashboard the creation of Work Orders, Tasks, and scheduling of routine, preventative and b WorkOrders emergency maintenance activities of any inventory item in the system, giving you the ability to manage all of your maintenance operations in one place. p WorkBooks {+± !� Worksheets WorkSheets, Q Workorders Completed tasks Settings - Q Workorder Priorities so • ryl��.�oeg.,1 OEdit WorkOrderType Preventive Maintenance Web access via Desktop or Mobile: Easy to use interface provides flexible office or remote access with secure login/password protection. Add, manage and track all inventory located at each field site, including manufacturer, part numbers, serial numbers, and software/firmware versions loaded, cable lengths, etc Supports field maintenance efforts to know exact field configurations prior to visiting sites. File/Document Uploads (.doc, .xis, and .pdf): Add Data Sheets, User Manuals models, Permits and Maintenance Records, RMA and Calibration Reports. Image/Photo Upload: Images can be added to manufacturers, models, site locations, and inventory assets. Q Locations Reports w w�•rrn .+•�rvb�nnxm o-.�xaya< w,wrtmvN rM:m..i a•nn o,•iii • Site Location: Integrated postal addressing and geo-location mapping information to a location. Add Custom Notes: Notes can be added to manufacturers, models, locations, and inventory assets.The notes field stores free -form text and HTML and automatically generates active links for URL text. OR Barcodes: A unique Quick Response (QR) code is automatically generated by the Inventory Manager when a new Location or Inventory item is added. OR codes are matrix barcodes that can be easily scanned with a mobile device (phone, tablet, etc.) camera using a third party application. Field service technicians equipped with mobile devices can scan OR code labels applied to gauge sites and equipment to quickly retrieve and display the item's Inventory record. Click and Print Label Creation: Print QR code for the Inventory item, Location, or all Inventory items at a Location on standard label templates. Powerful Search tool enables easy lookup of serial numbers, locations, or any other database attribute. Built-in Reports: Choose from a comprehensive selection of standard report templates. Data Export: Compatibility with Microsoft Excel Formats. Lifecycle History with Inventory Audits: Inventory audits provide a way to access the history of a specific piece of equipment from purchase, through all maintenance, until final disposition. .+.a,.a.rwa.r.aa wn .r„a, m. .ro. o.,., e•.d�.= a Ace.e le„a s. aeteVe.J— axew Loaeeore _ ....i AV M Contact Us For more information about OneRain's Contrail products, visit onerain.com or call 1-800-758-RAIN (7246) or 303-774-2033. Is -- Contrail° Inventory plus User Experience Contrail Inventory's web -based adaptive and responsive design is compatible with ME N N E N the widest range of devices, desktop PCs, laptops, tablets and smartphones. We've tried to walk in your shoes as we redesigned Contrail Inventory's accessibility to create the best experience possible to match up to your needs. Now, whether i..__ you're in the field, or at your desktop, you'll be able to accomplish virtually all your Contrail Inventory management tasks (review, edit, add, upload photos, etc.) anywhere at any time. Users can get to the information that's important to them fast with easy to understand content priority, workflow and viewpoints: "Everything you need to • Easy to navigate whether on smartphone, y tablet and desktop devices manage inventory and No special mobile app. required maintenance is at • Adaptive between mobile and desktop for your fingertips. content, features, viewpoints Responsive design fluidly changes and responds to fit any screen or device size One Raia, The Rainfall Company �� Copyright m 2014, OneRain Incorporated. All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change T: 303 774-2033 '• without notice. Rev 1.4 Toll Free: 800-758-RAIN (7246) Email: sales@onerain.comrL ' www.onerain.com L• t neRaia The Rainfall Company Contrail° Implementations that ensure system resiliency, high availability and real-time monitoring to support your critical mission OneRain's Contrail is an enterprise level software solution designed to support your mission -critical responsibilities in early flood warning, emergency management, dam safety, reservoir and hydropower operations and stormwater management. Are you ready for those challenging situations? When faced with challenging situations such as major rainstorm or flood events, Contrail must be able to maintain its availablity and provide real-time information to the right people when and where it is needed. To ensure the highest level of availability and optimized performance, OneRain's Contrail application can be deployed with redundant configurations and a core network architecture that maintains at least two continuously replicated databases. Flexible configurations to achieve required reliability A resilient system provides geographic redundancy, eliminates a potential single point of failure, and will continue to provide service even if there is a system failure at one end —the data feeds and essential agency operations can continue uninterrupted. OneRain understands that different agencies have different demands. Our products and solutions are designed to meet the day-to-day operations as well being a critical resource when the situation demands. ................................................................... •SITE/SENSOR CONTRAIL BASE STATION CONTRAIL BASE STATION SITE/SENSOR DATA RECEIVE DATA RECEIVE ANTENNA (PRIMARY) (SECONDARY) ANTENNA I RECEIVER/ REPLICATION -".�, RECEIVER/ DECODER "� * I " °1°"'°' DECODER INTR0.NET I!i ill INTRANET NETWORI{ NETWORK SERIALTO ® "' ® SERIALTO TCP/IP TCP/IP DATAEXCHANGEj� ......................................................................I................................... Y Example of a locally installed 2-server Contrail Base Station Wrimplementation. WEB &MOBILE l" The secondary Contrail Base Station provides public URL web M _ access and specific user level privilege views of the data. o Although both servers are hosted by your agency's IN M facilities, they should be in geogrophicollydisparate o locations for the purpose of survivability of local system failures. USERS & ADMIN : .................... ,. • SITE/SENSOR n DATA RECEIVE ANTENNA / CONTRAIL BASE STATION (PRIMARY) RECEIVER/ DECODER eiwma�enii INTRANET . NETVII _ SERIALTO TCP/IP REPLICATION ............ a...........................J., .A............. REDUNDANT SERIAL DATA CONTRAIL SERVER (SECONDARY) SECURE DATA CENTER Solutions for small to large scale... Several configuration architectures are possible. Talk to us today to find out what best meets the needs of your organization. OneRain's professional services can help you achieve your goals by building solutions that effectively strengthen your monitoring and analysis capabilities and align technology with process to support data sharing, forecasting, early warning, disaster mitigation, and emergency response. R Copyright * 2014, C)neRain Incorporated. All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. Rev 1.1 Example of a 2-server Contrail Base Station implementation. The primary Contrail Base Station is installed locally with a secondary base station, Contrail Server, hosted by OneRain. The secondary Contrail Server provides public URL web access and specific user level privilege views of the data. Chances of bad things happening to your Agency and OneRain receive and dissemination activities simultaneously are slim, so reliability and survivability of local problems are WEB & MOBILE very good. .Li0 USERS & ADMIN One Ra1U The Rainfall Company T. 303-774-2033 •; Toll Free: 800-758-RAIN (7246) Email: sales@onerain.com www,onerain.com A Frame Swm y One.Rai The Rainfall Company �� ii One €Zaill Th; ftainJell ...�m��an� _ TDMAManager i� Agencies 9 Capacity n Networks z .u— t00 %bts ac%wntinp br SiJ00 � �5p Ox,� .III Frequencies AFrame Summary - o IF Stations .1 Supports multi -frequency, multi -repeater, multi -base station networks Contrail° ALERT2T'TDMA ManagerT1 Visualize and design your network, tracking capacity, available capacity, and data latency HIGHLIGHTS Time Division Multiple Access (TDMA) is a frequency use protocol in which each w transmitter is assigned specific times to transmit so that two transmitters on the ■ Manage and design one more same frequency do not transmit at the same time, and eliminates data loss due to networks in a controlled workspace more than one transmitter on a frequency talking at the same time. ALERT2 supports ■ Aids in the proactive planning of your both the ALOHA and TDMA transmission protocols, but preferably uses the TDMA network capacity and demands protocol to reduce or eliminate data loss. ■ QA/QC verification optimizes Why use Contrail ALERT2 TDMA Manager? transmission capacity Contrail ALERT2 TDMA Manager provides multi-user shared access via web interface • Real-time tracking of live network and and enables information sharing that reduces potential for conflicts or mistakes. It ability to create "what if" alternative gives a complete view of your infrastructure in one place. Multiple agencies can share network designs access. ■ Visibility of other agency's networks Contrail ALERT2 TDMA Manager features Capacity Planning and QA/QC Verification — ensuring the optimization of transmission capacity across all parts of the network. ■ Reduces potential for conflicts or It provides a controlled workspace so that users for an agency can edit/maintain mistakes agency TDMA designs, and can see, but cannot edit other agency TDMA designs. ■ Import and export network designs ALERT2 T'TDMA Terminology GENERALTERMS DESCRIPTION ALOHA is a frequency use protocol in which transmitters transmit at any rill Frequencies time when they have something to say, and can potentially collide with other transmissions and lose data.The probability of success of ALOHA ALOHA transmissions can be calculated, assuming that all transmissions are random. ALERT uses the ALOHA transmission protocol. ALERT2 can use the ALOHA transmission protocol, but preferably uses the TDMA protocol to ALERT Gauge Frequency reduce or eliminate data loss. 169,50000 MHz n t A specific radio frequency (RF) is a resource used by ALERT and ALERT2 for Frequency both transmission and receive of signal. Frequency is usually defined in ALERT Repeater Frequency terms of MHz and is divided into 0.0250 MHz ranges. ea" "rty1°"`E6T".ease An ALERT frequency is shared by many transmitters which transmit ALOHA ALERT2 Gauge Frequency ALERT Frequency messages, and have potential for collisions and data loss. 169.52500 MW Transmit heq for N.Etir2 pauper An ALERT2 frequency used forTDMA is defined by a frame length, block T" ALEU length, and slot lengths, that is divided into TDMA slots, which are then Frequency LERT Concentrated Repeater Frequency Frequency allocated to transmitters on the frequency. 17030000 MHz Transma heq tgrf RT2 repeaters A network is a combination of frequencies, receivers, transmitters, H Network transceivers used for ALERT and/or ALERT2. A network serves one or more agencies. Receiver Base Station, receives on one or more radio frequencies. Station Transmitter Transmits on a single radio frequency. Is comprised of both a receiver and a transmitter. A transceiver receives on Description ALERT2 Repeater one or more radio frequencies and transmits on a single radio frequency. station Type +T+Tran—ver Transceiver They typically are repeaters that listen to data content on their receiver, and then retransmit that content on their transmitter. Protocol AALERT Address Frame Length is used to define the transmission repeat for transmitters on 6503 a frequency. For example, a transmitter on a 20 second frame would have Latitude 398700000 Frame Length an assigned TDMA slot with a predefined offset from the top of the frame, Longitude 05.2970000 and be able to transmit every 20 seconds. Antenna height 15.00n The block size is the minimum time interval possible for an ALERT2 Block Length transmission. In the ALERT2 specification, it is 250 milliseconds (ms), and is the smallest time that can be used for subdividing a frequency's frame into individual TDMA offsets and slots. It is the allocated division of time for a transmitter within a TDMA plan for a Slot Length frequency. This is one or more whole units of block length. The TDMA plans we currently have use 500 milliseconds as the standard slot length, which with ALERT2 allows up to 75 bytes of information to be transmitted. ALERT2" is o trademark of the National Hydrologic Warning Council (NHWQ Copyright © 2015, OneRain Incorporated. All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. Rev 1.0 OneRaiv The Rainfall Company T: 303-774-2033 Toll Free: 800-758-RAIN (7246) Email: sales@onerain.com www.onerain.com 114W.: OneRai The Rainfall Company �� Contrail° Training Program Contrail is a dynamic product with many features and capabilities. Our on -site training for Contrail Base Station and Contrail Server ensures you gain the maximum value from your OneRain software and products and enables you to confidently use the product in its entirety. OneRain provides in- depth end -user, system administrator and server administrator training with your own system and data. Contrail Inventory plus training is provided via live Webinar at an appropriate time after core system training. Users also have access to ongoing scheduled live web -based training sessions. Contrail System Administration Detailed training on server access and usage. Full description and details of the architecture of the system, how all the components interface, and details of each component. Troubleshooting and problem solving processes are covered. This advanced training is designed for those responsible for maintaining the servers, applying software upgrades and performing system failovers... Contrail Administrator Interface Contrail Administrator Interface: Setting up users and authorizing privilege levels, establishing sites and sensors, creating validation formulas, setting thresholds and creating alarm rules and notifications, acknowledging and clearing alarms, accessing alarm logs, accessing standard maintenance reports. How to modify and customize web themes, adding content and links... Part III Contrail User Explores all the end user features of Contrail. Understand the navigation of user interface, menu options, viewing data with map view and site lists; drilling down to sensor data. Learn the use of single and multiple graphs. How to retrieve historical data and export data. Overview of detailed help system... EXCEPTIONS TO THE AGREEMENT SOFrwARE LICENSE AND MAINTENANCE AGREEMENTS We acknowledge and have reviewed the City's proposed Agreements attached to this RFP 8161 Flood Warning Data Management Software (Exhibit B Software License Agreement and Exhibit C Software Maintenance Agreement). OneRain's Standard Software Access License Agreement and Standard Software Maintenance Agreement cover the products and services and OneRain's warranty obligations with respect to the software you license (or purchase) from OneRain, unless and until we enter into a new mutually acceptable agreement. We would be glad to discuss and negotiate legal terms and conditions if it is the City's desire to use our software and services. We noted in the City's proposed Software License Agreement (Exhibit B item 1o) requires that the "...Company agrees to provide the source code to the Information Services Director of the City." OneRain does not agree to this but instead offers the option of a software escrow agreement at an annual fee to the City. The software source code would be deposited with a third parry escrow firm, and would be updated approximately twice a year, as new releases of Contrail software are made available to our clients. Under the software escrow agreement, the source code would only be released to the City under certain mutually agreeable defined conditions. OUR COMMITMENT The team here at OneRain is highly focused on how to serve our clients and we are confident that we offer you what no other firm can —the expertise and experience of our end -to -end hydrological monitoring best practices, combined with the functionality of our advanced software solutions that empower our clients to perform their critical missions. Our ultimate objective is the success of your program. We have worked with the City of Fort Collins and with agencies like yours for several decades and in doing so established an exceptionally successful track record and strong ongoing relationships. We still serve the customers we had when we started in 1992. We are excited about this project, and confident we will meet the letter and spirit of your expectations with our proposal. It is OneRain's mission to provide the systems and information our customers need to make good decisions. OneRain Incorporated I Response to RFP 8161 FWS Software Page 3 ONGOING TRAINING AND EVENTS In addition to on -site training, OneRain offers a variety of online training sessions for our software and solutions. Web -based training is a great way to learn more about Contrail, whether you choose our monthly complimentary Training Series for Contrail Administrators, or Customized Training sessions that are exclusively tailored for your agency or organization. Our on-line instructional sessions are great for: • New customer user training • Learning about new features and enhancements • Refresher sessions for your employees • Basic training for new employees • Administration training Complimentary online live training series for Contrail Administrators OneRain offers live web -based training sessions to our valued customers! Each live session is aimed at new or experienced Contrail Administrators who want to refresh or expand their knowledge of the software. These sessions also provide the opportunity to learn about any recent updates and enhancements. Note that the training schedule may change from time to time due to holidays or other conflicts. Check our website to learn more about upcoming webinar dates and to register. Customized Training Do you need training tailored to your needs? For more in-depth training with your own system and data, we can come to you! Contact us to arrange customized training for groups of 4 or more at your site. OneRai 1 The Rainfall Company T: 303-774-2033 Toll Free: 800-758-RAIN (7246) r� Email: sales@onerain.com Copyright 02014, OneRain Incorporated. All www.onerain.com }. rights reserved.This document is provided G for information purposes only and the contents hereof are subject to change without notice. Rev 1.2 ne Ral a,,,, The Rainfall Company Software Maintenance and Technical Support OneRain's software maintenance and technical support is designed to provide you with latest software enhancements and technical support for your product licenses. We offer two levels of software maintenance and technical support to meet our clients' needs —Standard and Extended 24x7. The first year of Standard support is included with your new product licenses. As an additional option, we offer Extended 24x7 that includes all the benefits of Standard support plus around -the clock critical technical support. ■ Complete support protection ■ Access to new features, updates, enhancements and fixes Unlimited telephone and email support during normal business hours M-F with standard maintenance Access to ongoing scheduled live web -based training sessions Most cost-effective way to ensure you're always up-to-date Protects your investment: Know that your systems are current Predictable budget planning Standard Software Maintenance The initial purchase of a OneRain Software License includes the first year of standard technical support. Thereafter, on each annual anniversary, Licensees may purchase standard technical support at an annual price equaling 25% of the current software license fee. It includes both product upgrades and technical support as follows: • Subscription and Support: Under our Standard Software Maintenance agreement, OneRain provides continuing subscription to and support of the most current release of the software during the annual term. Subscription and support include correcting material or substantial defects in the software or deviations from the published software specifications. • Telephone Consultation: Standard Software Maintenance and Technical support also includes reasonable telephone consultation for your organization on the use of the software during OneRain's normal business hours (8 a.m. to 5 p.m. Mountain Time). OneRain strives to respond to normal support calls (or emails received) not later than one business day after receipt of the Licensee contact. Customer outages are treated with the highest priority. OneRain has no obligation to provide on -site support or remote administration of Licensee systems. Extended 24x7 Software Maintenance If around -the -clock support is required to meet your critical mission needs, OneRain offers coverage and assistance beyond our normal support hours, as well as Remote Diagnostic Support, Automated Monitoring and Technical Support for your data collection system. Licensees may elect to purchase Extended 24x7 Technical Support (I2-monthterm) at the prevailing list price at any time, provided that your subscription to OneRain's Standard Software Maintenance Agreement is valid. In addition to the Standard Technical Support described earlier, OneRain's extended level of service includes the following: • 24x7 Telephone Consultation. Our Extended 24x7 Technical Support provides phone support 24 hours a day, seven days a week. OneRain provides an Extended Customer Support HOTLINE telephone number to call requesting service of the covered product. The Extended Customer Support HOTLINE operates outside of normal business hours and during statutory holidays. CO214H • Remote Diagnostic Support*. OneRain maintains a staff of support personnel with two people on call at any given time. Upon any interruption of processing detected by the monitoring, OneRain sends out alarms to both the client's designated support contact and OneRain's on call staff. OneRain's staff attempt to remotely log into the client's base station(s) and begin the process of diagnosing and trying to fix the problem. We make every effort to get you operational as soon as possible. If the problem cannot be fixed remotely, OneRain works with the customer's designated support contact to solve the problem. • Automated Monitoring*. OneRain sets up automated monitoring of the Licensee base station. For clients that use Contrail° Base Station, OneRain uses the alarm "Extended support provides pp p capabilities built into the servers to monitor their health. OneRain will monitor data feeds, check operating system processes and scan Licensee's system network additional peace of mind for for failures or irregularities, and take remedial action. For clients using DIADvisor"", your organization 's critical OneRain monitors the DIADvisor backup feed for receipt of new data within a operations with day and night, specified time frame, and an alarm is triggered should that feed stop sending data to OneRain's enterprise. To enable automated monitoring of DIADvisor the Licensee weekend and holiday round -the- must use OneRain's free backup option. clock technical assistance." *Remote Diagnostic Support and Automated Monitoring requires all OneRain on -call staff to have remote access to the client's base station. Copyright m 2014, CneRain Incorporated. All rights reserved. This document is provided for information purposes only and the OneRaiV The Rainfall Company T:303-774-2033 ❑ 71 Toll Free: 800-758-RAIN (7246) Email: sales@onerain.com www.onerain.com i OneRaivThe Rainfall Company'- Contrail° Base Station Pre -Installation Planning Software Version 6.0.X CORPORATE HEADQUARTERS OneRain Incorporated 1531 Skyway Drive, Unit D Longmont, CO 80504-6270 Revision: 2.2 THE SPECIFICATIONS AND INFORMATION REGARDING THE PRODUCTS IN THIS DOCUMENT ARE SUBJECT TO CHANGE WITHOUT NOTICE. ALL STATEMENTS, INFORMATION, AND RECOMMENDATIONS IN THIS DOCUMENT ARE BELIEVED TO BE ACCURATE BUT ARE PRESENTED WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED. USERS MUST TAKE FULL RESPONSIBILITY FOR THEIR APPLICATION OF ANY PRODUCTS. THE SOFTWARE LICENSE AND LIMITED WARRANTY FOR THE CONTRAIL BASE STATION PRODUCT ARE SET FORTH IN THE INFORMATION PACKET THAT SHIPPED WITH THE PRODUCT AND ARE INCORPORATED HEREIN BY THIS REFERENCE. IF YOU ARE UNABLE TO LOCATE THE SOFTWARE LICENSE OR LIMITED WARRANTY, CONTACT ONERAIN INCORPORATED FOR A COPY. Contents Introduction....................................................................................................................................4 Customer Pre -Installation Checklist.....................................................................................................4 Planning your installation.............................................................................................................4 Time..........................................................................................................................................................4 Pre -Installation Plan................................................................................................................................4 Hardware.................................................................................................................................................. 5 Contrail Base Station Training...............................................................................................................5 AdditionalConsiderations.....................................................................................................................5 Contrail® Base Station Platform Requirements.........................................................................7 Minimum Server Requirements............................................................................................................7 Minimum Network Requirements........................................................................................................7 IncomingNetwork Ports........................................................................................................................7 OutgoingNetwork Ports........................................................................................................................8 SupportedWeb Browsers...................................................................................................................... 8 Government Policy on Hypertext Transfer Protocol Secure — HTTPS-Only Standard ............9 Technical Assistance........................................................................................ Software Implementation Process for Virtualized Hardware ................ Network Setup for Contrail Base Station on Enterprise Linux 6.X........ Connect and start the server.......................................................................... To view current server network settings using ifconfig .............................. Edit the server network settings using the command line ......................... Customer Pre -Installation Checklist........................................................ .............................. 9 ..........................10 .....12 .....................................12 .....................................12 .....................................12 ...................................14 Technical Assistance and Support..............................................................................................16 Questions?.............................................................................................................................................16 MoreInformation.........................................................................................................................17 Introduction This document discusses pre -installation considerations and provides guidelines to ensure that your installation of Contrail® Base Station proceeds smoothly. It provides an overview of server hardware, network and operating system requirements and some additional information to prepare for installation. Before you install Contrail Base Station, we urge you to consider the time required to complete the process. Although the installation process itself does not take long, making sure that your organization is ready to install the software and associated hardware are keys to a successful installation and system deployment. This document is intended to provide a generic guideline as each organization has many variables, including the number of users, network specifications, size of system, etc. Customer Pre -Installation Checklist There are certain steps that you must take before installation of Contrail Base Station can take place. We recommend that you read this document in its entirety in order to fully understand the pre -installation requirements. A checklist on page 14 of this document will assist you in coordinating and planning the installation tasks. Planning your installation The four key areas of consideration to smooth the process of installation are: ✓ Time ✓ Pre -Installation Plan ✓ Hardware ✓ Services/Training Time Following receipt of a purchase order/contract, please allow four to six weeks prior to doing an onsite installation to allow for pre -installation planning, reviewing hardware and network requirements, and lead-time for any hardware purchases. Pre -Installation Plan Involve and get a commitment from all appropriate personnel for your installation plan; create a cross - functional installation team (IT/network administrators, end users, management, etc.) with a designated lead. The following should be considered as part of your pre -installation plan. (For reference, detailed System Requirements are provided later in this document). ✓ Understand the Contrail Base Station system and server requirements. ✓ You will need ports open for services including remote connectivity. ✓ Set up Wide Area Network (WAN) address and Network Address Translator (NAT) to internal server Local Area Network (LAN) address. ✓ Set up (1) one domain name registered to WAN address for Contrail and one (1) for Contrail Inventory plus. Three (3) additional sub -domains will be required if Pan and Zoom map tiles are hosted locally on your server. ✓ If you plan to deploy a public website, set up network URL addresses and establish firewall rules to allow external access. PRE -INSTALLATION PLANNING PAGE 4 OF 17 ✓ Consider application groups and users access and privilege levels. ✓ Are you planning a two -server architecture? Consider network connectivity, firewall access, etc. Identify which will be the primary server and which will be the secondary. Determine failover process. ✓ If you plan to run the installation in a secured data center, please contact OneRain's Contrail Support to establish network use for system support, software updates and maintenance. Network Connectivity & Configuration ✓ Location of network drops for Contrail Base Station server(s). ✓ Network drop for IP/ Serial Port device(s) for serial -to -network connectivity. Hardware ✓ Contrail Base Station operates on a LinuxO-based server architecture. ✓ Allow a 2- to 3- week lead time + shipping time to order server. ✓ IP/Serial Port(s): Digi PortServer® TS devices (minimum 2- or 4-port recommended).* ✓ Custom cables or adapters necessary to split existing serial data feed.* A Custom Serial-to-IP Connection Kit is available to purchase from OneRain. The device will be pre- programmed and pre -configured by OneRain for your specific site requirements for ease of installation and setup. Contrail Base Station Training Contrail Base Station is a dynamic product with many features. Our on -site training ensures you gain the maximum value from your OneRain software and products and enables you to confidently utilize the product in its entirety. OneRain provides in-depth end -user, system administrator and server administrator training with your own system and data. Training includes: ✓ System Administration Training: Detailed training on server access and usage. Full description and details of the architecture of the system, how all the components interface and details of each component. Troubleshooting and problem solving processes are covered. This advanced training is designed for those responsible for maintaining the servers, applying software upgrades and performing system failovers. ✓ Contrail Administrator Interface: Setting up users and authorizing privilege levels, establishing sites and sensors, creating validation formulas, setting thresholds and creating alarm rules and notifications, acknowledging and clearing alarms, accessing alarm logs, accessing standard maintenance reports, modifying themes, adding content and links. ✓ Contrail User Training: Detailed user interface, viewing data with map view and site lists; drilling down to sensor data. Use of single and multiple graphs. Retrieving historical data and exporting data. Overview of detailed help system. Additional Considerations ✓ Maps. Calculate the extents of your map regions in decimal degrees. Contrail can host multiple map regions, offering regional and zoomed in views. PRE -INSTALLATION PLANNING PAGE 5 OF 17 ✓ Site and Sensor Definitions (see http:Hcontrail.onerain.com/help/import.xls to download template for minimum requirements for site and sensor creation). Not required if upgrading from DIADvisorTM. ✓ Identify site groupings such as watersheds, water basins, fire borders, or other logical groups or views. ✓ Collect additional information to enhance the Site and Sensor metadata. Site images, maintenance or public notes about the installations, sensor thresholds, and compile historic events such as maximum values during storms. ✓ Alarms and Notifications. Consider types of notifications and alarm evaluations to be used in your real- time monitoring. Contrail can trigger alarms for any sensor or group of sensors within your program. Who will receive the notifications? Different messages can be delivered to different people all from the same triggered event. ✓ Determine default validation criteria for Sensor Types. The default validation will be used as the baseline for new sensors. ✓ Historical data transfer. Catalog and validate existing datasets. ✓ Contrail Inventory data preload and import. If you have your data in an existing spreadsheet, transfer or format it to Contrail's import template (see http:Hinventory.onerain.r)et/help/import.xls to download template for inventory data). ✓ Theming Contrail's user environment to match your organization's look and feel. Choose an existing Web site as the template for the theme, or collect logo images, color swatches to be used. PRE -INSTALLATION PLANNING PAGE 6 OF 17 Contrail° Base Station Platform Requirements We typically install our software on Dell® PowerEdge Servers. Choose a rack or tower solution, whichever form factor best suits your server environment. The operating system we support is 64-bit Red Hat° Enterprise Linux° 6 or CentOS 6 (CentOS 6 is the free open source version of Red Hat 6 and is what OneRain utilizes). Operating System installation support is covered in OneRain's setup pricing. During setup the "Minimal" software group install is selected. One (1) Contrail Base Station software License is required per server. Additional Contrail Base Station licenses may be purchased for deployment on each additional server. Minimum Server Requirements ■ CPU: Dual Core 2.0 GHz ■ RAM: 4 GB DDR-2 ■ Optical Drive: DVD-ROM ■ Disk Configuration: RAID 1 Hardware (mirroring) ■ Data Storage: 80 GB (Additional 10 GB required if Pan and Zoom map tiles will be hosted locally on your server). ■ Operating System: Red Hat® Linux 6 or CentOS 6 (free open source version of Red Hat 6) 64-bit Linux Server virtualization can be used in place of a dedicated physical server. OneRain does not provide specific images for virtualization platforms. Contact contrail.support@onerain.com for guidelines and additional information. Minimum Network Requirements ■ 4 megabits per second (Mbps) downstream and 1 Mbps upstream ■ Higher speed is recommended when hosting a public website Incoming Network Ports Some open network ports are required as follows: Port Use Description Web Access to Contrail Web on the server 8080 Contrail Data Exchange interface 8181 Contrail Inventory application 3306 MySQL access 22 Default ssh port (sometimes moved to an off port for security) 60001 - 60010 reserved for StormlinkTM IP (logging queuing ALERT data collection) 60011 - 60020 Reserved for ALERT2 (feed from decoder to base station, usually via a serial to IP conversion). 60021- 60030 Reserved for ALERT data collection (via serial to IP converter) 60031- 60040 Reserved 60041- 60050 Reserved for StormLink cellular data collection PRE -INSTALLATION PLANNING PAGE 7 OF 17 2 Scope of Services and Functionality For a flood early warning system to be successful and provide the right information to the right people, at the right time, communications must be robust and the data from it must be highly available, easily accessible and understood, to support those charged with making informed decisions and taking appropriate actions. The software solution we are proposing, Contrail®, has been in use since 2005 and is capable of meeting the requirements to collect, store, analyze and disseminate data from the City's gauge network monitoring system and other regional sources for the purposes of flood early warning and emergency operations decision -support. The primary objective is to make the information more accessible to City officials, the National Weather Service and other partner agencies for use in operational decision support and emergency operations; post -event analysis; model calibration and planning in flood early warning; and stormwater and wastewater management. The City of Fort Collins' objectives for their new Flood Warning System software application include the following: ■ A robust and reliable network- or Web -based system which supports uninterrupted data receipt from ALERT/ALERT2 gauging stations and other non -City FWS gauge sensor data. ■ Provides managed and secure unlimited user Internet/intranet access for data visualizing, displaying, analyzing and data management. ■ Allows viewing of real-time gauge data (e.g., precipitation, stage, wind, temperature etc.) and sharing of data with the public. ■ Provides visualization and displays to show multiple sensor type (rain, streamflow, wind direction, wind speed, etc.) data on a single map. ■ Supports many varied users and allows peer agencies and partners to view and access data. ■ Automatically initiates emergency notifications and automates alert messaging function based on configurable thresholds and conditions. ■ Transmits notifications and alert messages via phone, cell, e-mail, pager, etc. ■ A scalable solution, compatible with virtualized server environments, that supports the agency's longer -term growth and diverse users. ■ A solution that is well supported and has ongoing enhancements, support and maintenance options. The City requires the following deliverables: ■ A primary and secondary base station software solution hosted on the City's own servers with licensing and technical support for a period of 5 years. ■ Installation, system setup, and configuration in a virtualized server environment. ■ Training of enterprise base station software for City personnel (end users, application and server administrators). The City desires to have a fully operational system and project completion by April 1, 2016. 2.1 Overview of Proposed Solution OneRain's Contrail -based solutions make decision -critical support data highly available and today is used by more than 14o entities with requirements similar to those of the City of Fort Collins for operational decision support and emergency operations, post -event analysis, model calibration and planning in early flood warning, safety of dams programs, stormwater and wastewater management. OneRain solutions are designed to hold OneRain and the monitoring systems we support accountable. Our customers know at all times that their system is up and running, or that it requires attention. OneRain Incorporated I Response to RFP 8161 FWS Software Page 4 Port Use Description 60051 - 60060 Reserved for Storm Link Satellite (IDP) collector 60061 - 60070 Reserved for ALERT two-way service Outgoing Network Ports The following outgoing ports are required for data feeds and software updates: Port Use Description 25 SMTP (Simple Mail Transfer Protocol). Required for Contrail to send emails and text messages from alarms. Also used to send reports and notifications of system events. 80 and 8080 Allows data agents to bring in data like USGS, METAR, or FFG. IP Outgoing Access/ 443 Required for software updates: Red Hat (or CentOS), and OneRain (handles by allowing IP outgoing access to specific IP or ranges of IP addresses).,- 123 NTP service using UDP for time synchronization. Incoming and Outgoing ports between multiple servers must be allowed to enable two-way data communication and synchronization. Supported Web Browsers Microsoft Internet Explorer, Mozilla Firefox, Apple Safari, or Google Chrome (latest versions). Contrail works well on all popular mobile device platforms (latest versions). PRE -INSTALLATION PLANNING PAGE 8 OF 17 Government Policy on Hypertext Transfer Protocol Secure — HTTPS- Only Standard IMPORTANT NOTE On June 8, 2015, the Whitehouse mandated HTTPS connection for Federal publicly -accessible websites'. The directive instructs Federal agencies with publicly accessible websites to provide service only through a secure HTTPS connection that encrypts nearly all information during communication between the website and user. (Reference M-15-13 Memorandum for the Heads of Executive Department and Agencies "Policy to Require Secure Connections across Federal Websites and Web Services") The strongest privacy and integrity protection currently available for public web connections is Hypertext Transfer Protocol Secure (HTTPS). HTTPS is a combination of HTTP and Transport Layer Security (TLS). TLS is a network protocol that establishes an encrypted connection to an authenticated peer over an untrusted network. TLS/SSL is the de facto standard for encrypted and authenticated communications between clients and servers on the Internet. ✓ Transport Layer Security (TLS) is the successor of Secure Sockets Layer (SSL); they are both cryptographic protocols that provide secure communications on the Internet for such things as web browsing, e-mail, Internet faxing, instant messaging, and other data transfers. There are slight differences between SSL and TLS, but the protocol remains substantially the same. ✓ A TLS/SSL certificate is required to enable encryption and authentication on your site domain and use the HTTPS protocol. ✓ Data between the browser and Contrail is encrypted. This is important for transmitting sensitive data like username and password. Technical Assistance Please visit https://HTTPS.cio.gov for technical assistance and best practices to aid in the implementation of this policy. 1 Publicly -accessible websites and services are defined here as online resources and services available over HTTP or HTTPS over the public Internet that are maintained in whole or in part by the Federal Government and operated by an agency, contractor, or other organization on behalf of the agency. They present government information or provide services to the public or a specific user group and support the performance of an agency's mission. This definition includes all web interactions, whether a visitor is logged -in or anonymous. PRE -INSTALLATION PLANNING PAGE 9 OF 17 © © 0 Create Virtual Machine Issue Contrail Software Provide OneRain SSH & Install OS License(s) access to Server Configures Network Firewall Rules Settings 0 Identify Data Collection Metadata OneRain Client �� Client System Administrator All 0 Provide SSL Certificate(s) Compile Metadata Install Contrail App & Configure Data Collection 0 Verify Live Data Collection Load System Metadata Training AssemblHistorical Data I Historical Data Load Steps U ❑9 1 011 Tasks Create Virtual Machine(s) & Install OS • 64-bit virtual machine: refer to Contrail Pre -Installation Plan for server hardware requirements. ✓ • Operating System: Red Hat' Linux® 6 or CentOS 6; Minimal Install (Note: OneRain will install all necessary software packages (MySQL, etc.) during the initial software application deployment). Issue Contrail Base Station software license authorization key(s) Provide OneRain SSH Access to Server • Provide OneRain SSH (secure shell) access to the Contrail Base Station server(s), typically via VPN. Configure Network Settings • Configure necessary network settings (Local IP address, DNS, etc.). • Determine WAN address and register public URL if applicable. Firewall Rules • Ensure all firewall rules regarding required Contrail Incoming and ✓ Outgoing Network Ports are in place. Provide SSL certificate(s) • Data between the browser and Contrail is encrypted. • A TLS/SSL (Transport Layer Security/Secure Sockets Layer) protocol certificate is required to enable encryption and authentication on your site domain and use the HTTPS protocol. Identify Data Collection Metadata • Identify application user access privilege levels. • Identify site groupings: watersheds, water basins, fire borders, or other logical groups or views. • Identify site images, maintenance or public notes, sensor thresholds, ✓ historic events such a maximum values during storms, etc. • Determine default validation criteria for sensor types. • Alarms and Notifications: Consider alarm evaluations and types of notifications. Compile System Meta Data • Provide Data Collection System information. • Provide Site and Sensor Meta -data definitions via Import Spreadsheet. Install Contrail Application & Configure Data Collection • Install Contrail application(s) via SSH. ✓ • Perform advanced configuration of data collectors, data agents and other services. Load System Meta Data • As Identified in step 7. mown", Verify Live Data Collection • Confirm that data are being collected and correctly processed as ✓ expected. Assemble Historical Data • Catalog and validate existing datasets to migrate to Contrail. Historical Data Load (if applicable) • Optional professional services performed by OneRain for historical ✓ data transfer. Training • Advanced Server Administrator. • Contrail Application System Administration. • Contrail General User. PRE -INSTALLATION PLANNING Network Setup for Contrail Base Station on Enterprise Linux 6.X A pre -installed Contrail Base Station is configured for DHCP (dynamic host configuration protocol) network addressing before shipment. Static network address configuration is recommended for server operations to allow routing of data. To access the server remotely for management and data viewing, either the IP address assigned to the server is an Internet -accessible IP, or Port Forwarding techniques can be used to permit communications from external hosts to access the server inside a local network. Contact your network administrator to request the necessary network settings. Local IP address: (192.168.1.100) Gateway address: (192.168.1.1) Subnet mask: (255.255.255.0) Primary DNS address: Secondary DNS address: External IP address: Network Ports: Review the documented ports in this Pre - installation Plan (refer to pages 7 and 8 in this document) Connect and start the server 1. Connect an Ethernet cable between your network and the first Ethernet port on the server. The first physical Ethernet port on the server corresponds with the Linux Ethernet adapter eth0. Some servers label the Ethernet connections - choose the first physical connection. 2. Connect the monitor, keyboard, mouse, and server power cord. 3. Start the server. Press the power button. 4. You are prompted to enter username and password. Contact OneRain to request your username and password credentials. To view current server network settings using ifconfig 1. View current network configuration of (eth0) tool. 2. Type on the command prompt: ifconfig Edit the server network settings using the command line 1. Open the text based network configuration tool. Type on the command prompt: system -co nfig-netwo rk 2. Use the keyboard <Tab> to navigate the interface. Use the <Enter> key to confirm an action. Use the <Space> key to select or un-select options. PRE -INSTALLATION PLANNING 3. Select Action > Device configuration. 4. Select a Device > (eth0). 5. Network Configuration: Unselect "Use DHCP" to edit the static network information Static IP = Local IP address Netmask = Subnet mask Default gateway IP = Gateway address Primary DNS Server = Primary DNS address Secondary DNS Server = Secondary DNS address 6. Save the network changes. 7. Select Action > DNS configuration. 8. DNS configuration: Hostname = primary (machine name without spaces) Primary DNS = Primary DNS address Secondary DNS = Secondary DNS address Tertiary DNS = (Optional) DNS search path = onerain.net (organization may provide) 9. Save the network changes (Save & Quit). 10. Restart the server for changes to be applied. Type on the command prompt: reboot PRE -INSTALLATION PLANNING PAGE 13 OF 17 Customer Pre -Installation Checklist There are certain steps that you must take before installation of Contrail Base Station can take place. The checklist below will assist you in coordinating and planning the installation tasks in preparation for a smooth and efficient installation of Contrail Base Station. Send a copy of the completed form to OneRain via email at customer.support@onerain.com (or fax 303-774-2037). Keep a copy for your records. To fill out the form electronically and then save and submit, you'll need free Adobe'h' Reader'. CONTACTS AND INSTALLATION SITE DETAILS (to be completed by customer) ORGANIZATION /BUSINESS NAME DEPARTMENT /DIVISION STREET ADDRESS CITY, STATE, ZIP PRIMARY CONTACT _ PRIMARY CONTACT NAME PRIMARY CONTACT PHONE PRIMARY CONTACT EMAIL I.T. AND NETWORK ADMINISTRATION CONTACT I.T. CONTACT NAME LT. CONTACT PHONE I.T. CONTACT EMAIL OTHER CONTACT CONTACT NAME CONTACT PHONE CONTACT EMAIL Task Description Check ✓ Notes Done N/A Hardware 1. Provision for Server(s): Contrail Base Station operates on a 64-bit Linux°'-based. Refer to Contrail® Base Station Platform Requirements on page 7. 2. IP/Serial Device: OneRain Custom Serial-to-IP ❑ ❑ Connection Kit, or other. 3. Identify network drops for Contrail Base Station ❑ ❑ server(s). 4. Identify network drop of IP/Serial Port devices. ❑ ❑ Network and System Requirements 5. Obtain SSL/TSL (HTTPS) certificate(s) for your website domain. Refer to section on "Government ❑ 8. Register one (1) domain name to WAN address for Contrail and one (1) Contrail Inventory plus. Three Technical Assistance and Support Questions? Receive guidance about supported hardware options and network configurations that can assist you with your decisions. OneRain technical assistance is available to warranty or maintenance contract customers who need technical assistance with a OneRain product. Contact OneRain Incorporated 1531 Skyway Drive, Unit D Longmont, Colorado 80504 Technical Support Email: contraiLsupport@onerain.com Phone 303-774-2033 Toll Free 1-800-758-RAIN (7246) PRE -INSTALLATION PLANNING PAGE 16OF 17 More Information Since 1992 OneRain has been providing high quality data and professional services to customers who need accurate rainfall and related environmental information to make high -value decisions. Our customers' critical missions include dam safety, flood warning, stormwater and wastewater management, and reservoir and hydropower operations. Our vertical involvement in water measurement, from gauges through remote sensing and storm analysis, enables us to collect and distribute the best real-time and historical hydrometeorological data available. Our complete systems approach to hydrological management includes nationwide 24/7-supported enterprise data collection, archiving, notification and Web visualization services, local data collection software, gauge -adjusted radar rainfall estimation, rain and other hydromet gauging and professional services, gauge maintenance, real- time satellite telemetry services, telemetry system integration, storm properties analyses and consulting services. OneRain has designed, built, rehabilitated, and maintains many hundreds of gauges throughout the country. Each gauge or system is tailored specifically to the customers' needs. OneRain continually strives to be the industry leader to the remote hydrometeorological world, consistently pushing the bar with new technology, while always maintaining quality service and support. For the latest information about our products and services, please contact: OneRain Incorporated 1531 Skyway Drive, Unit D Longmont, Colorado 80504 T: (303) 774.2033 or Toll Free: 1.800.758.RAIN (7246) www.onerain.com PRE -INSTALLATION PLANNING PAGE 17 OF 17 The Contrail -based solutions we are proposing are fully supported by a dedicated in-house development, implementation and support team and have been in use by many agencies for many years for the purposes described in the City's objectives. Contrail is as an enterprise -level software platform offering a scalable and reliable software architecture built for the age of Web -access and modern data collection practices. The growth in mobile computing, along with advances in technology and many industry changes —for example, new ALERT2TM protocol, use of non -ALERT data communications such as satellite and cellular, Web -based dissemination, insecurity of FIT, and more —has driven Contrail's evolutionary development, continuous improvement, and its rapid and flexible response to change. Contrail is built on open source, open standard platforms; Linux, Apache, Tomcat, mySQL. This provides OneRain and our customers with greater control over the fast -changing technology that underlies everything we count on. Contrail consolidates multiple sensor data and processes into a single solution that creates a comprehensive view of the surrounding region's entire hydrologic network. Encompassed are tools and reports for sensor management, rainfall and stream -related reporting, maintenance, and custom alarm and notification features. Our solutions also enable management of and quick access to water -related Emergency Action Plan (EAP) content, links to any outside resources, webcam video feeds from Internet - enabled sites, and many other Web -hosted tools. The Contrail platform supports not only real-time, flood warning -oriented activities, but also longer scale water resources management, water quality, safety of dams programs, road weather information, and other activities with potentially wider user populations. Contrail delivers many capabilities not available in the City's current legacy systems. You'll have a full suite of advanced tools and reports available to you that provide early warnings and notifications of severe wet weather conditions that may impact your operations, while improving information sharing and operational efficiencies in support of your operations. Highlights ■ Brings all your water and rainfall data together in one place. Seamless integration and automated data collection from many sensor types and multiple sources (DIADvisol", ALERT/ALERT2TM, USGS, METAR, RAWS, HADS, CDEC, Tides, Orbcomm, GoData, RWIS, SCADA, Modbus and more...) ■ Supports many users with no special software to install anywhere except on the base station servers. ■ 24/7 Web -accessible for both end -users and administrators via laptops, smartphones, tablets... ■ Advanced Alarm Management and event notifications sent via email, text, pager. ■ Up-to-the-minute visualization of current conditions - presents data in easy to understand maps, real-time dashboards and widgets, charts, graphs and tables. ■ High -resolution, custom static maps and pan -and -zoom maps clearly define sensors and their status. ■ Map Overlays allows the integration of radar, spatial rainfall, flood inundation, and GIS layers onto your custom maps. ■ Point and click drill -down to sensor data. ■ Advanced data analysis and reporting tools included —numerous integrated toolsets and reports (Contrail Insight, Contrail Inventory Plus, and Contrail ALERT2 TDMA Manager are included with licensed Contrail Base Station). Alarms and Notifications Support Decision -Critical Operations Automated delivery notifications to appropriate personnel to warn of possible flood conditions ensures time for actions that reduce risk, minimize losses and enhances public safety. At Contrail's core are the advanced warnings with reliable alarm delivery capabilities that support decision criteria and EAP OneRain Incorporated I Response to RFP 8161 FWS Software Page 5 OneRaia,,,,, The Rainfall Company Experts measuring rainfall and its consequences'' Experts in measuring and Your Data Anytime. Anywhere. When You Need It. WHEN FLOODED Visualizing information from your hydrometeorlogic and flood TURNAROUND understanding water t �"' warning network in a matter of seconds is critical in the decision DON'T ®® • End -to -end real-time hydrometeorological monitoring systems®N.� �' _. making process. Allowing multiple viewers to access real-time • Contrail' 24/7-reliable data collection and management solutions _ data anywhere they can access the web is of even more • OneRainwareTM radar rainfall for real-time and analytical applications „-. ,. _._ . _ , value. OneRain's easy -to -use data and graphical visualization • StormLinkTMtelemetry systems and data services 0 L _-® _- software tools provide centralized historical and real-time sensor • Complete network design and implementation _ monitoring information with advanced alarm and notification • OneRainTech'"Field Services W ` capability. • Best practices consulting and professional services Our Total Systems Approach For more than 20 years, OneRain has been providing private and public sector clients across the country with solutions to optimize water management, heighten regulatory compliance, achieve successful civil works, and save lives. OneRain has contributed to the fundamentals ofthe industry in Its 20+years of existence and today is helping to shape the next generation of real-time hydrometeorological monitoring technology and systems. Our vertical involvement in water measurement, from gauges through remote sensing and storm analysis, enables us to tolled and distribute the best real-time and historical hydrometeorological data available. We build, maintain and troubleshoot systems that collect data and present information for mission -critical decision making. Today, our products and services serve: Flood Early Warning and Emergency Management Dam Safety and Reservoir Operations Water Resource Management Post Fire Mitigation Floodplain Management Urban Water Management Stormwater Management Wastewater Management (1/1 Studies, NPDES) OneRain helps agencies create reliable and maintainable hydrologic monitoring and decision support systems. OneRain has designed, built, rehabilitated, and maintains many hundreds of gauges and systems throughout the United States. Our complete systems approach to water management includes nationwide 24/7-supported enterprise data collection, archiving, notification and web visualization services, local on -premise data collection software, rain and other hydromet gauging, field gauge maintenance services, real-time satellite, cellular and IP telemetry services, telemetry system integration, gauge -adjusted radar rainfall data, design storms and storm properties analyses, and professional consulting services. Our core purpose is to optimize the successful estimation of rainfall and its consequences, both in real time and from a historical perspective. Accurate and reliable collection of rainfall and related hydrological data from start to finish ►►► Our customers require the best rainfall estimates. It is OneRain's philosophy that this reality is achieved by creating strong, scientifically -based, replicable data processes. Our data infrastructure focuses on quality and reliability of our input data sources. The best rainfall data today combine well placed, well maintained rain gauge information with expert -vetted, high quality mosaiced radar rainfall information. There are no shortcuts to data quality. It is a critical task to complete all analyses with the best, most complete information sources available. OneRain is the only company that focuses on rainfall from end to end —starting with the rain gauge data collection network and the best mosaiced radar rainfall, and finishing with the best available rainfall estimates. Contrail' Enterprise, our secure, 24/7-supported data services center, is the core of our rainfall data collection and distribution system. Contrail Enterprise continuously collects real- time data from ALERT/ALERT2 networks, direct Internet and satellite data feeds, and on-line data sources, both public and proprietary, including NEXRAD Radar, USGS, HADS and METAR. Our nationwide radar rainfall data archive goes back to the beginning. Contrail® Software High Availability Real-time Monitoring, Early Warning and Response 207 web -based and mobile smartphone access to your mission critical data. ►►► Measuring rainfall, river or stream water levels at several points upstream, combined with reliable and timely communications and dissemination of information via Contrail, ensures sufficient lead time for actions that reduce risk, minimize losses, and possibly save lives. OneRain's Contrail software platform collects, processes and archives rainfall, flow, stream level, weather station and many other hydrometeorological data from virtually any sensor type and transmission protocol. Contrail supports local ALERT/ALERT2' line -of -sight radio data, cellular and satellite weather gauge data, as well as any web -accessible sources such as USGS gauges, METAR, TIDES, HADS, RWIS, and more.... At the core of Contrail is its 24/7 continuous real-time data collection, monitoring, and advanced alarm and automated delivery notifications that ensures information is automatically distributed quickly and efficiently to appropriate personnel to warn of possible flood conditions. Contrail empowers decision makers and response personnel with critical real-time information through highly customizable alarm rules, communicating response actions, and multiple alert delivery notification options. Storm Li nk- Telemetry Complete Turnkey Solutions Remote and on site hydrometeorlogic monitoring. ►►► Whether it's monitoring reservoirs or high risk dams in extremely remote areas, or post -wildfire burn areas, OneRaln provides full tumkey solutions that provide automated data —77 collection, dissemination, alarming and triggered events notifications. Fully compatible with Contrail, the system delivers reliable and timely data via RF, IP, cellular, or OneRain's real-time satellite option that includes airtime data services with guaranteed delivery to a Contrail destination. "OneRain helps agencies create reliable and maintainable hydrologic monitoring and decision support systems." "We partner with our customers to deliver solutions that help them achieve their goals and mission success." OneRain Professional Services OneRainwareT" Gauge -Adjusted Radar Rainfall (GARR) Real-time Data and Historical Analysis Services. i,- Pit, Gauge -Adjusted Radar Rainfall (GARR) marries rain gauge measurement at a point with the spatially distributed information from NEXRAD radars to give you - ground truthed, spatially distributed rainfall information over your area of _ interest. -- OneRain is unique in having and continuously updating the most complete database of National Weather Service NEXRAD radar available, starting in 1993 to present. Every five minutes, nearly 20 million new radar -rainfall estimates are added to the database. OneRain's radar record contains 2-km', 15-minute data from 1993 for most areas. Our national record of 1-km2, 5-minute data dates back to 2002.OneRainware radar processing has evolved continuously since 1994 into the data quality management system required to produce archive quality data for flood warning, runoff modeling, 1/1 studies, litigation, real-time control, design storms and National Pollutant Discharge Elimination System (NPDES) compliance activities. The data, whether historical, real-time or forecasted, are available to authorized users as part of OneRain's 24/7-supported, hosted Contrail' Enterprise. With a talented team of highly experienced individuals, OneRain draws on our proven experience for the past 20 years to offer a wide range of leading support and professional services to modernize and optimize your water management and hydrometeorological data collection systems. We understand the challenges you face. OneRain's professional services can help you achieve your goals by building solutions that effectively strengthen your water monitoring and analysis capabilities and align technology with process to support data sharing, forecasting, early warning, disaster mitigation, and emergency response. Copyright 02014, OneRain Incorporated. All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. Rev 2.0 OneRatlia.The Rainfall Compan T. 303-774-2033 Toll Free: 800-758-RAIN (7246) Email: sales@onerain.com www.onerain.com (emergency action plan) notification procedures. Contrail's Alarm Manager administrative interface allows configuring of alarms rules based on user -defined alarm thresholds. Alarm Manager �l Alarms Triggered (Past Year) 80 60 �' nn1-1I-In 0 0 o y � n `s c n o A A A to � tlt � Ui U tT to � Figure 1- Contrail's Alarm Manager Administrators can create customized rules to trigger an alarm for any sensor or group of sensors within your program. We can help you establish alarm rules based on data so the program will generate a text or email message alerting appropriate contacts via text and/or email of conditions that require attention that involve one or multiple sensor readings. Alarm Status and Delivery Contrail provides several ways to view alarms and their status (map icons, drill -down lists, graphs, searches), depending on web views and user privileges. Triggered alarms are indicated with alarm icons on Contrail Maps and, when the data are qualified and the alarm criteria are met, sends out e-mail and/or text messaging notifications to the people that you designate. Managing Contacts and Groups for Issuance of Alarm Notifications Contrail's Contacts and distribution Groups feature makes it easy to organize alarm delivery notifications whether individuals or groups or based on their roles, departments or teams (e.g., flood control, emergency responders, water quality management, field maintenance, etc.). Changes in personnel or delivery addresses are easily handled —you can replace a contact with an alternative contact to be used for all assigned alarm notifications deliveries, or choose to remove a contact from all assigned deliveries. AL Test System Latency @ Rule aW. 1k,w1;ro.m�. ro.l 9nuar w_ 6y. tm-.w- Alarm Summary A Triggered. 0610812015 12 61 40 B Duration: 6 Delivered Q 6 Data has trot been received Tor the system. Mundo Dam The Apache, StorrhLink Satellite Mauer-Rernat system has not reponetl a Valle reading in 30 hmrrs (1800 Mra sa) �f) — — A lK OneRain Weather Station (ALERT2) rimo)L0 ._.... ....... _._... ......... .J B Air TemperajuemQl 5VOdef O 3 iiiatres ago ii Baterytc, L® 117 Y Oabd610 hers ago # Rain Accumulation M 19 16 00 it Oabmalohoursago I +_ Rain axminentri=cNIV 0.00 it .. O about 10 halls ago "w Figure 2 - Contrail Alarms and Status OneRain Incorporated I Response to RFP 8161 FWS Software Page 6 2.2 Methods and Approach As an agency with mission -critical responsibilities in flood early warning and water management, high availability and accessibility to your data anywhere and at any time is highly important. With Contrail, several configuration architectures are possible to achieve the required system redundancy and reliability. A resilient system provides geographic redundancy, eliminates a potential single point of failure, and will continue to provide service even if there is a system failure at one end —the data feeds and essential agency operations can continue uninterrupted. OneRain typically recommends a two -server Contrail software solution with two servers that are geographically separated, with automated real-time replication of the databases between the two providing redundancy. The solution we are proposing is described in section "2.2.1 Technical Architecture Design", below. The approach we will take to perform the system upgrade and installation is outlined in section "2.2.5 Implementation and Project Schedule", below. 2.2.1 Technical Architecture Design To ensure the highest level of availability and optimized performance, OneRain is proposing a two -server (primary and secondary) architecture for the City of Fort Collins, with continuous real-time database replication between the two servers. The primary server handles data collection, alarming, and user interaction, and the secondary server is used to support reporting and data analysis. The secondary server also acts as a backup server if the primary server should be offline for some reason. This way, data collection and alarming are not impacted by users doing data analysis. City of Fort Collins IT Network Poudre Fire Authority IT Network "lm1-1 IN �II rive] RxF:raITHM.............. 6 • 114 9 L• W,[3a ........ DAT AREc PRIMARY SECONDARY �, DATAANTENNA NA RECEIVE CONTRAIL BASE STATION CONTRAIL BASE STATION RECEMBU : : L m .i RECEIVEW DECODER : REPLICATION */ DECODER INTRANET { - • I (NTRANET NEIWO!?i(. * � A j NEiYVORK SERIAL TO SERIAL TO : 1 TCPftP • DATA EXCHANGE T�� a ................................................ .......................... .. ........................................... i i ;SHEF: r NATIONAL 1, WEATHER SERVICE WEB & MOBILE a0 0 USERS & ADMIN Figure g - Proposed Contrail Base Station Architecture for the City of Fort Collins OneRain Incorporated I Response to RFP 8161 FWS Software Page 7