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