Case Studies on Training & Technology Transfer
San Mateo County ArcSDE/Oracle Spatial Implementation
Challenge
San Mateo County wanted to wanted to deploy the map production and geocoding tools available in ArcGIS on top of their existing Oracle Spatial and Intergraph Geomedia Enterprise GIS.
Solution
Farallon configured and performance-tuned Oracle to integrate with ArcSDE and geodata access via ESRI software. Farallon also provided County staff with training and useful tools such as scripts, tips, and common troubleshooting techniques. Read more details...
Categories: GIS/IT Integration, Planning & Training, Training & Technology Transfer
Town of Hillsborough Enterprise Geodatabase Development
Challenge
The Town of Hillsborough had devoted time and resources to initiating a GIS on a departmental desktop-level basis. To minimize data duplicities, increase data accessibility, and make data manageable by Town staff, they needed an enterprise GIS implementation.
Solution
Farallon devised a three-part solution that included building a RDBMS- based enterprise GIS, developing two web-based GIS applications (property review and notification) and training Town staff to manage their data and applications. Read more details...
Categories: Web Applications, Notification, Geodatabase Design, Planning & Training, Training & Technology Transfer
San Mateo County Department of Health - GIS, Epidemiology, Disease Control & Prevention
Challenge
San Mateo Disease Control & Prevention investigates infectious diseases in the County. This group of epidemiologists, community workers and health professionals needed to understand GIS tools in order to monitor, track and help prevent the spread of disease threats.
Solution
Farallon customized a two-day course on the fundamentals of GIS including hands-on software experience. Using West Nile Virus tracking as an example, Farallon taught staff how to synthesize their existing epidemiology data (i.e. patient addresses) with enterprise data (i.e. storm drains and address points) to perform a spatial and visual analysis. Read more details...
Categories: Planning & Training, Training & Technology Transfer
Bay Area Air Quality Management District ESRI-based Enterprise GIS
Challenge
The Bay Area Air Quality Management District assesses the health risks associated with exposure to high concentrations of toxic air contaminants and comes up with a strategies to reduce risk to residents. They needed an efficient means of analyzing large volumes of data and a way to visually explain these results to policymakers and the public.
Solution
Farallon developed and implemented an enterprise-class GIS that provides BAAQMD with a central data repository to store and share data across the organization as well as perform targeted and visual analyses. Read more details...
Categories: Geodatabase Design, Planning & Training, Training & Technology Transfer
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
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. Read more details...
Categories: Web Applications, GIS/IT Integration, Asset Management Systems, Geodatabase Design, GPS Field Data Collection, Planning & Training, 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
City of Walnut Creek - GIS and General Plan Mapping, Formatting, and Layout Support
Challenge
The City of Walnut Creek was on a tight deadline to update their General Plan and needed to generate a large number of maps from their GIS. They also wanted a solution and the necessary training to allow their non-technical staff to use the GIS as a tool for map production in future analyses.
Solution
Farallon assessed the existing GIS and provided production services for the required maps. Farallon helped create GIS templates, documentation, and workflow training so that the City staff could develop maps without depending upon GIS specialists. Read more details...
Categories: Planning & Training, GIS Needs Asssessment, Training & Technology Transfer
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
Web-based Seismic Hazards Mapping for the California Department of Conservation
Challenge
The California Division of Mines and Geology (DMG) captures and compiles statewide geologic, and geo-hazard data. They wanted a user-friendly method for cities and counties to access information about and plan for seismic hazard zones.
Solution
Farallon designed and implemented a web-based application, the Seismic Hazards Mapping Program that allows DMG users (county and local governments, consultants, and researchers) to view, manage, and download seismic data presented as maps, images and tabular geospatial information. Read more details...
Categories: Web Applications, Planning & Training, Training & Technology Transfer