There are several ways to connect ArcPro to Enviro Spase to Enviro Data. All the methods start with using the SELECT DATA form in the Enviro Data Viewer to choose the data that you want on your map. After selecting the data, you can have Enviro Data use its sophisticated data formatting capabilities to prepare the data for display. For example, you can use the Value and Flag feature to format each result based on its analytic flag, possibly showing a non-detected value as “<.01”, which is helpful in identifying non-detect exceedances, or you could add trailing zeros as appropriate, to display “.010”, to accurately represent the analytical precision. These methods are:

Direct connection - In this approach you connect ArcMap to the SelectedData table in Enviro Data. The result is a data layer in ArcMap with a “live” connection. This means that when you change your selection in Enviro Data and refresh SelectedData and refresh your map, the map will respond to your selection changes. This is helpful when you are doing “what if” type analyses, looking at various different data elements in different ways.

Intermediate File - Although the “live” connection is useful sometimes, other times you may want to create a map that doesn’t change, such as when you are creating a map for a final report. In that case, you might be better off to export the SelectedData, and then connect the map to the exported database, so you have a record of the data that was used for the map.

ViewGISData - A SQL Server view named ViewGISData can be added to your SQL Server database. ViewGISData can be used with ArcGIS for retrieving data to be presented on maps. The contents of ViewGISData can also be exported to Excel using the Enviro Data Viewer. A number of new fields have been added to the database Analyses table. OutputResult, ValueAndFlag and ParameterUnitsCode save results and reporting units that are used in formatting data for reports and exports.

Custom ArcGIS Code - You can do a lot with the basic functionality provided by ArcGIS working with data from Enviro Data. However, for making some types of displays for your environmental projects you will find Geotech’s Enviro Spase software for ArcGIS very helpful, or you can write your own custom code to run within ArcGIS.

Note that Geotech is currently testing Enviro Spase for use with ArcGIS Pro and can provide a beta copy upon request.