An EHS&S Look Into the Tech Used in the Iowa Caucuses

The Importance of User Implementation and Quality Assurance from an EHS&S Software Provider

After reading about the IowaReporterApp used during the 2020 Iowa caucuses, it struck me how remarkably similar it is in intended function to the EHS&S software developed by my employer, Locus Technologies. Both their application and Locus’ mobile technology collect large quantities of sensitive data from several remote users at multiple facilities, allowing for instant calculation and reporting. What surprised me though, is just how vastly different their user implementation and data management methodology was from what is standard operating procedure at Locus.

In this blog, I will highlight some of the pitfalls of the IowaReporterApp, and compare it to Locus’ EHS&S software. Note, this article is not a political critique, but is an examination of data collection and data quality methods used during the caucuses.

Complex data - Data stewardship

Implementation

Users were introduced to the IowaReporterApp just days before the caucuses and received no app-specific training. Many users were downloading the application on the night of the caucuses.

The Iowa caucuses have been held biennially for almost a half-century as the first major contest of the primaries. The date of the caucuses was a surprise to no one. As a result, app development deadlines should have given enough time for user implementation, through one-on-one training or presentations with appropriate support staff. If app deadlines were not met, there should have been a fallback to redundant reporting systems, like in the case of Nevada, who were also planning to use the app but have opted out after the debacle in Iowa.

When Locus introduces new users to our software, we take implementation seriously. Our customer support team is composed of domain experts who have actively built and used Locus software. We know the deadlines and the problems users typically face during the implementation process. From one-on-one and on-site training to quick turnaround, our support team does everything they can to ensure that users are comfortable with our product as soon as possible.

Complex data - Software quality assurance

Untested Software/Quality Assurance

User implementation deadlines are all the more important given that the software had no real-world use to this point. While it is not advisable to go live with untested software, at the very least, having users stress test a product before field-use could have staved off a few issues.

This is something we see frequently with newer products and newer companies. Locus has over 20 years of experience creating EHS&S software used by U.S. government organizations and Fortune 500 companies. Our quality assurance team rigorously tests any update we bring to customers and doesn’t rush changes to sell a platform update, since every user is always on the same version of Locus software.

Complex data - Data redundancy

Data Redundancy

No one can question that Excel or Google Spreadsheets can perform math correctly, but what is frequently overlooked or not even considered, are the macros, custom functions, and calculations that are often added to spreadsheets when deployed for managing data and other tasks. If one fails, there need to be backups for reporting and storing data.

When the untested application predictably failed, users flocked to the phone lines as a redundancy. Manual data collection on such a scale created confusion and could not carry the load, and had no way of accounting for errors in data entry. At Locus, we understand the importance of EHS&S data, and maintain backups and full audit trails for all critical data, with quick restoration available so you can keep going if anything should happen.

Complex data - Security

Security

The IowaReporterApp was not released in time to get approval in Apple’s app store, and it was sent out through beta testing platforms which required suspension of smartphone security settings.

ProPublica, a nonprofit organization who produces public interest investigative journalism, did a report on the security of the IowaReporterApp after the Iowa Caucuses. Shockingly, they found security problems to be “elementary” and that the app was so insecure that vote totals, passwords, and other sensitive information could have been intercepted or changed. Luckily, there seems to be no evidence of hacking or tampering with results.

Locus understands the need for security with sensitive data, and hosts our entire infrastructure in the most secure and reliable cloud, Amazon Web Services. AWS has an unmatched portfolio of cloud services that Locus fully utilizes to the benefit of their customers.

Complex data - Data entry

Summary

Overall, I think that the mishaps related to the IowaReporterApp show just how easy it is for a data collection and management application to fail if not properly implemented and ran by those with years of practical expertise. Subverted data quality will always be extremely costly to your organization, both financially and otherwise, and should be avoided unequivocally.


Locus Technologies was founded in 1997. Locus’ environmental data management software currently handles over a half billion sensitive records taken from over one million unique locations and is used hundreds of organizations including the government agencies and Fortune 500 companies. Aaron Edwards received his bachelor’s degree in Political Science from UNC Asheville and is Marketing Associate for Locus Technologies. He is an active voter, and is unaffiliated with any political party.

Why Locus?

Locus Technologies receives prestigious EBJ Award for 14 consecutive years

Environmental Business Journal (EBJ) recognized the firm for growth and innovation in the field of Information Technology

MOUNTAIN VIEW, Calif., 10 February 2020

Locus Technologies, leading provider of environmental management and EHS software, was awarded a 14th consecutive award from Environmental Business Journal (EBJ) for growth and innovation in the field of Information Technology.

EBJ is a business research publication providing strategic business intelligence to the environmental industry. Locus received the 2019 EBJ Award for Information Technology by expanding their software and services.

Among the key drivers for Locus in 2019 was the growth of key software applications for waste and sustainability, as well as the introduction of their facilities management app. Locus software also now further integrates with EPA compliance systems like CMDP, eManifest, and eGGRT. Finally, in terms of services, Locus achieved over 500 GHG verifications under the California AB32 program, being the first company to do so. They were also among the first independent bodies to become certified for the new California Low Carbon Fuel Standard verification.

“We would like to express our gratitude for receiving the EBJ Information Technology award for another year. We look forward to providing our customers with cutting-edge software and services as we seek to improve in the areas of artificial intelligence, IoT integration, and blockchain technology,” said Wes Hawthorne, President of Locus Technologies.

How to extend your EHS software with integrated systems

Integration with other systems, whether on-premises or in the cloud, has become a key wishlist item for many EHS software buyers. It allows you to take advantage of other tools used by your organization (or available from third parties) to simplify processes, access information, and enhance communication, both internally and externally.

Locus Technologies obtains accreditation as verification body for Low Carbon Fuel Standard (LCFS)

Locus staff continue to prove expertise in this emerging compliance area with accredited staff throughout California and the Midwest. 

MOUNTAIN VIEW, Calif., 27 January 2020
Locus Technologies, (Locus), industry leader in water quality, EHS, sustainability, and compliance management software, is pleased to announce they are among the first accredited verification bodies for the Low Carbon Fuel Standard (LCFS) program administered by the California Air Resources Board (CARB). Locus verifiers were accredited for fuel pathway applications, alternative fuel transactions, and petroleum-based fuel reports.

Originally adopted in 2009, the goal of the LCFS program is to reduce the carbon intensity (CI) of the transportation fuel pool. The LCFS is one of the key AB 32 measures to reduce greenhouse gas emissions in California, while reducing petroleum dependency and achieving improved air quality. The program has grown in scope, and certified third-party verifiers can now review both applications and routine reporting.

Locus Technologies has been a certified third-party reviewer of GHG verifications for CARB since 2010 under the Mandatory Reporting Rule and maintains an unmatched track record. Not one of over 500 GHG verifications by Locus has been overturned, a standard the company intends to match with LCFS reporting.

Locus has staff and expertise to review Tier 1 fuel pathway applications and annual reports under LCFS as well as other LCFS projects, with verifiers located in San Francisco, San Jose, Sacramento, Los Angeles, and in the Midwest. Locus also offers software products designed to assist reporters in complying with the LCFS program.

Why Companies Replace Their EHS&S Software Systems

A recent NAEM study explored the main reasons EHS&S professionals look to replace their current software configuration. Among the most reported issues were overall performance, customer support, and software customization. The following infographic highlights both why EHS&S professionals are seeking new software, and wheat criteria are most important in shopping for a new software system.

locus_infographic_why-companies-replace-software-1

 

Top 10 OSHA Cited Violations of 2019

OSHA has released their most cited violations of the 2019 fiscal year, and perhaps unsurprisingly, the same mistakes are being made year after year. They are:

  1. Fall Protection – General Requirements (1926.501)
  2. Hazard Communication (1910.1200)
  3. Scaffolding – General Requirements (1926.451)
  4. Control of Hazardous Energy – Lockout/Tagout (1910.147)
  5. Respiratory Protection (1910.134)
  6. Ladders (1926.1053)
  7. Powered Industrial Trucks (1910.178)
  8. Fall Protection – Training Requirements (1926.503)
  9. Machine Guarding– General Requirement (1910.212)
  10. Personal Protective and Lifesaving Equipment – Eye and Face Protection (1926.102)

With over 30,000 cumulative violations for the top ten alone, and the same mistakes being cited repeatedly, there is an obvious need for an EHS software solution that provides a number of tools to prevent these missteps from being made. From configurable smart notifications to follow-up assignments when accidents, near misses, or when other incidents are logged, Locus EHS&S compliance software offers assurance that your safety procedures can be followed promptly and correctly.

 

 

Top 10 Enhancements to Locus Environmental Software in 2019

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.

Infographic: 6 Benefits of EHS on AWS

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.

Locus Single Sign On (SSO)

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.

Locus GIS+ Data Callouts

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.

EIM One Packages

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.

Locus IoT Data

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.

CIWQS and NCDEQ Exports

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.

Locus Water Utility Reporting

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.

Non-analytical views in Locus EIM

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.

Locus EIM Quick Search

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.

Historical Data in Locus EIM

 

Top Enhancements to Locus EHS Compliance Software in 2019

Let’s take a look back on the most exciting new features and changes made in Locus Platform during 2019!

California’s Low Carbon Fuel Standard Program

Last week Locus attended the first training session offered by California Air Resources Board (CARB) for verifiers under the California Low Carbon Fuel Standard (LCFS) program. The California LCFS program has been ramping up over the past several years, and is now ready to start certifying third-party verifiers to review both applications and routine reporting.

The LCFS program is part of California’s initiative to meet the AB32 requirements of reducing overall greenhouse gas emissions to 1990 levels by 2020, and 40% lower than that level by 2030. LCFS is specifically intended to address emissions from transportation fuels in California, which are approximately half of the overall emissions statewide. Like the Greenhouse Gas Mandatory Reporting Rule and Cap-and-Trade programs that preceded it, the California LCFS program uses a market-based approach to incentivize innovation and new approaches to reduce emissions.

LCFS Expert Seth Lalonde at the California Air Resources Board Training

Seth Lalonde, Locus Environmental Scientist, at the California Air Resources Board Training

The program covers a wide variety of projects, including production of alternative fuels (e.g. renewable diesel and biogenic compressed natural gas), innovative approaches to fossil fuel production and refining, and direct carbon capture and sequestration. Fuels are assigned a carbon intensity based on overall carbon dioxide emissions over the entire life cycle, from production to processing to shipping to consumption. The carbon intensity is essentially a measure of the emissions from the fuel per unit of energy. The lower the carbon intensity value, the less impact the fuel has in terms of carbon emissions. Certain fuels can even have a negative carbon intensity, which essentially means the fuel production process is absorbing more carbon than is eventually emitted to the atmosphere (such is the case for compressed or liquefied natural gas produced using biomethane from manure collection). The program also has impacts well outside the California border. After all, fuel that is eventually used in California can originate anywhere in the world, and the LCFS program allows for these projects to obtain credits regardless of their location.

Unsurprisingly, California was the first state to adopt and implement a LCFS program, and the first to establish a third-party verification program specific for LCFS. Although it was clearly the first presentation of this training material, staff from CARB as well as the Climate Action Reserve and The Climate Registry were on hand to assist in addressing questions and topics that weren’t covered in the prepared materials. And considering the wide variety of LCFS project types and the disparate backgrounds of attendees for the verification training, they did a great job of getting everyone all the information they needed to understand and verify these projects.

For those participating in the LCFS program or considering projects under the program, there are a few key things to keep in mind.

First and foremost, like any market-based emission program that includes a verification or auditing requirement, transparency is critical. The verifiers are trained to dig deep into your data, and not to take ‘no’ for an answer. Be prepared to have your metadata and documentation assembled and easily made available to the verifier. (For more on Transparency in Reporting, view this webinar)

Second, the LCFS program includes requirements for continuous or near-continuous monitoring for many parameters, and instrumentation capable of electronic data archival. Manual data records and transcription are still acceptable under other carbon offset programs, but under LCFS these options are no longer allowed. Be sure that your instrumentation is consistent with the specific LCFS requirements, or you’ll be seeing a non-conformance from your verifier.

There were many other tips and common pitfalls highlighted during the training for specific LCFS project types. Overall, I’m very excited to see how the LCFS program evolves in California, and how the energy industry takes advantage of these incentives to provide new options for transportation fuels that will reduce carbon emissions.

Update: Locus is now an approved verification body for the Low Carbon Fuel Standard. Learn more here.

 

Mapping All of Space and Time

Today is GIS Day, a day started in 1999 to showcase the many uses of geographical information systems (GIS). To celebrate the passage of another year, this blog post examines how maps and GIS show time, and how Locus GIS+ supports temporal analysis for use with EIM, Locus’s cloud-based, software-as-a-service application for environmental data management.

Space and Time

Since GIS was first imagined in 1962 by Roger Tomlinson at the Canada Land Inventory, GIS has been used to display and analyze spatial relationships. Every discrete object (such as a car), feature (such as an acre of land), or phenomenon (such as a temperature reading) has a three-dimensional location that can be mapped in a GIS as a point, line, or polygon. The location consists of a latitude, longitude, and elevation. Continuous phenomenon or processes can also be located on a map. For example, the flow of trade between two nations can be shown by an arrow connecting the two countries with the arrow width indicating the value of the traded goods.

However, everything also has a fourth dimension, time, as locations and attributes can change over time. Consider the examples listed above. A car’s location changes as it is driven, and its condition and value change as the car gets older. An acre of land might start covered in forest, but the land use changes over time if the land is cleared for farming, and then later if the land is paved over for a shopping area. The observed temperature at a given position changes with time due to weather and climate changes spanning multiple time scales from daily to epochal. Finally, the flow of trade between two countries changes as exports, imports, and prices alter over time.

Maps and Time

Traditional flat maps already collapse three dimensions into two, so it’s not surprising that such maps do not handle the extra time dimension very well. Cartographers have always been interested in showing temporal data on maps, though, and different methods can be employed to do so. Charles Minard’s famous 1861 visualization of Napoleon’s Russian campaign in 1812-1813 is an early example of “spatial temporal” visualization. It combines two visuals – a map of troop movements with a time series graph of temperature – to show the brutal losses suffered by the French army. The map shows the army movement into Russia and back, with the line width indicating the troop count. Each point on the chart is tied to a specific point on the map. The viewer can see how troop losses increased as the temperature went from zero degrees Celsius to -30 degrees. The original thick tan line has decreased to a black sliver at the end of the campaign.

Minard's map

Charles Minard’s map of Napoleon’s Russian campaign in 1812-1813.

The Minard visual handles time well because the temperature chart matches single points on the map; each temperature value was taken at a specific location. Showing time changes in line or area features, such as roads or counties, is harder and is usually handled through symbology. In 1944, the US Army Corps of Engineers created a map showing historical meanders in the Mississippi River. The meanders are not discrete points but cover wide areas. Thus, past river channels are shown in different colors and hatch patterns. While the overlapping meanders are visually complex, the user can easily see the different river channels. Furthermore, the meanders are ‘stacked’ chronologically, so the older meanders seem to recede into the map’s background, similar to how they occur further back in time.

Alluvial Valley

Inset from Geological Investigation of the Alluvial Valley of the Lower Mississippi River.

Another way to handle time is to simply make several maps of the same features, but showing data from different times. In other words, a temporal data set is “sliced” into data sets for a specific time period. The viewer can scan the multiple maps and make visual comparisons. For example, the Southern Research Station of the US Forest Service published a “report card” in 2011 for Forest Sustainability in western North Carolina. To show different land users over time, small maps were generated by county for three years. Undeveloped land is colored green and developed land is tan. Putting these small maps side by side shows the viewer a powerful story of increasing development as the tan expands dramatically. The only drawback is that the viewer must mentally manipulate the maps to track a specific location.

Buncombe County land use map

Land Use change over time for Buncombe County, NC

GIS and Time

The previous map examples prove that techniques exist to successfully show time on maps. However, such techniques are not widespread. Furthermore, in the era of “big data” and the “Internet of Things”, showing time is even more important. Consider two examples. First, imagine a shipment of 100 hazardous waste containers being delivered on a truck from a manufacturing facility to a disposal site. The truck has a GPS unit which transmits its location during the drive. Once at the disposal site, each container’s active RFID tag with a GPS receiver tracks the container’s location as it proceeds through any decontamination, disposal, and decommission activities. The locations of the truck and all containers have both a spatial and a temporal component. How can you map the location of all containers over time?

As a second example, consider mobile data collection instruments deployed near a facility to check for possible contamination in the air. Each instrument has a GPS so it can record its location when the instrument is periodically relocated. Each instrument also has various sensors that check every minute for chemical levels in the air plus wind speed and temperature. All these data points are sent back to a central data repository. How would you map chemical levels over time when both the chemical levels and the instrument locations are changing?

In both cases, traditional flat maps would not be very useful given the large amounts of data that are involved. With the advent of GIS, though, all the power of modern computers can be leveraged. GIS has a powerful tool for showing time: animation. Animation is similar to the small “time slice” maps mentioned above, but more powerful because the slices can be shown consecutively like a movie, and many more time slices can be created. Furthermore, the viewer no longer has to mentally stack maps, and it is easier to see changes over time at specific locations.

Locus has adopted animation in its GIS+ solution, which lets a user use a “time slider” to animate chemical concentrations over time. When a user displays EIM data on the GIS+ map, the user can decide to create “time slices” based on a selected date field. The slices can be by century, decade, year, month, week or day, and show the maximum concentration over that time period. Once the slices are created, the user can step through them manually or run them in movie mode.

To use the time slider, the user must first construct a query using the Locus EIM application. The user can then export the query results to the GIS+ using the time slider option. As an example, consider an EIM query for all benzene concentrations sampled in a facility’s monitoring wells since 2004. Once the results are sent to the GIS+, the time slider control might look like what is shown here. The time slices are by year with the displayed slice for 3/30/2004 to 3/30/2005. The user can hit play to display the time slices one year at a time, or can manually move the slider markers to display any desired time period.

Locus GIS+ time slider

Locus GIS+ time slider

Here is an example of a time slice displayed in the GIS+. The benzene results are mapped at each location with a circle symbol. The benzene concentrations are grouped into six numerical ranges that map to different circle sizes and colors; for example, the highest range is from 6,400 to 8,620 µg/L. The size and color of each circle reflect the concentration value, with higher values corresponding to larger circles and yellow, orange or red colors. Lower values are shown with smaller circles and green, blue, or purple colors. Black squares indicate locations where benzene results were below the chemical detection limit for the laboratory. Each mapped concentration is assigned to the appropriate numerical range, which in turn determines the circle size and color. This first time slice for 2004-2005 shows one very large red “hot spot” indicating the highest concentration class, two yellow spots, and several blue spots, plus a few non-detects.

Locus GIS+ time slice

Time slice for a year for a Locus GIS+ query

Starting the time slider runs through the yearly time slices. As time passes in this example, hot spots come and go, with a general downward trend towards no benzene detections. In the last year, 2018-2019, there is a slight increase in concentrations. Watching the changing concentrations over time presents a clear picture of how benzene is manifesting in the groundwater wells at the site.

GIS+ time slider in action

GIS+ time slider in action

While displaying time in maps has always been a challenge, the use of automation in GIS lets users get a better understanding of temporal trends in their spatial data. Locus continues to bring new analysis tools to their GIS+ system to support time data in their environmental applications.

Time slice for a Locus GIS+ query

Time slice for a Locus GIS+ query

Interested in Locus’ GIS solutions?

Locus GIS+ features all of the functionality you love in EIM’s classic Google Maps GIS for environmental management—integrated with the powerful cartography, interoperability, & smart-mapping features of Esri’s ArcGIS platform!

Learn more about Locus’ GIS solutions.

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. Dr. Pierce earned his GIS Professional (GISP) certification in 2010.