CN117708911A - Building axis network coordinate rapid labeling method based on CAD - Google Patents
Building axis network coordinate rapid labeling method based on CAD Download PDFInfo
- Publication number
- CN117708911A CN117708911A CN202311700177.8A CN202311700177A CN117708911A CN 117708911 A CN117708911 A CN 117708911A CN 202311700177 A CN202311700177 A CN 202311700177A CN 117708911 A CN117708911 A CN 117708911A
- Authority
- CN
- China
- Prior art keywords
- coordinate
- cad
- axis
- control points
- coordinate values
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000002372 labelling Methods 0.000 title claims abstract description 22
- 238000000034 method Methods 0.000 claims abstract description 13
- 238000010276 construction Methods 0.000 claims description 19
- 238000010586 diagram Methods 0.000 claims description 16
- 238000013461 design Methods 0.000 claims description 12
- 238000013075 data extraction Methods 0.000 claims description 5
- 230000000007 visual effect Effects 0.000 claims description 3
- 238000004140 cleaning Methods 0.000 claims description 2
- 238000012216 screening Methods 0.000 claims description 2
- 230000006870 function Effects 0.000 abstract description 8
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000010415 tidying Methods 0.000 description 1
Landscapes
- Processing Or Creating Images (AREA)
Abstract
The application provides a CAD-based building shaft network coordinate quick labeling method, which can conveniently and quickly complete shaft network all control points, line lofting and three-dimensional coordinate labeling work in batches only through the own command functions of CAD and Excel, solves the problems of low efficiency and easy error of traditional manual coordinate value input, solves the problem of additional cost increase caused by using professional software or plug-in components, reduces additional learning and use cost, and also avoids various software and system fault risks possibly caused by software or plug-in components. By storing the three-dimensional coordinate sorting Excel table as a template and copying the set three-dimensional coordinate index block to other engineering projects, the method has the advantages of being similar to professional software or plug-in components, free of repeated labor, and capable of reducing the use flow of the other engineering projects. Meanwhile, the Excel template and the three-dimensional coordinate index block have certain parameterization customizing and modifying functions, and learning cost is greatly reduced.
Description
Technical Field
The application relates to the field of constructional engineering, in particular to a CAD-based rapid labeling method for coordinates of a building shaft network.
Background
Various shaft networks play a vital role in construction engineering and they are used to determine the most basic positioning of various buildings and structures. An axial network is understood to mean a series of mutually interlaced wires which are used as reference lines for a building or structure. By using the axle net, architects and engineers can ensure that the various parts of the building are positioned accurately during construction. In particular, in the actual construction stage, constructors determine the positions and the sizes of various elements of the building through the shaft net, so that construction work is effectively performed.
Although BIM systems can provide comprehensive building information and models, conventional two-dimensional construction drawings are still required to achieve accurate coordinate positioning and reference in the actual construction process. On the drawing of the coordinate value of the control point of the axial network, constructors can intuitively understand the design intention, can accurately measure and position, and ensure the construction accuracy and quality.
The traditional method for marking the coordinate values of the control points of the shaft network in the construction drawing generally comprises two methods: one is to manually input various coordinate values in a CAD environment using a manual manner; the disadvantage of this approach is that it is inefficient and prone to error. Another way is to use professional software or plug-in components to automatically generate the coordinate values of the control points of the shaft network in CAD; although this way can improve the working efficiency and reduce errors caused by human factors, there are some problems: first, the use of specialized software or plug-ins requires additional cost investment, which may be impractical for some small projects or teams with limited budgets; second, the complexity of software operations may require additional learning and use costs, which can be difficult for those who are unfamiliar with the software; in addition, some software or plug-ins may have compatibility problems, failing to match properly with the particular CAD software, resulting in errors or imperfections in data transmission; finally, relying on software or plug-ins also increases the risk of system crashes or software failures.
Disclosure of Invention
The application provides a CAD-based quick labeling method for building axis network coordinates, which aims to solve the problems of low working efficiency and easy error of labeling axis network control point coordinate values in the existing construction drawing.
The technical scheme of the application is as follows:
a CAD-based building axis network coordinate rapid labeling method comprises the following steps:
s1, extracting coordinate values: extracting the coordinate values of the required shaft network control points according to a given design construction drawing or BIM model, and inputting the coordinate values into Excel;
s2, arranging coordinate values of the axis network control points: the extracted coordinate values of the axis network control points are arranged in Excel, and the coordinate values of the axis network control points are converted into a format which can be identified by CAD;
s3, lofting an axial network: the coordinate values of the sorted shaft net control points are imported into CAD in batches, and shaft net lofting is carried out by using point, straight line or multi-section line commands, or a shaft net lofting layout is drawn;
s4, marking coordinate values: and importing the sorted coordinate values of the axis net control points into CAD in batches, and generating coordinate value labels on the axis net lofting layout.
As an aspect of the present application, in step S1, the shaft network control point includes a longitudinal axis end point, a transverse axis end point, and an intersection point of the longitudinal axis and the transverse axis of the shaft network.
As a technical scheme of the present application, in step S1, when the axis network control point coordinate values are extracted from the design and construction drawing, the coordinate table in the design and construction drawing is exported to an Excel table, and coordinate data are listed in a manner of X coordinate, Y coordinate and Z coordinate.
In step S1, when extracting the coordinate values of the axis network control points from the BIM model, cleaning the BIM model, retaining the required axis network BIM model information by deleting or hiding, and then extracting the coordinate value data of the axis network control points into an Excel table; when the BIM software has no function of exporting the axis network coordinate data, exporting an axis network BIM model into a three-dimensional model file in a DWG format, opening the three-dimensional model file by using CAD, and marking points on the axis network control points by using CAD Point commands; screening out all marked points, extracting three-dimensional coordinate data of all marked points by using a data extraction command, deriving an Excel table, and classifying the coordinate data according to X coordinates, Y coordinates and Z coordinates.
As a technical solution of the present application, in step S2, coordinate values are sorted: and arranging the extracted coordinate values of the axis network control points in an Excel table, and converting the coordinate values of the axis network control points into X, Y, Z format which can be identified by CAD.
As a technical scheme of the application, in step S3, when a BIM model is provided, a three-dimensional model file is derived from the BIM model, and the three-dimensional model file is an axial network lofting layout; when the coordinate value data of the axis network control points are provided by the design construction drawing, the coordinate values of the axis network control points are imported into CAD in batches, the axis network lofting is carried out by using point, straight line or multi-section line commands, and the axis network lofting layout is drawn.
As an aspect of the present application, in step S4, the step of labeling coordinate values includes:
s41, setting a visual style space of a three-dimensional space of a CAD file as a two-dimensional wire frame and setting a view control as a overlook;
s42, drawing a three-dimensional coordinate index, converting a symbol graph of the three-dimensional coordinate index into a block, and opening the block in a block editor;
s43, running a block attribute definition Attdef command in the block editor, inserting x=, y=, Z = placeholder fields in the attribute default settings. After the setting is completed, saving and closing the block editor;
s44, copying all three-dimensional coordinate data in the coordinate value table of the axis network control point;
s45, inserting a three-dimensional coordinate index block at any position in the axial network control diagram;
s46, selecting the three-dimensional coordinate index block, running a Copy command, clicking pins of the three-dimensional coordinate index block, pasting all three-dimensional coordinate data in a CAD command prompt line, and automatically marking three-dimensional coordinate values of all the axis network control points in batches.
The beneficial effects of this application:
the application provides a CAD-based building axis network coordinate rapid labeling method, which has the beneficial effects that:
(1) The implementation of the method only depends on CAD and Excel software which are necessary for various engineering personnel, and the work of all control points, line lofting and three-dimensional coordinate marking of the shaft network can be conveniently and rapidly finished in batches only through the own command functions of the CAD and Excel, so that the problems of low efficiency and easy error of the traditional manual coordinate value input are solved, the problem of additional cost increase caused by using professional software or plug-in components is also solved, the additional learning and using cost is reduced, and various software and system fault risks possibly caused by software or plug-in components are also avoided;
(2) According to the method, the three-dimensional coordinate sorting Excel table is stored as the template, and the set three-dimensional coordinate index block is copied to other engineering projects for use, so that the effect similar to professional software or plug-in components can be achieved, repeated labor is not needed, the use flow of other engineering projects can be reduced, the problems that the prior art needs to restart and repeat operations in different projects are solved, and the method has the characteristic of high efficiency; meanwhile, the Excel template and the three-dimensional coordinate index block have certain parameterization customizing and modifying functions, and learning cost is greatly reduced.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments will be briefly described below, it being understood that the drawings only show,
Certain embodiments of the present application should not be construed as limiting the scope and other related drawings may be obtained from these drawings by those of ordinary skill in the art without undue burden.
Fig. 1 is a schematic flow chart of a rapid labeling method for building axis network coordinates based on CAD according to an embodiment of the present application;
FIG. 2 is a three-dimensional model diagram of an axial network provided in an embodiment of the present application;
fig. 3 is a three-dimensional model diagram of an axial network control point according to an embodiment of the present application;
fig. 4 is a three-dimensional coordinate data extraction diagram of an axial network control point according to an embodiment of the present application;
fig. 5 is a three-dimensional coordinate data diagram of an axial network control point according to an embodiment of the present application;
fig. 6 is a three-dimensional coordinate data arrangement diagram of an axial network control point according to an embodiment of the present application;
fig. 7 is a layout diagram of control points of an axial network according to an embodiment of the present application;
FIG. 8 is a cross-axis schematic illustration of a control point of a shaft network according to an embodiment of the present application;
FIG. 9 is a longitudinal axis schematic view of a control point of a shaft network according to an embodiment of the present application;
fig. 10 is a schematic diagram of three-dimensional coordinate index block attribute setting provided in an embodiment of the present application;
fig. 11 is a schematic diagram of three-dimensional coordinate index block attribute field setting provided in an embodiment of the present application;
FIG. 12 is a schematic diagram of a three-dimensional coordinate index block according to an embodiment of the present disclosure;
FIG. 13 is a schematic illustration of three-dimensional coordinate index block insertion provided in an embodiment of the present application;
FIG. 14 is a schematic diagram of batch labeling of three-dimensional coordinate indexes according to an embodiment of the present disclosure;
fig. 15 is a partial enlarged view of three-dimensional coordinate index batch labeling provided in an embodiment of the present application.
Detailed Description
For the purposes of making the objects, technical solutions and advantages of the embodiments of the present application more clear, the technical solutions of the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is apparent that the described embodiments are some embodiments of the present application, but not all embodiments. The components of the embodiments of the present application, as generally described and illustrated in the figures herein, may be arranged and designed in a wide variety of different configurations.
Thus, the following detailed description of the embodiments of the present application, as provided in the accompanying drawings, is not intended to limit the scope of the application, as claimed, but is merely representative of selected embodiments of the application. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the present disclosure, are within the scope of the present disclosure.
Examples:
referring to fig. 1, with reference to fig. 2 to 15, in this embodiment, a method for quickly labeling coordinates of a building shaft network based on CAD is provided, which mainly includes the following steps:
s1, extracting coordinate values: extracting the coordinate values of the required shaft network control points according to a given design construction drawing or BIM model, and inputting the coordinate values into Excel; the shaft network control points are the longitudinal axis end points, the transverse axis end points, and the intersection points between the longitudinal axis and the transverse axis of the shaft network; when the coordinates of the control points of the axial network are extracted from the design construction drawing, the coordinate table in the drawing can be directly exported to an Excel table, and coordinate data are listed in a mode of 'X coordinate', 'Y coordinate', 'Z coordinate'; when the coordinate values of the shaft network control points are extracted from the BIM model, the model is required to be cleaned, the needed shaft network BIM model information is reserved in a deleting or hiding mode, and then the coordinate value data of the shaft network control points are extracted into an Excel table; referring to fig. 2, when the BIM software does not have the function of deriving the axis coordinate data, the axis BIM model is derived into a three-dimensional model file in DWG format, the three-dimensional model file is opened by CAD, and then points are marked on the axis control points by CAD Point (Point) commands; specifically, it can command the display style and display size of the setpoint using the point-like (Ptype) in CAD, making it clear and noticeable; setting an independent layer to the point so as to screen and carry out subsequent operation; referring to fig. 3 to 5, all marked points are screened out, three-dimensional coordinate data of all marked points are extracted by using a data extraction (Dataextraction) command, and derived into an Excel table, and the coordinate data are listed in a manner of 'X coordinate', 'Y coordinate', 'Z coordinate';
s2, arranging coordinate values of the shaft network control points: the coordinate values of the extracted axis net control points are arranged in Excel, and the coordinate values of the axis net control points are converted into an X, Y and Z format which can be identified by CAD; referring to fig. 6, in the present embodiment, in the Excel table, the C column unit cell is the X coordinate data, the D column unit cell is the Y coordinate data, the E column unit cell is the Z coordinate data, the F column unit cell is used as the auxiliary column to add the character ",", and the G2 cell is filled with the following functional formula: =concat (C2, F2, D2, F2, E2), duplicates the above functional formula to fill all cells of column G down;
s3, lofting an axial network: when a three-dimensional model file derived by the BIM exists, the three-dimensional model file is an axial network lofting chart; when only the coordinate data given by the design drawing does not have an axial network diagram, the arranged coordinate values are required to be imported into CAD in batches, and the axial network lofting is carried out by using point, straight line or multi-section line commands, or the axial network lofting layout diagram is drawn; referring to fig. 7, in the present embodiment, three-dimensional coordinate data in a coordinate value table is copied, when a Point command is executed in CAD, and a CAD status bar presents a coordinate prompt of a designated Point, the three-dimensional coordinate data is copied to the CAD status bar, so that an axis network control Point diagram can be automatically generated; referring to fig. 8, three-dimensional coordinate data in a coordinate value table is copied, a three-dimensional multi-section line (3 dpoly) command is run in CAD, when a CAD status bar presents a prompt, the three-dimensional coordinate data is copied into the CAD status bar, and a lateral axis map of an axis network can be automatically generated; referring to fig. 9, three-dimensional coordinate data of a longitudinal axis in a coordinate value table is copied, a Line (Line) command is run in CAD, and when a CAD status bar presents a prompt, the three-dimensional coordinate data is copied into the CAD status bar, so that a shaft network longitudinal axis map can be automatically generated;
s4, marking coordinate values: the arranged coordinate values are imported into CAD in batches, and coordinate value labels are generated on the axial network lofting layout; the method comprises the following specific steps:
s41, setting a visual style space of a three-dimensional space of a CAD file as a two-dimensional wire frame and setting a view control as a overlook;
s42, drawing a three-dimensional coordinate index, converting a symbol graph of the three-dimensional coordinate index into a block, and opening the block in a block editor;
s43, referring to fig. 10 to 12, a block attribute definition (Attdef) command is run in the block editor, and "x=", "y=", "z=" placeholder fields are inserted in the attribute default settings; after the setting is completed, saving and closing the block editor;
s44, copying all three-dimensional coordinate data in the coordinate value table;
s45, inserting a three-dimensional coordinate index block at any position in the axial network control diagram;
s46, selecting the three-dimensional coordinate index block, running a Copy command, taking pins of the three-dimensional coordinate index block, and pasting all three-dimensional coordinate data in a CAD command prompt line, so that three-dimensional coordinate values of all axis network control points can be automatically marked in batches.
On the one hand, the implementation of the method only depends on CAD and Excel software which are necessary for various engineering personnel, and the operation of all control points, line lofting and three-dimensional coordinate marking of the shaft network can be conveniently and rapidly finished in batches only through the own command functions of the CAD and Excel, so that the problems of low efficiency and easy error of traditional manual coordinate value input are solved, the problem of additional cost increase caused by using professional software or plug-in components is also solved, the additional learning and using cost is reduced, and various software and system fault risks possibly caused by software or plug-in components are also avoided; on the other hand, the method has the advantages that the three-dimensional coordinate tidying Excel form is stored as a template, and the set three-dimensional coordinate index block is copied to other engineering projects for use, so that the effect similar to professional software or plug-in components can be achieved, repeated labor is not needed, the use flow of other engineering projects can be reduced, the problems that the prior art needs to restart and repeated operation in different engineering are solved, and the method has the characteristic of high efficiency; meanwhile, the Excel template and the three-dimensional coordinate index block have certain parameterization customizing and modifying functions, and learning cost is greatly reduced.
The foregoing description is only of the preferred embodiments of the present application and is not intended to limit the same, but rather, various modifications and variations may be made by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principles of the present application should be included in the protection scope of the present application.
Claims (7)
1. The method for quickly marking the coordinates of the building shaft network based on CAD is characterized by comprising the following steps:
s1, extracting coordinate values: extracting the coordinate values of the required shaft network control points according to a given design construction drawing or BIM model, and inputting the coordinate values into Excel;
s2, arranging coordinate values of the axis network control points: the extracted coordinate values of the axis network control points are arranged in Excel, and the coordinate values of the axis network control points are converted into a format which can be identified by CAD;
s3, lofting an axial network: the coordinate values of the sorted shaft net control points are imported into CAD in batches, and shaft net lofting is carried out by using point, straight line or multi-section line commands, or a shaft net lofting layout is drawn;
s4, marking coordinate values: and importing the sorted coordinate values of the axis net control points into CAD in batches, and generating coordinate value labels on the axis net lofting layout.
2. The rapid labeling method for CAD-based building shaft network coordinates according to claim 1, wherein in step S1, the shaft network control points comprise the longitudinal axis end points, the transverse axis end points, and the intersection points of the longitudinal axis and the transverse axis of the shaft network.
3. The rapid labeling method for building axis network coordinates based on CAD according to claim 1, wherein in step S1, when the axis network control point coordinate values are extracted from the design construction drawing, the coordinate table in the design construction drawing is exported to an Excel table, and coordinate data are listed in a manner of X coordinate, Y coordinate and Z coordinate.
4. The rapid labeling method for building axis network coordinates based on CAD according to claim 1, wherein in step S1, when extracting the coordinate values of the axis network control points from the BIM model, cleaning the BIM model, retaining the needed axis network BIM model information by deleting or hiding, and then extracting the coordinate value data of the axis network control points into an Excel table; when the BIM software has no function of exporting the axis network coordinate data, exporting an axis network BIM model into a three-dimensional model file in a DWG format, opening the three-dimensional model file by using CAD, and marking points on the axis network control points by using CAD Point commands; screening out all marked points, extracting three-dimensional coordinate data of all marked points by using a data extraction command, deriving an Excel table, and classifying the coordinate data according to X coordinates, Y coordinates and Z coordinates.
5. The rapid labeling method for building axis network coordinates based on CAD according to claim 1, wherein in step S2, coordinate values are collated: and arranging the extracted coordinate values of the axis network control points in an Excel table, and converting the coordinate values of the axis network control points into X, Y, Z format which can be identified by CAD.
6. The rapid labeling method for building axis network coordinates based on CAD according to claim 1, wherein in step S3, when BIM is provided, a three-dimensional model file is derived from the BIM, and the three-dimensional model file is an axis network lofting layout; when the coordinate value data of the axis network control points are provided by the design construction drawing, the coordinate values of the axis network control points are imported into CAD in batches, and the axis network lofting is carried out by using point, straight line or multi-section line commands or an axis network lofting layout is drawn.
7. The rapid labeling method for building axis network coordinates based on CAD according to claim 1, wherein in step S4, the step of labeling coordinate values comprises:
s41, setting a visual style space of a three-dimensional space of a CAD file as a two-dimensional wire frame and setting a view control as a overlook;
s42, drawing a three-dimensional coordinate index, converting a symbol graph of the three-dimensional coordinate index into a block, and opening the block in a block editor;
s43, running a block attribute definition Attdef command in the block editor, inserting x=, y=, Z = placeholder fields in the attribute default settings. After the setting is completed, saving and closing the block editor;
s44, copying all three-dimensional coordinate data in the coordinate value table of the axis network control point;
s45, inserting a three-dimensional coordinate index block at any position in the axial network control diagram;
s46, selecting the three-dimensional coordinate index block, running Copy command, and clicking three
Pins of the dimensional coordinate index block paste all three-dimensional coordinate data in a CAD command prompt line,
and automatically labeling the three-dimensional coordinate values of all the axis network control points in batches.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311700177.8A CN117708911A (en) | 2023-12-12 | 2023-12-12 | Building axis network coordinate rapid labeling method based on CAD |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311700177.8A CN117708911A (en) | 2023-12-12 | 2023-12-12 | Building axis network coordinate rapid labeling method based on CAD |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117708911A true CN117708911A (en) | 2024-03-15 |
Family
ID=90152717
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311700177.8A Pending CN117708911A (en) | 2023-12-12 | 2023-12-12 | Building axis network coordinate rapid labeling method based on CAD |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117708911A (en) |
-
2023
- 2023-12-12 CN CN202311700177.8A patent/CN117708911A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP0536534B1 (en) | Automated re-layout method with dimensional associativity | |
| CN104008223B (en) | Graphical expressing method for connection of virtual terminals of secondary system of intelligent substation | |
| GB2213967A (en) | Knowledge based method and apparatus for designing integrated circuits using functional specifications | |
| JP3194823B2 (en) | CAD library model creation device | |
| CN109032577B (en) | Data simulation method | |
| JP2000155859A (en) | Method for preparing mesh for analyzing numerical value and its device | |
| CN110968294B (en) | Business domain model establishing system and method | |
| CN112465958A (en) | WebGL-based BIM model lightweight display method | |
| CN109933765A (en) | A method of Excel table content is extracted to CAD table | |
| CN110765028B (en) | Visual construction method and device of verification environment and storage medium | |
| CN109739490A (en) | Quick electrical component model creating method based on QT graph framework | |
| CN103677811B (en) | Design system and method of spacecraft development process | |
| CN114201793B (en) | Sketchup-based BIM model lightweight method and system | |
| CN111309321A (en) | Customizable GUI system based on data drive | |
| CN114816381A (en) | Construction engineering MBD three-dimensional labeling method, electronic equipment and storage medium | |
| CN114398071A (en) | Control logic configuration implementation method and system of control system | |
| CN104573176A (en) | AutoCAD (computer -aided design) based electrical system data management unit | |
| CN117708911A (en) | Building axis network coordinate rapid labeling method based on CAD | |
| CN116452756A (en) | Three-dimensional scene local automatic generation method, device, equipment and storage medium | |
| CN114090611A (en) | Method and device for generating cable inventory by terminal wiring table and electronic equipment | |
| CN114297766A (en) | Engineering structure three-view joint design method based on AutoCAD and DotNET | |
| CN115115787A (en) | Method for converting two-dimensional drawing into 3D model based on DirectVR | |
| CN114092641A (en) | Method, device and equipment for generating wiring board drawing and readable storage medium | |
| CN111783373A (en) | Topology analysis method of PSCAD simulation model | |
| CN109064557A (en) | A kind of method, system, terminal and medium carrying out 3D modeling by drawing data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |