← Back to Queries
Points with Rock Depth Analysis
Statistical Query
Get points with rock depth statistics
SQL Query
SELECT
functionalkey,
latitude,
longitude,
elevation,
rock_depth,
(elevation - rock_depth) as rock_elevation,
total_depth
FROM webmap_gdms_points
WHERE rock_depth IS NOT NULL
ORDER BY rock_depth DESC
Run Query
This query does not require any parameters.