[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