Supunmali Ahangama wrote:
Stephen Woodbridge wrote:
What is the response to the following queries:
select full_postgis_version();
select astext(the_geom) from customer_location where
> gid=1;
select astext(the_geom) from vertices_tmp limit 1;
-Steve
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
Hi Steve,
select full_postgis_version(); is not working. But,
Sorry, that should have been:
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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
