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