Clients
Intergraph Case Studies
Voter record point data against a census block polygon layer
DNC National Election Precincts Dataset Development for 2008 Presidential Campaign
Challenge
Map the Vote, working with data from the Democratic National Committee (DNC) wanted to create a national election precinct GIS. But the costs and time required to produce the precincts layers using traditional GIS drawing methods were cost and time prohibitive.
Solution
Farallon developed automated geodatabase techniques and spatial analysis algorithms to process and validate millions of voter records. This enables organizations to cost-effectively microtarget voter turnout efforts for the 2008 Presidential campaign.
City of San Mateo Master Address Database
Challenge
Addresses are a key dataset used by the City of San Mateo to provide essential services. No single complete, accurate, and current address list existed within the City that could be used as the authoritative list of business and residential locations. This limited the ability for City departments to coordinate efforts and integrate information across business systems.
Solution
Farallon designed and deployed a Master Address Database (MAD) as a central authoritative service for all City departments. The MAD offers increased data availability, reduced errors and maintenance, elimination of duplicate data, and enhanced City services.
GIS PavePlan Application Helps San Mateo County Manage Pavement Conditions
Challenge
San Mateo County manages over $100 million of infrastructure assets such as roads and sewer infrastructure. Pulling together information from separate GIS, pavement management software and budgeting spreadsheets was time consuming. It could take up to three months for a decision, such as asphalt resurfacing, to be agreed upon by all departments.
Solution
Farallon Geographics developed the GIS PavePlan application which automates data interchange between their cost modeling application, GIS database, and pavement scenario manager.
San Mateo County ArcSDE/Oracle Spatial Implementation
Challenge
San Mateo County wanted to wanted to deploy the map production and geocoding tools available in ArcGIS on top of their existing Oracle Spatial and Intergraph Geomedia Enterprise GIS.
Solution
Farallon configured and performance-tuned Oracle to integrate with ArcSDE and geodata access via ESRI software. Farallon also provided County staff with training and useful tools such as scripts, tips, and common troubleshooting techniques.
GIS Integration with Pavement Management System Allows Town of Danville to Visualize Pavement Data
Challenge
The Town of Danville wanted to visualize their StreetSaver Online pavement management analyses using their Geomedia GIS to create maps that could show both detailed street maps and pavement condition and maintenance information.
Solution
Farallon developed dynamic segmentation procedures to render StreetSaver information to the Intergraph Geomedia GIS. The segmentation of the streets into paving sections is done dynamically using the StreetSaver database at the time the user requests the information so that the two datasets never get out of sync.
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.
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.
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.
San Ramon Valley Fire Protection District Brings Enterprise GIS to the Fire Truck
Challenge
The San Ramon Valley Fire Protection District provides fire and ambulance service to a rapidly growing population from two cities. New land development meant that the District's GIS maps, CAD system, and records management system had to be integrated to allow fire fighters to quickly find homes in new subdivisions and confirm that nearby fire hydrants were connected to functional pressure zones.
Solution
Farallon helped the district implement a web-based system that links GIS with CAD and records management databases, providing dispatchers and fire fighters with a consolidated and near real-time view of dispatch, hydrant, and logistics (best access to remote rescue areas). The geodata can be forwarded directly to the responding units via the onboard mobile data computers in the vehicles.
San Mateo County Enterprise GIS
Challenge
The County of San Mateo had developed its GIS capabilities over time, resulting in many departmental GIS implementations that operated autonomously and independently. This organizational approach to GIS led to the duplication of important framework geospatial datasets resulting in undesirable data redundancy, data inconsistency, and unnecessary duplication of effort.
Solution
Farallon developed a GIS Utility and departmental governance structure, as well as an enterprise collaboration model developed through interviews with departments and County management. Once the Enterprise GIS was implemented, Farallon developed a GIS web-based portal as well as other web-based applications requiring GIS data, including notification and asset management.