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
CAD Engineer for Nvidia at Santa Clara, California
Design Verification Engineer for Blockwork IT at Milpitas, California
Senior Firmware Architect - Server Manageability for Nvidia at Santa Clara, California
Sr. Silicon Design Engineer for AMD at Santa Clara, California
Senior Platform Software Engineer, AI Server - GPU for Nvidia at Santa Clara, California
GPU Design Verification Engineer for AMD at Santa Clara, California
Upcoming Events
Phil Kaufman Award Ceremony and Banquet to be held November 6 at Hayes Mansion at Hayes Mansion 200 Edenvale Ave San Jose CA - Nov 6, 2024
SEMICON Europa 2024 at Messe München München Germany - Nov 12 - 15, 2024
DVCon Europe 2023 at Holiday Inn Munich – City Centre Munich Germany - Nov 14 - 15, 2024
SEMI MEMS & Imaging Sensors Summit, at International Conference Center Munich Germany - Nov 14, 2024



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