Door and window table interpretation method and device, equipment and storage medium

Abstract

The application relates to a door and window table analysis method and device in a drawing, equipment and a storage medium. The method comprises the following steps: extracting door and window table data from a CAD drawing; wherein the door and window table data comprises position information and corresponding text data of each cell constituting a door and window table, and the range of the door and window table; identifying a target cell with text data meeting a specified feature from the cells; obtaining each attribute information corresponding to the target cell according to the range of the door and window table, the position information of the cells and the position information of the target cell; and structurally storing the target cell and each attribute information corresponding to the target cell. The application is used to solve the problem that the door and window table in the building plan needs to be manually checked, resulting in low efficiency.

Description

TECHNICAL FIELD

[0001] The present 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

[0002] In the building plan, many door and window components are drawn. The door and window components are displayed to the constructors in the form of door and window numbers. In the process of checking drawings, if the fire resistance rating, material, and hole size of a certain number of doors or windows are to be known, the drawing checker must check the door and window table in the door and window detail drawing.

[0003] It can be seen that how to improve the auditing efficiency of the door and window table in the building plan is a problem to be solved. SUMMARY

[0004] The present application provides a door and window table analysis method, device and equipment in drawings and a storage medium to solve the problem that the door and window table in the building plan needs to be manually checked, resulting in low efficiency.

[0005] In a first aspect, the present application provides a door and window table analysis method in drawings, comprising:

[0006] extracting door and window table data from CAD drawings; wherein the door and window table data includes position information of each cell constituting the door and window table and corresponding text data, and a range of the door and window table;

[0007] from the cells, identifying a target cell whose text data meets a specified feature;

[0008] According to the range of the door and window table, the position information of the cells, and the position information of the target cell, obtaining each attribute information corresponding to the target cell;

[0009] structurally storing the target cell and each attribute information corresponding to the target cell.

[0010] Optionally, extracting door and window table data from CAD drawings comprises:

[0011] analyzing table data of each frame of the CAD drawing, and extracting table data not including size marking information from the analyzed table data as the door and window table data.

[0012] Optionally, from the cells, identifying a target cell whose text data meets a specified feature comprises:

[0013] naming the door and window number as the specified feature;

[0014] Identify a door and window number cell in which text data meets a door and window number naming feature as the target cell from the cells.

[0015] Optionally, according to the range of the door and window table, the position information of the cells, and the position information of the target cell, obtain attribute information corresponding to the target cell, including:

[0016] According to the position information of the target cell and the range of the door and window table, determine a target attribute search range corresponding to the target cell in the door and window table; the target attribute search range is a search range composed of cells having the same Y-axis coordinate as the target cell within the range of the door and window table.

[0017] From the cells whose position information falls within the target attribute search range, extract target attribute information corresponding to the target cell.

[0018] Optionally, from the cells whose position information falls within the target attribute search range, extract target attribute information corresponding to the target cell, including:

[0019] From the cells whose position information falls within the target attribute search range, perform material-related text keyword search to obtain material text.

[0020] Perform fusion and deduplication processing on the obtained material text.

[0021] According to the material text after the fusion and deduplication processing, determine material attribute information corresponding to the target cell.

[0022] Optionally, from the cells whose position information falls within the target attribute search range, extract target attribute information corresponding to the target cell, including:

[0023] From the cells whose position information falls within the target attribute search range, perform fireproof grade-related text keyword search to obtain fireproof grade text.

[0024] Perform fusion and deduplication processing on the obtained fireproof grade text.

[0025] According to the fireproof grade text after the fusion and deduplication processing, determine fireproof grade attribute information corresponding to the target cell.

[0026] Optionally, from the cells whose position information falls within the target attribute search range, extract target attribute information corresponding to the target cell, including:

[0027] obtaining a cell corresponding to the opening size from the cells whose position information falls into the target attribute searching range; wherein the determination of the cell corresponding to the opening size comprises: grouping the cells according to the X-axis coordinates in the position information of the cells by column; extracting a target column including the opening size keyword from the keywords of each column after grouping; and taking the cells belonging to the target column in the target attribute searching range as the cell corresponding to the opening size;

[0028] obtaining opening size data from the cell corresponding to the opening size;

[0029] parsing the opening size data to obtain opening size data corresponding to the target cell; wherein the opening size data includes opening width and opening height.

[0030] In a second aspect, an embodiment of the present application provides a device for parsing a door and window table in a drawing, comprising:

[0031] an extracting module configured to extract door and window table data from a CAD drawing; wherein the door and window table data includes position information and corresponding text data of each cell constituting a door and window table, and a range of the door and window table;

[0032] an identifying module configured to identify a target cell with text data meeting a specified feature from the cells;

[0033] an obtaining module configured to obtain attribute information corresponding to the target cell according to the range of the door and window table, the position information of the cells, and the position information of the target cell;

[0034] a storage module configured to store the target cell and the attribute information corresponding to the target cell in a structured manner.

[0035] In a third aspect, an embodiment of the present application provides an electronic device, comprising: a processor, a memory, and a communication bus, wherein the processor and the memory complete communication with each other through the communication bus;

[0036] the memory is configured to store a computer program;

[0037] the processor is configured to execute the program stored in the memory to implement the method in any one of the first aspect.

[0038] In a fourth aspect, an embodiment of the present application provides a computer readable storage medium storing a computer program, wherein the computer program is executed by a processor to implement the method in any one of the first aspect.

[0039] Compared with the prior art, the technical solution provided by the embodiment of the present application has the following advantages: the method provided by the embodiment of the present application extracts the door and window table data from the CAD drawing, identifies a target cell in which text data meets a specified feature from each cell included in the door and window table data, obtains each attribute information corresponding to the target cell based on the position information of the target cell and the range of the door and window table and the position information of the cell in the door and window table, thereby obtaining the mapping relationship between the target cell and each attribute information corresponding to the target cell, and then performing structured storage, so that the door and window table data in the CAD drawing can be stored in a structured manner, which facilitates subsequent extraction of the door and window table data in the CAD drawing from the structured storage, facilitates automatic reading of data and automatic auditing, and provides a basis for improving the viewing efficiency of the door and window table data. BRIEF DESCRIPTION OF DRAWINGS

[0040] The accompanying drawings, which are incorporated into and form a part of the specification, illustrate an embodiment consistent with the present application and, together with the description, serve to explain the principles of the application.

[0041] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the accompanying drawings required to be used in the embodiments or the prior art description will be briefly introduced as follows. Obviously, for those of ordinary skill in the art, other drawings can also be obtained based on these drawings without any creative effort.

[0042] Figure 1 A flowchart of a door and window table parsing method in a drawing in an embodiment of the present application;

[0043] Figure 2 A structure diagram of a door and window table in an embodiment of the present application;

[0044] Figure 3 A structure diagram of a door and window table parsing device in an embodiment of the present application;

[0045] Figure 4 A structure diagram of an electronic device in an embodiment of the present application. DETAILED DESCRIPTION

[0046] In order to make the objectives, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all the embodiments of the present application. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without any creative effort fall within the scope of protection of the present application.

[0047] In the embodiments of the present application, a door and window table analysis method for drawings is provided, which can be applied to any electronic device, such as a computer Figure 1 As shown in the drawings, the door and window table analysis method for drawings mainly includes the following steps:

[0048] Step 101, extracting door and window table data from CAD drawings; wherein the door and window table data includes position information of each cell constituting the door and window table and corresponding text data, and the range of the door and window table.

[0049] In the exemplary embodiments, the door and window table data is extracted from the CAD drawings, including: analyzing table data of each frame of the CAD drawings, extracting table data not including dimension mark information from the analyzed table data as door and window table data.

[0050] Wherein, analyzing table data of each frame of the CAD drawings can be specifically: determining the category information of each table line in the frame, and determining the coordinate information of each text block in the frame; projecting the table line to the corresponding coordinate axis according to the category information to obtain a projection area; determining at least one table area in the frame according to the projection area; determining the intersection coordinates of the table lines in each table area according to the category information; determining the coordinate information of each cell area in each table area according to the intersection coordinates and the category information; generating the mapping relationship between the 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. To achieve the method of determining the vertex coordinates of each cell line segment according to the position information of the table line and the projection area, accurately constructing the cells of the table, mapping the text block in the cell according to the text coordinates, and grouping and splicing the accurate text content according to the text coordinates, which improves the recognition accuracy and efficiency of the table.

[0051] The frame is a line frame that defines a drawing area on a drawing sheet, and the frame is drawn around the drawing sheet to mark the drawing range of the drawing sheet. One CAD drawing sheet can include multiple frames, and the table information in each frame can be identified respectively. The table line is a line segment that constitutes a table in the frame. All straight lines and multi-segment lines in the frame range are obtained, and the multi-segment lines are scattered into straight lines according to the bending points to obtain each table line. The multi-segment line is used to indicate that there is at least one bending point in a line. The category information is used to indicate the category of the table line, which can include horizontal table lines parallel to the horizontal frame of the frame, vertical table lines parallel to the vertical frame of the frame, and other table lines. The corresponding category information can be determined according to the coordinates of the vertex of each table line or the position in the frame. For example, when the horizontal coordinates of the two vertices of the table line are the same, the category information is determined as a vertical table line. When the vertical coordinates of the two vertices of the table line are the same, the category information is determined as a horizontal table line. When the vertical coordinates and the horizontal coordinates of the two vertices of the table line are different, the category information is determined as other table lines. The text in the frame is divided into text blocks according to the pre-set text splitting rule. The text splitting rule is used to split the text according to the combination rule of the text, the reading habit of the user, and the recognition rule of the computer. The single character or single word group obtained after splitting is taken as a text block. The coordinate information is used to indicate the coordinates of the text block in the frame.

[0052] The coordinate axis is a horizontal coordinate axis parallel to the horizontal frame of the frame and a vertical coordinate axis parallel to the vertical frame of the frame. The projection mode can be: projecting the table line parallel to the horizontal coordinate axis to the horizontal coordinate axis, merging the overlapping projection regions on the horizontal coordinate axis into one projection region to obtain a horizontal projection region, projecting the table line parallel to the vertical coordinate axis to the vertical coordinate axis, and merging the overlapping projection regions on the vertical coordinate axis into one projection region to obtain a vertical projection region.

[0053] The table region is the region range of each table in the frame. According to each horizontal projection region and vertical projection region, the corresponding rectangular region in the frame is determined, and the overlapping part in each rectangular region can be merged to obtain the table region. The table region can be one or more, and each table region includes table lines. According to the category information of each table line, the intersection of the horizontal table line and the vertical table line is determined, and the coordinates of the intersection in the frame are taken as the intersection coordinates.

[0054] According to the intersection coordinates, the vertical table lines and the parallel table lines where the intersection points are located are divided into single cell grid lines according to the positions of the intersection points, the cell grid lines are line segments of each minimum rectangular cell in the table, including two vertical grid lines and two horizontal grid lines, the four grid lines are connected by four adjacent intersection points to form a cell, and the area surrounded by the coordinates corresponding to the four intersection points of the cell is determined as a cell area, and the coordinate information of each cell area is determined according to the coordinates of the two intersection points on the diagonal line in the four intersection points.

[0055] The mapping relationship is that one or more text blocks correspond to one cell area, whether the coordinate information of the text block is in the coordinate range corresponding to the cell area is judged, and the text block with the coordinate information in the coordinate range of the cell area is mapped to the corresponding cell. The mapping relationship is used to determine the text block corresponding to the cell area.

[0056] It should be noted that the specific parsing manner of the table data of the frame in the CAD drawing is not limited in the embodiments of the present application, and other parsing manners can also be used to obtain the table data from the CAD drawing.

[0057] The inventor analyzes different drawing characteristics of the door and window table in the door and window large drawing, and summarizes that there is no "dimension mark" feature in the range of the door and window table, while there is a "dimension mark" in other types of tables. Based on this, the effective door and window table data is extracted from the table analysis result of the CAD drawing.

[0058] In step 102, from the cells, a target cell with text data meeting a specified feature is identified.

[0059] In an example embodiment, from the cells, a target cell with text data meeting a specified feature is identified, including: taking a door and window number naming feature as the specified feature; and identifying, from the cells, a door and window number cell with text data meeting the door and window number naming feature as the target cell.

[0060] The door and window number naming feature can be pre-configured, and specifically, a technical personnel can configure the electronic device through a human-computer interaction interface, and the electronic device filters the target cell meeting the door and window number naming feature from the text data of the cells based on the door and window number naming feature. For example, the door and window number naming feature is English letters + Arabic numerals; or the door and window number naming feature is English letters + Arabic numerals, and the number of characters is not less than 5. Here, only the door and window number naming feature is exemplified, and the door and window number naming feature can be various in application, and the protection scope of the present application is not limited thereto.

[0061] In step 103, according to the range of the door and window table, the position information of each cell, and the position information of the target cell, attribute information corresponding to the target cell is obtained.

[0062] In an example embodiment, according to the range of the door and window table, the position information of each cell, and the position information of the target cell, attribute information corresponding to the target cell is obtained, including: according to the position information of the target cell and the range of the door and window table, a target attribute search range corresponding to the target cell in the door and window table is determined; the target attribute search range corresponding to any target cell is a search range composed of cells having the same Y-axis coordinate as the target cell within the range of the door and window table; and target attribute information corresponding to the target cell is extracted from each cell whose position information falls within the target attribute search range.

[0063] As shown in the door and window table, Figure 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 the part enclosed by the dashed line in Figure 2 Each cell in the part enclosed by the dashed line includes attribute information belonging to the target cell, i.e., target attribute information.

[0064] The target attribute information can be various, and varies according to the information included in the actual door and window table, including but not limited to: the material of the door and window, the fireproof level, the size of the opening, etc.

[0065] The range of the door and window table refers to the range defined by the boundary of the door and window table. The boundary can coincide with part of the line segment of the cell at the boundary position of the door and window table, or can slightly exceed the cell at the boundary position to frame each cell of the door and window table within the range of the door and window table.

[0066] In an example embodiment, from each cell whose position information falls within the target attribute search range, target attribute information corresponding to the target cell is extracted, including: from each cell whose position information falls within the target attribute search range, a material-related text keyword search is performed to obtain material text; the obtained material text is subjected to fusion and deduplication processing; and according to the material text after fusion and deduplication processing, material attribute information corresponding to the target cell is determined.

[0067] For example, for the target attribute search range corresponding to any target cell, the cells falling into the target attribute search range are traversed, and the text including the material-related text keyword is extracted from the text of each cell as the material text, such as 'wood', 'aluminum alloy', 'plastic','steel reinforced concrete','metal', 'glass', and the like. The obtained material text is subjected to fusion and deduplication processing to remove redundant data in the material text, and the result after the fusion and deduplication processing is taken as the material attribute information corresponding to the target cell.

[0068] In the example embodiment, the target attribute information corresponding to the target cell is extracted from the cells whose position information falls into the target attribute search range, including:

[0069] Fire rating-related text keyword search is performed on the cells whose position information falls into the target attribute search range to obtain fire rating text, and fusion and deduplication processing is performed on the obtained fire rating text. The fire rating attribute information corresponding to the target cell is determined according to the fire rating text after the fusion and deduplication processing.

[0070] For example, for the target attribute search range corresponding to any target cell, the cells falling into the target attribute search range are traversed, and the text including the fire rating-related text keyword is extracted from the text of each cell as the fire rating text, such as Class A, Class B, Class C, and the like. The obtained fire rating text is subjected to fusion and deduplication processing to remove redundant data in the fire rating text, and the result after the fusion and deduplication processing is taken as the fire rating attribute information corresponding to the target cell.

[0071] In the example embodiment, the target attribute information corresponding to the target cell is extracted from the cells whose position information falls into the target attribute search range, including:

[0072] The cell corresponding to the opening size is obtained from the cells whose position information falls into the target attribute search range. The determination process of the cell corresponding to the opening size includes grouping the cells according to the X-axis coordinates in the position information of the cells, extracting a target column including the opening size keyword from the keywords of each column after grouping, and taking the cells belonging to the target column in the target attribute search range as the cell corresponding to the opening size.

[0073] The opening size data is obtained from the cell corresponding to the opening size.

[0074] The opening size data is analyzed to obtain the opening size data corresponding to the target cell. The opening size data includes the opening width and the opening height.

[0075] For example, referring to the position information of each cell of the door and window table, the cells are grouped by column according to the X-axis coordinates of the cells (which can be the X-axis coordinates of the specified vertex of the cell, such as the X-axis coordinates of the top-left vertex or the X-axis coordinates of the bottom-left vertex); identify the keyword of each column group, which is the text data belonging to the first row cell of the table (determined according to the Y-axis coordinates of the group of cells, that is, the cell corresponding to the maximum value in the Y-axis coordinates is the first row cell of the group); by identifying the keywords such as "size", "opening" or "opening size", the target column including the opening size keyword is obtained, and for any target cell (such as any cell in the design number column), the opening size data (such as 900*2100) is obtained from the cells in the target attribute search range of the target cell that overlap with the target column, as the opening size data corresponding to the target cell. Analyze the opening size data to obtain the opening width (such as 900) and the opening height (such as 2100).

[0076] It should be noted that only the material, fire rating and opening size are taken as examples of attribute information here to illustrate the way of obtaining each piece of data of the door and window table. It should be understood that similar methods can be used to obtain other attributes, which will not be enumerated and described here.

[0077] In step 104, the target cell and the attribute information corresponding to the target cell are stored in a structured manner.

[0078] It can be understood that the structured storage in the embodiments of the present application refers to storing the target cell and the attribute information corresponding to the target cell in a database according to a certain set format, so as to query and read out the target cell and at least one attribute information corresponding to the target cell from the database.

[0079] The method provided by the embodiments of the present application extracts the door and window table data from the CAD drawing, identifies the target cell whose text data meets the specified feature from each cell included in the door and window table data, obtains the attribute information corresponding to the target cell based on the position information of the target cell and the range of the door and window table and the position information of the cell of the door and window table, thereby obtaining the mapping relationship between the target cell and the attribute information corresponding to the target cell, and then performing structured storage, so as to structure the door and window table data in the CAD drawing, facilitate subsequent extraction of the door and window table data in the CAD drawing from the structured storage, facilitate automatic reading of data and automatic auditing, and provide a basis for improving the viewing efficiency of the door and window table data.

[0080] Based on the same concept, the embodiment of the present application provides a device for parsing a door and window table in a drawing. The specific implementation of the device can refer to the description of the method embodiment part, and the repeated parts will not be described here, such as Figure 3 As shown in the figure, the device mainly includes:

[0081] An extraction module 301 is configured to extract door and window table data from a CAD drawing. The door and window table data includes position information of each cell constituting a door and window table, corresponding text data, and a range of the door and window table.

[0082] An identification module 302 is configured to identify a target cell with text data meeting a specified feature from the cells.

[0083] An acquisition module 303 is configured to acquire attribute information corresponding to the target cell according to the range of the door and window table, the position information of the cells, and the position information of the target cell.

[0084] A storage module 304 is configured to store the target cell and the attribute information corresponding to the target cell in a structured manner.

[0085] Based on the same concept, the embodiment of the present application further provides an electronic device, as shown in the figure. The electronic device mainly includes a processor 901, a memory 902, and a communication bus 903. The processor 901 and the memory 902 communicate with each other through the communication bus 903. The memory 902 stores a program executable by the processor 901. The processor 901 executes the program stored in the memory 902 to implement the following steps: Figure 4

[0086] The door and window table data is extracted from a CAD drawing. The door and window table data includes position information of each cell constituting a door and window table, corresponding text data, and a range of the door and window table.

[0087] A target cell with text data meeting a specified feature is identified from the cells.

[0088] Attribute information corresponding to the target cell is acquired according to the range of the door and window table, the position information of the cells, and the position information of the target cell.

[0089] The target cell and the attribute information corresponding to the target cell are stored in a structured manner.

[0090] ​The communication bus 903 mentioned in the above electronic device can be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The communication bus 903 can be divided into an address bus, a data bus, a control bus, etc. For the convenience of representation, Figure 4 Only one thick line is used to represent the bus in the above-mentioned electronic device, but it does not mean that there is only one bus or only one type of bus.

[0091] The memory 902 can include a Random Access Memory (RAM) and can also include a non-volatile memory, such as at least one disk memory. Optionally, the memory can also be at least one storage device located away from the aforementioned processor 901.

[0092] The aforementioned processor 901 can be a general-purpose processor, including a Central Processing Unit (CPU), a Network Processor (NP), etc., and can also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field-Programmable Gate Array (FPGA) or other programmable logic device, a discrete gate or transistor logic device, a discrete hardware component.

[0093] In still another embodiment of the present application, a computer readable storage medium is also provided, and the computer readable storage medium stores a computer program, when the computer program runs on a computer, the computer program causes the computer to execute the door and window table analysis method described in the above-mentioned embodiments.

[0094] In the embodiments described above, all or some of the steps can be implemented by software, hardware or firmware, or any combination thereof. When implemented by software, all or some of the steps can be implemented in the form of one or more computer programs. The computer program can be stored in any computer readable medium, and loaded into the computer for execution. The computer readable medium includes: a computer storage medium and a computer communication medium. The computer storage medium includes: volatile memory and non-volatile memory. The computer storage medium includes: an electric medium, a magnetic medium, an optical medium, and a solid medium. The computer communication medium includes: computer communication networks and computer networks. The computer program can be loaded into many different computers and computers networks to implement the embodiments described in the present application.

[0095] It should be noted that the terms "first" and "second" and the like in this text are used only to distinguish one entity or action from another, and do not necessarily require or imply these entities or actions have any such actual relationship or order. Also, the terms "include", "contain" or any other variants thereof are intended to cover non-exclusive inclusion, so that processes, methods, articles or devices including a series of elements not only include those elements, but also include other elements not explicitly listed or inherent to such processes, methods, articles or devices. Without more limitations, the element defined by the statement "including a" does not exclude the presence of other identical elements in the process, method, article or device including the element.

[0096] The above description is only a specific implementation of the present application, which enables those skilled in the art to understand or implement the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein can be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to these embodiments shown herein, but will conform to the widest scope consistent with the principles and novel features applied herein.

Claims

1. A method for analyzing door and window schedules in drawings, characterized in that, The method comprises the following steps: extracting door and window table data from CAD drawings; wherein the door and window table data comprises position information of each cell constituting a door and window table and corresponding text data, and a range of the door and window table; identifying a target cell with text data meeting a specified feature from the cells; obtaining 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; structurally storing the target cell and the attribute information corresponding to the target cell; wherein identifying a target cell with text data meeting a specified feature from the cells comprises: taking a door and window number naming feature as the specified feature; identifying a door and window number cell with text data meeting the door and window number naming feature as the target cell from the cells; wherein obtaining 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 a search range composed of cells with the same Y-axis coordinate as the target cell within the range of the door and window table; extracting target attribute information corresponding to the target cell from cells with position information falling within the target attribute search range; wherein extracting target attribute information corresponding to the target cell from cells with position information falling within the target attribute search range comprises: performing material-related text keyword search on cells with position information falling within the target attribute search range to obtain material text; performing fusion and deduplication processing on the obtained material text; determining material attribute information corresponding to the target cell according to the material text after fusion and deduplication processing; or, performing fireproof grade-related text keyword search on cells with position information falling within the target attribute search range to obtain fireproof grade text; performing fusion and deduplication processing on the obtained fireproof grade text; determining fireproof grade attribute information corresponding to the target cell according to the fireproof grade text after fusion and deduplication processing.

2. The method of claim 1, wherein, Extracting door and window table data from CAD drawings comprises: parsing table data of each frame of the CAD drawings, and extracting table data not including dimension marking information from the parsed table data as door and window table data.

3. The method of claim 1, wherein, Extracting target attribute information corresponding to the target cell from cells with position information falling within the target attribute search range further comprises: obtaining a cell corresponding to the opening size from cells whose position information falls into the target attribute search range; wherein the determination of the cell corresponding to the opening size comprises: grouping the cells according to the X-axis coordinates in the position information of the cells by column; extracting a target column including an opening size keyword from the keywords of each column after grouping; and taking the cells belonging to the target column in the target attribute search range as the cell corresponding to the opening size; obtaining opening size data from the cell corresponding to the opening size; parsing the opening size data to obtain the opening size data corresponding to the target cell; wherein the opening size data includes an opening width and an opening height.

4. A device for analyzing door and window schedules in drawings, characterized in that, comprise: an extraction module configured to extract door and window table data from a CAD drawing; wherein the door and window table data includes position information and corresponding text data of each cell constituting a door and window table, and a range of the door and window table; an identification module configured to identify, from the cells, a target cell whose text data meets a specified feature; an obtaining module configured to obtain, according to the range of the door and window table, the position information of the cells, and the position information of the target cell, attribute information corresponding to the target cell; a storage module configured to store the target cell and the attribute information corresponding to the target cell in a structured manner; wherein the identification of, from the cells, a target cell whose text data meets a specified feature comprises: taking a door and window number naming feature as the specified feature; identifying, from the cells, a door and window number cell whose text data meets the door and window number naming feature as the target cell; wherein the obtaining of, according to the range of the door and window table, the position information of the cells, and the position information of the target cell, attribute information corresponding to the target cell comprises: determining, according to the position information of the target cell and the range of the door and window table, a target attribute search range corresponding to the target cell in the door and window table; wherein the target attribute search range is a search range composed of cells having the same Y-axis coordinates as the target cell within the range of the door and window table; extracting target attribute information corresponding to the target cell from cells whose position information falls into the target attribute search range; wherein the extraction of target attribute information corresponding to the target cell from cells whose position information falls into the target attribute search range comprises: performing material-related text keyword search on the cells whose position information falls into the target attribute search range to obtain material text; performing fusion and deduplication processing on the obtained material text; determining material attribute information corresponding to the target cell according to the material text after fusion and deduplication processing; or, performing fireproof grade-related text keyword search on the cells whose position information falls into the target attribute search range to obtain fireproof grade text; performing fusion and deduplication processing on the obtained fireproof grade text; According to the fire rating text after the fusion deduplication processing, the fire rating attribute information corresponding to the target cell is determined.

5. An electronic device, comprising: Comprise: A processor, a memory and a communication bus, wherein the processor and the memory complete mutual communication through the communication bus; The memory is used for storing a computer program; The processor is used for executing the program stored in the memory, and realizing the method in any one of claims 1-3.

6. A computer readable storage medium storing a computer program, characterized in that, The computer program is executed by the processor to realize the method in any one of claims 1-3.

Images