Water works

To get higher billing and receivables cycle speeds, Greater Vancouver Regional District upgraded its data historian, resulting in savings, efficiency, and improved service to its customers.

1 of 2 < 1 | 2 View on one page
Greater Vancouver Regional DistrictBy Gary L.S. Wong, Greater Vancouver Regional District

The Greater Vancouver Regional District (GVRD) is in the quality-of-life business for our residents, overseeing aspects of drinking water, wastewater, air quality, social housing and parks. We aren’t after profitability; rather we are after reducing costs and improving how people live. Because of this, it was necessary for us to focus on building a sustainable region that could be maintained whether the population of the area stays at 2 million or grows to 3 million in the next 15 years, as is estimated.

To do this, we needed an enterprise-level data historian that would enable us to collect, analyze, report and integrate control system data and information to corporate systems and other lines of business. In 2005, we rolled the OSIsoft PI data collection and distribution engine into production. This gave us the foundation for successful enterprise business integration.

Business Challenges
The business challenges of creating a cohesive, working unit out of the GVRD was four-fold: dealing with disparate systems and data, replacing obsolete systems, preparing for ever-changing environments and acquiring real-time access to information across the organization. Each issue presented a separate set of challenges, solutions and benefits that were directly addressed by introducing OSIsoft’s technology and services.

Gary L.S. Wong

GVRD manager, corporate applications, Gary L. S. Wong, says the OSIsoft data historian upgrade has speeded up GVRD’s billing and receivables cycle, earning the company an additional $500,000 a year in interest.

The first item was unifying many disparate systems and data. The previous system required managing and using multiple user interfaces and disparate technologies, learning many different systems and having redundant data that had to be sifted through. It was also very costly to support several systems and presented enterprise-integration issues.

The solution was as simple as adding just one OSIsoft PI V3.4 server to manage all control-system data. This allowed for a common user interface using the ProcessBook graphics module, the DataLink report creator and RtWebParts, which allows users to access information via the SharePoint Portal Server. In addition, users were able to access a web portal using Microsoft SharePoint across the entire organization. GVRD used MS BizTalk and the PI SDK software development kit for data and application integration, which simplified the entire process.

This simple implementation eliminated the need to standardize control or other disparate systems, saving hundreds of thousands of dollars. Deferring the replacement of our wastewater treatment plant control systems (which have a remaining product life of at least 10 years) will save $250,000 per year based on a cost of capital of 5%.

Employees now know where and how to find information, a change that can be felt across the organization. Our IT department fields fewer requests for tutorial and information. By using the OSIsoft platform, our organization only needed to learn one system that incorporated familiar Microsoft tools, making for faster implementation and adoption.

Replacing Obsolete Systems
Prior to implementing the OSIsoft solution, we had eight proprietary historians across four wastewater treatment plants (WWTPs). The organization was also facing imminent failure of an obsolete and cumbersome billing system responsible for managing $165 million per year in revenue from water sales and wastewater treatment. The billing system was not only out of date, but also slow—a consistent two-month delay for the finance department to receive preliminary billing information caused internal and customer dissatisfaction. In addition, the billing system cost more than $100,000 a year for support and maintenance.

We replaced the system with PI redundant-pair buffer nodes at each of four WWTPs, sending data back to a single corporate OSIsoft PI server. The Corporate Historian Reporting and Information System (codename CHRIS) is based on PI Enterprise, PI SDK, .Net and Microsoft Office. In short, the entire billing application was rewritten with zero downtime on production systems and no lag. The move saved $285,000 on licensing fees alone. Support and maintenance costs are also projected to be reduced by 70%.

In addition, more than 100 GB of data needed for billing, previously stored in a Sybase system, was converted to just 6 GB in OSIsoft PI. This accelerated our data, and the finance department now receives billing information in near-real time, allowing for accurate budget forecasting and more accurate and faster billing. By speeding up our billing and receivables cycle by one month, we’re able to earn an extra $500,000 per year in interest. The organization also benefits, as quality assurance and quality control are no longer headaches, since all data is available in real time and includes an audit trail.

Preparing for Ever-Changing Environments
The SCADA system needed to be replaced by 2007/2008, and data continuity was needed for water distribution and wastewater collection. Water operations optimization also demanded simulations, forecasting and predictive modeling requiring operational and process data. The new water filtration plant also needs to be online in 2008 and ready for up to 40,000 new tags. Finally, OSIsoft’s solutions are based on the MS Office platform, and Office System 2007 was in pilot version, therefore the portal and desktop were evolving.

1 of 2 < 1 | 2 View on one page
Show Comments
Hide Comments

Join the discussion

We welcome your thoughtful comments.
All comments will display your user name.

Want to participate in the discussion?

Register for free

Log in for complete access.


No one has commented on this page yet.

RSS feed for comments on this page | RSS feed for all comments