CN112100272B - Drainage line data display method and device, computer equipment and storage medium - Google Patents

Drainage line data display method and device, computer equipment and storage medium Download PDF

Info

Publication number
CN112100272B
CN112100272B CN202010943335.2A CN202010943335A CN112100272B CN 112100272 B CN112100272 B CN 112100272B CN 202010943335 A CN202010943335 A CN 202010943335A CN 112100272 B CN112100272 B CN 112100272B
Authority
CN
China
Prior art keywords
well
pipe
drainage
data structure
numbers
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.)
Active
Application number
CN202010943335.2A
Other languages
Chinese (zh)
Other versions
CN112100272A (en
Inventor
刘建雄
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Glodon Co Ltd
Original Assignee
Glodon Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Glodon Co Ltd filed Critical Glodon Co Ltd
Priority to CN202010943335.2A priority Critical patent/CN112100272B/en
Publication of CN112100272A publication Critical patent/CN112100272A/en
Application granted granted Critical
Publication of CN112100272B publication Critical patent/CN112100272B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/26Visual data mining; Browsing structured data
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02ATECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
    • Y02A10/00TECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE at coastal zones; at river basins
    • Y02A10/40Controlling or monitoring, e.g. of flood or hurricane; Forecasting, e.g. risk assessment or mapping

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Software Systems (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention provides a data display method, a device, computer equipment and a storage medium of a drainage line, wherein the method comprises the following steps: acquiring a drainage pipe network model, and establishing a well pipe undirected graph according to the position relationship between a well and a pipe contained in the drainage pipe network model; establishing a plurality of data structures according to the well pipe undirected graph, wherein each data structure comprises a pipe and two wells connected to two ends of the pipe; determining a drain line contained in the drain pipe network model based on the data structure; displaying all drainage lines and drainage data corresponding to each drainage line in a table form, wherein the drainage data comprises well numbers, well parameters and pipe parameters.

Description

Drainage line data display method and device, computer equipment and storage medium
Technical Field
The present invention relates to the field of water supply and drainage technologies, and in particular, to a method and apparatus for displaying data of a drainage line, a computer device, and a storage medium.
Background
Along with the continuous acceleration of the urban process, the penetration and fusion of BIM in municipal engineering design have gradually become an application trend. The calculation of the line and the quantity of the pipeline is realized by manually manufacturing an Excel table form according to a drainage pipe network model in the municipal industry at present.
The Excel table form can only realize simple listing of data, and can not automatically show which drainage lines are specifically contained in the drainage pipe network model and the specific trend of each drainage line, and the corresponding lines can only be filled after manual judgment. In addition, each parameter in the drain pipe network model also needs to be manually input into an Excel table, and the efficiency is low and the error is easy to occur. And because the Excel table can not intuitively display different drainage lines, a metering staff can easily leak or confuse a certain well or pipe when performing drainage metering based on the Excel table, so that the metering result is inaccurate.
Therefore, how to automatically obtain different drainage lines included in the drainage pipe network model and display the drainage lines and corresponding parameters in a proper form is a problem to be solved by those skilled in the art.
Disclosure of Invention
The present invention is directed to a data display scheme for a drainage line, so as to solve the above-mentioned problems in the prior art.
In order to achieve the above object, the present invention provides a data display method for a drainage line, comprising the steps of:
acquiring a drainage pipe network model, and establishing a well pipe undirected graph according to the position relationship between a well and a pipe contained in the drainage pipe network model;
establishing a plurality of data structures according to the well pipe undirected graph, wherein each data structure comprises a pipe and two wells connected to two ends of the pipe;
determining a drain line contained in the drain pipe network model based on the data structure;
displaying all drainage lines and drainage data corresponding to each drainage line in a table form, wherein the drainage data comprises well numbers, well parameters and pipe parameters.
According to the data display method of the drainage line provided by the invention, the step of establishing a plurality of data structures according to the well pipe undirected graph comprises the following steps:
acquiring wells connected with each pipe according to the well pipe undirected graph;
storing said each tube and the well connected to said each tube as a data structure.
According to the data display method of the drainage line provided by the invention, the step of determining the drainage line based on the data structure comprises the following steps: acquiring well numbers of wells in the data structure, and establishing a mapping relation between the well numbers and the data structure; wherein the mapping relation comprises a forward mapping relation and a backward mapping relation;
sequencing all the well numbers, and taking the well number with the smallest sequencing as a target well number;
querying a target data structure containing the target well number;
searching a first well number with a backward mapping relation with the target data structure when the forward mapping relation is between the target well number and the target data structure;
taking the first well number as the target well number, and repeatedly executing the step of searching the first well number;
searching a second well number with a forward mapping relation with the target data structure when the target well number and the target data structure are in the backward mapping relation;
taking the second well number as the target well number, and repeatedly executing the step of searching the second well number;
and sequentially connecting all the searched first well numbers with all the second well numbers to obtain a first drainage line.
According to the data display method of the drainage line provided by the invention, in response to searching a plurality of first well numbers or a plurality of second well numbers,
determining the first well number or the second well number according to the prefix of the target well number; or alternatively
The first well number or the second well number is determined according to an angle of a pipe connected to the first well number or an angle of a pipe connected to the second well number.
According to the data display method of drainage lines provided by the invention, the step of displaying all the drainage lines and the drainage data corresponding to each drainage line in a table form further comprises the following steps:
displaying well numbers in all data structures contained in the drainage line in sequence in a first data column of a line table; the first data column comprises repeated well numbers, and each well number corresponds to one cell;
displaying a pipe number corresponding to each well number in the drainage line in a second data column of the line table, wherein each pipe number and the well number connected with each pipe number are positioned in the same row; the second data column comprises repeated pipe numbers, and each pipe number corresponds to one cell;
merging cells containing repeated well numbers in succession in the first data column, and merging cells containing repeated pipe numbers in the second data column;
adding well parameters corresponding to each well number and pipe parameters corresponding to each pipe number; the well parameters and the corresponding well numbers are positioned in the same row, and the pipe parameters and the corresponding pipe numbers are positioned in the same row;
and deleting the second data column in response to all the pipes corresponding to the pipe numbers being of the same type.
According to the method for displaying the data of the drainage lines provided by the invention, after the step of displaying all the drainage lines and the drainage data corresponding to each drainage line in the form of a table, the method further comprises the following steps:
and receiving and storing the modified well parameters and/or pipe parameters, wherein the different well parameters belonging to the same line have an association relationship, and the different pipe parameters belonging to the same line have an association relationship.
According to the data display method of the drainage line, the well parameters comprise any one or more of a well map set, a well size, application, drop, well depth, well top elevation, original ground elevation, pavement design elevation and road bed line elevation, and the pipe parameters comprise any one or more of pipe bottom elevation, pipe diameter, pipe length and pipe base map set.
In order to achieve the above object, the present invention further provides a data display device for a drainage line, including:
the model acquisition module is suitable for acquiring a drainage pipe network model and determining the connection relation between a well and a pipe in the drainage pipe network model;
the data structure module is suitable for establishing a plurality of data structures according to the connection relation between the wells and the pipes, and each data structure comprises a pipe and two wells connected to two ends of the pipe;
the line determining module is suitable for determining a drainage line contained in the drainage pipe network model based on the data structure;
the table display module is suitable for displaying all drainage lines and drainage data corresponding to each drainage line in a table form, wherein the drainage data comprises well numbers, well parameters and pipe parameters.
To achieve the above object, the present invention also provides a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the above method when executing the computer program.
To achieve the above object, the present invention also provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the above method.
Compared with the prior art, the invention has the following beneficial effects:
(1) According to the invention, a plurality of data structures are established according to the position relation between the wells and the pipes, each data structure comprises one pipe and two wells connected to two ends of the pipe, and the connection relation between all the wells and the pipes can be completely and accurately embodied.
(2) Before calculating the pipeline, aiming at the habit of drawing CAD drawings by users, name ordering is carried out according to well IDs, so that the accuracy of calculation of the main line and the branch line is ensured.
(3) In the drainage calculation form, the same cell merging treatment is carried out on the form according to the well pipe association relation, so that clear presentation of the association relation between the well and the front and the back of the pipe is ensured.
(4) The corresponding linkage processing mechanism is realized aiming at the property modification function of the well pipe, and the accurate dependency relationship among the related well pipes is ensured.
(5) The user can quickly realize operations such as adding, deleting and the like through the drainage calculation table, and the modification and adjustment of the drainage line are completed.
Drawings
FIG. 1 is a flow chart showing a first embodiment of a data display method of a drain line of the present invention;
FIG. 2 shows a top view of a drain pipe network model according to a first embodiment of the present invention;
FIG. 3 shows a schematic flow chart of a first embodiment of the invention for creating a plurality of data structures;
FIG. 4 shows a schematic flow chart of an embodiment of the invention for determining a drain line based on a data structure;
FIG. 5 shows a schematic flow chart of a first embodiment of the invention showing drain lines in tabular form;
FIG. 6 shows a schematic diagram of a tabular display of well numbers and pipe numbers in accordance with an embodiment of the present invention;
FIG. 7 is a schematic diagram of a drainage calculation table generated by an embodiment of the present invention;
FIG. 7A is a schematic view of a part of a drainage line in a drainage calculation table according to the first embodiment of the invention;
FIG. 7B shows a schematic of well parameters and pipe parameters for a first embodiment of the invention;
FIG. 8 is a schematic program module of a first embodiment of a data display device of a drain line according to the present invention;
fig. 9 is a schematic diagram showing a hardware configuration of a first embodiment of the data display device of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present invention more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Example 1
Referring to fig. 1, the present embodiment provides a data display method of a drainage line, which includes the following steps:
and S100, acquiring a drainage pipe network model, and building a well pipe undirected graph according to the position relationship between the well and the pipe contained in the drainage pipe network model.
The drainage pipe network model can be a three-dimensional model generated based on a two-dimensional CAD drawing by utilizing any existing modeling platform. Fig. 2 shows a top view of a drainage pipe network model according to a first embodiment of the present invention. As shown in fig. 2, wherein A1, A2, A3, A5-1, A5-2, A6 and B1, B2, B3, B4, B5, B6 respectively represent wells in different positions, and a line segment connected between any two wells represents a pipe. The drainage pipe network model is composed of a plurality of wells, a plurality of pipes and connection relations between the wells and the pipes.
As previously mentioned, the drainage pipe network model shown in fig. 2 is actually a three-dimensional perspective view. Figure 2 looks like a plan view simply because of the viewing angle problem. For easy recognition, the present embodiment requires converting a three-dimensional drainage pipe network model into a two-dimensional well pipe undirected graph for characterizing the positional relationship between the wells and pipes contained in the drainage pipe network model. The well pipe undirected graph in this embodiment is similar in display effect to fig. 2, except that the well pipe undirected graph itself is a two-dimensional view. Reference is made to figure 2 together with the description of the well pipe undirected drawing hereinafter. The connection relationship between the well and the pipe, namely, which well and which pipe have the connection relationship can be determined through the well pipe undirected graph. Whether a well and a pipe are connected may be determined by whether there is a connection point or a common point between the well and the pipe. As can be seen from fig. 2, well A1 connects well A1, well A2 connects well G2, and well A3 … … connects well G2. In this way, the connection between each well and each pipe can be obtained.
And S200, establishing a plurality of data structures according to the well pipe undirected graph, wherein each data structure comprises a pipe and two wells connected to two ends of the pipe.
This step is used to group all wells and pipes in the drainage pipe network model to form a plurality of data structures. It will be appreciated that one pipe may connect two wells simultaneously, and one well may connect multiple pipes simultaneously, with each pipe corresponding to a different branch. A plurality of data structures may further be obtained on the basis of the connection between the well and the pipe in the well pipe undirected graph having been obtained in step S100. Each data structure in this embodiment includes a tube and two wells connected at either end of the tube. Taking fig. 2 as an example, a plurality of data structures may be obtained: data structure 1 (well A1, tube G1, well A2), data structure 2 (well A2, tube G2, well A3), data structure 3 (well A3, tube G3, well A5), data structure 4 (well A5, tube G4, well A6), data structure 5 (well A5, tube G5, well A5-1), data structure 6 (well A5-1, tube G6, well A5-2) … ….
And S300, determining a drainage line contained in the drainage pipe network model based on the data structure.
Since each data structure contains one pipe and two wells, the drain can be routed through the repeated wells. For example, the same well occurs both at the back end of data structure m (i.e., after the tube number) and at the front end of data structure n (i.e., after the tube number), then it may be determined that the two data structures are connected by the same well, so that the continuity of the two data structures may be determined from the same well that occurs between the two data structures. Similarly, a plurality of data structures are connected in pairs, so that a coherent drainage line can be formed. For example, in FIG. 2, A1-G1-A2-G2-A3-G3-A5-G4-A6 form a complete drainage line.
And S400, displaying all drainage lines and drainage data corresponding to each drainage line in a table form, wherein the drainage data comprises well numbers, well parameters and pipe parameters.
Displaying the drainage routes in a form of a table may include displaying well numbers and pipe numbers belonging to the same drainage route in the same row or column or the same area of the table, so that a user can clearly see which wells and which pipes are respectively contained in different drainage routes. Further, well parameters or pipe parameters in a drain line may also be placed in the same row or column or region of the table, thereby facilitating accurate engineering calculations based on the table. Specifically, the well parameters may include any one or more of a well map set, a well size, a use, a drop, a well depth, a well top elevation, an original ground elevation, a road surface design elevation, and a road bed line elevation, and the pipe parameters may include any one or more of a pipe bottom elevation, a pipe diameter, a pipe length, and a pipe base map set.
Through the steps, the drainage lines contained in the drainage pipe network model can be automatically calculated, visual display is carried out through a table form, and efficiency and accuracy of drainage calculation are improved.
Fig. 3 shows a schematic flow chart of the creation of multiple data structures in a first embodiment of the invention. As shown in fig. 3, the step of creating a plurality of data structures according to the well pipe undirected graph in S200 includes: the method comprises the steps of carrying out a first treatment on the surface of the
Storing said each tube and the well connected to said each tube as a data structure.
And S210, acquiring wells connected with each pipe according to the well pipe undirected graph. It will be appreciated that each well or pipe in the well pipe undirected graph corresponds to a unique one of the primitive IDs, referred to in this embodiment as a well ID or pipe ID, when stored. Meanwhile, in the drainage pipe network model or the well pipe undirected graph, each well is also corresponding to a well number, and the well number is added by a drawing designer for identifying different wells. Empirically, the well numbers on one drain line are typically ordered by the same prefix, such as well numbers A1, A2, A3, A5, A6, etc. in fig. 2. The pipes used in the construction site are all of the same type and are not required to be distinguished, so that the pipes can not be numbered. Of course, in this embodiment, for convenience of explanation, a tube number such as G1, G2, G3, G4, etc. is also added to each tube. It will be appreciated that each pipe connects at most two wells, and that each well may connect multiple pipes simultaneously. The example of fig. 2 includes the following well tubular connection relationships: well number A1-tube number G1, well number A2-tube number G2, … … well number A5-tube number G3, well number A5-tube number G4, well number A5-tube number G5 … …. From the above connection, the well to which each pipe is connected can be determined.
S220:
Storing said each tube and the well connected to said each tube as a data structure.
In the above example, the three well numbers A1, G1, and A2 are used as one data structure based on the well number A1 and A2 connected to the pipe number G1 in the query. When a pipe number is not added, a corresponding pipe ID may also be stored in the data structure. Further, the front and back positions of two well numbers may be determined based on the size of the well number, e.g., a smaller well number is located before the tube number and a larger well number is located after the tube number.
Through the steps, a plurality of data structures contained in the drainage pipe network model can be obtained, and a foundation is provided for subsequent drainage line calculation.
Fig. 4 shows a schematic flow chart of determining a drain line based on a data structure in a first embodiment of the invention. As shown in fig. 4, the schematic flowchart of determining the drain line in step S300 includes the steps of:
s310, acquiring well numbers of wells in the data structure, and establishing a mapping relation between the well numbers and the data structure; wherein the mapping relation comprises a forward mapping relation and a backward mapping relation.
As previously mentioned, a single tube and two wells may be included in a data structure, with one well necessarily being at the front end of the tube and the other well being at the rear end of the tube. For example, in data structure 1 (well A1, tube G1, well A2), well A1 is at the front end of tube G1 and well A1 is at the rear end of tube G2. In this embodiment, the relationship between the well at the front end of the pipe and the corresponding data structure is referred to as a forward mapping relationship, and the relationship between the well at the rear end of the pipe and the corresponding data structure is referred to as a backward mapping relationship. For example, a forward mapping relationship is between well A1 and data structure 1, and a backward mapping relationship is between well A2 and data structure 1.
And S320, sorting all the well numbers, and taking the well number with the smallest sorting as the target well number.
It is considered that a designer is used to represent wells on the same water line with the same type of letter or symbol when drawing the drawing, and numbering is usually performed in order from small to large. Based on this, the present embodiment will first sort the well numbers in order to determine the well at the beginning of the drain line. Taking fig. 2 as an example, the well numbers include A1, A2, A3, A5-1, A5-2, A6, and B1, B2, B3, B4, B5, B6. The well numbers of the same type are arranged in order from small to large, so that the well numbers A1 and B1 with the smallest sequence can be obtained, wherein A1 and B1 are the wells positioned at the end parts of different drainage lines respectively, and A1 or B1 can be selected as a starting well number.
S330, inquiring a target data structure containing the target well number.
Assuming A1 as the target well number, querying the data structure containing A1 may result in data structure 1 (well A1, tube G1, well A2), where well A1 and data structure 1 are forward mapped. In addition, assuming the target well number is A2, querying the data structure containing A2 may result in data structure 1 (well A1, pipe G1, well A2) and data structure 2 (well A2, pipe G2, well A3), where well A2 and data structure 1 are backward mappings and well A2 and data structure 2 are forward mappings.
And S340, searching a first well number with a backward mapping relation with the target data structure when the forward mapping relation is between the target well number and the target data structure.
When the target well number is A1 and the target data structure is a data structure 1, it may be determined that the target well number and the target data structure are in a forward mapping relationship, and the well number in a backward mapping relationship with the target data structure is A2. When the target well number is A2 and the target data structure is the data structure 2, the well number which is in a backward mapping relation with the target data structure is A3.
And S350, taking the first well number as the target well number, and repeatedly executing the step of searching the first well number.
This step enables traversing all associated data structures so that all wells connected with the same line strike can be obtained. Specifically, when well A1 is the target well number, a first well number A2 may be determined; when well A2 is the target well number, a first well number A3 may be determined. And so on until the corresponding well number is not found. In this case, a backward line direction corresponds.
And S360, searching a second well number with a forward mapping relation with the target data structure when the target well number and the target data structure are in the backward mapping relation.
For example, A2 is the target well number, and the target data structure having a backward mapping relationship with A2 is data structure 1. The second well with the forward mapping relationship to data structure 1 is now numbered A1.
And S370, taking the second well number as the target well number, and repeatedly executing the step of searching the second well number.
This step enables traversing all associated data structures so that all wells connected with the same line strike can be obtained. For example, the correspondence between well number A2 and well number A1 is a forward line trend. For another example, when the initially established target well number is A5, the second well number is sequentially searched forward, and A3, A2, and A1 can be obtained, respectively.
And S380, sequentially connecting all the searched first well numbers with all the second well numbers to obtain a first drainage line.
In the step, all the first well numbers and all the second well numbers are sequentially connected, so that the integrity of the drainage line can be ensured. This is because the smallest ordered destination well number is not necessarily at the end of a rank line, but may be in the middle of a drain line. When the target well number is at the intermediate position of the drainage line, the well number arranged at the rear end of the target well number and the well number arranged at the front end of the target well number can be obtained by searching the first well number and the second well number in different directions forward and backward, respectively. And connecting all the well numbers arranged at the front end, the target well numbers and all the well numbers arranged at the rear end in sequence, so that a complete drainage line can be obtained.
It will be appreciated that some wells will connect multiple tubes simultaneously, thereby forming multiple branches. For the starting well, when a plurality of data structures are obtained by querying the starting well number, one of the data structures may be optionally selected as the first data structure, so that the drain line may be calculated from any one branch. For intermediate wells other than the starting well, when multiple first or second well numbers are queried, the drain line may be determined based on the prefix of the well number or the angle of the pipe. For example, the well number having the same prefix and consecutive numbers is selected as the first well number or the second well number, or the well number having the same prefix and consecutive numbers is selected as the first well number or the second well number. In addition, the angle of the tube refers to the angle of the tube contained in one data structure, and may reflect that the arrangement direction of the tube is a horizontal direction (e.g., 0 degrees), a vertical direction (e.g., 90 degrees), or other directions. In the example of FIG. 2, the data structures containing well number A5 are data structure 3 (well A3, pipe G3, well A5), data structure 4 (well A5, pipe G4, well A6) and data structure 5 (well A5, pipe G5, well A5-1). The candidate data structure at this point includes data structure 4 and data structure 5. It may be determined which data structure is closest to data structure 3 to select based on the angle of tube G4 and the angle of tube G5. It can be seen that the angle of pipe G4 is closest to the angle of pipe G3, so well number A6 in data structure 4 can be selected as the next well number in the drain.
Fig. 5 shows a schematic flow chart of a first embodiment of the invention showing the drain line in tabular form. As shown in fig. 5, step S400 includes:
s410, displaying well numbers in all data structures contained in the drainage line in sequence in a first data column of a line table; the first data column comprises repeated well numbers, and each well number corresponds to one cell.
S420, displaying a pipe number corresponding to each well number in the drainage line in a second data column of the line table, wherein each pipe number and the well number connected with each pipe number are positioned in the same row; the second data column contains repeated pipe numbers, and each pipe number corresponds to one cell.
FIG. 6 shows a schematic diagram of an embodiment of the present invention showing well numbers and pipe numbers in tabular form. As shown in FIG. 6, the first column is the well number and the second column is the tube number in the left half of the table. Since in one drain, the wells other than the starting well are connected to both tubes at the same time, each well in the first column is repeated twice. Similarly, one pipe in the drain line connects two wells simultaneously, so each pipe in the second column is repeated twice. It can be seen that in the left half of the table, the wells and pipes with connection are in the same row.
And S430, merging the cells containing the repeated well numbers continuously in the first data column, and merging the cells containing the repeated tube numbers in the second data column.
The right half of fig. 6 shows the effect diagram after merging the cells. It can be seen that the well numbers and the pipe numbers after merging the cells are no longer in one-to-one correspondence but are offset from each other. This misalignment can more clearly and intuitively indicate the connection of a single pipe to two wells. As can be seen from the right-hand table of FIG. 6, well 0 and well 1 are connected by pipe A, well 1 and well 2 are connected by pipe B, and well 2 and well 3 are connected by pipe C.
S440, adding well parameters corresponding to each well number and pipe parameters corresponding to each pipe number; the well parameters and the corresponding well numbers are located in the same row, and the pipe parameters and the corresponding pipe numbers are located in the same row.
Fig. 7 shows a schematic diagram of a drainage calculation table generated from the drainage pipe network model of fig. 2. As shown in fig. 7, the first column on the left shows the well number contained in each line. As can be seen from the partial drain lines included in fig. 7 referring to fig. 7A, in the columns corresponding to the well numbers, the drain lines from A1 to A6 sequentially include A1, A2, A3, A5, and A6, and the drain lines from B1 to B6 sequentially include B1, B2, B3, B4, B5, and B6. Fig. 7B shows a well parameter and pipe parameter schematic corresponding to one of the drainage lines. It can be seen that well parameters include well pattern set, well size, use, drop, well depth, well top elevation, original ground elevation, road surface design elevation, road bed line elevation, and pipe parameters include pipe bottom elevation, pipe diameter, pipe length, and pipe pattern set. As can be seen from fig. 7B, there is a certain misalignment between the rows of well parameters and the rows of pipe parameters, which better reflects the connection between different well pipes.
And S450, deleting the second data column in response to that all the pipes corresponding to the pipe numbers are of the same type.
It is noted that the column corresponding to the tube number is not included in fig. 7B. The present invention is not limited to the above-described embodiments, and various modifications may be made without departing from the scope of the present invention.
Further, the drainage calculation table in this embodiment may also receive and store modified well parameters and/or pipe parameters for modification by the user according to actual needs. In addition, in this embodiment, there is an association relationship between different well parameters belonging to the same line, for example, after changing the well atlas, the well parameters such as the corresponding well size, drop, well depth, etc. will also be changed accordingly. Similarly, there is an association between different pipe parameters of the same line, and when one of the pipe parameters is modified, the other pipe parameters can be automatically changed. In addition, the present embodiment may also set the same well parameter corresponding to different well numbers in the same drainage line to the same value, or set the same pipe parameter corresponding to different pipe numbers in the same drainage line to the same value. Through the functions, the drainage calculation table of the embodiment can flexibly and cooperatively modify parameters, greatly improve the efficiency of parameter modification and ensure the consistency and accuracy of modified data.
With continued reference to fig. 8, a drainage data display device is shown, in this embodiment, the drainage data display device 80 may include or be divided into one or more program modules, where the one or more program modules are stored in a storage medium and executed by one or more processors to complete the present invention, and may implement the drainage data display method. Program modules in the present invention refer to a series of computer program instruction segments capable of performing a specific function, more suitable than the program itself for describing the execution of the drain line data presentation device 80 in a storage medium. The following description will specifically describe functions of each program module of the present embodiment:
the model acquisition module 81 is suitable for acquiring a drainage pipe network model and determining the connection relation between a well and a pipe in the drainage pipe network model;
a data structure module 82 adapted to establish a plurality of data structures according to the connection between the wells and the pipes, each data structure comprising a pipe and two wells connected to both ends of the pipe;
a line determination module 83 adapted to determine a drain line contained in the drain pipe network model based on the data structure;
the table display module 84 is adapted to display all drainage lines and drainage data corresponding to each drainage line in a table format, wherein the drainage data includes well numbers, well parameters and pipe parameters.
The present embodiment also provides a computer device, such as a smart phone, a tablet computer, a notebook computer, a desktop computer, a rack-mounted server, a blade server, a tower server, or a rack-mounted server (including an independent server or a server cluster formed by a plurality of servers) that can execute a program. The computer device 90 of the present embodiment includes at least, but is not limited to: a memory 91, a processor 92, which may be communicatively coupled to each other via a system bus, as shown in fig. 9. It should be noted that FIG. 9 only shows a computer device 90 having components 91-92, but it should be understood that not all of the illustrated components are required to be implemented and that more or fewer components may alternatively be implemented.
In the present embodiment, the memory 91 (i.e., readable storage medium) includes a flash memory, a hard disk, a multimedia card, a card memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a read-only memory (ROM), an electrically erasable programmable read-only memory (EEPROM), a programmable read-only memory (PROM), a magnetic memory, a magnetic disk, an optical disk, and the like. In some embodiments, the memory 91 may be an internal storage unit of the computer device 90, such as a hard disk or memory of the computer device 90. In other embodiments, the memory 91 may also be an external storage device of the computer device 90, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card) or the like, which are provided on the computer device 90. Of course, the memory 91 may also include both internal storage units of the computer device 90 and external storage devices. In this embodiment, the memory 91 is typically used to store an operating system and various types of application software installed on the computer device 90, such as program codes of the data display device 80 of the drain line of the first embodiment. Further, the memory 91 may be used to temporarily store various types of data that have been output or are to be output.
The processor 92 may be a central processing unit (Central Processing Unit, CPU), controller, microcontroller, microprocessor, or other data processing chip in some embodiments. The processor 92 is typically used to control the overall operation of the computer device 90. In this embodiment, the processor 92 is configured to execute the program code stored in the memory 91 or process data, for example, execute the data display device 90 of the drain line, so as to implement the data display method of the drain line of the first embodiment.
The present embodiment also provides a computer-readable storage medium such as a flash memory, a hard disk, a multimedia card, a card-type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a read-only memory (ROM), an electrically erasable programmable read-only memory (EEPROM), a programmable read-only memory (PROM), a magnetic memory, a magnetic disk, an optical disk, a server, an App application store, etc., on which a computer program is stored, which when executed by a processor, performs the corresponding functions. The computer readable storage medium of the present embodiment is used for storing the data display device 80 of the drain line, and when executed by the processor, implements the data display method of the drain line of the first embodiment.
The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps of the process, and further implementations are included within the scope of the preferred embodiment of the present invention in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present invention.
It will be appreciated by those of ordinary skill in the art that all or part of the steps carried out in the method of the above-described embodiments may be implemented by a program to instruct related hardware, and the program may be stored in a computer readable medium, where the program when executed includes one or a combination of the steps of the method embodiment.
In the description of the present specification, a description referring to terms "one embodiment," "some embodiments," "examples," "specific examples," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present invention. In this specification, schematic representations of the above terms do not necessarily refer to the same embodiments or examples. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment.
The foregoing description is only of the preferred embodiments of the present invention, and is not intended to limit the scope of the invention, but rather is intended to cover any equivalents of the structures or equivalent processes disclosed herein or in the alternative, which may be employed directly or indirectly in other related arts.

Claims (8)

1. The data display method of the drainage line is characterized by comprising the following steps of:
acquiring a drainage pipe network model, and establishing a well pipe undirected graph according to the position relationship between a well and a pipe contained in the drainage pipe network model;
acquiring wells connected with each pipe according to the well pipe undirected graph;
storing each pipe and the well connected with each pipe as a data structure, wherein each data structure comprises one pipe and two wells connected at two ends of the one pipe;
acquiring well numbers of wells in the data structure, and establishing a mapping relation between the well numbers and the data structure; wherein the mapping relation comprises a forward mapping relation and a backward mapping relation;
sequencing all the well numbers, and taking the well number with the smallest sequencing as a target well number;
querying a target data structure containing the target well number;
searching a first well number with a backward mapping relation with the target data structure when the forward mapping relation is between the target well number and the target data structure;
taking the first well number as the target well number, and repeatedly executing the step of searching the first well number;
searching a second well number with a forward mapping relation with the target data structure when the target well number and the target data structure are in the backward mapping relation;
taking the second well number as the target well number, and repeatedly executing the step of searching the second well number;
sequentially connecting all the searched first well numbers with all the second well numbers to obtain a first drainage line;
displaying all drainage lines and drainage data corresponding to each drainage line in a table form, wherein the drainage data comprises well numbers, well parameters and pipe parameters.
2. The method of claim 1, wherein, in response to searching for a plurality of the first well numbers or a plurality of the second well numbers,
determining the first well number or the second well number according to the prefix of the target well number; or alternatively
The first well number or the second well number is determined according to an angle of a pipe connected to the first well number or an angle of a pipe connected to the second well number.
3. The method for displaying drainage line data according to claim 1, wherein the step of displaying all drainage lines and drainage data corresponding to each drainage line in a table form comprises:
displaying well numbers in all data structures contained in the drainage line in sequence in a first data column of a line table; the first data column comprises repeated well numbers, and each well number corresponds to one cell;
displaying a pipe number corresponding to each well number in the drainage line in a second data column of the line table, wherein each pipe number and the well number connected with each pipe number are positioned in the same row; the second data column comprises repeated pipe numbers, and each pipe number corresponds to one cell;
merging cells containing repeated well numbers in succession in the first data column, and merging cells containing repeated pipe numbers in the second data column;
adding well parameters corresponding to each well number and pipe parameters corresponding to each pipe number; the well parameters and the corresponding well numbers are positioned in the same row, and the pipe parameters and the corresponding pipe numbers are positioned in the same row;
and deleting the second data column in response to all the pipes corresponding to the pipe numbers being of the same type.
4. The method for displaying drainage data of drainage lines according to claim 3, further comprising, after the step of displaying all drainage lines and drainage data corresponding to each drainage line in a table format:
and receiving and storing the modified well parameters and/or pipe parameters, wherein the different well parameters belonging to the same line have an association relationship, and the different pipe parameters belonging to the same line have an association relationship.
5. A method of displaying drainage line data according to claim 3, wherein the well parameters include any one or more of a well pattern set, a well size, a use, a drop, a well depth, a well top elevation, a ground elevation, a road surface design elevation, and a road bed line elevation, and the pipe parameters include any one or more of an inner pipe bottom elevation, a pipe diameter, a pipe length, and a pipe base pattern set.
6. A data presentation device for a drain line, comprising:
the model acquisition module is suitable for acquiring a drainage pipe network model and determining the connection relation between a well and a pipe in the drainage pipe network model;
the data structure module is suitable for acquiring wells connected with each pipe according to the well pipe undirected graph; storing each pipe and the well connected with each pipe as a data structure, wherein each data structure comprises one pipe and two wells connected at two ends of the one pipe;
the line determining module is suitable for acquiring the well number of the well in the data structure and establishing a mapping relation between the well number and the data structure; wherein the mapping relation comprises a forward mapping relation and a backward mapping relation; sequencing all the well numbers, and taking the well number with the smallest sequencing as a target well number; querying a target data structure containing the target well number; searching a first well number with a backward mapping relation with the target data structure when the forward mapping relation is between the target well number and the target data structure; taking the first well number as the target well number, and repeatedly executing the step of searching the first well number; searching a second well number with a forward mapping relation with the target data structure when the target well number and the target data structure are in the backward mapping relation; taking the second well number as the target well number, and repeatedly executing the step of searching the second well number; sequentially connecting all the searched first well numbers with all the second well numbers to obtain a first drainage line;
the table display module is suitable for displaying all drainage lines and drainage data corresponding to each drainage line in a table form, wherein the drainage data comprises well numbers, well parameters and pipe parameters.
7. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any one of claims 1 to 5 when the computer program is executed by the processor.
8. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method according to any one of claims 1 to 5.
CN202010943335.2A 2020-09-09 2020-09-09 Drainage line data display method and device, computer equipment and storage medium Active CN112100272B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010943335.2A CN112100272B (en) 2020-09-09 2020-09-09 Drainage line data display method and device, computer equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010943335.2A CN112100272B (en) 2020-09-09 2020-09-09 Drainage line data display method and device, computer equipment and storage medium

Publications (2)

Publication Number Publication Date
CN112100272A CN112100272A (en) 2020-12-18
CN112100272B true CN112100272B (en) 2024-04-12

Family

ID=73751373

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010943335.2A Active CN112100272B (en) 2020-09-09 2020-09-09 Drainage line data display method and device, computer equipment and storage medium

Country Status (1)

Country Link
CN (1) CN112100272B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112814111B (en) * 2020-12-31 2022-05-10 天津市市政工程设计研究院 Drainage pipeline positioning method based on probability
CN113537605B (en) * 2021-07-22 2024-04-30 广联达科技股份有限公司 Method, system and device for determining drainage line
CN115062442B (en) * 2022-07-07 2023-03-28 中交水运规划设计院有限公司 Model deployment method and device for water supply and drainage line, electronic equipment and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108399652A (en) * 2018-02-12 2018-08-14 广州市城市规划勘测设计研究院 Method, apparatus, storage medium and the terminal device of City Buried Pipeline three-dimension monitor model foundation
CN109165412A (en) * 2018-07-27 2019-01-08 中国电力科学研究院有限公司 A kind of cable duct bank engineering design method and system based on GIS-Geographic Information System
CN110130984A (en) * 2019-04-18 2019-08-16 北京信息科技大学 Water bursting in mine stretch evaluation method and calculate equipment
CN110717088A (en) * 2019-09-04 2020-01-21 江苏能电科技有限公司 Electronic document-based device management method, apparatus, device and storage medium

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20190325331A1 (en) * 2018-04-20 2019-10-24 Qri Group, Llc. Streamlined framework for identifying and implementing field development opportunities

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108399652A (en) * 2018-02-12 2018-08-14 广州市城市规划勘测设计研究院 Method, apparatus, storage medium and the terminal device of City Buried Pipeline three-dimension monitor model foundation
CN109165412A (en) * 2018-07-27 2019-01-08 中国电力科学研究院有限公司 A kind of cable duct bank engineering design method and system based on GIS-Geographic Information System
CN110130984A (en) * 2019-04-18 2019-08-16 北京信息科技大学 Water bursting in mine stretch evaluation method and calculate equipment
CN110717088A (en) * 2019-09-04 2020-01-21 江苏能电科技有限公司 Electronic document-based device management method, apparatus, device and storage medium

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
城市排水GIS系统拓扑模型的建立;王萌;史明昌;;测绘通报(第08期);全文 *
基于CADTableConvert和雨水管网设计计算表的自动SWMM水力模型构建方法研究;杨伟明;刘子龙;周玉文;王中正;高琳;;给水排水(第04期);全文 *

Also Published As

Publication number Publication date
CN112100272A (en) 2020-12-18

Similar Documents

Publication Publication Date Title
CN112100272B (en) Drainage line data display method and device, computer equipment and storage medium
CN110415349B (en) Three-dimensional pipeline modeling method and device
CN110647611A (en) Element attribute labeling method and device based on ArcGIS platform, electronic equipment and computer readable storage medium
CN112348873A (en) Method, system, medium and device for marking three-dimensional size of ship pipe section model
CN115641407A (en) Three-dimensional pipe network incremental updating modeling method and device, storage medium and electronic equipment
CN115688341B (en) Distribution network thematic map layout method based on multi-tree collision detection and storage medium
CN109739859B (en) Relation map drawing method, system and related device
CN116777671A (en) Large-scale energy storage resource management method and system based on automatic topology display generation
CN109710785A (en) A kind of management method, device, system and the storage medium of picture library figure cluster
CN111680376B (en) Method, device and system for constructing polygon by line elements
CN110390725B (en) Pipeline completion map generation method, device and system
CN116011157A (en) Automatic desk CAD and Revit secondary development-based pipeline rapid extraction modeling method
CN113223167B (en) Three-dimensional weather sand table building method and system
Lee Geographic and cartographic contexts in generalization
CN107423520A (en) Based on CAD secondary development rapid extraction pipeline information SWMM modeling methods
CN113901560A (en) Data processing method and device for water supply and drainage construction drawing and drawing operation system
CN111160831A (en) Intensive storage task generation method and device and electronic equipment
Borkowski et al. USE OF THE CDE ENVIRONMENT IN TEAM COLLABORATION IN BIM
CN110750818B (en) Height marking method, system and storage medium for drainage well design
CN115062442B (en) Model deployment method and device for water supply and drainage line, electronic equipment and storage medium
CN112436439B (en) Method and device for laying cable bridge of photovoltaic power station
CN102542095B (en) Processing method and system of basic configuration of power transmission line
CN114429639A (en) Pipeline marking identification method and device
JP3883644B2 (en) Leader line automatic creation method, leader line automatic creation apparatus and program storage medium therefor
CN113971494A (en) Path track display method and device, electronic equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant