Case Studies on Utility System Data Modeling
City of Santa Rosa: Utilities Geodatabase Deployment and Integration
Challenge
The City of Santa Rosa needed to automate the process of populating the asset inventory in its Asset Management System based on information in the utility maps generated with AutoCAD.
Solution
Farallon developed a GIS data model in an ESRI geodatabase that is populated from AutoCAD and uploads it to the City's Hansen Asset Management Software.
Read more details...
Categories: GIS/IT Integration, Asset Management Systems, Geodatabase Design, Utility System Data Modeling
Fairfield Suisun Sewer District Water Utility Enterprise GIS and RDBMS
Challenge
Fairfield Suisun Sewer District (FSSD) needed to expand their existing GIS for utility pipeline management, to integrate with and be of use to other departments.
Solution
Farallon developed a business case for a complete enterprise GIS, including the development of technology, geodata, workflows, a web portal, and staffing plans. Implementation included a water utility data model, a populated geodatabase (using ArcSDE and ArcGIS), and specific GIS workflows designed to ensure that FSSD's network administrators and GIS staff were comfortable managing the enterprise GIS. A geospatial web portal integrated other District business units, consolidating specific GIS applications (such as property review and notification), metadata, workflows, and standards into a single, web-based environment, available to all staff. Read more details...
Categories: Web Applications, Notification, Property Review, Geodatabase Design, Utility System Data Modeling, 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