I would like to create a Postgres database (postgreslq-9.1 and postgis-2.0.2) storing several shapefiles but I am uncertain on how to implement it so I'm searching for some advices.
I have already done this last year but was pretty uncofortable beacause I had a table per shapefile, every table signed with its SRID (stored inside geometry_columns table - I was using postgis 1.5, so this was still a table and not a view as in postgis-2).
I had to create a new table every time I converted a shapefile: pretty uncofortable because I had to query them using Django ORM, and create table mapping on the fly is not trivial.
Is that possible to create one single table having an id indicating the original shapefile and the relative SRID per geometry?
Otherwise have you got any better ideas?