sys_feature_epa_type - Giswater/giswater_dbmodel GitHub Wiki
Description
Catalog of arc and node types defined by EPANET or SWMM hydraulic model.
Fields:
| Column name | Data type | Description | Domain values |
|---|---|---|---|
| id | character varying(16) | Type defined by EPANET model | WS: ARC: [UNDEFINED, PIPE, PUMP-IMPORTINP, VALVE-IMPORTINP, VIRTUALVALVE]NODE: [INLET, JUNCTION, UNDEFINED, PUMP, RESERVOIR, SHORTPIPE, TANK, VALVE] CONNEC: [UNDEFINED, JUNCTION]UD: ARC: [CONDUIT, ORIFICE, OUTLET, PUMP, WEIR,UNDEFINED, VIRTUAL]NODE: [DIVIDER, JUNCTION, UNDEFINED, OUTFALL, STORAGE]GULLY: [UNDEFINED, GULLY] |
| feature_type | character varying(30) | Feature type assigned to EPA type | [NODE, ARC] |
| epa_table | character varying(50) | Name of the epa table related to the type | WS: [inp_junction, inp_reservoir, inp_tank, inp_pump, inp_valve, inp_shortpipe, inp_pipe, inp_virtualvalve, inp_inlet, inp_pump_importinp, inp_valve_importinp, inp_connec]UD: [inp_junction, inp_outfall, inp_storage, inp_conduit, inp_outlet, inp_orifice, inp_pump, inp_virtual, inp_weir, inp_divider, inp_gully] |
| descript | text | Description | |
| active | character varying(30) | If true, catalog value is being used |