“Point-cell” type feature of which the size is based on a data table field - Bentley Map V8i-S3 & Bentley Geospatial 08.11.09.107

 

I want to create a feature of which the geometry type is
“Point-cell”.

The size of cell (scale) will be determine by a numeric value(field)
in the data table.

In the Symbology  dialog box the size can be controlled
by entering a numeric value for the following;

Cell XScale

Cell YScale

Cell ZScale

I would like these values to be determine by a value(field) in
the data table and these values might be unique for each feature placed.

Have you created such a feature before or know how this can
be done?

Regards,

Parents
  • Hi,

    In the Bentley map help file, there is what I found:

    In the "registering features" page go to #3 under "To Register Features" sub-section: docs.bentley.com/.../MicroStationMaphelp55.html

    "If any of the features are point features, there will be an option to define a column that can be used to store the angle of the feature as well as columns to store the X and Y scale value. The angle and scale of cells and text will be stored in the selected columns. The registration wizard automatically looks for columns named MS_XSCALE, MS_Y_SCALE and MS_ANGLE. If these columns are present in the data table then they will automatically be populated in the appropriate fields for the point feature. Enter the appropriate settings and click Next.

    X Scale and Y Scale are unit less values that simplify magnify (scale > 1.0) or shrink (0.0 < scale <1.0) or leave unchanged (scale = 1.0) the default dimensions of the element used to represent the point feature. 
    An X Scale of 2.0 would double the width of the feature; 0.5 would divide the width by two. The actual size of the feature depends upon the dimensions of cell used, or in the case of text, the size of the font and the number of characters in the text string. 

    Leave these columns blank if scale and angle are not required per feature. The values defined in the feature definition will be used when the features are queried from Oracle."

     

    I hope that helps.

    Best Regards,


    This is a test

  • Thanx for the information Sebastien.

    I am not familiar with registering features but will read up on it.

    The idea is to show possible Gas release point clouds in a plant.

    The clouds will be represented by spheres.

    The size of the sphere will be determined by the pressure of the gas and each type of gas will be represented by a colour.

    The sphere cell feature will be populated from a SQL table and columns in this table will determine the size, colour and position of each feature.

    Here is an illustration of what I have in mind.

  • Hello,

    My specific case apply on SQL Spatial Server, where you can stored metadata an geometries ... and that not seems to be your case. Unfortunately, Cell Scale cannot reach value from database. See following quote from Help file about Cell Symbology. It talked about a “ApllyScaleonEdit” option, but I am not sure it could be a solution in your case:

    "Cells are normally not scaled to the size defined in the feature definition whenever a property edit operation takes place (subject to any PBS rules). If the administrator would like to maintain the scale for the feature, then the ApplyScaleonEdit key should be defined for the feature. To add this key, right-click the Symbology node for the feature and select Add > Apply Scale on Edit. Leave the value checked, or on. In this way the scale of the feature will automatically be reapplied when editing the feature."

    Source: http://docs.bentley.com/en/Map/MicroStationMaphelp20.html

     

    Sorry I do not have any idea for now. Sorry about that.

    I hope someone else will propose any other solution.

     

    Regards,


    This is a test

  • If the data is stored in a spatial table and the feature is defined as a point feature, then the cell scale can be stored as a property. You define which property sets the xscale and the yscale of the cell when you register the feature from the spatial database.

    You then create a sphere cell in the cell library with a default radius set to 1. The scale in the spatial table will then scale this sphere cell according to the value stored in the database property for X and Y  scale (HINT : make the X and Y scale value the same)

    As for the color this also can be dependent upon a property. You need so set criteria (rules) and associate this to the color key in the symbology node for the feature definition.

    Make sure you set the "Override cell symbology" so the sphere will take on all the symbology (color, weight, level, etc...) values for the specified record in the spatial database.

    HTH

     

  • The colour & layer of the cell is no problem, it’s rather the variation of the scale for each cell placed which is base on a value in a column for each feature.

    Ok so I’ll need to read up more on registering features from the spatial database.

    Will keep you posted.

    Regards

Reply Children
No Data