Last week the Civil Immersion blog site released a video that explains how to extract a point list that notates a point with station and offset in respect to an alignment in your drawing. I highly recommend watching this video, especially if you're a surveyor.
While watching the video it triggered in my memory the very first blog I ever posted back in 2010 for a site that no longer exists. In my post I go in the opposite direction of the video. I import points that have stations and offsets and create a point label style that expresses the values.
Here's the original post. . .
A few weeks ago one of our clients called me up with an uncommon question. He had an Excel file (CSV format) that had point numbers, northings, eastings, elevations, offsets, and station numbers as follows:
(I’ve replaced the column headings with the correct title to make the file format clearer.)
His desire was to import these points into Civil 3D with a label style that would only express point numbers, elevations, offsets, and station numbers as follows:
This sounded pretty straight forward and easy until I realized that there was not a label style native to Civil 3D that would label offset values or station values. “Well, no problem,” I thought, “I could just use the offset column as a description.” But what about the station numbers? Bring in the User-Defined Property Classifications. These are highly useful for situations such as this.
In the Settings tab, expand the Point heading, right-click on User-Defined Property Classification heading and select New…:
Give it a name (I gave it Station):
You’ll see the name appear in the Toolspace.
Right-click on the name and select New…:
In the New-User Defined Property dialog box name the value to read from the import file (I named it Station):
Leave the other values alone and click OK.
Now navigate to the Point File Formats branch and pick one to copy and edit (I selected PNEZD (comma delimited) since it was closest to what I need).
Once selected, right-click and select Copy…:
Double-click on the existing format name and rename it (I named it to Point#-Elev-Off-Sta).
The CSV file given to me has point numbers, northings, eastings, elevations, offset values, and station numbers. Since I used the Raw Description as the place holder for the offset values, I needed to create a place holder for the station values.
Click the “<unused>” column heading to the right of Raw Description:
Click the Column name drop-list and select “Station” from the list.
The “Station” name came from the User-Defined Property Classification created earlier.
Click the Load… button and import the CSV file to see if it will load into your drawing (remember, to do this you must change your “Files of Type” to CSV). Then click the Parse button to see the outcome.
If it appears correctly, click OK to exit the Point File Format dialog box.
Navigate to the Ribbon’s Insert tab, Import panel and select Points from File:
In the Import Points dialog box, select the file format you just created from the Format drop-list and specify the import file using the blue “+” button.
Click OK to import the file and generate the points.
Zoom Extents to view your points.
Create a label style to accommodate for the offset and station values.
Expand the Label Styles branch to copy and edit an existing style. (I selected Point#-Elevation-Description).
Double-Click the new style to rename and define as desired (I named my Point#-Elev-Off-Sta):
Click the Layout tab and create a Text component:
Change the Name to “Station” and apply the anchor and attachment settings as shown here:
Click the “Label Text” in the Contents value cell to display the ellipsis button (…). Click the ellipsis button:
Highlight the “Label Text” text that is in the right pane and delete it. Type “STA:” to indicate station.
With the blinking cursor to the right of “STA:” select Station from the Properties drop-list and use the arrow button to push it across:
Click OK to exit the Text Component Editor – Contents dialog box.
Click the Component name drop-list and select Point Description:
Click the “<[Full Description(CP)]>” in the Contents value cell to display the ellipsis button (…). Click the ellipsis button:
Add “OFF:” in front of the Full Description code as follows to indicate the offset value:
Click the Component name drop-list and select Point Elev and repeat the process adding “ELEV:” in front of the Point Elevation code.
When completed your preview should appear as follows:
Click Apply and OK to exit the Label Style Composer dialog box.
Select the All Points point group in the Prospector tab, right-click, and select Properties…:
Change the Point Label Style to the one you just created:
Click Apply and OK.
The final product should appear as follows: