Trench - foreign key from trench_line to trench

[jpdupuy]

I believe that the foreign key defined in the trench_line table does not make sense.

The land surveyor is supposed to capture the trench axis (CompoundCurve) instead of the trench edges (CurvePolygon) because it takes less time and less number of points.

Furthermore based on the current datamodel, you currently have to capture the trench polygon with QGIS (and all of the attributes like trench width, depth, type, ....). Then you can capture the trench_line, and then refer the foreign key to the trench polygon.

It would make more sense to define all of the attributes to the trench_line, and then build a buffer depending to the trench width. The trench polygon is just a construction.( suggest to ;

• trench_line (rename to trench_poly +change geometry type from CompoundCurve to CurvePolygon + change fk)
• trench (change the geometry type from CurvePolygon to CoumpoundCurve)

Luzern Specifications : Le tracé ne doit être capturé que si sa largeur dépasse 2 m ou s'il s'agit d'un canal maçonné ou en béton. Les autres captures de tracés sont facultatives. Le tracé est capturé comme une ligne pour une géométrie parallèle. Pour des objets plus complexes avec des angles supplémentaires, une géométrie en surface peut être capturée.