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-boun...@postgis.refractions.net [postgis-users-boun...@postgis.refractions.net] on behalf of Basques, Bob (CI-StPaul) [bob.basq...@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-boun...@postgis.refractions.net [postgis-users-boun...@postgis.refractions.net] on behalf of Basques, Bob (CI-StPaul) [bob.basq...@ci.stpaul.mn.us] Sent: Tuesday, June 26, 2012 9:51 AM To: postgis-users@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
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users