[postgis-users] Simple Point Density Surface

JamesH james.holmes at newcastle.ac.uk
Wed Apr 25 10:59:57 PDT 2012

"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 


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.

More information about the postgis-users mailing list