[postgis-users] identfying a nearest point
supunmali7 at gmail.com
Fri Apr 24 12:29:16 PDT 2009
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.
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
> 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.
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.
More information about the postgis-users