[postgis-users] Coordinate transformation with customrecordsofspatial_sys_ref

[Sandro Santilli]

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------'