<br><br><div class="gmail_quote">On Sat, Feb 11, 2012 at 6:48 AM, Martin Chapman <span dir="ltr"><<a href="mailto:chapmanm@pixia.com">chapmanm@pixia.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US"><div><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"></span><p><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span>4.<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I select the max(srid) where srid > 10000000. If zero is returned then I use that base number (10000000) and add a new entry to the spatial_ref_sys table using the proj4 text and wkt so all fields have a value…and my app name as the authority (makes me feel important </span><span style="font-size:11.0pt;font-family:Wingdings;color:#1f497d">J</span><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">). If a max above 10000000 is found then I take the max and add one and then add the new entry.</span>Guys, the MAXIMUM <br>
</p></div></div></blockquote><div>The MAXIMUM valid user value for SRID in PostGIS-2.0 is 998999 so please<br>
consider using values in the range 910000..910999 for your custom entries.<br>
<br>
--strk; <br></div></div><br>