CodePlex: SQL Server Spatial Tools

CodePlex: SQL Server Spatial Tools

  • Comments 4

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

  • Very cool Isaac, LocateAlongGeog will be in my next demo for sure!

    Thanks,

    John.

  • WPF Learning WPF with BabySmash - Manually Managing ClickOnce and some more Designer Goodness [Via:...

  • Nice one Isaac!

    Now if you could add a Douglas-Peucker line thinning algorithm that honours shared node topology.... ;-)

  • 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.

Page 1 of 1 (4 items)