Hello

I have an Oracle DB with a spatial table that I want to join with a query
to get some attributes from a non spatial table (the geo column is
SDO_Geomerty as a point [get_gtype() returns 1]). I have found 2 differetn
issue when trying to do this 2 ways

Firstly, I first tried to create a view in the DB, setting the geom columns
in the geom_metadata table. When I did this and went to import into
Geoserver, the native SRS was blank. I set the Declared SRS to 4326 and
'Force Declared', compute the bounding boxes from data (which gives the
correct results) and press save. When i go do view the data nothing appears!

Secondly, In order to rectify this I thought I might build the query in
geoserver, which seems to fix the problem.. until some data changed in the
DB and Geoserver did not update. now I am at a loss in where to go to now.

Anyone able to help at all?

Thanks!

Peter
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to