Farallon GIS and Location Technology Case Studies
Nothing shows Farallon's capabilities or commitment to customer satisfaction better than real-life case studies of our projects. Whether in a local government office, an emergency dispatch center, a transportation network, or a marketing and sales department, Farallon solutions are enabling businesses and governments to make better and faster operational decisions.
To make it easier to review our case studies, you can search by Type of Industry, By Type of Service that Farallon provided, or by Keyword.
Most recently posted case studies and client solutions
City of City of Menlo Park integrates ESRI GIS with StreetSaver PMS
Challenge
The City of Menlo Park wanted the their Enterprise GIS (ArcSDE/ArcGIS/SQL) data to be dynamically shared with a StreetSaver pavement management database with live links between the two.
Solution
Farallon integrated MTC's StreetSaver v.8 pavement management software with ESRI's ArcSDE/ArcGIS software on an enterprise SQL Server database and defined a new data model, linking procedures, and database views to provide a live-link between the PMS and GIS systems over 60 miles of streets. Read more details...
Categories: GIS/IT Integration, Pavement Management
Bay Area Geological Hazard Abatement Districts use GIS Mashup to Identify and Manage Critical Data
Challenge
San Francisco Bay Area Geological Hazard Abatement Districts (GHADs) manage risk related to property damage from potential landslides. They needed to analyze 15 years of quarterly data tracking water levels, angles of slopes that have been sliding, and homeowner reported cracks, in order to identify potential at-risk properties and proactively manage landslide risks.
Solution
Farallon created business rules in Oracle Express to determine locations that exceeded threshold levels for risk and then displayed these as markers in Google Earth along with links to supporting details. The GIS mashup provides an intuitive and powerful decision support system with low cost, high speed, and easy scalability. Read more details...
Categories: Web Applications, Enterprise Mashups, Geodatabase Design
City of Santa Rosa GIS/PMS integration
Challenge
The City of Santa Rosa wanted to integrate their pavement management system with their enterprise GIS and provide live-links between the two systems.
Solution
Farallon integrated MTC's StreetSaver v.8 pavement management software with ESRI's ArcSDE/ArcGIS software on an enterprise SQL Server database and defined a new data model, linking procedures, and database views to provide a live-link between the PMS and GIS systems over 542 miles of streets. Read more details...
Categories: GIS/IT Integration, Pavement Management
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
City of San Mateo Google Earth integration with OGC compliant data
Challenge
The City of San Mateo uses a suite of GIS applications for staff to access geospatial data. The City wanted to provide more intuitive access to its GIS data and make it accessible to the public using the Google Earth interface. However, the back end GIS was not able to deliver geospatial data directly to Google Earth.
Solution
Farallon built a web service interface using .NET to translate data from the City's Intergraph GeoMedia WebMap server to a format usable by Google Earth. This allows a Google Earth user to view selected City GIS data such as high quality aerial imagery and point, linear, & polygonal features - all in real-time. Read more details...
Categories: Web Applications, Enterprise Mashups, Property Review, Geodatabase Design, Open Standards Solutions
California ISO GIS and Transmission Information Display System
Challenge
The California ISO manages the transmission of electricity through the State's extensive network of high voltage lines. To manage the electrical grid in response to factors such as wild land fires and extreme weather, the ISO needed a complete and positionally accurate accurate representation of the grid from all of the State's primary electricity generators and transmitters.
Solution
Farallon developed a Unified GIS data model that merged the State's major power generators' GIS data into a single, consistent, validated, and audited database. It offers a broad array of online and offline visualization and mapping capabilities and can easily integrate future external databases. Read more details...
Categories: Web Applications, GIS/IT Integration, Geodatabase Design, Network GIS
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
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. Read more details...
Categories: GIS/IT Integration, Asset Management Systems
MTC Streetsaver PMS-GIS scalable web application
Challenge
Sonoma County had worked with Farallon to integrate their GIS with MTC StreetSaver pavement management system (PMS). MTC wanted to make this integrated GIS-PMS solution more widely accessible and asked Farallon to create a web-based implementation that would be used by Sonoma County and then extended to other Bay Area jurisdictions.
Solution
Farallon designed and deployed a custom web-based application which displays Streetsaver tabular reports along with a map highlighting corresponding street sections. The web-services XML based application will readily scale to accommodate other Bay Area counties and completely new applications. Read more details...
Categories: Web Applications, GIS/IT Integration, Pavement Management