<!DOCTYPE html><html><head>
<style type="text/css">body { font-family:'Times New Roman'; font-size:13px}</style>
</head>
<body><div>Brent,</div><div><br></div><div><br></div><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td valign="top" style="font: inherit;">I have Simon's code working fine, at least using his example invocation, from:<br><a href="http://www.spatialdbadvisor.com/postgis_tips_tricks/290/r-based-delaunay-triangulation-function-for-postgis-using-the-deldir-package">http://www.spatialdbadvisor.com/postgis_tips_tricks/290/r-based-delaunay-triangulation-function-for-postgis-using-the-deldir-package</a><br><br>But I can't figure out how to make it work with my point data. I don't know R or PL/R well enough to adapt it.<br><br>I have a set of sample points in a table:<br><br><font face="courier,monaco,monospace,sans-serif"> Column | Type
| <br> --------+-----------------+-----------------<br> id | integer | not null default<br> geom | geometry(Point) | </font><br><br>Can anyone explain, ideally in words of one syllable or less, how Simon's function from the link above needs to be adapted to read my points dataset as input?</td></tr></tbody></table></blockquote><div><br></div><div>Just pass in a valid SQL statement that exposes your x y and z point values eg:</div><div><br></div><div>SELECT ST_Delaunay_Triangles('select ST_X(p.geom) as x,ST_Y(p.geom) as y,ST_Z(p.geom) from sample_points_in_table p') as triangle;<br></div><div><br></div><div>regards<br></div><div>Simon</div><div id="M2Signature"><div>-- </div><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>