<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16788" name=GENERATOR></META></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=830263415-19022009><FONT face=Arial
color=#0000ff size=2>I should add when implemented it would work for all
geometries similar to the way ST_Distance does.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=830263415-19022009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=830263415-19022009><FONT face=Arial
color=#0000ff size=2>So think of ST_Distance as
ST_Min_Distance</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=830263415-19022009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=830263415-19022009></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Obe,
Regina<BR><B>Sent:</B> Thursday, February 19, 2009 10:29 AM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> RE: [postgis-users] Re: maximum
distance between a POINT and POLYGON<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=848352815-19022009><FONT face=Arial
color=#0000ff size=2>It hasn't been implemented. Well it was a long long
time ago, but the logic was incorrect so it was turned off.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=848352815-19022009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=848352815-19022009><FONT face=Arial
color=#0000ff size=2>We plan to bring it back probably in a 1.4.something or
1.5</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>nicklas.aven@jordogskog.no<BR><B>Sent:</B> Thursday, February 19, 2009 8:50
AM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users]
Re: maximum distance between a POINT and POLYGON<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hallo</DIV>
<DIV> </DIV>
<DIV>What is the problem with <SPAN
style="FONT-FAMILY: Courier New"><STRONG>ST_Max_Distance</STRONG>(</SPAN>geometry
<VAR class=pdparam>g1</VAR>, geometry <VAR
class=pdparam>g2</VAR><CODE>)?</CODE></DIV>
<P><CODE></CODE></P>
<P><CODE>/Nicklas</CODE></P>
<DIV><BR><BR>2009-02-19 My Pid wrote:<BR><BR>Hello again,<BR>><BR>>I found
the generate_series function (yes i am a newbie!) and I can use it in order to
calculate the distance between<BR>> my centroid (geometry_centroid) and
my polygon (geometry_zone) with the following
request<BR>><BR>><BR>>SELECT
(distance_spheroid(geometry_centroid,ST_AsText(ST_PointN(ExteriorRing(geometry_zone),
generate_series(1,(SELECT npoints(geometry_zone) FROM "208_1_26624_zones" WHERE
"cellID"='1')))), 'SPHEROID["WGS 84",6378137,298.257223563]')) as d FROM
"208_1_26624_zones" WHERE "cellID"='1';<BR>><BR>>Now I can't use the max
function because of the following error: "set-valued function called in context
that cannot accept a set"<BR>>when I use<BR>><BR>>SELECT
max(distance_spheroid(geometry_centroid,ST_AsText(ST_PointN(ExteriorRing(geometry_zone),
generate_series(1,(SELECT npoints(geometry_zone) FROM "208_1_26624_zones" WHERE
"cellID"='1')))), 'SPHEROID["WGS 84",6378137,298.257223563]')) as d FROM
"208_1_26624_zones" WHERE "cellID"='1';<BR>><BR>><BR>>any idea
?<BR>><BR>>thanks!<BR>>Nick<BR>><BR>><BR>>></DIV>
<DIV>2009/2/18 My Pid <<A
target=_blank>mamat750@gmail.com</A>><BR>>Hello,<BR>><BR>>I would
like to know how I could get the maximum distance between a POINT and a
POLYGON.<BR>> (the POINT i am talking about here is in fact the ST_Centroid
of the mentionned POLYGON)<BR>><BR>>I looked for a function that transform
my POLYGON into several POINT but without success.<BR>><BR>>I am working
with longitude, latitude, altitude for POINT<BR>>It is really the max
distance that I am looking for (not the minimum distance.)<BR>>and "accuracy"
is important to me.<BR>><BR>>thanks in advance for your help
!<BR>><BR>>regards,<BR>>Nick<BR>><BR>><BR>></DIV><BR>>
<P>
<HR SIZE=1>
<P></P>
<P><STRONG>The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure pursuant to
Massachusetts law. It is intended solely for the addressee. If you received this
in error, please contact the sender and delete the material from any computer.
</STRONG></P>
<P>
<HR SIZE=1>
<P></P>
<P><STRONG><FONT color=#339900 size=2>Help make the earth a greener place. If at
all possible resist printing this email and join us in saving paper. </P>
<P></FONT></STRONG></P></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>