<div>
Thanks Astrid!</div><div><br></div><div>Seems a little strange that spatialreference.org would produce an invalid insert statement. Regardless, thanks for the pointer.</div><div><br></div><div>Peter</div>
<div><div><br></div><div>-- </div><div>Peter Tittmann</div><div><br></div><div><br></div></div>
<p style="color: #A0A0A8;">On Tuesday, July 17, 2012 at 1:09 PM, Astrid Emde wrote:</p>
<blockquote type="cite" style="border-left-style:solid;border-width:1px;margin-left:0px;padding-left:10px;">
<span><div><div><div>Hello Peter,</div><div><br></div><div>there is a constraint that checks that srid is < 998999</div><div><br></div><div><br></div><div>ALTER TABLE spatial_ref_sys</div><div> ADD CONSTRAINT spatial_ref_sys_srid_check CHECK (srid > 0 AND srid <=</div><div>998999);</div><div><br></div><div>You should set sird in the insert to 102243 instead of 9102243:</div><div><br></div><div>INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text,</div><div>srtext) values</div><div>( 102243, 'esri', 102243, '+proj=lcc +lat_1=37.06666666666667</div><div>+lat_2=38.43333333333333 +lat_0=36.5 +lon_0=-120.5 +x_0=2000000</div><div>+y_0=500000 +ellps=GRS80 +units=m +no_defs ',</div><div>'PROJCS["NAD_1983_HARN_StatePlane_California_III_FIPS_0403",GEOGCS["GCS_North_American_1983_HARN",DATUM["NAD83_High_Accuracy_Regional_Network",SPHEROID["GRS_1980",6378137,298.257222101]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Lambert_Conformal_Conic_2SP"],PARAMETER["False_Easting",2000000],PARAMETER["False_Northing",500000],PARAMETER["Central_Meridian",-120.5],PARAMETER["Standard_Parallel_1",37.06666666666667],PARAMETER["Standard_Parallel_2",38.43333333333333],PARAMETER["Latitude_Of_Origin",36.5],UNIT["Meter",1],AUTHORITY["EPSG","102243"]]');</div><div><br></div><div>Astrid</div><div><br></div><div>On Tue, July 17, 2012 6:14 pm, Peter Tittmann wrote:</div><blockquote type="cite"><div><div>Hi,</div><div><br></div><div><br></div><div>Im trying to add a srid from spatial <a href="http://reference.org">reference.org</a></div><div>(<a href="http://spatialreference.org/ref/esri/102243/postgis/">http://spatialreference.org/ref/esri/102243/postgis/</a>) but i'm getting a</div><div>error using the insert statement:</div><div><br></div><div>ERROR: new row for relation "spatial_ref_sys" violates check constraint</div><div>"spatial_ref_sys_srid_check"</div><div><br></div><div><br></div><div>I saw this ticket</div><div>(<a href="http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CDYQ">http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CDYQ</a></div><div>FjAA&url=http%3A%2F%<a href="http://2Ftrac.osgeo.org">2Ftrac.osgeo.org</a>%2Fpostgis%2Fticket%2F1505&ei=f6gFUOy</div><div>kJcWl2AXz2eDKBQ&usg=AFQjCNH1dlCvTvWEYntRmqflCDtAOUT49g&sig2=tch67lIoPp2IO</div><div>RZaCyOpSw) and thread</div><div>(<a href="http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CDgQ">http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CDgQ</a></div><div>FjAB&url=http%3A%2F%<a href="http://2Fpostgis.refractions.net">2Fpostgis.refractions.net</a>%2Fpipermail%2Fpostgis-devel</div><div>%2F2012-February%2F018485.html&ei=f6gFUOykJcWl2AXz2eDKBQ&usg=AFQjCNGxJREc</div><div>0HrXIbAFuKSfvjU0tbfg9A&sig2=0wH8-t8hCMiuIWKDL6AeFQ) but seems lie it</div><div>should be fixed.</div><div><br></div><div>Thanks in advance!</div><div><br></div><div><br></div><div>Peter</div><div><br></div><div><br></div><div>--</div><div>Peter Tittmann</div><div><br></div><div><br></div><div><br></div><div>_______________________________________________</div><div>postgis-users mailing list <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a></div><div><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a></div></div></blockquote><div><br></div><div><br></div><div>-- </div><div>Mit freundlichen Grüßen</div><div><br></div><div>Astrid Emde</div><div><br></div><div>-----------------------------------</div><div>Aufwind durch Wissen!</div><div><br></div><div>Qualifizierte OpenSource-Schulungen</div><div>bei der <a href="http://www.foss-academy.eu">www.foss-academy.eu</a></div><div><br></div><div>----------------------------------</div><div><br></div><div> Astrid Emde</div><div> WhereGroup GmbH & Co.KG</div><div> Eifelstraße 7</div><div> 53119 Bonn</div><div> Germany</div><div><br></div><div> Fon: +49(0)228 90 90 38 - 19</div><div> Fax: +49(0)228 90 90 38 - 11</div><div><br></div><div> <a href="mailto:astrid.emde@wheregroup.com">astrid.emde@wheregroup.com</a></div><div> <a href="http://www.wheregroup.com">www.wheregroup.com</a></div><div> Folgen Sie der WhereGroup auf twitter: <a href="http://twitter.com/WhereGroup_com">http://twitter.com/WhereGroup_com</a></div><div><br></div><div>Amtsgericht Bonn, HRA 6788</div><div>-------------------------------</div><div>Komplementärin:</div><div>WhereGroup Verwaltungs GmbH</div><div>vertreten durch:</div><div>Olaf Knopp, Peter Stamm</div><div>-------------------------------</div><div> pgp-public key:</div><div> <a href="http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284">http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284</a></div><div> Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen</div><div> Signed and/or encrypted mail is highly appreciated</div><div><br></div><div>_______________________________________________</div><div>postgis-users mailing list</div><div><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a></div><div><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a></div></div></div></span>
</blockquote>
<div>
<br>
</div>