CN115544620A - Method, device and equipment for analyzing door and window tables in drawing and storage medium - Google Patents
Method, device and equipment for analyzing door and window tables in drawing and storage medium Download PDFInfo
- Publication number
- CN115544620A CN115544620A CN202211211510.4A CN202211211510A CN115544620A CN 115544620 A CN115544620 A CN 115544620A CN 202211211510 A CN202211211510 A CN 202211211510A CN 115544620 A CN115544620 A CN 115544620A
- Authority
- CN
- China
- Prior art keywords
- door
- target
- cell
- position information
- window
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/13—Architectural design, e.g. computer-aided architectural design [CAAD] related to design of buildings, bridges, landscapes, production plants or roads
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
- G06F16/86—Mapping to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V30/00—Character recognition; Recognising digital ink; Document-oriented image-based pattern recognition
- G06V30/40—Document-oriented image-based pattern recognition
- G06V30/41—Analysis of document content
- G06V30/414—Extracting the geometrical structure, e.g. layout tree; Block segmentation, e.g. bounding boxes for graphics or text
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V30/00—Character recognition; Recognising digital ink; Document-oriented image-based pattern recognition
- G06V30/40—Document-oriented image-based pattern recognition
- G06V30/42—Document-oriented image-based pattern recognition based on the type of document
- G06V30/422—Technical drawings; Geographical maps
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Geometry (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Multimedia (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Computer Hardware Design (AREA)
- Artificial Intelligence (AREA)
- Mathematical Analysis (AREA)
- Computational Mathematics (AREA)
- Architecture (AREA)
- Mathematical Optimization (AREA)
- Pure & Applied Mathematics (AREA)
- Evolutionary Computation (AREA)
- Structural Engineering (AREA)
- Computer Graphics (AREA)
- Civil Engineering (AREA)
- Data Mining & Analysis (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The application relates to a method, a device, equipment and a storage medium for analyzing a door and window table in a drawing, wherein the method comprises the following steps: extracting door and window table data from a CAD drawing; the door and window table data comprises position information and corresponding text data of each cell forming the door and window table, and the range of the door and window table; identifying target cells of which the text data accord with the specified characteristics from all the cells; acquiring attribute information corresponding to the target cell according to the range of the door and window table, the position information of each cell and the position information of the target cell; and carrying out structured storage on the target cell and each attribute information corresponding to the target cell. This application is used for solving in the building plan door and window table and needs manual inspection, leads to the problem of inefficiency.
Description
Technical Field
The application relates to the field of drawings, in particular to a door and window table analysis method, device and equipment in drawings and a storage medium.
Background
In the plan view of the building, a lot of door and window components are drawn, and are shown to the constructor in the form of door and window numbers, and in the process of examining the drawing, if the constructor wants to know the information such as the fire-proof grade, the material, the opening size and the like of a door or a window with a certain number, the examiner needs to check the information in a door and window table in a door and window large-scale drawing.
Therefore, how to improve the auditing efficiency of the door and window tables in the building plan is a problem to be solved.
Disclosure of Invention
The application provides a method, a device, equipment and a storage medium for analyzing a door and window table in a drawing, which are used for solving the problem of low efficiency caused by manual inspection of the door and window table in a building plan.
In a first aspect, an embodiment of the present application provides a method for analyzing a door and window table in a drawing, including:
extracting door and window table data from a CAD drawing; the door and window table data comprises position information and corresponding text data of each cell forming the door and window table and a range of the door and window table;
identifying target cells of which the text data accord with the specified characteristics from the cells;
acquiring attribute information corresponding to the target cell according to the range of the door and window table, the position information of each cell and the position information of the target cell;
and carrying out structured storage on the target cell and each attribute information corresponding to the target cell.
Optionally, extracting the door and window list data from the CAD drawing includes:
and analyzing the table data of each drawing frame of the CAD drawing, and extracting the table data which does not comprise the size marking information from the table data obtained by analysis to be used as door and window table data.
Optionally, identifying a target cell, from the cells, of which the text data conforms to the specified feature includes:
the door and window number naming characteristics are used as designated characteristics;
and identifying the door and window number unit cells of which the text data accord with the door and window number naming characteristics from the unit cells to serve as the target unit cells.
Optionally, obtaining each attribute information corresponding to the target cell according to the range of the door and window table, the position information of each cell, and the position information of the target cell, includes:
determining a target attribute search range corresponding to the target cell in the door and window table according to the position information of the target cell and the range of the door and window table; the target attribute search range is as follows: in the range of the door and window table, a search range is formed by the unit grids which have the same Y-axis coordinate with the target unit grid;
and extracting target attribute information corresponding to the target cell from each cell of which the position information falls into the target attribute searching range.
Optionally, extracting target attribute information corresponding to the target cell from each cell whose position information falls in the target attribute search range includes:
searching the keywords of the text related to the material quality from each cell of which the position information falls into the target attribute searching range to obtain a material quality text;
performing fusion de-duplication processing on the obtained material texts;
and determining corresponding material attribute information of the target cell according to the material text subjected to the fusion and de-duplication processing.
Optionally, extracting target attribute information corresponding to the target cell from each cell whose position information falls in the target attribute search range includes:
searching relevant text keywords of the fire-protection level from each cell of which the position information falls into the target attribute searching range to obtain a fire-protection level text;
performing fusion de-duplication processing on the acquired fire-proof grade text;
and determining the fire-rating attribute information corresponding to the target cell according to the fire-rating text subjected to the fusion and de-duplication processing.
Optionally, extracting target attribute information corresponding to the target cell from each cell whose position information falls in the target attribute search range includes:
obtaining cells corresponding to the opening size from each cell of which the position information falls into the target attribute searching range; the determination process of the unit cell corresponding to the opening size comprises the following steps: grouping the cells in columns according to the X-axis coordinate in the position information of the cells; extracting a target column comprising the key words of the opening size from the key words of each column obtained after grouping; taking the cells belonging to the target column in the target attribute searching range as the cells corresponding to the opening size;
acquiring the size data of the opening from the cells corresponding to the size of the opening;
analyzing the hole size data to obtain hole size data corresponding to the target cell; the opening size data comprises an opening width and an opening height.
In a second aspect, an embodiment of the present application provides a device for analyzing a door and window table in a drawing, including:
the extraction module is used for extracting door and window list data from the CAD drawing; the door and window table data comprises position information and corresponding text data of each cell forming the door and window table, and the range of the door and window table;
the identification module is used for identifying target cells of which the text data accord with the specified characteristics from all the cells;
the acquisition module is used for acquiring each attribute information corresponding to the target cell according to the range of the door and window table, the position information of each cell and the position information of the target cell;
and the storage module is used for carrying out structured storage on the target cell and each attribute information corresponding to the target cell.
In a third aspect, an embodiment of the present application provides an electronic device, including: the system comprises a processor, a memory and a communication bus, wherein the processor and the memory are communicated with each other through the communication bus;
the memory for storing a computer program;
the processor is configured to execute the program stored in the memory to implement the method according to any one of the first aspect.
In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, which stores a computer program, and when the computer program is executed by a processor, the computer program implements the method of any one of the first aspect.
Compared with the prior art, the technical scheme provided by the embodiment of the application has the following advantages: according to the method provided by the embodiment of the application, after door and window table data are extracted from a CAD drawing, target unit cells with text data meeting specified characteristics are identified from all unit cells included in the door and window table data, all attribute information corresponding to the target unit cells is obtained based on the position information of the target unit cells, the range of the door and window table and the position information of the unit cells in the door and window table, and therefore the mapping relation between the target unit cells and all attribute information corresponding to the target unit cells is obtained and then structured storage is carried out.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the invention and together with the description, serve to explain the principles of the invention.
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without inventive exercise.
FIG. 1 is a schematic flow chart of a method for analyzing a door and window list in a drawing in the embodiment of the present application;
FIG. 2 is a schematic structural diagram of a door/window watch according to an embodiment of the present disclosure;
FIG. 3 is a schematic structural diagram of a door/window table parsing apparatus in the drawings in the embodiment of the present application;
fig. 4 is a schematic structural diagram of an electronic device in an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in 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 obvious that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
In the embodiment of the present application, a method for analyzing a door and window sheet in a drawing is provided, and the method may be applied to any electronic device, as shown in fig. 1, and the method for analyzing a door and window sheet in a drawing mainly includes the following steps:
In an exemplary embodiment, extracting the fenestration data from the CAD drawings comprises: and analyzing the table data of each drawing frame of the CAD drawing, and extracting the table data which does not comprise the size marking information from the table data obtained by analysis to be used as door and window table data.
The analysis of the table data of each drawing frame of the CAD drawing may specifically be: determining the category information of each table line in a drawing frame and determining the coordinate information of each text drawing block in the drawing frame; projecting the table lines to corresponding coordinate axes according to the category information to obtain projection areas; determining at least one table area in the drawing frame according to the projection area; determining the intersection point coordinates of the table lines in each table area according to the category information; determining coordinate information of each cell area in each table area according to the intersection point coordinates and the category information; and generating a mapping relation between each text block and each cell area according to the coordinate information of each text block and the coordinate information of each cell area in each table area. The method is used for determining the vertex coordinates of each cell line segment according to the position information and the projection area of the table line, accurately constructing the cells of the table, mapping the text image blocks in the cells according to the text coordinates, grouping and splicing the text image blocks into accurate character contents according to the text coordinates, and improving the identification accuracy and the identification efficiency of the table.
The drawing frame is a line frame for defining a drawing area on the drawing, the drawing frame is drawn on the periphery of the drawing to mark the drawing range of the drawing, a plurality of drawing frames can be contained in one CAD drawing, and the scheme can respectively identify the form information in each drawing frame. The table lines are line segments forming a table in a picture frame, all straight lines and multiple lines in the picture frame range are obtained, the multiple lines are broken into straight lines according to bending points to obtain each table line, and the multiple lines are used for indicating that at least one bending point exists in one line. The category information is used for indicating the category of the table line, and may include: for example, when the horizontal coordinates of two vertexes of a table line are the same, the category information is determined to be a vertical table line, when the vertical coordinates of two vertexes of a table line are the same, the category information is determined to be a horizontal table line, and when the vertical coordinates and the horizontal coordinates of two vertexes of a table line are different, the category information is determined to be other table lines. Dividing the text in the picture frame into text picture blocks according to a preset text splitting rule, wherein the text splitting rule is used for splitting the text according to the combination rule of the characters, the reading habit of a user and the recognition rule of a computer, and using a single character or a single word group obtained after splitting as a text picture block. The coordinate information is used to indicate coordinates of the text tile in the frame.
The coordinate axis is an abscissa axis parallel to the horizontal frame of the picture frame and an ordinate axis parallel to the vertical frame of the picture frame, and the projection mode can be as follows: the method comprises the steps of projecting table lines parallel to an abscissa axis to the abscissa axis, combining projection areas overlapped on the abscissa axis into one projection area to obtain a horizontal projection area, projecting table lines parallel to an ordinate axis to the ordinate axis, and combining projection areas overlapped on the ordinate axis into one projection area to obtain a vertical projection area.
The table area is an area range where each table in the picture frame is located, rectangular areas correspondingly formed in the picture frame are determined according to each horizontal projection area and each vertical projection area, and overlapped parts in each rectangular area can be combined to obtain the table area. The table area can be one or more, and each table area contains a table line. And determining the intersection points of the horizontal table lines and the vertical table lines according to the category information of each table line, and determining the coordinates of the intersection points in each table area in a picture frame as intersection point coordinates.
Dividing a vertical table line and a parallel table line where the intersection points are located into single cell lattice sub-lines according to intersection point positions according to intersection point coordinates, wherein the cell lattice sub-lines are line segments of each minimum rectangular cell in the table and comprise two vertical lattice lines and two horizontal lattice lines, the four lattice lines are connected through four adjacent intersection points to form a cell, determining an area defined by coordinates corresponding to the four intersection points of the cell as a cell area, each cell area is connected with each other through the corresponding four intersection points to generate each corresponding table, and determining coordinate information of each cell area according to two intersection point coordinates located on diagonal lines in the four intersection points.
The mapping relation is that one or more text blocks correspond to one cell area, whether the coordinate information of the text blocks is in the coordinate range corresponding to the cell area or not is judged, and the mapping relation is established between the text blocks of which the coordinate information is in the coordinate range of the cell area and the corresponding cells. The mapping relation is used for determining the text blocks corresponding to the unit cell areas.
It should be noted that, in the embodiment of the present application, a specific analysis manner of the form data of the drawing frame in the CAD drawing is not limited, and other analysis manners may also be used to obtain the form data from the CAD drawing.
The inventor summarizes the characteristic that the size label does not exist in the range of the door and window table by analyzing different drawing characteristics of the door and window table in the door and window big sample drawing, but the size labels exist in other types of tables, and based on the characteristic, effective door and window table data are extracted from the table analysis result of the CAD drawing.
And 102, identifying target cells of which the text data accord with the specified characteristics from the cells.
In an exemplary embodiment, identifying a target cell, from among the cells, for which the text data conforms to the specified feature includes: the door and window number naming characteristics are used as designated characteristics; and identifying the door and window number cells of which the text data accord with the door and window number naming characteristics from the cells as the target cells.
The door and window number naming features can be configured in advance, specifically, technical personnel can configure the door and window number naming features to the electronic equipment through a man-machine interaction interface, and the electronic equipment screens out target cells which accord with the door and window number naming features from text data of the cells based on the door and window number naming features. For example, the door and window number naming characteristics are English letters + Arabic numerals; or the door and window number naming characteristics are English letters and Arabic numerals, and the number of the characters is not less than 5. The door and window number naming features are only exemplified here, and there may be various door and window number naming features in application, and the scope of protection of the present application is not limited thereto.
Step 103, acquiring each attribute information corresponding to the target cell according to the range of the door and window table, the position information of each cell and the position information of the target cell.
In an exemplary embodiment, acquiring each attribute information corresponding to the target cell according to the range of the door and window table, the position information of each cell, and the position information of the target cell includes: determining a target attribute search range corresponding to the target cell in the door and window table according to the position information of the target cell and the range of the door and window table; the target attribute search range corresponding to any one target cell is as follows: in the range of the door and window table, the search range is formed by the cells with the same Y-axis coordinate as the target cell; and extracting target attribute information corresponding to the target cell from each cell of which the position information falls into the target attribute searching range.
In the door and window table shown in fig. 2, each cell in the design number column is a target cell that meets the naming characteristics of the door and window number. Taking one of the target cells as an example, the attribute search range corresponding to the target cell is a dashed line framed part in fig. 2, and each cell in the dashed line framed part includes attribute information belonging to the target cell, that is, target attribute information.
The target attribute information is various and changes according to the difference of the information included in the actual door and window table, including but not limited to: the material, fire-proof grade and opening size of the door and window.
The range of the door and window table refers to a range defined by a boundary of the door and window table, and the boundary can be overlapped with a cell part line segment of a boundary position of the door and window table or a cell slightly exceeding the boundary position so as to frame each cell of the door and window table in the range of the door and window table.
In an exemplary embodiment, extracting target attribute information corresponding to the target cell from each cell whose position information falls in the target attribute search range includes: searching the keywords of the material related text from each cell of which the position information falls into the target attribute searching range to obtain a material text; performing fusion de-duplication processing on the obtained material texts; and determining corresponding material attribute information of the target cell according to the material text subjected to the fusion and de-duplication processing.
For example, for a target attribute search range corresponding to any one target cell, each cell falling into the target attribute search range is traversed, and a text including a material-related text keyword is extracted from the text of each cell, as a material text, for example, 'wood', 'aluminum alloy', 'plastic', 'rigid \ plastic steel \ reinforced concrete', 'metal', 'glass', and the like. And performing fusion de-duplication processing on the obtained material texts to remove redundant data in the material texts, and taking the result after the fusion de-duplication processing as the material attribute information corresponding to the target cell.
In an exemplary embodiment, extracting target attribute information corresponding to the target cell from each cell whose position information falls in the target attribute search range includes:
searching relevant text keywords of the fire-retardant rating from each cell of which the position information falls into the target attribute searching range to obtain a fire-retardant rating text; performing fusion de-duplication processing on the acquired fire-proof grade text; and determining the fire-proof grade attribute information corresponding to the target cell according to the fire-proof grade text subjected to fusion and de-duplication processing.
For example, for a target attribute search range corresponding to any one target cell, each cell falling into the target attribute search range is traversed, and a text including a text keyword related to a fire-protection level is extracted from the text of each cell as a fire-protection level text, such as a first level, a second level, a third level, and the like. And performing fusion de-duplication processing on the obtained fire-protection level text to obtain redundant data in the fire-protection level text, and taking the result after the fusion de-duplication processing as fire-protection level attribute information corresponding to the target cell.
In an exemplary embodiment, extracting target attribute information corresponding to the target cell from each cell whose position information falls in the target attribute search range includes:
obtaining cells corresponding to the size of the opening from each cell of which the position information falls into the target attribute searching range; the determination process of the cells corresponding to the opening size comprises the following steps: grouping the cells in columns according to the X-axis coordinate in the position information of the cells; extracting a target column comprising the key words of the opening size from the key words of each column obtained after grouping; taking the cells belonging to the target column in the target attribute searching range as the cells corresponding to the opening size;
acquiring hole size data from the cells corresponding to the hole sizes;
analyzing the hole size data to obtain hole size data corresponding to the target cell; the hole size data comprises a hole width and a hole height.
For example, with reference to the location information of each cell in the door/window table, the cells are grouped in columns according to the X-axis coordinate of the cell (which may be the X-axis coordinate of a specified vertex of the cell, such as the X-axis coordinate of an upper left vertex or the X-axis coordinate of a lower left vertex) (e.g., the cells with the same X-axis coordinate of the upper left vertex belong to a group); identifying keywords grouped in each column, wherein the keywords are text data belonging to a first row of cells in a table (the first row of cells are determined according to Y-axis coordinates of a group of cells, namely the cells corresponding to the maximum value in the Y-axis coordinates are the first row of cells in the group), obtaining a target column comprising an opening size keyword by identifying keywords such as 'size', 'opening' or 'opening size', and for any target cell (such as any one cell in a design number column), obtaining opening size data (such as 900 2100) from cells overlapped with the target column in a target attribute search range of the target cell, and analyzing the opening size data to obtain an opening width (such as 900) and an opening height (such as 2100) as opening size data corresponding to the target cell.
It should be noted that, the attribute information is only taken as an example of the material, the fire-proof rating and the opening size, and the attribute obtaining manner of each piece of data of the door and window table is described here, it should be understood that other attributes may also be obtained in a similar manner, and a description thereof is not given here.
And 104, performing structured storage on the target cell and each attribute information corresponding to the target cell.
It should be understood that the structured storage in the embodiment of the present application refers to storing the target cell and each attribute information corresponding to the target cell into the database according to a certain set format, so as to query and read out the target cell and at least one item of attribute information corresponding to the target cell from the database.
According to the method provided by the embodiment of the application, after door and window table data are extracted from a CAD drawing, target unit cells with text data meeting specified characteristics are identified from all unit cells included in the door and window table data, all attribute information corresponding to the target unit cells is obtained based on the position information of the target unit cells, the range of the door and window table and the position information of the unit cells in the door and window table, and therefore the mapping relation between the target unit cells and all attribute information corresponding to the target unit cells is obtained and then structured storage is carried out.
Based on the same concept, the embodiment of the present application provides a device for analyzing a door and window table in a drawing, and the specific implementation of the device may refer to the description of the method embodiment, and repeated details are not repeated, as shown in fig. 3, the device mainly includes:
the extraction module 301 is used for extracting door and window list data from a CAD drawing; the door and window table data comprises position information and corresponding text data of each cell forming the door and window table and a range of the door and window table;
an identifying module 302, configured to identify a target cell, from the cells, for which text data conforms to a specified feature;
an obtaining module 303, configured to obtain, according to a range of the door/window table, the location information of each cell, and the location information of the target cell, each attribute information corresponding to the target cell;
a storage module 304, configured to store the target cell and each attribute information corresponding to the target cell in a structured manner.
Based on the same concept, an embodiment of the present application further provides an electronic device, as shown in fig. 4, the electronic device mainly includes: a processor 901, a memory 902 and a communication bus 903, wherein the processor 901 and the memory 902 communicate with each other via the communication bus 903. The memory 902 stores a program executable by the processor 901, and the processor 901 executes the program stored in the memory 902, thereby implementing the following steps:
extracting door and window table data from a CAD drawing; the door and window table data comprises position information and corresponding text data of each cell forming the door and window table and a range of the door and window table;
identifying target cells of which the text data accord with the specified characteristics from all the cells;
acquiring attribute information corresponding to the target cell according to the range of the door and window table, the position information of each cell and the position information of the target cell;
and carrying out structured storage on the target cell and each attribute information corresponding to the target cell.
The communication bus 903 mentioned in the electronic device may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The communication bus 903 may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown in FIG. 4, but that does not indicate only one bus or one type of bus.
The Memory 902 may include a Random Access Memory (RAM) or a non-volatile Memory (non-volatile Memory), such as at least one disk Memory. Alternatively, the memory may be at least one storage device located remotely from the processor 901.
The Processor 901 may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), etc., and may also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic devices, discrete gates or transistor logic devices, and discrete hardware components.
In yet another embodiment of the present application, a computer-readable storage medium is further provided, in which a computer program is stored, and when the computer program runs on a computer, the computer program causes the computer to execute the method for parsing a window-in-drawing table in the drawing described in the foregoing embodiment.
In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When implemented in software, it may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, cause the processes or functions described in accordance with the embodiments of the application to occur, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored on a computer readable storage medium or transmitted from one computer readable storage medium to another, for example, from one website site, computer, server, or data center to another website site, computer, server, or data center via wire (e.g., coaxial cable, fiber optic, digital Subscriber Line (DSL)) or wirelessly (e.g., infrared, microwave, etc.). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device, such as a server, a data center, etc., that includes one or more of the available media. The available media may be magnetic media (e.g., floppy disks, hard disks, tapes, etc.), optical media (e.g., DVDs), or semiconductor media (e.g., solid state drives), among others.
It is noted that, in this document, relational terms such as "first" and "second," and the like, are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrases "comprising a," "8230," "8230," or "comprising" does not exclude the presence of additional like elements in a process, method, article, or apparatus that comprises the element.
The above description is merely illustrative of particular embodiments of the invention that enable those skilled in the art to understand or practice the invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A door and window table analysis method in a drawing is characterized by comprising the following steps:
extracting door and window table data from a CAD drawing; the door and window table data comprises position information and corresponding text data of each cell forming the door and window table and a range of the door and window table;
identifying target cells of which the text data accord with the specified characteristics from the cells;
acquiring attribute information corresponding to the target cell according to the range of the door and window table, the position information of each cell and the position information of the target cell;
and carrying out structured storage on the target cell and each attribute information corresponding to the target cell.
2. The method of claim 1, wherein extracting the door and window list data from the CAD drawings comprises:
and analyzing the table data of each drawing frame of the CAD drawing, and extracting the table data which does not comprise the size marking information from the table data obtained by analysis to be used as door and window table data.
3. The method of claim 1, wherein identifying, from the cells, a target cell for which text data conforms to a specified characteristic comprises:
the door and window number naming characteristics are used as designated characteristics;
and identifying the door and window number unit cells of which the text data accord with the door and window number naming characteristics from the unit cells to serve as the target unit cells.
4. The method according to claim 3, wherein obtaining the attribute information corresponding to the target cell according to the range of the door and window table, the position information of each cell, and the position information of the target cell comprises:
determining a target attribute search range corresponding to the target cell in the door and window table according to the position information of the target cell and the range of the door and window table; the target attribute search range is as follows: in the range of the door and window table, a search range is formed by the unit grids which have the same Y-axis coordinate with the target unit grid;
and extracting target attribute information corresponding to the target cell from each cell of which the position information falls into the target attribute searching range.
5. The method according to claim 4, wherein extracting target attribute information corresponding to the target cell from each cell whose position information falls in the target attribute search range comprises:
searching the keywords of the text related to the material quality from each cell of which the position information falls into the target attribute searching range to obtain a material quality text;
performing fusion de-duplication processing on the obtained material texts;
and determining corresponding material attribute information of the target cell according to the material text subjected to the fusion and de-duplication processing.
6. The method according to claim 4, wherein extracting target attribute information corresponding to the target cell from each cell whose position information falls in the target attribute search range comprises:
searching relevant text keywords of the fire-retardant rating from each cell of which the position information falls into the target attribute searching range to obtain a fire-retardant rating text;
performing fusion de-duplication processing on the acquired fire-proof grade text;
and determining the fire-rating attribute information corresponding to the target cell according to the fire-rating text subjected to the fusion and de-duplication processing.
7. The method according to claim 4, wherein extracting target attribute information corresponding to the target cell from each cell whose position information falls in the target attribute search range comprises:
obtaining cells corresponding to the size of the opening from each cell of which the position information falls into the target attribute searching range; the determination process of the cells corresponding to the opening size comprises the following steps: grouping the cells in columns according to the X-axis coordinate in the position information of the cells; extracting a target column comprising the key words of the opening size from the key words of each column obtained after grouping; taking the cells belonging to the target column in the target attribute searching range as the cells corresponding to the opening size;
acquiring the size data of the opening from the cells corresponding to the size of the opening;
analyzing the hole size data to obtain hole size data corresponding to the target cell; the hole size data comprises a hole width and a hole height.
8. The utility model provides a door and window table analytical equipment in drawing which characterized in that includes:
the extraction module is used for extracting door and window list data from the CAD drawing; the door and window table data comprises position information and corresponding text data of each cell forming the door and window table, and the range of the door and window table;
the identification module is used for identifying the target cells of which the text data accord with the specified characteristics from the cells;
the acquisition module is used for acquiring various attribute information corresponding to the target cell according to the range of the door and window table, the position information of each cell and the position information of the target cell;
and the storage module is used for carrying out structured storage on the target cell and each attribute information corresponding to the target cell.
9. An electronic device, comprising: the system comprises a processor, a memory and a communication bus, wherein the processor and the memory are communicated with each other through the communication bus;
the memory for storing a computer program;
the processor, executing a program stored in the memory, implementing the method of any of claims 1-7.
10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211211510.4A CN115544620A (en) | 2022-09-30 | 2022-09-30 | Method, device and equipment for analyzing door and window tables in drawing and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211211510.4A CN115544620A (en) | 2022-09-30 | 2022-09-30 | Method, device and equipment for analyzing door and window tables in drawing and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115544620A true CN115544620A (en) | 2022-12-30 |
Family
ID=84731034
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211211510.4A Pending CN115544620A (en) | 2022-09-30 | 2022-09-30 | Method, device and equipment for analyzing door and window tables in drawing and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115544620A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115841679A (en) * | 2023-02-23 | 2023-03-24 | 江西中至科技有限公司 | Drawing sheet extraction method, system, computer and readable storage medium |
-
2022
- 2022-09-30 CN CN202211211510.4A patent/CN115544620A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115841679A (en) * | 2023-02-23 | 2023-03-24 | 江西中至科技有限公司 | Drawing sheet extraction method, system, computer and readable storage medium |
| CN115841679B (en) * | 2023-02-23 | 2023-05-05 | 江西中至科技有限公司 | Drawing form extraction method, drawing form extraction system, computer and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2021042521A1 (en) | Contract automatic generation method, computer device and computer non-volatile storage medium | |
| US8019761B2 (en) | Recording medium storing a design support program, design support method, and design support apparatus | |
| WO2021147559A1 (en) | Service data quality measurement method, apparatus, computer device, and storage medium | |
| CN111512315A (en) | Block-wise extraction of document metadata | |
| US11341319B2 (en) | Visual data mapping | |
| CN110110198B (en) | Webpage information extraction method and device | |
| CN112115130A (en) | Method, device, equipment and medium for acquiring data corresponding relation | |
| CN111553556A (en) | Business data analysis method and device, computer equipment and storage medium | |
| CN111680506A (en) | External key mapping method and device of database table, electronic equipment and storage medium | |
| CN115544620A (en) | Method, device and equipment for analyzing door and window tables in drawing and storage medium | |
| CN116682130A (en) | Method, device and equipment for extracting icon information and readable storage medium | |
| Yin et al. | An automated layer classification method for converting CAD drawings to 3D BIM models | |
| CN113837799A (en) | Intelligent business site selection method, system, equipment and readable storage medium | |
| CN110688995A (en) | Map query processing method, computer-readable storage medium and mobile terminal | |
| CN111369294A (en) | Software cost estimation method and device | |
| CN109948015B (en) | Meta search list result extraction method and system | |
| CN113486976B (en) | Automatic classification method and device for map annotation content | |
| CN113627892B (en) | BOM data identification method and electronic equipment thereof | |
| CN115238078A (en) | Webpage information extraction method, device, equipment and storage medium | |
| CN115546815A (en) | Table identification method, device, equipment and storage medium | |
| CN115186240A (en) | Social network user alignment method, device and medium based on relevance information | |
| CN110377907B (en) | Recruitment information standardization method and device | |
| CN115481240A (en) | Data asset quality detection method and detection device | |
| CN112948587A (en) | Microblog public opinion analysis method and device based on earthquake industry and electronic equipment | |
| CN114283437A (en) | Legend identification method, device, equipment and storage medium |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230711 Address after: A601, Zhongke Naneng Building, No. 06 Yuexing 6th Road, Gaoxin District Community, Yuehai Street, Nanshan District, Shenzhen City, Guangdong Province, 518063 Applicant after: Shenzhen Wanyi Digital Technology Co.,Ltd. Address before: 519085 room 105-24914, No.6 Baohua Road, Hengqin New District, Zhuhai City, Guangdong Province (centralized office area) Applicant before: WANYI TECHNOLOGY Co.,Ltd. |