Create a table or offset report

Hello,

I am currently useing MicrostationConnect version 10.14.00.109. The dgn file that I created has 3  lines  one on the lt, center line and one on the right .with different offsets.

What I would like is to create a table of all these different offsets or a report by clicking measure distance command picking the two lines centerline and then the left and doing the same thing on the right.

As a example 

Location 1 10.6' lt of centerline 78.4' right of centerline

Location 2 10.622.3' lt of centerline 34' right of centerline

Appreciate some step by step how to crate it.

Thanks

  • The dgn file that I created has 3  lines  one on the lt, center line and one on the right .with different offsets

    I don't understand how a line can have an offset.  What is offset from what?  A screenshot or, better, a DGN example, would clarify your question.

     
    Regards, Jon Summers
    LA Solutions

  • I don't know why you don't understand it is simple. You have 3 lines one the left one on the right and one in the middle with the offset distance distance at both locations. Offset distance is using copy parallel command with the distance you type in.

    MicroStation V8i (SELECT series  3) - Version 08.11.09.578

    Microstation Connect 10.14.00.109

  • I don't know why you don't understand

    Because I am simple?

    You have a set of three parallel straight lines.  Is that it?  Or do you anticipate having many more sets of parallel lines that you want to measure?

    with the offset distance distance at both locations

    You want to measure the perpendicular distance between one line and two other lines.

    The result is two distance measurements, which you term 'offsets'.

    What I would like is to create a table of all these different offsets
    • How should the table appear? 
    • Should there be one table row for each pair of measurements?
    • Once you have created a table, how do you know where the data in each row orginates? 
    • Are you labelling each line in some way?

     
    Regards, Jon Summers
    LA Solutions

  • Hello,

    You sure like to make things complicated.

    You have a set of three parallel straight lines.  Is that it?  Or do you anticipate having many more sets of parallel lines that you want to measure?

    Yes, if you have looked in my example I show to but end results will have 23 locations
    with the offset distance distance at both locations

    You want to measure the perpendicular distance between one line and two other lines.

    I want to measure the distance on the lt. and right of the centerline.

    The result is two distance measurements, which you term 'offsets'.

    Yes 

    What I would like is to create a table of all these different offsets
    • How should the table appear?
    • The table should appear on the dgn drawing
    • Should there be one table row for each pair of measurements?
    • No one table for all 23 locations
    • Once you have created a table, how do you know where the data in each row orginates?
    • once I get the measurements by clicking on the centerline and the one on the left it will give me a distnce I dont know if microstation connect can some get that number and place it in the table automatically or maybe get a printout of all the lt. and right offsets. 
    • Are you labelling each line in some way?

                Need to clarify

    The table will have headers like:

    location           lt  distance offset           right distance offset

    Location 1         1 0..6'                                        78.4' 

    Location 2        10.622.3'                                    34'

    Location 3-23    various                                     various

    MicroStation V8i (SELECT series  3) - Version 08.11.09.578

    Microstation Connect 10.14.00.109

  • Hi Steve,

    The dgn file that I created has 3  lines

    There are only these 3 elements in the file? I assume they are not, and context (how complex the file is) can change the complexity drastically.

    one on the lt, center line and one on the right .with different offsets.

    What do mean "left" and "right" terms for you? In topology (and GIS, cartography generalization and similar areas), left/right is defined in context 1st and 2nd point of the center line.

    a report by clicking measure distance command picking the two lines centerline and then the left and doing the same thing on the right.

    Do you mean you expect to select all lines (center / left / right), always in the same order? So when there will be 20 center lines, 60 lines have to be located? This workflow makes the location issue the simplest possible I guess, on the other hand is not user friendly (too many clicks).

    Appreciate some step by step how to crate it.

    MicroStation is not able to do it. MicroStation reports allow to query elements with Item Types attached (or with other EC data available), and include also defined related information. But lines, created using Copy parallel tool, are independent elements, with no relation to the original line.

    I think what you are asking for can be achieved writing own code. Because Tables and Reports are not supported in VBA, probably to use C# is necessary (or maybe C++, because it's MicroStation primary API). To implement such functionality is about balancing between workflow (how it's automated and user friendly) and complexity (to implement detection of left/right lines depends a lot on design file content and structure).

    With regards,

      Jan