EIM: Configurable Software that Meets Your Needs
One of the key advantages of Locus’s environmental software is the ability to configure the software to fit your needs. If you buy pre-configured software, you must adapt your process to fit the constraints of the system you just bought. When you buy configurable software such as Locus’s EIM and Locus Platform, you’re able to create the exact workflow that you need.
EIM has multiple features that customers have used to configure the tasks of uploading, processing, querying, and reporting for their analytical, groundwater, and field data. For example, to date customers have created over:
- 2,750 expert and intermediate queries
- 4,300 enhanced formatted reports (EFRs)
- 830 electronic data deliverable (EDD) formats
- 950 saved query filters and output column lists
- 150 saved chart option sets
- 180 saved GIS+ maps
Let’s look at a few of the items above.
The Custom Queries module has features to configure and save your own queries tailored to the output that you require. The Intermediate Custom Queries module lets you select desired tables and fields, add selection filters, and then run the query. You also can save your query for future use. The image here shows one of the forms in this module. This form lets you build a query using a diagram showing tables and their relationships.
EIM also supports creating and saving Expert Custom Queries. You create these queries by using the Query Builder, a drag and drop interface for query creation. You can also edit the query using T-SQL (structured query language) if you know that language, but it’s not required to use the module. Once a query is created, it can be run by any user. You can also set up schedules that run a specified Expert Query at certain times, with the results emailed to selected users. In addition, Expert Queries can be called using the Locus EIM API with results accessed in other applications. The image here shows the Query Builder interface.
The Enhanced Formatted Report (EFR) module lets you create print-ready Excel spreadsheets that combine multiple data sources into compact pivot tables. EFRs are highly configurable. You can select the data fields to put into the rows and columns, as well as the fields to show in the cells of the pivot table. Furthermore, you can aggregate the data (for example, using the maximum or average).
You can also create, save, and apply rules for formatting the data. Maybe you need data to be highlighted in certain colors based on the data value, or whether the data exceeds an action limit. Or maybe you need the data modified to append certain flags based on data validation. You can support these scenarios, plus many others, in the EFR Module.
The image below shows the EFR interface for selecting fields for the rows, columns, and cells of an EFR pivot table.
The EIM Charting module lets you create line, bar, and scatter plots of your data. Once you create a chart, you have full control over all parts of the chart display, including the fonts and colors used for the chart axes, data points, legend, and labels. The image below shows many of the configurable options available for EIM charts.
The EDD Format Setup module lets you create and configure the EDD formats used for uploading your data into EIM. When you create a new EDD format, you specify a data delimiter as well as the destination tables and columns that are populated by the EDD. You can order the columns as needed to match your incoming EDDs. The image below shows the main form for setting up an EDD format.
EIM has many other configurable modules, such as the Analysis grids, the EDD Validation module, and the GIS+ module. All these tools let you fit EIM to your needs and processes. That’s the power of configurable software! For more information, contact Locus Technologies.
Long Live the GIS Mashup
Nov 15, 2023, is GIS Day, a day started in 1999 to highlight the diverse uses of geographical information systems (GIS). Earlier Locus blog posts have looked forward to discuss how GIS can work with augmented reality and artificial intelligence. This post looks backwards to talk about mashups, a GIS concept that is over twenty years old but still relevant to environmental data management.
The term ‘mashup’ became popular in the early 2000s to describe the combination of multiple songs to make a new song. Similarly, a GIS mashup combines digital map layers into a new map – something that can’t be done with paper maps that have fixed data. Often, the mashed-up map layers are public, allowing digital cartographers to repurpose existing content from other users into their own custom maps.
The term ‘mashup’ has lately fallen out of use, perhaps because mashups are common now; sometimes it seems all pop culture is one big mashup. At any rate, the Locus GIS+ module, powered by the ESRI mapping engine, lets you make mashups in the Locus EIM and Locus Platform applications by combining data from three sources.
First, you can show georeferenced objects stored in EIM and Locus Platform, whether the objects are sample locations, spills, assets, or other features. Here is a map of wells and sample locations in EIM mashed up with a satellite image.
Second, you can add any map layers you have stored in your ESRI ArcGIS cloud – these could be plant boundaries, areas of concern, building footprints, site photos – anything you have in your ESRI web maps. The next map shows wells in EIM with map layers showing a plant boundary, wetlands, and several pipelines.
Third, you can supplement your maps with public data stored in the ESRI cloud – layers made public by a host of national, state, and local organizations and agencies, as well as private companies such as ESRI. This map mashes up EIM sample locations with a publicly available map layer showing nearby schools.
By combining data from these various sources, you can bring together many layers to perform your own analysis. For example, you can combine your asset layers in the Locus Platform with flood plain maps to evaluate property risk. Here is a map showing Platform locations with flood plans and streams.
Or you can combine sampling results from EIM with groundwater contours generated in GIS+ and overlay public layers of aquifers, watersheds, and topography, to determine impacts on drinking water supplies. The next map shows groundwater contours from EIM mashed up with flood areas, streams, and wetlands.
The word ‘mashup’ may have gone out of style, but combining multiple data sources into your own map is a feature of Locus GIS+ that is here to stay. If you’re not using GIS+ with your Locus apps, contact Locus to try it; and if you already have GIS+, be sure to take advantage of this powerful method to make your own custom maps.
[sc_vimeo width=”640″ height=”360″ aspect_ratio=”16:9″ video_id=”882248509″ style=”default” position=”right”]
Time for another Compliance Minute from Locus Technologies EHS Implementation Manager, Chris DeCree, today we will be focusing on Task Groups and how they can ease your workflow.
To learn more, click the video above.
[sc_button link=”https://vimeo.com/882248509″ text=”Watch the video” link_target=”_self” color=”000000″ background_color=”52a6ea”]
[sc_vimeo width=”640″ height=”360″ aspect_ratio=”16:9″ video_id=”876102756″ style=”default” position=”right”]
This week, Vice President of Data Management and Visualization, Todd Pierce is diving into the synergy that exists among our suite of Locus applications. When combined, these four powerful tools—EIM, Locus Platform, GIS+, and Locus Mobile—work seamlessly to help you harness the true potential of your data within the Locus Cloud.
Let’s take a closer look at how each of these applications contributes to transforming your data landscape, click the video to learn more.
[sc_button link=”https://vimeo.com/876102756″ text=”Watch the video” link_target=”_self” color=”000000″ background_color=”52a6ea”]
When looking for a GHG reporting program, there is one element that is typically overlooked. This short video gives us more insight.
When looking for a GHG reporting program, there is one element that is typically overlooked. This short video gives us more insight.
[sc_vimeo width=”640″ height=”360″ aspect_ratio=”16:9″ video_id=”866411478″ style=”default” position=”right”]
Chris DeCree, EHS Implementation Manager at Locus Technologies, is back with another Compliance Minute. Today’s topic is Requirements Management. Locus offers integrated solutions for EHS, ESG, and Environmental data, emphasizing the use of the Locus Software to manage requirements and permits.
To learn more, click to watch the video.
[sc_button link=”https://vimeo.com/866411478″ text=”Watch the video” link_target=”_self” color=”000000″ background_color=”52a6ea”]
Business intelligence (BI) is a critical component of any organization. BI lets you analyze data on your processes and products, so you have the information needed to make decisions and take actions to improve your business’s performance. BI applications have been available for several years, with offerings from many companies including Microsoft, Oracle, SAS, Qlik, and Tableau.
Initially, BI was focused on just a few areas such as finance, logistics, and sales. As BI effectiveness evolves you need information covering all aspects of your business. One key information set is spatial information, which is usually managed in a geographic information system (GIS). GIS applications have been available since 1965 but only became widely commercially available in the 1980s when ESRI released its first GIS applications. Since then, GIS has spread from the desktop to mobile devices and the cloud.
Often, an organization’s spatial data is separate from other data, kept in its own department or application. For example, your organization might have a GIS department that manages geographic information for your facilities. However, spatial data might also be in other departments such as sales (locations of clients); physical plant (buildings, infrastructure, assets); logistics (sales or delivery routes), or even human resources (safety incident locations). It can be challenging to bring together these disparate spatial data sources and integrate them with non-spatial data stored in spreadsheets, databases, files, and other data warehouses.
Several recent business trends, however, have made it much easier to bring together both spatial and non-spatial information to support GeoBI or Geographic Business Intelligence. First, the rise and ubiquity of the internet ‘cloud’ has made it possible for an organization to put all their data into the cloud. Your business staff can now access all your data, regardless of the physical location of the data or your staff. Second, GIS has evolved from its earlier days when it was a way to automate traditional cartography. Now, GIS supports advanced spatial analysis and visualization techniques, including buffering, contouring, interpolation, network analysis, and 3D mapping. And third, new applications and methods have broken the barriers between spatial and non-spatial data. GeoBI software applications can manage both types of data, letting you combine all your data for analysis and visualization. Applications that don’t explicitly support both types can be connected through the use of application programming interfaces (APIs) for seamless transfer of data.
GeoBI and Locus
Locus Technologies has been a leader in bringing GeoBI to environmental data management. Locus’ software supports non-spatial data analysis via reporting, charting, and expert query functionality. The Locus GIS+ add-on lets you add spatial data to your analysis with the GIS+ functions for spatial query, data classification, time series analysis, buffering, and contouring. Let’s look at some examples.
- Water quality: Clean water regulations may require your facility to identify and report any instances of chemical concentrations in water sources that are above certain action limits. To do this, you can load analytical results from chemical sampling into the application. Once the data is loaded, you can add the sampling results to the GIS+ along with overlays of plant assets, watersheds, aquifers, and other relevant geographic information. You can quickly generate maps showing concentrations at sample locations. In this way, you can identify ‘hotspots’ where your facility may be in non-compliance with regulatory requirements.
The example below shows the GIS+ displaying tritium results from water samples along with watershed boundaries. The map represents each location with a symbol that is colored and sized to reflect the actual maximum value at that location. You can easily see spatial patterns and identify two areas of concern near the center of the map – one with orange and yellow circles, and another with red circles. You could then use other functions, such as charting or contouring, to further explore the results at these locations.
- Air quality: Your facility may fall under clean air regulations such as the US EPA’s 40 CFR Part 60 Subpart OOOO standards. In short, this subpart establishes emission standards and compliance schedules for the control of volatile organic compounds (VOC) and sulfur dioxide (SO2) emissions). As an environmental manager, you could simply use a BI program to write and run a text query such as “show me all emission assets that have exceedances under 40 CFR Part 60 Subpart OOOO”.
However, Subpart OOOO often applies to the Oil and Gas industry where maps and GIS are heavily utilized. If you have data and maps, you can associate a data query to an area that is “lassoed” on the map. The example below shows several emission sites that have been grouped together by a user-drawn area. Locus shows a table of all data for the “lassoed” locations, including analytical results and regulatory exceedances. By simply putting a lasso around another set of emission locations, the query is automatically updated with the relevant results. No query needs to be written – you just need to lasso locations on a map!
- Safety: In a similar fashion, safety personnel can use a map to find different incident categories without having to train on reporting and query details. When an incident occurs, efficiency of logging the essential information is paramount, and simple pulldown list coupled with graphics expedite the process when time is of the essence.
Below is a map where the manager and incident for rapid input was pinned to a location and for follow-up on a particular region the manager can apply a lasso query to list all Significant Injuries and Fatalities (SIFs), for root cause and other analysis.
GeoBI and You
The above examples show how GeoBI can bring all your data together for use in analysis and decision-making, leading to a more complete picture of your facilities and processes. Furthermore, by having one suite of applications for your GeoBI needs, your organization can be more efficient. If spatial and non-spatial data are in separate silos, accessible only by different staff, it is difficult for one person to perform a complete analysis. Files, maps, spreadsheets, and other data objects must be shuffled between different persons and applications. With your data in Locus software, a full GeoBI analysis can be performed by one person, leading to productivity gains and cost reductions.
In the future, advances in artificial intelligence (AI) could lead to GeoAI, which would combine GeoBI with powerful features such as predictive analytics, pattern mining, and anomaly detection. Stay tuned for a future blog post on these exciting possibilities!
Acknowledgments: All the data used in the examples was obtained from the publicly available chemical datasets online at Intellus New Mexico.
299 Fairchild Drive
Mountain View, CA 94043
P: +1 (650) 960-1640
F: +1 (415) 360-5889
Locus Technologies provides cloud-based environmental software and mobile solutions for EHS, sustainability management, GHG reporting, water quality management, risk management, and analytical, geologic, and ecologic environmental data management.