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