Wanted Geoserver to serve a WMS layer using spatial data from an Oracle
table, but select features based on the contents of non-spatial fields
across multiple tables - the only way to achieve this was to pull together
all the information together in a Materialised View containing the features
and all the non-spatial fields that would be filtered on.
Have created and populated the materialised view, created spatial indexes
and added an entry into Oracle's sdo_geom_metadata table.
When I come to publish the layer in Geoserver, it can see the view, but when
I try and publish it, the Native SRS is blank and cannot have anything typed
in it. As a result, even if I declare an SRS I will not compute bounding
boxes and will just hang when trying to publish.
Any suggestions as to what the problem is and how to correct it would be
useful.
Mark Hammond
Web Software Developer
British Trust for Ornithology, The Nunnery, Thetford, Norfolk, IP24 2PU, UK
' Scribo ergo sum dolor '
------------------------------------------------------------------------------
10 Tips for Better Server Consolidation
Server virtualization is being driven by many needs.
But none more important than the need to reduce IT complexity
while improving strategic productivity. Learn More!
http://www.accelacomm.com/jaw/sdnl/114/51507609/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
