In working with circles or arc segments one needs to be able to do more than just calculate chordlengths, arclengths or arc2chord separations. For example,

This SQL Server TSQL function returns a (Normalized) bearing in Degrees between two non-geodetic (XY) coordinates.

In working with circles (and circular arcs) in spatial data one must be able to compute the length of an arc defined by an angle

In working with circles one must be able to compute the arc2chord separation, the length of an arc and the length of the chord subtended

Computing the arc to chord (Arc2Chord) separation between an arc on the circumference of a circle and the chord subtended by that arc is considered

The relevant standards covering spatial data types within databases provide functionality at many levels (and miss some that is required by pratitioners like myself) from

Recently I had need to convert a PL/SQL Oracle Spatial function I created years ago called FindCircle to SQL Server 2008 for use in another

There is often a need for all sorts of reasons, for the generation of spatial data within a database like SQL Server 2008. I have

Sometimes things are simple and prosaic rather than clever and complicated. Building solutions in TSQL requires one to build a prior collection of handy functions