I have several spatial layers created in QGIS that are held as spatial data in SQL Server 2008 R2. What I want to do is to find the centroid (OS Easting and Northing) of the polygon from the geometry. But I want to do this in a view that I have of the data. Each table I want to do this on, has a Geometry field. I've looked at examples of using ST.Centroid, but none of them seem to use a geometry field from a table.
Help on this will be invaluable.
Best Answer
In SQL Server 2008 R2, you should be able to use spatial function: STCentroid
If you have a geometry column (i.e. called geom) stored in the myTable, you can do the following:
To create a view: