The Past, Present, and Future of EHS & ESG

To celebrate a milestone 25 years of success in EHS and ESG software development, we sat down with Locus President, Wes Hawthorne for a brief discussion. In this post, we ask him a series of questions highlighting the past, present and future of EHS and ESG.

1. What are the greatest challenges that environmental professionals are facing?

One of the persistent challenges we’ve seen for the past 25 years is that the responsibilities of environmental professionals are continually expanding. Previously, almost all environmental work was localized, with facility-level permits for air, water, waste, etc. That has expanded over the years to include new regulations and reporting requirements for sustainability, social metrics, and other new compliance areas, while the old facility-level programs still continue. This has led to more pressure on environmental managers to keep up with these programs, and increased reliance on tools to manage that information. That’s where Locus has always focused our effort, to make that ever-expanding workload more manageable with modern solutions.

2. What are the most interesting trends in EHS and ESG?

The current flood of interest in ESG is certainly notable as far as bringing corporate attention to the environmental field, as well as having requirements originate from the SEC here in the US. We have become accustomed to managing oversight from multiple regulatory bodies at the local, state, and federal level, but SEC would be a newcomer in our line of work. Their involvement will be accompanied by a range of new requirements that are common for the financial world, but would be unfamiliar to environmental staff.

Across other EHS fields, we are seeing increased demand for transparency in EHS functions. Overall, this is a positive move, as it brings more attention to EHS issues and develops a better EHS culture within organizations. But this also drives the need for better tools to make EHS information readily available across all levels of the organization.

3. What are the most disruptive technologies available today?

As far as technologies, the ones most likely to have significant impact in the environmental field are ones that don’t require a significant capital investment. Although there are definitely some practical advantages to installing smart monitoring devices and other new technologies, procuring the funding for those purchases is often difficult for environmental professionals. Fortunately, there are still many technologies that have already been implemented successfully in other fields, but only need to be adapted for environmental purposes. Even simple changes like using web-based software in place of spreadsheets can have a huge impact on efficiency. And we haven’t yet seen the full impact of the proliferation of mobile devices on EHS functions. We are still working on new ways to take advantage of mobile devices for data collection, analysis, and communication purposes.

4. What do you think are the biggest innovations of the last 25 years in our field?

We’ve seen a number of innovation milestones in the past 25 years, and while we didn’t invent SaaS, we’ve been largely responsible for adapting it and perfecting it for environmental purposes. One of the major innovations we’ve integrated into our products include online GIS tools where users can easily visualize their environmental data on maps without expensive desktop software. Another one was our fully configurable software platform with built-in form, workflow, and report builders tailored for environmental purposes, which allows anyone to build and deploy environmental software applications that exactly match their needs. There have been many other innovations we’ve incorporated into our software, but these two stand out as the most impactful.

5. Where do you see Environmental and ESG reporting in the future?

More and more, we are seeing all types of reporting being converted into pure data exchanges. Reports that used to include regulatory forms and text interpretations are being replaced with text or XML file submittals. This transition is being driven largely by availability of technology for EHS professionals to generate and read these files, but it is also promoted by regulatory agencies and other stakeholders receiving these reports. Stakeholders have less time to read volumes of interpretive text, and are becoming more skeptical of potential bias in how facts are presented in text. These are driving the need for more pure data exchanges, with increasing emphasis on quantifiable metrics. These types of reports are also more readily compared against regulatory or industry standards. For reporters, lengthy corporate reports with volumes of text and graphics are becoming less common, and the success of an organization’s programs will be increasingly reliant on robust data sets, since ultimately only the data will be reported.

6. What has been the key reason for Locus’ success for the past 25 years?

There are actually a few that immediately come to mind. One reason is the nature of our continually evolving products. By providing our solutions as SaaS, our software adapts with new environmental requirements, and with new technologies. If our software was still the same as it was 25 years ago, it simply wouldn’t be sufficient for today’s requirements. Since our software is updated multiple times each year, it is difficult to notice the incremental changes, but they can be readily seen if you compare today’s software with the original in 1997. And we’re committed to continuing the development of our products as environmental needs change.

The other primary reason for our success is our excellent staff and the environmental expertise we bring to our customers. We simply could not provide the same level of support without our team of environmental engineers, scientists, geologists, chemists, and an array of others. Having that real-world understanding of environmental topics is how we’ve maintained customer relationships for multiple decades. And our software only has value because it is maintained and operated by staff who appreciate the complexity and importance of environmental work.


Locus President Wes Hawthorne meets with Locus Platform dev team 2016Mr. Hawthorne has been with Locus since 1999, working on development and implementation of services and solutions in the areas of environmental compliance, remediation, and sustainability. As President, he currently leads the overall product development and operations of the company. As a seasoned environmental and engineering executive, Hawthorne incorporates innovative analytical tools and methods to develop strategies for customers for portfolio analysis, project implementation, and management. His comprehensive knowledge of technical and environmental compliance best practices and laws enable him to create customized, cost-effective and customer-focused solutions for the specialized needs of each customer.

Mr. Hawthorne holds an M.S. in Environmental Engineering from Stanford University and B.S. degrees in Geology and Geological Engineering from Purdue University. He is registered both as a Professional Engineer and Professional Geologist, and is also accredited as Lead Verifier for the Greenhouse Gas Emissions and Low Carbon Fuel Standard programs by the California Air Resources Board.

Want to discuss EHS and ESG solutions with our product specialists? Contact us today!

    Name

    Company Email

    Phone

    Tell us about your company's needs

    Locus is committed to preserving your privacy.

    Locus Technologies Celebrates 25 Years of Innovative EHS & ESG Software

    Locus looks back on the last 25 years of pioneering EHS, ESG, and water quality software.

    MOUNTAIN VIEW, Calif., 11 April 2022Locus Technologies, the leading EHS Compliance and ESG software provider, today celebrates the 25th anniversary of its founding, and with it, a quarter-century of customer success. Locus looks back on its founding as a Silicon Valley leader in EHS & ESG software with pride in its leadership through expertise, stability, and innovation. 

    Locus was founded in 1997 with a revolutionary vision that set the framework for what is now widely known as environmental, social, and corporate governance (ESG) and environmental, health, and safety (EHS). Locus envisioned a simplified and data-driven approach, offering software in the cloud, on mobile devices, and as a service. The company pioneered SaaS (Software as a Service) model in EHS, ESG, and water quality management spaces in 1999 and never installed its software on customers’ premises. 

    Over 25 years, Locus has pioneered cloud environmental solutions, online and mobile GIS (Geographic Information System) services, has revolutionized environmental information management, and AI and IoT technologies for organizations ranging from Fortune 500 companies to forward-facing municipalities and the US Government. 

    Locus recently broke new ground by releasing the first Visual Calculation Engine for ESG Reporting. Locus’s visual calculation engine helps companies quickly set up and view their entire ESG data collection and reporting program, enabling full transparency and financial-grade auditability throughout the entire process. 

    As the industry continues to evolve, competitors merge and disappear. New markets emerge and grow. Locus remains a constant in the environmental space, an innovative and independent pioneer. 

    “For 25 years now, Locus has brought together industry-leading experts in EHS, sustainability, and technology. Although regulations and requirements have changed over the years, that combination remains at the core of what Locus does, as demonstrated by our stability and long-term customer partners. We look forward to continuing our path of growth using those same values for the next 25 years.” said Wes Hawthorne, Locus President.  

    Locus Founder and CEO, Neno Duplan is proud to look back on the growth of Locus over the last 25 years. He said, “Locus did not start in the clouds, but back in 1997, we had a rather good view. Locus’s vision for better global environmental stewardship has not changed since its inception. We focus on empowering organizations to track better and mitigate the environmental impact of their activities. That vision has come to fruition through the Locus software services used by some of the world’s largest companies and government organizations. Locus’ SaaS has been ahead of the curve in helping private and public organizations in not only managing their water quality, EHS compliance or ESG reporting but also turning their environmental information into a competitive advantage in their operating models.” 

    Locus Introduces Visual Calculation Engine for ESG Reporting

    MOUNTAIN VIEW, Calif., 1 March 2022Locus Technologies, the leading EHS Compliance, and ESG software provider, today announced the industry-first visual calculation engine for ESG reporting. Locus’s visual calculation engine helps companies easily set up and view their entire ESG data collection and reporting program, enabling full transparency throughout the entire process.  Through an interactive branching interface, ESG professionals can quickly identify areas where to focus efforts to improve their ESG performance. Companies that set goals in line with the Science-Based Targets initiative (SBTi) can use Locus’s ESG software to track progress to reach those goals in a transparent and credible manner. 

    Having a visual calculation engine reduces the burden, time, and potential inaccuracies associated with ESG reporting. The environmental portion of ESG reports includes complex calculations, factors, and numerous data inputs. The visual calculation engine goes beyond GHG (Greenhouse Gas) and addresses any calculations that are part of ESG reporting such as waste generation, resources, and water consumption. Through the visual hierarchical tree, companies can easily get to the sources of any raw data, factors, and formulas used to generate reported ESG metrics. 

    With an increased focus on ESG reporting and transparency, ensuring accurate reporting is more important than ever. Locus’s award-winning ESG data tracking, analysis, reporting, and visualization software aims at helping organizations plan, implement, and accelerate net-zero strategies. Choosing the right calculation engine plays a crucial part in remaining compliant with rapidly evolving requirements and regulations. In the US, the SEC’s proposed rules expected this year will likely require public companies to report emissions from their operations, energy usage, and resources they consume. The SEC requirements are being driven by the fact that many investors are considering ESG disclosures in their investment decisions. With those requirements, there is an expectation that these reports will be subject to some form of auditing to ensure accuracy.  Locus’ accredited GHG verifier designed the visual calculation engine to support this impending requirement. It provides a single consolidated view of all input data, referenced factors, and calculations that went into the ESG report. Through the calculation engine, raw data can be traced back to the user input, integrated external database, utility API, supplier attestation, or any other data source. 

    Locus’s visual calculation engine supports simultaneous calculations using multiple methods so that users can input data once and report to federal, state, and voluntary reporting programs according to each proper protocol. Once raw data is in the Locus ESG app, reporting can be performed to several different reporting standards such as U.S. EPA Mandatory Reporting Rule, European Union Emissions Trading Scheme (EU ETS) or GRI, SASB, CDP, DJSI, GRESB, and DNSH.  

    “Locus’ visual calculation engine builds upon over a decade of experience performing verification of ESG data for many companies. Coupled with Locus SaaS Platform it provides all necessary tools to simplify data management, reporting, and visualization of necessary carbon and other calculations in real-time. It provides full transparency for calculations, which become part of an organization’s ESG reporting. As financial-grade audits are applied to ESG reporting, this becomes a critical feature for organizations needing a reliable ESG reporting tool.,” said Wes Hawthorne, President of Locus. 

    Locus Technologies Receives 16th Consecutive EBJ Award for Information Technology in ESG

    Environmental Business Journal (EBJ) recognized Locus for ESG software growth and innovation.

    MOUNTAIN VIEW, Calif., 24 February 2022 — Locus Technologies, the leading EHS Compliance and ESG software provider, was awarded a 16th consecutive award from Environmental Business Journal (EBJ) for growth and innovation in the field of Information Technology in the environmental software with particular focus on ESG.

    EBJ is a business research publication providing strategic business intelligence to the environmental industry. Locus received the 2021 EBJ Award for Information Technology by growing and innovating its unified EHS compliance and ESG software platform.

    In 2021 Locus took a leading market position in the fast-growing space of ESG software. Locus’s ESG SaaS covers carbon data aggregation via a powerful visual calculation engine, investor-grade emissions calculations audit capabilities, reporting to multiple standards from a single data set, integration APIs, dashboards, and carbon reduction goal setting and tracking. This separates Locus from competitors as customers demand integrated net-zero ESG software that supports investor-grade data in disclosure rules such as the EU’s corporate sustainability reporting directive, mandatory TCFD reporting, and anticipated SEC action on climate disclosures.

    In 2021 Locus continued to expand its ESG SaaS to include built-in business intelligence tools allowing for interactive, actionable insights into EHS and ESG data, forecasting tools to predict future ESG reporting, APIs linking to utility meters, and interfaces with other Locus and third-party systems that house ESG data. Locus’s ESG application is focused on “enter once, report many times.” The gold standard for multinational enterprises with many locations worldwide is to have a system configured to report to multiple organizations and many standards from a single dataset. Essential built-in reporting in the Locus ESG app includes state or federal regulations, internal CSR, and ESG based on whatever standard their organization adheres to, such as CDP, GRI, SASB, TCDF, or more recent World Economic Forum (WEF) attempt to standardize many voluntary standards.

    Locus also expanded its ESG consulting expertise by becoming the first and only software provider to offer accreditation services under new Oregon DEQ guidelines requiring third-party verification for GHG and CFP programs.

    Besides strong growth in ESG space, Locus also continues to lead the software for water quality management market with the addition of new SaaS customers in 2021, such as the City of Hillsboro, Oregon for water quality management and Westinghouse Electric Company for control of environmental and radionuclides data, cementing Locus’s market leader position in the space of nuclear facilities.

    “Locus’s investment in integrated carbon management software and EHS compliance is paying off. As one of the early SaaS leaders in net-zero digital solutions for ESG reporting, Locus continues to provide value to companies that want to be credible with their carbon reporting and sustainability software.,” said Grant Ferrier, president of Environmental Business International Inc. (EBI), publisher of Environmental Business Journal.

    “We would like to thank EBJ for recognizing Locus for a 16th consecutive year and for taking note of our industry-leading ESG software. We aim to continue expanding our software offerings to customers in 2022,” said Wes Hawthorne, President of Locus Technologies.

    The Locus Technologies ESG Survey Tool

    The Locus Technologies ESG Survey Tool enables users to email surveys and questionnaires directly from Locus to their supply chain. This is achieved without having to create usernames and credentials those receiving surveys.

    When surveys are issued, the tool generates a secure link to each email recipient. Email recipients click the link, respond to the survey or questionnaire (without having to create a Locus username/password), and the data will be captured within Locus software for ESG purposes. Recipients of the link only receive access to their survey form, and nothing else in the system, and the links expire within a prescribed timeframe to further strengthen security.

    The survey tool securely streamlines data collection from external entities who would traditionally never be given access to the system, including suppliers, vendors, sales channels and consultants. Once collected, the data can be immediately be used for ESG calculations and reporting.

    The Locus ESG Survey Tool Infographic

    Want to learn more about the Locus ESG Survey Tool? Reach out to our product specialists today!

      Name

      Company Email

      Phone

      Tell us about your company's needs

      Locus is committed to preserving your privacy.

      Selecting ESG Software? Watch out for these 7 Red Flags

      One of the biggest recent trends we have seen with novice ESG providers (both startups and major software providers new to the field) is a lack of substantial software tools presented. What is lacking is covered up by grandiose statements about the efficacy of their options. These statements are so vague that they could cover anything if you switched out references to ESG with any other nouns, since these providers don’t show their tools transparently.

      Locus Technologies ESG Reporting

      Here are seven red flags to be aware of when selecting ESG software:

      • These providers prominently share statements and statistics about the current ESG climate, without any offering of how their software fits into the picture. This is a major ‘tell’ that someone is jumping on the ESG bandwagon without adequate expertise or software tools.
      • There is a lack of explanation about how their tools directly improve your ESG program. There is no mention of their dashboards or reporting options or other integrated tools. A seasoned software provider will happily share the specifics of what they offer.
      • You’ll find over-the-top flashiness on their website, but there are no software previews to be found. If they’re not showing an example of their software, it may be because it lacks functionality, or is theoretical.
      • Their site is filled with buzzwords. They will talk about reaching net-zero, about how their software is expert-led and data-driven. They will offer no insight as to how they meet these goals.
      • They will shy away from offering demonstrations. Instead, they will seek to have conversations where they make lavish promises about what their software will be able to do in the future. They may be quick to offer a PowerPoint presentation, but you’ll find that many organizations are reluctant to show their software in action. You deserve to see the software you intend to purchase.
      • No case studies or current customers can be found. If there’s not an example of their software in use, then it may not be worth exploring, or it may not exist.
      • If an ESG software provider has grown by acquisition, there are likely issues with software integration and staffing knowledge/support for the product. And if they’re owned by investors, it’s inevitable that they’re being packaged to sell, and they’ve raised prices to meet the needs of the investor.

      So, what should you look for in an ESG Software Solution instead?

      When selecting an ESG software solution, don’t waste your time with something that either isn’t functional or doesn’t exist. More importantly, your software should have a long track record of usability and be backed by years of expertise. Locus ESG software is proven and is a vital part of the Port Authority of New York and New Jersey’s Clean Construction Program. It also helps Del Monte Foods meet their sustainability goals by improving analyzation and forecasting.

      Want to learn more? See it for yourself. Reach out to our product specialists today.

        Name

        Company Email

        Phone

        Tell us about your company's needs

        Locus is committed to preserving your privacy.

        Embodied Carbon in the Construction and Building Operations Industry

        When we look at all the new construction in the next 20 years, we see the critical role embodied carbon plays. The world urgently needs to address carbon emissions from buildings and construction, constituting almost 40% of global carbon emissions. Of those total emissions, building operations are responsible for 28% annually, while building materials and construction (typically referred to as embodied carbon) are responsible for an additional 12% annually.

        The construction industry is the world’s largest single industry. Oxford Economics estimates the global construction market at $10.7 trillion in 2020. The market is expected to grow by $4.5 trillion between 2020 and 2030 to reach $15.2 trillion.

        Embodied Carbon Software

        Unlike operational carbon emissions, which can be reduced over time with building energy upgrades and the use of renewable and nuclear energy, embodied carbon emissions are locked in place upon completion of construction. The owners and construction industry must handle embodied carbon now if we hope to achieve climate change goals by target dates. Embodied carbon typically precedes Scope 1, 2, and 3 emissions and should be added to those for any new construction.

        Achieving zero embodied emissions will require adopting the principles of reusing, reducing, and sequestering, including retrofitting existing buildings, using recycled materials, and designing for deconstruction. Reducing means material optimization and the specification of low to zero carbon materials. Sequester means including the design of carbon sequestering sites and the use of carbon sequestering materials.

        Just three materials – concrete, steel, and aluminum – are responsible for 23% of total global emissions (most of the materials used in the built environment). Concrete is the second most-consumed substance on Earth after water. Overall, humanity produces more than 10 billion tons, about 4 billion cubic meters of concrete and cement per year, or about 1.3 tons for every person on the planet, more than any other material, including oil and coal. The consumption of concrete exceeds that of all other construction materials combined. Making modern cement and concrete has a heavy environmental penalty, being responsible for 5% or so of global carbon emissions. And yet, most of those emissions are not accounted for during regular carbon reporting protocols. Steel and aluminum are not much different.

        All companies that want to be credible with their carbon reporting need software tools for embodied carbon tracking and management. For this reason, Locus has developed a SaaS application to manage and report embodied carbon data in real-time during construction projects. The Locus Embodied Carbon app, part of the ESG toolset, advances environmentally friendly infrastructure design and increases the ability to track and reduce emissions before being built in the new structure forever.

        Locus’s Embodied Carbon management software automates carbon emissions management throughout the design and construction processes. It is one of the most ambitious real-time carbon management software programs in the US. Locus Embodied Carbon app helps site owners, construction companies, and the supply chain reduce embodied carbon from on-site construction activities and reduce air pollution from construction activities.

        Embodied Carbon Software

        Locus Embodied Carbon application combines the advantages of Locus Platform’s multitenant SaaS with its powerful configuration tools and APIs that, for example, stream carbon data from construction equipment to online software. The construction industry now has precisely the ESG software solution they need to fit their business processes for the low carbon construction program management to incorporate other EHS compliance and Sustainability data on the same unified platform in the future.

        Locus to Provide GHG Verification Services in Oregon

        Locus Technologies has received accreditation by Oregon DEQ for GHG and CFP verification services.

        MOUNTAIN VIEW, Calif., 21 December 2021 — Locus Technologies (Locus), industry leader in environmental compliance and ESG software, has been accredited by the Oregon Department of Environmental Quality (DEQ) to provide verification services for mandatory greenhouse gas (GHG) reporting and the Clean Fuels Program (CFP). Locus is the first of a select few to receive approval for verification services. 

        The accreditation allows Locus to provide verification services for GHG emissions reports, which are now mandatory for facilities in the State of Oregon. The verification team at Locus consists of experts in all reporting requirements. Locus’ in-house Lead Verifiers are certified in all reporting types, including air contamination stationary sources, electricity suppliers, fuel suppliers, natural gas suppliers, natural gas systems, and process emissions. Locus verifiers are also certified for all report types under the Oregon CFP. 

        The Oregon Environmental Quality Commission (EQC) updated their rules in May 2020 to enhance the data collection of Oregon’s greenhouse gas emissions. The adopted rules incorporate existing reporting and emissions accounting protocols into rule and improve the specificity of how emissions data are calculated, reported, and verified. The regulation requires mandatory reporting and verification of greenhouse gas (GHG) emissions by third-party verifiers like Locus, starting in 2022. 

        “Locus is proud to become an accredited GHG and CFP verification body for the state of Oregon, as we have been in California since the inception of that program. We are continually committed to staying informed on new and updated ESG reporting frameworks, which we accomplish first and foremost through domain expertise. Our field expertise and industry knowledge allow us to provide a vital service, while also further expanding on our ESG software to support these new reporting programs” said Wes Hawthorne, President of Locus. 

        Building on over a decade of GHG verification experience, Locus remains the only software provider for collecting, managing, and reporting GHG emissions that is also an accredited verifier. Using this expertise, the software includes unparalleled tools for transparent and auditable calculations for GHG programs.  

        The Convergence of Augmented Reality and GIS

        Today is GIS Day, a day started in 1999 to showcase the many uses of geographical information systems (GIS). Earlier blog posts by Locus Technologies for GIS day have shown how GIS supports cutting-edge visualization of objects in space and over time. This year’s post explains how GIS supports augmented reality.

        Augmented reality (AR) is a technology that enhances how we experience the real world by overlaying your surroundings with computer-generated objects. It differs from virtual reality (VR) because in VR, everything you see is computer generated, but in AR, the majority of what you see is real – your experience of reality is enhanced (augmented) but not totally replaced.

        You are probably familiar with one AR application already if you watch American football. The ‘virtual’ first down line that appears on field before each play is projected there by computer and is not really painted on the field. If you follow soccer (or football to the rest of the world), AR is used by a Video Assistant Referee (VAR) to objectively determine tight offsides decisions. Digital lines are drawn across the field to show whether or not attackers are illegally past the last defender or not. Another AR example is the popular game Pokémon Go that shows cute virtual creatures in your living room or your front yard.

        To experience AR, you need something to project the non-real objects onto your view of the world. Many AR applications use mobile phones or other devices. An AR application uses the camera view to show you the world around you and then overlays virtual objects onto the view. Other devices such as head mounted displays, ‘smart glasses’, or even ‘bionic contact lenses’ can use AR, but have not been as popular as phones or other mobile devices. In contrast to AR, VR cannot be fully supported with just a mobile device and usually requires headsets to immerse you in a virtual world. Because of this need, AR is much less intrusive than VR is.

        Countless other examples of AR already exist in many fields. A few selected applications include:

        • Online shoppers at some e-commerce sites can use smart devices to project furniture into their home to see how the pieces look before making a purchase.
        • Some clothing stores can project clothing onto shoppers’ bodies to check appearance without having to change clothes. These applications require the user to be in a special dressing booth with full body scanning capabilities.
        • Urban planners use AR to display how planned buildings, cell towers, wind turbines, and other structures would look in the existing space. Planners can walk the streets and view how proposed projects would alter the existing cityscape.
        • AR is used in manufacturing to display operation and safety instructions in a worker’s field of vision using head mounted displays, which circumvents the need to refer to bulky paper manuals.
        • Utility managers can see underground pipelines, water lines, sewer pipes, electrical lines, and other infrastructure projected below their feet.

        So how does GIS relate to AR? There are three main uses of GIS in AR:

        • Location: Any AR application must know where the user is and where to place virtual objects. In most cases, full GIS capabilities are not needed; instead, the application accesses a GPS (global positioning system) to find locations. Consider the Pokémon Go application mentioned before. The game knows where the various Pokémon need to appear. When a user plays the game, it uses GPS to find the user, and then shows any Pokémon that are near the user based on their locations.
        • Layers: An AR application may need to show features that are not visible to the user, such as underground electrical lines, earthquake fault lines, property lines, or planned buildings. All these features can be stored as GIS map layers in the cloud and then displayed in the AR application as virtual overlays projected on the real world. Furthermore, a user could select a displayed item and view related attribute information in the GIS layer. For example, a user could view the condition, age, and repair status of a selected water pipeline.
        • Navigation: An AR application may also need to help a user get from point A to point B, for example in a crowded airport or in a large warehouse. Such navigation could be facilitated by showing virtual route markers and arrows on the real world.

        Locus has been exploring environmental uses of AR and GIS by adding AR to Locus Mobile, which is the Locus app for collecting field data, completing EHS audits, tracking waste containers, and completing other tasks requiring users to gather data out of the office. Locus Mobile now features an AR mode to assist users when taking field samples. When the user activates AR mode, the app uses the camera to show the user’s immediate area. The app then puts multiple virtual markers on the display corresponding to sampling points located in that direction. As the user moves or rotates the phone to change the viewing area, the markers change to reflect the locations in the user’s line of sight. Clicking a marker provides more information including the location name and the distance from the user.

        Locus Mobile uses all three ways to combine GIS with AR:

        • By using GPS to find the user’s location and the locations of nearby sampling points.
        • By using GIS to display the layer of sampling points.
        • By using GIS to assist with navigation to sampling points by showing distance and direction.

        Here is a sample image from Locus Mobile showing three nearby sampling locations along with information about past events or measurements at the locations. The three blue banners are the augmented reality displayed on top of the view of the nearby surroundings.

        Locus Augmented Reality

        By using GIS and AR to assist users in finding sampling points, Locus Mobile makes field personnel more productive. Samplers can find field locations quickly and can easily pull up related information. Locus continues to explore using AR to expand the functionality of its environmental applications.


        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!

        [sc_button link=”https://www.locustec.com/applications/gis-mapping/” text=”Learn more about Locus’ GIS solutions” link_target=”_self” color=”#ffffff” background_color=”#52a6ea” centered=”1″]


        [sc_image width=”150″ height=”150″ src=”16303″ style=”11″ position=”centered” disable_lightbox=”1″ alt=”Dr. Todd Pierce”]

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

        The Horrors of Excel for Data Management

        Locus has been preaching on the pitfalls of Excel for a long time. It’s no surprise that one of the worst imaginable errors in Excel that could’ve happened, did. Almost 16,000 COVID-19 cases in England went unreported because Public Health England hit the maximum row count in their version of Excel.

        This is not the only example of Excel being misused or being the wrong tool entirely for the job. Excel is not in any way a data management system for complex or vital data. When it comes to sustainability reporting and environmental data management, the evils of the grid are a force to be reckoned with. We have highlighted a few examples that will have you shivering.

        Excel Horrors - Evils of Autofill

        Case 1: The Evils of Autofill

        Take a look at this harmless-looking chart. It shows monthly electricity consumption for a facility set to report:

        Month  Monthly Electricity Consumption (MWh) 
        January 2019  133,500 
        February 2019  122,400 
        March 2019  138,900 
        April 2019  141,600 
        May 2019  141,601 
        June 2019  141,602 
        July 2019  141,603 
        August 2019  141,604 
        September 2019  141,605 
        October 2019  141,606 
        November 2019  141,607 
        December 2019  141,608 

        During review, the auditor notices a distinct trend from April to December, indicating false data overwritten by a stray double-click. Eventually, the auditor required re-entering all invoice data for dozens of facilities to correct the issue. Where the original data went and how autofill went astray remains a mystery.

         

        Excel Horrors - Phantom File Editor

        Case 2: The Phantom File Editor

        Imagine using a massive spreadsheet with lots of linked calculations for your annual sustainability report. One of the team engineers works on the file to input more data and get it ready for presentation. But in the final steps, they accidentally delete one of the formulas that sum up the indicators. The annual total looks great for the presentation since you’ve effectively removed a portion of your resource consumption, but afterwards you discover the conclusions were incorrectly calculated.  How did that error get introduced?  The spreadsheet has no auditing capabilities on the individual values, so you may never know.

        Excel supports multiple users editing one document simultaneously, but not well.  Multiple records are saved, edits are lost, and vital data vanishes, or at best is very hard to recover. The Track Changes feature is not infallible, and over reliance on it will cause hardship.

        Excel Horrors - Date of the Dead

        Case 3: Date of the Dead

        Excel has a frustrating insistence of changing CAS numbers into dates, even if they are something like “7440-09-7″ turning into September 7, 7400. If you’re not explicit in your cell formatting, Excel isn’t happy leaving values as they are.

         

        Excel Horrors - Imposter Numbers

        Case 4: Imposter Numerical Values

        You meant to type 1.5, but you typed “1..5” or “.1.5”. Does Excel reject these imposter numbers or let you know of a potential error? No, it’s stored in Text format. This can throw off any averages or sums you may be tracking. This minor identity theft can cause a real headache.

         


         

        Other Significant Cases:

        Other data quality issues with using Excel include, but are not limited to:

        • Locations with multiple variations of the same ID/name (e.g., MW-1, MW-01, MW 1, MW1, etc.)
        • Use of multiple codes for the same entity (e.g., SW and SURFW for surface water samples)
        • Loss of significant figures for numeric data
        • Special characters (such as commas) that may cause cells to break unintentionally over rows when moving data into another application
        • Bogus dates like “November 31” in columns that do not have date formats applied to them
        • Loss of leading zeros associated with cost codes and projects numbers (e.g., “005241”) that have only numbers in them but must be stored as text fields
        • The inability to enforce uniqueness, leading to duplicate entries
        • Null values in key fields (because entries cannot be marked as required)
        • Hidden rows and/or columns that can cause data to be shifted unintentionally or modified erroneously
        • Inconsistent use of lab qualifiers— in some cases, these appear concatenated in the same Excel column (e.g., “10U, <5”) while in other cases they appear in separate columns

        As you can see, the horrors of Excel are common, and terrifying. Without a proper system of record, auditing features, and the ability for data to vanish into the ephemera, Excel offers little in the way of data security and quality for organizations managing vital environmental and compliance data. Many are learning firsthand the superiority of database management systems over spreadsheets when it comes to managing data. Now is the time to examine the specific shortcomings of your current system and consider your options.

        Contact us today to learn how Locus makes complex data management a little less spooky!

          Name

          Company Email

          Phone

          Tell us about your company's needs

          Locus is committed to preserving your privacy.