Integration of SCADA, GIS, and Call Center Systems for Electrical Power Distribution Management and Planning

In electrical power distribution systems the traditional methods cannot detect the customer fault location in real time and respond to customer complaints at the same time of the outage of the electric power because the required information is scattered among isolated databases. In this paper the combination of Supervisory Control and Data Acquisition (SCADA) and Geographical Information System (GIS) and using SQLCMD against DBSET has been shown to solve this problem better. This paper reducing the response time of the customer waiting when they calling the agent in the call center, creating a model for the integration of real time data in SCADA system against static data in GIS to make online GIS and send data from GIS to CALL CENTER at the same time. The prototype describes the flow of the data between various systems and integrates all in one logical database that contains all data about the customers. The proposed model depends on three major sub-systems: GIS, SCADA, and Call Center systems. The GIS system is base of the model so the change and update in GIS database is available, GIS provides different features like maps, real coordinates and tables. The model contains three different databases, GIS as geo database, SCADA as the real time database and call center as customer information database, all this database will be in one logical global database that contains of spatial information tables, asset information tables, topology information tables, and operation information tables. This method has been shown to significantly improve the accuracy and efficiency of fault detection in distribution networks and to decrease the response time in call centers