[postgis-users] Distance function is not in meters
Bruce Rindahl
rindahl at lrcwe.com
Tue Mar 18 12:24:32 PDT 2008
How about:
distance(the_geom, transform(GeometryFromText('POINT(10 10)',4326),
srid(the_geom)))
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of David
Jordan
Sent: Tuesday, March 18, 2008 1:01 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Distance function is not in meters
If I use sphere they have to both be points, the actual search I am doing is
distance(the_geom, GeometryFromText('POINT(10 10)',4326))
the_geom field is a polygon or a multipolygon
Paul Ramsey <pramsey at cleverelephant.ca> wrote:
distance_sphere(GeometryFromText('POINT(10 10)',4326),
GeometryFromText('POINT(11 11)',4326))
On 3/18/08, davidj2k wrote:
>
> I am trying to find the distance from a point to a polygon object
and when I
> use the distance(geometry,geometry) function it returns something
that is
> not in meters, I have been doing searches and all the examples of
using this
> function shows it in meters but that is not what I am seeing for
example if
> I use
>
> distance(GeometryFromText('POINT(10 10)',4326),
GeometryFromText('POINT(11
> 11)',4326))
>
> I get
>
> 1.4142135623731
>
> How can I get this in meters? I need to do
> distance < 1000 meters
>
> --
> View this message in context:
http://www.nabble.com/Distance-function-is-not-in-meters-tp16127891p16127891
.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
________________________________
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
<http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/c
ategory.php?category=shopping>
More information about the postgis-users
mailing list