CN112685382A - BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method and system - Google Patents
BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method and system Download PDFInfo
- Publication number
- CN112685382A CN112685382A CN202011565792.9A CN202011565792A CN112685382A CN 112685382 A CN112685382 A CN 112685382A CN 202011565792 A CN202011565792 A CN 202011565792A CN 112685382 A CN112685382 A CN 112685382A
- Authority
- CN
- China
- Prior art keywords
- project
- processed
- data
- information
- engineering
- 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.)
- Granted
Links
Images
Abstract
The invention discloses a BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method and system, which finish the binding of a highway engineering three-dimensional BIM model and the corresponding engineering quantity through reading, classifying and reconstructing a highway engineering electronic engineering quantity table, establish complete design information digital data containing design size, parameters and the engineering quantity table, fully display the complete design information digital data in a GIS platform, effectively serve the actual requirements of each link of construction on the engineering quantity data, end the era that the traditional engineering quantity can only transmit information through a two-dimensional drawing and a paper form, realize the digital interaction and transmission of highway engineering design stage information to a construction stage through the BIM + GIS platform, and get through the physical barriers of data transmission of each stage in the whole life cycle of highway engineering.
Description
Technical Field
The invention relates to the technical field of highway engineering three-dimensional models, in particular to a BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method and system.
Background
In the traditional highway engineering design achievement, according to the application characteristics of the current BIM technology, the method is divided into the highway geometric information of expressing design size, parameters and the like and the engineering quantity information of expressing the specific material quantity required by the highway construction. The two kinds of information are finally transmitted to the construction stage in a complete form through qualification files and are used for guiding the concrete construction of the highway engineering. At present, the generation of highway engineering quantity information is to obtain the quantity of materials required by a designed structure by a designer in the highway engineering design and calculation processes, and to record and store the quantity of the materials through Excel software. The delivery mode of the achievement of the engineering quantity table is to print out an electronic Excle form, sign and seal on the qualification document, finally bind the qualification document into a book and deliver the design achievement to the engineering project owner and the construction party.
With the concept of Building Information Modeling (BIM) proposed for the first time in 2002 by Autodesk corporation, the BIM technology is widely applied in the road engineering design stage, and the expression modes of geometric Information such as design structure parameters and dimensions in the design results can be converted into accurate three-dimensional models through traditional drawings, and then the design stage results are directly transmitted to the construction stage through the three-dimensional models through mature GIS (geographic Information system) technology. The application of the BIM + GIS technology in highway engineering is the development direction of each stage of the current highway engineering and is the inevitable trend of full digital delivery of design results. However, no scientific and effective technology can be transmitted along with the BIM model at present, the result delivery is still carried out by printing the result into a qualification file, the delivery efficiency is low, the correlation calculation of the project quantity and the model is also required to be carried out manually, the project quantity cannot be visually displayed in the model, and when the road engineering design project quantity information delivered by the paper form has errors, the defects of difficult source tracing and difficult checking exist.
Disclosure of Invention
The invention aims to overcome the defects of low delivery efficiency and difficult traceability caused by the fact that the traditional engineering quantity can only be transmitted by two-dimensional drawings and paper forms in the prior art, and provides a BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method and a system thereof, wherein the binding of a highway engineering three-dimensional BIM model and the corresponding engineering quantity is completed by reading, classifying and reconstructing a highway engineering electronic engineering quantity table, complete design information digital data containing design dimensions, parameters and the engineering quantity table is established and fully displayed in a GIS platform, the actual requirements of each link of construction on the engineering quantity data are effectively served, the era that the traditional engineering quantity can only be transmitted by two-dimensional drawings and paper forms is ended, and the digital interaction and transmission of highway engineering design stage information to a construction stage through the BIM + GIS platform are realized, and (4) getting through physical barriers of data transmission of all stages in the whole life cycle of the highway engineering.
In order to achieve the above purpose, the invention provides the following technical scheme:
a BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method comprises the following steps:
step 1: screening a plurality of original project quantity tables of the highway project by utilizing a pre-configured table name dictionary library, and screening a plurality of project quantity tables to be processed according to the table name matching degree; traversing a plurality of to-be-processed project quantity tables, and generating first attribute information of the to-be-processed project quantity tables according to storage paths and table names of the to-be-processed project quantity tables;
traversing a plurality of to-be-processed project quantity tables to generate second attribute information of the to-be-processed project quantity tables, and representing effective data position intervals in the to-be-processed project quantity tables through the second attribute information;
step 2: polling the quantity table of the projects to be processed, searching in the effective data position interval according to a pre-established project data category dictionary base, extracting effective original data belonging to each category in the quantity table of the projects to be processed, and marking the effective original data according to the category to which the effective original data belongs;
and step 3: a constructor generates a form data function of each to-be-processed project quantity table, wherein the form data function is associated with effective original data and marks thereof in each to-be-processed project quantity table;
and 4, step 4: regrouping the plurality of to-be-processed engineering quantity tables according to an engineering quantity calculation mode, and generating a plurality of standard engineering quantity table templates according to grouping results;
structured data filling is carried out in a plurality of standard engineering quantity table templates by calling first attribute information of the to-be-processed engineering quantity table and mapping according to the form data function, so that a plurality of standard engineering quantity tables are obtained;
and 5: receiving project information input by a user, carrying out rationality check on the standard project quantity table according to the project information, and associating the project information with the standard project quantity table after the check is qualified to obtain an associated standard project quantity table; wherein the engineering information comprises: project name, project stage, road section to which project belongs and construction section interval information;
step 6: and mapping the standard work quantity table on a BIM (building information modeling) model in a GIS (geographic information system) platform through key fields so as to bind the standard work quantity table with the BIM model of the road engineering.
Preferably, in the method for extracting, classifying and reconstructing a road engineering quantity table based on BIM + GIS, traversing a plurality of to-be-processed engineering quantity tables in the first step, and generating first attribute information of the to-be-processed engineering quantity tables according to storage paths and table names of the to-be-processed engineering quantity tables, the method includes:
101, judging whether the original table name of the quantity table of the projects to be processed is the standard table name in the pre-configured table name dictionary library or not for each quantity table of the projects to be processed, and if so, entering 103; if not, entering step 102;
step 102, modifying the table name of the to-be-processed project quantity table according to the standard table name, and then entering step 103;
103, judging whether the quantity table of the projects to be processed meets the requirements or not according to a preset table version format, and if so, entering a step 105; if not, go to step 104; wherein the preset table version format is an xlsx format;
104, converting the format of the to-be-processed project quantity table according to a preset table version format, storing the to-be-processed project quantity table before and after conversion to different storage paths, and then entering step 105;
and 105, generating first attribute information of the to-be-processed project quantity table according to the table names before and after conversion and the storage paths before and after conversion.
Preferably, in the method for extracting, classifying and reconstructing a road engineering quantity table based on BIM + GIS, traversing a plurality of to-be-processed engineering quantity tables in the first step to generate second attribute information of the to-be-processed engineering quantity tables, and representing effective data position intervals in the to-be-processed engineering quantity tables through the second attribute information, the method includes:
step 201, using the printing area as the data searching area of each to-be-processed project quantity table;
step 202, searching the valid data of the to-be-processed engineering quantity table in the data search area, finding the valid data of the to-be-processed engineering quantity table, eliminating hidden lines of the to-be-processed engineering quantity table and eliminating invalid data lines, wherein the invalid data lines comprise: a total line and a sign line;
step 203, generating second attribute information of the to-be-processed engineering quantity table according to the starting line and the ending line of the effective data.
Preferably, in the method for extracting, classifying and reconstructing the road engineering quantity table based on the BIM + GIS, the pre-established engineering data category dictionary base is classified and divided according to the needs of different specialties, and is composed of data categories needed to be included by each specialty; wherein the data categories include at least: pile number information, position information, treatment height, treatment length, treatment width, first treatment type, third treatment type and material information;
wherein, stake number information includes: the stake number of starting point stake, central stake number, terminal point stake number, positional information includes: punishment position left side, punishment position right side, punishment length includes: left side punishment length, right side punishment length, central punishment length, punishment width includes: left side treatment width, right side treatment width, center treatment width.
Preferably, in the above method for extracting, classifying and reconstructing a road engineering quantity table based on BIM + GIS, the step 2 further includes: and checking the format normalization and the data integrity of the read valid original data, and modifying the valid original data which does not meet the requirement.
Preferably, in the method for extracting, classifying and reconstructing a road engineering quantity table based on BIM + GIS, the step of checking the format normalization and the data integrity of the read valid raw data and modifying the valid raw data which does not meet the requirement includes:
step 301, checking pile number formats in the pile number information according to the specific pile number formats of the highway engineering, and converting the pile number information which does not meet the format requirements;
and step 302, judging whether the material information is complete or not, and supplementing the blank material data.
Preferably, in the method for extracting, classifying and reconstructing a road engineering quantity table based on BIM + GIS, the regrouping of the plurality of to-be-processed engineering quantity tables according to the engineering quantity calculation manner and the generation of the plurality of standard engineering quantity table templates according to the grouping result includes:
regrouping the plurality of to-be-processed project quantity tables according to a project calculation quantity mode to obtain a plurality of groups of to-be-processed project quantity tables; aiming at each group of to-be-processed project quantity tables, a standard project quantity table template is created, wherein the standard project quantity table template comprises: the data types of all the to-be-processed project quantity tables in the group and the positions corresponding to the data of the types.
Preferably, in the method for extracting, classifying and reconstructing a road engineering quantity table based on BIM + GIS, the checking the rationality of the standard engineering quantity table according to the engineering information includes:
judging whether the pile number at the starting point of the standard project quantity table is greater than or equal to the pile number at the end point according to the actual geographic information of the road section to which the project belongs, if so, judging that the pile number is reasonable; if not, the cell is colored and marked;
judging whether the routes of the pile numbers are the same or not, if so, judging the routes to be reasonable; if not, the cell is colored and marked;
judging whether the pile number range of the standard engineering quantity table is correct or not according to the construction section interval information, and if so, judging that the pile number range is reasonable; if not, the cell is colored and marked;
and manually modifying according to the coloring mark information, and after the manual modification, carrying out reasonableness check again until the check is qualified, and associating the project information with the standard project quantity table.
Preferably, in the above method for extracting, classifying and reconstructing a road engineering quantity table based on BIM + GIS, the step 6 further includes:
and screening out the data needing to be bound with the list item number in the standard workload table, and marking the data according to a preset WBS number and the list item number so as to perfect data information.
In a further embodiment of the present invention, a BIM + GIS-based road engineering quantity table extraction, classification and reconstruction system is provided, which includes at least one processor, and a memory communicatively connected to the at least one processor; the memory stores instructions executable by the at least one processor to enable the at least one processor to extract a classification reconstruction method based on the BIM + GIS road work quantity table.
Compared with the prior art, the invention has the beneficial effects that: the method comprises the steps of screening, processing and reading an original project quantity table, structuring original form data according to the attribute characteristics of a project type form on the premise of ensuring the data format and the content safety of the original project quantity table, and converting the original form data into a new standard electronic form; constructing complete and correct structural engineering data by an automatic and manual modification mode on a new quantity table; and finally, according to the technical characteristics of BIM and the use mode of construction links, enriching and perfecting the engineering data, and finally binding the engineering data to the three-dimensional model and displaying the three-dimensional model in a GIS platform. According to the method, a corresponding table name dictionary library and an engineering data category dictionary library are constructed by fully analyzing a highway engineering professional engineering quantity table, and the generation mode and the reconstruction mode of a structured standard table are designed to construct structured engineering quantity data capable of realizing engineering information interaction and transmission by fully mining the binding requirement of the quantity table of a BIM three-dimensional model and the use requirement of GIS platform service on the engineering quantity in a construction stage.
Description of the drawings:
fig. 1 is a flowchart of a road engineering quantity table extraction, classification and reconstruction method based on BIM + GIS according to an exemplary embodiment of the present invention.
Fig. 2 is a diagram of an engineering structure tree corresponding to a standard table according to an exemplary embodiment of the present invention.
Fig. 3 is a block diagram of a structure for extracting, classifying and reconstructing a road engineering quantity table based on BIM + GIS according to an exemplary embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to test examples and specific embodiments. It should be understood that the scope of the above-described subject matter is not limited to the following examples, and any techniques implemented based on the disclosure of the present invention are within the scope of the present invention.
Example 1
Fig. 1 shows a BIM + GIS-based road engineering quantity table extraction, classification and reconstruction method according to an exemplary embodiment of the present invention, including:
step 1: screening a plurality of original project quantity tables of the highway project by utilizing a pre-configured table name dictionary library, and screening a plurality of project quantity tables to be processed according to the table name matching degree; traversing a plurality of to-be-processed project quantity tables, and generating first attribute information of the to-be-processed project quantity tables according to storage paths and table names of the to-be-processed project quantity tables;
traversing a plurality of to-be-processed project quantity tables to generate second attribute information of the to-be-processed project quantity tables, and representing effective data position intervals in the to-be-processed project quantity tables through the second attribute information;
and step 3: a constructor generates a form data function of each to-be-processed project quantity table, wherein the form data function is associated with effective original data and marks thereof in each to-be-processed project quantity table;
and 4, step 4: regrouping the plurality of to-be-processed engineering quantity tables according to an engineering quantity calculation mode, and generating a plurality of standard engineering quantity table templates according to grouping results;
data filling is carried out in a plurality of standard engineering quantity table templates by calling first attribute information of the to-be-processed engineering quantity table and mapping according to the form data function, so that a plurality of standard engineering quantity tables are obtained;
and 5: receiving project information input by a user, carrying out rationality check on the standard project quantity table according to the project information, and associating the project information with the standard project quantity table after the check is qualified to obtain an associated standard project quantity table; wherein the engineering information comprises: project name, project stage, road section to which project belongs and construction section interval information;
step 6: and mapping the standard work quantity table on a BIM (building information modeling) model in a GIS (geographic information system) platform through key fields so as to bind the standard work quantity table with the BIM model of the road engineering.
Specifically, an original project quantity table is screened, analyzed and processed, according to industry specifications, the expression form of the final result of the project quantity table is designed to be a qualification version file, and a back electronic version Excel project quantity table is generated, modified and completed in the design process. Therefore, for the extraction of the final accurate project quantity, a truly effective project quantity table needs to be screened from all electronic Excel files and analyzed.
Screening of file names
In step 1, a standard table name dictionary (referred to as a standard table name dictionary for short) of the project number table which really needs to be analyzed and reconstructed in the industry range 'road engineering basic construction project design documentation method' is pre-established, so that all the file names of the original project number table and the standard table name dictionary are subjected to keyword fuzzy matching, and an effective original project number table is screened out according to the table name matching degree.
In the road engineering effective project quantity table, most of tables are manually drawn, the style, format and content of the tables are not fixed, and subsequent processing is required, so in the step one, specific analysis is required according to specific file names, a to-be-processed project quantity table which accords with a standard table name dictionary is found according to keyword matching degree, an initial first attribute of each table is required to be established for the to-be-processed project quantity table, and the specific attribute content is as follows:
original table names (character string types); for example, the protection project quantity sheet-20200705;
② standard table names (character string type); for example, in the roadbed protection project quantity table;
absolute path (string type) of original table.
(II) raw Table processing
For the screened Excel original project quantity table meeting the matching degree of the standard table name dictionary base, the versions of the storage formats of the Excel original project quantity table are divided into a version before 2007 (suffix: xls) and a version after 2007 (suffix: xlsx) according to different software using habits of designers. Different versions have slight differences in data formats and the like, and in order to ensure the unification of the table format and the version, and to facilitate the processing errors in the subsequent steps not to be transmitted as much as possible, in this step, the version after 2007, i.e., the table with the suffix name "xlsx", needs to be unified for two different versions.
For the processing of the original table, firstly, it should be ensured that all formats of the original table are not modified, and the security of the original project data is ensured, so in the method of converting the format of the original table of the later version 2007 (with the suffix name of "xls"), a new quantity table after upgrading is stored in a system temporary folder, and the two are associated by adding the file attribute. Therefore, the data format of the original quantity table is ensured to be safe (without any modification), and the processing format of the original quantity table is ensured to be uniform in the subsequent steps (the version format after 2007).
On the basis of the initial first attribute of the table in the step, adding the specific attribute of the processed table:
original table names (existing attributes);
second, standard table names (existing attributes);
absolute path (existing attribute) of original table;
and fourthly, temporary paths (newly added attributes in the section) after version conversion.
In conclusion, the discrimination and analysis processing work of the original project quantity table is completed. And independent and unique first attribute information is established for each table. Then, traversing the plurality of to-be-processed quantity tables to generate second attribute information of the to-be-processed quantity tables, wherein the step of representing the effective data position interval in the to-be-processed quantity tables by the second attribute information comprises the following steps:
in this step, the specific content in each original Excel quantity table is analyzed to determine whether the reading requirement is met.
Checking whether the contents in the quantity table are valid
The method comprises the steps of judging valid data in each workbook (sheet workbook) of the quantity engineering tables (a large amount of calculation process data and other annotation data exist in a plurality of quantity engineering tables). The judging method of the patent is judging and identifying the printing area.
Secondly, the header of the effective data is judged, and the effective header, namely the professional attribute of the road engineering quantity table, is searched and confirmed: starting and stopping pile numbers, treatment measures, engineering quantity, remarks and other information.
Identifying the validity of each row of data except the header in the data range: hidden lines are removed, and invalid data lines (such as totalized lines, signed lines and the like) are removed.
For the problems in the third step, the method throws out the specific problem types and positions, returns to the manual modification processing of the user, repeats the steps after the processing is completed, and finally continues to add the sheet attribute set of each sheet to the attributes in the first step, wherein the sheet attribute of each workbook specifically comprises the following information (tablelnfo):
(ii) a master table name (i.e., a standard table name);
second list names (i.e., each sheet list name);
beginning line of header data (int type);
fourthly, end line (int type) of header data;
valid engineering data start line (int type).
Accordingly, the second attribute information of the to-be-processed engineering quantity table can be generated according to the start line and the end line of the effective data, and the step 2 is performed.
Step 2: polling the quantity table of the projects to be processed, searching in the effective data position interval according to a pre-established project data category dictionary base, extracting effective original data belonging to each category in the quantity table of the projects to be processed, and marking the effective original data according to the category to which the effective original data belongs;
similarly, before this step, a data structure classification according to the basic road engineering construction project design documentation method, i.e., an engineering data category dictionary library, should be established in advance. Classifying, analyzing and sorting the contents which should appear in the project quantity table according to the edition, summarizing quantity types which correspond to different specialties and need to be classified and divided, and establishing corresponding public attributes: data set (string type). The specialties herein include: the road bed specialty, the road surface specialty, the bridge specialty, the tunnel specialty, the culvert specialty, the grade specialty, etc.
Taking the "road-based pavement" specialty as an example, the specific data types can be classified as follows: pile number information (starting point pile number, central pile number, terminal pile number), position information (left side, right side and other treatment positions of a treatment position), treatment height, treatment length (left side, right side, center), treatment width (left side, right side, center), first treatment type (with a secondary name, such as 'barricade' or 'organic slope protection' in the roadbed protection project quantity table), third treatment type (referring to 'treatment measures' in the header), material information (referring to specifically used materials, such as steel bars, concrete, earthwork, and the like, and the hierarchical relation and units of the materials) and other treatment information (without units, other information, such as 'remarks').
And then polling the quantity tables to be processed, according to the sheet table attribute information (second attribute information) obtained in the step 1 and a pre-established project data category dictionary base, traversing each quantity table to be processed, sequentially obtaining the attribute information and the data information of the quantity tables to be processed, searching in the effective data position interval of each quantity table, extracting the data of the obtained original table, extracting the effective original data belonging to each category in the quantity tables to be processed, marking the effective original data according to the category to which the effective original data belongs, and forming a first structural tree according to the marking result, so that a readable structured quantity table is formed, and the subsequent standard table mapping is facilitated. And then, checking the format normalization and the data integrity of the read valid original data, and modifying the valid original data which does not meet the requirement. And primarily screening the acquired data according to the classification rule, wherein the screened content mainly refers to human errors in manual form preparation by designers, and prompts users to modify the data.
Taking the "roadbed and pavement" specialty as an example, the specific screening rules are as follows:
pile number information: whether the pile number format is adopted (the road engineering specific pile number format);
material information: whether pile number information exists but no material information exists.
And after automatic screening and modification confirmation by a user, structurally storing the final original engineering quantity data into the system in a character string mode. Until the work of analyzing the quantity tables is completely finished, step 3 is executed, the data of each quantity table is structured, and a function is constructed to generate a form data function of each quantity table to be processed, wherein the form data function is associated with the effective original data and the marks thereof in each quantity table to be processed;
the specific data structuring information (List < FileInfo >) is as follows:
original table names (character string types);
② standard table names (character string type);
absolute path (character string type) of original table;
fourthly, temporary path (character string type) after version conversion;
single table data set (constructor, containing all valid data in table).
And 4, step 4: regrouping the plurality of to-be-processed engineering quantity tables according to an engineering quantity calculation mode, and generating a plurality of standard engineering quantity table templates according to grouping results;
specifically, data are reconstructed according to a storage mode of data selected by a user, and a mode of compiling one type of quantity table into a plurality of excels exists according to the habit of electronic Excel created by a designer in the design process; according to the calculation mode of a project amount list in a standard construction bidding document of highway engineering in the industry standard, different types of a sheet table are required to be split and independently calculated, namely according to the calculation mode, a plurality of project amount tables to be processed are regrouped to obtain a plurality of groups of project amount tables to be processed; and creating a standard engineering quantity table template aiming at each group of the to-be-processed engineering quantity tables.
For example, in "special roadbed design engineering quantity table", there are often a plurality of sub-tables: such as soft foundation treatments, frame beams, pile panel walls, etc. In the programming habit of designers, some designers can program three Excel tables: special subgrade-software treatment, special subgrade-frame beam treatment and special subgrade-pile wall treatment. However, the three tables are all different contents in the special roadbed quantity table, and in the step, the data of the three tables are required to be merged to form a new independent project quantity table;
for example, a roadbed protection project quantity table is used, wherein the shoulder wall, the cutting wall and the embankment wall are all in the table content of a Sheet work book, but the numbering principle of the project quantity list needs to number part of projects of the shoulder wall, the cutting wall and the embankment wall separately, and a treatment mode existing in one table at the same time is not beneficial to number binding, so that splitting is needed. And after the user self-defines and selects the two modes, reconstructing the result data executed by the method in the step three and storing the result data into the memory.
Wherein, the standard engineering quantity table template comprises: writing the data type of all the to-be-processed engineering quantity tables in the group and the corresponding positions of the data of the type into a new table, wherein the data type of the to-be-processed engineering quantity tables comprises the following steps: and performing structured data filling in a plurality of standard engineering quantity table templates by calling the first attribute information of the to-be-processed engineering quantity table and mapping according to the form data function to obtain a plurality of standard engineering quantity tables.
Specifically, according to the grouping rule of all the quantity tables to be processed, a standard table template which is suitable for all the data types of the quantity tables in all the groups is created for one group of quantity tables, and the standard table template comprises the following steps: all data categories and the locations where the data categories need to be stored (specified locations in Excel tables). For example, the Excel position for storing the pile number information is 3 to 5 columns; the Excel positions for storing the 'position information' are 6-8 rows; the Excel positions for storing the treatment length are 9-11 rows, and so on. For example, there are three tables ABC in a group, table A: the method comprises the steps of pile number, treatment measures, left and right sides and materials; b table: including pile number, treatment length, material; c, table: including pile number, treatment width, material, remarks. Then my "rule" is to create a rule containing: pile number, treatment measure, treatment length, width, material and remark. And copying the standard table template according to the file storage position selected by the user, renaming the standard table template according to the memory structured data information, and writing specific data in the table. Directly copying and renaming the table of the computer-aided drawing mentioned in the step one. And through the steps from one to four, completely converting all the original form data into the standard engineering quantity form which has a specific rule format and completely reserves all the original form data. The conversion process for the original quantity of work table is complete.
And 5: receiving project information input by a user, carrying out rationality check on the standard project quantity table according to the project information, and associating the project information with the standard project quantity table after the check is qualified to obtain an associated standard project quantity table; wherein the engineering information comprises: project name, project stage, road section to which project belongs and construction section interval information;
recording the project information of the project quantity table according to the input of the user
According to the user interaction interface, the relevant information with the highway engineering characteristics is bound with the individual engineering quantity table, and the engineering quantity table is enriched and perfected to serve as a part of attributes required by the construction process. The specific attribute contents are as follows:
item name (string type);
secondly, project phase (enumeration type: scheme, workmanship, initial setting and construction);
the route (main line, XX intercommunication, XX parking area, XX service area and XX junction) is covered;
fourthly, constructing the mark sections (full lines and XX mark sections).
And (II) reading and checking the legality and the specialty of the contents of all standard tables, wherein the read structure tree is shown in FIG. 2.
Reading all contents of the standard table according to the format of the standard table in the step 4, and sequentially checking the following rules of the standard table data:
whether the pile number range is in the construction section interval (construction section interval information is established separately according to the project information table)
Whether the number of the starting point pile is more than or equal to that of the terminal point pile
(iii) whether the routes of the stake numbers are the same (such as AK1+ 010-BK 1+030)
(iv) whether the material information is of a digital type (Double type)
And (4) throwing out specific problem types and quantity table positions for the problems in the first step to the fourth step, marking colors on the cells corresponding to the error data, returning to the manual modification processing of the user, and repeating the steps after the processing is finished. And finally, after the data packet is checked to be correct, reading and generating the data packet according to the fixed structure rule. In the engineering data structure defined in this patent, the following data structure needs to be specified: project (e.g. XX highway construction drawing design project) -route type (e.g. main line, XX intercommunication, XX service area, XX parking area, etc.) -route name (K, Z1K, AK, CK, etc.). The division of the hierarchical structure enables the number of the engineering quantity table hierarchies to be consistent under different conditions, and the data structure of the quantity table is used beneficially. The specific structural rules are as follows: (see the attached drawing for the details of the tree structure).
Quantity table background information:
the background information comprises the specific positioning of the quantity table in the project and is beneficial to the management and calling of the quantity table at the project level. The total includes a project name (projectame), a construction section (construction section), a design stage (projectage), and the like.
Number table attribute information:
the number table attribute information refers to the characteristics of the number table itself for retrieval of the number table by a key and for distinction of the number table in the case of the same number table background information. The total number comprises the absolute path (MainTableName) of the number table and the route type (alignmenttype) to which the number table belongs.
Quantity table data information:
the quantity table data information, i.e. all data of the engineering quantity table itself, and the reconstructed general information extraction include but are not limited to: pile number information, position information, treatment measure information, material information, treatment type information, route range information, and the like. The data information has a deeper hierarchical structure, which is described in detail in the attached drawings. On the master node, the above information can be divided into two types of route data range set information (List < alignscene >) and List < project data >).
Third, standard table normalized naming and data serialization storage normalized naming
After the data inspection is completed and the structured storage is performed in the memory, the data needs to be rolled out and stored. In order to quickly acquire the background attribute of the quantity table, the file name of the standard table is set in a standard manner in the step, and the specific setting content is as follows: the method comprises the steps of drawing number, standard file name, construction section and route type, and setting item names at fixed unit grid positions of a numerical table. The file renaming and the file fixed cell content are regularly set, so that the requirements of related compiling methods are met, and the background information of the quantity table can be rapidly stored and read; and (2) performing serialized storage on the structural data in the second step, and performing naming specification on the xml file: project name + construction section + route type. This data format helps a particular user to quickly retrieve the corresponding desired information from the filename.
Standard table naming example:
quantity of earth and stone in every kilometer of S6-3-2-9 roadbed JN4 table of intercommunication of terrace xlsx
Serialized data file naming example:
g4216 line-Jinyang to Ningnan section-XJ 27-Main line. xml
Step six: deepening engineering quantity data according to construction requirements
And after the fifth step is finished, basically finishing the structuralization work of the design project quantity table, and meeting various data operations in the design stage, such as construction section division, statistical analysis of certain project data, data judgment under specific conditions and the like. However, in the application of data in the construction stage, the data subdivision item is divided (hereinafter referred to as WBS) and the project amount list item number (preset WBS classification number on the project) is bound with the property of a specific material. Therefore, in this step, attribute refinement is still required by performing attribute refinement on the structural attributes of the data. The perfection mode is as follows:
screening and outputting data needing to be divided into items and binding list item numbers;
manually inputting WBS number and list item number in the output list;
rereading the table with WBS number and list item number to perfect attribute structure;
taking material information as an example, the specific engineering quantity to be bound is generally part of the material information. Such as: a retaining wall comprising: 30 square concrete, 5Kg of steel bar, 0.5 square gravel and 2 square meters asphalt flax. The data needing to bind the list item number is as follows: concrete with the weight of 30 square and steel bars with the weight of 5 Kg; the remaining number is one that does not require a binding list item number.
Further, step six also includes: and binding and applying the engineering quantity data, namely mapping the standard work quantity table on a BIM (building information modeling) model in a GIS (geographic information system) platform through key fields so as to bind with the BIM model of the road engineering.
And D, accurately determining specific items, affiliated routes and route pile numbers required to be bound by the engineering quantity through the finally obtained result of the step five, clicking the BIM model in the GIS platform through mapping of the key fields, and directly finding the corresponding BIM model design engineering quantity.
Secondly, in the quality inspection and evaluation in the construction link, the specific engineering needing quality evaluation and inspection and the corresponding material quantity can be quickly found in the form of a model or a structure tree according to the WBS numbering mode in the step six.
And thirdly, in the measurement payment in the construction link, according to the data format of the project amount list item number in the sixth step, the completed project amount can be quickly counted and removed, the number and the cost of the completed projects can be automatically calculated, the construction efficiency is improved, and the construction data recording quality is improved.
In the embodiment in the city, the reading of the original project quantity table can be finished by executing the form preprocessing from the first step to the third step, so that the structured carding of the highway project electronic project quantity table is realized, and the problem that the electronic project quantity table cannot be uniformly managed in the design process at the current stage is solved. The engineering quantity table structuralization principle improves the data processing efficiency in the design process. And D, completing the conversion from the original engineering quantity table to the standard table through the classification reconstruction in the step four, unifying the style and the type of the road engineering quantity table from the data and standard template level, and realizing the standardized management of the electronic engineering quantity table. And finally, reading and binding the standard table by executing the fifth step, binding the project information of the standard table, completing the structured storage of the engineering quantity table, checking design engineering quantity errors by a computer assistant section, automatically dividing standard sections, comparing scheme data and quickly inquiring engineering quantity, and solving the problem that the existing work is purely manually calculated, checked and modified. Furthermore, the standard engineering quantity table obtained in the steps can be directly used for binding with the engineering quantity list item number, in the field of highway engineering design, the corresponding relation between the engineering quantity list item number and specific materials is systematically completed, so that the engineering quantity list establishment work in the design stage is shortened to 1-2 hours from a few weeks, and in links needing the design engineering quantity, such as measurement payment and quality evaluation in the construction stage, the problem that data personnel manually turn over a large number of drawings to inquire the engineering quantity in the current construction stage is solved. The method has the advantages that the corresponding project quantity table and the model are mapped in the BIM + GIS platform, the construction stage process is effectively completed, the binding is completed in the design stage by the branch work, and the links of the design project quantity such as the measurement payment and the quality evaluation in the construction stage are needed, so that the problem that at present, construction stage data personnel manually turn over a large number of drawings to inquire the project quantity is solved.
Fig. 3 illustrates a BIM + GIS-based road work quantity table extraction, classification and reconstruction system according to an exemplary embodiment of the present invention, namely, an electronic device 310 (e.g., a computer server with program execution function) including at least one processor 311, a power supply 314, and a memory 312 and an input/output interface 313 communicatively connected to the at least one processor 311; the memory 312 stores instructions executable by the at least one processor 311, the instructions being executable by the at least one processor 311 to enable the at least one processor 311 to perform a method disclosed in any one of the embodiments; the input/output interface 313 may include a display, a keyboard, a mouse, and a USB interface for inputting/outputting data; the power supply 314 is used to provide power to the electronic device 310.
Those skilled in the art will understand that: all or part of the steps for realizing the method embodiments can be completed by hardware related to program instructions, the program can be stored in a computer readable storage medium, and the program executes the steps comprising the method embodiments when executed; and the aforementioned storage medium includes: various media that can store program codes, such as a removable Memory device, a Read Only Memory (ROM), a magnetic disk, or an optical disk.
When the integrated unit of the present invention is implemented in the form of a software functional unit and sold or used as a separate product, it may also be stored in a computer-readable storage medium. Based on such understanding, the technical solutions of the embodiments of the present invention may be essentially implemented or a part contributing to the prior art may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the methods described in the embodiments of the present invention. And the aforementioned storage medium includes: a removable storage device, a ROM, a magnetic or optical disk, or other various media that can store program code.
The foregoing is merely a detailed description of specific embodiments of the invention and is not intended to limit the invention. Various alterations, modifications and improvements will occur to those skilled in the art without departing from the spirit and scope of the invention.
Claims (10)
1. A BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method comprises the following steps:
step 1: screening a plurality of original project quantity tables of the highway project by utilizing a pre-configured table name dictionary library, and screening a plurality of project quantity tables to be processed according to the table name matching degree; traversing a plurality of to-be-processed project quantity tables, and generating first attribute information of the to-be-processed project quantity tables according to storage paths and table names of the to-be-processed project quantity tables;
traversing a plurality of to-be-processed project quantity tables to generate second attribute information of the to-be-processed project quantity tables, and representing effective data position intervals in the to-be-processed project quantity tables through the second attribute information;
step 2: polling the quantity table of the projects to be processed, searching in the effective data position interval according to a pre-established project data category dictionary base, extracting effective original data belonging to each category in the quantity table of the projects to be processed, and marking the effective original data according to the category to which the effective original data belongs;
and step 3: a constructor generates a form data function of each to-be-processed project quantity table, wherein the form data function is associated with effective original data and marks thereof in each to-be-processed project quantity table;
and 4, step 4: regrouping the plurality of to-be-processed engineering quantity tables according to an engineering quantity calculation mode, and generating a plurality of standard engineering quantity table templates according to grouping results;
structured data filling is carried out in a plurality of standard engineering quantity table templates by calling first attribute information of the to-be-processed engineering quantity table and mapping according to the form data function, so that a plurality of standard engineering quantity tables are obtained;
and 5: receiving project information input by a user, carrying out rationality check on the standard project quantity table according to the project information, and associating the project information with the standard project quantity table after the check is qualified to obtain an associated standard project quantity table; wherein the engineering information comprises: project name, project stage, road section to which project belongs and construction section interval information;
step 6: and mapping the standard work quantity table on a BIM (building information modeling) model in a GIS (geographic information system) platform through key fields so as to bind the standard work quantity table with the BIM model of the road engineering.
2. The method of claim 1, wherein traversing a plurality of the quantity to be processed tables in the first step, and generating the first attribute information of the quantity to be processed tables according to the storage path and the table name of the quantity to be processed tables comprises:
101, judging whether the original table name of the quantity table of the projects to be processed is the standard table name in the pre-configured table name dictionary library or not for each quantity table of the projects to be processed, and if so, entering 103; if not, entering step 102;
step 102, modifying the table name of the to-be-processed project quantity table according to the standard table name, and then entering step 103;
103, judging whether the quantity table of the projects to be processed meets the requirements or not according to a preset table version format, and if so, entering a step 105; if not, go to step 104; wherein the preset table version format is an xlsx format;
104, converting the format of the to-be-processed project quantity table according to a preset table version format, storing the to-be-processed project quantity table before and after conversion to different storage paths, and then entering step 105;
and 105, generating first attribute information of the to-be-processed project quantity table according to the table names before and after conversion and the storage paths before and after conversion.
3. The method of claim 2, wherein traversing a plurality of the quantity to be processed tables in the first step, generating second attribute information of the quantity to be processed tables, and characterizing valid data location intervals in the quantity to be processed tables by the second attribute information comprises:
step 201, using the printing area as the data searching area of each to-be-processed project quantity table;
step 202, searching the valid data of the to-be-processed engineering quantity table in the data search area, finding the valid data of the to-be-processed engineering quantity table, eliminating hidden lines of the to-be-processed engineering quantity table and eliminating invalid data lines, wherein the invalid data lines comprise: a total line and a sign line;
step 203, generating second attribute information of the to-be-processed engineering quantity table according to the starting line and the ending line of the effective data.
4. The method of claim 1, wherein the pre-established project data category dictionary base is classified and divided according to the needs of different specialties, and is composed of data categories needed to be included by each specialty; wherein the data categories include at least: pile number information, position information, treatment height, treatment length, treatment width, first treatment type, third treatment type and material information;
wherein, stake number information includes: the stake number of starting point stake, central stake number, terminal point stake number, positional information includes: punishment position left side, punishment position right side, punishment length includes: left side punishment length, right side punishment length, central punishment length, punishment width includes: left side treatment width, right side treatment width, center treatment width.
5. The method of claim 4, wherein step 2 further comprises: and checking the format normalization and the data integrity of the read valid original data, and modifying the valid original data which does not meet the requirement.
6. The method of claim 5, wherein checking the read valid raw data for format normalization and data integrity, and modifying the valid raw data that does not meet the requirements, comprises:
step 301, checking pile number formats in the pile number information according to the specific pile number formats of the highway engineering, and converting the pile number information which does not meet the format requirements;
and step 302, judging whether the material information is complete or not, and supplementing the blank material data.
7. The method according to any one of claims 1 to 6, wherein said regrouping a plurality of said to-be-processed quantity tables according to a quantity-to-be-processed manner and generating a plurality of standard quantity-to-be-processed table templates according to the grouping result comprises:
regrouping the plurality of to-be-processed project quantity tables according to a project calculation quantity mode to obtain a plurality of groups of to-be-processed project quantity tables; aiming at each group of to-be-processed project quantity tables, a standard project quantity table template is created, wherein the standard project quantity table template comprises: the data types of all the to-be-processed project quantity tables in the group and the positions corresponding to the data of the types.
8. The method of claim 7, wherein said checking said standard quantity of work table for plausibility based on said project information comprises:
judging whether the pile number at the starting point of the standard project quantity table is greater than or equal to the pile number at the end point according to the actual geographic information of the road section to which the project belongs, if so, judging that the pile number is reasonable; if not, the cell is colored and marked;
judging whether the routes of the pile numbers are the same or not, if so, judging the routes to be reasonable; if not, the cell is colored and marked;
judging whether the pile number range of the standard engineering quantity table is correct or not according to the construction section interval information, and if so, judging that the pile number range is reasonable; if not, the cell is colored and marked;
and manually modifying according to the coloring mark information, and after the manual modification, carrying out reasonableness check again until the check is qualified, and associating the project information with the standard project quantity table.
9. The method of claim 8, wherein step 6 further comprises:
and screening out the data needing to be bound with the list item number in the standard workload table, and marking the data according to a preset WBS number and the list item number so as to perfect data information.
10. A BIM + GIS-based road engineering quantity table extraction, classification and reconstruction system is characterized by comprising at least one processor and a memory which is in communication connection with the at least one processor; the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method of any one of claims 1 to 9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011565792.9A CN112685382B (en) | 2020-12-25 | 2020-12-25 | BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011565792.9A CN112685382B (en) | 2020-12-25 | 2020-12-25 | BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112685382A true CN112685382A (en) | 2021-04-20 |
| CN112685382B CN112685382B (en) | 2021-07-30 |
Family
ID=75453304
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011565792.9A Active CN112685382B (en) | 2020-12-25 | 2020-12-25 | BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112685382B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113177251A (en) * | 2021-04-30 | 2021-07-27 | 四川省交通勘察设计研究院有限公司 | Road design data collaborative management method and management system based on BIM + GIS platform |
| CN114048542A (en) * | 2022-01-14 | 2022-02-15 | 四川省交通勘察设计研究院有限公司 | Visualization method and system for highway engineering data space |
| CN116127137A (en) * | 2022-11-15 | 2023-05-16 | 蜀道投资集团有限责任公司 | Highway engineering structure tree construction method, electronic equipment and computer readable medium |
| CN117093662A (en) * | 2023-10-17 | 2023-11-21 | 深圳市地铁集团有限公司 | Rail transit digital-analog fusion method, system and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20000005951U (en) * | 1998-09-05 | 2000-04-06 | 권혁중 | Manhole cover |
| CN110222445A (en) * | 2019-06-13 | 2019-09-10 | 四川省交通勘察设计研究院有限公司 | Based on BIM and the integrated of design information, collaborative design and delivery method and system |
| CN110704928A (en) * | 2019-09-29 | 2020-01-17 | 长江航道规划设计研究院 | Method for converting BIM model into GIS model |
| CN110782154A (en) * | 2019-10-23 | 2020-02-11 | 中铁十八局集团有限公司 | Construction plan management system based on BIM + GIS |
| CN110991882A (en) * | 2019-12-03 | 2020-04-10 | 中交第二航务工程勘察设计院有限公司 | Project construction fine management method based on BIM5D |
| US20200167997A1 (en) * | 2018-01-30 | 2020-05-28 | Gaia3D, Inc. | Method of providing 3d gis web service |
| CN111814240A (en) * | 2020-07-14 | 2020-10-23 | 河南省交通规划设计研究院股份有限公司 | Highway engineering agronomy worker management system based on BIM technique |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR102120680B1 (en) * | 2018-07-09 | 2020-06-09 | 서울시립대학교 산학협력단 | 3D BIM object modeling server and 3D BIM object modeling system comprising it |
-
2020
- 2020-12-25 CN CN202011565792.9A patent/CN112685382B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20000005951U (en) * | 1998-09-05 | 2000-04-06 | 권혁중 | Manhole cover |
| US20200167997A1 (en) * | 2018-01-30 | 2020-05-28 | Gaia3D, Inc. | Method of providing 3d gis web service |
| CN110222445A (en) * | 2019-06-13 | 2019-09-10 | 四川省交通勘察设计研究院有限公司 | Based on BIM and the integrated of design information, collaborative design and delivery method and system |
| CN110704928A (en) * | 2019-09-29 | 2020-01-17 | 长江航道规划设计研究院 | Method for converting BIM model into GIS model |
| CN110782154A (en) * | 2019-10-23 | 2020-02-11 | 中铁十八局集团有限公司 | Construction plan management system based on BIM + GIS |
| CN110991882A (en) * | 2019-12-03 | 2020-04-10 | 中交第二航务工程勘察设计院有限公司 | Project construction fine management method based on BIM5D |
| CN111814240A (en) * | 2020-07-14 | 2020-10-23 | 河南省交通规划设计研究院股份有限公司 | Highway engineering agronomy worker management system based on BIM technique |
Non-Patent Citations (4)
| Title |
|---|
| JOEL CARNEIRO: "BIM, GIS, IoT, and AR/VR Integration for Smart Maintenance and Management of Road Networks:a Review", 《2018 IEEE INTERNATIONAL SMART CITIES CONFERENCE (ISC2)》 * |
| MOHAMED MARZOUK: "Planning utility infrastructure requirements for smart cities using the integration between BIM and GIS", 《SUSTAINABLE CITIES AND SOCIETY》 * |
| 孙莉: "基于BIM的公路桥梁工程数字化交付方法初探", 《研究与探索》 * |
| 王维高: "BIM和GIS技术在某高速公路施工建设管理中的应用", 《山西建筑》 * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113177251A (en) * | 2021-04-30 | 2021-07-27 | 四川省交通勘察设计研究院有限公司 | Road design data collaborative management method and management system based on BIM + GIS platform |
| CN113177251B (en) * | 2021-04-30 | 2022-02-01 | 四川省交通勘察设计研究院有限公司 | Road design data collaborative management method and management system based on BIM + GIS platform |
| CN114048542A (en) * | 2022-01-14 | 2022-02-15 | 四川省交通勘察设计研究院有限公司 | Visualization method and system for highway engineering data space |
| CN114048542B (en) * | 2022-01-14 | 2022-07-15 | 四川省交通勘察设计研究院有限公司 | Visualization method and system for highway engineering data space |
| CN116127137A (en) * | 2022-11-15 | 2023-05-16 | 蜀道投资集团有限责任公司 | Highway engineering structure tree construction method, electronic equipment and computer readable medium |
| CN116127137B (en) * | 2022-11-15 | 2023-12-08 | 蜀道投资集团有限责任公司 | Highway engineering structure tree construction method, electronic equipment and computer readable medium |
| CN117093662A (en) * | 2023-10-17 | 2023-11-21 | 深圳市地铁集团有限公司 | Rail transit digital-analog fusion method, system and storage medium |
| CN117093662B (en) * | 2023-10-17 | 2024-02-02 | 深圳市地铁集团有限公司 | Rail transit digital-analog fusion method, system and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112685382B (en) | 2021-07-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112685382B (en) | BIM + GIS-based highway engineering quantity table extraction, classification and reconstruction method and system | |
| CN112270027B (en) | Paperless intelligent interactive examination method for city design based on entity model | |
| CN112685804B (en) | Highway engineering design information-based WBS automatic construction method and system | |
| Dore et al. | Integration of Historic Building Information Modeling (HBIM) and 3D GIS for recording and managing cultural heritage sites | |
| CN101477549B (en) | Knowledge base supported spatial database design method and system | |
| CN110222445A (en) | Based on BIM and the integrated of design information, collaborative design and delivery method and system | |
| Diara et al. | Open source hbim for cultural heritage: A project proposal | |
| CN114971597B (en) | BIM-based calculated amount and metering payment road cost calculation system and method | |
| CN104881762A (en) | Engineering quantity list decomposition method and system | |
| CN112685816B (en) | Model and data-based design result online delivery system and method | |
| Xu et al. | Developing an IFC-based database for construction quality evaluation | |
| CN113177251B (en) | Road design data collaborative management method and management system based on BIM + GIS platform | |
| CN112597579A (en) | Engineering project digital delivery method and system based on BIM | |
| CN115168971A (en) | Component parameter library-based integrated collaborative method for design and construction of fabricated building | |
| Zhang et al. | Monitoring and Maintenance of Highway Super-Large Bridge Based on BIM Technology | |
| Binding et al. | Automatic Normalization of Temporal Expressions | |
| Raner et al. | Regularized Reconstruction of HBIM for Built Heritage—Case Study with Chinese Ancient Architecture | |
| Wang et al. | Algorithm Modeling of Ancient Architecture for Heritage Documentation | |
| Clemen et al. | Site plan for BIM?–A free and open source plug-in for as-is vicinity models to be used in small and medium-sized BIM-projects | |
| CN117851412B (en) | Highway engineering list compiling method and system based on BIM | |
| Liang et al. | Coding structure of digital highway model and implementation of automatic encoding based on rule engine | |
| KR100588740B1 (en) | Method for constructing GIS database using cadastral map | |
| Oskar | Measuring and extracting data from a BIM model | |
| Lombardini et al. | Enhancing and managing data and digital competencies for architecture teaching and training in the field of protection of Heritage | |
| Akanbi | IFC-Based Systems and Methods to Support Construction Cost Estimation |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |