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.