On Fri, Jun 24, 2011 at 3:13 PM, Bisland, Kenneth <[email protected]> wrote: > We are about to start on a project where a number of editable layers are > stored in a single table in MSSQL. The easiest way to access these layers > will be via WFS and a parameterised view. My question is can you save edits > back up to the server over WFS-T if you are using parameterised views or can > anyone see another way of achieving the following:
SQL views are read only, so you cannot perform WFS-T on them. Plus, in the case of MS-SQL, they don't work not even read only, geometries are not recognized and are returned as byte[]: http://jira.codehaus.org/browse/GEOS-4448 There has been few reports about this issue, but nobody so far has had the time/knowledge/resources to go and fix the code. To perform WFS-T on a transformed data set such as a SQL view the server would need to understand the transformation applied to the data, so that it can invert the transformation when saving back the data (even if the transformation is just joining data and replacing some codes with a human readable label, the code needs to know how to go back to the code, and on which table to save it). > > > The SQL table stores the CAD plans of a building with layers identified by a > layer column (we will have loads of layers so cannot easily set up > individual layers in geoserver) You can automate setting up layers in GeoServer with RESTConfig, there are installations with hundred of thousands of layers around with automation software publishing new layers hourly. Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense.. http://p.sf.net/sfu/splunk-d2d-c1 _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
