I see from this post that I can tweak RIA Services to transmit Sql Server spatial types. What I'd like to do is edit these spatial types. Does anyone know of any tools that would run in Silverlight that would support this?

4 Answers
4

By default, ArcSDE geodatabases in SQL
Server use the ArcSDE compressed
binary type, so if you want to use the
Microsoft geometry or geography types
for storage, you must either (1)
change the GEOMETRY_STORAGE parameter
under the DEFAULTS configuration
keyword in the SDE_dbtune table to
GEOMETRY or GEOGRAPHY or (2) specify a
configuration keyword that designates
a GEOMETRY_STORAGE parameter of
GEOMETRY or GEOGRAPHY when creating
feature classes.

Using the Silverlight API editing that Brad suggested will edit the SQL Spatial Types if the GEOMETRY_STORAGE parameter is set to not use the ArcSDE compressed binary type. This is probably the best option if you are not using versioned data and you want to make your edits directly on the map, as opposed to editing the string representation of the geometry.

All I have for this task is SQL Server 2008. I don't have AGS or arcsde. I want to leverage RIA Services.
–
Kirk KuykendallNov 29 '10 at 19:48

I'm looking through the blog post on GISBelowSeaLevel.net. It looks like he's using the ToWpfGeometry() method to render the geometry as a string in the GridView. Could you reverse that function to take in a Silverlight geometry and return a SQLGeometry?
–
Seth P.Nov 29 '10 at 20:07

Yes, I hadn't thought about that. So I guess if there is a toolset that lets me edit wpf geometries I could adapt that. Do you know of one? (e.g. Something that add/moves vertices from polygons).
–
Kirk KuykendallNov 29 '10 at 20:18

Could you just use the .NET SqlGeometry / SqlGeography from the
Microsoft.SqlServer.Types
namespace to roll your own editing?

There are some extras in the SQL Server Spatial Tools that may add some extra functionality. These types can both be used from within SQL Server or directly through the CLR, so I can't see why you wouldn't be able to use them in a Silverlight application (although I have not tried).