[postgis-users] st_transform crashes

[Bryan Hempen]

Hi Regina,

You were right! I inserted the proj4text for a cylindrical projection I used with ogr2ogr and it worked! For the moment I don't even know if the parameters are right, but I will check for that later. Thanks everyone who has helped and especially Regina!

Kind regards,
Bryan


-------- Original-Nachricht --------
> Datum: Sun, 31 Jul 2011 13:24:01 -0400
> Von: "Paragon Corporation" <lr at pcorp.us>
> An: "\'PostGIS Users Discussion\'" <postgis-users at postgis.refractions.net>
> Betreff: Re: [postgis-users] st_transform crashes

> Bryan,
> 
> Not sure if you got the cc to the bug report I posted.
> 
> The issue seems to be that the:
> http://spatialreference.org/ref/iau2000/49910/
> 
> Is lacking a proj4text -- PostGIS pretty much ignores everything in the
> spatial_ref_sys except the proj4text column.  The rest of it is just
> metadata for other tools.
> 
> So you need to figure out the comparable proj4text for this -- assuming
> there is one.
> 
> It is a bug though that PostGIS even allows entries into the
> spatial_ref_sys
> without coughing an error when proj4text is empty.
> 
> Thanks,
> Regina
> http://www.postgis.us
> 
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-
> > bounces at postgis.refractions.net] On Behalf Of Bryan Hempen
> > Sent: Saturday, July 30, 2011 6:17 PM
> > To: PostGIS Users Discussion
> > Subject: Re: [postgis-users] st_transform crashes
> > 
> > @Leo and Regina:
> > 
> > "POSTGIS="2.0.0SVN" GEOS="3.3.1dev-CAPI-1.7.1" PROJ="Rel. 4.6.1, 21
> August
> > 2008" LIBXML="2.7.8" USE_STATS"
> > 
> > "PostgreSQL 8.4.8, compiled by Visual C++ build 1400, 32-bit"
> > 
> > I am using Windows XP.
> > 
> > 
> > 
> > @Josh Jordan:
> > 
> > I had some invalid geometries in the table but fixed them now.
> > 
> >    select count(*) from alldata where ST_IsValid(the_geom) = 'f';
> > 
> > returns 0. However, the database still crashes.
> > 
> > 
> > 
> > Thanks for the input so far. Any other ideas?
> > 
> > Kind regards,
> > Bryan
> > 
> > 
> > 
> > _______________________________________________
> > 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