man_hydrant - Giswater/giswater_dbmodel GitHub Wiki
Description:
Inventory table, that stores id and specific data of features with system id HYDRANT.
Fields:
| Column name | Data type | Description |
|---|---|---|
| node_id | character varying(16) | Id of node |
| fire_code | character varying(30) | Related code in case of fire |
| communication | character varying(254) | Communication |
| valve | character varying(100) | Valve related to hydrant |
| geom1 | double precision | Vertical dimension of the element |
| geom2 | double precision | Horizontal dimension of the element |
| brand | text | Brand defined on cat_brand,used in case when brand is not specified on node catalog |
| model | text | Model defined on cat_brand_model ,used in case when model is not specified on node catalog |
| hydrant_type | text | Type of hydrant |