Mary Handriati, Endy Prianto, Kamdi

GIS DEVELOPMENT FOR CUSTOMER SERVICES IN PT. TELEKOMUNIKASI INDONESIA


ABSTRACT:
PT.TELKOM, as state own telecommunication company in Indonesia, acknowledged the potential of GIS technology to increase their performance and services. For that purpose, they decided to use ArcInfo and ARCVIEW to develop their GIS application. By developing this system PT.TELKOM expected to be able to give a better, faster and more accurate services for their customer. In addition, the potential information of the cable, network condition and trouble shooting, could be recognized easier by using this system. The system was designed to utilize ArcInfo Version 7 and PC ArcView 2 and customized to get information of network cable and customer from INGRES relational database format. Besides, this system integrate an ArcInfo, INGRES database and Arcview 2 which have distance of 5 - 15 Km each others in an Online connection.To get better performance of transferring and querying data, some brige and middleware was install to the system.

INTRODUCTION:
Utilization of GIS technology has been extended into many different fields. Today, automated Mapping and Facilities Management becomes the new potential application for GIS, especially in telecomunication area. PT. Telekomunikasi, as state own communication company in Indonesia, acknowledged the potential of GIS technology to increase their performance and services. For that purpose, as the initial project, they decided to use ArcInfo and ARCVIEW to develop their GIS application.

PT. Telekomunikasi Indonesia (PT. TELKOM) always aims to give the best services to their customers. For achieving that purpose, PT. TELKOM in conjuction with PT. Nusantara System International (PT. NSI), as the agent of Esri products in Indonesia, developed a GIS system for customer services. This system is called GIS SISKAMAYA, Siskamaya means System for Cable Administration and Service management that maintain Cabling network information.By developing this system PT.TELKOM expected to be able to give a better, faster and more accurate services for their customer. In addition, the potential information of the cable, network condition and trouble shooting, could be recognized easier by using this system.

OBJECTIVES:
The objective of the GIS Siskamaya development in PT.TELKOM was to increase services to the customer and to maintain the network information (cable). The detail objectives of GIS Siskamaya were:

- to give a better services to the customers, especially new potential
  customer 
- to make a better system for analizing the cable network 
- to perform a better network planning 
- to be able to do trouble tracing and shooting.  
- to prepare data for demand forecast 
- to maintain both graphical and attribute data easily 
- to integrate Graphical and alphanumeric data 
- to compute cabling administration 
- to handle network data problems
For the pilot projects, two service points were selected from nine service points in Kandatel Bandung (Telecomuniation region office). They provided services for more than 30.000 telephone customers. This pilot project took four months to be completed and successfully implemented in November 1994.

SCOPE OF WORK:
Bandung Telecomunication Region Office has 9 (nine) service points that have several stations for each service point. The 9 service points have the same textual data base which stored in one mini computer (IBM RS/6000). All service point linking to the same data (textual/alphanumeric) in central database, therefore that only one data that use by many operator in areas entire Bandung. The Share Database concept was implies in this system.

GIS was develop for helping the operator to find the DP (Distribution Points) around the house which potentially take from. Before GIS, the operator has some mapping text that give information what DP could take from what street. But this mapping could not help if the house of new customer could not in a regular number (like most of the houses in Bandung). By GIS, the operator could identify the house easily and faster analyzing. Basically scope of work is what the operator do when the new customer come to have new telephone line, that requirement could describes into several way:

  1. The operator should find the house of new customer by query of the address /street then
  2. Operator should identify which DP's inside the radius of max 250 of the house.
  3. From that DP they should chose one DP that has enough line to take. This DP information like how many the free lines,pair, the network , should access from the central database that has distance about 5 to 15 km from the service points.
  4. After find the DP and telephone number and the other information , the operator must entry the data of new customer and updating the cable information in the common database as well, which will be used by another operator. This updating is very important, because with this real time updating, the the data was updating every time and every second. There fore this shared database was very important to use.
Using this shared database is no longer each service point store, manage and update this information independently. Everyday and everytime when there is a new customer the data will updated automatically.

What descibes above are some scope of work of the operator, the front desk officer, that they called Front Room. Besides, there is a section that has duty to maintain the geographic data of cable network, called by Back Room. Back room should preparing data, taking a survey for updating and updated GIS data maps and textual for which will use by Front Room. After the updating process, Back room should should submit that data to Service points PC's , which has local data maps (for each Service Point) through Wide Area Network.

The another important thing of the scope are: Although the service points are spread in the city but they all access the same the Cable Network Information which store in The Central database in in INGRES format. The operator in each Service Point uses Pcs which online connecting to the Central database which placed more than 5 Km from Service Point.

To make this Workstation and PC's spread in whole Bandung area linking each other those machine should integrate in a Network and uses some telephone line to connect among them.

STRUCTURE HIERARCHI
The Cable network has hierarkhi as follows:

Cable network hierarkhi

STO - Otomatic Telephone Central, describes as a points. This is the central of the telephone in a region.

SSP - Cable House, the place where the secondary cable was collected before distribute.

DP - Distribution Points, describes as a points. This is where line telephone distributes to customer house

DATA MODEL:
This GIS project was taken 2 (two) service points as pilot project, Centrum and Turangga. Both are plotted by 57 grid maps of 1 : 1000. The geographical data of those area devided into several layers that design will be usefull for customer application services, some of layer those are:

  1. Road
  2. Center line
  3. River
  4. Houses/building
  5. Distribution Point
  6. Primary and Secondary Cable
  7. SSP (Cable House)
  8. Boundary of Central station
  9. Boundary of SSP
  10. Adminstrative Boundary
Besides, some annotation of Cable network, DP and especially Houses number will helpfull the operator to identify the new customer address. To find the house number some survey was taken into the field. Since the number of the house is the first identify of new customer by operator, it was no need to entry house number as an attributes, therefore the house number will appear as an annotation.

It is not the same as house number, DP's and SSP should appears as annotation and an attributes as well. Because this DP and SSP should linking with the DP and SSP in Central database.

Besides this regular hierarkhi data, that was some irregular hierarkhi, a DCL (Direct line area). Not like the DP which distribute in Secondary cable and SSP from Primary, DCL distributes in Primary Cable. That means the DCL function same as DP but the information store in the level of SSP. That is why this database should design very carefully to fit with the existing database.

In the Central Database, alphanumeric data stores in INGRES format in Mini Computer. This textual data was develop long time before GIS develop, then the important things that the GIS should used the existing data which has been entry and design before. This kind of work was really not the simple as if the textual data was design same time with the GIS data.

In this case the design of textual data could not change at all, and the GIS should develop follow on the textual information. To integrate between existing and new data, then some new field created in the existing database as keys for linking to the geographic data.

SYSTEM CONFIGURATION:
To design system that integrate application and data in Workstations and PC's also in a Wide Area Network with Online connecting and the cheapest way are really not easy. Fortunatelly, about middle of 1994, ArcInfo - the Best solution, publish the new client server concept packet module, ArcView 2 which any in PC's format. Therefore the system could design to fulfill the PT.TELKOM needed, and the configuration could describes as follows (see Software Configuration, SoftKonf.gif):

  1. Central Database collect all alphanumeric data which serve to every service point. This database are in INGRES Rdbms format and store in Workstation.
  2. Backroom maintain all geographical data using ArcInfo Version 7.0 in IBM RS/6000, when Backroom has updated data (network cable, house or streets) should submit to PC's in Service point using the 64 Kb leased line.
  3. PC's in Service point has local data maps and centralized data textual that online connect to the Central Database. PC ArcView2 and Avenue was customized the application for operator which could modify (edit, update) the textual data in Central database.
  4. To make all the system running well with good performace, some Bridges with 64 Kb telephone lines were install in Wide Area Network.
APPLICATION DEVELOPMENT
The interesting one in this pilot project are application development part. These application development has been formed to have a user friendly application for the user in Back room and Front room, therefore they don't have to know the commands of ArcInfo and especially for operator in front room that has limitation knowlege of Computer software.

Basically the application development in this pilot is divided into 2 kinds of application.

  1. Backroom application package was develop for maintaining and capturing geographical data. This application develop by customizing ArcInfo with AML. This application are programmed to create, modify, edit , query, map/report and update the geographic data. Besides, this backroom application could query and updated the textual data in INGRES as well when the permission was enable.
  2. Frontroom application package was develop for operator to serve the customer when they need new telephone line or other information in front desk. This application was develop by Avenue of ArcView 2. Some application used Structure Query Language (SQL) commands for getting information in INGRES RDBMS.

CONCLUSION: