|
|
 |
||||||
|
||||||
 |
by Brian Morse
Issue
You wish to automate the calculation of pavement quantities for driveways along a roadway. You wish to track the station value for each driveway so you can make spot checks at specific driveways.
Solution
Using Autodesk Map you can create a comma delimited text file containing the Station and Area for each driveway. The file can be imported to a spreadsheet to calculate quantities from the area. The station is used for validation purposes.
Draw each driveway as a closed polyline.
Label the station/offset of the driveway.
Alignments > Station/Offset > Label
Place the insertion point of the station label text inside the driveway polyline.
Erase the Offset portion of the label.
Place the station label on a unique layer to assist in selecting the text by layer later.
Create a Polygon Topology of the Driveway polylines.
Select the Station label (not the offset label) for the Centroid Object.
Select the Driveway polylines for the link objects.
Object data tables are created for the topology.
The object data is attached to the station labels.
Choose Map > Topology > Administration > Statistics.
Check out the number of Polygons to verify that you have all the driveways.
Run the Map > Query > Define Topology Query command.
Set the Topology Type to None.
Choose the Define Query button.
The Current Query window should already show the query type.
Property: OBJECT TYPE = TEXT
Set the Query Mode to Report.
Choose the Options button.
In the Output Report Options dialog set the conditions to get the Area from the object data table and the Text Value from the Centroid Object (the station label text).
To do this choose the Data button.
Choose the Properties button from the Output Report Options dialog and select Text Value. This selection will add the Station Label to the output file.
Execute the query and you will get a report in the format shown below.
700.1745433,STA: 225+53.31
700.1745431,STA: 228+92.16
700.1743277,STA: 227+66.00
700.1745354,STA: 226+65.50
You can import the comma delimited text file to a spreadsheet to calculate pavement quantities.
