City of Santa Rosa GIS/PMS integration

san-mateo-streetsaver-main

Client: City of Santa Rosa

Challenge

The City of Santa Rosa wanted to integrate their pavement management system with their enterprise GIS and provide live-links between the two systems.

Solution

Farallon integrated MTC’s StreetSaver v.8 pavement management software with ESRI’s ArcSDE/ArcGIS software on an enterprise SQL Server database. In order to provide a high level of automation and integration, Farallon and the City incorporated the City’s existing street data into a linear network and defined a new data model, linking procedures, and database views to provide a live-link between PMS and GIS. In addition, Farallon provided the City with support for the setup of StreetSaver, as well as training and documentation.