[Geoserver-users] Joining tables ub WFS ?

[Luca M. <lmo...@ie...>]

Yes, I know it cannot be done using WFS or SLD, but, I have this sort of 
requirement:

1) A 1.5 million rows table (the entire Italian 2001 census) in Oracle.
2) Some 9.000 polygons (Oracle Spatial) to make thematic maps out of.
3) Queries should be dynamic, since user may choose amongst more than a 
hundred statisics.

Therefore, the selection of the BBOX-included polygons and the 
subsequent join of this selection with a subset of the 1.5m-rows table 
would make sense, allowing a good deal of flexibility with a resonable 
response time.

Problem is, I cannot join tables in WFS or SLD (I mean, no filter 
element for that)... any idea on how to solve this ?

Regards,

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