qwat srid still on 21781 (LV03)

[sjib]

How to deal with the srid in qwat when adding new layers for protection_tube / control_cable?
The projects file and datamodel restore are still on 21781

I get confused if I add 2056 for the new layers, as the srid_value lookup takes it from the settings.

@ponceta / @kandre Should I add the new layers with 21781 or 2056 (LV95)?

Is there a documentation how to change the whole project / database at once if someone wants to change from LV03 to LV95?

[ponceta]

On the paper, it is quite simple, just initialize a project with the desired SRID.

In practical cases, it become like a whole migration process between two very similar but not identical datamodels.

The most annoying thing is the fact that we cannot yet remove completely the application lockings from the data tables which is now possible on the new implementation of TWW, meaning we can't alter in a simple way the geometry columns since they are locked by many views, triggers, etc...

That's probably why no one has tried to migrate the demo project for now, but we could provide some guidelines on how it could be done.

[ponceta]

And the answer to the question would be :

• Please use the current SRID (21781) to integrate new layers to the project until we decide to migrate the whole thing to 2056. ;)