dma - Giswater/giswater_dbmodel GitHub Wiki
Description:
Catalog and configuration of dma.
In case of WS project dma's are district metering areas, the areas to account the water usage.
For UD projects there are district management areas, management areas of sanitation network.
Fields for WS Projects:
| Column name |
Data type |
Description |
Example |
| dma_id |
serial |
Id |
1 |
| name |
character varying(30) |
Name of the dma |
dma1-1d |
| expl_id |
integer |
Id of an exploitation, defined on exploitation |
1 |
| macrodma_id |
integer |
Id of zone group, defined on macrodma |
1 |
| descript |
text |
Description |
|
| undelete |
boolean |
If true, zone can't be deleted |
|
| 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 |
|
Fields for UD Projects:
| Column name |
Data type |
Description |
Example |
| dma_id |
serial |
Id |
1 |
| name |
character varying(30) |
Name of the dma |
dma1-1d |
| expl_id |
integer |
Id of an exploitation, defined on exploitation |
1 |
| 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 |
|
| active |
boolean |
If true, zone is being used on the system |
TRUE |