<!DOCTYPE html><html><head>
<meta content="text/html; charset=us-ascii" http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 9.00.8112.16443">
<style type="text/css">"body { font-family:'Times New Roman'; font-size:13px"}</style>
<style type="text/css">"body { font-family:'Times New Roman'; font-size:13px"}</style>
</head>
<body>Sorry, folks, last email had an incomplete Subject.<br><br>I had need of a Delaunay Trianguation function for use with PostGIS 2.0.<div><br></div><div>I found David Leahy's email post and Regine Obe's blog article on a vonoroi article using pl/R and Dr Rolf Turner's deldir package.<br></div><div><br></div><div>My initial function created the delaunay triangles but the triangles were 2D. I needed a function that maintained any Z attribute associated with the XY points passed in to the function.</div><div><br></div><div>I contacted Dr Rolf Turner. Rolf changed the base deldir function in the package to maintain any Z or associated value with the XY point set such that the returned triangles still have their Z values.</div><div><br></div><div>I have written a short blog article on this which includes the source code.</div><div><br></div><div>http://www.spatialdbadvisor.com/postgis_tips_tricks/290/r-based-delaunay-triangulation-function-for-postgis-using-the-deldir-package</div><div><br></div><div>Any comments, suggested improvements greatly welcomed.</div><div><br></div><div>NOTE: After my initial experience with deldir I installed Jaspa and used its ST_DelaunayTriangles function: it works beautifully and quickly.</div><div>But installing a whole replacement spatial type for Postgresql to get access to one function is overkill (and I don't have time to extract just</div><div>one function). In addition the solution is problematic due to pl/Java releases being behind PostgreSQL releases. And finally, the manual</div><div>nature of installation which while not a problem for me, it is for my less technical customers.</div><div><br></div><div>regards</div><div>Simon</div><div id="M2Signature"><div>-- </div></div><div id="M2Signature"><div>Holder of "2011 Oracle Spatial Excellence Award for Education and Research."<br>SpatialDB Advice and Design, Solutions Architecture and Programming,<br>Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional<br>Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.<br>39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.<br>Website: www.spatialdbadvisor.com<br> Email: simon@spatialdbadvisor.com<br> Voice: +61 362 396397<br>Mobile: +61 418 396391<br>Skype: sggreener<br>Longitude: 147.20515 (147° 12' 18" E)<br>Latitude: -43.01530 (43° 00' 55" S)<br>GeoHash: r22em9r98wg<br>NAC:W80CK 7SWP3</div></div></body></html>