[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