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

2216
1
11-04-2015 03:34 PM
FrankJohnson
New Contributor II

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

0 Kudos
1 Reply
RobertScheitlin__GISP
MVP Esteemed Contributor

Frank,

   What format is the stored procedure looking for the polygon geometry to be passed in?

0 Kudos