4. Detailed Description of Column Values
Here is a detailed description of the use of specific columns, on per module basis.
4.1. Municipal module
Column LOG_LOCATIONS.GIS_ID contains SETT_ID (converted from integer to string).
Column LOG_REF_VALUES.PARAM_TYPE contains:
| DDR | domestic distribution rates |
| CDR | commercial distribution rates |
| SIDR | small industries distribution rates |
| PDR | pastoral distribution rates (actually, pastoral distribution rates are not used, but this value should be reserved for future use) |
| DWD | domestic water demand |
| CWD | commercial water demand |
| SIWD | small industries water demand |
| PWD | pastoral water demand |
Column LOG_Y.PARAM_TYPE contains:
| GR | growth rate |
| M | migration |
| SC | salinity class |
Column LOG_M.PARAM_TYPE contains:
| DID | domestic sudden increase / decrease |
| CID | commercial sudden increase / decrease |
| SIID | small industries sudden increase / decrease |
| PID | pastoral sudden increase / decrease |
| DYID | domestic yearly increase / decrease |
| CYID | commercial yearly increase / decrease |
| SIYI | small industries yearly increase / decrease |
| PYID | pastoral yearly increase / decrease |
4.2. Touristic module
Column LOG_LOCATIONS.GIS_ID contains SETT_ID.
Column LOG_REF_VALUES.PARAM_TYPE contains DR for distribution rates.
Column LOG_Y.PARAM_TYPE contains:
| GR | growth rate |
| ID | increase / decrease |
| WD | water demand per bed unit |
| SC | salinity class |
| LA | landscaping areas of tourist installations |
| SLC | salinity class for landscaping |
Column LOG_M.PARAM_TYPE contains:
| OC | occupancy rates |
| GIR | Gross irrigation requirements in m3/dunum |
4.3. Industrial module
Column LOG_LOCATIONS.GIS_ID contains FACILITY_ID.
Column LOG_REF_VALUES.PARAM_TYPE contains DR for distribution rates.
Column LOG_Y.PARAM_TYPE contains:
| GR | growth rate |
| EN | expansion (net) |
| EW | expansion (wells) |
| WWG | waste water generation rate |
| SC | salinity class |
Column LOG_M.PARAM_TYPE contains OC for operational capacity.
4.4. Losses module
Column LOG_LOCATIONS.GIS_ID contains SETT_ID.
Table LOG_REF_VALUES is not used for this module.
Column LOG_Y.PARAM_TYPE contains AL for assumed losses.
Table LOG_M is not used in this module.
4.5. Waste water module
Column LOG_LOCATIONS.GIS_ID contains FACILITY_ID.
Table LOG_REF_VALUES is not used for this module.
Column LOG_Y.PARAM_TYPE contains:
| AC | assumed coverage |
| ARF | assumed return factor |
Column LOG_M.PARAM_TYPE contains ALI for assumed losses + inflow.
5. Description of the configuration file options
Two additional lines (keys) are added to the configuration file dvs.cfg:
These modifications were necessary because during parameters transfer between online and offline and vice versa, connection should be established to both databases simultaneously.