Clients
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.
TKT STPR iPhone & Android App helps avoid parking tickets in San Francisco
Challenge
General Eyeballs was in process of developing an iPhone & Android application to help drivers avoid parking tickets in San Francisco as well as other major urban centers. No central database of citywide parking regulations and restrictions in San Francisco existed so one had to be created that could intelligently integrate sophisticated spatial and non-spatial data.
Solution
Farallon Geographics integrated a variety of data sources from the City of San Francisco including point datasets for parking meter locations and non-spatial (i.e. tabular) datasets such as time restrictions and street cleaning schedules using sophisticated geospatial processing techniques to correctly position all the data on the right street segment and on the correct side of the street.
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.
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.
