Hi all
I am trying to work out how to return the distances from a user
defined location but not too sure how. My query follows;
select * from azev2_1 where distance_spheroid(GeomFromText('Point(-70
20)',4326),the_geom,'SPHEROID["WGS 84",6378137,298.257223563]') <
250000;
This provides all the point features located within 250000 metres of
the coordinates -70, 20 but how do I return the distances that each
feature is away from those coordinates?
Any ideas would be much appreciated.
Many thanks
Mark
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users