Re: [postgis-users] I can't make sense of this.

2010-05-20 Thread Ronald Phillips
4326. > Instead, they're wildly different. So, I know I am misunderstanding in some > basic way. > > > > Ron > > > > > > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] On Be

Re: [postgis-users] I can't make sense of this.

2010-05-20 Thread Paul Ramsey
ay. > > > > Ron > > > > > > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Emilie > Laffray > Sent: Thursday, May 20, 2010 12:48 PM > To: PostGIS Us

Re: [postgis-users] I can't make sense of this.

2010-05-20 Thread Paul Ramsey
3857 is a Mercator projection. Your coordinates are geographics. If you mis-declare your SRS (as, in your case, declaring that geographics are mercators) then transform will spit out funny numbers on the basis of that initial mistake. P On Thu, May 20, 2010 at 9:38 AM, Ronald Phillips wrote: > S

Re: [postgis-users] I can't make sense of this.

2010-05-20 Thread Ronald Phillips
stgis.refractions.net] On Behalf Of Emilie Laffray Sent: Thursday, May 20, 2010 12:48 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] I can't make sense of this. Why would you expect them to be similar? There are different sets of coordinates. Your first set of coordinates looks like

Re: [postgis-users] I can't make sense of this.

2010-05-20 Thread Emilie Laffray
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" wrote: SELECT ST_AsText( ST_

[postgis-users] I can't make sense of this.

2010-05-20 Thread Ronald Phillips
SELECT ST_AsText( ST_GeomFromText('POINT(-81.064544 40.28787)', 3857) ) AS goog, ST_AsText( ST_Transform( ST_GeomFromText('POINT(-81.064544 40.28787)', 385