[Qgis-user] Versioned editing in QGIS

[Tyler Veinot]

Morten;
There are 2 versioning editing plugins for Postgre that might work for you.
One is simply called Versioning and  pgVersion. I had little success with
them but it was giving me errors that someone who is more database
knowledgeable might be able to interpret and correct.
There is also the built in offline editing mode. I did some test with some
success working with; PostgreSQL, MSSQL Express 2008R2 and 2012, and
Filegeodatabase. Where I "checked out" some data into a sqlite database,
made some edits and "checked in" the data. It worked with multiple users
(my test was 2) as long as you didn't edit the same features. My testing
was also on simple tables no relationships or triggers.
To my knowledge even using versioned datasets through Esri you are still
limited in that you and someone else cannot edit the same feature during
the same check out because it causes conflicts on reconciling and someones
edits will be over ruled. At least that is how it was on the system we were
using on an Oracle db.
Hope that helps;
Tyler

On Wed, Dec 20, 2017 at 10:58 AM, Tyler Veinot <tylerkveinot at gmail.com>
wrote:

> Morten;
> There are 2 versioning editing plugins for Postgre that might work for
> you. One is simply called Versioning and  pgVersion. I had little success
> with them but it was giving me errors that someone who is more database
> knowledgeable might be able to interpret and correct.
> There is also the built in offline editing mode. I did some test with some
> success working with; PostgreSQL, MSSQL Express 2008R2 and 2012, and
> Filegeodatabase. Where I "checked out" some data into a sqlite database,
> made some edits and "checked in" the data. It worked with multiple users
> (my test was 2) as long as you didn't edit the same features. My testing
> was also on simple tables no relationships or triggers.
> To my knowledge even using versioned datasets through Esri you are still
> limited in that you and someone else cannot edit the same feature during
> the same check out because it causes conflicts on reconciling and someones
> edits will be over ruled. At least that is how it was on the system we were
> using on an Oracle db.
> Hope that helps;
> Tyler
>
> On Wed, Dec 20, 2017 at 10:28 AM, Morten Storm <morten.storm at artogis.dk>
> wrote:
>
>> Hi,
>>
>> We have quite a few QGIS users, who are used to working in ArcGIS for
>> Desktop on an Esri Enterprise Geodatabase. These users want to apply
>> versioned editing as known from ArcGIS.
>>
>> Their basic requirements for versioned editing in QGIS can be summarized
>> as follows:
>> - Versioned editing is based on data contained in a central multi-user
>> data repository (database), preferably PostgreSQL/PostGIS.
>> - The parent version/default version/master version is the "current"
>> dataset that all ordinary users access for data browsing purposes.
>> - Editing users should be able to create independent versions (or
>> branches) of the data set - either in its entirety or for selected
>> layers/tables in the data set.
>> - It is not an ultimate requirement that a specific version/branch can be
>> shared by multiple users.
>> - But one user must be able to edit, whereafter another user can review,
>> approve and commit.
>> - Generally the "parent version/branch" (default version in ArcGIS
>> terminology) should not be edited, but this need not be prevented by the
>> versioning solution.
>> - The individual user chooses which version/branch he/she wants to edit
>> at the beginning of an editing session.
>> - At any given time a user should be able to either delete (if edits are
>> to be dropped again) or commit the version/branch to the parent/default
>> version.
>> - A complete history of editing or the ability to regret commit of
>> version/branch is NOT needed.
>>
>> Do anyone know of any solutions, that will allow QGIS users to achieve
>> this?
>>
>>
>> Kind regards,
>>
>> Morten Storm
>>
>> ARTOGIS a/s
>> Eltangvej 61
>> 6000 Kolding
>> DENMARK
>>
>> Phone +45 75 53 73 93
>> Direct +45 76 30 82 22
>> Mobile +45 51 51 09 29
>>
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20171220/928fa864/attachment.html>