Does anyone know if it's possible to extract the shape details of a polygon (area, length) within a SQL Server query/view using a feature class with SQL geometry as the shape storage type...?
Ex: I have a parcel feature class and I want to create a SQL Server (2008 R2) query/view within SQL Server that displays all the areas of the polygons...similar to the Shape.STArea() field within ArcMap/ArcCatalog. Is this possible?
Thanks in advance!
I believe I found the answer I was after...
select Shape.STArea() as 'Area'
from 'Parcel'
Just as it appears in ArcMap and ArcCatalog.