Using GaeaSynergy to Create a Database to Integrate, Link and Display Subsurface Data

Share the knowledge

Managing subsurface data across multiple projects can quickly become overwhelming. Borehole logs, lab results, monitoring data, and reports are often scattered across spreadsheets, PDFs, and disconnected software tools. This fragmentation leads to inefficiencies, data loss, and costly errors.

GaeaSynergy provides a powerful solution by enabling users to create a centralized database that integrates, links, and displays subsurface data in a unified environment. Instead of working in silos, geotechnical and environmental professionals can manage all project data within a single, structured system.

In this tutorial, you’ll learn how to use Gaea Synergy to build a database-driven workflow that connects field data, laboratory results, and reporting tools—improving accuracy, efficiency, and collaboration.


Why Centralized Subsurface Data Management Matters

Subsurface investigations generate a wide range of data types:

  • Borehole logs
  • Lithology descriptions
  • Groundwater levels
  • Laboratory test results
  • Geophysical data

When this data is stored in separate systems, common problems arise:

  • Duplicate data entry
  • Inconsistent naming conventions
  • Difficulty generating reports
  • Limited data reuse across projects

A centralized database solves these issues by:

  • Storing all data in a structured format
  • Linking related datasets
  • Enabling real-time updates
  • Supporting advanced visualization

Gaea Synergy is designed specifically to address these challenges.


Overview of GaeaSynergy

GaeaSynergy is an integrated platform for managing geotechnical and environmental data. It connects multiple modules into a single workflow, allowing users to:

  • Store subsurface data in a relational database
  • Link boreholes, samples, and lab results
  • Visualize data across projects
  • Generate standardized reports

Key Capabilities

1. Database-Centric Architecture

All data is stored in a centralized database rather than isolated files.

2. Seamless Integration

Gaea Synergy integrates with tools such as:

  • Logging software
  • Laboratory data systems
  • Reporting modules

3. Real-Time Data Access

Changes made in one module are reflected across the system instantly.


Step 1: Setting Up Your Gaea Synergy Database

The first step is creating a structured database to store your subsurface data.


Creating a New Project Database

Start by:

  1. Launching Gaea Synergy
  2. Creating a new project
  3. Defining database parameters

Typical database fields include:

  • Project name
  • Location
  • Client information
  • Coordinate system

Designing the Data Structure

A well-designed database should include:

Borehole Table

  • Borehole ID
  • Coordinates
  • Elevation
  • Drilling method

Sample Table

  • Sample ID
  • Depth interval
  • Sample type

Laboratory Results Table

  • Parameter
  • Value
  • Units
  • Detection limits

Best Practices for Database Design

  • Use consistent naming conventions
  • Avoid duplicate fields
  • Plan for future data expansion

Step 2: Importing and Integrating Subsurface Data

Once your database is set up, the next step is integrating existing data.


Importing Borehole Data

Gaea Synergy allows you to import:

  • Borehole logs from logging software
  • CSV or Excel datasets
  • Legacy project data

Integrating Laboratory Results

Laboratory data can be imported and linked to samples:

  • Match Sample IDs
  • Assign parameters
  • Validate units

Linking Data Across Tables

One of Gaea Synergy’s most powerful features is data linking.

For example:

  • A borehole is linked to multiple samples
  • Each sample is linked to multiple lab results

This relational structure enables complex queries and reporting.


Step 3: Linking Subsurface Data for Analysis

Linking data transforms raw datasets into actionable insights.


Relationships in the Database

Key relationships include:

  • Borehole → Sample
  • Sample → Laboratory Results
  • Project → Boreholes

Benefits of Data Linking

  • Eliminates redundancy
  • Ensures consistency
  • Enables advanced analysis

Example Workflow

  1. Create borehole BH01
  2. Add samples at various depths
  3. Import lab results for each sample
  4. Link results to borehole

Now, all data is connected and accessible.


Step 4: Visualizing Subsurface Data

Visualization is critical for interpreting subsurface conditions.


Borehole Logs and Profiles

Gaea Synergy allows you to:

  • Generate borehole logs
  • Display lithology layers
  • Annotate groundwater levels

Cross-Sections

Create cross-sections to:

  • Compare multiple boreholes
  • Identify stratigraphic trends
  • Visualize subsurface variability

Graphs and Charts

Visualize lab data using:

  • Time-series graphs
  • Parameter comparison charts
  • Trend analysis

GIS Integration

Map data spatially:

  • Borehole locations
  • Contamination plumes
  • Monitoring wells

Step 5: Reporting Subsurface Data

Reporting is one of the most time-consuming aspects of geotechnical projects.


Automated Report Generation

Gaea Synergy enables:

  • Predefined templates
  • Automatic data population
  • Consistent formatting

Types of Reports

  • Borehole logs
  • Laboratory summaries
  • Environmental site assessments
  • Monitoring reports

Benefits of Automated Reporting

  • Saves time
  • Reduces errors
  • Ensures consistency

Step 6: Managing and Storing Data Long-Term

Subsurface data often needs to be retained for years or decades.


Centralized Storage

All data is stored in a single database, making it:

  • Easy to access
  • Easy to update
  • Easy to share

Version Control

Track changes to:

  • Borehole data
  • Lab results
  • Reports

Data Security

Gaea Synergy provides:

  • User permissions
  • Secure access
  • Backup options

Step 7: Collaboration and Multi-User Access

Modern projects involve multiple stakeholders.


Multi-User Environment

Gaea Synergy supports:

  • Simultaneous access
  • Real-time updates
  • Role-based permissions

Improving Team Collaboration

  • Engineers access shared data
  • Field teams upload data directly
  • Managers review reports instantly

Step 8: Advanced Use Cases


Environmental Monitoring Programs

Track long-term groundwater data:

  • Compare results over time
  • Identify trends
  • Generate compliance reports

Contaminated Site Assessments

  • Map contamination plumes
  • Link lab data to locations
  • Support remediation planning

Large Infrastructure Projects

  • Manage hundreds of boreholes
  • Integrate geotechnical and environmental data
  • Generate large-scale reports

Best Practices for Using Gaea Synergy


1. Standardize Data Entry

  • Use templates
  • Define naming conventions
  • Train users

2. Maintain Data Quality

  • Validate imports
  • Perform QA/QC checks
  • Monitor anomalies

3. Leverage Automation

  • Automate reporting
  • Use data linking
  • Minimize manual entry

4. Plan for Scalability

  • Design flexible databases
  • Anticipate future needs

Common Challenges and Solutions


Challenge 1: Legacy Data Migration

Solution:
Clean and standardize data before import.


Challenge 2: Inconsistent Data Formats

Solution:
Use predefined templates and validation rules.


Challenge 3: User Adoption

Solution:
Provide training and clear workflows.


Challenge 4: Data Overload

Solution:
Use filters, queries, and visualization tools.



Digital Transformation

Moving from paper and spreadsheets to fully digital workflows.


Cloud-Based Databases

Access data from anywhere with secure cloud systems.


AI and Automation

  • Automated data extraction
  • Predictive modeling

Integration with GIS and BIM

Combining subsurface data with design and spatial tools.


Conclusion

Using Gaea Synergy to create a centralized database for subsurface data transforms how geotechnical and environmental projects are managed.

By integrating, linking, and displaying data within a single platform, you can:

  • Eliminate data silos
  • Improve accuracy
  • Streamline reporting
  • Enhance collaboration

Instead of juggling disconnected files and manual workflows, Gaea Synergy provides a unified system that connects every stage of your project—from field data collection to final reporting.

By implementing the strategies outlined in this guide, you can build a scalable, efficient, and future-ready subsurface data management workflow.

1 / ?