Many thanks for your help David, it works!
select astext(the_geom), distance_spheroid(GeomFromText('Point(-70
20)',4326),the_geom,'SPHEROID["WGS 84",6378137,298.257223563]') from
azev2_1 group by 1,2 having
distance_spheroid(GeomFromText('Point(-70
20)',4326),the_geom,'SPHEROID["WGS 84",6378137,298.257223563]') <
250000;
What I need also is a field name from azev2_1 called sitename.. I am a
little bit confused as to where I need to put this in this query now?
Thanks again!
Mark
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
