On Wed, May 9, 2012 at 9:54 PM, Hunter, David <[email protected]> wrote: > Hello all, > > > > I’m evaluating Geoserver (WMS) for use in a Tomcat – based application that > will use Oracle Spatial 11g as the map data source. I will also most likely > be using Open Layers and Ext-JS in the front end. > > > > I need the ability to access a set of data that is stored in tables in a > state-by-states basis, so that it appears to the user as one layer. What > used to be called a “seamless layer” when this type of thing was done in a > file system.
Besides what Andreas already suggested, and if you are game trying something a bit new and experimental, another option would be to try out the "aggregating data store" (http://geo-solutions.blogspot.it/2011/09/aggregate-and-republish-from-several.html), while not available on a release, you can get it for a nightly build here: http://gridlock.opengeo.org/geoserver/trunk/community-latest/ (it's the aggregate-plugin one). Performance wise it will be better than setting up 50 layers in a layer group, though probably the best option, given that you have everything in the same database, is to create a view in the database that unions all the tables and publish that one. Cheers Andrea -- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob: +39 339 8844549 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
