AnsweredAssumed Answered

Looking for a way to pass a polygon geometry shape to a SQL stored procedure.

Question asked by frankjohnson on Nov 4, 2015
Latest reply on Nov 4, 2015 by rscheitlin

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.


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.


Thoughts? Has anyone done this before?


Any help would be greatly appreciated.


Frank Johnson