Method and device for creating rainwater pipe network information model, electronic equipment and medium

By defining the range and reference base point coordinates of the stormwater pipeline network in GIS software, reading the data table and loading it into the model library, and using Revit technology to build the stormwater pipeline network information model, the problem that the existing technology is difficult to meet the needs of efficient batch creation is achieved, and efficient , accurate construction of rainwater pipeline information model has important application value.

CN118940447AInactive Publication Date: 2024-11-12CCCC SECOND HARBOR CONSULTANTS CO LTD
View PDF 5 Cites 0 Cited by

Patent Information

Application Number
CN202411423906.4
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-10-12
Publication Date
2024-11-12
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

The existing technology is difficult to meet the needs of batch efficient rainwater pipeline information model creation, especially in the design and management of rainwater pipelines. Conventional modeling methods are difficult to meet the information of rainwater pipelines with wide coverage, many types, many specifications, large quantities and complex attributes. Model creation requirements.

Method used

By importing the geospatial database containing stormwater network elements into the GIS software, defining the stormwater network range and reference base point coordinates, reading the stormwater well and stormwater pipe data tables, and loading the corresponding model from the standardized model library, using Revit project files and databases Reading technology builds a rainwater pipeline information model to realize batch creation and automatic update of three-dimensional information model.

Benefits of technology

Improve the efficiency and accuracy of model creation, realize batch construction of rainwater pipeline information model, simplify operations, and is suitable for network collaborative design and smart pipeline construction management, solving the problem that existing technology is difficult to meet the needs of batch efficient creation. .

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118940447A_ABST
    Figure CN118940447A_ABST
Patent Text Reader

Abstract

The invention provides a building method and device of a rainwater pipe network information model, electronic equipment and a medium, and belongs to the technical field of municipal pipe networks, and the method comprises the following steps: after a geographic space database is imported into GIS software, defining a rainwater pipe network range and reference base point coordinates, and obtaining a target format file; linking the Revit project file to the target format file, reading a catch basin data table and a rainwater pipe data table from the rainwater pipe network database, loading a catch basin model from the standardized catch basin model library, and loading a rainwater pipe model from the standardized rainwater pipe model library; and constructing a rainwater pipe network information model in the Revit project file based on the rainwater well data table, the rainwater pipe data table, the rainwater well model and the rainwater pipe model. According to the method, the data table is read from the database, and the corresponding model is loaded from the model library to construct the rainwater pipe network information model, so that the problem that the existing technical scheme is difficult to meet the requirement for creating the batch and efficient rainwater pipe network information model is solved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of municipal pipe networks, and in particular to a method, device, electronic equipment and medium for creating a rainwater pipe network information model. Background Art

[0002] BIM (Building Information Modeling) technology has the characteristics of visualization, parameterization, and information completeness, and can realize the integration and shared management of engineering information. With the development of cities, the design and management of rainwater pipe networks are becoming increasingly important. In order to clearly express the accurate position relationship between pipe networks and between pipe networks and surrounding buildings, the establishment of a visual three-dimensional rainwater pipe network information model can provide intuitive and convenient information support for collaborative design and smart pipe network construction.

[0003] Generally speaking, rainwater pipe networks have the characteristics of wide coverage, multiple types, multiple specifications, large quantity, complex attributes, and different wellhead elevations. Conventional modeling methods are difficult to meet the needs of batch and efficient creation of rainwater pipe network information models. Summary of the invention

[0004] In view of this, it is necessary to provide a method, device, electronic equipment and medium for creating a rainwater pipe network information model to solve the technical problem that existing technical solutions are difficult to meet the needs of batch and efficient creation of rainwater pipe network information models.

[0005] In order to solve the above problems, on the one hand, the present invention provides a method for creating a rainwater pipe network information model, comprising: After importing the geospatial database containing rainwater pipe network elements into the GIS software, define the rainwater pipe network range and reference base point coordinates in the GIS software to obtain the target format file; After linking the Revit project file to the target format file, read the rainwater well data table and the rainwater pipe data table from the rainwater pipe network database, and load the corresponding rainwater well model from the standardized rainwater well model library and the corresponding rainwater pipe model from the standardized rainwater pipe model library; Based on the stormwater well data table and stormwater pipe data table, as well as the stormwater well model and stormwater pipe model, a stormwater pipe network information model is constructed in the Revit project file.

[0006] In a possible implementation, before linking the Revit project file to the target format file, the following steps are also included: Export the rainwater well layer data in the GIS software as a first database file; Export the stormwater pipe layer data in the GIS software as a second database file; A rainwater pipe network database is constructed based on the first database file and the second database file.

[0007] In a possible implementation, the first database file and the second database file are both lightweight database files in SQLite format.

[0008] In a possible implementation, constructing a rainwater pipe network database based on the first database file and the second database file includes: Generate an initial rainwater pipe network database based on the first database file and the second database file; Query and verify the data in the initial rainwater pipe network database to clean up abnormal data and null value data and obtain the verified rainwater pipe network database; The coordinate values ​​of each rainwater pipe network element in the approved rainwater pipe network database are converted so that the coordinate values ​​of each rainwater pipe network element after conversion meet the display range of the Revit project file, thereby obtaining the final rainwater pipe network database.

[0009] In a possible implementation, before loading the corresponding rainwater well model from the standardized rainwater well model library, the method further includes: Use the metric general model family template file to create the structural model of each element of the rainwater well; After defining the geometric parameters, material parameters and non-geometric parameters corresponding to the standardized rainwater well model library of the structural model of each element of the rainwater well based on the rainwater pipe network database, the structural model of each element of the rainwater well is stretched, compressed or rotated to obtain the standardized rainwater well model library.

[0010] In a possible implementation, before loading the corresponding rainwater pipe model from the standardized rainwater pipe model library, the method further includes: Use the metric general model family template file to create the structural model of each element of the rainwater pipe; After defining the geometric parameters, material parameters and non-geometric parameters corresponding to the standardized rainwater pipe model library of the structural model of each element of the rainwater pipe based on the rainwater pipe network database, the structural model of each element of the rainwater pipe is stretched, compressed or rotated to obtain the standardized rainwater pipe model library.

[0011] In a possible implementation, a corresponding rainwater well model is loaded from a standardized rainwater well model library, and a corresponding rainwater pipe model is loaded from a standardized rainwater pipe model library, including: Traverse the rainwater well data table, and load the corresponding rainwater well model from the standardized rainwater well model library according to the rainwater well type in the rainwater well data table; Traverse the stormwater pipe data table, determine the starting and ending points of the stormwater pipe according to the stormwater pipe data table, and load the corresponding stormwater pipe model from the standardized stormwater pipe model library according to the starting and ending points of the stormwater pipe and the corresponding stormwater well type.

[0012] In a possible implementation, a stormwater pipe network information model is constructed in a Revit project file based on a stormwater well data table and a stormwater pipe data table, as well as a stormwater well model and a stormwater pipe model, including: The plug-in tool based on the Revit platform loads the corresponding class library, and based on the class library, combines the rainwater well data table and the rainwater pipe data table, as well as the rainwater well model and the rainwater pipe model, to build a rainwater pipe network information model in the Revit project file.

[0013] On the other hand, the present invention also provides a device for creating a rainwater pipe network information model, comprising: The import module is used to import the geospatial database containing rainwater pipe network elements into the GIS software, define the rainwater pipe network range and reference base point coordinates in the GIS software, and obtain the target format file; The reading and loading module is used to link the Revit project file to the target format file, read the rainwater well data table and the rainwater pipe data table from the rainwater pipe network database, and load the corresponding rainwater well model from the standardized rainwater well model library and the corresponding rainwater pipe model from the standardized rainwater pipe model library; A building module used to build a stormwater pipe network information model in a Revit project file based on the stormwater well data table and stormwater pipe data table, as well as the stormwater well model and stormwater pipe model.

[0014] On the other hand, the present invention also provides an electronic device, including a memory and a processor, wherein: The memory is used to store programs; The processor is coupled to the memory and is used to execute the program stored in the memory to implement the steps of the method for creating a rainwater pipe network information model as described in any one of the above items.

[0015] The beneficial effects of adopting the above-mentioned implementation method are as follows: the creation method, device, electronic device and medium of the rainwater pipe network information model provided by the present invention reads the rainwater well data table and the rainwater pipe data table from the rainwater pipe network database, and loads the corresponding rainwater well model from the standardized rainwater well model library, and loads the corresponding rainwater pipe model from the standardized rainwater pipe model library, thereby constructing the rainwater pipe network information model, thereby improving the efficiency and accuracy of model creation; by linking the Revit project file to the target format file, using Revit secondary development and database reading technology, batch creation of three-dimensional rainwater pipe network information models and automatic information update are realized. The solution of the present invention directly obtains the elements required to construct the rainwater pipe network information model from the database and the model library. When constructing the rainwater pipe network information model, there is no need to create the required elements separately each time, that is, there is no need to create the required rainwater well model and rainwater pipe model and their corresponding data tables by units. It has the advantages of simple operation, high efficiency, good accuracy, etc., and can realize batch construction of rainwater pipe network information models, solving the technical problem that the existing technical solutions are difficult to meet the needs of batch and efficient creation of rainwater pipe network information models, and has important application value in pipe network collaborative design and smart pipe network construction management. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative work.

[0017] Figure 1 A flowchart of an embodiment of a method for creating a rainwater pipe network information model provided by the present invention; Figure 2 A flowchart of another embodiment of a method for creating a rainwater pipe network information model provided by the present invention; Figure 3 A principle block diagram of an embodiment of a device for creating a rainwater pipe network information model provided by the present invention; Figure 4 A schematic structural diagram of an embodiment of an electronic device provided by the present invention. DETAILED DESCRIPTION

[0018] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative work are within the scope of protection of the present invention.

[0019] In the description of the embodiments of the present application, unless otherwise specified, “plurality” means two or more.

[0020] The terms "including" and "having" and any variations thereof in the embodiments of the present invention are intended to cover non-exclusive inclusions. For example, a process, method, apparatus, product or equipment comprising a series of steps or modules is not necessarily limited to those steps or modules clearly listed, but may include other steps or modules not clearly listed or inherent to these processes, methods, products or equipment.

[0021] The naming or numbering of the steps in the embodiments of the present invention does not mean that the steps in the method flow must be executed in the time / logical sequence indicated by the naming or numbering. The execution order of the named or numbered process steps can be changed according to the technical purpose to be achieved, as long as the same or similar technical effects can be achieved.

[0022] Reference to an "embodiment" herein means that a particular feature, structure, or characteristic described in conjunction with the embodiment may be included in at least one embodiment of the present invention. The appearance of the phrase in various places in the specification does not necessarily refer to the same embodiment, nor is it an independent or alternative embodiment that is mutually exclusive with other embodiments. It is explicitly and implicitly understood by those skilled in the art that the embodiments described herein may be combined with other embodiments.

[0023] The present invention provides a method, device, electronic device and medium for creating a rainwater pipe network information model, which are described below respectively.

[0024] like Figure 1 As shown, the present invention provides a method for creating a rainwater pipe network information model, comprising: S101. After importing the geospatial database containing rainwater pipe network elements into GIS (Geographic Information System or Geo-Information system, Geographic Information System) software, define the rainwater pipe network range and reference base point coordinates in the GIS software to obtain a target format file; the target format file may be a CAD (Computer Aided Design) format file; S102, after linking the Revit project file to the target format file, read the rainwater well data table and the rainwater pipe data table from the rainwater pipe network database, and load the corresponding rainwater well model from the standardized rainwater well model library, and load the corresponding rainwater pipe model from the standardized rainwater pipe model library; S103. Based on the stormwater well data table and the stormwater pipe data table, as well as the stormwater well model and the stormwater pipe model, a stormwater pipe network information model is constructed in the Revit project file.

[0025] It is understandable that the Revit series of software is built for building information modeling (BIM), which helps building designers design, build and maintain better quality and more energy-efficient buildings. The stormwater network information model is a three-dimensional model that contains elements such as stormwater pipes and stormwater wells and corresponding data.

[0026] The method for creating a rainwater pipe network information model provided by the present invention comprises the following steps: Import the shp file of the geospatial database containing rainwater pipe network elements into the GIS software to define the scope of the rainwater pipe network and the coordinates of the reference base points; create a rainwater pipe network database; query and count rainwater pipe network data and clean the database; establish a standardized rainwater well model library; establish a standardized rainwater pipe model library; set the base point coordinates of the project file through shared coordinates; use Revit secondary development and database reading technology to achieve rapid creation of rainwater pipe network information models.

[0027] Define the scope of the stormwater pipe network and the coordinates of the reference base point, specifically: Import the shp files of the geospatial database containing the rainwater wells, rainwater pipes and other pipe network elements into Map3D software in sequence. Map3D software is GIS software. Display the entire pipe network range in the window and create an envelope rectangle for the pipe network area; Record the center coordinates X0 and Y0 of the rectangle, and save the rectangular graphic as a file LK.dwg, that is, a CAD file.

[0028] Link the Revit project file to the target format file, that is, set the base point coordinates of the project file through shared coordinates between the two files, specifically: In the Revit project file, set the project's length unit to m; Link the CAD file by "center to center" method, linking the LK.dwg file in step S103 to the Revit project file; The project file and the CAD file share coordinates through the shared coordinate setting. The horizontal and vertical coordinates of the project base point are X0 and Y0 respectively.

[0029] In some embodiments, before linking the Revit project file to the target format file, the method further includes: Export the rainwater well layer data in the GIS software as a first database file; Export the stormwater pipe layer data in the GIS software as a second database file; A rainwater pipe network database is constructed based on the first database file and the second database file.

[0030] The first database file and the second database file are both lightweight database files in SQLite format.

[0031] It can be understood that the GIS software can be Map3D software, and the rainwater well layer data in the Map3D software is exported as an SQLite file to create a rainwater well lightweight database file YSPopint.sqlite, that is, the first database file; the rainwater pipe layer data in the Map3D software is exported as an SQLite file to create a rainwater pipe lightweight database file YSLine.sqlite, that is, the second database file.

[0032] In some embodiments, constructing a rainwater pipe network database based on the first database file and the second database file includes: Generate an initial rainwater pipe network database based on the first database file and the second database file; Query and verify the data in the initial rainwater pipe network database to clean up abnormal data and null value data and obtain the verified rainwater pipe network database; The coordinate values ​​of each rainwater pipe network element in the approved rainwater pipe network database are converted so that the coordinate values ​​of each rainwater pipe network element after conversion meet the display range of the Revit project file, thereby obtaining the final rainwater pipe network database.

[0033] It is understandable that the rainwater pipe network data query statistics and database cleaning are specifically: By writing database query statements, query and count the pipe network data in the SQLite database, including the number, type, size, material and other attributes of the pipe network; During the query process, verify the accuracy of the data, discover and clean up abnormal data and null value data; To prevent the coordinates from being too large and exceeding the Revit display range, a new field coordinate N is created in the lightweight data of the rainwater well. X and N Y , calculate N X = original well coordinate X-X0, NY= original well coordinate Y-Y0, and write the new coordinate value into the database so that the coordinate value of each stormwater pipe network element after conversion meets the display range of the Revit project file.

[0034] In some embodiments, before loading the corresponding stormwater well model from the standardized stormwater well model library, the method further includes: Use the metric general model family template file to create the structural model of each element of the rainwater well; After defining the geometric parameters, material parameters and non-geometric parameters corresponding to the standardized rainwater well model library of the structural model of each element of the rainwater well based on the rainwater pipe network database, the structural model of each element of the rainwater well is stretched, compressed or rotated to obtain the standardized rainwater well model library.

[0035] It is understandable that a standardized rainwater well model library is established, specifically: Use the metric conventional model family template file to create the well structure model; According to the statistical results of database query, define geometric parameters, material parameters and corresponding non-geometric parameters in the database; The wellhead center is uniformly set at the origin position, and the model is constructed through operations such as stretching; According to the above steps, models of inspection wells, rainwater grates, discharge outlets, interception wells, etc. are created respectively. Inspection wells, rainwater grates, discharge outlets, and interception wells are all elements of rainwater wells.

[0036] In some embodiments, before loading the corresponding storm sewer model from the standardized storm sewer model library, the method further includes: Use the metric general model family template file to create the structural model of each element of the rainwater pipe; After defining the geometric parameters, material parameters and non-geometric parameters corresponding to the standardized rainwater pipe model library of the structural model of each element of the rainwater pipe based on the rainwater pipe network database, the structural model of each element of the rainwater pipe is stretched, compressed or rotated to obtain the standardized rainwater pipe model library.

[0037] It is understandable that a standardized stormwater pipe model library is established, specifically: Use adaptive metric conventional model family template files to create well structure models; According to the statistical results of database query, the geometric parameters, material parameters and corresponding non-geometric parameters of the rainwater pipe are defined; The wellhead center is uniformly set at the origin position, and the model is constructed through operations such as stretching; Follow the above steps to create models of circular rainwater pipes, rectangular rainwater pipes, drainage ditches, etc. Circular rainwater pipes, rectangular rainwater pipes, and drainage ditches are all rainwater pipe elements.

[0038] In some embodiments, loading a corresponding rainwater well model from a standardized rainwater well model library and loading a corresponding rainwater pipe model from a standardized rainwater pipe model library include: Traverse the rainwater well data table, and load the corresponding rainwater well model from the standardized rainwater well model library according to the rainwater well type in the rainwater well data table; Traverse the stormwater pipe data table, determine the starting and ending points of the stormwater pipe according to the stormwater pipe data table, and load the corresponding stormwater pipe model from the standardized stormwater pipe model library according to the starting and ending points of the stormwater pipe and the corresponding stormwater well type.

[0039] It can be understood that the rainwater well database YSPopint.sqlite is linked to read the rainwater well data table to obtain the well type, coordinate X, coordinate Y, ground elevation, well depth, angle, number, connecting pipe number, owner, construction unit and other non-geometric information.

[0040] Traverse the rainwater well data table and load the corresponding rainwater well model according to the well type. The main functions used include creating a family model using the function doc.Create.NewFamilyInstance(XYZ location, FamilySymbol symbol,StructuralType structuralType), updating the angle of the model using the function familyinstance.Location.Rotate(Line axis, double angle), updating the geometric information of the well model using the function familyinstance.LookupParameter(string name).Set(double value), and updating the non-geometric information of the well model using the function familyinstance.LookupParameter(string name).Set(string value).

[0041] Link to the stormwater pipe database YSLine.sqlite, read the stormwater pipe data table, and obtain the pipe type, starting well number, end well number, starting pipe invert elevation, end pipe invert elevation, pipe diameter or trench size, and other non-geometric information.

[0042] Traverse the rainwater pipe data table, query the rainwater well data table according to the starting well number and the end well number to obtain the corresponding well coordinate X and coordinate Y, and calculate the center coordinates of the starting and end points of the pipeline in combination with the pipeline inner bottom elevation.

[0043] The corresponding stormwater pipe model is loaded according to the stormwater well type. The main functions used include using the function AdaptiveComponentInstanceUtils.CreateAdaptiveComponentInstance (Document doc, FamilySymbol famSymb) to create a family pipe model, using the function familyinstance.LookupParameter(string name).Set(double value) to update the geometric information of the pipe model, and using the function familyinstance.LookupParameter(string name).Set(string value) to update the non-geometric information of the pipe model.

[0044] In some embodiments, based on the stormwater well data table and the stormwater pipe data table, as well as the stormwater well model and the stormwater pipe model, a stormwater pipe network information model is constructed in a Revit project file, including: The plug-in tool based on the Revit platform loads the corresponding class library, and based on the class library, combines the rainwater well data table and the rainwater pipe data table, as well as the rainwater well model and the rainwater pipe model, to build a rainwater pipe network information model in the Revit project file.

[0045] It can be understood that the external command extension interface IExternalCommand of the Revit API (application programming interface) is used to create the main function for executing the command, and the class library dll file is compiled in Visual Studio.

[0046] Use the AddIn-Manager plug-in tool in Revit to load the generated class library, execute the pipe network creation command, and complete the creation of the rainwater pipe network information model.

[0047] like Figure 2 As shown, in one embodiment, the method for creating a rainwater pipe network information model provided by the present invention includes the following steps: S201. Import the shp file into the GIS software to define the scope of the rainwater pipe network and the coordinates of the reference base points; S202, creating a rainwater pipe network database; S203, rainwater pipe network data query statistics and database cleaning; S204, establish a standardized rainwater well model library; S205. Establish a standardized rainwater pipe model library; S206, setting the base point coordinates of the project file through shared coordinates; S207. Use Revit secondary development and database reading technology to quickly create rainwater pipe network information models.

[0048] S201. Define the scope of the rainwater pipe network and the coordinates of the reference base points, specifically: S2011. Import the shp files of the geospatial database containing the rainwater wells, rainwater pipes and other pipe network elements into Map3D software in sequence. Map3D software is GIS software. S2012. Display the entire pipe network range in the window and create an envelope rectangle for the pipe network area; S2013. Record the center coordinates X0 and Y0 of the rectangle, and save the rectangular graphic as a file LK.dwg, that is, a CAD file.

[0049] S202, creating a rainwater well and rainwater pipe database, specifically: S2021. Export the rainwater well layer data in the Map3D software as a SQLite file, and create a rainwater well lightweight database file YSPopint.sqlite, i.e., the first database file; S2022. Export the stormwater pipe layer data in the Map3D software as a SQLite file, and create a stormwater pipe lightweight database file YSLine.sqlite, which is the second database file.

[0050] S203, rainwater pipe network data query statistics and database cleaning, specifically: S2031. By writing database query statements, query and count the pipe network data in the SQLite database, including the number, type, size, material and other attributes of the pipe network; S2032. During the query process, verify the accuracy of the data, and discover and clean up abnormal data and null value data; S2033. To prevent coordinates from being too large and exceeding the Revit display range, create a new field coordinate N in the lightweight data of the rainwater well. X and N Y , calculate N X = original well coordinate X-X0, NY = original well coordinate Y-Y0, and write the new coordinate value into the database.

[0051] S204. Establish a standardized rainwater well model library, specifically: S2041. Use the metric conventional model family template file to create a well structure model; S2042, defining geometric parameters, material parameters, and corresponding non-geometric parameters in the database according to the database query statistical results; S2043, the wellhead center is uniformly set at the origin position, and the model is constructed by stretching and other operations; S2044. According to steps S2041 to S2043, models of inspection wells, rainwater grates, discharge outlets, interception wells, etc. are respectively created. Inspection wells, rainwater grates, discharge outlets, interception wells are all elements of rainwater wells.

[0052] S205. Establish a standardized rainwater pipe model library, specifically: S2051. Use the adaptive metric conventional model family template file to create a well structure model; S2052. According to the statistical results of the database query, the geometric parameters and material parameters of the rainwater pipe and the corresponding non-geometric parameters in the database are defined; S2053, the wellhead center is uniformly set at the origin position, and the model is constructed by stretching and other operations; S2054. Create models of circular rainwater pipes, rectangular rainwater pipes, drainage ditches, etc. according to steps S2051 to S2053. The circular rainwater pipes, rectangular rainwater pipes, and drainage ditches are all rainwater pipe elements.

[0053] S206. Setting the base point coordinates of the project file through shared coordinates, specifically: S2061. In the Revit project file, set the length unit of the project to m; S2062, linking the CAD file in a "center-to-center" manner, linking the LK.dwg file in step S2013 to the Revit project file; S2063. Share the coordinates of the project file and the CAD file through the shared coordinate setting. The horizontal coordinate and vertical coordinate of the project base point are X0 and Y0 respectively.

[0054] S207, using Revit secondary development and database reading technology to achieve rapid creation of rainwater pipe network information model, specifically: S2071. Create a project in Visual Studio and create a new C# class, referencing the Revit API.dll, RevitAPIUI.dll, and System.Data.SQLite.dll assemblies; S2072, linking to the rainwater well database YSPopint.sqlite, reading the rainwater well data table, obtaining the well type, coordinate X, coordinate Y, ground elevation, well depth, angle, number, connecting pipe number, owner, construction unit and other non-geometric information; S2073, traverse the rainwater well data table, load the corresponding rainwater well model according to the well type, and use the following main functions: create a family model using the function doc.Create.NewFamilyInstance(XYZ location, FamilySymbol symbol, StructuralType structuralType), update the angle of the model using familyinstance.Location.Rotate(Line axis, double angle), update the geometric information of the well model using the function familyinstance.LookupParameter(string name).Set(double value), and update the non-geometric information of the well model using the function familyinstance.LookupParameter(string name).Set(string value); S2074. Link to the stormwater pipe database YSLine.sqlite, read the stormwater pipe data table, and obtain the pipe type, starting well number, end well number, starting pipe invert elevation, end pipe invert elevation, pipe diameter or trench size, and other non-geometric information; S2075, traverse the rainwater pipe data table, query the rainwater well data table according to the starting well number and the end well number to obtain the corresponding well coordinate X and coordinate Y, and calculate the center coordinates of the starting point and the end point of the pipeline in combination with the pipeline inner bottom elevation; S2076. Load the corresponding stormwater pipe model according to the stormwater well type. The main functions used include using the function AdaptiveComponentInstanceUtils.CreateAdaptiveComponentInstance (Document doc, FamilySymbol famSymb) to create a family pipe model, using the function familyinstance.LookupParameter (string name).Set (double value) to update the geometric information of the pipe model, and using the function familyinstance.LookupParameter (string name).Set (string value) to update the non-geometric information of the pipe model; S2077. Use the external command extension interface IExternalCommand of RevitAPI to create the main function for executing commands, and compile and generate the class library dll file in Visual Studio; S2078. Use the AddIn-Manager plug-in tool in Revit to load the generated class library, execute the pipe network creation command, and complete the creation of the rainwater pipe network information model.

[0055] In summary, the method for creating a rainwater pipe network information model provided by the present invention includes: after importing the geospatial database containing rainwater pipe network elements into the GIS software, defining the rainwater pipe network range and reference base point coordinates in the GIS software to obtain a target format file; after linking the Revit project file to the target format file, reading the rainwater well data table and the rainwater pipe data table from the rainwater pipe network database, and loading the corresponding rainwater well model from the standardized rainwater well model library, and loading the corresponding rainwater pipe model from the standardized rainwater pipe model library; based on the rainwater well data table and the rainwater pipe data table, as well as the rainwater well model and the rainwater pipe model, constructing the rainwater pipe network information model in the Revit project file.

[0056] The method for creating a rainwater pipe network information model provided by the present invention reads a rainwater well data table and a rainwater pipe data table from a rainwater pipe network database, loads a corresponding rainwater well model from a standardized rainwater well model library, and loads a corresponding rainwater pipe model from a standardized rainwater pipe model library, thereby building a rainwater pipe network information model, thereby improving the efficiency and accuracy of model creation; by linking a Revit project file to a target format file, using Revit secondary development and database reading technology, batch creation of a three-dimensional rainwater pipe network information model and automatic information update are realized. The scheme of the present invention directly obtains the elements required to build a rainwater pipe network information model from a database and a model library, and when building a rainwater pipe network information model, it is not necessary to create the required elements separately each time, that is, it is not necessary to create the required rainwater well model and rainwater pipe model and their corresponding data tables by a unit, and has the advantages of simple operation, high efficiency, good accuracy, etc., and can realize batch construction of rainwater pipe network information models, solving the technical problem that the existing technical scheme is difficult to meet the needs of batch and efficient rainwater pipe network information model creation, and has important application value in pipe network collaborative design and intelligent pipe network construction management.

[0057] In addition, the present invention also uses the rainwater pipe network geospatial database to quickly convert into a lightweight database, and through data cleaning, ensures the accuracy and reliability of the data. Figure 3 As shown, the present invention also provides a device 300 for creating a rainwater pipe network information model, comprising: The import module 301 is used to import the geospatial database containing rainwater pipe network elements into the GIS software, define the rainwater pipe network range and reference base point coordinates in the GIS software, and obtain a target format file; The reading and loading module 302 is used to read the rainwater well data table and the rainwater pipe data table from the rainwater pipe network database after linking the Revit project file to the target format file, and load the corresponding rainwater well model from the standardized rainwater well model library and the corresponding rainwater pipe model from the standardized rainwater pipe model library; The construction module 303 is used to construct a rainwater pipe network information model in the Revit project file based on the rainwater well data table and the rainwater pipe data table, as well as the rainwater well model and the rainwater pipe model.

[0058] The device for creating a rainwater pipe network information model provided in the above embodiment can implement the technical solution described in the above embodiment of the method for creating a rainwater pipe network information model. The specific implementation principles of the above modules or units can refer to the corresponding contents in the above embodiment of the method for creating a rainwater pipe network information model, which will not be repeated here.

[0059] like Figure 4 As shown, the present invention also provides an electronic device 400. The electronic device 400 includes a processor 401, a memory 402 and a display 403. Figure 4 Only some components of the electronic device 400 are shown, but it should be understood that it is not required to implement all of the components shown, and more or fewer components may be implemented instead.

[0060] In some embodiments, the memory 402 may be an internal storage unit of the electronic device 400, such as a hard disk or memory of the electronic device 400. In other embodiments, the memory 402 may also be an external storage device of the electronic device 400, such as a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, a flash card, etc., equipped on the electronic device 400.

[0061] Furthermore, the memory 402 may include both an internal storage unit of the electronic device 400 and an external storage device. The memory 402 is used to store application software installed in the electronic device 400 and various data.

[0062] In some embodiments, the processor 401 may be a central processing unit (CPU), a microprocessor or other data processing chip, used to run program codes or process data stored in the memory 402, such as the method for creating a rainwater pipe network information model in the present invention.

[0063] In some embodiments, the display 403 may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch device, etc. The display 403 is used to display information on the electronic device 400 and to display a visual user interface. The components 401-403 of the electronic device 400 communicate with each other via a system bus.

[0064] In some embodiments of the present invention, when the processor 401 executes the creation program of the rainwater pipe network information model in the memory 402, the following steps may be implemented: After importing the geospatial database containing rainwater pipe network elements into the GIS software, define the rainwater pipe network range and reference base point coordinates in the GIS software to obtain the target format file; After linking the Revit project file to the target format file, read the rainwater well data table and the rainwater pipe data table from the rainwater pipe network database, and load the corresponding rainwater well model from the standardized rainwater well model library and the corresponding rainwater pipe model from the standardized rainwater pipe model library; Based on the rainwater well data table and the rainwater pipe data table, as well as the rainwater well model and the rainwater pipe model, a rainwater pipe network information model is constructed in the Revit project file. It should be understood that when the processor 401 executes the creation program of the rainwater pipe network information model in the memory 402, in addition to the above functions, other functions can also be realized, and the details can be referred to the description of the corresponding method embodiment above.

[0065] Furthermore, the embodiment of the present invention does not specifically limit the type of the electronic device 400 mentioned, and the electronic device 400 may be a portable electronic device such as a mobile phone, a tablet computer, a personal digital assistant (PDA), a wearable device, a laptop computer, etc. Exemplary embodiments of portable electronic devices include but are not limited to portable electronic devices equipped with IOS, Android, Microsoft or other operating systems. The above-mentioned portable electronic device may also be other portable electronic devices, such as a laptop computer with a touch-sensitive surface (e.g., a touch panel). It should also be understood that in some other embodiments of the present invention, the electronic device 400 may not be a portable electronic device, but a desktop computer with a touch-sensitive surface (e.g., a touch panel).

[0066] In another aspect, the present invention further provides a non-transitory computer-readable storage medium having a computer program stored thereon, which is implemented when the computer program is executed by a processor to execute the method for creating a rainwater pipe network information model provided by the above methods, the method comprising: After importing the geospatial database containing rainwater pipe network elements into the GIS software, define the rainwater pipe network range and reference base point coordinates in the GIS software to obtain the target format file; After linking the Revit project file to the target format file, read the rainwater well data table and the rainwater pipe data table from the rainwater pipe network database, and load the corresponding rainwater well model from the standardized rainwater well model library and the corresponding rainwater pipe model from the standardized rainwater pipe model library; Based on the stormwater well data table and stormwater pipe data table, as well as the stormwater well model and stormwater pipe model, a stormwater pipe network information model is constructed in the Revit project file.

[0067] Those skilled in the art will appreciate that all or part of the processes of the above-mentioned embodiments can be implemented by instructing related hardware through a computer program, and the program can be stored in a computer-readable storage medium, wherein the computer-readable storage medium is a disk, an optical disk, a read-only storage memory, or a random access memory, etc.

[0068] The above is a detailed introduction to the creation method, device, electronic device and medium of the rainwater pipe network information model provided by the present invention. Specific examples are used in this article to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only used to help understand the method of the present invention and its core idea; at the same time, for technical personnel in this field, according to the idea of ​​the present invention, there will be changes in the specific implementation method and application scope. In summary, the content of this specification should not be understood as a limitation on the present invention.

Claims

1. A method for creating a rainwater pipe network information model, characterized in that: include: After importing the geospatial database containing rainwater pipe network elements into the GIS software, define the rainwater pipe network range and reference base point coordinates in the GIS software to obtain the target format file; After linking the Revit project file to the target format file, read the rainwater well data table and the rainwater pipe data table from the rainwater pipe network database, and load the corresponding rainwater well model from the standardized rainwater well model library and the corresponding rainwater pipe model from the standardized rainwater pipe model library; Based on the stormwater well data table and stormwater pipe data table, as well as the stormwater well model and stormwater pipe model, a stormwater pipe network information model is constructed in the Revit project file.

2. The method for creating a rainwater pipe network information model according to claim 1, characterized in that: Before linking the Revit project file to the target format file, also include: Export the rainwater well layer data in the GIS software as a first database file; Export the stormwater pipe layer data in the GIS software as a second database file; A rainwater pipe network database is constructed based on the first database file and the second database file.

3. The method for creating a rainwater pipe network information model according to claim 2, characterized in that: The first database file and the second database file are both lightweight database files in SQLite format.

4. The method for creating a rainwater pipe network information model according to claim 2, characterized in that: Based on the first database file and the second database file, a rainwater pipe network database is constructed, including: Generate an initial rainwater pipe network database based on the first database file and the second database file; Query and verify the data in the initial rainwater pipe network database to clean up abnormal data and null value data and obtain the verified rainwater pipe network database; The coordinate values ​​of each rainwater pipe network element in the approved rainwater pipe network database are converted so that the coordinate values ​​of each rainwater pipe network element after conversion meet the display range of the Revit project file, thereby obtaining the final rainwater pipe network database.

5. The method for creating a rainwater pipe network information model according to claim 1, characterized in that: Before loading the corresponding stormwater well model from the standardized stormwater well model library, it also includes: Use the metric general model family template file to create the structural model of each element of the rainwater well; After defining the geometric parameters, material parameters and non-geometric parameters corresponding to the standardized rainwater well model library of the structural model of each element of the rainwater well based on the rainwater pipe network database, the structural model of each element of the rainwater well is stretched, compressed or rotated to obtain the standardized rainwater well model library.

6. The method for creating a rainwater pipe network information model according to claim 1, characterized in that: Before loading the corresponding storm sewer model from the standardized storm sewer model library, it also includes: Use the metric general model family template file to create the structural model of each element of the rainwater pipe; After defining the geometric parameters, material parameters and non-geometric parameters corresponding to the standardized rainwater pipe model library of the structural model of each element of the rainwater pipe based on the rainwater pipe network database, the structural model of each element of the rainwater pipe is stretched, compressed or rotated to obtain the standardized rainwater pipe model library.

7. The method for creating a rainwater pipe network information model according to claim 1, characterized in that: Load the corresponding rainwater well model from the standardized rainwater well model library, and load the corresponding rainwater pipe model from the standardized rainwater pipe model library, including: Traverse the rainwater well data table, and load the corresponding rainwater well model from the standardized rainwater well model library according to the rainwater well type in the rainwater well data table; Traverse the stormwater pipe data table, determine the starting and ending points of the stormwater pipe according to the stormwater pipe data table, and load the corresponding stormwater pipe model from the standardized stormwater pipe model library according to the starting and ending points of the stormwater pipe and the corresponding stormwater well type.

8. The method for creating a rainwater pipe network information model according to any one of claims 1 to 7, characterized in that: Based on the stormwater well data table and stormwater pipe data table, as well as the stormwater well model and stormwater pipe model, a stormwater pipe network information model is constructed in the Revit project file, including: The plug-in tool based on the Revit platform loads the corresponding class library, and based on the class library, combines the rainwater well data table and the rainwater pipe data table, as well as the rainwater well model and the rainwater pipe model, to build a rainwater pipe network information model in the Revit project file.

9. A device for creating a rainwater pipe network information model, characterized in that: include: The import module is used to import the geospatial database containing rainwater pipe network elements into the GIS software, define the rainwater pipe network range and reference base point coordinates in the GIS software, and obtain the target format file; The reading and loading module is used to link the Revit project file to the target format file, read the rainwater well data table and the rainwater pipe data table from the rainwater pipe network database, and load the corresponding rainwater well model from the standardized rainwater well model library and the corresponding rainwater pipe model from the standardized rainwater pipe model library; A building module used to build a stormwater pipe network information model in a Revit project file based on the stormwater well data table and stormwater pipe data table, as well as the stormwater well model and stormwater pipe model.

10. An electronic device, characterized in that: comprising a memory and a processor, wherein: The memory is used to store programs; The processor is coupled to the memory and is used to execute the program stored in the memory to implement the steps of the method for creating a rainwater pipe network information model as described in any one of claims 1 to 8.

Citation Information

Patent Citations

  • Urban inland inundation model construction method based on CAD engineering drawing information and computation sheet of pipe network design

    CN105224747A

  • Sponge city planning and construction BIM modeling method

    CN110222357A

  • Rainwater pipe network flow calculation method and system based on GIS underlying surface analysis

    CN110717233A

  • Revit and Dynamo-based drainage pipe network model creation method

    CN115481515A

  • CAD-based drainage pipe network model construction method and storage medium

    CN116305952A