Abstract
 Data Management for Transportation, Water, Sanitary and Storm in ArcSDE Track: Database Design, Automation, and Management Author(s): Jeff Whiting, Glen Boos The City of Saskatoon has separate data models for Parcel, Transportation, Water, Sanitary, and Storm in 1 ArcSDE. Transportation data is edited using NovaLIS Editor except for Asset Lines & Points. Asset Lines (for example, curbs, sidewalks, painted lines) are edited in AutoCAD and transferred to ArcSDE using SAFE FME batch program. Asset Points (stop, yield, overhead signs and traffic lights) are edited in MapGuide by field staff and transferred to ArcSDE. Water, Sanitary, and Storm are edited using AutoCAD with an editor extension soon to change to AutoCAD Oracle Locator. The data is then transferred to ArcSDE. The inventory data is completely replaced every four months while operation data (ie., hydrant pressure) persists. Operational data is supported by ArcPad from ten different field groups. Spatial inventory data is not changed by field staff but sent as event tables to data editors. MapGuide uses SAFE SDP to view ArcSDE data. Jeff Whiting City of Saskatoon Infrastructure Services 222-3rd Ave., N., Saskatoon , SK S7K 0J5 CA Phone: 306-975-1460 E-mail: Jeff.Whiting@City.Saskatoon.Sk.Ca Glen Boos City of Saskatoon Corporate Services Department 222-3rd Ave., N., Saskatoon , SK S7K 0J5 CA Phone: 306-975-2253 Fax: 306-975-2971 E-mail: Glen.Boos@City.Saskatoon.Sk.Ca |
|||||
