[postgis-users] Simple Point Density Surface

[JamesH]

"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.