Clients
GIS/IT Integration 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.
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.
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.
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.
Farallon builds Emergency Operations Center (EOC) incident management application for MTC
Challenge
In order to effectively manage unpredictable events in real time, MTC's Emergency Operations Center needed an incident management application with a clean, intuitive interface optimized to streamline the collection of incident data, as well as the display of incident locations relative to other critical data sets.
Solution
Farallon created a robust web-based incident management application that enables users to register and flag emergencies on a map, report routine incidents such as service delays, add emergency routing and response information and generate summary reports. EOC can now effectively manage and assess large volumes of continuously generated data in real time, and to distribute this data to all relevant personnel.
Enterprise GIS for Town of Woodside with StreetSaver PMS integration
Challenge
The Town of Woodside needed an enterprise GIS. They also wanted to integrate the GIS with MTC’s StreetSaver Online Pavement Management System and a CRW Permit Management System.
Solution
Farallon Geographics built and deployed an enterprise GIS for the Town of Woodside, CA, and linked the GIS to the Town’s MTC StreetSaver Pavement Management System (PMS) as well as to its CRW Permit Management System. Town staff could quickly map StreetSaver information into the GIS to perform spatial analysis or use a map as an interface for managing property assets and notifications.
Contra Costa Economic Development website integrates spatially-aware database and MS Virtual Earth
Challenge
To promote economic development, Contra Costa County Community Development Department wanted a website to help real estate professionals and business owners search for properties available for development or new business locations.
Solution
Farallon developed an easy-to-use "GIS Site Locator" website that lets users enter parameters such as price range and square footage, then view matching properties on a map in MS Virtual Earth. Click on a property to display additional information, including photographs, driving directions and current traffic conditions. An RSS feed automatically keeps users updated of relevant new properties.
MarineMap web application for identifying marine life protection areas
Challenge
The Marine Life Protection Act directs the State of California to design and manage a network of multi-use marine protected ecosystems.The state needed a web-based decision support system for designing marine protected areas and communicating proposed designs.
Solution
Farallon, working with the Marine Science Institute at UCSB, developed "MarineMap", a Web 2.0 online mapping application that enables members of scientific community and general public to participate in the selection of marine environments that should be designated for conservation, recreational, and commercial uses.
City of Santa Rosa: Utilities Geodatabase Deployment and Integration
Challenge
The City of Santa Rosa needed to automate the process of populating the asset inventory in its Asset Management System based on information in the utility maps generated with AutoCAD.
Solution
Farallon developed a GIS data model in an ESRI geodatabase that is populated from AutoCAD and uploads it to the City's Hansen Asset Management Software.