[postgis-users] identfying a nearest point

Supunmali Ahangama supunmali7 at gmail.com
Fri Apr 24 12:06:49 PDT 2009

Stephen Woodbridge wrote:
> select postgis_full_version();
>> select postgis_version();
>> select astext(the_geom) from customer_location where gid=1;
>> "POINT(-96.7396491708658 32.9772528902849)"
> This data is in lat,long degrees
>> select astext(the_geom) from vertices_tmp limit 1;
>> "POINT(2512160.45149086 7040141.09734678)"
> This data is in some projection in meters or feet.
> This is your problem. You are using data in two separate projections. 
> You need to make sure you use data in a consistent projection or that 
> you take the appropriate steps to project the one set of data into the 
> other projection before you try to use them.
> -Steve
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Thank you very much for the quick responses.

But I have the srid(the_geom) = 2276 in both tables.

So can they be in two projections? I am new to GIS development. So Please
suggest me why I am getting incorrect answers. In previous equations I used
2276 instead of 4326 for all.

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

More information about the postgis-users mailing list