One easy way to generate the syntax required to add a custom projection is to select something similar at spatialreference.org and click "PostGIS spatial_ref_sys INSERT statement," then copy and paste into a text or query editor to revise. Blinding flash of the obvious, perhaps, but hope it's helpful to someone.
-Rob -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Sandro Santilli Sent: Tuesday, July 17, 2012 5:49 AM To: DUPREZ Cédric Cc: PostGIS Users Discussion Subject: Re: [postgis-users] Coordinate transformation with customrecordsofspatial_sys_ref On Tue, Jul 17, 2012 at 11:34:46AM +0200, DUPREZ Cédric wrote: > SELECT AddGeometryColumn('public', 'pts', 'geom', 320002120, 'POINT', > 2, false); > > This gives me the following error message: "ERROR: AddGeometryColumn() > - SRID must be <= 998999 > > How can I use the correct 320002120 SRID specified by French IGN? Is 320002120 in your spatial_ref_sys already ? You'll need to assign it a different SRID, the spatial_ref_sys has provision for "auth_srid" so you can put 320002120 in there and use something valid for PostGIS' "srid" field. Unfortunately we never got around writing a page about SRID ranges in PostGIS manual (contributions welcome!) but the idea is that you put your "custom" entries somewhere from 910000 and below 999000. --strk; ,------o-. | __/ | Delivering high quality PostGIS 2.1 | / 2.1 | http://strk.keybit.net - http://vizzuality.com `-o------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users