Hi all, > > 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 ?
As a matter of fact, the importatio n of the IGNF-spatial_ref_sys.sql script is working perfectly with PostGIS 1.x ... and yes, this kind of SRID are set in our CRS' db. > 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. > I don't understand why such a trigger on the primary key. If one has a look at what EPSG says about CRS identification : "... expect that all user records have codes outside of the EPSG reserved range 0-32767 and 60000000-69999999, (and recognise that users may add user aliases to EPSG records even though those user aliases had codes within the EPSG reserved range.)" So, no limit for user crs' id except 0-32767 and 600000000-69999999 ... > 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. > ... therefore I then understand that EPSG's official codes in the 600000000-69999999 range would be rejected !! I feel that restriction on SRID's values is a real regression on the usability of the spatial_ref_sys table for public agencies like our in charge of maintaining CRS' catalogue. Releasing the trigger would be just being compatible with PostGIS 1.x. > --strk; > > ,------o-. > | __/ | Delivering high quality PostGIS 2.1 > | / 2.1 | http://strk.keybit.net - http://vizzuality.com > `-o------' > Regards, didier -- RICHARD Didier - Chef du pôle technique du Géoportail 2/4, avenue Pasteur - 94165 Saint Mandé Cedex Tél : +33 (0) 1 43 98 83 23 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users