[postgis-users] distance between two points

Rich Gibson rich at testingrange.com
Mon Nov 8 09:08:14 PST 2004


select distance_spheroid(
	GeometryFromText('POINT(-122.8412 38.4112)', 4326),
	GeometryFromText('POINT(-122.4750 37.8073)', 4326),
	'SPHEROID["WGS_1984",6378137,298.257223563]'
 )    / 1609.344



On Mon, 8 Nov 2004, pinktomate, el gato de amarilla wrote:

> hi all
> 
> whats the exactly query in postgis to calculate the distance between two
> points, every one with a east north coordinate???
> 
> regards for the help
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 



More information about the postgis-users mailing list