How about:
distance(the_geom, transform(GeometryFromText('POINT(10 10)',4326),
srid(the_geom)))-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
