[gdal-dev] PostGIS SRID conundrum

Martin Chapman chapmanm at pixia.com
Tue Feb 14 12:35:18 EST 2012


Thank you very much for the info!

Best regards,


From: sandro.santilli at gmail.com [mailto:sandro.santilli at gmail.com] On Behalf 
Of Sandro Santilli
Sent: Tuesday, February 14, 2012 3:05 AM
To: Martin Chapman
Cc: pcreso at pcreso.com; gdal-dev at lists.osgeo.org
Subject: Re: [gdal-dev] PostGIS SRID conundrum

On Sat, Feb 11, 2012 at 6:48 AM, Martin Chapman <chapmanm at pixia.com> wrote:

4.       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 J).  If a 
max above 10000000 is found then I take the max and add one and then add the 
new entry.Guys, the MAXIMUM

The MAXIMUM valid user value for SRID in PostGIS-2.0 is 998999 so please
consider using values in the range 910000..910999 for your custom entries.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120214/f7293f81/attachment.html

More information about the gdal-dev mailing list