New Functions Added To The SQL Server Spatial Tools CodePlex Project

Two new functions have been added to the SQL Server Spatial Tools CodePlex Project: FilterArtifactsGeography FilterArtifactsGeometry These new functions, as the names imply, are designed to remove unwanted components from spatial objects.  For instance, consider the output from the Reduce() method on a Geography object which results in a GeometryCollection consisting of a MultiPolygon and…

1

FME Webinar: Practical Techniques for Loading Data into SQL Server

One of the most often asked questions about SQL Server Spatial is “How do I load data into the spatial types?”. Safe Software has long provided solutions for this dilemma with their excellent ETL tool, Feature Manipulation Engine (FME).  On December 14th, Safe will be presenting an FME Webinar entitled “Practical Techniques for Loading Data…

0

A Short Discussion On The ShortestLineTo() Method

In a recent post to the SQL Server Spatial Forum, the subject of finding the closest point from one geometry to another resurfaced. While this was a difficult problem with SQL Server 2008, the new “Denali” CTP has introduced a method, ShortestLineTo(), which provides a solution to this problem. Taking the geometries provided in the…

1

New Spatial Features in SQL Server Code-Named “Denali” CTP1

  We have just released a white paper, New Spatial Features in SQL Server Code-Named “Denali” Community Technology Preview 1, as your definitive guide to the spatial improvements in this release of SQL Server. Of course, you can’t take advantage of the new spatial features without the new server. You can now download the new…

7

Loading ANSS Earthquake Data Into SQL Server 2008

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…

2

Spatial Data Support Coming To SQL Azure

Last Wednesday (March 17th), Dave Robinson of the SQL Azure Team announced upcoming support for spatial data in SQL Azure.  You can view the announcement at the MIX Conference in the video of Dave’s presentation, Building Web Applications with Microsoft SQL Azure (go to 18:40 on the timeline for the start of the spatial data…

4