Oct 22 2010
(With apologies to Bill Ham and ZZ Top)
Some progress, and apparently some shifting ice floes underfoot. Some blog posts say that the SQL Server Management Studio (SSMS) 2010 Express does not feature a “Spatial Results” tab for queries. In fact, at least this week, it does. It does seem like full-bore database development tools are withheld by Microsoft until the Visual Studio Premium 2010 tier, and yet I’m presently unable to locate an IntelliSense add-in for the OGC-compliant methods on Geometry instances.
Here they are, 43 OGC methods on geometry instances,
plus 16 OGC static geometry methods,
along with the typical MS-style augmentation
11 augmented MS-extended methods on geometry,
and 4 augmented MS-extended static geometry methods.
Another interesting topic is how to merge certain feature classes for use by both ArcSDE and SQL Spatial. In this regard, since ArcGIS Server 9.3 it appears that one can have ArcSDE store feature classes with SQL Server 2008 GEOMETRY data type. Here’s an ESRI documentation page on the subject.
Sometimes, it’s the simple stuff that one stumbles over (at least I do). Here’s some of the bootstrapping stuff for editing SQL in the Visual Studio 2010 environment. Plus, although I’m personally comfortable with programming languages like structured C, and have been trained in (but not worked professionally with) Objective C++ and Visual C++ (at 6.0), I’m not finding immediate transparency with C#; most of the Visual Studio Web Developer tutorial examples use Visual Basic.
Leave a Reply
You must be logged in to post a comment.