[postgis-users] transform problem

Peter Bange bange at argoss.nl
Tue Apr 17 02:09:10 PDT 2007


Hi Mark,

I tried some other transformation, but no succes; the simplest a  
tried was:

TestDB=# select transform(geomfromtext('Point(4.4 52.0)', 3395), 4001);
server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Any idea ?

Peter

On Apr 16, 2007, at 20:19, Mark Cave-Ayland wrote:

> On Mon, 2007-04-16 at 11:00 +0200, bange at argoss.nl wrote:
>> I cannot get the Transform function working on Mac OSX. When I try
>> something like
>>
>> select transform(geomfromtext('MULTIPOLYGON(((45340.81
>> 387680.7,51892.99 387641.0, 52012.12 380810.8,45459.94
>> 380850.5,45340.81 387680.7)))',28992),3395)
>>
>> I get a query that is running for some time, and the result is a ':'
>> and 'lost connection to server'. Anybody got the same problem ?
>>
>> I am running postrgesql 8.1.5, postgis 1.1.6 proj 4.4.8.
>>
>> Thanks, Peter Bange
>
>
> Hi Peter,
>
> Are there any messages in the PostgreSQL server log? I get the  
> following
> output from psql here:
>
> postgis=# select transform(geomfromtext('MULTIPOLYGON(((45340.81
> postgis'# 387680.7,51892.99 387641.0, 52012.12 380810.8,45459.94
> postgis'# 380850.5,45340.81 387680.7)))',28992),3395);
> ERROR:  AddToPROJ4SRSCache: Cannot find SRID (3395) in spatial_ref_sys
> postgis=# select * from spatial_ref_sys where srid = 3395;
>  srid | auth_name | auth_srid | srtext | proj4text
> ------+-----------+-----------+--------+-----------
> (0 rows)
>
> postgis=# select postgis_full_version();
>                    postgis_full_version
> ----------------------------------------------------------
>  POSTGIS="1.1.6" PROJ="Rel. 4.5.0, 22 Oct 2006" USE_STATS
> (1 row)
> postgis=# select version();
>                                                   version
> ---------------------------------------------------------------------- 
> --------------------------------------
>  PostgreSQL 8.1.8 on i486-pc-linux-gnu, compiled by GCC gcc-4.0.gcc- 
> opt
> (GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)
> (1 row)
>
>
> Also, a good check would be to see if the reprojection works for any
> other SRID values...
>
>
> Kind regards,
>
> Mark.
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>

-- 
ARGOSS: your partner for atmospheric, marine & coastal information
P O Box 61
8325ZH Vollenhove The Netherlands
tel +31-527-242299 fax +31-527-242016
Web http://www.argoss.nl

Confidentiality Notice & Disclaimer
The contents of this e-mail and any attachments are intended only for  
the
use of the e-mail addressee(s) shown. If you are not that person, or  
one of
those persons, you are not allowed to take any action based upon it  
or to
copy it, forward, distribute or disclose the contents of it and you  
should
please delete it from your system.

ARGOSS Holding BV and its subsidiaries do not accept any liability  
for any
errors or omissions in the context of this e-mail or its attachments  
which
arise as a result of Internet transmission, nor accept liability for
statements which are those of the author and not clearly made on  
behalf of
ARGOSS.




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070417/2ea238ad/attachment.html>


More information about the postgis-users mailing list