PostGIS Best Practices with thousands of entries [on hold]

[المشرف العام]

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.

• How should I organize such a PostGIS database?
• Do I need to create a different table for each file that's imported?
• Should I use the public schema, or - as someone's indicated - use a separate schema?

It seems a bit weird that each "file" should have it's own separate table, but this is perhaps natural? I know from the OSM dataset that they have all the data in one table, so I'm a bit confused regarding this.

Any pointers appreciated, thank you.



أكثر...