CodePlex: SQL Server Spatial Tools

Hi Folks,

I've just published a new project on CodePlex: SQL Server Spatial Tools.  The core idea is that instead of pushing up more samples showing how to extend our spatial functionality in text, we can put them in a more usable form.  Beyond just showing off some samples, though, we'd like to assemble useful code into a toolkit that provides some real functionality over what we bake into the server.

Here's what's in the package so far:

• ShiftGeometry: Takes a geometry instance and shifts if by a given X and Y amount.
• InterpolateBetweenGeom: Takes start and end geometry points and returns a new point that is a given distance from the start toward the end.
• InterpolateBetweenGeog: Takes start and end geography points and returns a new point that is a given distance from the start toward the end.
• LocateAlongGeom: Takes a geometry linestring and finds the point a given distance along it.
• LocateAlongGeog: Takes a geography linestring and finds the point a given distance along it.

So far we haven't pushed up an actual build, but you can get the source and put it together yourself.  We'll be working to clean this up over time.  Oh, and everything is published under the Microsoft Public License, so you can have fun playing with it all you like.

If you're interested in adding to the package, let us know---we're happy to have you.

Cheers,
-Isaac

Comments

• Anonymous
  August 01, 2008
  Very cool Isaac, LocateAlongGeog will be in my next demo for sure! Thanks, John.

• Anonymous
  August 02, 2008
  WPF Learning WPF with BabySmash - Manually Managing ClickOnce and some more Designer Goodness [Via:...

• Anonymous
  August 03, 2008
  The comment has been removed

• Anonymous
  August 04, 2008
  This is neat Isaac.  I'll update my spatial comparison article to include a link to these linear referencing and translate functions and more to come.