On Thu, Jun 2, 2011 at 7:10 PM, Javier Maestu <javier.mae...@gmail.com> wrote: > Hi list! > > > > I want to ask you about your opinion about the following question: > > - If I have a table in Oracle Spatial with more than a geometry there is any > way to represent it in GeoServer? Is it possible? > > I thought about using SQL views with one geometry, and define a layer with > this SQL view. Once I defined each layer I can group the layers together. > > I am concerned about having some kind of problem with Oracle spatial > indexes. > > > > Can anybody share their experience?
I haven't used multi geometry tables lately but they should be supported. Details: - the first geometry column will be marked as the default (there is no way to change this besides defining views that reorder the columns) - make sure all geometry columns that you intend/need to run spatial filters on are spatially indexed, Oracle won't work without them (it's not about being slow, it's about filters not working at all without spatial indexes) - you can use the other columns to draw maps by telling the symbolizer to use them using <geometry>columnName</geometry> 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 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 ------------------------------------------------------- ------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
