International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, Vol XXXV, Part B2. Istanbul 2004 
MAPPING AND GIS IMPLEMENTATION 
The collected data was transferred in a text file daily. This file 
contain x, y, z coordinates for each point. Text files contain also 
code of each item. The example for a text file is given on Figure 
l. Coding was developed using below listed information: 
e Municipality code — 2 digits — numeric 
e District code — 2 digits — numeric 
e Street code — 3 digits 
- . Primary street 3 digits — numeric 
- Secondary street first digit character (x) last 
2 digits is numeric 
e Type of item 1 digit character 
-  G for underground water items 
- . S for storm water items 
- I for catch base 
e ID for each item — 5 digits — numeric (ID begin from 
1 and continue for all collected data) 
Coding system is given in Figure 2. All text files were prepared 
daily using the collected data for each day by using x, y, z 
coordinates. We developed an application for creating these text 
files. This macro transfers x, y, z and ID from field survey 
equipment, finds the district for each point and writes it in text 
file. The text file names are the date of the day, such as 
10NOVOlI.txt for the collected data on 10 November 2001. 
Mapping is performed with a macro under MicroStation. Macro 
reads x, y coordinates for each item from text file and draw all 
points automatically on the locations which are read from text 
file. The GIS contains two different type of graphic feature. 
These are 
e Lines for pipelines 
e Points for catch base, groundwater, manholes and 
storm water manholes. 
Lines, which represent pipes, are drawn by snapping the points 
by a house made automatic mapping application tool. We 
developed a tool for digitizing the pipes. Operator combines 
two manholes according to registered as built maps using this 
tool. By clicking the manholes all the information such as x,y,z 
coordinates, municipality name, district code, street code, 
manhole number extracted and are transferred to the proper 
fields in the database representing beginning and end points of 
pipeline. After clicking the end point, the length of the pipeline 
measured automatically and is written in length field of the 
database. The slope of the pipeline is calculated using the 
length of the segment and "z coordinates of beginning and end 
points — depth of manhole' information of the segment. An 
example is given in Figure 3. The database contains for point 
feature below mentioned items 
e  ID-— was taken from field survey code 
e. X-was taken from field survey 
e. Y —was taken from field survey 
e. Z- was taken from field survey 
e Street names — was taken from field survey code 
e District names — was taken from field survey code 
eo Municipality names — was taken from field survey 
code 
eo Type of item — was taken from field survey code 
e Type (normal or exit) 
e Maintenance date 
310 
e Maintenance type 
e Maintenance period 
e Depth of manholes 
e Diameter of manholes and line code 
e Net name 
e Contract numbers 
e (Contractor name 
v 
The database contains for line features below mentioned items. 
e ID 
e Code 
e Maintenance period 
e Maintenance type 
e Maintenance date 
e Type of pipe 
e Length of pipe 
e Slope of pipe 
e Invert elevation 
e Diameter of pipe 
e Line code 
e Net name 
e Contract numbers 
e Material 
e Contractor name 
These features are collected in Ms Access database. In house 
developed macro reads the code from text file and creates the 
fields in the database and put the information in the database 
automatically. These fields are 
- Municipality names 
- District names 
- Street names 
- Types of items 
- ID for each item 
An operator using another macro in micro station simply links 
the other features for the points. By using this macro, after 
clicking an item, a data entry dialog (Figure 5a) appears and 
operator can enter the data for each item. These data will be 
linked in Ms Access automatically. The data may also be 
modified using this macro as illustrated in Figure 5b. The 
features that are entered by the operator are listed below: 
- Maintenance date (date) 
- Maintenance type (character) 
- Maintenance period (character) 
- Depth of manhole 
- Type of manhole 
- Diameter of the cover 
AII the ground and storm water maps compiled by Municipality 
were scanned. The Riyadh map and as built maps of 
municipality were registered and transformed by using the 
topographic maps that are compiled as part of project 116 of 
MOMRA and MOC roads, for digitizing of the pipelines. An 
example to such a map is given in Figure 6. This project has 
accomplished the development of a national seamless standard 
basemaps for all mapping and GIS implementation studies. 
Pipelines were being digitized from these maps in MicroStation 
for the pipelines layer. These lines were guide for drawing line 
features of GIS. After creation of the line feature, user could 
link the data to the pipelines by using another macro. All the 
Internati 
data that 
The feat 
After cre 
was mad 
file was 
show son 
SUR 
KINEN 
The pring 
the relat 
between 
radio con 
level prec 
than stati 
Hardware 
below.