[postgis-users] identfying a nearest point

[Supunmali Ahangama]

Stephen Woodbridge wrote:
> 
> 
> select postgis_full_version();
> 
>> 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)"
> 
> 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.

Thanks.
-- 
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.