[postgis-users] Coordinate transformation withcustomrecordsofspatial_sys_ref

[Richard Didier]

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