I have points that form a line. I would like to assign a radius to each point to give them volume, e.g. 50m and then find the area of the combined points. Does anyone know of a way to do this in PostGIS?
I guess you mean the area of the combined 50m buffers?
If so, then like this:
SELECT SUM(ST_Area(ST_Buffer(geom, 50))) FROM points;
This assumes that the points are projected in a CRS with meters as units. And I'm not sure I understand what you mean by "points that form a line". Is the PostGIS table a point feature or line feature?
If the area of the buffers should be combined (as not to count the same area several times) then this query should be used:
SELECT ST_Area(ST_Union(ST_Buffer(geom, 50))) FROM points;