Branches: Water Planning & Information Management

and Regulation

Process Automation and Application Rationalisation

Branch : Water Planning and Information Management Organisational Structure:

Water Planning and Information Mangement

CD: Integrated Water Planning

4dir.

CD: Water Information

Management 4dir.

CD: Water Ecosystems

Management 2dir.

CD: Water Services and Local

Water Management 4dir.

CD: Sanitation Macro Planning and Information Management 1dir.

Branch : Regulation Organisational Structure:

Regulation

CD: Economic Regulation 4Dr

CD: Compliance Monitoring 5Dr

CD :Water Services

Regulation 2Dr

CD: Water Use Authorisation 4Dr

CD: Mine Water Management 2Dr

CD: Enforcement 3Dr

E-WULAAS

NIWIS

WARMS

WMS SAP

Resource Directed

Measures DSS

SAP _C4C NCIMS

Green Drop Blue

Drop

LIMS(M)

ECMS

PI

ACCESS

REGISTRY SYSTEM

LEGEND

Existing Future In Progress Proposed

Systems Integration Requirements Diagram

Economic &Social

Regulation

FMS

Resource Protection &

Waste

Water Abstraction & Instream User

No Drop

HYDSTRA

NGIS REMP

LIMS

SPATIAL

DATA

SWAF

WOIS

ARCGIS

LOCALITY DATABASE

E

SEDIMENT REPORT CAD

Systems/Data Integration between : For what purpose ? Existing, Future or In Progress

WOIS- SLIM Central Repository For central storage and accessing of aerial/Remote Sensing data with set permissions Future

ArcGIS/CAD - SLIM Central Repository For central storage and accessing of GIS, spatial and cadastral related data , in the form of land parcels; maps; shapes etc

Future

Surveys - SLIM Central Repository For storage and central access with set permissions of survey data , including topographical, hydrological and deflect surveys- SLIM Surveys

Future

Sediment Program Upgrade compatibility of Sediment Program to versions after Windows XP. Currently stand-alone and restricted to an old XP Machine , which is no longer performing optimally.

Future

Locality Database - NCIMS Move Locality database to a network location, Sole function of the database is to assign a unique id to each dam that is registered with DWS. Information and dam attributes will be received from NCIMS and used to register the dam in the locality DB

Future

SLIM Central Repository -CHART Spatial Groundwater data collected at SLIM surveys is imported into CHART Existing

CAD- ArcGIS Land parcel conversion from CAD into GIS format for use in SAP . In Progress

CAD - SLIM Spatial Repository For storage and central access with set permissions of cadastral related data . Future

Locality Database - NCIMS After a dam application is approved, the dam owners profiles are provided to the locality database to capture and assign a locality number which becomes the primary identifier for the dam

Future

ArcGIS - SAP Real Estate GIS data related to land being rented or leased out; purchased under expropriation to be imported into SAP Real Estate for billing

In Progress

SWAF - NIWIS Ranking and Rating of Mines based on set KPIS will feed into NIWIS for accessibility by the public

Future

Systems/Data Integration between : For what purpose ? Existing, Future or In Progress

WMS- LIMS Integrate WMS and LIMS to allow • WMS transfers sample and laboratory analysis schedules to LIMS • LIMS register the samples with scheduled analysis, • LIMS analyse the samples and update the interface tables with the result • WMS read and import the analysis into to WMS

In Progress

WMS- eWULAAS Water quality data is extracted from the National Water Quality database to be used with license applications

Existing

WMS- CHART Surface and Groundwater Quality Data from WMS database Existing

WMS - NGA Water quality data is imported by the Groundwater Archive System directly from the WMS database

Existing

HYDSTRA- WMS Water quantity data ( surface water) , groundwater levels time series , rainfall and river flow are extracted from the Hydstra system in order to calculate loads.

Existing

SWAF- eWULAAS Provide eWULAAS with actual volumes of water utilised by mines for billing Future

RDM DSS - eWULAAS RDM DSS assists in the license application at eWULAAS process by providing information related to a particular reserve and its status in the reserve determination process

In Progress

No Drop System System related to non revenue water used for capturing of water conservation/water demand management efforts and questions in a score card format .Interface to SAP_c4c to be provisioned for tickets logged related to water leakages and non revenue water that will need to be redirected by the helpdesk to the No Drop System.

Future

FMS FMS to be replaced possibly with Mike 11 which is an already existing hydrodynamic, versatile modelling package used for rivers and channels modelling (COTS) .Interface to SAP_ c4c to be provisioned for tickets logged relating to flood, e.g. requests for information regarding flood that will need to be redirected to FMS.

Future

REMP River Eco Status Monitoring Program used to monitor ecological conditions of river ecosystems. Being replaced as it has not worked since 2015.

In Progress

Systems/Data Integration between : For what purpose ? Existing, Future or In Progress

DSS-eWULAAS Provision of Reserve Determination figures Future

eWULAAS - SWAF Audited water reports from the users Future

eWULAAS – Resource Protection and Waste

User self-monitoring data and volumes Future

eWULAAS – SAP_c4c (Call Centre) Provision of Licence application status Future

eWULAAS- Registry System Provision of file number to generated from eWULAAS to Registry System, in order to keep track of all stored/archived physical documents.

Future

Excel spreadsheet (Water Abstraction & Instream Use) - eWULAAS

Capturing of input/comment data from the specialist for the processing of water Use Licence Applications

Future

WMS – Blue Drop Provision of Raw water data quality from a specified point. Future

WMS – Green Drop Provision of resource quality data from a specified point Future

eWULAAS – Green Drop Retrieval of approved water licence users effluence compliance data

Future

Green Drop - ECMS Provivision of effluent compliance data, utilised for cases within enforcement team. Future

Systems/Data Integration between : For what purpose ? Existing, Future or In Progress

SAP_C4C - ArcGIS

Tickets logged on SAP_C4C that require GIS information, will require ArcGIS integration to locate the specific area in question.

In Progress

ECMS – NCIMS Provision of case progress report (status) Future

SAP_C4C- ECMS Retrieval of data concerning reported cases by public member

Future

NIWIS – Economic & Social Regulation Provision of KPI 1 (Access to water supply, KPI2(Access to Sanitation), KPI3 (Access to Free Basic Water ), KPI 4 ( Access to Free Basic Sanitation) data

Future

Blue Drop – Economic & Social Regulation

Provision of KPI 5 (Drinking Water Quality Management) data Future

Green Drop – Economic & Social Regulation

Provision of KPI 6 ( Waste Water Quality Management) data Future

Economic & Social Regulation - ECMS Non- complaint Water Users, cases will be handed over to ECMS Future

SAP – Economic & Social Regulation Provision of Raw Water Tariffs Future

eWULAAS – Economic & Social Regulation

Retrieval of abstracted volumes of water , updates on licences conditions of Water Users Future

NCIMS – Economic & Social Regulation Performance Data Future

SAPc4c – Economic & Social Regulation Provision of Customer Disputes information Future

Spatial Data – Economic & Social Regulation

Provision of GIS information regarding water sources, the specific areas in which the water sources are found in order to ascertain the cost of supplying water to that area (for tariff determination)

Future

NGIS – Economic & Social Regulation

Provision of rainfall data ,groundwater ,surface water levels ( what is available) and information related to the cost of supplying water in a particular area

Future

Systems/Data Integration between : For what purpose ? Existing, Future or In Progress

WARMS - ECMS

Retrieval of data of all registered Water Users ( not only the authorised user)

Future

No Drop – Economic & Social Regulation

Provision of KPI11(Water Use Efficiency) data Future

SAP_c4c-SAP

Provision of updated customer details and retrieving billing information Future

eWULAAS – NCIMS

Retrieval of Non-compliant Water Users In Progress

NCIMS – ECMS

Provision of Non – Compliant Water Users details, Referral, compliance monitoring reports and progress reports of cases which have been handed over from NCIMS

Future

WARMS - eWULAAS

Retrieval of Water User registration details, and data of approved Water Use Licences . Development 60% complete.

In Progress

Microsoft Access – NCIMS

Module has been built within NCIMS, to cater for the capturing of Dam Owners’ details and be stored with the NCIMS database. Currently on UAT phase

In Progress

WMS -eWULAAS

To retrieve interactive water quality reports , Landing Page has been developed within eWULAAS for Water User to upload self monitoring data

Existing

WARMS - NCIMS

Retrieval of registered user details Existing

LIMS (Municipality) – Blue Drop & Green Drop

Provision of drinking water quality data Existing

Excel Spreadsheet - Resource Protection and Waste

Process Automation of Manage Records of Decision – This in entails the granting of Waste Discharge Licence in collaboration with the Department of Environmental Affairs.

Future

Excel Spreadsheet – Mine Water Management

Require a data management system for capturing of assessments and mitigation measures in the catchments with potential of AMD generating mines. (Mine Water Management) Require a data management system for hosting of technologies for the treatment of mine water.

Future

NIWIS

Spatial Database

LEGEND

Existing Future In Progress Proposed

NIWIS BI Reporting Systems Diagram

Blue Drop

ECMS

Economic & Social

Regulation

FMS

WMS

HYDSTRA

NGIS

REMP

WARMS

NCIMS

Green Drop

ArcGIS

e- WULAAS

SAP

SWAF

RDM ESS

CAD

WOIS

No Drop

Systems/Data Integration between :

For what purpose ? Existing, Future or In Progress

eWULAAS - NIWIS License Tracking Progress Existing

NGIS - NIWIS Provision of groundwater status i.e. levels and monitoring; Pump testing or drilling hydro geological census ; Abstraction boreholes; Yield or Exploration Studies; Geochemical Information

Existing

HYDSTRA - NIWIS Provision of Rainfall, runoff and river Flow data ;Ground Water potential; Surface water storage; Groundwater level and surface water monitoring networks data. Gauging Stations/Calibration information; Evaporation and Dam basin Characteristics; Dam Supply Capacity

Existing

WMS - NIWIS Provision of Water Quality Data Monitoring information e.g. Resource Water Quality objects; Health Risks related to using untreated water from rivers and dams; Eutrophication hotspots

Existing

WARMS - NIWIS Provision of data on Raw Water Tariffs; Existing Lawful Water Use ,General Authorisations; Abstraction Quantities; Water use Authorisations Process License Status; Validations and Verifications; Number of (Type) Registered User; Number of License Applicants (registered and unregistered)

Existing

Blue Drop - NIWIS Provision of Drinking water quality data Existing

Green Drop - NIWIS Provision of Waste Water Quality data Existing

SAP- NIWIS Provision of Water Tariffs and Actual Water Use data. Existing

FMS- NIWIS Provision of Flood (Raw Data and Probability Analysis); Hydrological Real Time Data on River Flows, Dam levels and rainfall data .

Existing

ArcGIS /Spatial Database/CAD/WOIS – NIWIS

Provision of Spatial information Existing

RDM DSS – NIWIS Provision Groundwater and Surface water Reserve related Information In progress

Systems/Data Integration between :

For what purpose ? Existing, Future or In Progress

REMP – NIWIS

River health information Future

SWAF – NIWIS

Provision of KPIs for the mines to assess performance and rate mines against their WC/WDM plans Future

ECMS – NIWIS

Provision of data related to level of compliance per case ;classification of offences by activity type; classification of offences per sector; status of legal processes associated with cases.

Existing

NCIMS – NIWIS

Provision of Dam Safety data ; Capacity /Inspection Reports; Dam Basin characteristics; license issued, water risk ;Dam Usage/Owners and Areas

Existing

Economic and Social Regulation – NIWIS

Provision of KPI 1 (Access to water supply, KPI2(Access to Sanitation), KPI3 (Access to Free Basic Water ), KPI 4 ( Access to Free Basic Sanitation) data

Future

No Drop – NIWIS

Provision of Non Revenue Water data in the forms of water balance components directly from municipalities via No Drop.

In Progress