[postgis-users] multiple srids in a single geometry column

[strk at refractions.net]

You don't need to populate geometry_columns unless a client actually
uses the information contained therein. Still, the spatial index
on a table containing records with different SRID sounds useless.
If all are UTM cells a box spanning 6degrees in both directions and
starting at the origin would match every record...

--strk;

On Sun, Jun 18, 2006 at 09:53:42PM -0600, Mark Wright wrote:
> I would like to use UTM for my geometries but each zone has its own
> srid and my coverage area spans multiple zones. If I create a geometry
> column with addgeometrycolumn() I need to specify a single srid so
> this will not work. If I create a standard postgres geometry column
> and create a gist index on it can I still work with it using postgis?
> In other words, can I still use the postgis functions and operators as
> I normally would if I created the column using addgeometrycolumn() or
> does postgis require that there be an entry in the geometry_columns
> table in order to work with a particular column?
> 
> Any thoughts on this would be appreciated.
> 
> 
> Mark