Locus Technologies founder and CEO Neno Duplan provides a wealth of experience on water quality in the cloud. Neno began cloud-based data work before any of us knew what the cloud even was. He does a great job explaining the steps needed to undertake and the significant benefits of a cloud-based digital transformation, and much more!
Attention all water providers: the EPA’s UCMR 5 list includes 30 contaminants (29 PFAS and lithium) that both small and large water systems have to test for and report. Can your current environmental solution handle it?
Locus EIM environmental software can handle new chemicals and analyses seamlessly. Both the standard Locus EIM configuration and the Locus EIM Water configuration (specially tailored to water utilities) are built with ever-changing regulations in mind.
We’ve put together some helpful background and tips for water providers preparing for UCMR 5 monitoring.
What water providers need to know
- The fifth and latest list (UCMR 5) was published on March 11, 2021, and includes 30 new chemical contaminants that must be monitored between 2023 and 2025 using specified analytical methods.
- SDWA now requires that UCMR include all large PWSs (serving >10,000 people), all PWSs serving between 3,300 and 10,000 people, and a representative sample of PWSs serving fewer than 3,300 people.
- Large systems must pay for their own testing, and US EPA will pay for analytical costs for small systems.
- Labs must receive EPA UCMR approval to conduct analyses on UCMR 5 contaminants.
[sc_icon icon=”download” shape=”square” size=”small” link=”https://ltweb-stage.locustec.com/wp-content/uploads/2021/03/locus_infographic_ucmr5.jpg” link_target=”_self”] Download Infographic
What’s the UCMR and why are some contaminants unregulated?
In 1996, Congress amended the Safe Drinking Water Act with the Unregulated Contaminant Monitoring Rule (UCMR). Under this new rule, US EPA can require water providers to monitor and collect data for contaminants that may be in drinking water but don’t have any health-based standards set (yet) under the SDWA.
More than 150,000 public water systems are subject to the SDWA regulations. US EPA, states, tribes, water systems, and the public all work together to protect the water supply from an ever-growing list of contaminants.
However, under the UCMR, US EPA is restricted to issuing a new list every five years of no more than 30 unregulated contaminants to be monitored by water providers.
This helps reduce the burden on water providers, since monitoring and testing for the existing long list of regulated contaminants already requires a significant investment of time and resources.
Throughout the course of this monitoring, US EPA can determine whether the contaminants need to be officially enforced— but this would require regulatory action, routed through the normal legislative process.
Tips for managing UCMR in 
- DO use EIM’s Sample Planning module to set your sample collection schedule ahead of time, as requirements vary and are on specific schedules
- DO take advantage of EIM’s sample program features to track and manage UCMR data, or consider using a dedicated location group to track results, keeping them separate and easy to find for CCR reporting.
- DON’T worry about adding in new analytical parameters in advance. With EIM’s EDD loader, you can automatically add them when the data arrive from the laboratory.
Contact your Locus Account Manager for help setting up your EIM database in advance of your sampling schedule, and we’ll make sure you’re equipped for UCMR 5!
Not yet a customer? Send us a quick note to schedule a call or a demo to find out how Locus software can completely streamline your water sampling and reporting.
[sc_button link=”#eimquote” text=”Get a demo of Locus EIM” link_target=”_self” centered=”1″]
More helpful links:
- Locus adds Consumer Confidence Report (CCR) module to Locus EIM Water
- Improving arsenic detection and keeping it out of drinking water
- Making water quality data more transparent: Lessons from an annual water quality report
- Water quality data management: 10 best practices
[sc_fullwidth background_image=”15039″ background_style=”cover” background_position_horizontal=”center” background_position_vertical=”top” video_background_acpect_ratio=”16:9″ container=”1″]
Get a demo
[/sc_fullwidth]
Let’s look back on the most exciting new features and changes made in EIM, Locus’ environmental data management software, during 2020!
[sc_icon_with_text icon=”laptop” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#52a6ea” icon_size=”big” level=”h3″]
1. Expanded EIM API
Locus expanded the EIM application programming interface (API) to support running any EIM Expert Query. Using a drag and drop interface, an EIM user can create an Expert Query to construct a custom SQL query that returns data from any EIM data table. The user can then call the Expert Query through the API from a web browser or any application that can consume a REST API. The API returns the results in JSON format for download or use in another program. EIM power users will find the expanded API extremely useful for generating custom data reports and for bringing EIM data into other applications.[/sc_icon_with_text]
[sc_icon_with_text icon=”search” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#9ac63f” icon_size=”big” level=”h3″]
2. Enhanced EIM Search Bar Functionality
Locus enhanced the usefulness of the EIM search box located at the top right of EIM. A user can now search for a location, field sample, or parameter, and choose from quick links showing any found data records plus related field measurements, groundwater levels, or analytical results. The search box also supports searches across EIM help files. These improvements, along with the existing ability to search for EIM menu items or functions, greatly increase the search bar’s usefulness and make it much easier for users to find what they need. In 2021, Locus plans on further expanding the search bar to allow for generating charts or maps for entered locations or parameters.[/sc_icon_with_text]
[sc_icon_with_text icon=”gis-plus” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#3766b5″ icon_size=”big” level=”h3″]
3. Multisite Support for EIM GIS+
The EIM GIS+ package brings the power of geographical information systems (GIS) to EIM. In 2020, Locus added multisite support for the GIS+. A user can generate a map showing locations and related results for more than one EIM site at a time. This GIS+ improvement supports cross-site queries and maps, which help greatly with analysis across a portfolio of sites in EIM.[/sc_icon_with_text]
[sc_icon_with_text icon=”sample-planning” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#52a6ea” icon_size=”big” level=”h3″]
4. Support for Sample Planning Notifications
Locus rolled a new EIM feature in 2020 to support automated email notifications for sample planning events. Users can subscribe to notifications for unreported analysis groups, parameters, or samples; late and upcoming samples; and compliance samples at risk of being late. Each notification can be tailored for specific plans, events, and tasks, and are set to run for specific time window. With these new notification types, users gain more control over their sample planning and are better notified about potential issues. The new sample planning notifications are available in Water EIM but can be deployed to other customer EIM instances on request.[/sc_icon_with_text]
[sc_icon_with_text icon=”consumer-confidence-report” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#9ac63f” icon_size=”big” level=”h3″]
5. Continued Water EIM Reporting Support
EIM is the world’s leading water quality management software used since 1999 by many Fortune 500 companies, water utilities, and the US Government. Locus continues to support water utility customers in EIM through multiple updates done to EIM reporting and analysis. From enhanced support for chlorine field data, to incorporating the latest reporting requirements for the Consumer Confidence Report, Locus continues to expand Water EIM functionality while accounting for variable practices that exist among water utility operators.[/sc_icon_with_text]
[sc_icon_with_text icon=”analytical-view” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#3766b5″ icon_size=”big” level=”h3″]
6. Improved Analytical Views
Locus continues to upgrade and improve the EIM interface and user experience. In 2020, Locus overhauled the Analytical Views pages in EIM, which support data exports for analytical results as well as laboratory QC samples and results. Multiple EIM menu items were combined into one page that supports all analytical data views. Users are directed through a series of filter selections that culminate in a grid of results. The new page improves usability and provides one centralized place for these data reports.[/sc_icon_with_text]
[sc_icon_with_text icon=”load-edd” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#52a6ea” icon_size=”big” level=”h3″]
7. Enhanced FTP EDD Loader Abilities
One of the more powerful modules in EIM is the FTP EDD loader, which lets laboratory users upload multiple analytical EDD files for different sites to a Locus FTP server for batch processing. Lab users do not have to login to EIM to upload each EDD individually. In 2020, Locus augmented this function to support non-analytical EDDs and to accept EDDs from non-lab users. With these changes, any EIM user can upload to the FTP site any number of EDD files in any format for multiple sites. Users may still need to login to EIM to resolve any EDD errors. Interested EIM users should contact Locus to get the needed FTP site credentials.[/sc_icon_with_text]
[sc_icon_with_text icon=”discharge-monitoring-report” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#9ac63f” icon_size=”big” level=”h3″]
8. Expanded DMR Support
Locus continues to enhance the Discharge Monitoring Report (DMR) module in EIM. In 2020, Locus implemented calculations needed to handle reporting of divalent metals. Locus also added the Florida DEP ezDMR format. Locus continues to add more formats so customers can meet their reporting requirements.[/sc_icon_with_text]
[sc_icon_with_text icon=”parameter-limits” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#3766b5″ icon_size=”big” level=”h3″]
9. Improved Parameter Management
Locus added two new features in EIM to improve support for managing analytical parameters. First, EIM now allows for storing parameter names in the local language and using these translated names in EIM Enhanced Formatted Reports. This function helps non-English customers create reports customized for local users. Second, EIM can handle alternate parameter codes. These ‘aliases’ for the primary parameter code, used in tracking reports and in EDD uploads, ensure that labs are not flagged or penalized for using a parameter code that is synonymous with the expected EIM parameter code.[/sc_icon_with_text]
[sc_icon_with_text icon=”unit-conversions” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#52a6ea” icon_size=”big” level=”h3″]
10. Improved Unit Conversions
Locus enhanced the unit conversion functions in EIM in 2020; these functions are used to convert laboratory analytical results to a consistent set of reporting units. EIM now allows for conversion factors that are parameter specific. Second, EIM now lets users define molecular weight multipliers for use in unit conversions that require molecular weight calculations. Both these changes give users more control and transparency over unit conversions in EIM.[/sc_icon_with_text]
Contact us to see a demo of Locus EIM and get a quote
Locus will provide water quality and analytical data management software for Valley Water
MOUNTAIN VIEW, Calif., 1 September 2020 — Locus Technologies (Locus), industry leader in water data management software, today announced that Valley Water (formerly Santa Clara Valley Water District) has chosen Locus environmental software for their data collection and management.
Valley Water has selected Locus’ environmental software, EIM, following consultant work Locus provided for the utility going back 14 years. They will seek to utilize Locus EIM as a laboratory database management system, and for data analytics. Locus EIM will be used to manage sample data for over 200 million gallons of drinking water consumed daily by over 2 million people in the district.
“Valley Water has an award-winning track record of bringing the highest-quality water to the Bay Area. Being local, we see the hard work that Valley Water puts into providing some of the best drinking water available anywhere. We are proud to be a part of that process,” said Wes Hawthorne, President of Locus.
Imagine the time savings and the simplicity of having your regulatory requirements all lined out for the year without having to worry about missing required samples. For water utilities, this is especially valuable given the strict schedules and public health implications of missing sampling events. Locus sample planning streamlines repetitive sampling, such as required samples for drinking water or monitoring wells. Any sampling events can be planned and reused repeatedly, even with tweaks to the schedule for the samples to be collected. We’ve outlined some key features of Locus sample planning in this infographic.
Contact us to see Sample Planning in action
Let’s look back on the most exciting new features and changes made in EIM, Locus’ environmental data management software, during 2019!
1. Migration to AWS Cloud
In August, Locus migrated EIM into the Amazon Web Services (AWS) cloud. EIM already had superior security, reliability, and performance in the Locus Cloud. The move to AWS improves on those metrics and allows Locus to leverage AWS specific tools that handle big data, blockchain, machine learning, and data analytics. Furthermore, AWS is scalable, which means EIM can better handle demand during peak usage periods. The move to AWS helps ensure that EIM remains the world’s leading water quality management software.
2. SSO Login
EIM now supports Single Sign-On (SSO), allowing users to access EIM using their corporate authentication provider. SSO is a popular security mechanism for many corporations. With SSO, one single login allows access to multiple applications, which simplifies username and password management and reduces the number of potential targets for malicious hacking of user credentials. Using SSO with EIM requires a one-time configuration to allow EIM to communicate with a customer’s SSO provider.
3. GIS+ Data Callouts
The Locus GIS+ solution now supports creating data callouts, which are location-specific crosstab reports listing analytical, groundwater, or field readings. A user first creates a data callout template using a drag-and-drop interface in the EIM enhanced formatted reports module. The template can include rules to control data formatting (for example, action limit exceedances can be shown in red text). When the user runs the template for a specific set of locations, EIM displays the callouts in the GIS+ as a set of draggable boxes. The user can finalize the callouts in the GIS+ print view and then send the resulting map to a printer or export the map to a PDF file.
4. EIM One
For customers who don’t require the full EIM package, Locus now offers EIM One, which gives the ability to customize EIM functionality. Every EIM One purchase comes with EIM core features: locations and samples; analytical and field results; EDD loading; basic data views; and action limit exceedance reports. The customer can then purchase add-on packages to get just the functionality desired–for example a customer with DMR requirements may purchase the Subsurface and Regulatory Reporting packages. EIM One provides customers with a range of pricing options to get the perfect fit for their data management needs.
5. IoT data support
EIM can now be configured to accept data from IoT (internet of things) streaming devices. Locus must do a one-time connection between EIM and the customer’s IoT streaming application; the customer can then use EIM to define the devices and data fields to capture. EIM can accept data from multiple devices every second. Once the data values are in EIM, they can be exported using the Expert Query tool. From there, values can be shown on the GIS+ map if desired. The GIS+ Time Slider automation feature has also been updated to handle IoT data by allowing the time slider to use hours, minutes, and seconds as the time intervals.
6. CIWQS and NCDEQ exports
EIM currently supports several dozen regulatory agency export formats. In 2019, Locus added two more exports for CIWQS (California Integrated Water Quality System Project) and the NCDEQ (North Carolina Department of Environmental Quality). Locus continues to add more formats so customers can meet their reporting requirements.
7. Improved Water Utility reporting
EIM is the world’s leading water quality management software, and has been used since 1999 by many Fortune 500 companies, water utilities, and the US Government. Locus added two key reports to EIM for Water in 2019 to further support water quality reporting. The first new report returns chlorine averages, ranges, and counts. The second new report supports the US EPA’s Lead and Copper rule and includes a charting option. Locus will continue to enhance EIM for Water by releasing the 2019 updates for the Consumer Confidence Report in January 2020.
8. Improved Non-Analytical Views
Locus continues to upgrade and improve the EIM user interface and user experience. The most noticeable change in 2019 was the overhaul of the Non-analytical Views pages in EIM, which support data exports for locations, samples, field readings, groundwater levels, and subsurface information. Roughly 25 separate pages were combined into one page that supports all these data views. Users are directed through a series of filter selections that culminate in a grid of results. The new page improves usability and provides one centralized place for these data reports. Locus plans to upgrade the Analytical Views in the same way in 2020.
9. EIM search box
To help customers find the correct EIM menu function, Locus added a search box at the top right of EIM. The search box returns any menu items that match the user’s entered search term. In 2020, Locus will expand this search box to return matching help file documents and EDD error help, as well as searches for synonyms of menu items.
10. Historical data reporting in EDD loading
The EIM EDD loader now has a new “View history” option for viewing previously loaded data for the locations and parameters in the EDD. This function lets users put data in the EDD holding table into proper historical context. Users can check for any unexpected increases in parameter concentrations as well as new maximum values for a given location and parameter.
Contact us to see a demo of Locus EIM
SAN FRANCISCO, Calif., 23 July 2019 — Locus Technologies (Locus), the market leader in multi-tenant SaaS water quality, environmental compliance, and sustainability management, today announced that it is going all-in on Amazon Web Services, Inc. (AWS), moving its entire infrastructure to the world’s leading cloud. By moving its flagship product EIM (Environmental Information Management) to AWS this month, Locus will complete its transition to AWS. Locus previously moved its Locus Platform (LP) to AWS in 2018.
EIM is the world’s leading water quality management software used by many Fortune 500 companies, water utilities, and the US Government since 1999. Among its many features, EIM delivers real-time tools to ensure that water utilities deliver clean water to consumers’ taps and don’t discharge contaminated wastewater above allowable limits to groundwater or surface water bodies like streams, lakes, or oceans.
EIM generates big data, and with over 500 million analytical records at over 1.3 million locations worldwide, it is one of the largest centralized, multi-tenant water quality management SaaS systems in the world. With anticipated growth in double digits stemming from the addition of streaming data from sensors and many IoT monitoring devices, Locus needed to have a highly scalable architecture for its software hosting. The unmatched performance and scalability of AWS’s offerings are just the right match for powering Locus’ SaaS.
Because of the scope of its applications, Locus is expecting to leverage the breadth and depth of AWS’s services (including its database systems, serverless architecture, IoT streaming, blockchain, machine learning, and analytics) to automate and enhance the on-demand EHS compliance, sustainability, facility, water, energy, and GHG management tools that Locus’ software provides to its customers.
Running on AWS’s fault-tolerant and highly performant infrastructure will help support Locus’s everyday business, and will scale easily for peak periods, where reporting demand such as GHG calculation engine or significant emissions incidents like spills can skyrocket scalability demand.
By leveraging Amazon CloudFront, Amazon Virtual Private Cloud (Amazon VPC), Amazon Elastic Kubernetes Service (Amazon EKS) and AWS Lambda, Locus is migrating to a microservices architecture to create more than 150 microservices that independently scale workloads while reducing complexity in the cloud, thereby enhancing every element of the customer cloud experience. Locus built a data lake on Amazon Simple Storage Service (Amazon S3) and will leverage Amazon Redshift to analyze the vast amount of data it is storing in the cloud, delivering insights and predictive analytics that uncover chemicals trending patterns and predict future emissions releases at various locations.
Locus intends to leverage AWS IoT services and Amazon Managed Blockchain by building a new native integration to help businesses generate value from the millions of events generated by connected devices such as real-time environmental monitoring sensors and environmental treatment systems controls. AWS IoT is a set of cloud services that let connected devices easily and securely interact with cloud applications like EIM and Locus Platform and other devices. Locus IoT Cloud on AWS allows customers to experience real-time emissions monitoring and management across all their connected sensors and devices. And for customers who want to allow multiple parties to transact (e.g. GHG trading) without a trusted central authority, AWS provides a fully managed, scalable blockchain service. Amazon Managed Blockchain is a fully managed service makes it easy to setup, deploy, and manage scalable blockchain networks that Locus intends to use for emissions management and trading.
For example, a water utility company that maintains thousands of IoT-enabled sensors for water flow, pressure, pH, or other water quality measuring devices across their dispersed facilities and pipeline networks will be able to use Locus IoT on AWS to ingest and manage the data generated by those sensors and devices, and interpret it in real time. By combining water sensor data with regulatory databases, water utility companies will be able to automatically create an emergency shutdown if chemical or other exceedances or device faults are detected and as such, will be better prepared to serve their customers and environment.
By combining the powerful, actionable intelligence in EIM and rapid responsiveness through Locus Platform with the scalability and fast-query performance of AWS, customers will be able to analyze large datasets seamlessly on arrival in real time. This will allow Locus’ customers to explore information quickly, find insights, and take actions from a greater variety and volume of data—all without investing the significant time and resources required to administer a self-managed on-premises data warehouse.
“After 22 years in business, and after evaluating AWS for a year with our Locus Platform, we decided to switch and continue all our business on AWS. We are taking advantage of their extensive computing power, depth and breadth of services and expertise to develop an effective cloud infrastructure to support our growing business and goal of saving the planet Earth by providing and managing factual information on emissions management, all the while reducing operational costs of Locus’ customers,” said Neno Duplan CEO of Locus. “By operating on AWS, we can scale and innovate quickly to provide new features and improvements to our services – such as blockchain-based emissions management – and deliver exceptional scalability for our enterprise customers. With AWS, we don’t have to focus on the undifferentiated heavy lifting of managing our infrastructure, and can concentrate instead on developing and improving apps and services.”
“By organizing and analyzing environmental, sustainability, and water quality information in the cloud, Locus is helping organizations to understand the impact of climate change on drinking water,” said Mike Clayville, Vice President, Worldwide Commercial Sales at AWS. “AWS’s unmatched portfolio of cloud services, proven operational expertise, and unmatched reliability will help Locus to further automate environmental compliance for companies ranging from local water utilities to multinational manufacturing corporations, to federal government research agencies. ”By choosing to go all-in on AWS, Locus is able to innovate and expand globally, developing new solutions that will leverage comprehensive analytics and machine learning services to gain deeper insights and forecast sustainability metrics that will help deliver clean drinking water to consumers around the world.”
In most cities in the US, drinking water quality conforms with the norms of the Safe Drinking Water Act, which requires EPA to set Maximum Contaminant Levels (MCL) for potential pollutants. Besides, the EPA’s Consumer Confidence Rule (CCR) of 1998 requires most public water suppliers to provide consumer confidence reports, also known as annual water quality reports, to their customers.
PFAS stands for “perfluoroalkyl and polyfluoroalkyl substances,” with the most important thing to know that this large group of synthetic chemicals includes perfluorooctanoic acid (PFOA) and perfluorooctane sulfonate (PFOS).
Not Regulated by EPA
When it comes to drinking water from the tap in the US, the phrase that fits concerning PFOA and PFOS is “caveat emptor” (buyer beware). The EPA has not regulated these chemicals. There are no federal regulations for PFOA and PFOS in drinking water in the US.
In May 2016, the EPA established a drinking water “health advisory” of 70 parts per trillion (ppt) for the combined concentrations of PFOA and PFOS. While that was a start, there’s a big difference between a health advisory and a regulation that has teeth. Moreover, many scientists consider 70 ppt too high a limit. Reportedly, the EPA is considering turning its 70 ppt health advisory into regulation.
Meanwhile, some states have stepped up to the plate to protect their residents and visitors better. In April 2019, for instance, the New Jersey Department of Environmental Protection (DEP) proposed maximum contamination levels (MCLs) of 14 ppt for PFOA and 13 ppt for PFOS in the state’s drinking water.
As a water consumer, you should be aware of this crisis, as it has the potential to affect both your health and wealth.
What are PFOA and PFOS?
This toxic couple has contaminated the drinking water supply in areas surrounding some industrial sites and military bases. They’re the most studied of the PFAS group because they’re the ones that have been produced in the most significant quantities in the United States, according to the US Environmental Protection Agency (EPA).
PFOA and PFOS, which repel water and stains of various types, have been used as coatings on fabrics and leather and in the production of stain-repellent carpeting and are found in firefighting foams — which have been used extensively on US military bases for decades — among other products. Moreover, some related polyfluoroalkyl compounds can be transformed into these chemicals in the environment, per the National Institutes of Health (NIH), with the Environmental Working Group (EWG) stating that some perfluorinated chemicals not only break down into PFOA in the environment but also can do so in the human body.
While PFOA and PFOS are no longer made in the US, that hardly matters in our global economy. Both are still produced internationally, which means they end up in our country via imports of consumer goods such as carpet, apparel, textiles, and paper and packaging.
Why all the concern about PFOA and PFOS?
These chemicals — dubbed “forever chemicals” because they’re persistent in the environment and the human body — have been linked to cancer, thyroid disease, weakened the immune system and liver function, low infant birth weight, and other health problems, according to many sources.
And this is what the EPA says: “There is evidence that exposure to PFAS can lead to adverse health outcomes in humans. If humans, or animals, ingest PFAS…the PFAS are absorbed and can accumulate in the body. PFAS stay in the human body for long periods. As a result, as people get exposed to PFAS from different sources over time, the level of PFAS in their bodies may increase to the point where they suffer from adverse health effects.”
In most industrialized cities around the world, drinking water is readily available and safe. Safeguarding groundwater (aquifers), streams, rivers, reservoirs, and lakes is crucial to continue delivering clean water on the tap. So is testing and validated water quality data. There are several aspects of drinking water quality that is of concern in the United States, including Cryptosporidium, disinfection by-products, lead, perchlorates, and pharmaceutical substances.
Recent headlines about water quality issues in cities like Flint, Pittsburgh, Asheville, or Rome and Capetown are motivating consumers to ask more questions about their water quality. Albuquerque’s groundwater is becoming seriously depleted; Fresno’s groundwater is highly susceptible to contamination; In Atlanta, Chicago, Detroit, Houston, Los Angeles, New Orleans, Newark, Philadelphia, Phoenix, San Diego and Washington, D.C., source water is threatened by runoff and industrial or sewage contamination; Water supplies in Baltimore, Fresno, Los Angeles, New Orleans, San Diego, and several other cities are vulnerable to agricultural pollution containing nitrogen, pesticides or sediment.
Locus Technologies IoT Monitoring. Connected at all times.
In most cities in the US, drinking water quality is in conformity with the norms of the Safe Drinking Water Act, which requires EPA to set Maximum Contaminant Levels (MCL) for potential pollutants. In addition, the EPA’s Consumer Confidence Report (CCR) Rule of 1998 requires most public water suppliers to provide consumer confidence reports, also known as annual water quality reports, to their customers. Each year by July 1 anyone connected to a public water system should receive in the mail an annual water quality report that tells where water in a specific locality comes from and what’s in it. Locus EIM automates this reporting and allows utilities to be transparent by publishing CCR online in real time so that consumers have access to their CCR at all times. Consumers can also find out about these local reports on a map provided by EPA.
Utilities must maintain good water quality records and manage them in a secure database with built-in alerts for any outliers so that responsible water quality managers can react quickly when there is exceedance of MCL or another regulatory limit.
[sc_button link=”https://ltweb-stage.locustec.com/applications/industry/water-utilities/” text=”Learn more about our water solutions” link_target=”_self” background_color=”52a6ea” centered=”1″]
Manage all those ops readings without spreadsheets or paper forms
I am constantly reminded by the number of calls we receive, that no matter how robust a SCADA and HMI system is, there is always a requirement for in-field O&M verification and documentation. It’s almost universal, and spans a myriad of industries, large and small, the need to monitor and record thousands of periodic (daily/per shift/weekly, etc.) routine readings/recordings at a prescribed frequency often recorded on pen to paper field forms. The same processes sometimes use “template” spreadsheets for data collection that are then emailed/placed on shared file servers or otherwise sent to some central location for review and post processing. These processes are antiquated and subject to data quality and record keeping challenges.
It’s time for an upgrade!
Why simple form builders are not a good software solution for ops data
Electronic forms are great for collecting data and almost every business entity has built such forms in spreadsheets, word processing or simple databases to collect the information. In addition, there is a software category of form builders and they can certainly build forms. The question becomes is it a good fit so solve your business process issues?
Most customers have more sophisticated needs than simply collecting information on one or more custom forms – they want to do something with all the information collected far beyond what simple form builder tools can provide. Even customers with sophisticated spreadsheet forms, can’t manage them as they multiply exponentially or their Excel gurus retire.
Here are some examples of where you may require software tools beyond a simple form builder:
- Collecting equipment readings on each shift at multiple locations and report the data to centralized management, who review the data, look for trends/ issues.
- Verifying and validating data at the point of data entry to eliminate data entry errors.
- Automatically visualizing (charts or tables) information in near real time to make operations decisions.
- Sharing the information with others.
- Scheduling activities related to periodic or infrequent data collection events.
- Receiving notifications when actions are due.
- Automatically creating regulatory reports in prescribed formats.
- Creating complex work flows and audited approval processes.
- Creating intelligent forms with calculations based on past data or other criteria
Forms with Benefits
Locus Platform is a configurable platform with standard applications that are easy to configure to customers unique requirements. One of its many strengths is its powerful form builder capable of creating simple or complex forms with simple or sophisticated logic. So for customers looking to move from paper and spreadsheet templates, it’s an excellent option to consider, especially if you require more than a simple “fill in the blank” form for transmittal using mobile devices. Best of all, the data are securely stored in a database structure for reporting and alternative business uses and analyses, compared to the almost impossible management of hundreds of spreadsheets or paper forms.
Here are some examples where sophisticated forms are integrated with a flexible database:
- Water Utilities – Tracking chlorination and aerobic digestion processes with daily inputs/outputs with a monthly summary and chart, and tracking well production across well fields.
- Water Utilities – Tracking periodic sewer discharges and water samples for permit compliance.
- Agriculture – Monitoring food processing equipment for compliance with optimum equipment operating parameters for air permits.
- Pharmaceutical/Chemical Manufacturing Facilities- Tracking EHS daily, weekly, monthly, etc. investigations and in-house audits.
- Universities – tracking chemical inventories.
- Facility Engineering – Documenting O&M activities for groundwater treatment systems.
- Electric Utilities – Monitoring water/energy/gas usage from old style meters for sustainability reporting with data entry validation.
- Refineries and Terminals – Collecting O&M, usage and wastewater data.
If you still rely on paper forms and template spreadsheets and are ready to streamline your process and enhance the value of your data, give us a call and we can show you a range of options that will retire the paper forms for good!