[postgis-users] Transformation problem using transform()

Marc Angelo computrain at paradise.net.nz
Tue May 2 03:03:44 PDT 2006


Hi

Thanks very much Michael that worked but maybe someone can help me with
this. If I run those waypoints through a transform I get the following
geometry:-

SELECT Transform(position,27200) FROM waypoints =
0101000020406A0000B856779E53AB41417FC37EE399E55441


Ran the geometry through the AsEWKT function as follows:-

SELECT AsEWKT('0101000020406A0000B856779E53AB41417FC37EE399E55441');


...and I get the following answer.
"SRID=27200;POINT(2315943.23801693 5477991.55461204)"

I have now changed my import code to change the Lat Long of the co-ordinates
around which does give me the correct Lat Long using the AsEWKT function
using srid 4269 and 4326 but I get the above result using other srid's such
as 27200......

any help would be greatly appreciated

Cheers
Marc


----- Original Message -----
From: "Michael Fuhr" <mike at fuhr.org>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Monday, May 01, 2006 11:24 AM
Subject: Re: [postgis-users] Transformation problem using transform()


> On Mon, May 01, 2006 at 10:12:47AM +1200, Marc Angelo wrote:
> > The following is a random sample of the different srid's I tried to
> > transform to:
> > 2014,27200,2029,2848,26705,27231
> > It seems that apart from trying to transform to 4269 all other
> > transformations fail with the error:
> > ERROR:  transform: couldn't project point: -45 (geocentric
transformation
> > missing z or ellps)
> >
> > The following is the one and only current record in the spatial table:
> >
1;"E004010001CC1B0F";"2006-04-30";"-45.879185";"170.50196";"0101000020E61000
> > 001F11532289F046C0CEFC6A0E10506540"
>
> Looks like latitude and longitude are in the wrong order:
>
> postgis=> SELECT
AsEWKT('0101000020E61000001F11532289F046C0CEFC6A0E10506540');
>                 asewkt
> ---------------------------------------
>  SRID=4326;POINT(-45.879185 170.50196)
> (1 row)
>
> Geometries are (X,Y) so lat/lon coordinates should be (lon,lat).
>
> --
> Michael Fuhr
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.385 / Virus Database: 268.5.1/327 - Release Date: 28/04/2006
>
>




More information about the postgis-users mailing list