[Map SS4] MSSQL Spatial Feature creation

Question

I've got a simple schema as defined in Geospatial Administrator - one polygon feature. I have installed SQL Server 2012, and wish to either "convert" my feature such that I can "post" updates to the database, or "define" a second feature that will allow me to "post" any drawn graphics back to the database. I haven't figured out where/how to link the feature to a database table. Shouldn't creating a new feature also (somehow) create the corresponding table in the database to hold the feature's geometry/attribution? I am aware of "registering" a database table, but when that is attempted, all I get is "No object identifying property was discovered", so apparently there is something not quite as expected for my database table. I *think* my test table has been defined correctly (geometry data type and ID column as IDENTITY).

Thanks,

Bruce

Thanks, 
 Bruce

sebastien.cote · Accepted Answer

Hello Bruce,

From what I understand, I think you have take it the wrong way. You cannot create a feature in the database by creating it in your Bentley Geospatial Administrator schema and then try to post, it won't work. It works going thru the opposite. The feature must be created in your database first, and then, in Bentley Geospatial Administrator, register it.

To make sure it is crystal clear, you asked > "Shouldn't creating a new feature also (somehow) create the corresponding table in the database to hold the feature's geometry/attribution?" [Seb] The answer is no. As I said, it works on the opposite way.

Workflow is to create your feature in your database, create the connection within your Bentley Geospatial Administrator schema. and finally register the feature. Please, review from the Bentley Map Help Documentation : Bentley Geospatial Administrator > Defining Graphical Sources > Spatial Data Source Requirements > Registering Spatial Features

I would encourage you the confirm the requirments from what you can find in the Bentley Map Help Documentation : Working with Spatial Databases > Working with SQL Server Spatial.

Regards