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.
Thank in advance.
You can just try making the geometry column allow NULL values.
Make a view off of this table where [geometry_column IS NOT NULL]. Make your layer off of this view
Have your webpage insert into the underlying table with the value for geometry_column omitted or set to NULL
This way, user-added records are omitted from the rendered layer because they are filtered out by the view that MapGuide will be reading from.
- Jackie
From there, how would we add the geometry to the data generated?
I am not sure how AutoCAD Map will handle records without geometry. We do all our GIS work in AutoCAD Map with an FDO connection to SQL.
Do you see my problem? How do I enable users to add new records that will need the geometry updated at a later date?