[postgis-users] AddGeometryColumn for multiple SRIDs

[Nicolas Ribot]

> G'day.
> 
> I am totally new to PostGIS and relatively new/out of date to GIS in
> general so please excuse me if this is a stupid question.
> 
> The data which I want to store and process comes from two zones/spatial
> reference systems - 20253 and 20254.
> 
> How should I use the AddGeometryColumn function to create a geometry
> column for this data?
> 
> Cheers and thanks,
> Stephen Davies
> 

Hi Stephen,

You can't.
One column = one SRID.

Either add 2 geometry columns in your table, each with its own SRID,
or better (in my own point of vue), convert your data from one system
to the other one before adding your geometries.

You can also create 2 tables for each data set.

Nicolas