[postgis-users] distance calculation usng lat and long in miles

sunithab at travelpost.com sunithab at travelpost.com
Wed Mar 8 09:43:18 PST 2006

I have the lat and long data. I have created the geom column based on the 
lat and long data as below.

     UPDATE property SET geom =GeometryFromText('POINT(' || long ||
     ' ' || lat || ')',4326);

Now I have the geom columns in two tables

I am calculating the distance as below

select distance(geom1, geom2)* 69.055

It seems to be right. But I want to make sure.

Thanks for help in advance.

More information about the postgis-users mailing list