Application of Client-Server GIS
to Urban Transit Facility Management


ABSTRACT

As urban transportation becomes more important than ever due to rapid growth of economics and social infrastructures, Pusan Urban Transit Authority(PUTA) had constructed Underground Transportation Systems since 1987. PUTA still expands it s underground transportation facilities more and PUTA realize that GIS based Urban Transit Facilities Management is very important for controlling the facilities efficiently.

PUTA set up a 'Client-Server' GIS facility management system with ArcInfo and ArcView. All drawings about 40,000 sheet of A0/A3 size which relates with facilities being built-up in the ArcStorm database on SUN Enterprises 3000 and pc ArcView on 24 PC hooked up with server and an application written by Delphi on ArcView controls the facility management systems, as client application. It handles details about facilities such as railway, tunnel, electricity, signal, communications and others such as administration boundary, geographic features, drainage and raster maps. All systems are hooked up on the network and ORACLE RDBMS was being used for database management.

Basic software for this facility management were ArcInfo and ArcView. The application was written using Delphi, Avenue and AML.

The Enterprise GIS concept is adopted for this project and client-server technology by using ArcInfo and ArcView were very efficient.



1. Introduction

Pusan Metropolitan City is the second largest city in Korea and underground transportation becomes more important due to rapid growth of economics and social infrastructures. Since 1981, Pusan Metropolitan City started the construction of subway line No.1 (with 34 stations) and set-up the Pusan Urban Transit Authority(PUTA) at 1988 in order to manage the underground transportation efficiently. PUTA will finish the construction of subway line No.2 in 1999 and subway line No.3 will be continued. (total length of line will be 135.7 km after constructing subway Line NO.4). In 1996, PUTA started to set up an 'Integrated Management System' for Management Information System(MIS), Computer Aided Drawing(CAD), Geographic Information System(GIS) in order to increase its efficiencies and cost saving purpose.

2. Project Objectives

  • 2-1 Integrate the existing data into GIS
  • 2-2 Develope the application for facility management in client-server architectue.

    3. Implementation

  • 3.1 Data collection

    Any attribute data which related with facility management for construction, railway, electricity, signal etc. are inputted into ORACLE RDBMS Ver.7.1.6 by using an application developed on Delphi 2.0 which is used for input, query and update the attribute data.
    Existing drawings were scanned and vectorized by 'tracer for AutoCAD'(about 40,000 sheet of A0/A3 size) and these were converted into ArcInfo coverage and shape file format.

  • 3.2 Client-Server system Programming

    Facility Management system was developed on the basis of client-server architecture by using ArcInfo and ArcView.
    Server program was developed as ArcTools format by adding some functions which PUTA will be needed.
    Server program also produce line type layer with STATION coordinate system(STA coordinate system) which reproduced from T.M. Coordinate System (conversion, remeasure and re-built route system). During this procedures, ArcEdit function on ArcTools was used.
    All the layers which produced through above procedures were distributed to clients through PC-NFS.
  • Modified ArcTools Menu
    <Fig 1. Modified ArcTools Menu>


    Facility Management Application Main Menu
    <Fig 2. Facility Management Application Main Menu


    Client application was developed by using ArcView 2.1 and it included following functions in addition to basic function of ArcView 2.1.

    <Additional Client Functions>

    - attribute query
    - measure
    - connection with external DBMS by ODBC and query
    - dynamic segmentation (by using route-system)
    - auto-labeling and layer control
    - auto registration deletion theme
    - automatic creation deletion table
    - external program interface
    - user control and password security
    - dynamic image interface


  • 3.3 Interface between spatial features and attribute data

    All attribute data which are required for facility management are collected through various reports and survey drawings collected data are inputted into ORACLE RDBMS through the application which developed by Delphi 2.0 and these ORACLE database are forming ArcView Table through ODBC 32 driver on Windows 95.
    All data on historic log book are joined to Spatial Index Layer and all attribute data on daily report will be displayed as event theme on route-system layer by dynamic segmentation.
  • Attribute input menu by Delphi
    <Fig 3. Attribute input menu by Delphi>


    Example of Spatial query by attribute and sptial feature
    <Fig 4. Example of Spatial query by attribute and spatial feature>


    Example of query through ODBC32 driver
    <Fig 5. Example of query through ODBC32 driver>


    Example of event theme display after query
    <Fig 6. Example of event theme display after query>


    4. Conclusion

    All attribute data for facility management by daily checking and survey results will be gathered during night-time and sent to headquarters early next morning.
    In order to make these data effective, the client-server technology with RDBMS are being used. PUTA has ArcInfo, Oracle on data center server with client ArcView, all gathered and analyzed data can be displayed graphically very accurately. In addition, details will be displayed with image dynamically. So decision maker can get valuable information through this system.
    Also PUTA can check weak points for facilities through statistical query on graphics.

    5. Acknowledgment

    Special thanks will be addressed to director JOON Lee at PUTA who give us good direction for overall implementation and Mr. Hyun Ho Kim at CADLAND for his ArcView programming and president Ki HONG Kim at Sekwang Information for drawing scanning & Drawing Management programming.


    References

  • Esri, 'Advanced ArcInfo' Training Material
  • Esri, 'Network Analysis', Esri Arc Documentaton, 1994
  • Charles Calvert, 'Delphi Unleashed', Sams Publishing, 1996
  • Esri, 'Getting to know ArcView GIS', 1997
  • Scott Hutchinson and Larry Daniel, 'Inside ArcView', 1997


  • NO KYU PARK/GYEONG WOO LEE
    Pusan Urban Transit Authority
    861-1, Bumchun 1-Dong Jin-Gu
    Pusan,
    Korea
    Tel : 82-51-640-7158
    Fax : 82-51-645-5661

    CHANG HAHK HAHM/JAE HO CHO
    Inha Technical Junior College
    Dept. of Geoinfomatics
    253, Yong Hyun-Dong, Nam-Ku
    Inchon,
    Korea
    Tel : 82-32-870-2242/ MR. HAHM
    Tel : 82-32-870-2511/ MR. CHO
    Fax : 82-32-870-2511

    JOONG HI RYU
    CADLAND, INC/GIS Dept.
    Songnam Bldg. 3rd Floor, 1358-6
    Seocho 2-Dong, Seocho-Ku
    Seoul,
    Korea
    Tel : 82-2-3473-4888
    Fax : 82-2-3474-2090