ws_dma - Giswater/giswater_dbmodel GitHub Wiki
Description:
Table of spatial objects representing District Meter Area.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| dma_id | integer | Id | |
| name | character varying(30) | Name of the dma | dma1-1d |
| dma_type | character varying(16) | Description | |
| muni_id | integer[] | Description | |
| expl_id | integer[] | Description | |
| sector_id | integer[] | Description | |
| macrodma_id | integer | Id of zone group, defined on macrodma | 1 |
| descript | text | Description | |
| undelete | boolean | If true, zone can't be deleted | TRUE |
| the_geom | geometry(MultiPolygon,SRID) | Multi polygon geometry of zone | |
| minc | double precision | Default value of minimun coefficient | |
| maxc | double precision | Default value of maximum coefficient | |
| effc | double precision | Default value of efficiency | |
| pattern_id | character varying(16) | Consumption pattern applied on the zone, defined on inp_pattern | dma01_estimated |
| link | text | Link | |
| graphconfig | json | Definition of a zone header (nodeParent) and a direction of a flow(toArc). Necessary in order to perform dynamic zonification process | {"use":[{"nodeParent":"10280", "toArc":[2092]}], "ignore":[]} |
| stylesheet | json | Definition of a style applied on a qgis layer after executing dynamic zonification process | {"color":[251,181,174], "featureColor":"251,181,174"} |
| active | boolean | If true, zone is being used on the system | TRUE |
| avg_press | numeric | Average pressure | |
| tstamp | timestamp without time zone | Description | |
| insert_user | character varying(15) | Description | |
| lastupdate | timestamp without time zone | Description | |
| lastupdate_user | character varying(15) | Description |