creat database in Bentley Map Enterprise v8i (SELECT series3)

Hi, all I have a map including land plots, houses and roads. But I do not know where to start in order to generate data for its properties including their name and address of each parcel of land, to show it in databrows containing my data insert to it. Can you guide me to do this in Bentley Map?
thanks you very much !!!

Parents
  • It sounds like you have graphics in a drawing and no database. you want to add the attribute properties to the geometry in the drawing. This is one approach.

    • Decide what attributes you want to track for the features (land plots for example).
    • Decide if you want the geometry to be stored in the DB or not. If you do not want to store the geometry in the DB then a simple relational database engine is fine ( Access, MySQL, etc.). If you want the geometry to be stored ion the DB, then you are going to have to use Oracle or SQL Server.
    • Create the attribute tables.
    • Using the Geospatial Administrator ( there is a course on this called Bentley Map Administrator), setup the project. This WILL take a bit to do, give yourself some time to do this. Remember to create promote functionality for your features.
    • Start Map using the project.
    • Select the geometry for the land plots.
    • Promote to the land plot feature(s).
    • Edit attributes for each feature instance. There is a way in the promote process to populate the attributes that have the same value across all feature instances.

    I hope this helps.

    As others have expressed there are courses for this on the learn server. The one course mentioned above should give you most of what you need.

     

  • hi , Jerry Thank you for your interest in my questions. you say is true, that is the problem I encountered my map without database. I do not know how to add attributes to it like attributes of the database table in MapInfo. I want to create a database table as you want of me and I can enter information into it I can see them in Utilities
    -> Databrowser You can tell more about this section is not? I'm thank your help for me.
  • Open the Bentley Map V8i Geo_Example project from the Bentley Map program group in the Start menu. Once you see how the Features and attributes operate together in the MicroStation graphics environment, open that same project using the Geospatial Administrator to review the XML-based Schema, Features, Properties and Methods. You can do this before or after you import the MapInfo data as Jerry suggests.



  • Thanks Dan and Jerry. I have followed the way of Jerry and succeeded. So if I want to create additional columns in the DATA attribute to it in Brower must do like?
  • To add properties, open the XFM Schema with the Geospatial Administrator.  Then Browse to your Feature, right-click on the Properties item, and select Add > and the type of property you wish to include.

      

    And this is how it looks in the GSA:



  • Hi,

    Unknown said:
    So if I want to create additional columns in the DATA attribute to it in Brower must do like?

    A note which I think can help you to understand Bentley Map concepts: What you mentioned as "table" in your picture is not database table, so to think in terms "add a column to database" can leads to a confusion. The displayed grid is a kind of summary of data received from all elements representing the same feature. The data can come from different sources: DGN file itseld, external relation database or external spatial database.

    If you imported your data directly to DGN file as demonstrated in Jerry's tutorial, all data are in DGN file (which is typical XFM technology feature), but there is no database table inside DGN. The data are attached directly to elements in a proper structure, so to "add a column" would require to change this data structure at all element instances, which cannot be done by a user.

    If you choose a way through Geospatial Administrator, to add new property (column) to a particular feature is easier, because it can be done in GSA as described by Dan.

    With regards,

      Jan

Reply
  • Hi,

    Unknown said:
    So if I want to create additional columns in the DATA attribute to it in Brower must do like?

    A note which I think can help you to understand Bentley Map concepts: What you mentioned as "table" in your picture is not database table, so to think in terms "add a column to database" can leads to a confusion. The displayed grid is a kind of summary of data received from all elements representing the same feature. The data can come from different sources: DGN file itseld, external relation database or external spatial database.

    If you imported your data directly to DGN file as demonstrated in Jerry's tutorial, all data are in DGN file (which is typical XFM technology feature), but there is no database table inside DGN. The data are attached directly to elements in a proper structure, so to "add a column" would require to change this data structure at all element instances, which cannot be done by a user.

    If you choose a way through Geospatial Administrator, to add new property (column) to a particular feature is easier, because it can be done in GSA as described by Dan.

    With regards,

      Jan

Children