[postgis-users] Re: maximum distance between a POINT and POLYGON
Obe, Regina
robe.dnd at cityofboston.gov
Thu Feb 19 07:35:49 PST 2009
I should add when implemented it would work for all geometries similar
to the way ST_Distance does.
So think of ST_Distance as ST_Min_Distance
________________________________
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Obe,
Regina
Sent: Thursday, February 19, 2009 10:29 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Re: maximum distance between a POINT and
POLYGON
It hasn't been implemented. Well it was a long long time ago, but the
logic was incorrect so it was turned off.
We plan to bring it back probably in a 1.4.something or 1.5
________________________________
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
nicklas.aven at jordogskog.no
Sent: Thursday, February 19, 2009 8:50 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Re: maximum distance between a POINT and
POLYGON
Hallo
What is the problem with ST_Max_Distance(geometry g1, geometry g2)?
/Nicklas
2009-02-19 My Pid wrote:
Hello again,
>
>I found the generate_series function (yes i am a newbie!) and I can use
it in order to calculate the distance between
> my centroid (geometry_centroid) and my polygon (geometry_zone) with
the following request
>
>
>SELECT
(distance_spheroid(geometry_centroid,ST_AsText(ST_PointN(ExteriorRing(ge
ometry_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';
>
>Now I can't use the max function because of the following error:
"set-valued function called in context that cannot accept a set"
>when I use
>
>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';
>
>
>any idea ?
>
>thanks!
>Nick
>
>
>>
2009/2/18 My Pid <mamat750 at gmail.com>
>Hello,
>
>I would like to know how I could get the maximum distance between a
POINT and a POLYGON.
> (the POINT i am talking about here is in fact the ST_Centroid of the
mentionned POLYGON)
>
>I looked for a function that transform my POLYGON into several POINT
but without success.
>
>I am working with longitude, latitude, altitude for POINT
>It is really the max distance that I am looking for (not the minimum
distance.)
>and "accuracy" is important to me.
>
>thanks in advance for your help !
>
>regards,
>Nick
>
>
>
>
________________________________
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.
________________________________
Help make the earth a greener place. If at all possible resist printing
this email and join us in saving paper.
-----------------------------------------
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090219/ef53f8c6/attachment.html>
More information about the postgis-users
mailing list