Locus Technologies releases new Query Builder tool in Locus EIM

Advanced querying in Locus EIM just got much easier and much more powerful

MOUNTAIN VIEW, Calif., 8 March 2017 — Locus Technologies (Locus), the leader in cloud-based environmental compliance and sustainability management software, is excited to announce the release of the EIM Query Builder tool that is one of a kind in the environmental data management industry. The tool, exclusively in Locus’ EIM environmental information management software, provides users with a graphical “drag-and-drop” interface to design, save, and share customized SQL queries with their teams via the EIM interface. This powerful tool will transform the user experience for Locus EIM customers.

EIM has always allowed users with advanced access and expert knowledge to write custom SQL queries against one site in the database. However, the existing tool required the user to be extremely knowledgeable in both SQL and EIM’s database structure.

The new EIM Query Builder tool allows all users, even those with less knowledge of EIM’s structure and the SQL language, to access their data via an interactive tool for one site, multiple sites, or across a site group. The Query Builder tool saves users’ time through a number of new, useful functions, such as including lists of EIM tables and columns, automatically populating table relationships, joins, and on-the-fly query debugging. It even includes “friendly names” to make table querying even easier. Additionally, users can leverage this new querying efficiency by saving and sharing queries across all user levels. The new version of Query Builder will be available to all customers in Spring 2017 and is included in the basic subscription pricing.

“We believe our EIM users will love this new tool, as it provides the flexibility to dive into the data in any way users wish”, said Wes Hawthorne, President of Locus Technologies. “Many times, experienced data managers need to extract very specific data sets that previously required the use of complex SQL queries. This new tool elevates the experience and provides many extras— including cross-site query and sharing that will greatly streamline advanced querying.”

 

Rethinking Urban Water Management

 

Water utility worker stands among tanks

Improved wastewater distribution and treatment technologies have largely eradicated once-common waterborne diseases.

Water supply and distribution were ranked as the fourth greatest engineering achievement of the 20th century by the National Academy of Engineering (NAE), and rightfully so.

Developments in water management have drastically improved public health and safety.  In the early 1900s, for example, dysentery and diarrhea, both waterborne diseases, were the third largest cause of death in the United States (Wulf, 2000).

Currently, incidences of waterborne diseases in the United States are minimal, thanks in large measure to improved water distribution and treatment technologies.  Additionally, cities are now less susceptible to flooding due to the development and implementation of storm drain systems. The current paradigm in urban water management entails a centralized drinking water plant, connected to individual households through an underground network of pipes, and a sewer that carries the wastewater to a centralized treatment plant for further discharge into a natural water stream.  This system has permitted significant progress in our society.

Our clean water supply and sanitation systems may be endangered

NAE also says that providing access to clean water is the fifth greatest challenge that we will face this century.  Despite all its positive qualities, the urban water management paradigm has some serious limitations that are likely to get worse in the future due to increasing urban population, expansion of paved areas, scarcity of water, and climate change:

  • Reliance on large quantities of water
    Centralized systems depend heavily on large quantities of water— an already scarce resource that will likely become even more so, with increasing population and climate change.  Population growth also requires increasing the capacity of the water treatment plants and expanding the already-complex network of water lines.
  • More runoff
    Fast-growing cities mean larger paved areas and, therefore, higher runoff during rain events.  Runoff, which carries pollutants from the street surface, is difficult and expensive to contain and treat. Many cities— including some cities here in the San Francisco Bay Area— discharge their storm water runoff directly to the sea, with minimal treatment.  If you live in the San Francisco Bay area, you may have noticed blue signs posted next to storm drains, which read “Drains to the Bay”.  Runoff is expected to become an even bigger issue due to the variability in rainfall caused by climate change.
  • Expensive operation and maintenance
    Extensive underground pipe networks for drinking and wastewater are expensive to operate and maintain.  They make urban planning more difficult because pipe locations are not always known, and multiple independent agencies and companies run pipes and cables underground. Furthermore, the lead poisoning in Flint, Michigan, shows us that poorly maintained old pipes can present a serious public health issue.
  • Leaky pipes
    An estimated 10 – 40% of the global urban water supply is lost due to leaky pipes, which are difficult and costly to repair (Larsen et al., 2016)..
  • Lost nutrients
    Centralized water systems are not particularly efficient in recovering the nutrients that wastewater offers (i.e., nitrogen and phosphorous).
In search of a more sustainable solution
Water treatment utility plant

Centralized treatment plants have vastly improved public health, but perhaps a more decentralized urban water management system would address some of their shortcomings.

Across the country and the world, innovative teams have proposed and implemented multiple improvements and alternatives to the current urban water management paradigm.  But there is still no widely-accepted solution to the current and future challenges in urban water management.

A real, sustainable solution would involve a combination of measures adapted to local needs.  One promising approach to replace or supplement our current systems is to decentralize the management of urban water.  This means treating the wastewater close to the source in small-scale treatment systems, instead of transporting it through a complex network of pipes to a centralized treatment plant.  Decentralization offers a series of advantages— such as less reliance on pipes, easier coverage expansion in rapidly growing cities, lower variability in the loading of the treatment systems, and efficient utilization of the wastewater as a resource.

Decentralized systems, for example, offer the opportunity to separate blackwater (urine, faeces, flushwater), brownwater (faeces and flushwater), and greywater (water from washing food, clothes, and dishware, and from bathing)— which would be very complicated in a centralized system, due to the need to install separate pipelines for each.

Separating these sources makes wastewater treatment more efficient, as each of them require different extents of treatment.  It also opens the possibility of water reuse.  For example, greywater can easily be treated at a local scale and reused, therefore saving water and energy.  Source separation also provides the opportunity to recover nutrients from human waste more efficiently.  Urine, for example, contains a high concentration of nitrogen, which is lost as nitrogen gas in most centralized treatment plants.  By separating the urine in a decentralized system, nitrogen could be recovered.

Nevertheless, decentralized systems have their own challenges.  These include the complexity of operating, maintaining, and inspecting a network of treatment systems; the development of reliable and robust small-scale systems; and public acceptance.  Decentralized urban water management is still in its early development, but it’s an idea that certainly deserves further consideration.

Why now?

Historically, major innovations in urban water management have been triggered by crises: the overpopulation of Ancient Rome led to the development of large scale water distribution systems; the cholera and typhoid fever outbreaks in Europe led to the development of disinfection; and the severe pollution of water stream led to development and implementation of wastewater treatment (Sedlak, 2014).  With increasing world population, rapid urbanization, climate change, and a growing scarcity of resources, our current urban water management systems will be under increasingly significant stress.  It is crucial to our health, our safety, and the overall well-being of our society that we anticipate the challenges and start innovating now.

References
Hansen, R. D. (n.d.). Water and Wastewater Systems in Imperial Rome. [online]  <Accessed 16 December 2016>

Larsen, T. A., Hoffmann, S., Lüthi, C., Truffer, B., Maurer, M. (2016). Emerging solutions to the water challenges of an urbanizing world. Science, 352 (6288), pp. 928-933.

National Academy of Engineering. (2008). Grand Challenges for Engineering. National Academy of Science.

San Francisco Public Utilities Commission. (n.d.). Only Drain Down the Rain. [online]  <Accessed on 16 December 2016>

Sedlak, D. (2014). Water 4.0: The Past, Present, and Future of the World’s Most Vital Resource. Yale University Press.

Tilley, E., Ulrich, L., Lüthi, C., Reymond, P., Schertenleib, R., Zurbrügg C. (2014). Compendium of Sanitation Systems and Technologies, 2nd Revised Edition. Swiss Federal Institute of Aquatic Science and Technology (Eawag), Dübendorf.

Wulf, W. A. (2000). Great Achievements and Grand Challenges. The Bridge, 30 (3&4), pp. 5-10.

Still looking for the right EHS software to revolutionize your environmental and compliance initiatives?  Book a demo with us today!

 


Locus environmental engineer Victor Huanambal

About guest blogger— Victor Huanambal, Locus Technologies

Victor Huanambal has been working at Locus for close to two years as an environmental engineer. He graduated from the University of California, Berkeley, in 2014.

At Locus, he is mostly involved in projects related to groundwater remediation, environmental compliance, and greenhouse gases verification.

Different is good—How to find your unique strengths for success in R&D

Periodically, our CEO Blog will host blog contributions from Locus employees, who will be blogging about environmental data, compliance, sustainability, or other topics of interest to our customers and partners. We hope you will enjoy these different perspectives, and we invite you to join in the conversation, either in the comments field below, or on our social media channels:

[sc_icon icon=”facebook” shape=”circle” color=”#ffffff” background_color=”#52a6ea” size=”mdsmall” link=”https://facebook.com/locustechnologies” link_target=”_blank”] [sc_icon icon=”twitter” shape=”circle” color=”#ffffff” background_color=”#52a6ea” size=”mdsmall” link=”https://twitter.com/Locustec” link_target=”_blank”] [sc_icon icon=”linked-in” shape=”circle” color=”#ffffff” background_color=”#52a6ea” size=”mdsmall” link=”https://www.linkedin.com/company/locus-technologies” link_target=”_blank”]


Finding a differentiator for R&D success in cloud SaaS applications

Finding a differentiator for your organization is the key to success in a competitive marketplace.

Anyone in the tech industry will tell you that building software can be a costly endeavor.

On top of the overhead expenses, selling enterprise software means long sales cycles and competing in a crowded field of vendors.

To succeed in this cutthroat environment, you need a differentiator—somewhere your company excels compared to the other players in the field.  This differentiator will be your main focus in every aspect of the business.  It allows you to effectively prioritize and execute your tasks, maintaining an edge on the competition.

Working at Locus, a question I often hear is, “How do you hire and retain top engineering talent, when you’re competing with the big tech titans in Silicon Valley?”

My answer is simple and straightforward: our environmental focus.  Ever since Locus started as a company, our vision has been to deliver technologies that optimize the management of environmental data for our customers.  Our goal is to be the best technology partner for helping our customers manage their environmental footprint.

Locus environmental engineers collaborating with software designers

At Locus, environmental engineers with high domain expertise work closely with software engineers to build solutions that very effectively fulfill our customers’ needs.

To work on Locus’ product development team, you must either be exceptional in cloud/SaaS technologies or in environmental engineering.  Our ability to integrate these two specialties is our differentiator.  Other vendors may have capability in one area, but very few can claim both.

At Locus, these two types of engineers work side by side, collaborating to deliver new software.  This dynamic creates incredible opportunities for engineers to learn new things and experience the satisfaction of being challenged at work.  At the same time, it creates an ideal team to deliver the best products to address the environmental health & safety market.

Recently, our engineering team was working on our vapor intrusion and indoor air management application, built for our customers for compliance and regulatory reporting.  Environmental engineers were best suited for this project because they thoroughly understand the regulatory compliance process.  Having environmental engineers collaborating directly with software designers on the team, rather than relying on consultants, allowed us to quickly design a reliable system for automating GHG tracking.  This is just one example of how we integrate a unique set of skills and expertise in our company.

Projects such as this one help reaffirm my belief that finding a unique differentiator is the key to success.  Find what makes you stand out in the market, and pride yourself on that quality.

Still looking for the right EHS software to revolutionize your environmental and compliance initiatives?  Book a demo with us today!

 


Sandeep Khabiya - Director of Software Engineering

About guest blogger— Sandeep Khabiya, Locus Technologies

Sandeep Khabiya is responsible for driving software development at Locus Technologies in alignment with the company objectives. In his role, he directs the work of a broad range of technical personnel and is a coach and mentor for team members across multiple and diverse projects.

Before joining Locus as the Director of Software Engineering, he spent over 14 year with HP Software leading development of products like IT Governance, Project Management and Cloud Service Automation while working with teams across the globe in US, Czech Republic, India, and China.

San Jose Water Company selects Locus Platform for environmental compliance management

 

SAN FRANCISCO, Calif., 29 November 2016 — Locus Technologies (Locus), a leading provider of cloud-based software solutions to streamline EHS regulation and compliance management, has partnered with San Jose Water Company for an implementation of the Locus Platform.

San Jose Water Company is an investor-owned water utility that serves over one million people in the greater San Jose metropolitan area. San Jose Water Company has been a customer of Locus since 2014, and has been using Locus EIM and Locus Mobile for its drinking water compliance activities. After finding success with their EIM solution, San Jose Water Company is expanding its Locus usage to Locus Platform.

San Jose Water Company will take advantage of the flexibility of the Locus Platform to configure a range of environmental compliance apps for tracking and reporting water discharges and hazardous material inspections, helping Locus to further strengthen its position in the water utilities market. By choosing to build most of their applications themselves, San Jose is taking advantage of Locus Platform’s easy-to-use configuration workbench to create unique and effective solutions. They will be able to use Locus Platform to support compliance with EPA’s Clean Water Act, Clean Air Act, and Resource Conservation and Recovery Act (RCRA).

In addition to tracking discharges and inspections, San Jose Water Company will use Locus Platform’s capabilities for reminders and checklists associated with other compliance requirements. They will also take advantage of Locus Platform’s built-in mobile features to enable their custom apps and streamline data collection throughout their various departments.

Locus Platform’s configurable solution will replace a range of self-built spreadsheet solutions and consolidate the water utility’s environmental compliance in one application. With the built-in configuration flexibility, San Jose Water Company’s Locus Platform will be able to grow and change as new regulatory requirements arise.

“Our recent successes in deploying our software solutions to customers in the water utility industry proves their versatile nature. San Jose Water Company needed a data management system that was tailored to their specific business practices. The Locus Platform allows for full configurability of its data collection tools, workflows, and outputs. By using these tools, the software solution fits the business— not the other way around.” said J. Wesley Hawthorne, President of Locus Technologies. “They were also impressed with their ability to self-configure and manage their own applications, which allows them to add new applications as their needs change.”

ABOUT SAN JOSE WATER COMPANY
San Jose Water Company (SJWC), a wholly owned subsidiary of SJW Group and founded in 1866, is an investor-owned water company headquartered in San Jose and is one of the largest and most technically sophisticated urban water system in the United States. SJWC serves over 1 million people in the greater San Jose metropolitan area comprising about 138 square miles. The utility delivers safe, high quality, and reliable water and exceptional customer service.

Cortina Rancheria selects Locus Technologies’ EIM for its water quality and environmental management system software

The Locus EIM SaaS will streamline the Cortina Rancheria environmental monitoring program under U.S. EPA Clean Water Act


San Francisco, Calif., 1 November 2016 — Locus Technologies, a leader in environmental and compliance enterprise management software, announced today that the Cortina Rancheria Kletsel Dehe Band of Wintun Indians (Cortina Rancheria) has selected Locus EIM as its environmental information management system.

Cortina Rancheria is implementing the Locus EIM SaaS-based software to manage their environmental monitoring under the U.S. EPA Clean Water Act.  Locus EIM will enable the tribe to consolidate and better manage its field, water quality, and air monitoring data, with output reporting to the EPA WQX database.

Locus EIM is a comprehensive environmental data management system designed for the variety and complexity of environmental sampling and analysis. EIM has all the built-in tools necessary for any environmental media sampling event, and it includes a powerful, integrated mobile application to streamline data acquisition.  With built-in sample planning, laboratory data upload, and a wide range of reporting and visualization tools, EIM is a complete solution for any environmental monitoring and reporting need and an excellent fit for natural resources monitoring.

“As the U.S. EPA recently approved the Cortina Rancheria Kletsel Dehe Band of Wintun Indians’ right to develop tribal water quality standards, the timing for EIM implementation is perfect.  Their use of EIM will help achieve their environmental stewardship goals by providing them the software tools to efficiently manage their water quality and tribal resources” said Wes Hawthorne, President of Locus.  “Our EIM software will also support their need to upload data to the EPA’s systems in a timely and efficient manner”.

ABOUT CORTINA INDIAN RANCHERIA
Cortina Rancheria is a federally recognized tribe, enacted in 1907 by order of the U.S. Secretary of the Interior.  The Tribe has a formally adopted constitution and is governed by a duly elected five (5) member Tribal Council, overseen by the General Council.  The Rancheria is located approximately seventeen (17) miles southeast of Williams, CA at the base of the Western Foothills.  The Rancheria consists of 640 acres of sovereign land and resources and has over 200 Tribal members.

Improving Arsenic detection and keeping it out of drinking water

Arsenic, a naturally occurring element, is one of the many drinking water contaminants actively monitored by drinking water systems because it can result in adverse health conditions, including an increased risk for a range of cancers. U.S. EPA and the U.S. Bureau of Reclamation (USBR) are joining forces to launch the Arsenic Sensor Prize Competition for the development of new technology to detect arsenic in water. If you are interested in participating you can read more here:

https://blog.epa.gov/blog/2016/09/were-sensing-a-change-in-water-monitoring-introducing-the-arsenic-sensor-prize-competition/

The use of arsenic as a poison is widely documented. As a result, many people are alarmed when they hear that their drinking water, either from a public or private water system, may contain any amount of arsenic. Exposure to arsenic in drinking water at the level the U.S. Environmental Protection Agency (EPA) currently deems as safe in the United States (10 parts per billion) still may induce adverse health outcomes. The U.S. EPA recently lowered the Maximum Contaminant Level (MCL) for arsenic to 10 µ/L in public water supplies—a regulated level that is considered “safe” for a lifetime of exposure—yet concentrations of 100 µ/L and higher are commonly found in private, unregulated well water in regions where arsenic is geologically abundant, including upper New England (Massachusetts, New Hampshire, Maine), Florida, and large parts of the Upper Midwest, the Southwest, and the Rocky Mountains.

Arsenic is a natural component of the earth’s crust and is widely distributed throughout the environment in the air, water and land. It is highly toxic in its inorganic form.

Arsenic in drinking water.

Measuring and testing for arsenic require expensive instruments and lab work, as well as time. However, with new and emerging technologies, a more efficient arsenic monitoring technology could help to improve the monitoring system, reduce costs, and better protect human health and the environment. Typically, samples are sent to a laboratory for analysis, with results available days to weeks later. New technology could accelerate this process by allowing for immediate detection of arsenic in water. This could reduce monitoring costs and help water utilities more effectively control treatment to remove arsenic from the drinking water supply.
The Arsenic Sensor Prize Competition aims to improve the existing process with upcoming and emerging technology. The competition is not exclusively restricted to sensor developers but seeks applicants from all fields, including information technology. For example, besides sensor technologies, a new data collection and transmission technologies such as Internet of Things (IoT) can also accelerate water quality characterization process or better data management, visualization, and reporting via cloud-based SaaS technologies. Applicant criteria include anyone with ideas for how to rapidly, accurately, and cost-effectively measure arsenic in water.

Locus Technologies is a software company that specializes in providing a SaaS-based solution for water quality management. Arsenic is one of  a key and prolific contaminants in our vast water quality databases. We have a keen interest in supporting this excellent and timely competition to help find a way to automate detection and data collection of arsenic and other contaminants in real time. To help shed some light on the  importance of arsenic in drinking water, we performed a quick check on a total number of arsenic records, hits, and locations across all customers in Locus SaaS EIM (Yes multi-tenant SaaS as otherwise, this statistic would be impossible to gather). This is what we found:

Total number of analytical records: >520,000,000
Number of Arsenic Records: 248,850
Number of Arsenic hits (above action limit MCL of 10 µ/L): 112,597
Number of Arsenic locations: 19,304

If you have ideas and  are interested in helping protect our nation’s drinking water, Locus encourages you to participate. We will have a special prize for the winner.

Aviation industry agrees to cap CO2 emissions, other transportation industries to follow

The first deal limiting greenhouse gasses from international aviation has been sealed after years of negotiations. Carbon emissions from international aviation will be capped under a global agreement to limit the impact of commercial flights on the climate. The deal launches a voluntary compliance system from 2021 that would become mandatory in 2027. Airlines spent about $181 billion on fuel last year, and this deal would add between $5 and $24 billion in additional costs, depending on the price of carbon at the time. The aviation carbon cuts were agreed in Montreal by national representatives at the International Civil Aviation Organization, ICAO.

The deal comes in a critical week for climate policy when the Paris agreement to stabilize climate change passed a key threshold for becoming law. International aviation is responsible for putting more carbon dioxide into the atmosphere every year than the whole of the Germany or the UK. And until now, there has been no global consensus on how to address aviation emissions.

CO2 will be allowed to grow to 2020, but after that, emissions will need to be offset. The deal will be voluntary to 2026, but most major nations are expected to take part. Airlines that pollute more than the prescribed level after 2020 would have to purchase carbon-offsetting credits.

The offsetting proposal is especially controversial. Airlines are striving to make planes more efficient, but the industry can’t innovate fast enough to contain its dynamic growth.

That led to the proposal for offsetting – but sometimes offsetting by planting trees is not enough and is prone to double-counting.

One way to offset emissions, besides planting trees, is using trees’ and other plants spoils to make sustainable fuels. The effort to use sustainable fuels has already started, and manufacturers and airlines support of alternative fuels is high.

To that end, the US biofuels leader, Amyris, Inc is developing an alternative aviation jet fuel made with a sustainably-sourced hydrocarbon using Amyris’s proprietary synthetic biology platform. It is one of the most promising developments in aviation fuels in decades.

Amyris’ jet fuel can reduce greenhouse gas emissions by up to 80 percent compared with petroleum fuels, when compared unmixed to petroleum fuels on a one-to-one basis, according to Amyris.

Attempts have been made for nearly two decades to include aviation and shipping in the UN’s climate agreements, but both sectors have managed to avoid firm targets.

US EPA earlier this year issued a final scientific assessment that concluded that carbon emissions from aircraft endanger public health and welfare, a legal prerequisite the agency must take before regulating those emissions in the US. It is widely expected that EPA will introduce its set of rules for regulating domestic aircraft emissions in the US. Domestic aviation represents about 40% of total carbon-dioxide output from commercial flights.

Environmental groups said they hope the action to curb airline emissions will spur a similar cap on maritime CO2 production. Maritime emissions aren’t covered by the Paris climate deal even though the industry is considered a major carbon emitter.

All these emissions trackings must be managed and verified and will require companies to install scalable and intelligent database systems like Locus SaaS-based EIM and Locus Platform that already help many companies comply with various emission laws and regulations around the world.

Locus Technologies introduces EIM GIS+ mapping platform with added features and functionality

Locus EIM GIS+ builds on the original Google Maps-based GIS — with new powerful cartography, interoperability, and smart-mapping technology

MOUNTAIN VIEW, Calif., 6 October 2016 —Locus Technologies (Locus), a leader in SaaS environmental compliance and information management software, introduces the Locus GIS+ mapping platform, a significant upgrade to the current Locus EIM Google Maps-based solution. Locus GIS+ is powered by Esri’s ArcGIS platform and offers a host of advanced features— including enhanced cartography, comprehensive spatial data analysis, and ability to use the customer’s own map through integration with ArcGIS Online and Portal for ArcGIS.

With GIS+, Locus gives users all the tools they need to make professional-looking maps and perform a wide range of data analysis. The new platform is based largely on customer requests and feedback, and it includes an improved user-friendly interface, as well as many new features that are standard in advanced mapping applications. By adding options such as a variety of base maps and hundreds of customizable symbols, advanced editing and label placement, as well as Esri map integration with the customer’s own base layers, Locus GIS+ provides a complete environmental data analysis and mapping solution for Locus EIM users.

Other notable new functionality includes the ability to save multiple query result layers; customizable graduated symbols, color ramps, and histograms to better control how query results display; improved ad hoc location group creation; and more user control over map layer styles and sequencing. The upgraded GIS+ platform is fully compatible with any existing EIM site, and existing customer maps will be seamlessly transferred from Locus’ Google Maps-based GIS to the new GIS+.

GIS+ will be available as an add-on purchase to Locus EIM. It will be open for existing customers to test drive in a free trial period during the 4th quarter 2016, along with an introductory webinar to highlight the power of GIS+. As always, the current Google-based GIS mapping will remain available to all EIM customers.

“GIS mapping capability is essential for all environmental data analysis. Locus GIS is great for quick data visualization, but Locus GIS+ is a quantum leap forward with advanced analysis tools and analysis tools that use Esri’s Smart Mapping technology, and we are sure our customers will be ecstatic with the new features. The features of GIS+ will make a substantial difference in the work that our clients do, as the new features allow for better visualization, better outputs, and better outcomes— all integrated within EIM,” said Wes Hawthorne, President of Locus.

Learn more about GIS+ on our website.

Locus Technologies creates IoT interoperability with Locus Platform

Locus helps customers leverage data, analytical, cloud, and mobile capabilities via IoT-to-Locus SaaS platform


MOUNTAIN VIEW, Calif., 9 August 2016 — Locus Technologies (Locus), the industry leader in cloud-based EHS software, announced today that its multi-tenant SaaS Platform fully interoperates with the Internet of Things (IoT). The company has been the pioneering innovator in the EHS software space since 1999 when it first introduced its Automation and Data Management Groups, which used Internet-based technologies to manage and control vast amounts of data generated at the company’s customer sites.

Locus’ automation technologies have evolved over the years to encompass the vast array of Internet-connected devices, sensors, programmable logic controllers, and other instruments to gather and organize large amounts of streaming data.

The IoT interconnects uniquely identifiable embedded computing, testing, and monitoring devices within the existing Internet infrastructure and software platform. Locus IoT services offer connectivity beyond machine-to-machine communications and cover a variety of protocols, domains, and applications.

“The IoT is one of the fastest-growing trends in tech. When applied to the environmental monitoring industry, there is an overwhelming influx of information that has to be dealt with; many companies are concerned that the sheer volume of data will render the information useless. For that reason, Locus invested in smart software and intelligent databases to deal with this new trend, long before IoT had a common name. We aspire to change the face of the environmental monitoring industry,” said Neno Duplan, CEO of Locus.

In any industry, when all incoming data are connected and centrally accessible through a multi-tenant SaaS application, the flow of information is much more efficient and effective. For example, instead of having a separate data collection protocol from software applications for water quality management, waste management, GHG management, EHS compliance and incident management, a company can have all emissions-related records—regardless of whether they originated in the laboratory, field, or Internet-connected monitoring device—in a single system of record. From this single system of record, they can manage compliance activities, perform data gathering and monitoring, manage water treatment systems remotely, and manage resources for sustainability reporting at the same time. Adopting such a structure offers Locus’ customers the ability to converge all incoming sources of information to create a much-needed integrated enterprise platform for EH&S+S management.

At the crux of this integration is Locus’ highly scalable and end-user configurable Locus Platform. The interoperability combines the Locus Platform as a service with its automation, mobile, and IoT platforms. The combined IoT suite will be hosted on Locus’ cloud.

“By combining our cloud platform and Internet of Things (IoT) platforms to make them interoperable, we provide the single platform for our customers that helps them lower their operational costs, reduce cycle time, and ultimately become better stewards of the environment. This integration will give our customers more analytics from connected devices,” added Duplan.

Making water quality data more transparent: Lessons from an annual water quality report

 

A few weeks ago, I received my water bill in the mail, right on schedule. But this time, it came with a glossy pamphlet containing the annual water quality report. Normally I just toss it into the trash unread. It’s full of small print and lots of numbers, and I was never that concerned about our water quality.

I live in the NC mountains, where the water comes from “pristine mountain springs and streams”. And having grown up in New Orleans— spending 21 years drinking water from the polluted tail end of the Mississippi River— I figured any damage was already done. (But that New Orleans water sure was tasty!)

This time, though, I actually read the entire report. I’d heard about recent water issues in Flint, MI, and other cities, and I do have children who drink the water here. So I looked at this City of Asheville water quality report in detail, and here’s what I discovered.

The report contains a lot of rather informative text about how the City of Asheville treats its water and what possible risks could be present from various contaminants. The centerpiece of the report is a table that lists detected substances in the water. In 2015, 13 substances were detected out of 150 substances sampled for, and those 13 were “well within safe levels”. That sounded good.  But then I started looking at the report and wondering about certain things…

Let’s start with lead. The report has this:

City of Asheville water quality report- lead measurements

City of Asheville’s 2015 Water Quality Report: Lead, ppb

The “Highest Level Allowed” (the maximum contaminant level, or MCL) is 15 parts per billion (ppb). I did some searching and found a good article explaining lead sampling in water. If over 10% of tests come back over that level of 15 ppb, then the water utility must warn residents.

Asheville seems to have passed this test (only one sample exceeded the action level). However, the article mentioned above also describes how the tests for Flint, MI had possible problems because the Michigan Department of Environmental Quality threw out two samples.  With those samples included, the number of samples over the limit would have exceeded 10%, and water customers would have received a much earlier warning of possible lead issues.

So, back to Asheville. Were any samples thrown out— and if so, why? That information is not in the report.

Let’s take one more example: hexavalent chromium. Here is the City of Asheville report:

City of Asheville water quality report- hexavalent chromium measurements

City of Asheville’s 2015 Water Quality Report: Hexavalent Chromium, ppb

So, the average hexavalent chromium level in the water is 0.05 ppb. But there is no action level given, and the EPA definition text says nothing about any possible side effects. Through more searching, I learned that although hexavalent chromium is a carcinogen, the US EPA does not have a maximum contaminant level (MCL) for this compound.

California has a public health goal of 0.02 ppb, but North Carolina has a public health goal of 0.07 ppb. So, how would I interpret the Asheville value of 0.05 that falls in the middle of those two numbers? At least the report provides the detected range (ND – 0.08), so the maximum level in any sample was only a bit higher than the 0.07 level.

These two examples are not meant to disparage Asheville’s Annual Water Quality Report— it is a great way to deliver some basic information to water users. But for motivated water users, the report will lead to other questions— to answer these questions would require more context or a deeper dive into the actual data. Also, while I’m personally fairly tech-savvy and scientifically literate, many water users may lack the numerical and verbal literacy skills needed to understand the report.

For some closing thoughts:

  • How can water utilities make their sample data more transparent and available to users who want to take the “deeper dive”? How can users learn about sampling processes and decisions made— for example, “were any lead samples rejected, and why?”
  • How do users evaluate risks from compounds without EPA maximum contaminant levels, especially when states and regulators have conflicting levels?
  • How do water utilities present trend information and changes in water quality procedures over time? The 2015 report only shows data from that year. I dug up some older reports and found that hexavalent chromium was not detected at all in 2014. So what caused the detects in 2015? Also, lead was sampled at 100 sites in 2014, but only 50 sites in 2015.  Why was the number of samples cut in half?
  • How do you balance presenting too much information to the public (causing information overload) with presenting too little (causing users to be uninformed about quality issues)? Is there a way to show key information, but let users drill down into actual sampling data results for further details?
  • As a follow up to that last question— if you allow public access to sampling data, how do you ensure customers can interpret that data correctly, if those customers lack knowledge of sampling processes and any statistical techniques used?
  • Can the power of the internet be harnessed to distribute this data and make it understandable to customers? Are there tools that customers can use to explore the data on their own and see key findings and trends? I could not find anything online for Asheville.
  • Finally, given that a certain level of technical understanding is needed to read the Annual Report and explore any actual data— do we need a neutral party to serve as interpreter and interlocutor for the public when dealing with water utilities? Who would play that role?

Other Locus contributors will explore some of these issues in future posts.  In the meantime, please share your own thoughts and ideas in the comments section below.

 


Locus employee Todd Pierce

About guest blogger— Dr. Todd Pierce, Locus Technologies

Dr. Pierce manages a team of programmers tasked with development and implementation of Locus’ EIM application, which lets users manage their environmental data in the cloud using Software-as-a-Service technology. Dr. Pierce is also directly responsible for research and development of Locus’ GIS (geographic information systems) and visualization tools for mapping analytical and subsurface data.