[postgis] distance(geometry,geometry) function
Timothy H. Keitt
tklistaddr at keittlab.bio.sunysb.edu
Tue Jul 24 06:47:08 PDT 2001
I assume you mean euclidean distance. A lot of us keep our locations in
geodetic coordinates. It would be nice if geometries could reference a
particular datum so these things would be handled transparently.
(Postgis is nonetheless a very exciting development.)
Cheers,
Tim
Dave Blasby wrote:
>Due to popular demand, I've added the function;
>
>distance(geometry,geometry)
> :- finds the minimum distance between the two geometries
>
>now you can do things like;
>
>select * from <table> where distance(<geometry col>,'POLYGON(0 0, 0 10,
>10 10, 10 0, 0 0)') < 10.0;
>
>which will find anything that is within 10 units of the given polygon.
>
>This will greatly increase the complexity of spatial queries users will
>be able to perform.
>
>I'm still testing it; it should hit the CVS version in the next few
>days.
>
>dave
>
>
>To unsubscribe from this group, send an email to:
>postgis-unsubscribe at yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
--
Timothy H. Keitt
Department of Ecology and Evolution
State University of New York at Stony Brook
Stony Brook, New York 11794 USA
Phone: 631-632-1101, FAX: 631-632-7626
http://life.bio.sunysb.edu/ee/keitt/
To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
More information about the postgis-users
mailing list