topic Looking for a way to pass a polygon geometry shape to a SQL stored procedure. in ArcGIS Web AppBuilder Questions https://community.esri.com/t5/arcgis-web-appbuilder-questions/looking-for-a-way-to-pass-a-polygon-geometry-shape/m-p/231174#M6240 <HTML><HEAD></HEAD><BODY><P>I have a stored procedure, that will retrieve a list of shape objects based on the polygon coordinated passed into it. I want to use a Widget, and allow the user to draw a point with a defined buffer, that is returned as a polygon. Or, I am cool with letting the user draw a a polygon circle shape and then pull the geometry from the shape they draw and pass that to the stored procedures as well.</P><P></P><P>The procedure would then run 3 separate processes to pull, line, point, and polygon objects from a set of tables in my database to return a comprehensive list of objects contained, touching, intersecting, or overlayed by the polygon. </P><P></P><P>Thoughts? Has anyone done this before?</P><P></P><P>Any help would be greatly appreciated.</P><P></P><P>Frank Johnson </P></BODY></HTML> Wed, 04 Nov 2015 23:34:03 GMT FrankJohnson 2015-11-04T23:34:03Z Looking for a way to pass a polygon geometry shape to a SQL stored procedure. https://community.esri.com/t5/arcgis-web-appbuilder-questions/looking-for-a-way-to-pass-a-polygon-geometry-shape/m-p/231174#M6240 <HTML><HEAD></HEAD><BODY><P>I have a stored procedure, that will retrieve a list of shape objects based on the polygon coordinated passed into it. I want to use a Widget, and allow the user to draw a point with a defined buffer, that is returned as a polygon. Or, I am cool with letting the user draw a a polygon circle shape and then pull the geometry from the shape they draw and pass that to the stored procedures as well.</P><P></P><P>The procedure would then run 3 separate processes to pull, line, point, and polygon objects from a set of tables in my database to return a comprehensive list of objects contained, touching, intersecting, or overlayed by the polygon. </P><P></P><P>Thoughts? Has anyone done this before?</P><P></P><P>Any help would be greatly appreciated.</P><P></P><P>Frank Johnson </P></BODY></HTML> Wed, 04 Nov 2015 23:34:03 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/looking-for-a-way-to-pass-a-polygon-geometry-shape/m-p/231174#M6240 FrankJohnson 2015-11-04T23:34:03Z Re: Looking for a way to pass a polygon geometry shape to a SQL stored procedure. https://community.esri.com/t5/arcgis-web-appbuilder-questions/looking-for-a-way-to-pass-a-polygon-geometry-shape/m-p/231175#M6241 <HTML><HEAD></HEAD><BODY><P>Frank,</P><P></P><P>&nbsp;&nbsp; What format is the stored procedure looking for the polygon geometry to be passed in?</P></BODY></HTML> Thu, 05 Nov 2015 00:05:35 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/looking-for-a-way-to-pass-a-polygon-geometry-shape/m-p/231175#M6241 RobertScheitlin__GISP 2015-11-05T00:05:35Z