Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a geoserver that displays some basic country data for Brazil at a course spatial scale (1:1 milion). Now the geography institute (IBGE) is making available the topo sheets at 1:250,000 scale, one shape file for each of the 548 tiles. My question is: In order to store those data in PostGIS and serve via Geoserver, would I be better of merging all topo sheets into one? Or is it better to have each sheet as a separate table in PostGIS? This, of course, considering that there will be no topology issues with the sheets.

Thanks Daniel

share|improve this question
Will you be accessing this data many times or reading once for each process? – Mapperz Nov 9 '12 at 17:44
Not sure I understand what you mean, I'm not the DB expert in our group. The data will be available for other people to look at using GeoServer and also in a WebGIS application we developed, all through WMS. – Daniel Nov 9 '12 at 18:45
It looks like I made the answer too soon.The data is provided as 10 large chunks, not 548 small tiles. So I believe I won't have much trouble putting it on PostGis and into GeoServer – Daniel Nov 9 '12 at 19:08

I try to keep data that is of similar features in one table. For example, all 10 data chunks of roads, merge into a table, all 10 data chunks of watercourses, another table.

I find that trying to manually determine which data to load based on which area you are is too much work and is best left up to the spatial indexes in postgis / geoserver.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.