Clients
Case Studies
Nothing shows Farallon's capabilities or commitment to customer satisfaction better than real-life case studies of our projects.
City of Chula Vista uses dynamic segmentation to render StreetSaver information to the GIS
Challenge
The City of Chula Vista wanted the information in their ArcSDE GIS to be shared with a StreetSaver database.
Solution
Tools in ESRI's ArcGIS were used to develop dynamic segmentation procedures to render StreetSaver information to the GIS. The segmentation of the streets into paving sections is done dynamically using the StreetSaver database post mile data at the time the user requests the information so the two datasets remain in sync.
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.
City of Boston Redevelopment Authority: Web Based GIS Redevelopment Project Tracking Portal
Challenge
The Boston Redevelopment Authority manages the review process of City development projects. Over time, redevelopment related data had become spread across several independent databases making it difficult to integrate the data necessary to complete a formal redevelopment project review.
Solution
Farallon created a web application to integrate the City's permitting system with an enterprise databases using GIS . Fast and simple access to 2D & 3D maps, City GIS data, and project specific redevelopment information, was developed using web services to dynamically overlay GIS results onto Virtual Earth.
Integrating MDOT’s business data with its geographic data using Oracle Spatial
Challenge
The Michigan Department of Transportation (MDOT) is responsible for planning, designing, building and operating the state's transportation network. MDOT's existing LRS implementation was not geographically referenced . This limited their ability to automate data validation or perform real-time spatial analyses of their network.
Solution
Farallon developed a data model to support MDOT's transportation system workflows and integrated the data with Oracle Spatial. Farallon also developed dynamic segmentation procedures to link tabular data (e.g. traffic reports) to on-the-fly to visualization of road segments. MDOT can now access mapping and business data dynamically.
City of City of Menlo Park integrates ESRI GIS with StreetSaver PMS
Challenge
The City of Menlo Park wanted the their Enterprise GIS (ArcSDE/ArcGIS/SQL) data to be dynamically shared with a StreetSaver pavement management database with live links between the two.
Solution
Farallon integrated MTC's StreetSaver v.8 pavement management software with ESRI's ArcSDE/ArcGIS software on an enterprise SQL Server database and defined a new data model, linking procedures, and database views to provide a live-link between the PMS and GIS systems over 60 miles of streets.
City of Santa Rosa GIS/PMS integration
Challenge
The City of Santa Rosa wanted to integrate their pavement management system with their enterprise GIS and provide live-links between the two systems.
Solution
Farallon integrated MTC's StreetSaver v.8 pavement management software with ESRI's ArcSDE/ArcGIS software on an enterprise SQL Server database and defined a new data model, linking procedures, and database views to provide a live-link between the PMS and GIS systems over 542 miles of streets.
Town of Hillsborough Enterprise Geodatabase Development
Challenge
The Town of Hillsborough had devoted time and resources to initiating a GIS on a departmental desktop-level basis. To minimize data duplicities, increase data accessibility, and make data manageable by Town staff, they needed an enterprise GIS implementation.
Solution
Farallon devised a three-part solution that included building a RDBMS- based enterprise GIS, developing two web-based GIS applications (property review and notification) and training Town staff to manage their data and applications.
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.