Hot answers tagged

1

You're missing a GROUP BY to specify aggregation of the rows. WITH clusters AS( SELECT row_number() OVER () AS cluster_id, unnest(ST_ClusterWithin(table.geom, 250)) AS gc FROM table) , unclustered AS( SELECT cluster_id, unnest(gc) AS geom FROM clusters) SELECT cluster_id as gid, string_agg(table.amenity, ';' ORDER BY table....


1

Try to use ST_GeogFromText instead of ST_GeomFromText select * from circles where st_intersects (towers.the_geog,ST_Buffer(ST_Transform(ST_GeogFromText('POINT(-105.04428 39.74779)', 4326), 2877), 1500));



Only top voted, non community-wiki answers of a minimum length are eligible