Abstract

Development and Implementation of a Transportation Geodatabase
Track: Transportation
Authors: Phil Friesen

Like many municipalities, the City of Colorado Springs requires a street centerline that supports a multitude of business functions. Single-purpose, overly segmented layers which were difficult to maintain and provided limited utility had been used in the past. Consequently, a multi-use, multi-purpose enterprise geodatabase was built, starting with an analysis of business processes and construction of a data model. The data model is comprised of separate logical and physical centerline feature classes that are integrated through topology rules. The logical centerline represents streets as single lines, is minimally segmented, and provides the base structure for linear referencing. The physical centerline models streets to provide an accurate base for routing. Linear referencing is currently utilized to attribute address ranges, speed limits, pavement, Highway User Tax Fund records, and Computer Aided Dispatch records. The presentation will address key aspects of the implementation with an emphasis on the linear referencing approach.