[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] identfying a nearest point
From: Supunmali Ahangama <supunmali7 () gmail ! com>
Date: 2009-04-24 19:29:16
Message-ID: 23223347.post () talk ! nabble ! com
[Download RAW message or body]
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@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.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic