Clients
Asset Management Systems Case Studies
Automated integration between San Mateo County’s GIS and asset management system
Challenge
San Mateo County catalogs infrastructure assets and creates preventative maintenance schedules using Hansen's asset management software. Spatial data from their GIS could automatically update corresponding location information in the asset management system. However many data fields were derived using GIS tools and then had to be entered manually.
Solution
Farallon implemented a complete automated solution that would keep the two databases in sync for all types of data. This resulted in more complete and accurate data as well as an expected labor cost savings of almost 15 times the investment.
Utah Department of Transportation (UDOT) Oracle Spatial Transportation Asset Management
Challenge
UDOT maintenance division had developed an Oracle database with tabular reports to track and analyze Utah's 5,900 miles of roads and 250,000+ transportation-related assets. UDOT wanted to integrate this with a web-based map interface to make spatial and business data more accessible and allow for field verification techniques.
Solution
Farallon worked with UDOT to create an enterprise-wide spatial database building on their existing Oracle infrastructure. This allowed UDOT to pilot a spatially enabled transportation asset management system, without having to deploy a new or separate GIS.
San Francisco street sweeping maps let residents avoid parking citations
Challenge
The complexity of street sweeping schedules in San Francisco makes it all too common for a resident to park in the wrong spot, at the wrong time, and receive a parking citation. A local entrepreneur sought a cartographic solution to this urban inconvenience.
Solution
Farallon developed neighborhood maps for public use that display street sweeping schedules by day and time. Because of the sheer volume of maps and frequently changing schedules, Farallon used ArcObjects and a geodatabase to automate the creation and easy update of these maps.
San Ramon Valley Fire Protection District Brings Enterprise GIS to the Fire Truck
Challenge
The San Ramon Valley Fire Protection District provides fire and ambulance service to a rapidly growing population from two cities. New land development meant that the District's GIS maps, CAD system, and records management system had to be integrated to allow fire fighters to quickly find homes in new subdivisions and confirm that nearby fire hydrants were connected to functional pressure zones.
Solution
Farallon helped the district implement a web-based system that links GIS with CAD and records management databases, providing dispatchers and fire fighters with a consolidated and near real-time view of dispatch, hydrant, and logistics (best access to remote rescue areas). The geodata can be forwarded directly to the responding units via the onboard mobile data computers in the vehicles.
Caltrans - Linear Referencing System (LRS) Data Model
Challenge
The California Department of Transportation, (Caltrans) is a large agency that supports numerous departments, business processes, projects and personnel. A subset of Caltrans tasked with the maintenance and analysis of road data, was working to develop map-based asset management and analysis. It needed a way to leverage existing transportation asset data and create a system with the flexibility to withstand future changes in technology and data collection.
Solution
Farallon developed a new data model based on Caltrans' existing linear referencing system (LRS). The new model allows for a multitude of highway system data (road conditions, terrain specifics, surrounding properties) that were measured in disparate methods to be used geospatially for location referencing needs.
San Mateo County Enterprise GIS
Challenge
The County of San Mateo had developed its GIS capabilities over time, resulting in many departmental GIS implementations that operated autonomously and independently. This organizational approach to GIS led to the duplication of important framework geospatial datasets resulting in undesirable data redundancy, data inconsistency, and unnecessary duplication of effort.
Solution
Farallon developed a GIS Utility and departmental governance structure, as well as an enterprise collaboration model developed through interviews with departments and County management. Once the Enterprise GIS was implemented, Farallon developed a GIS web-based portal as well as other web-based applications requiring GIS data, including notification and asset management.
Kinder Morgan Energy Partners Liquid Fuel Pipeline Control Center Emergency Response GIS
Challenge
Kinder Morgan Energy Partners (KMEP) is the nation's largest liquid fuel pipeline transmission company. Long sections of KMEP's most vital pipeline sections run along railroad rights-of-way. When a trail derails, KMEP must quickly determine whether the pipeline network has been compromised, where the nearest shut-off valves are, and how to get inspection and repair crews to the accident scene.
Solution
Farallon created an ArcSDE geodatabase in Oracle with a web interface that tracks over 3000 miles of railroad and pipeline GIS data, 30,000,000 street segments nation wide. It allows KMEP staff instant and intuitive access to the entire Pacific Region pipeline network faciltating the process of locating a leak and executing a response. With this integral tool KMEP can react within seconds, rather than hours.