<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle"></style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">No problem. And as it is written as a function, it becomes a permanent feature in your database.
<div><br>
</div>
<div>Best,<br>
Steve<br>
<div><br>
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div class="WordSection1">
<p class="MsoNormal"><img src="http://sig.cmparks.net/cmp-ms-90x122.png" alt="http://sig.cmparks.net/cmp-ms-90x122.png" align="left" height="122" hspace="12" width="90">
<span style="font-size:14.0pt; font-family:"Arial","sans-serif"; color:#006C56">Stephen V. Mather<br>
</span><span style="font-size:11.0pt; font-family:"Arial","sans-serif"; color:#006C56">GIS Manager<br>
</span><span style="font-size:9.0pt; font-family:"Arial","sans-serif"; color:#006C56">(216) 635-3243 (Work)
</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"><a href="http://www.clemetparks.com" target="_blank"><span style=""><br>
clevelandmetroparks.com</span></a></span></p>
<p class="MsoNormal"></p>
<br>
</div>
</div>
<div></div>
</div>
</div>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF802303" style="direction: ltr;"><font face="Tahoma" size="2" color="#000000"><b>From:</b> postgis-users-bounces@lists.osgeo.org [postgis-users-bounces@lists.osgeo.org] on behalf of Luis Carrasco [leca00@gmail.com]<br>
<b>Sent:</b> Tuesday, January 29, 2013 2:16 PM<br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> Re: [postgis-users] Request to develop st_pointonsurface variant to output a random point (not an arbitrary one)<br>
</font><br>
</div>
<div></div>
<div>Thanks Steven!<br>
<br>
I think that puts me in the right direction.<br>
<br>
Best regards,<br>
<br>
Luis<br>
<div class="gmail_quote"><br>
On Tue, Jan 29, 2013 at 2:01 PM, Stephen V. Mather <span dir="ltr"><<a href="mailto:svm@clevelandmetroparks.com" target="_blank">svm@clevelandmetroparks.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div>
<div style="direction:ltr; font-size:10pt; font-family:Tahoma">You might look to this post:
<div><br>
</div>
<div><a href="http://sorokine.blogspot.com/2011/05/postgis-function-for-random-point.html" target="_blank">http://sorokine.blogspot.com/2011/05/postgis-function-for-random-point.html</a></div>
<div><br>
</div>
<div>Best,<br>
Steve<br>
<div><br>
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div>
<p class="MsoNormal"><span style="font-size:14.0pt; font-family:"Arial","sans-serif"; color:#006c56">Stephen V. Mather<br>
</span><span style="font-size:11.0pt; font-family:"Arial","sans-serif"; color:#006c56">GIS Manager<br>
</span><span style="font-size:9.0pt; font-family:"Arial","sans-serif"; color:#006c56"><a href="tel:%28216%29%20635-3243" value="+12166353243" target="_blank">(216) 635-3243</a> (Work)
</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1f497d"><a href="http://www.clemetparks.com" target="_blank"><span><br>
clevelandmetroparks.com</span></a></span></p>
<p class="MsoNormal"></p>
<br>
</div>
</div>
<div></div>
</div>
</div>
<div style="font-size:16px; font-family:Times New Roman">
<hr>
<div style="direction:ltr"><font color="#000000" face="Tahoma"><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">
postgis-users-bounces@lists.osgeo.org</a> [<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] on behalf of Luis Carrasco [<a href="mailto:leca00@gmail.com" target="_blank">leca00@gmail.com</a>]<br>
<b>Sent:</b> Tuesday, January 29, 2013 1:53 PM<br>
<b>To:</b> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<b>Subject:</b> [postgis-users] Request to develop st_pointonsurface variant to output a random point (not an arbitrary one)<br>
</font><br>
</div>
<div>
<div class="h5">
<div></div>
<div>Hello,<br>
<br>
This is more of a wishlist item. I've tried using st_pointonsurface as part of a point geomasking routine but all the points I get follow the same pattern of angle and direction. Could a new function be integrated into postgis where the output point has a random
location within a surface? I'm solving my problem by using a different approach for my purposes which ends being a little more complicated (therefore, this request), but I think returning a true random point could help other colleagues as well when working
with a large dataset.<br>
<br>
Thanks,<br>
<br>
Luis<br clear="all">
<br>
-- <br>
<span lang="en-US"><font color="black" face="Tahoma"><span dir="ltr" style="font-size:10pt">
<div><br>
<div><font size="1"><span style="font-size:13px">
<div>
<div>
<div>
<div>
<div style="margin-top:0; margin-bottom:0"><font face="Arial"><span style="font-size:10pt">Luis Eduardo Carrasco, Ph.D.</span></font>
<br>
<font face="Arial"><span style="font-size:10pt">Spatial Analyst</span></font> <br>
<font face="Arial"><span style="font-size:10pt">Health & Spatial Analysis Unit</span></font><font face="Times New Roman" size="3"><span style="font-size:12pt">
</span></font><font face="Times New Roman" size="3"><span style="font-size:12pt"><br>
</span></font><font face="Arial"><span style="font-size:10pt">State Center for Health Statistics &</span></font>
<br>
<font face="Arial"><span style="font-size:10pt">UNC</span></font> <font face="Arial">
<span style="font-size:10pt">Lineberger Comprehensive Cancer Center</span></font>
<br>
<font face="Arial"><span style="font-size:10pt">Department of Health and Human Services</span></font>
</div>
</div>
</div>
</div>
</div>
</span></font></div>
</div>
</span></font></span><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
Luis Eduardo Carrasco, Ph.D.<br>
919.757.5574<br>
skype: luis_e_carrasco<br>
<a href="mailto:leca00@gmail.com" target="_blank">leca00@gmail.com</a><br>
<a href="http://www.unc.edu/%7Elecarras/" target="_blank">http://www.unc.edu/~lecarras/</a><br>
</div>
</div>
</div>
</div>
</body>
</html>