Case Studies on GIS Needs Asssessment
Moulton Niguel Water District Strategic Plan
Challenge
Moulton Niguel Water District needed a plan for creating an integrated enterprise GIS to simplify office functions related to operating its water, recycled water and wastewater services.
Solution
Farallon's GIS Strategic Plan provides the District with comprehensive and flexible enterprise GIS architecture, governance structure, data development and maintenance plan, staff training plan, and overall budget forecast for implementation of the system. The plan details the return on investment and specific deployment steps necessary. Read more details...
Categories: Planning & Training, GIS Needs Asssessment
Kern County Master Address Database Needs Assessment
Challenge
Kern County had no single complete, accurate, and current address list that could be used as the authoritative list of business and residential locations for providing essential services. This limited the ability for Count departments to coordinate efforts and integrate information across business systems.
Solution
Farallon Geographics completed a Master Address Database needs assessment and budget plan for a single, centralized address source or MAD to solve the problem of duplicated and error-prone addresses. Read more details...
Categories: GIS/IT Integration, Master Address Database, Planning & Training, GIS Needs Asssessment
Getty Conservation Institute Web-Based GIS for Managing Jordanian Antiquities
Challenge
The Getty Conservation Institute working with the World Monuments Fund and the Jordanian Department of Antiquities wanted to develop a new national GIS to assist in inventorying, monitoring, and managing the thousands of archaeological sites in Jordan
Solution
Farallon is developing a Web-based, bilingual (Arabic-English) system that will be used by inspectors, archaeologists, scholars, and government planners involved in cultural heritage management and research. The scalable solution using open source software, will subsequently be adapted for use in Iraq and possibly other countries in the region. Read more details...
Categories: Web Applications, GIS/IT Integration, Asset Management Systems, Geodatabase Design, Open Standards Solutions, Planning & Training, GIS Needs Asssessment
Caltrans PEAR-STEVE Systems Evaluation
Challenge
The California Department of Transportation, Division of Environmental Analysis required a comprehensive system requirements evaluation for two projects: the Preliminary Environmental Analysis Report (PEAR) tool and the Standard Tracking and Exchange Vehicle for Environmental System (STEVE) project.
Solution
Farallon performed a comprehensive system requirements evaluation of the PEAR-Tool and STEVE projects and prepared a detailed System Requirements Specification report that documents the programs' functional and non-functional system requirements, use studies, interview data, and the perceived limitations of the program. Read more details...
Categories: Planning & Training, GIS Needs Asssessment
Integrating MDOT’s business data with its geographic data using Oracle Spatial
Challenge
The Michigan Department of Transportation (MDOT) is responsible for planning, designing, building and operating the state's transportation network. MDOT's existing LRS implementation was not geographically referenced . This limited their ability to automate data validation or perform real-time spatial analyses of their network.
Solution
Farallon developed a data model to support MDOT's transportation system workflows and integrated the data with Oracle Spatial. Farallon also developed dynamic segmentation procedures to link tabular data (e.g. traffic reports) to on-the-fly to visualization of road segments. MDOT can now access mapping and business data dynamically. Read more details...
Categories: Geodatabase Design, Transportation & Linear Networks, Planning & Training, GIS Needs Asssessment
MTC SAFE’s Bay Area Freeway Service Patrol fleet management evaluation
Challenge
MTC SAFE's Freeway Service Patrol Program uses an Automatic Vehicle Locator (AVL) system that allows the California Highway Patrol to verify that tow service trucks are at their designated locations. The FSP needed a comprehensive diagnosis of their existing telecommunications network, especially the AVL system.
Solution
Farallon examined the current software, provided diagnosis, made recommendations for technical and logistical improvements, and to develop and implement a fleet management program, as well as integrate with external incident management systems. Read more details...
Categories: Geodatabase Design, GPS Field Data Collection, Planning & Training, GIS Needs Asssessment
ISO Innovative Analytics risk management geoprocessing to develop a nationwide set of risk factors using Oracle Spatial
Challenge
ISO Innovative Analytics (ISO), a risk management insurance company, wanted to analyze massive amounts of unstructured historical data (both spatial and non-spatial ) in order to develop a flexible, customized and configurable nationwide set of potential risk factors. This would be used to improve the way insurance companies currently rate auto insurance policies.
Solution
Farallon developed a series of pre-processing services and custom data structures for the intensive geoprocessing using Oracle Spatial 10g. Tens of millions of individual policy locations were combined with historical claims records to determine predictive correlations between potential risk factors and location of policy holders. Read more details...
Categories: Spatial Data Processing, Risk Management, Planning & Training, GIS Needs Asssessment, Training & Technology Transfer
Pacific Gas and Electric (PG&E) Oracle Spatial Technical Support
Challenge
PG&E needed to develop robust GIS applications and tools for identifying and analyzing its power pole transmission line data. They also wanted training for their internal staff in how to develop custom GIS applications while still maintaining data validation and business rules.
Solution
Farallon worked with the PG&E team using Oracle Spatial 9i with PL/SQL database programming to develop several custom applications, including a Java JSP-based map viewer for analyzing transmission line data. Technology transfer and training was an integral aspect of the project. Read more details...
Categories: Geodatabase Design, Network GIS, Planning & Training, GIS Needs Asssessment, Training & Technology Transfer
Parsons-UXB Joint Venture on Kaho’olawe Island Reserve Demilitarization GIS
Challenge
Farallon worked with Parsons-UXB to develop an online mapping system that managed the cleanup of unexploded ordnance (UXO) on the small Hawaiian island of Kaho'olawe.
Solution
Using a web interface, users who click on a grid square get a summary of information at a glance, while those who click on a piece of UXO get information and photographs about that item including GPS coordinates and images depicting everything from vegetation to the destruction date, as well as proximity to historically signficant Hawaiian sites and artifacts. Read more details...
Categories: Web Applications, Geodatabase Design, Planning & Training, GIS Needs Asssessment
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