Predefined Queries

Run predefined queries to analyze geotechnical data in the GDMS database.

Example queries already exist.
View Execution History Add Example Queries

All Points

Basic Query
Get all geotechnical points in the database
Run Query

Average Elevation by Type

Statistical Query
Calculate average elevation grouped by point type
Run Query

Points by Date Range

Advanced Query
Get points completed within a specific date range
Run Query

Points by Elevation Range

Advanced Query
Get points within a specific elevation range
Run Query

Points by Geographic Area

Spatial Query
Get points within a specific geographic bounding box
Run Query

Points by Project

Basic Query
Get points associated with a specific project
Run Query

Points by Type

Basic Query
Get points filtered by type
Run Query

Points with Rock Depth Analysis

Statistical Query
Get points with rock depth statistics
Run Query