trench and trench_line - move trench_type to pipe_section table

[jpdupuy]

This issue has been raised by the initiators of the TDH module during the prototype presentation.

The trench (curvepolygonZ) and trench_line (compoungcurveZ) will never be used or captured by the land surveyors, nor by the QGIS operators. The datamodel references the trench by the fk_trench in the trench_line table. This means that the trench (polygon) must be created first. This is unrealistic. A special python tool should be created to allow to digitize the trench axis and ask for the trench_width. We do not believe that the landsurveyor will capture the axis of the trench, but rather the pipe_section fixed points, start and end points, and all intermediate elements.

Therefore, the initiators ask to include the trench_type and trench_width in the pipe_section table. There is a need to know the trench_type when the end user select a pipe_section.

[sjib]

• Think about how to relate these tables in a view vw_tdh_* (connecting pipe_section and trench)
• check with user needs described above
• sketch a new form
• implement in datamodel
• adapt project file