Data editing, directly in the database or WFS-T?

GeoServer GeoServer User
, , ,
1

Greetings,
We are starting the process of interoperability of geospatial data, using geOrchestra, which allows the administration of GeoServer and GeoNetwork in a unified way, in addition to offering more services.
And, we have a question about making layers available for editing by our internal customers. The question is: about how to make the layers available for editing, updating or deleting, would it be directly in the database or via WFS-T? How are they used in corporate or institutional environments?

2

I think this may be an architecture question for your team, or for the “geOrchestra” project?

  • GeoServer WFS-T can be used for editing directly in scripts, or in Desktop software like QGIS
  • If you share your database connection with your internal users they could once again use scripts or desktop software like QGIS to edit

To make layers editable in GeoServer:

  1. Turn on WFS setting service level to Transactional (allows editing) or Complete (allows locking)
  2. Adjust permissions for your internal users so that they have data security write w permission on the layers they wish to edit
1 Like
3

Thank you for your time in answering my question!

We already have GeoServer and GeoNetwork in testing.
The question is briefly: make layers available for editing layers to internal users through WFS-T or directly in the database? We are a public company whose 4 sectors produce geospatial data (in large volumes), users will use Qgis to produce this data. Therefore, according to the best flow of service responses and information security, what is most used in institutions or companies?

4

From a security standpoint editing via WFS-T may be easier to manage (not sure how well geOrchestra manages security for you?). Using GeoServer as middleware also gives you the freedom to change how the data is stored if that is useful to you.

Setting up with PostGIS (for example) access on your intranet can open up to wide range of tools like FME.

Since this is a question very much dependent on your organization you may prefer to reach out to consultant who can work with you to evaluate your needs and priorities. I assume you have an existing security environment and policies to meet which you do not necessarily which to discuss in a public forum.

Both approach work and have value!

1 Like
5

Thank you very much for the guidance! I appreciate your time and response!