Clients
Web Applications Case Studies
Enterprise Address Repository and Maintenance Solution for Walnut Creek Citywide Building Address Database
Challenge
The City of Walnut Creek maintained critical address data on a departmental basis in a variety of incompatible formats. They wanted to reduce errors and inconsistencies by deploying a single, authoritative, centralized database of building addresses.
Solution
The City engaged Farallon to design and deploy an integrated Enterprise Master Address Database /Repository, Address Management System and Address Maintenance System that would link every building address within the City to assessor parcels, street centerlines, and potentially to individual buildings.
Colliers International Bank Site Data Management Application
Challenge
Colliers International, a leading global real estate services firm, needed to enhance the way it managed site data collection for Citibank locations. Usng Excel spreadsheets to track bank branch locations data resulted in incomplete or inconsistent data, and made it difficult to search and compare information about specific locations or transaction comparables.
Solution
Farallon developed a web-based database and mapping application that would let Colliers evaluate and enter a new bank location simply by clicking on a map and entering information associated with the bank. Staff can also manage existing Citibank properties, enter and update information for potential bank locations, and track the location of competing banks.
Bay Area Air Quality Management District - Geospatial Components Integration With Mobile Field App
Challenge
The Bay Area Air Quality Management District is responsible for maintaining air quality standards within the nine San Francisco Bay Area counties. BAAQMD needed to develop and integrate geospatial functionality into backend applications for permitting, engineering, and enforcement used for daily operations. They also wanted to build and integrate a mobile application into their system to support inspectors in the field.
Solution
Farallon developed and integrated geospatial functionality into the District's customer facing permitting application and internal SharePoint portal that contained all of the District's spatially related data. Farallon also developed an Android-based mobile application and integrated it into the District's production system to support coordination between inspectors in the field and managers in the District's office.
Cal EMA Enterprise GIS and CAL-SABER Web Application
Challenge
The California Emergency Management Agency (Cal EMA) needed an Enterprise GIS integrated with it core IT and business workflows that would offer it in-house capability to quickly disseminate critical geospatial datasets and applications in support of its mission of statewide emergency mitigation, response, and recovery.
Solution
Farallon developed an Enterprise GIS and data model for the thousands of GIS layers that the Cal EMA warehouses, along with a web-based GIS viewer to visualize the location and extent of incident data such as wild fires, accidents or swine flu outbreaks. Farallon also developed a prototype Android-based mobile application for collection of real-time field data during an emergency training exercise.
Enterprise Addressing System for the City of San Francisco
Challenge
The City of San Francisco and its numerous departments managed hundreds of independent address databases with no common linkage. Most of these databases were not georeferenced.
Solution
Farallon and City IT staff developed and deployed an authoritative, centralized database of building addresses for use throughout City government. This Enterprise Addressing System was developed with Farallon's flexible, extensible and cost-effective framework and uses Open Source technologies.
Union Sanitary District Plant GIS
Challenge
Union Sanitary District wanted to develop a Plant GIS Rich Internet application for viewing wastewater treatment plant infrastructure and managing mission critical workflows. It needed to tightly integrate with 15 business systems including SharePoint, Hansen Asset Management System, Wastewater Asset Management database and ArcGIS Server.
Solution
Farallon designed designed, developed and deployed a web-based Plant GIS asset tracking application that monitors wastewater treatment plant infrastructure and manages mission critical workflows.
Kern County Community Services Finder
Challenge
The County of Kern needed a web mapping application to improve access to parcel and address-based information for its staff and citizens.
Solution
Farallon developed a property-based community services locator for the County to support its citizens’ ability to identify essential services. The web app has an intuitive, high-performance user interface providing smart address-based and map-based property searches.
Mobile Data Collection Application using Android
Challenge
A Bay Area city needed a comprehensive and accurate storm drain geodatabase and geometric network to support their stormwater infrastructure planning, operations, and maintenance. They wanted it efficient for field crew data collection of 12000+ storm drain features, and real-time trackable by office managers.
Solution
Farallon developed an Android-based workflow-driven mobile data collection application to streamline the process of data collection and synchronize with the City's central database in both network connected (3G or Wi-Fi) and disconnected environments. Managers in the office track real-time progress using a simple Google Earth interface.
City of Fairfield Property Review and Notification Application
Challenge
The City of Fairfield wanted to upgrade its slow, legacy property review and notification application.
Solution
Using Farallon’s flexible and cost effective framework, Farallon developed an extensible web-based property review and notification application utilizing the City’s existing ArcGIS Server technology along with Google Maps basemap data.
GIS Web Application to Identify and Manage Critical Geological Hazard Data
Challenge
Geological Hazard Abatement Districts (GHADs) are charged with managing geological hazards within their district. They needed an efficient, easy-to-use tool for managing hazard report / monitoring information and a way to quickly visualize this data.
Solution
Farallon developed a high performance web application using Farallon's flexible and cost effective framework. The application allows the GHADs to more effectively protect homeowners from geologic hazards occurring within their community by providing an intuitive and powerful decision support system with low cost, high speed, and easy scalability.
