Why would you expect them to be similar? There are different sets of coordinates. Your first set of coordinates looks like wgs84 but you set the srid to Google srid. It doesn't make sense.
On 20 May 2010 17:38, "Ronald Phillips" <[email protected]> wrote: SELECT ST_AsText( ST_GeomFromText('POINT(-81.064544 40.28787)', 3857) ) AS goog, ST_AsText( ST_Transform( ST_GeomFromText('POINT(-81.064544 40.28787)', 3857) , 4326) ) AS gcs 3857 is “Google’s” SRID, and 4326 is a fairly standard GPS SRID. I’m getting this: Goog: "POINT(-81.064544 40.28787)"; Gcs: "POINT(-0.000728215188753794 0.000361912093851508)" What am I doing wrong, that they’re so different? Ronald Phillips, B.S., M.S. Programmer/Analyst Summit County Engineer 538 E. South St. Akron OH 44311 330.643.8061 http://www.linkedin.com/in/rwphillips _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
