I am trying to get over a hurdle that has left me puzzled. I am not with out a solution but I am trying to find a better way to do things.
All our data is stored in SQL Spatial 2008. I want the ability for people outside of the GIS to be able to add records that would end up in the GIS, but without having the ability to place it on a map. So I have a webpage that allows an insertion of record into SQL that inserts a new record without geometry. Geometry is required for a spatial layer.
So, do I tell it to insert @ 0,0 and manually place it later?
Do I setup up a join trigger that would update the data automatically after I give it a point?
Do I spend weeks and weeks pulling my hair out trying to figure out how to create a tool in AIMS that allows insertion of a spatial object?
My hope is someone has had a similar questions and can help me get to a reasonable solution. If nothing else just have a discussion on data procedures.