Good morning.
I am working with Geoserver WMS services and an application with MapFish. I Use
layers and tables as a data source that represent polygons with attributes
stored in Oracle Spatial.
I have a layer (stored in Oracle Spatial) and a table (Oracle) storing
attributes of the polygons with a relation of one to many. I need to make a
thematic map based on attributes of the associated table. Are related through a
common column.
I tried to create a view then add as a layer in Geoserver, using SLD and the
field at the relationship table as if it were in the same layer. This works,
but the problem is that I have almost infinite views, because I have a
parameter called date. I need to know if it is possible to add dynamically from
my Geoserver application a layer based on a view. The idea would be to create a
WMS layer in Geoserver in run-time based on a view in response to a user
selection.
I have also seen Parametric SQL Views documentation. The problem is I need to
use version 2.0, not 2.1, and this feature is version 2.1.
I tried to make a view with all the information I have. However, Geoserver does
not represent this view: I suppose it's because it generates repeated records
(if the polygon A in the layer has 4 values in the relationship table, it
appears 4 times in the view). However, if the view has only one record for each
polygon, it represents well. If this is the problem, is it possible to make a
view with a column that uniquely identifies all records in it?
Any advice?
Thanks in advance.
Un saludo.
Pedro Briones García
TRAGSATEC
Gerencia de SIG y Consultoría
Departamento de Cartografía
C/ Julián Camarillo 6, Edificio 6B - 2ª Pl. Sector B
28037 Madrid
mailto:[email protected] <mailto:[email protected]>
Tfno.: +34 91 322 6489
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
