[postgis-users] ST_distance in meters

[Suhr, Ralf]

ST_Distance_Spheroid( pointa, pointb, 'SPHEROID["WGS 84",6378137,298.257223563]');

Gr Ralf

-----Ursprüngliche Nachricht-----
Von: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] Im Auftrag von lomarod
Gesendet: Freitag, 22. Januar 2010 12:18
An: postgis-users at postgis.refractions.net
Betreff: [postgis-users] ST_distance in meters


Hi,

I have a table "tableA" with the column "colB" and "colC" type geometry.

tableA.colB = geometryfromtext('POINT('-19.922488 -43.9367')',4326)
tableA.colC = geometryfromtext('POINT('-19.926357 -43.934223')',4326)

Using google earth or google maps, a have the distance between this two
points in 500 meters.

When I execute the query
select st_distance(tableA.colB, tableA.colC) from tableA my result is
0,004593984...

How can I have the same result as google maps ?
What am I doing wrong ?


-- 
View this message in context: http://old.nabble.com/ST_distance-in-meters-tp27271750p27271750.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