[postgis-users] Transformation problem using transform()

[Michael Fuhr]

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