Monday, June 28, 2010

Loading ANSS Earthquake Data Into SQL Server 2008 - Spatial Ed - Site Home - MSDN Blogs

Relevant to those in Canada that experienced the earthquake, here is how to generate spatial reports using a free feed from ANSS.

The Advanced National Seismic System (ANSS) maintains a comprehensive catalog of worldwide seismic events (typically earthquakes) which is a good source of spatial data for SQL Server 2008.  The ANSS Composite Catalog (formerly called the CNSS Earthquake Catalog) provides a search capability which allows the download of seismic events, from 1898 to present, using various search terms. In this post I will cover the following topics:

  • Download ANSS seismic data
  • Prepare the downloaded ANSS data
  • Create a database table for the ANSS data
  • Load the ANSS data
  • Add, update and index the spatial data column
  • Sample spatial queries on the ANSS data
  • Loading ANSS Earthquake Data Into SQL Server 2008 - Spatial Ed - Site Home - MSDN Blogs

    No comments: