<div>Thanks Brent for the good info. You are always good help on this list.. </div><div> </div><div>And thanks as always Simon. Your St_Voronoi is going to do exactly what I need done. </div><div> </div><div>Simon has been a great resource over the last year to me and continues to provide with this script. </div>
<div> </div><div>Many Thanks,<br><br>DC</div><div><br></div>-----------------------------------------------------------<div>Daniel Cole</div><br>
<br><br><div class="gmail_quote">On Sat, Sep 8, 2012 at 10:30 PM, <span dir="ltr"><<a href="mailto:pcreso@pcreso.com" target="_blank">pcreso@pcreso.com</a>></span> wrote:<br><blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
<table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td style="font:inherit;font-size-adjust:inherit;font-stretch:inherit" valign="top">Hi Daniel,<br><br>Do you want regular cells or polygons?<br><br>There are a few approaches for generating voronoi polygons in Postgis:<br>
<br>eg:<br><a href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut02" target="_blank">http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut02</a><br><a href="http://geogeek.garnix.org/2012/04/faster-voronoi-diagrams-in-postgis.html" target="_blank">http://geogeek.garnix.org/2012/04/faster-voronoi-diagrams-in-postgis.html</a><br>
<br>If your points already represent the centre of cells, then a fishnet approach would work, generate a mesh to match the grid, then do a spatial join on points inside cells to generate the match. You just need to know the extent & size of the grid:<br>
<br><a href="http://trac.osgeo.org/postgis/wiki/UsersWikiCreateFishnet" target="_blank">http://trac.osgeo.org/postgis/wiki/UsersWikiCreateFishnet</a><br><br><br>HTH,<br><br> Brent Wood<br><br>--- On <b>Sun, 9/9/12, Daniel Cole <i><<a href="mailto:daniel@southernsolutionsms.com" target="_blank">daniel@southernsolutionsms.com</a>></i></b> wrote:<br>
<blockquote style="padding-left:5px;margin-left:5px;border-left-color:rgb(16,16,255);border-left-width:2px;border-left-style:solid"><br>From: Daniel Cole <<a href="mailto:daniel@southernsolutionsms.com" target="_blank">daniel@southernsolutionsms.com</a>><br>
Subject: [postgis-users] create 1 cell/polygon per point inside bounding polygon<br>To: <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>Date: Sunday, September 9, 2012, 3:02 PM<div>
<div class="h5"><br><br><div><div><br></div><div>I want to be able to take a polygon that has 3 to 50 points inside of it and create polygon where each point is the only point inside of it a cell and it is located at the centroid, or at least close. The points are already in a sort of grid shape, so want my cells as uniform size as possible although I
assume the cells containing the outer-most points may be larger or smaller. Any cell on the outer edges will be clipped by the original bounding polygon. </div>
<div><br></div><div>I thought that I might could use something like fishnetting, but I want to be sure that there are just the same number of cells are there are points. </div><div><br></div><div>I have attached an image that I made using the nearest neighbor algorithm and I think and the look is basically what I wanting to do, but where you see the color there, there would be a cell unique to that point. If anyone knew anway to reverse that raster into cells that would help too. thanks. </div>
<div><br></div><div>any thoughts?</div><div><br></div><div>DC</div><div><br></div>-----------------------------------------------------------<div>Daniel Cole</div><br>
</div><br></div></div>-----Inline Attachment Follows-----<br><br><div>_______________________________________________<br>postgis-users mailing list<br><a href="http://mc/compose?to=postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></div></blockquote></td></tr></tbody></table><br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br>