Computational & Technology Resources
an online resource for computational,
engineering & technology publications
Civil-Comp Proceedings
ISSN 1759-3433
CCP: 73
Edited by: B.H.V. Topping
Paper 11

Data Extraction for Design and Construction Integration: An Application in Petrochemical Industry

K. Lueprasert+ and L. Meepradit*

+Department of Civil Engineering, *Construction Engineering and Management Program, Faculty of Engineering, King Mongkut's University of Technology Thonburi, Bangkok, Thailand

Full Bibliographic Reference for this paper
K. Lueprasert, L. Meepradit, "Data Extraction for Design and Construction Integration: An Application in Petrochemical Industry", in B.H.V. Topping, (Editor), "Proceedings of the Eighth International Conference on Civil and Structural Engineering Computing", Civil-Comp Press, Stirlingshire, UK, Paper 11, 2001. doi:10.4203/ccp.73.11
Keywords: CAD data extraction, design and construction integration, quantity take-off, database system.

Computer-aided-design and drafting (CAD) has long been used as a tool during design phase. However, the capabilities of CAD software have advanced profoundly in recent years along with other computer technology. CAD is no longer used only as a drafting or design tool, but also for 3D visualization and, moreover, as a source of a subsequent construction's database. Nowadays, designs drafted electronically in CAD software can be used in various ways, not only for the design process but in the construction process, such as construction cost and resource control as well. However, despite of all rapid development, only in the last decade that CAD software has started to establish its ground as a common drafting tool in Thailand.

The objectives of this project are to suggest a CAD data-extraction technique and develop the data extraction system prototype to promote the full use of electronic data in drawings after the design phase. The petrochemical industry was selected in this study. This proposed data-extraction system was designed to eliminate the manual quantity take-off process in construction estimation of petrochemical plant. Therefore, the proposed extraction system must capable of extracting relevant design data and information from existing design drawings. The extracted database can then be used in the construction phase for estimates, procurement, and construction control as needed.

The proposed system in this project uses the isometric drawing as a base for data extraction and query. A CAD software, AutoCAD® release 14.01, was selected, on the basis of its availability and current uses in the industry, as a platform for this project. This release is capable of integrating with other programming tools such as VBA (Visual Basic for Applications). Necessary block drawing templates and functions for pipeline drawings and the data-extraction function were developed using the VBA tool. All functions developed for the drawing or data-extraction purposes were designed to use as interface with the CAD software or as an add-on to the software.

To be able to perform automatic data extraction, it is needed to identify what were the data to be extracted and in which formats the data were using. The authors had reviewed and gathered applicable material lists, and the standards used in the industry, and designed a database that was used as a support database in the system. The system features an isometric drawing template, 17 drawing block templates for drawing each part and its connection in a pipeline, and associated design and specification database. Design and specification data of each part or object in a line can be incorporated using the provided functions. With these features, the data extraction and query from design drawings can be performed effectively. At this point, all features and functions in the system are still being tested to verify its performances and operations. After the evaluation by users in the field, the system may be further modified to conform with any new requirements accordingly.

P. Barrett, "Construction Management Pull for Four-Dimensional Computer- Aided Design (4D CAD)", Proceedings of the Sixth Construction Congress in Orlando, Florida , February, 2000, pp. 977-983.
R.M. Webb, "Four-Dimensional Computer-Aided Design (4D CAD): Construction Industry Perspective", Proceedings of the Sixth Construction Congress in Orlando, Florida , February, 2000, pp. 1042-1050.
R.M. Webb, "Towards Five Dimensional Computer-Aided Design (5D CAD): Dynamic Cost and Resource Planning for Specialist Contractors", Proceedings of the Sixth Construction Congress in Orlando, Florida , February, 2000, pp. 1023-1028.
"PlantSpace P&ID Technical Profile",, Bentley Systems Inc., 2000.
"Integraph Process & Building Solutions SmartPlant P&ID",, Intergraph Corporation, 2001.
T. Froese, "Interwoven Threads: Trends in the Use of Information Technologies for the Construction Industry", White Paper prepared for Berkeley-Stanford Workshop on Defining a Research Agenda for AEC Process/Product Development in 2000 and Beyond , Stanford, CA, Aug. 1999.

purchase the full-text of this paper (price £20)

go to the previous paper
go to the next paper
return to the table of contents
return to the book description