Import Datum Height for all Culverts

Glenn Morvan

Dear Tygron,

We recently built a digital twin of a future neighborhood to be developed. In this area all new waterways are modelled and connected with culverts. It seems that the Culvert Datum Height of all culvert is too high (above water line) by default. Therefore, we would like to lower the datum height of the culverts to allow more flow through the culverts. However, doing this for all culverts seperately and manually is too much work. Is there a way to import all culverts datum height at once (e.g. through CSV upload?)?

FYI: In the configuration wizard of the water overlay, we found a way to upload a csv, when checking the 'multi' checkbox in the culvert configuration (3.4.2), but in that case we run into the problem that we don't have a template csv with all culvert names in it. Making a csv manually with all culvert names also seems too much work. Is there a way to export a csv with all culvert names/codes?

Keen to hear from you!

Kind regards,

Glenn

RudolfNL

Hi Glenn,

The underlying question appears to be how to set the culvert threshold for all culverts, and added to that the question on how to get the names of all culverts.

the method you found (i.e. the multi checkbox mode in the wizard) is the recommended way for setting the culvert threshold across all culverts. There are a few other methods possible to set the height of all culverts, but they rely on all culverts making do with an identical culvert threshold. Thus, if its ok to place all the culverts on the water bottom, allowing water to flow through basically at all times, you could also use the following methods:

Create a new culvert function with Current Situation->Buildings->Edit Function values, then add the Culvert as a function and duplicate it. Give it an additional attribute (e.g. CULVERT-THRESHOLD-LOW) with a new threshold value of, for example -1000. Then use Current Situation->Buildings->Select multiple buildings to select all your culverts, and change them all in one go to your new culvert function. Finally, change the Water Overlay's key for culvert threshold to the new CULVERT-THRESHOLD-LOW attribute.

You can also use the Query tool to create a UPDATE statement for buildings. I believe its possible to create one of the form UPDATE-BUILDING-CULVERT-THRESHOLD-WHERE-FUNCTION-IS-[the id of the culvert functions]. Setting the value to -1000 and then executing the query will set the height of all culverts to -1000.

Using Tygron as a WFS, you can connect an application such as QGIS to your session, reading out your (underground) buildings layer. Tygron and QGIS also support WFS Transactions, allowing you to edit that layer in QGIS and then saving, the changes being sent back to your Tygron session as well. This means you can change the values of culverts in QGIS en masse, and then have those changed values applied to your session automatically, without the need to create an intermediate file.

To answer your question regarding the export of a csv with all culvert names: Any export of the culverts in any format will probably require a little bit of processing to place in the correct format for the csv import step (very simply: any export will list the culverts vertically, and the import will require the culverts horizontally, as the vertical direction is reserved for progression over time). There is the option for Current Situation->Buildings->Export Geo data, which provides a few format, one of which may be csv which you can then process into the right format.

Another option, if you want more control over how the export takes place, is to create an excel file with a query of the form SELECT-NAME-WHERE-BUILDING-IS-XA-CULVERT-THRESHOLD, and then upload that excel as a panel. Recalculate your project (set your complex Overlays to inactive as desired for a quicker recalc time), and then export the debug version of that panel. It should then contain a list of the names of all constructions with a CULVERT_THRESHOLD attribute.

Will any of these approaches work for you?

Regards!