Case Studies on GIS/IT Integration
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. Read more details...
Categories: GIS/IT Integration, Pavement Management, Asset Management Systems, Geodatabase Design, Network GIS, Planning & Training, GIS Needs Asssessment, Training & Technology Transfer
San Mateo County Assessor/County Clerk/Recorder Business Process Analysis
Challenge
San Mateo County's Clerk-Assessor-Recorder-Elections department (CARE) processes and records most of the information that is input into the County's system. Since most of the recorded information supports spatial processes, CARE wanted a way to improve the recording procedure and understand how it could be extended to support other County processes using a central Oracle database and the County's spatial data.
Solution
After a thorough needs assessment of the current County processes, Farallon created an implementation plan that when executed would improve the County's revenue collection timeframe and ability to forecast annual revenue streams. Read more details...
Categories: GIS/IT Integration, Planning & Training, GIS Needs Asssessment
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. Read more details...
Categories: GIS/IT Integration, Asset Management Systems, Geodatabase Design, Utility System Data Modeling, Planning & Training, Training & Technology Transfer
County of San Mateo Linear Referencing System (LSR) for PMS to GIS integration
Challenge
The County of San Mateo wanted their PMS database to be linked to their Intergraph-based GIS centerlines.
Solution
Farallon helped the County to develop an LRS and programmed their Oracle geodatabase to support a dynamic GIS/PMS link through linear referencing and dynamic segmentation. Read more details...
Categories: GIS/IT Integration, Pavement Management