Re: [postgis-users] Simple Point Density Surface

2012-04-25 Thread JamesH
Pierre, Thank you for explaining demonstarting how it could be done. I apologise, I cannot fully understand how I would change the custom function to suit the purpose? Also for the Raster creation, where I would need to change the parameters to suit, would I just change 'snow' and '2010'. For thi

Re: [postgis-users] Simple Point Density Surface

2012-04-25 Thread Pierre Racine
inside the custom function. Pierre > -Original Message- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of JamesH > Sent: Wednesday, April 25, 2012 1:15 PM > To: postgis-users@postgis.refractions.net > Subje

Re: [postgis-users] Simple Point Density Surface

2012-04-25 Thread Doug_Newcomb
e U.S.Fish and Wildlife Service or Dept. of the Interior. Life is too short for undocumented, proprietary data formats. JamesH Sent by: postgis-users-boun...@postgis.refractions.net 04/25/2012 02:49 PM Please respond to PostGIS Users Discussion To postgis-users@postgis.refractions.n

Re: [postgis-users] Simple Point Density Surface

2012-04-25 Thread JamesH
"Why not convert the raster cell centers to points , do a query on the point layer for a square centered on the raster derived point whose dimensions are given by the number of tiles in your neighborhood. return the number of points divided by the area of the square. ( neighborhoods are usua

Re: [postgis-users] Simple Point Density Surface

2012-04-25 Thread Doug_Newcomb
Interior. Life is too short for undocumented, proprietary data formats. JamesH Sent by: postgis-users-boun...@postgis.refractions.net 04/25/2012 01:15 PM Please respond to PostGIS Users Discussion To postgis-users@postgis.refractions.net cc Subject [postgis-users] Simple Point Density

Re: [postgis-users] Simple Point Density Surface

2012-04-25 Thread 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

Re: [postgis-users] Simple Point Density Surface

2012-04-25 Thread Sandro Santilli
On Wed, Apr 25, 2012 at 10:15:22AM -0700, JamesH wrote: > Hi all, > > I am looking to take a point dataset and generate a point density raster in > PostGIS, similar to the ArcGIS Point Density tool in Spatial Analyst. > > What I believe I need to do is to define a neightbourhood around each outp

[postgis-users] Simple Point Density Surface

2012-04-25 Thread JamesH
Hi all, I am looking to take a point dataset and generate a point density raster in PostGIS, similar to the ArcGIS Point Density tool in Spatial Analyst. What I believe I need to do is to define a neightbourhood around each output raster cell centre and calculate a density value for each pixel ba