[postgis-users] identfying a nearest point

[Supunmali Ahangama]

Stephen Woodbridge wrote:
> 
> 
> What is the response to the following queries:
> 
> select full_postgis_version();
> select astext(the_geom) from customer_location where
>  > gid=1;
> select astext(the_geom) from vertices_tmp limit 1;
> 
> -Steve
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

Hi Steve,

select full_postgis_version(); is not working. But,

select postgis_version();
"1.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"


select astext(the_geom) from customer_location where gid=1;
"POINT(-96.7396491708658 32.9772528902849)"


select astext(the_geom) from vertices_tmp limit 1;
"POINT(2512160.45149086 7040141.09734678)"

-- 
View this message in context: http://www.nabble.com/identfying-a-nearest-point-tp23193816p23220034.html
Sent from the PostGIS - User mailing list archive at Nabble.com.