Hi,
I have a GIS project which has become a wms service. The project was not
designed for the web, and therefore the datastructure was based on 110
different
shapefiles.
My job is to publish a wms service displaying these layers.
There are approx 110 shp...points,lines, polygons and text. A black/white 60%
transparent topographic map is draped over the project in Desktop GIS.
I want to load the geometries into postgresql/postgis to speed up the
rendering,
but am not sure what data structure to use.
1. Would it make sense to keep the shapefile data structure?..ie 110 different
tables in postgis?
2. Would it be better to join all similar geometries into one table?...ie 4
tables..points,polylines,polygons and text?
3. Collections?...don´t really know what these are
4. chuck everything in one table and create views?
Could anyone offer any guidance?
Thanks,
Robert Buckley
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
