Hi, We configured SQL views (oracle 11g r2) in geoserver for single geometry type (like continents, countries, states, districts, cities, villages etc. are present in one table but views configured for different admin type layers with SQL views) and working fine till now.
I think it is possible to strore multiple geometry types into a oracle spatial table and access through views. It stores geometry with clear differentiation (like 2001, 2002, 2003 for points, lines & polygons). If there is no future insertions/updates, i hope it may be OK. If updates are there, then considering separate table for different geometry types. Initially we were also thinking of problems, but views are working fine for us for single geometry type as mentioned above. Regards, Hari. On Thu, Jun 2, 2011 at 10:40 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? > > Thanks in advance, > > > > J. > > > ------------------------------------------------------------------------------ > 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 > >
------------------------------------------------------------------------------ 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