← Back to Queries
Average Elevation by Type
Statistical Query
Calculate average elevation grouped by point type
SQL Query
SELECT spt_type, AVG(elevation) as avg_elevation, COUNT(*) as count
FROM webmap_gdms_points
GROUP BY spt_type
Run Query
This query does not require any parameters.