RE: Distance function is not in meters

How about:
distance(the_geom, transform(GeometryFromText('POINT(10 10)',4326),
srid(the_geom)))

-----Original Message-----
From: postgis-users-bounces@...
[mailto:postgis-users-bounces@...] 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@...> 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@...
        > http://postgis.refractions.net/mailman/listinfo/postgis-users
        >
        _______________________________________________
        postgis-users mailing list
        postgis-users@...
        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>


_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users