Hello. 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:p...@tragsa.es <mailto:p...@tragsa.es> Tfno.: +34 91 322 6489
------------------------------------------------------------------------------ Oracle to DB2 Conversion Guide: Learn learn about native support for PL/SQL, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, data movement tools, best practices and more. http://p.sf.net/sfu/oracle-sfdev2dev
_______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
