<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle" type="text/css">
<!--
p
{margin-top:0;
margin-bottom:0}
p
{margin-top:0;
margin-bottom:0}
-->
P {margin-top:0;margin-bottom:0;}</style>
</head>
<body ocsi="0" fpstyle="1">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">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.<br>
<br>
proj4 parsing error in :<br>
<br>
"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"<br>
<br>
the INSERT works fine in:<br>
<br>
"POSTGIS="1.4.1" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23 September 2009" USE_STATS"<br>
<br>
I used the same creation statement in both DB's for the custom projection.<br>
<br>
bobb<br>
<br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div style="direction: ltr;" id="divRpF782704"><font face="Tahoma" color="#000000" size="2"><b>From:</b> postgis-users-bounces@postgis.refractions.net [postgis-users-bounces@postgis.refractions.net] on behalf of Basques, Bob (CI-StPaul) [bob.basques@ci.stpaul.mn.us]<br>
<b>Sent:</b> Tuesday, June 26, 2012 9:52 AM<br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> Re: [postgis-users] proj4 error between versions 8.4.2 (works) and 9.1.4 (doesn't work)<br>
</font><br>
</div>
<div></div>
<div>
<div style="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">Sorry, forgot to add the error:<br>
<br>
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<br>
<br>
********** Error **********<br>
<br>
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<br>
SQL state: XX000<br>
<br>
<div style="font-family:Times New Roman; color:#000000; font-size:16px">
<hr tabindex="-1">
<div id="divRpF88812" style="direction:ltr"><font face="Tahoma" color="#000000" size="2"><b>From:</b> postgis-users-bounces@postgis.refractions.net [postgis-users-bounces@postgis.refractions.net] on behalf of Basques, Bob (CI-StPaul) [bob.basques@ci.stpaul.mn.us]<br>
<b>Sent:</b> Tuesday, June 26, 2012 9:51 AM<br>
<b>To:</b> postgis-users@postgis.refractions.net<br>
<b>Subject:</b> [postgis-users] proj4 error between versions 8.4.2 (works) and 9.1.4 (doesn't work)<br>
</font><br>
</div>
<div></div>
<div>
<div style="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">I'm getting an error in proj4text in 9.1.4 for our custom projection which works just fine in 8.4.2.<br>
<br>
when inserting a geom like:<br>
<br>
INSERT INTO InsertInfoStp(. . . .<br>
the_geom,<br>
. . . .) <br>
VALUES (. . . .<br>
ST_Transform (ST_SetSRID (ST_MakePoint (-93.1286,44.9675), 4326), 200068),<br>
. . . .)<br>
<br>
The problem is in the ST_Transform, if I drop it, it succeeds.<br>
<br>
Can anyone see anything obvious with :<br>
<br>
srid=200068<br>
<br>
auth_name=EPSG<br>
<br>
auth_srid=200068<br>
<br>
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]]<br>
<br>
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<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>