Data extraction of 3D solid components

[dave_wilson]

I am using AutoCAD 2020 and want to achieve the following. (See attached drawing). The drawing shows all components in place on the left and the various components split up for clarity on the right.

I want to create a bill of quantities from a 3D drawing of a concrete pit. The components/process for creating the pit is as follows:

1. Excavate hole. (Colour=Brown on the drawing).
2. Backfill and compact 150mm layer on the pit floor. Colour=Cyan on the drawing).
3. Cast concrete floor. (Colour=Grey on the drawing).
4. After installing shutters, cast concrete walls. (Colour=Magenta on the drawing).

The data required is as follows:

1. Pit Identification
2. Component identification.
3. The volume of the component.

Each component will be drawn on the layer unique to that component. Bear in mind that I've only drawn one pit, in reality, there are approximately fifty pits on this project. For example, there will be fifty soil excavations on the drawing all drawn on the soil excavations layer.

My idea is to select all the components for all fifty pits and extract the abovementioned data to a spreadsheet. after all the data is extracted, I'll have a spreadsheet that identifies each component for each pit and contains the volume for each component of each pit.

Thanks in advance,

Dave 

[natasha.l]

Hello @dave_wilson, 

Are you using the The Data Extraction wizard it is the most efficient way to extract attribute information. It can also be used to extract property values that are associated with the other types of geometry defined in a drawing along with general information about a drawing file.

To find out more please review this link, to learn more about how to >extract attribute information from blocks or objects< into a table object or CSV file for use in another application. 

Please "Accept Solution" if a reply or replies have helped resolve the issue or answered your question, to help others in the community.

[dave_wilson]

Hi,

The article you reference deals specifically with data extraction of block
attributes. This I've done successfully on many occasions.



My issue is with extracting data related to a 3D solid; in this case the
volume of the solid. I've tried to use the wizard on a 3D solid, but none of
the properties I'm able to select, (page 4 of 8), provided me with the
information I require.



I hope this clarifies my issue.

[R_Tweed · Accepted solution]

The drawing shows a rectangular shape which could be worked out using closed polylines with thickness .  Based on that you can extract the area and thickness of a polyline to determine your volumes. If you block the polyline and add attributes the data can then be sorted by block.

If your looking at a different shape in the vertical section you could model it and do an average end area calc using the section function and then pull areas from that maybe in a separate data extraction.

Either that or run a massprop and then manually add text value that you could then extract.

[dave_wilson]

Thanks for the solution. So you live and so you learn.

Much appreciated