topic Get Shape Content in SQL Server Query in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/get-shape-content-in-sql-server-query/m-p/187229#M7475 <HTML><HEAD></HEAD><BODY><P>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...?</P><P></P><P>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.&nbsp; Is this possible?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 20 Aug 2014 17:48:02 GMT mpboyle 2014-08-20T17:48:02Z Get Shape Content in SQL Server Query https://community.esri.com/t5/arcgis-enterprise-questions/get-shape-content-in-sql-server-query/m-p/187229#M7475 <HTML><HEAD></HEAD><BODY><P>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...?</P><P></P><P>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.&nbsp; Is this possible?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 20 Aug 2014 17:48:02 GMT https://community.esri.com/t5/arcgis-enterprise-questions/get-shape-content-in-sql-server-query/m-p/187229#M7475 mpboyle 2014-08-20T17:48:02Z Re: Get Shape Content in SQL Server Query https://community.esri.com/t5/arcgis-enterprise-questions/get-shape-content-in-sql-server-query/m-p/187230#M7476 <HTML><HEAD></HEAD><BODY><P>I believe I found the answer I was after...</P><P></P><P><CODE>select Shape.STArea() as 'Area'</CODE></P><P><CODE>from 'Parcel'</CODE></P><P></P><P>Just as it appears in ArcMap and ArcCatalog.</P></BODY></HTML> Wed, 20 Aug 2014 18:04:03 GMT https://community.esri.com/t5/arcgis-enterprise-questions/get-shape-content-in-sql-server-query/m-p/187230#M7476 mpboyle 2014-08-20T18:04:03Z