msm_Culvert

tables.auto_generated.msm_Culvert

Classes

Name	Description
msm_CulvertTable	Table for msm_Culvert (Culverts).
msm_CulvertTableColumns	Column names for msm_Culvert (Culverts).

tables.auto_generated.msm_Culvert.msm_CulvertTable(net_table)

Table for msm_Culvert (Culverts).

Name	Description
columns	Get the columns for the table.
description	Get the table description.
display_name	Get the display name for the table.
name	Get the table name.

Name	Description
delete	Create a DELETE query for this table.
get_muids	Get a list of MUIDs for the table.
insert	Insert a row with the given values.
select	Create a SELECT query for this table.
update	Create an UPDATE query for this table.

tables.auto_generated.msm_Culvert.msm_CulvertTable.delete()

Create a DELETE query for this table.

Name	Type	Description
	DeleteQuery	A new DeleteQuery object

tables.auto_generated.msm_Culvert.msm_CulvertTable.get_muids(
    order_by=None,
    descending=False,
)

Get a list of MUIDs for the table.

Name	Type	Description	Default
order_by	str or None	Column to order the MUIDs by	`None`
descending	bool	Whether to order in descending order	`False`

Name	Type	Description
	list of str	A list of MUIDs

tables.auto_generated.msm_Culvert.msm_CulvertTable.insert(values, execute=True)

Insert a row with the given values.

Name	Type	Description	Default
values	dict of str to Any	Column-value pairs to insert	required
execute	bool	Whether to execute the query immediately (default: True)	`True`

Name	Type	Description
	str or InsertQuery	If execute is True, returns the ID of the newly inserted row (MUID) If execute is False, returns an InsertQuery instance

tables.auto_generated.msm_Culvert.msm_CulvertTable.select(columns=[])

Create a SELECT query for this table.

Name	Type	Description	Default
columns	list of str	The columns to select	`[]`

Name	Type	Description
	SelectQuery	A new SelectQuery object

tables.auto_generated.msm_Culvert.msm_CulvertTable.update(values)

Create an UPDATE query for this table.

Name	Type	Description	Default
values	dict of str to Any	Column-value pairs to set in the UPDATE	required

Name	Type	Description
	UpdateQuery	A new UpdateQuery object

tables.auto_generated.msm_Culvert.msm_CulvertTableColumns(table)

Column names for msm_Culvert (Culverts).

Name	Description
AllowRecalculationNo	Allow for recalculation
ApplyFactorNo	Apply flow factor
Chainage	Chainage [m]
DataSource	Data source
Description	Description
DownstreamInvert	Downstream invert [m]
Element_S	Status
Enabled	Apply
FactorValue	Flow factor [()]
GeomChainage	Geometry chainage [m]
GeomDiameter	Diameter [m]
GeomHeight	Height [m]
GeomLinkID	Geometry link name
GeomTopoID	Geometry topo ID
GeomType	Type
GeomWidth	Width [m]
HeadLossCmTypeNo	Computational method
HorizOffset	Horizontal offset from marker 2 [m]
IrregularTypeNo	Table type
Length	Length [m]
LinkID	River ID
MUID	ID
ManningN	Manning’s n [s/m^(1/3)]
NegBends	Negative bends
NegFreeOverflow	Negative free overflow
NegInflow	Negative inflow
NegOutflow	Negative outflow
NoQhRelations	No. of Q/h relations
NonReturnNo	Non return flap
NonReturnTypeNo	Return flap type
NumOfCulvert	Number of culverts
PosBends	Positive bends
PosFreeOverflow	Positive free overflow
PosInflow	Positive inflow
PosOutflow	Positive outflow
SectionTypeNo	Section type
UpstreamInvert	Upstream invert [m]