Clients
PostGIS 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.
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.
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.
Town of Danville Property Review Application
Challenge
The Town of Danville's 10-yr old GIS used a proprietary design and data structure. Existing property review and property notification applications built on this GIS were not scalable and could not be integrated with modern mapping services or other Town data systems such as permitting and document management.
Solution
Farallon built a new web-based property review application to query and display property ownership, taxation, and jurisdiction information on a map to allow staff the ability to quickly and easily access property data.
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.
Getty Conservation Institute Web-Based GIS for Managing Jordanian Antiquities
Challenge
The Getty Conservation Institute working with the World Monuments Fund and the Jordanian Department of Antiquities wanted to develop a new national GIS to assist in inventorying, monitoring, and managing the thousands of archaeological sites in Jordan
Solution
Farallon is developing a Web-based, bilingual (Arabic-English) system that will be used by inspectors, archaeologists, scholars, and government planners involved in cultural heritage management and research. The scalable solution using open source software, will subsequently be adapted for use in Iraq and possibly other countries in the region.