Farallon Geographics Builds GIS mashup to Identify and Manage Critical Data for Bay Area Geological Hazard Abatement Districts

August 30, 2006 -- Geological Hazard Abatement Districts (GHADs) are charged with managing geological hazards within their district. There are several GHAD located in the San Francisco Bay Area. Each manages risk related to property damage from potential landslides, which is high given the hilly terrain and wet winters in the area. Over a 15 year period, the GHADs had received quarterly data, each with about 15,000 data points tracking water levels, angles of slopes that have been sliding, and homeowner reported cracks. Farallon Geographics was asked to analyze the large volume of data to identify potential at-risk properties and then present this information using a web-based interface that would enable the GHADs to proactively manage geological risks.

Farallon first migrated the 15 years of quarterly data, originally maintained in Microsoft Excel, to an Oracle Express database. This provided a free database solution with 4 GB storage - more than adequate for the GHAD datasets. Farallon then performed a statistical analysis on the data to determine which combinations of data correlated to risk factors and to flag those locations that warranted further analysis for potential landslides.

Farallon reviewed the options to display the data using a web-based interface. Traditional GIS tools can provide the functionality but are costly and are difficult to scale to handle large numbers of users. Google Earth was chosen because of its speed, scalability, intuitive and familiar user interface, and no cost. Farallon created business rules to determine critical geographical points in the database and then display these as markers on the Google Earth map interface. Incident locations that exceeded threshold levels for risk were indicated by different colored markers. A user could click on a marker to see the address, incident link and a historical chart of relevant water level information. Clicking the incident link opens a popup window with detailed information about that incident.

GHAD staff can now see critical information on a map and tie it into potential problem areas. This GIS mashup provides an intuitive and powerful decision support system with low cost, high speed, and easy scalability. To see images related to this project, visit http://www.fargeo.com/case_studies/images/ghad_mashup.jpg . Farallon Geographic’s latest podcast further discusses mashups and the GHAD project: http://www.fargeo.com/podcasts/

Farallon Geographics ( www.fargeo.com), based in San Francisco, is a leader in the planning, implementation, and integration of GIS systems and software to support mission critical business functions. As a formal business partner with major vendors in the GIS market, Farallon provides unique and objective strategic and technical implementation services for enterprise-scale GIS.
Featured Video
Jobs
Machine Learning Engineer 3D Geometry/ Multi-Modal for Autodesk at San Francisco, California
Senior Principal Software Engineer for Autodesk at San Francisco, California
Principal Engineer for Autodesk at San Francisco, California
Senior Principal Mechanical Engineer for General Dynamics Mission Systems at Canonsburg, Pennsylvania
Mechanical Manufacturing Engineering Manager for Google at Sunnyvale, California
Manufacturing Test Engineer for Google at Prague, Czechia, Czech Republic
Upcoming Events
Digital Twins 2024 at the Gaylord National Resort & Convention Center in, MD. National Harbor MD - Dec 9 - 11, 2024
Commercial UAV Expo 2025 at RAI Amsterdam Amsterdam Netherlands - Apr 8 - 11, 2025
Commercial UAV Expo 2025 at Amsterdam Netherlands - Apr 8 - 10, 2025
BI2025 - 13th Annual Building Innovation Conference at Ritz-Carlton Tysons Corner McLean VA - May 19 - 21, 2025



© 2024 Internet Business Systems, Inc.
670 Aberdeen Way, Milpitas, CA 95035
+1 (408) 882-6554 — Contact Us, or visit our other sites:
TechJobsCafe - Technical Jobs and Resumes EDACafe - Electronic Design Automation GISCafe - Geographical Information Services  MCADCafe - Mechanical Design and Engineering ShareCG - Share Computer Graphic (CG) Animation, 3D Art and 3D Models
  Privacy PolicyAdvertise