Hi all, I have to implement the following scenario, with postgis as the backend db.
One table holds the geometries of my polygons (several thousands of them), something like POLYGON_TABLE ID_POLY | GEOM I must generate tiles from these geometries, choosing the background color of the polygons from another table. The problem is that each polygon can be differently painted, according to the user requesting it. So the colors are dynamic and persisted in another table: COLOR_TABLE ID_POLY | ID_USER | COLOR The background color of the same polygon could be yellow or green, according to the user requesting it. I read some guides about choosing a color according to a fixed column on the same table of the geometry, or dinamically provide the sld in the request: http://osgeo-org.1560.x6.nabble.com/Random-colors-in-SLD-templates-td3790073.html http://www.geo-solutions.it/blog/dynamic-wms-styling-with-geoserver-sld-and-library-mode/ However my scenario is a bit different, I guess I'd need to implement this by a CQL expression or something like that. Is it possible to use GeoServer with SLD to generate tiles in this scenario? Would it be reasonably fast or would the query in the SLD really slow down things? The other option would be to generate the tiles programmatically with geotools, but I'd like to avoid reinventing the wheel. Thanks for any input, Paolo -- Paolo Crosato Software engineer/Custom Solutions e-mail: paolo.cros...@targaubiest.com ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
