MicroStation Tip: Automate Coordinate Entries

Written by Rod Wing

For those of you who have had to do a lot of coordinate entry in MicroStation, either through the key-in browser or using AccuDraw, you know what a chore that can be. You can use Excel and Notepad to create a MicroStation script file to make that job much easier.

In this example we have a parcel boundary from a legal description. We are given the start point Northing, Easting and the Distance and Bearing for each subsequent point. Even if you do not receive the coordinate entries in electronic format and have to re-key all of the values you may find this method easier than trying to key them directly in MicroStation.

CoordinateEntry1

 

 

The first step is to format the coordinate data. The Northing (Y) and Easting (X) values have been transposed to the be in the traditional X,Y order. Then the direction/bearing values are edited so they are in a format MicroStation accepts. Simply use the Excel Replace tool to edit all the values at once.

CoordinateEntry1b

 

The next step is to insert a column at the beginning of each line for the MicroStation key-in command. In this case the first coordinate will use the MicroStation XY= key-in to place the point while the subsequent points will use the MicroStation DI= key-in to use the distance and direction values. Adding the command column in Excel it is easy to copy and paste the command key-ins.

CoordinateEntry2

 

Once this formatting is completed in Excel we export the data to a .csv file. Using Notepad we can complete the formatting. The first step is to comment out any non-executable lines by placing a # at the beginning. Then we replace the first comma with an = so that it matches the MicroStation key-in syntax. Using the Notepad Replace tool makes this very easy.

CoordinateEntry3

Now that coordinate key-ins are formatted correctly we add the MicroStation tool command(s) with which we want to place the coordinates. In this case we start with the Place Smartline tool and enter a Reset when completed.

CoordinateEntry4

 

Finally, save the text file and open MicroStation. In MicroStation we open the Key-in browser and run the script file. The @ character followed by the full path to the script file will execute commands in the file.

CoordinateEntry5

 

 

Last month’s tips:

Locks   7-1-2014 10-25-37 AM      Options Layout Regen       1
MicroStation: Key                   InRoads: Horizontal                  AutoCAD Civil 3D:                    VBA: Message Box 
     Point Snap                               Geometry working …                 Improve Performance…                  Buttons
 
 
 
Don’t want to miss out on other great information? Subscribe to this blog or our monthly eNewsletter now!
Learn More ◊ Contact us today ◊ Newsletter ◊
EnvisionCAD Group EnvisionCAD YouTube Channel   
Rod Wing

Rod Wing

Rod is the Senior Systems Analyst at EnvisionCAD and has extensive experience in GIS, cartography, plotting, scanning, raster editing/manipulation, publishing, and file/data translations. He instructs MicroStation classes ranging from fundamentals to advanced.

Tags:

2 comments on “MicroStation Tip: Automate Coordinate Entries

  1. Guy Ladd Reply

    Hi Rod,
    Great Tip!!
    I’m assuming you can also use the automate coodinate entries for creating a long highway baseline that have distance/bearings for tangent lines and radius/delta for curves? What would be the key-in for changing from tangent to curve and back to tangent? Do you have an example of how the spreadsheet or text document would look like?

    Thanks
    Guy
    Maine Department of Transportation

  2. Bob Mecham Bob Mecham Reply

    Hi Guy, I did some checking and couldn’t find an easy solution for working with arcs based on Radius and Delta. If you knew 3 points on the arc you could try the keyin “place arc center constrained;xy=?,?,?;xy=?,?,?;xy=?,?,?” Otherwise I would look at InRoads or Geopak to help you out with scripting out a baseline alignment. Maybe someone else has a better idea.

    Bob

Leave a Reply

Your email address will not be published. Required fields are marked *