[postgis-users] Transformation problem using transform()

[Marc Angelo]

Sorry about that
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"

The Lat and Long are only text fields which come from a text file.....When I
insert the text file data, I brought across the text Lat and Long as well so
I could possibly see what was happening in various functions when applied to
the "geom" (in my case it's called position) field. The 2nd field is an rfid
tag ID

Cheers
Marc


----- Original Message -----
From: "Paul Ramsey" <pramsey at refractions.net>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Monday, May 01, 2006 4:00 AM
Subject: Re: [postgis-users] Transformation problem using transform()


> Marc,
>
> Not quite enough information...
>
> "using various srid's" ... which ones?
>
> And what particular points give the failure?
>
> P
>
> On 30-Apr-06, at 6:05 AM, Marc Angelo wrote:
>
> > Hi Everyone
> >
> > I have a quick question regarding using the transform function. I'm
> > very new to this so please excuse the basic question.
> >
> > I have a very simple spatial table that I import data to. The srid
> > is 4326 (WGS84). When I run the following transform function it
> > works fine:-
> >
> > SELECT Transform(position,4269) FROM waypoints;
> >
> >
> > ....so far so good. Problem is when I try several other transform's
> > using various srid's I get the following error:-
> >
> > ERROR:  transform: couldn't project point: -45 (geocentric
> > transformation missing z or ellps)
> >
> >
> > I'm sure someone is going to spot what I'm doing wrong straight
> > away - any help would greatly be appreciated - by the way I am
> > using the Windows Version of Postgres etc
> >
> > Cheers
> > Marc
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> 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
>
>