[Geoserver-users] som question about spatial data and another table

GeoServer GeoServer User
1

I have some questions.
1. Can I join the table that has spatial data with another table in oracle?
I need more data to display in the map.
2. Can each user change his/her view properties in map such as color?If I
want to have some filters before display for each user, where should I put
it ?

--
View this message in context: http://www.nabble.com/som-question-about-spatial-data-and-another-table-t1354278.html#a3625554
Sent from the GeoServer - User forum at Nabble.com.

2

worr wrote:

I have some questions.
1. Can I join the table that has spatial data with another table in oracle?
I need more data to display in the map.

Geoserver can read data from views as from tables. I had to do this in order to make it read data written by AutoCAD Map (see http://docs.codehaus.org/display/GEOSDOC/Oracle+DataStore ).

However, as of current version, these views cannot be dynamic (they should be registered in the Geoserver catalog before using them).

2. Can each user change his/her view properties in map such as color?If I
want to have some filters before display for each user, where should I put
it ?

Look at SLD, you can do a lot with it, including dynamically generating filters and symbols.

Regards,

--------------------
    Luca Morandini
www.lucamorandini.it
--------------------