Real-time Pavement Management for Sonoma County
Direction Magazine features an article on on using an Enterprise GIS asset tracking system to help monitor and maintain the Sonoma County pavement network system. The new GIS-PMS implemented by Farallon Geographics allows County management to use a Web-based map interface to identify problem pavement areas in near real-time.
Using ESRI’s ArcSDE geodatabase technology and Microsoft’s SQL Server database, Sonoma and Farallon designed a GIS data model that would support integrated, real-time access to MTC StreetSaver’s pavement information using Dynamic Segmentation. This insure that the tabular and map datasets always remain in sync and the GIS maps can accurately highlight just the portions of a roadway that require maintenance.
The dynamic segmentation capability allows edits to be made to the StreetSaver data directly from the GIS by clicking on a segment and changing attributes specific to the road network segment. Pavement managers can immediately see the results of such data changes on a map. Using the integrated GIS and PMS, County staff can quickly map StreetSaver information into the GIS and perform spatial analysis, allowing them to quickly create maps showing the extent of distressed streets.
An ArcIMS Web application allows Planning, Public Works and Finance personnel to interact with StreetSaver tabular data linked with dynamically segmented GIS maps. This site allows management personnel, who are not GIS experts, to quickly identify and understand problem pavement areas. For example, it allows County managers to immediately to see the latest pavement distress maps and budgeting scenarios.