## Top 5 Recent Articles

### COGO: TSQL Function For Creating a Point from Point, Bearing and Distance

This (coordinate geometry – COGO) TSQL function creates a point geometry from a whole-circle bearing and distance.

### COGO: Compute number of vertices required to stroke circle or circular arc

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,

### COGO: TSQL Function to Calculate the Bearing Between Two Points

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

### COGO: Compute arc length subtended by angle centre of circle

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

### COGO: Compute chord length of segment of a circle (arc)

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

### COGO: Computing Arc To Chord (Arc2Chord) Separation

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

### COGO: Creating a stroked polygon from a circle’s centre x,y and radius

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

### COGO: Finding centre and radius of a curve defined by three points: FindCircle function

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

### Generating random point data for SQL Server 2008 Spatial

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

### New Presentation on Active (Searchable) Spatial Metadata for SQL Server 2008 Spatial and FreeText

I gave a presentation on some work I did last year for a customer on providing a sophisticated spatial/textual search capability against over 700 tables