City of Hayward integrates ESRI GIS with StreetSaver Online PMS

City of Hayward integrates ESRI GIS with StreetSaver Online PMS

Client: City of Hayward

Challenge

The City of Hayward uses MTC’s StreetSaver Online Pavement Management System (PMS) application to track and analyze the condition of the County road network and to define and adjust maintenance treatments and costs.

Engineering technicians enter information about specific stretches of roads into StreetSaver Online, allowing the software to calculate relevant measures of the street’s pavement condition. These calculations are used to assess the quality of the City’s streets and to allocate pavement maintenance budgets.

While StreetSaver is a powerful pavement management tool, its output is limited to forms and tabular reports. City Engineers recognized that presenting the results of their analyses on maps would be a much better way to visualize results, allowing both managers and technicians to see where maintenance efficiencies might be gained. Unfortunately, StreetSaver and the City’s ESRI Geographic Information System (GIS) do not inherently link and they contain different types of data.

To display road condition information, City managers printed out hard copy maps from the GIS and then manually highlighted problem areas that were identified based upon StreetSaver database printouts.

Both MTC and the City realized that linking and dynamically integrating the GIS and StreetSaver would be necessary to create maps that could show both detailed street maps and pavement condition and maintenance information.

Solution

Farallon Geographics retrieved City pavement data from StreetSaver Online as a Microsoft Access database. Through data modeling and testing, dynamic views were created that allowed the information in the GIS to be shared with the StreetSaver database. Tools in ESRI’s ArcGIS were used to develop dynamic segmentation procedures to render StreetSaver information to the GIS. The segmentation of the streets into paving sections is done dynamically using the Streetsaver database at the time the user requests the information so that the two datasets never get out of sync.

Farallon trained City staff on how to download their StreetSaver data and reports as Microsoft Access databases and render their data over the dynamically segmented street network in ESRI ArcGIS.  Using Farallon’s integrated GIS and PMS, City staff could quickly map StreetSaver information into the GIS and perform spatial analysis, allowing them to quickly create maps showing the extent of distressed streets.

Screenshots & Videos

City of Hayward pavement condition data rendered over their dynamically segmented street network gives City engineers an easy way to visualize data for planning road maintenance.

City of Hayward pavement condition data rendered over their dynamically segmented street network gives City engineers an easy way to visualize data for planning road maintenance.