[postgis-users] proj4 error between versions 8.4.2 (works) and 9.1.4 (doesn't work)

[Basques, Bob (CI-StPaul)]

Geez, I think I need to slow down some.  I figured out it would probably be more pertinent to list the POSTGIS version instead of PostGres.

proj4 parsing error in :

"POSTGIS="1.5.3" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.8.0, 6 March 2012" LIBXML="2.7.8" USE_STATS"

the INSERT works fine in:

"POSTGIS="1.4.1" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23 September 2009" USE_STATS"

I used the same creation statement in both DB's for the custom projection.

bobb

________________________________
From: postgis-users-bounces at postgis.refractions.net [postgis-users-bounces at postgis.refractions.net] on behalf of Basques, Bob (CI-StPaul) [bob.basques at ci.stpaul.mn.us]
Sent: Tuesday, June 26, 2012 9:52 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] proj4 error between versions 8.4.2 (works) and 9.1.4 (doesn't work)

Sorry, forgot to add the error:

ERROR:  AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=lcc +lat_2=44.88333333333333 +lat_1=45.13333333333333 +lat_0=44.79111111111111 +lon_0=-93.38333333333334 +x_0=152400.3048 +y_0=30480.0610 +units=ft +to_meter=0.30480060960122 +a=6378418.941 +b=6357033.310 +no_defs': projection not named

********** Error **********

ERROR: AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=lcc +lat_2=44.88333333333333 +lat_1=45.13333333333333 +lat_0=44.79111111111111 +lon_0=-93.38333333333334 +x_0=152400.3048 +y_0=30480.0610 +units=ft +to_meter=0.30480060960122 +a=6378418.941 +b=6357033.310 +no_defs': projection not named
SQL state: XX000

________________________________
From: postgis-users-bounces at postgis.refractions.net [postgis-users-bounces at postgis.refractions.net] on behalf of Basques, Bob (CI-StPaul) [bob.basques at ci.stpaul.mn.us]
Sent: Tuesday, June 26, 2012 9:51 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] proj4 error between versions 8.4.2 (works) and 9.1.4 (doesn't work)

I'm getting an error in proj4text in 9.1.4 for our custom projection which works just fine in 8.4.2.

when inserting a geom like:

INSERT INTO InsertInfoStp(. . . .
                          the_geom,
                          . . . .)
                 VALUES (. . . .
                         ST_Transform (ST_SetSRID (ST_MakePoint (-93.1286,44.9675), 4326), 200068),
                        . . . .)

The problem is in the ST_Transform, if I drop it, it succeeds.

Can anyone see anything obvious with :

srid=200068

auth_name=EPSG

auth_srid=200068

srtext=PROJCS["MN Ramsey County",GEOGCS["NAD83 (1986)",DATUM["GRS 1980 + MN Ramsey Elevation",SPHEROID["Unknown",6378418.941,298.2572242549219]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]], PROJECTION["Lambert_Conformal_Conic_2SP"],PARAMETER["standard_parallel_1",45.13333333333333],PARAMETER["standard_parallel_2",44.88333333333333],PARAMETER["latitude_of_origin",44.79111111111111], PARAMETER["central_meridian",-93.38333333333334],PARAMETER["false_easting",500000],PARAMETER["false_northing",100000],UNIT["Foot_US",0.30480060960121924]]

proj4text=+proj=lcc +lat_2=44.88333333333333 +lat_1=45.13333333333333 +lat_0=44.79111111111111 +lon_0=-93.38333333333334 +x_0=152400.3048 +y_0=30480.0610 +units=ft +to_meter=0.30480060960122 +a=6378418.941 +b=6357033.310 +no_defs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120626/808ae0c9/attachment.html>