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
26 comments:
Post a Comment