"SELECT st_centroid(st_collect(the_geom)), count(*) FROM mytable GROUP BY ST_SnapToGrid(the_geom, cellsize)"
Thank you, would you visualise this with PixelAsPolygons? I'm trying to view it in OpenJump, trying something like: SELECT ST_AsBinary((gv).geom, (gv).val FROM (SELECT ST_PixelAsPolygons(St_Centroid(ST_Collect(the_geom)), count(*) FROM buses GROUP BY ST_SnapToGrid(the_geom, 50)) foo Regards, James ----- GIS Undergraduate -- View this message in context: http://postgis.17.n6.nabble.com/Simple-Point-Density-Surface-tp4917343p4917479.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
