I am looking to find the most effect way to use SDE and ST_Geometry SQL commands.
Can anyone tell me how/what commands I might use to perform a spatial query in MS Sql Server 2008, to Select property parcels that are contained by or cross the boundary of a flood area layer?
I then have to export the result (containing, owner, and address details) to some format that can be used to do a mail out. I would also have to create a site specific map for each property affected. Showing the neighbourhood parcels, specific owners parcel, flood potential layer and roads.