I'm creating a PostGIS database which will hold thousands of different shapes (imported from Shapefile, GeoJSON, etc), and they'll stay there and be queried over time.
- Do I need to create a different table for each file that's imported?
It seems a bit weird that each "file" should have it's own separate table, but this is perhaps natural?
The data is thousands of different
Shapefiles, with different properties/columns. We plan to do all kinds of queries on the data, but mostly on one
file (which translates to a few
rows) at a time.
geomcolumn, but otherwise different.