How do we map Bentley Geospatial Administrators features with oracle spatial?

The typical workflow is:

1. Create your feature attribute definitions, domains in Oracle Spatial.
2. Open the  GSA, create a Oracle Spatial Connection.
3. Register the features with Oracle spatial. ( This will pull in the Oracle spatial definitions)
4. Edit the symbology for each feature in the GCA.
5. Create the workspace.
6. Add the Placement metadata.
7. If you are using the command menu, then update the command menu.
8. Save and export the workspace.

From this point forward, all domain and feature attribute definition changes need to be done on the Oracle Spatial side, and then in the GCA, the feature resynched with Oralce Spatial by selecting the Oracle spatial Connection and re registering the data. This is because oracle spatial is now the owner of the non-graphiccal part of the feature definition.

HTH

Jerry

Hi Jerry

 And when registering the features how do I answer the identifier generator question?

 Doug

Sorry for the late response.

As for teh ideintifier generateor question, you are bing asked by the GSA to identify a sequence generateor for the primay key of the feature's attribute and spatial table. This is required to generate unique id's for Oracle Spatial to be able to create/track/retrieve unique records from these tables.

With that in mind, you either need to generate these through Oracle SQL statements, or whne the GSA registers these featuires, to create one. I personally prefer to create the sequence generator on the Oracle side, it gives me greater control of the creation process, and can be scripted for later reuse.

You can find a wealth of sources on line. All you need to do is Google for "Oracle Create Sequence".  There are many options in this command, using the simplist for now is sufficient.

For example

CREATE SEQUENCE "SEQ_MYSEQ_MYTABLE" INCREMENT BY 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

Of course replace SEQ_MYSEQ_MYTABLE with an appropiate name for your instance.

HTH

Jery

Hi jerry,

after registering the features, in domain list(Geospatial Project==AllUsers==Domains) ia m not getting data(LKP data) which has more than 6 columns.

Is GSA is restricted to only 6 columns?

if yes how can i handle data..

the below images shows the domain  6 and > 6  Columns

can any body tell me how to retrive data?

It does look as if we are only listing 6 columns when showing available domain lists from Oracle Spatial. I will let development and Product Management know about this and we will look into the situation.  

>can any body tell me how to retrive data?

Is your problem that you cannot get the domain lists to work properly?  Or are you having troubles when querying  Spatia data?  If this is in fact a domain list  issue, you might find the Bentley Map Help useful.  In particular look for the section 'Domain Lists' under 'Working with Oracle Spatial>Oracle Spatial for Bentley Map - Quick Reference' chapter.  This explains how to set up the PK-FK lookup in order to get this functionality working preoperly.  You will see that you really only need two columns in your domain lookup table, not 6 or more.  

 Please let me know if this is what you are trying to do, and whether the doc has proven to be helpful.

-Mark