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.


Review Article Be the first to review this article

Latest Blog Posts
Michelle Mata-ReyesAldec Design and Verification
by Michelle Mata-Reyes
ARM-based SoC Co-Emulation using Zynq Boards
Hardware Engineer, Board Design for Arista Networks at Santa Clara, California
Salesforce Technical Lead   East Coast  for EDA Careers at Cherry Hill, New Jersey
Sr. Application Engineer for Mentor Graphics at Fremont, California
Senior Account Managers… FORMAL VERIFICATION...VALLEY for EDA Careers at San Jose, California
Senior Software Architect Internet for EDA Careers at San Jose, California
Upcoming Events
FLEX 2020 and MSTC 2020 at DoubleTree by Hilton 2050 Gateway Place San Jose CA - Feb 24 - 27, 2020
DVCon U.S. 2020 at DoubleTree Hotel San Jose CA - Mar 2 - 5, 2020
OFC 2020 - The Optical Networking and Communication Conference & Exhibition at San Diego Convention Center San Diego CA - Mar 8 - 12, 2020
DATE '2020 at ALPEXPO Grenoble France - Mar 9 - 13, 2020
Verific: SystemVerilog & VHDL Parsers

© 2020 Internet Business Systems, Inc.
25 North 14th Steet, Suite 710, San Jose, CA 95112
+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