>>We are developing an application involving PostGis+Geoserver+QGIS, the >>application is basically a QGIS plugin, as client of Geoserver. We need to >>manage forms related to some spatial data (more than one form per spatial >>item). I would like to know if there is any way using Geoserver to manage the >>editing of these forms stored in a non spatial table. In summary, Is >>Geoserver capable of managing non spatial tables (including read and write)
>>Javier >Hi Javier, >yes, you can publish tables without geometries and do WFS-T on top of them, as >long as they are flat (e.g you are not trying to build a complex model, you >can have as many foreign keys as you like, but you'll have to publish them as >separate tables and issue separate update/insert/delete statements for each, >all bound in the same WFS-T transaction). >Cheers >Andrea Javier - If you're working in Postgres/PostGIS and you need to do something more complicated (but still want to keep data-entry simple), you might be able to set up a VIEW with INSERT-rules. so that you can maintain normalized tables in the database while still keeping things easy for clients. - Patrick O'Toole Application Developer Wyoming Natural Diversity Database UW Berry Biodiversity Conservation Center Department 3381, 1000 E. University Av. Laramie, WY 82071 P: 307-766-3018 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
