Get Shape Content in SQL Server Query

5025
1
08-20-2014 10:48 AM
mpboyle
Occasional Contributor III

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!

0 Kudos
1 Reply
mpboyle
Occasional Contributor III

I believe I found the answer I was after...

select Shape.STArea() as 'Area'

from 'Parcel'

Just as it appears in ArcMap and ArcCatalog.