[postgis-users] identfying a nearest point
supunmali7 at gmail.com
Fri Apr 24 12:06:49 PDT 2009
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.
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