The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences. Vol. XXXVII. Part B4. Beijing 2008 
Data Quality Control: This is an assistant module to control 
the data quality by editing the both of the newly created 
structure layer and pipe layer. The detail functions are shown in 
the figure 12. 
Editing Features 
a New Strucutre 
Attribute Data 
Add LOST # F12260| 
r New Pipe 
<•' Change Pipe Direction 
f Break Pipe Segment 
Connect 2 New Strns 
Sack i Exit ! Select Feature 
Figure 12. The Interface of the Editing New Feature 
Updating Existing Database: The Updating Existing Database 
is the final module in the SWDUS. The main function is to 
perform precise and fast replacement of existing data with new 
data. The methods include (1) dissolve the new pipes; (2) create 
a 10 m buffer in the dissolved layer shown in figure 13(a); (3) 
select the existing structures and the existing pipes in the buffer 
shown in figure 13(b); and (4) delete the selected dataset shown 
in figure 13(c). 
/* «*-*»* * • —“V 
• x t 
/ ‘, — 
v 
HP* 
•* • * Î “t* - 
tf- 
* 
*4~ ..... £ V y 
u f - 
/ 
^ / 
(a) 
(b) 
/ ; ^ 
1 ~ r > 
U~~- J 
(C) 
Figure 13. The Process of Updating Existing Database. 
(a) Create a 10 m Buffer, 
(b) Selecting the Existing Data in the Buffer, 
(c) The Result after Deleting the Selected Dataset. 
4. FIELD TEST and EVALUATION 
Survey and Storm Water crews have been organized to collect 
storm water spatial and attribute data respectively. The Survey 
Team determines the spatial position for each Structure by 
using GPS; the Storm Water Team collects each Structure’s 
attribute data, which include Structure type, size, invert, pipe 
count, pipe’s material, size, invert, etc. The two datasets are 
linked in the geodatabase by structure ID. In order to ensure the 
data precision, we selected GPS Topcon FC-100 with sub 
centimeter precision to survey each structure’s latitude, 
longitude and elevation and using Xplore Tablet to record the 
storm water field data in SWDUS (see figure 14). The collected 
Storm Water field data is saved by date, for example, table 
FD101206 includes all the data collected on October 12, 2006. 
Because the Survey team surveys separately, it is much faster 
than SW team’s data collection, so it is necessary to merge all 
the SW field data together to link with the Survey team’s GPS 
data. 
In addition, The Data Quality Control module in SWDUS can 
ensure the data quality by editing the created structure’s 
attribute data, adding lost or missing structures, changing pipe 
flow direction, breaks in pipe segments, and connecting two 
structures. 
The Storm Water Team 
The Survi 
tei.sïBii each S/ticCMic - J* 
Kirtthsjs-s. EaMjbg and f Ì 
Measure each sruetim: > ft pa size, imvi t, 
tope e>.rçirt. sîjafeml, size, »ma t, etc 
Figure 14. Field Test and Evaluation 
5. CONCLUSIONS 
The SWDUS is an ArcGIS application developed in-house by 
the Environmental Storm Water Management Division, Publics 
Works, City of Norfolk, VA. In U.S.A. Its design is based on 
the abounding experiences of the GIS programmer and Storm 
Water Engineer, so it functions and performs real live 
conditions with the high practicable and eased operations. The 
SWDUS development will enable the division to complete this 
project well ahead of schedule with a substantial savings to the 
project budget. Currently, the developed SWDUS system has 
been running in ArcGIS 9.2 version. We plan to add a module 
by taking advantage of GPS functionality in ArcGIS 9.2 to 
simultaneously measuring the spatial data and attribute data, as 
a result, reduce the field data collection time and labor intension, 
and increase the efficiency. 
ACKNOWLEDGEMENTS 
This project was funded by Environmental Storm Water 
Management Division, Publics Work, City of Norfolk, VA. 
U.S.A. we appreciate the supports from Michael Schaefer, the 
director of Storm Water division, Charles Kennedy, Information 
Management Supervisor in Division of Surveys, and the helps 
from all the colleagues involved in this project. Without the 
assistance of Ray Snedecor and Adarryll White, this project 
could not have been as successful. 
120 
■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■I