Friday 19 March 2010

Visibility Graph

Visibility graph is one requirement in a Sight Stopping Distance (SSD) departure from standards submission to the Highways Agency.

DfS

This can be prepared using the new Sight Distance along Corridor tool included in the Civil 3D 2010 Subscription Advantage Pack (SAP) and MS Excel.

The Civil 3D part is pretty simple and quick to do with most work done in Excel.

For my sample data, I have a surface model of a motorway central reserve with concrete step barrier which was created using 3D polylines.

The SAP tools live in the Toolbox tab of the Toolspace.

1-Toolspace

As in a number of Civil 3D commands, the tool will go through a wizard-type steps to get the desired output. The first box will ask to select a path for the visibility check. This can be in a form of an alignment and profile or feature lines or 3D polylines. This is also where we specify the start and end of the analysis. If an alignment is used for the path, it will ask for a chainage value and if a feature line or 3D polyine is used, points are used. Finally, choose the surface model to use.

SD1

The 2nd step is where we input the sight distance parameters such as the minimum SSD, driver’s eye height and offset and target object’s height and offset.

SD2

The offset being the offset distance from the path chosen in the first step. For my example my path is the road lane marking between Lane 2 and Lane 3 of the carriageway and I’d like the check to run along the centre of Lane 3.

Plan

Use negative (-) offset values if it is to the left side of the path and positive if on the right.

The next step of the wizard is to set whether the analysis components are to be drawn or not and which layers are to be used for each. Lastly, choose whether to create a report for the analysis. Use the CSV style report and chose where to save the report. The report will be saved as a .txt file.

SD3

That’s the Civil 3D part done and from here, it’s all MS Excel.

Open MS Excel and open the text file. Choose a Delimited data and comma as the delimiter.

Excel0 Excel1

Delete the information header and columns D and E.

Excel2

Remove the unit “m” from the values by using Replace under the Edit menu. I added a new column where I placed the One Step below Desirable Minimum (relaxed) value of 215 which I also want to show on the graph. These parameters by the way are all in TD 9/93 of the DMRB.

So basically, the first column contains the chainages, 2nd column has the actual sight distance achieved from the analysis, the 3rd column is the desirable minimum sight distance and the 4th column is the relaxed value.

Excel3

Insert menu> Chart and use a line-type chart and click Next.

Graph1

On the 2nd step of the wizard, click the Series tab and click Add.

Graph2

Give the Series a name. In my example I used “Visibility”. For the Values field, click the Value button and select the column B data (select and drag from Row 1 down to the row of the last value). For Category (X) axis labels, select the Column A data.

Graph3

Click Add to create another Series and name it 295. For the Values field, click the Value button and select the Column C data.

Graph4

Click Add to create another series and name it 215. For the Values field, click the Value button and select the Column D data.

Graph5

Click Next and under the Titles tab, put Visibility for Chart title, Chainage for Category (X) axis and SSD in the Value (Y) axis.

Graph6

Last step is to choose if the chart will be placed in a new sheet or as an object in the current worksheet and click Finish.

Graph7

The graph will look similar to the image below. For better presentation, you can always go back and change the format/style of the different parts of the graph by selecting them and right click.

Graph8

Here’s how a final output may look like.

Graph9 

Have a good weekend everyone!

3 comments: