Thursday, 19 December 2013

Getting Set Out Info. from your Corridor

The reporting end of Civil 3D can be frustrating. Generally I have found that there will not be a report that gives you exactly what you want. Some reports will give you one bit of what you want and also probably a lot of information you don't need.
I have found that you usually need to export bits from multiple reports and edit them in excel to create one final report with the info you want. This can be time consuming and for something simple like x,y and z points for say road edges and centreline I prefer to create points from corridor and then export these to csv file for set out. There is a report in Civil 3D that looks like it will get you this information and it does to a certain extent but it is not in a format that is easily unloadable to a GPS logger for setting out. Below is the procedure, which is by no means a one-click solution but it does the job.

First set your corridor frequency to the chainage interval that you want setout info for. In my case every 10m.
Next we will edit the assembly we are using to add Mark Points with specific codes for the points we are setting out - Road Edge Left, REL, Road Edge right, RER and Centreline, CL. Open your tool palettes (CTRL+3) and open the Civil Subassemblies and on the Generic tab browse to the Mark Point subassembly. This just inserts a point into the assembly and corridor - a point which we can give our own unique code to.
When you go to insert this into your assembly you can set the point code in the properties dialog box.
Set the code and then select the relevant location in your assembly - right edge of carriageway in my example above, just click on the existing marker at the end of the lane subassembly where you want to point to be. You will probably not notice anything different happen on the assembly as it is just inserting a point. Repeat this for any other points that you want to extract from the corridor, naming the point code appropriately.

Next select your corridor in plan and click on Launch pad on the top right of the ribbon and then select Points from Corridor and only select the codes from the Mark Point subassemblies.
This will create cogo points from the corridor at 10m intervals for each of the mark points using the point code for the cogo point description (RER, CL, REL). Next step is to separate these points into point groups based on their descriptions and export them to csv file. Create point groups for each code (RER, CL, REL) and include points related to that groups code. i.e for the point group CL only include points with description CL.
Next export each of the point groups to csv - right click on the point group and export points and fill out the info in the following dialog box.
When Civil 3D creates points from corridor it does so for each string along the length of the corridor. This doesn't suit from a setting out point of view where it will probably be set out in a cross section manner rather than doing each string separately. When you export each of the point groups to excel you will need to renumber the points and then copy and paste them into one excel file to create one complete set out file. In my case I have 3 points at each chainage so I renumber all the REL points 1,4,7... CL points 2,5,8... and RER points 3,6,9.... This is easy done in excel and then copy paste into one excel file and sort by number. You now have set out points at each chainage. By no means the smoothest of workflows but it gets the job done. There are 3rd party add-ons you can get for Civil 3D that allow you to create custom report formats. I haven't explored what sort of results you get from using the Trimble add on or similar to export a corridor to a logger.

No comments:

Post a Comment