[postgis-users] identfying a nearest point

[Supunmali Ahangama]

Supunmali Ahangama wrote:
> 
> 
> 
> 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.
> 


Its working. I used a different data set with srid=2276, it works for it.
Though it says 2276 in customer_location table (in postgres create table
script), I think the projection is different. 
Thanks a lot.
-- 
View this message in context: http://www.nabble.com/identfying-a-nearest-point-tp23193816p23223347.html
Sent from the PostGIS - User mailing list archive at Nabble.com.