Water supply network on-line hydraulic model construction method, device, equipment and medium
By building an online hydraulic model of the water supply pipeline network, the problems of changes in the topology structure of the water supply pipeline network and inaccurate measurement data are solved, real-time updates and accuracy improvements of the model are achieved, and more effective water supply pipeline management and planning are supported.
Patent Information
- Application Number
- CN202411932248.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-26
- Publication Date
- 2025-04-22
- Estimated Expiration
- 2044-12-26
AI Technical Summary
The existing online hydraulic model of the water supply network cannot automatically update the topological structure and cannot effectively deal with structural changes caused by urban development and pipeline transformation. At the same time, due to the incomplete advanced metrology facilities, there are data with a long metrology cycle, which makes water allocation difficult on the time scale, affecting the model accuracy.
By obtaining the monitoring data, revenue data and geographical information data of each pipeline node in the regional metrology area of the target area water supply pipeline network, the water consumption data and leakage water leakage data of each pipeline node are calculated and determined, and combined with the conservation equation of mass, energy conservation equation and pipeline pressure drop equation, an online hydraulic model of the water supply pipeline network is constructed to realize the online update of topological structure and node water demand.
The water supply pipeline model topology and node water demand are achieved simultaneously online update, which reduces the impact of topology changes on model accuracy, improves the time scale accuracy of water volume allocation, reduces the tedious work of model update and maintenance in later stages, and improves the planning and management efficiency of the water supply pipeline system.
Smart Images

Figure CN119862177A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of water supply pipe networks, and in particular to a method for constructing an online hydraulic model of a water supply pipe network, a corresponding device, an electronic device, and a computer-readable storage medium. Background Art
[0002] The water supply network system is an important part of urban infrastructure and accounts for a considerable proportion of the investment in the entire water supply system. The safe and stable operation of the entire water supply network system can not only improve the water quantity, water quality and water pressure of urban water use, but also reduce the waste of water resources and increase the revenue of water companies.
[0003] The hydraulic model can reflect the actual operation status of the pipe network and is used by water companies to plan and manage the entire water supply pipe network system. The hydraulic model includes offline hydraulic models and online hydraulic models. The offline hydraulic model requires manual data update and has the limitations of poor real-time performance, strong manual dependence and low intelligence, especially for emergency events. In contrast, the online hydraulic model has the functions of automatic update of operation data and scheduled automatic simulation calculation, which can obtain the operation status of the pipe network in a timely manner. However, with the in-depth development of cities and towns and the frequent transformation of pipelines, the topological structure of the water supply pipe network is constantly changing. The existing online hydraulic model mainly focuses on the online update of node water demand and cannot automatically update the topological structure to effectively meet this challenge.
[0004] At the same time, node water demand is the most uncertain dynamic variable in the hydraulic model of the water supply network, and its reasonable allocation is the premise for ensuring the accuracy of the model. However, in some developing countries or underdeveloped areas, due to the imperfect advanced metering facilities, there are a large number of data with long metering cycles, which makes it difficult to allocate water on a time scale, further affecting the accuracy of the model.
[0005] To sum up, in the existing technology, with the in-depth development of towns and the frequent transformation of pipelines, the topological structure of the water supply network is constantly changing, and the topological structure cannot be automatically updated to effectively respond to this challenge. In addition, due to the imperfect advanced metering facilities, there is a large amount of data with a long metering cycle, which makes the allocation of water on a time scale difficult. The applicant has made corresponding explorations to solve these problems. Summary of the invention
[0006] The purpose of the present application is to solve the above-mentioned problems and to provide a method for constructing an online hydraulic model of a water supply network, a corresponding device, an electronic device and a computer-readable storage medium.
[0007] In order to meet the various objectives of this application, this application adopts the following technical solutions:
[0008] A method for constructing an online hydraulic model of a water supply network proposed to meet one of the purposes of this application includes:
[0009] In response to the instruction to build an online hydraulic model of the water supply network, the network node monitoring data, network node revenue data and network geographic information data corresponding to each network node in the regional metering area of the target area water supply network are obtained, wherein the target area water supply network includes multiple regional metering areas, the network node revenue data includes remote meter time series data, and the network node monitoring data represents the node pressure data of each network node monitored in real time and its corresponding pipe section flow data;
[0010] Calculate and determine the water consumption data of each hand-copied meter in each time period according to the daily average water volume of each hand-copied meter, the time series data of the first remote meter with a similar daily average water volume and the same water type as that of each hand-copied meter, and the time series data of the second remote meter; and calculate and determine the hand-copied meter water volume corresponding to each pipe network node in the regional metering area according to the water consumption data of each hand-copied meter in each time period;
[0011] Calculate and determine the amount of water loss corresponding to each pipe network node in the regional metering area according to the amount of water loss in the regional metering area, the total length of the pipes in the regional metering area, and the total length of the pipes corresponding to each pipe network node in the regional metering area;
[0012] Calculate and determine the node water demand data corresponding to each pipe network node in the regional metering area according to the sum of the remote meter water volume, the hand-read meter water volume and the leakage water volume corresponding to each pipe network node in the regional metering area;
[0013] An online hydraulic model of the water supply network in the target area is constructed based on the mass conservation equation, energy conservation equation, pipeline pressure drop equation of the water supply network in the target area, the network topology structure of the regional metering area, the network node monitoring data and the node water demand data corresponding to each network node in the regional metering area.
[0014] Optionally, after the step of obtaining the pipe network node monitoring data and pipe network node revenue data corresponding to each pipe network node in the regional metering area of the target regional water supply pipe network, the method further includes:
[0015] In response to the data preprocessing instruction, the pipeline node monitoring data and pipeline node revenue data corresponding to each pipeline node in the regional metering area are cleaned to obtain regular, continuous and complete time series data.
[0016] Optionally, the steps of calculating and determining the water consumption data of each hand-copy meter in each time period according to the daily average water volume of each hand-copy meter, the time series data of the first remote meter with a similar daily average water volume and the same water use type as that of each hand-copy meter, and the time series data of the second remote meter, and calculating and determining the hand-copy meter water volume corresponding to each pipe network node in the regional metering area according to the water consumption data of each hand-copy meter in each time period include:
[0017] Calculate and determine the average daily water volume of each manual meter and the average daily water volume of the same type of remote meters;
[0018] Matching the first remote meter and the second remote meter with a daily average water volume similar to that of each hand-copied meter and the same water use type to obtain time series data of the first remote meter and the second remote meter;
[0019] According to the daily average water volume corresponding to the first remote meter, the daily average water volume corresponding to the second remote meter, the time series data of the first remote meter and the time series data of the second remote meter, each interpolation water consumption curve value of the hand-copied meter is calculated and determined, and according to each interpolation water consumption curve value, an interpolation curve average value of each hand-copied meter is calculated and determined;
[0020] According to each interpolation water consumption curve value of each hand-copied meter and the average value of the interpolation curve, the water consumption mode value of each hand-copied meter is calculated and determined;
[0021] Determine the basic water volume of each hand-copied meter, determine the water consumption data of each hand-copied meter in each time period according to the first product between the water consumption mode value of each hand-copied meter and the basic water volume of each hand-copied meter, and calculate and determine the hand-copied meter water volume corresponding to each pipe network node in the regional metering area according to the water consumption data of each hand-copied meter in each time period.
[0022] Optionally, the step of calculating and determining the amount of water loss corresponding to each pipe network node in the regional metering area according to the amount of water loss in the regional metering area, the total length of the pipes in the regional metering area, and the total length of the pipes corresponding to each pipe network node in the regional metering area includes:
[0023] Calculating and determining a first difference between an inlet water volume of the regional metering area and an outlet water volume of the regional metering area to determine a total water consumption of the regional metering area;
[0024] The first sum of the total water volume of the remote meters in the regional metering area and the total water volume of the hand-read meters in the regional metering area is calculated and determined, and the second difference between the total water consumption in the regional metering area and the first sum is calculated and determined to determine the water loss in the regional metering area.
[0025] Optionally, the step of calculating and determining the amount of water loss corresponding to each pipe network node in the regional metering area according to the amount of water loss in the regional metering area, the total length of the pipes in the regional metering area, and the total length of the pipes corresponding to each pipe network node in the regional metering area includes:
[0026] Determine the water loss in the regional metering area, calculate and determine a first ratio between the water loss in the regional metering area and the total length of the pipeline in the regional metering area to determine the specific flow rate;
[0027] The second product between one half of the total length of the pipeline corresponding to each pipe network node in the regional metering area and the specific flow rate is calculated to determine the leakage water volume corresponding to each pipe network node in the regional metering area.
[0028] Optionally, after the step of constructing an online hydraulic model of the water supply network in the target area according to the mass conservation equation, energy conservation equation, pipeline pressure drop equation of the water supply network in the target area, the network topology of the regional metering area, the network node monitoring data, and the node water demand data corresponding to each network node in the regional metering area, the method further comprises:
[0029] The node water demand data corresponding to each network node in the target area water supply network is input into the online hydraulic model of the target area water supply network to determine the node pressure data and pipe section flow data corresponding to each network node in the target area water supply network.
[0030] Optionally, the target area includes a town or a city, the regional metering area includes a commercial area, a residential area and an industrial area, and the pipeline network node represents a commercial area, a residential area or an industrial area.
[0031] A water supply network online hydraulic model building device provided for another purpose of the present application includes:
[0032] A data acquisition module is configured to respond to an instruction to construct an online hydraulic model of a water supply network, and acquire network node monitoring data, network node revenue data, and network geographic information data corresponding to each network node in a regional metering area of a target regional water supply network, wherein the target regional water supply network includes multiple regional metering areas, the network node revenue data includes remote meter time series data, and the network node monitoring data represents node pressure data for real-time monitoring of each network node and its corresponding pipe section flow data;
[0033] The manual meter water volume determination module is configured to calculate and determine the water consumption data of each manual meter in each time period based on the daily average water volume of each manual meter, the time series data of the first remote meter that is similar to the daily average water volume of each manual meter and has the same water use type, and the time series data of the second remote meter, and calculate and determine the manual meter water volume corresponding to each pipe network node in the regional metering area based on the water consumption data of each manual meter in each time period;
[0034] A leakage water volume determination module is configured to calculate and determine the leakage water volume corresponding to each pipe network node in the regional metering area according to the leakage water volume of the regional metering area, the total length of the pipes in the regional metering area, and the total length of the pipes corresponding to each pipe network node in the regional metering area;
[0035] A node water demand determination module is configured to calculate and determine the node water demand data corresponding to each pipe network node in the regional metering area according to the sum of the remote meter water volume, the hand-read meter water volume and the leakage water volume corresponding to each pipe network node in the regional metering area;
[0036] The hydraulic model construction module is configured to construct an online hydraulic model of the water supply network in the target area based on the mass conservation equation, energy conservation equation, pipeline pressure drop equation of the water supply network in the target area, the network topology structure of the regional metering area, the network node monitoring data, and the node water demand data corresponding to each network node in the regional metering area.
[0037] An electronic device provided to meet another purpose of the present application includes a central processing unit and a memory, wherein the central processing unit is used to call and run a computer program stored in the memory to execute the steps of the method for constructing an online hydraulic model of a water supply network described in the present application.
[0038] A computer-readable storage medium is provided to meet another purpose of the present application, which stores a computer program implemented according to the method for constructing an online hydraulic model of a water supply network in the form of computer-readable instructions. When the computer program is called and executed by a computer, the steps included in the corresponding method are executed.
[0039] Compared with the prior art, the present application aims at the following problems in the prior art: with the in-depth development of towns and the frequent transformation of pipelines, the topological structure of the water supply network is constantly changing, and the topological structure cannot be automatically updated to effectively cope with this challenge; and due to the imperfect advanced metering facilities, there is a large amount of data with a long metering cycle, which makes the allocation of water on a time scale difficult. The present application includes but is not limited to the following beneficial effects:
[0040] The present application constructs an online hydraulic model of the water supply network in the target area according to the mass conservation equation, energy conservation equation, pipeline pressure drop equation, network topology of the target area, network node monitoring data, and node water demand data corresponding to each network node in the regional metering area. It realizes the simultaneous online update of the topology of the water supply network model and the node water demand, reduces the influence of the change of the network topology on the model accuracy, and thus greatly saves the manpower, material and financial resources spent on the later update and maintenance of the online hydraulic model.
[0041] Furthermore, in terms of water distribution, by using the same type of remote water meter data with similar daily average water volume for interpolation, the water consumption mode of the hand-copied meter is obtained online, making the water distribution more realistic in terms of time scale, and effectively improving the accuracy of the model. This technical solution can better adapt to the application scenarios of rapid urban development and frequent pipeline transformation, effectively respond to the continuous changes in the topological structure of the water supply network, reduce the tedious work of later model updates and maintenance, and improve the simulation accuracy of the hydraulic model of the water supply network, thereby further guiding the planning and management of the water supply network system and promoting the digital development of the water industry;
[0042] Furthermore, the present application simulates and calculates the operating status of the urban water supply network through an online hydraulic model of the water supply network, so as to obtain the actual operating conditions of the network in a timely manner, make the operation of the urban water supply network safer and more stable, reduce the harm caused by abnormal accidents to the network system, and ensure normal water use for residents. BRIEF DESCRIPTION OF THE DRAWINGS
[0043] The above and / or additional aspects and advantages of the present application will become apparent and easily understood from the following description of the embodiments in conjunction with the accompanying drawings, in which:
[0044] Figure 1 A schematic diagram of a flow chart of a method for constructing an online hydraulic model of a water supply network in an embodiment of the present application;
[0045] Figure 2 A schematic diagram of a flow chart for determining the hand-copied meter water volume corresponding to each pipe network node in a regional metering area in an embodiment of the present application;
[0046] Figure 3 A schematic diagram of a process for determining the amount of water loss in a regional metering area in an embodiment of the present application;
[0047] Figure 4 A schematic diagram of a process for determining the amount of water leakage corresponding to each pipe network node in a regional metering area in an embodiment of the present application;
[0048] Figure 5 This is a schematic diagram of the topological structure of the hydraulic model of the S town constructed online using EPyT in an embodiment of the present application;
[0049] Figure 6 A schematic diagram showing the comparison of inconsistent collection time points and missing data for monitoring data or revenue data of town S in an embodiment of the present application;
[0050] Figure 7 It is a schematic diagram of partial pressure simulation error results of the S town in the embodiment of the present application;
[0051] Figure 8 It is a schematic diagram of partial flow simulation error results of S town in the embodiment of the present application;
[0052] Fig. 9 This is a principle block diagram of a device for building an online hydraulic model of a water supply network in an embodiment of the present application;
[0053] Fig.10 It is a schematic diagram of the structure of the computer device in the embodiment of the present application. DETAILED DESCRIPTION
[0054] The embodiments of the present application are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present application, and cannot be interpreted as limiting the present application.
[0055] It will be understood by those skilled in the art that, unless expressly stated, the singular forms "one", "said", and "the" used herein may also include plural forms. It should be further understood that the term "comprising" used in the specification of the present application refers to the presence of the features, integers, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, integers, steps, operations, elements, components and / or groups thereof. It should be understood that when we refer to an element as being "connected" or "coupled" to another element, it may be directly connected or coupled to the other element, or there may be an intermediate element. In addition, the "connection" or "coupling" used herein may include wireless connection or wireless coupling. The term "and / or" used herein includes all or any unit and all combinations of one or more associated listed items.
[0056] It will be understood by those skilled in the art that, unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as those generally understood by those skilled in the art to which this application belongs. It should also be understood that terms such as those defined in general dictionaries should be understood to have meanings consistent with those in the context of the prior art, and will not be interpreted with idealized or overly formal meanings unless specifically defined as here.
[0057] It will be understood by those skilled in the art that the "client", "terminal" and "terminal device" used herein include both devices with wireless signal receivers, which are devices with only wireless signal receivers without transmission capabilities, and devices with receiving and transmitting hardware, which are devices with receiving and transmitting hardware capable of two-way communication on a two-way communication link. Such devices may include: cellular or other communication devices such as personal computers, tablet computers, which have single-line displays or multi-line displays or cellular or other communication devices without multi-line displays; PCS (Personal Communications Service, personal communication system), which can combine voice, data processing, fax and / or data communication capabilities; PDA (Personal Digital Assistant, personal digital assistant), which may include a radio frequency receiver, pager, Internet / intranet access, web browser, notepad, calendar and / or GPS (Global Positioning System, global positioning system) receiver; conventional laptop and / or palmtop computers or other devices, which have and / or include a conventional laptop and / or palmtop computer or other device with and / or including a radio frequency receiver. The "client", "terminal" and "terminal device" used herein may be portable, transportable, installed in a vehicle (air, sea and / or land), or suitable for and / or configured to run locally, and / or in a distributed form, at any other location on the earth and / or in space. The "client", "terminal" and "terminal device" used herein may also be a communication terminal, an Internet terminal, a music / video playing terminal, for example, a PDA, a MID (Mobile Internet Device) and / or a mobile phone with a music / video playing function, or a smart TV, a set-top box and other devices.
[0058] The hardware referred to by the names such as "server", "client", and "service node" in this application is essentially an electronic device with the equivalent capabilities of a personal computer. It is a hardware device with the necessary components revealed by the von Neumann principle, such as a central processing unit (including an arithmetic unit and a controller), a memory, an input device, and an output device. The computer program is stored in its memory, and the central processing unit calls the program stored in the external memory into the internal memory for execution, executes the instructions in the program, and interacts with the input and output devices to complete specific functions.
[0059] It should be pointed out that the concept of "server" referred to in this application can also be extended to the case of server clusters. According to the network deployment principle understood by those skilled in the art, the servers should be logically divided. In physical space, these servers can be independent of each other but can be called through interfaces, or integrated into a physical computer or a set of computer clusters. Those skilled in the art should understand this flexibility, and should not use it to restrict the implementation of the network deployment method of this application.
[0060] Unless expressly specified, one or more technical features of the present application can be deployed on a server for implementation and accessed by a client through a remote call to obtain an online service interface provided by the server, or can be directly deployed and run on a client for access.
[0061] The neural network models referenced or may be referenced in this application, unless expressly specified, can be deployed on a remote server and remotely called on the client, or can be deployed and directly called on a client with sufficient device capabilities. In some embodiments, when it runs on the client, its corresponding intelligence can be obtained through transfer learning to reduce the requirements for the client's hardware operating resources and avoid excessive occupation of the client's hardware operating resources.
[0062] Unless explicitly specified, the various data involved in this application can be stored remotely on a server or on a local terminal device, as long as it is suitable for being called by the technical solution of this application.
[0063] Those skilled in the art should be aware that, although the various methods of the present application are described based on the same concept and thus present commonality to each other, unless otherwise specified, these methods can be independently executed. Similarly, for each embodiment disclosed in the present application, they are all proposed based on the same inventive concept, therefore, concepts with the same expression, and concepts that are appropriately changed for convenience despite different expressions, should be understood as equivalent.
[0064] Unless the mutually exclusive relationship between the embodiments to be disclosed in this application is explicitly stated, the relevant technical features involved in each embodiment can be cross-combined to flexibly construct a new embodiment, as long as such combination does not deviate from the creative spirit of this application and can meet the needs of the prior art or solve certain deficiencies in the prior art. Those skilled in the art should be aware of this flexibility.
[0065] See also Figure 1 In one embodiment, the method for constructing an online hydraulic model of a water supply network of the present application includes:
[0066] Step S10, responding to the water supply network online hydraulic model construction instruction, obtaining the network node monitoring data, network node revenue data and network geographic information data corresponding to each network node in the regional metering area of the target area water supply network, wherein the target area water supply network includes multiple regional metering areas, the network node revenue data includes remote meter time series data, and the network node monitoring data represents the node pressure data of each network node monitored in real time and its corresponding pipe section flow data;
[0067] The water supply network online hydraulic model construction system can respond to the water supply network online hydraulic model construction instruction, and obtain the network node monitoring data, network node revenue data and network geographic information data corresponding to each network node in the regional metering area of the target area water supply network, wherein the target area water supply network includes multiple regional metering areas, the network node revenue data includes remote meter time series data, the network node monitoring data represents the node pressure data of each network node monitored in real time and its corresponding pipe section flow data; the network geographic information data (network GIS data) refers to the geographical location of the water supply network. The data on location information and related attributes usually include the spatial location, shape, length, diameter, material, connection points and other information of the pipeline, which can help manage and optimize the pipe network system; the pipe network node revenue data represents the revenue data corresponding to each pipe network node in the water supply pipe network, and the revenue data includes remote meter measurement data and manual meter measurement data; pipe segment flow data refers to the amount of water flowing in a specific pipe segment in the water supply pipe network system, usually expressed in flow units (such as cubic meters per hour (m / h) or liters per second (L / s)); node pressure data refers to the water pressure measured at a specific node in the water supply pipe network system.
[0068] In some embodiments, a District Metered Area (DMA) refers to a city, town, or water supply network system divided into smaller areas, each of which has an independent water meter or flow meter to monitor and manage the inflow and outflow of water.
[0069] In some embodiments, the target area refers to an area where an online hydraulic model of a water supply network needs to be constructed, usually an area with a concentrated population such as a town or city, where tap water is supplied through a pipe network system. Since the pipelines are buried underground, they are concealed and complex, and they supply tap water to residents or other water users all the time. It is necessary to reasonably plan and manage the water supply network to provide sufficient guarantees in terms of water quantity, water quality and water pressure. The target area includes but is not limited to a town or city, such as S town, etc. The regional metering area includes commercial areas, residential areas and industrial areas, and the pipe network nodes represent commercial areas, residential areas or industrial areas, etc.
[0070] In some embodiments, the water supply network online hydraulic model construction method of the present application is applied to a water supply network online hydraulic model construction system, wherein the water supply network online hydraulic model construction system is provided with a processor, and the water supply network online hydraulic model construction method provided by the present application is executed by the processor. The processor can be an actual processor in the water supply network online hydraulic model construction system, or it can be a virtual cloud processor, which is not limited here.
[0071] In some embodiments, the water supply network online hydraulic model construction system includes PostGIS, Python, and EPyT control system, etc. PostGIS is an extension of the object-relational database system PostgreSQL. PostGIS provides the following spatial information service functions: spatial objects, spatial indexes, spatial operation functions, and spatial operators, and can convert the PostgreSQL database management system into a spatial database.
[0072] PostgreSQL is an object-relational database management system and the most powerful, feature-rich and complex free software database system. Python is a high-level, interpreted, general-purpose programming language known for its easy-to-learn syntax, powerful libraries and wide range of applications, suitable for various programming needs of developers. EPANET-Python Toolkit (EPyT) is a third-party library for Python. It is a Python-based programming interface for the open source hydraulic and water quality modeling software EPANET. It has rich modeling functions and supports modeling from scratch.
[0073] In some embodiments, the network node monitoring data may be SCADA monitoring data, which refers to node pressure data and pipeline flow data that are used to monitor various equipment and parameters of network nodes in the water supply network in real time through the SCADA system; the SCADA system stands for Supervisory Control And Data Acquisition, which is a core system for monitoring and controlling the water supply network. It can monitor various parameters in the water supply network in real time, such as pressure, flow, water level, valve status, pump station operation status, etc., automatically collect data from each measuring point, and store these data in a database. When the parameters in the water supply system exceed the set threshold, an alarm is issued to remind the staff to take necessary measures and remotely control the equipment in the water supply network, such as starting or stopping the water pump, adjusting the valve opening, etc.
[0074] In some embodiments, pipeline network geographic information data (pipeline network GIS data), SCADA monitoring data, and revenue data can be obtained through water companies or municipal government departments. After obtaining the pipeline network geographic information data (pipeline network GIS data), SCADA monitoring data, and revenue data of the target area, a spatial database of the water supply network in the target area is established in PostGIS based on the mapping relationship between the pipeline network geographic information data (pipeline network GIS data), SCADA monitoring data, revenue data and pipeline network elements.
[0075] In some embodiments, according to the mapping relationship between the network geographic information data (network GIS data), SCADA monitoring data, revenue data and network elements, the steps of establishing a spatial database of the target area water supply network in PostGIS include:
[0076] Step S101, determine the mapping relationship between the SCADA monitoring table of the water supply network in the target area and the user water meter, the network node or the pipe section, and establish the basic information data table of the SCADA monitoring table and the user water meter;
[0077] Specifically, according to the actual geographic spatial location of the SCADA monitoring table, the numbers of all SCADA pressure monitoring table associated nodes and the numbers of SCADA flow monitoring table associated pipe sections are determined, and the user numbers of the SCADA monitoring table, the numbers of associated nodes or pipes, and the types of tables are statistically organized in a *.csv format file; then, according to the actual geographic spatial location of the user water meter, the numbers of all user water meter associated nodes are determined, and the user numbers of the user water meters, the numbers of associated nodes, the water use types, and the names of the regional metering areas (DMAs) to which they belong are summarized and organized in another *.csv format file; the revenue data includes remote water meter measurement data and manual water meter measurement data;
[0078] In some embodiments, the mapping relationship between the SCADA monitoring table and the pipeline node or pipe section refers to the table and the associated nodes or pipes in the pipeline model; the basic information data table includes information such as the table number, type, and number of the associated node or pipe.
[0079] Step S102, determine the boundaries of the regional metering area (DMA) partitions of the target area, and establish a model calculation summary data table;
[0080] Specifically, the locations of all cut-off pipes and closed valves in the actual pipe network are found, and the regional metering area (DMA) zoning of the entire pipe network is obtained according to the cut-off pipes or closed valves; then the name of each regional metering area (DMA), the import and export SCADA flow monitoring table number, and the numbers of all pipelines and nodes are summarized and organized in a *.csv format file; the model calculation summary data table contains information such as all nodes, pipe sections, and import and export flow monitoring table numbers in the regional metering area (DMA).
[0081] Step S103: Establish a spatial database of the water supply network in the target area in PostGIS based on the network geographic information data (network GIS data), SCADA monitoring data, revenue data, basic information data table and the model calculation summary data table.
[0082] Run PostGIS and create a new spatial database. Use the Shapefile tool in PostGIS to load Shapefile (*.shp) format files such as pipeline geographic information data (pipeline network GIS data) into the database. The pipeline network geographic information data (pipeline network GIS data) includes pipe points, reservoirs, water tanks, pipelines, water pumps and valves. Use pgAdmin to create a new data table, and then use the "Import Data" function in pgAdmin to load *.csv format files such as SCADA monitoring data and revenue data into the database to obtain a database for building an online hydraulic model.
[0083] In some embodiments, the GIS data of nodes, reservoirs, water tanks, pipelines, pumps, and valves are point data and line data Shapefile (*.shp) format files that comply with ESRI standards. ESRI Shapefile is an open spatial data format developed by the Environmental Systems Research Institute (ESRI) of the United States.
[0084] In some embodiments, pgAdmin is an open source graphical tool for managing and developing PostgreSQL databases. It is the official administration tool for the PostgreSQL database management system, providing an easy-to-use interface to perform database management tasks and query data.
[0085] In some embodiments, the steps of querying and acquiring the pipe network geographic information data (pipe network GIS data) of the target area from a preset database and establishing the pipe network topology structure of the target area online using EPyT include:
[0086] Step S1001, querying and obtaining the pipe network geographic information data (pipe network GIS data) of the target area from a preset database;
[0087] Specifically, you can use psycopg2 to connect to the database, and then write SQL query language to query the pipe network geographic information data (pipe network GIS data). Psycopg2 is a third-party library of the Python programming language, which is used to access the PostgreSQL database system. It provides a set of tools and methods that can easily perform database operations in Python programs, including query, insert, update, delete and other operations. SQL (Structured Query Language) is a structured query language, which is an operating language for relational databases and can be applied to all relational databases.
[0088] Step S1002: According to the number, coordinate value and other corresponding attribute information of the Node class element in the pipe network geographic information data (pipe network GIS data), EPyT is used to establish a Node class element model in the topological structure of the water supply pipe network;
[0089] Use PostGIS spatial functions st_x and st_y to obtain the X and Y coordinate values of the Node class data; then call the addNodeJunction, addNodeReservoir and addNodeTank functions in EPyT respectively to establish the Node class element model according to the X and Y coordinate values and their attribute information.
[0090] In some embodiments, in the hydraulic model of the water supply network, the Node class element includes three elements: node, reservoir, and water tank. The main attribute information is shown in Table 1.
[0091] Table 1 Main attribute information of Node class element
[0092] Pipe Network Element Name Property information node Number, elevation and geographic coordinates Reservoir Number, elevation and geographic coordinates Water tank Number, pool bottom elevation and geographic coordinates
[0093] Step S1003: According to the number of Link class elements, the number of starting Node class elements, the number of ending Node class elements and other corresponding attribute information in the network geographic information data (network GIS data), EPyT is used to establish a Link class element model, thereby obtaining a complete water supply network topology structure. The number of the Node class element connected to each Link class element is obtained. For the two network elements of pipes and water pumps, the addLinkPipe and addLinkPump functions in EPyT are called respectively. For valve network elements, the addLinkValveFCV, addLinkValvePRV or addLinkValveTCV functions are called according to the type of valve. Then, according to the number of the Node class element and the attribute information of the Link class element, a Link class element model is established, thereby obtaining a network topology structure, and realizing the online construction function of the topology structure of the online hydraulic model of the water supply network.
[0094] In some embodiments, the Link class element includes three elements: pipe, pump, and valve. The main attribute information is shown in Table 2.
[0095] Table 2 Main attribute information of Link class element
[0096]
[0097] In some embodiments, the pipe network topology refers to the various elements in the pipe network and their connection relationships. Currently, urban water supply pipe networks are mainly ring-shaped pipe networks, while rural or economically backward areas are mainly branch-shaped pipe networks.
[0098] In some embodiments, after the step of obtaining the pipe network node monitoring data and pipe network node revenue data corresponding to each pipe network node in the regional metering area of the target regional water supply pipe network, the method includes:
[0099] In response to the data preprocessing instruction, the pipeline network node monitoring data and pipeline network node revenue data corresponding to each pipeline network node in the regional metering area are cleaned to obtain regular, continuous and complete time series data.
[0100] Specifically, the steps of cleaning the pipeline node monitoring data and pipeline node revenue data corresponding to each pipeline node in the regional metering area to obtain regular, continuous and complete time series data include:
[0101] Step S1100, query and obtain SCADA monitoring data and pipeline network node revenue data from the database;
[0102] Use psycopg2 to connect to the database, and then write SQL query language to query SCADA monitoring data and pipeline node revenue data.
[0103] Step S1200: Use data processing algorithms to clean the SCADA monitoring data and the network node revenue data to obtain regular, complete and continuous time series data.
[0104] Specifically, the steps of data cleaning include:
[0105] 1. Delete duplicate data to obtain time series data without duplicate data;
[0106] 2. Resample the non-repeating time series data to obtain time series data with regular time points;
[0107] 3. Use the data at the most recent time point to fill in the data with inconsistent data collection time points;
[0108] 4. Use linear interpolation method to fill in missing data to obtain regular, continuous and complete time series data.
[0109] The mathematical expression of the linear interpolation method is:
[0110]
[0111] Among them, X t is the value to be filled at time t, X j is the measured value at time j, X i is the measured value at time i, j is the moment after the missing value, i is the moment before the missing value, and Δt is the time difference between time j and time i.
[0112] Step S20, calculating and determining the water consumption data of each hand-copied meter in each time period according to the daily average water volume of each hand-copied meter, the time series data of the first remote meter which is similar to the daily average water volume of each hand-copied meter and has the same water consumption type, and the time series data of the second remote meter, and calculating and determining the hand-copied meter water volume corresponding to each pipe network node in the regional metering area according to the water consumption data of each hand-copied meter in each time period;
[0113] After obtaining the network node monitoring data, network node revenue data and network geographic information data corresponding to each network node in the regional metering area of the target area water supply network, the water consumption data of each manual meter in each time period is calculated based on the daily average water volume of each manual meter, the first remote meter time series data with a similar daily average water volume and the same water use type as each manual meter, and the second remote meter time series data. According to the water consumption data of each manual meter in each time period, the manual meter water volume corresponding to each network node in the regional metering area is calculated;
[0114] See also Figure 2 The steps of calculating and determining the water consumption data of each hand-copied meter in each time period according to the daily average water volume of each hand-copied meter, the time series data of the first remote meter with a similar daily average water volume and the same water type as that of each hand-copied meter, and the time series data of the second remote meter, and calculating and determining the hand-copied meter water volume corresponding to each pipe network node in the regional metering area according to the water consumption data of each hand-copied meter in each time period, include:
[0115] Step S201, calculating and determining the average daily water volume of each manual meter and the average daily water volume of the same type of remote meters;
[0116] Step S202, matching the first remote meter and the second remote meter with a daily average water volume similar to that of each hand-copied meter and with the same water use type, to obtain time series data of the first remote meter and the second remote meter;
[0117] Step S203, calculating and determining each interpolation water consumption curve value of the hand-copied meter according to the daily average water consumption corresponding to the first remote meter, the daily average water consumption corresponding to the second remote meter, the time series data of the first remote meter, and the time series data of the second remote meter, and calculating and determining the average value of the interpolation curve of each hand-copied meter according to each interpolation water consumption curve value;
[0118] Step S204, calculating and determining the water use mode value of each hand-copied meter according to each interpolated water use curve value of each hand-copied meter and the average value of the interpolated curve;
[0119] Step S205: determining the basic water volume of each hand-copied meter, determining the water consumption data of each hand-copied meter in each time period according to the first product between the water consumption mode value of each hand-copied meter and the basic water volume of each hand-copied meter, and calculating and determining the hand-copied meter water volume corresponding to each pipe network node in the regional metering area according to the water consumption data of each hand-copied meter in each time period.
[0120] Specifically, the remote transmission meter time series data represents the corresponding remote transmission meter measurement data in each time period within a preset time range, so as to construct the remote transmission meter time series data.
[0121] Assume that the metering data X of the first remote meter X and the second remote meter Y are similar to the daily average water volume of the manual meter and the same water type i远传 and Y i远传 They are:
[0122] X i远传 =[X1,X2,…,X 23 ,X 24 ],
[0123] Y i远传 =[Y1,Y2,…,Y 23 ,Y 24 ],
[0124] The metering data of the first remote meter X in one day is divided into the metering data of the remote meter in 24 time periods (the time unit is hours), which is represented by X i Remote transmission = [X1, X2, ..., X 23 ,X 24 ], the metering data of the second remote meter Y in one day is divided into the metering data of the remote meter in 24 time periods (the time unit is hours), which is expressed as Y i远传 =[Y1,Y2,…,Y 23 ,Y 24 ].
[0125] Furthermore, the daily average water volume Q of remote meters X and Y is Xave and Q Yave They are:
[0126]
[0127]
[0128] Assume that the average daily water volume of hand-copied meter i is Q iave , interpolation water use curve value I i for:
[0129]
[0130] Interpolation curve average value I iave for:
[0131]
[0132] The water consumption mode value P of the hand-copied meter i i For (normalization process):
[0133]
[0134] Basic water volume D of hand-copied meter i ibase for:
[0135] The value 24 is in hours.
[0136] Water consumption data D of hand-copied meter i i for:
[0137] D i =[P1×D base ,P2×D base ,…,P 23 ×D base ,P 24 ×D base ],
[0138] After the water consumption data of each hand-copied meter in each time period is determined by the above formula, the hand-copied meter water volume corresponding to each pipe network node in the regional metering area is calculated and determined according to the water consumption data of each hand-copied meter in each time period. The water consumption of each pipe network node can be obtained by adding the water consumption of the hand-copied meters connected downstream thereof.
[0139] In some embodiments, the revenue data includes remote meter measurement data and manual meter measurement data. For remote meter measurement data, the data collection frequency is relatively high, and it can generally be accurately allocated on a time scale. For manual meters, data is usually recorded once a month or two months, and the collection frequency is seriously insufficient, so the water volume cannot be accurately allocated on a time scale. The water use pattern refers to the law and trend of water demand changes over time by users of the water supply system within a specific time period. Water use type refers to the way water is used in different scenarios and purposes, and the water use patterns of water meters of the same water use type are similar; water consumption data is equal to the product of the basic water volume and the water use pattern value, and water consumption data refers to the actual water consumption recorded within a specific time period (such as hours, days, months, etc.).
[0140] Step S30, calculating and determining the amount of water loss corresponding to each pipe network node in the regional metering area according to the amount of water loss in the regional metering area, the total length of the pipes in the regional metering area, and the total length of the pipes corresponding to each pipe network node in the regional metering area;
[0141] After calculating and determining the hand-copied meter water volume corresponding to each pipe network node in the regional metering area according to the water consumption data of each hand-copied meter in each time period, calculate and determine the leakage water volume corresponding to each pipe network node in the regional metering area according to the leakage water volume of the regional metering area, the total length of the pipeline in the regional metering area, and the total length of the pipeline corresponding to each pipe network node in the regional metering area;
[0142] In some embodiments, see Figure 3 The step of calculating and determining the amount of water loss corresponding to each pipe network node in the regional metering area according to the amount of water loss in the regional metering area, the total length of the pipes in the regional metering area, and the total length of the pipes corresponding to each pipe network node in the regional metering area comprises:
[0143] Step S301, calculating and determining a first difference between the inlet water volume of the regional metering area and the outlet water volume of the regional metering area to determine the total water consumption of the regional metering area;
[0144] Step S302, calculate and determine a first sum of the total water volume of remote meters in the regional metering area and the total water volume of hand-read meters in the regional metering area, and calculate and determine a second difference between the total water consumption in the regional metering area and the first sum to determine the water loss in the regional metering area.
[0145] More specifically, the mathematical expression for the calculation process of water loss in each regional metering area includes:
[0146] The total water consumption of the regional metering area is determined by calculating the first difference between the inlet water consumption of the regional metering area and the outlet water consumption of the regional metering area to determine the total water consumption of the regional metering area. The total water consumption of the regional metering area is Q 总 The expression is:
[0147] Q 总 =Q 入 -Q 出 ,
[0148] Among them, Q 入 is the sum of the inlet water volume of the regional metering area, Q 出 It is the sum of the outlet water volume of the regional metering area;
[0149] The total amount of remote meter water in the regional metering area Q 远传 for:
[0150]
[0151] Where n is the number of remote meters in the regional metering area, R j It is the water volume data measured by remote meter j.
[0152] The total water volume of the hand-read meter in the regional metering area Q 手抄 for:
[0153]
[0154] Where m is the number of hand-copied meters in the regional metering area, D i is the water consumption data of hand-copied meter i.
[0155] The first sum of the total water volume of the remote meter in the regional metering area and the total water volume of the hand-read meter in the regional metering area is calculated and determined, and the second difference between the total water volume of the regional metering area and the first sum is calculated and determined to determine the water loss in the regional metering area. The water loss in the regional metering area Q 漏 The expression is:
[0156] Q 漏 =Q 总 -Q 远传 -Q 手抄 .
[0157] The water loss in each regional metering area can be calculated by the above formula.
[0158] For further information, see Figure 4 The step of calculating and determining the amount of water loss corresponding to each pipe network node in the regional metering area according to the amount of water loss in the regional metering area, the total length of the pipes in the regional metering area, and the total length of the pipes corresponding to each pipe network node in the regional metering area comprises:
[0159] Step S3001, determining the water loss in the regional metering area, calculating and determining a first ratio between the water loss in the regional metering area and the total length of the pipeline in the regional metering area to determine the specific flow rate;
[0160] Step S3002: Calculate and determine the second product between one half of the total length of the pipeline corresponding to each pipe network node in the regional metering area and the specific flow rate to determine the leakage water volume corresponding to each pipe network node in the regional metering area.
[0161] Specifically, the mathematical expression for calculating the amount of water loss allocated to each pipe network node includes:
[0162] The first ratio between the water loss in the regional metering area and the total length of the pipeline in the regional metering area is calculated to determine the specific flow rate, and the specific flow rate q s The expression is:
[0163]
[0164] Among them, L 总 is the equivalent length of the pipeline within the regional metering area.
[0165] Calculate and determine the second product between one-half of the total length of the pipeline corresponding to each pipe network node in the regional metering area and the specific flow rate to determine the leakage water volume corresponding to each pipe network node in the regional metering area, and the leakage water volume Q allocated to the pipe network node k k漏 The expression is:
[0166]
[0167] Where uk is the number of pipes connected to the network node k, L p is the length of the pth pipeline connected to the pipeline network node k.
[0168] The above calculation formula can be used to obtain the corresponding water leakage volume of each pipe network node in each regional metering area.
[0169] Step S40, calculating and determining the node water demand data corresponding to each pipe network node in the regional metering area according to the sum of the remote meter water volume, the hand-read meter water volume and the leakage water volume corresponding to each pipe network node in the regional metering area;
[0170] According to the water leakage volume of the regional metering area, the total length of the pipelines in the regional metering area and the total length of the pipelines corresponding to each pipeline network node in the regional metering area, the water leakage volume corresponding to each pipeline network node in the regional metering area is calculated and determined; according to the sum of the remote meter water volume, the hand-read meter water volume and the leakage water volume corresponding to each pipeline network node in the regional metering area, the node water demand data corresponding to each pipeline network node in the regional metering area is calculated and determined.
[0171] In some embodiments, according to the remote meter water volume, hand-read meter water volume and leakage water volume corresponding to each pipe network node in the regional metering area, aggregation is performed by node to obtain the node water demand data corresponding to each pipe network node of the target area water supply pipe network, wherein the node water demand data is the water demand of each pipe network node in the pipe network model, and the water demand of each node is the sum of the remote meter water volume, hand-read meter water volume and leakage water volume corresponding to each pipe network node. In the water supply pipe network system, the water supply is provided by reservoirs and water tanks, and the water output is composed of user water use and leakage water. When allocating the model flow, all water is allocated to the pipe network nodes.
[0172] Step S50, constructing an online hydraulic model of the water supply network in the target area according to the mass conservation equation, energy conservation equation, pipeline pressure drop equation of the water supply network in the target area, the network topology structure of the regional metering area, the network node monitoring data and the node water demand data corresponding to each network node in the regional metering area.
[0173] According to the sum of the remote meter water volume, the manual meter water volume and the leakage water volume corresponding to each pipe network node in the regional metering area, after calculating and determining the node water demand data corresponding to each pipe network node in the regional metering area, an online hydraulic model of the water supply network in the target area is constructed according to the mass conservation equation, energy conservation equation, pipeline pressure drop equation, the pipe network topology structure of the regional metering area, the pipe network node monitoring data and the node water demand data corresponding to each pipe network node in the regional metering area.
[0174] In some embodiments, after the step of constructing an online hydraulic model of the target area water supply network according to the mass conservation equation, energy conservation equation, pipeline pressure drop equation of the target area water supply network, the network topology of the regional metering area, the network node monitoring data, and the node water demand data corresponding to each network node in the regional metering area, the method includes:
[0175] The node water demand data corresponding to each network node in the target area water supply network is input into the online hydraulic model of the target area water supply network to determine the node pressure data and pipe section flow data corresponding to each network node in the target area water supply network.
[0176] In some embodiments, according to the node water demand data corresponding to each pipe network node in the regional metering area and the basic information data table of the user water meter, the node water demand and the preset control rules are set in the pipe network topology structure of the regional metering area, an online hydraulic model of the target area water supply pipe network is established, simulation options and parameters are set in the model, and then EPyT is used to perform hydraulic calculations to obtain hydraulic data of the water supply pipe network, wherein the hydraulic data of the water supply pipe network includes the node pressure and pipeline flow of each pipe network node in the target area water supply pipe network, and the preset control rules refer to the rules and logic used for automatic or manual operation of water pumps, valves or other regulating equipment in the actual water supply pipe network. Through these control rules, the flow and pressure of the pipe network can be adjusted according to demand, real-time data or preset conditions to ensure the efficient operation and stability of the water supply system under different working conditions. The online hydraulic model refers to a pipe network model deployed on a network such as the Internet, connected to the pipe network online monitoring system, and having the functions of automatic update of operation data and timed automatic simulation calculation. The pipe network model refers to a computer simulation model that is based on the topological structure of the water supply pipe network and uses hydraulics, reaction dynamics and mathematical algorithms to describe the water flow movement and water quality changes at all nodes and pipe sections in the pipe network, and simulates and analyzes the operation status of the pipe network.
[0177] In some embodiments, the simulation options and parameters include flow units, head loss calculation formula, simulation mode, total simulation time, hydraulic calculation step, simulation start time, simulation end time, pump efficiency and other information.
[0178] In some embodiments, the mass conservation equation indicates that the sum of the inflow flow at any node is equal to the sum of the outflow flow. That is, at each node, the flow leaving the node (defined as a positive value) is added to the flow entering the node (defined as a negative value), and their algebraic sum is zero. The specific mathematical expression is:
[0179] ∑±q ij +Q i =0,
[0180] Among them, q ij is the flow rate of the pipe section connected to node i, i is the number of the starting node of the pipeline, j is the number of the end node of the pipeline, "+" represents the flow rate in the direction of the outflow node, and "-" represents the flow rate in the direction of the outflow node. Q i is the traffic of node i.
[0181] In some embodiments, the energy conservation equation indicates that in any closed loop in the closed pipe network system, the total change of energy is zero. The specific mathematical expression is:
[0182]
[0183] Where L is the number of base rings in the pipe network model, h ij Head loss of pipe section ij inside base ring k, ΔH k It is the closing difference of the base ring k or the water pressure difference caused by the boosting (such as booster pump station) and the pressure reducing equipment (such as pressure reducing valve). k Equal to 0, in a multi-source water network, ΔH k The water pressure difference between multiple water supply sources.
[0184] In some embodiments, the pipeline pressure drop equation represents the relationship between the head loss of a pipe section in the pipeline network and the head of the nodes at both ends.
[0185] That is, the pressure drop of any pipe section is equal to the head difference between the nodes at both ends of the pipe section. The specific mathematical expression is:
[0186]
[0187] Among them, H i , H j is the total water head at nodes i and j at both ends of the pipe segment, h ij is the head loss of the pipe section (m), S ij is the friction resistance of the pipe section, q ij is the flow rate of the pipe section (m 3 / s), n is a constant, and its value range is between 1.582 and 2. The specific value is determined according to the friction resistance formula adopted, and is not limited here.
[0188] In some embodiments, based on the water supply network hydraulic data of the target area, SCADA monitoring data, the basic information data table of the SCADA monitoring table and the simulation error data of the past quarter, the step of online evaluating the model accuracy and prompting for verification includes:
[0189] Step S501: Calculate simulation error data based on the water supply network hydraulic data, SCADA monitoring data and basic information data table of the SCADA monitoring table in the target area to evaluate the model accuracy online.
[0190] Specifically, during implementation, the steps for evaluating model accuracy include:
[0191] Step S5011, respectively call the getNodePressure and getLinkFlows functions of EPyT to obtain the pressure simulation data of nodes at all times and the flow simulation data of the pipe links;
[0192] Step S5012, determining the monitoring value and the simulation value of the monitoring point according to the user number of the SCADA monitoring table in the basic information data table and the number of the associated node or pipeline, and calculating the simulation error data between the two;
[0193] Step S5013, using psycopg2 to connect to the database, and then storing the simulation data of all pipe network nodes or pipelines and the simulation error data of the monitoring points into the database;
[0194] The simulation error is divided into pressure simulation error and flow simulation error. The pressure simulation error uses the multi-period average absolute error as the model accuracy evaluation index, and the flow simulation error uses the multi-period average relative error as the model accuracy evaluation index.
[0195] Step S502: Based on the simulation error data of the past quarter, determine whether the model needs to be calibrated according to the online hydraulic model acceptance criteria, and then give a prompt.
[0196] The model acceptance standards must meet the "Technical Code for Construction and Application of Urban Water Supply Network Models" (T / CUWA20059-2022).
[0197] In some embodiments, the target area includes S town, Figure 5 This is a schematic diagram of the topological structure of the hydraulic model of the S town constructed online using EPyT in an embodiment of the present application; Figure 6 This is a comparative schematic diagram of the inconsistent collection time points and missing data of the monitoring data or revenue data of the S town in the embodiment of the present application;
[0198] In some embodiments, specifically, according to the node water demand data corresponding to each pipe network node in the regional metering area in S town and the basic information data table of the user water meter, the node water demand and control rules are set in the water supply network topology structure, and the online hydraulic model of S town is established; the simulation option parameters are set in the model, and then EPyT is used to perform hydraulic calculations to obtain the hydraulic data of the water supply network in S town. Among them, the pressure simulation error result of the S town part (March 8) is as follows Figure 7 As shown in the figure, the flow simulation error results of the S town part (March 8) are as follows Figure 8 shown.
[0199] Furthermore, the getNodePressure and getLinkFlows functions of EPyT are called respectively to obtain the pressure simulation data of nodes at all times and the flow simulation data of pipe sections in S town; the monitoring value and simulation value of the monitoring point are determined according to the user number of the SCADA monitoring table in the basic information data table of S town and the number of the associated node or pipeline, and the error between the two is calculated; psycopg2 is used to connect to the database of S town, and then the simulation data of all nodes or pipelines and the simulation error data of the monitoring point are stored in the database of S town; the simulation error data of S town in the past quarter is queried, and it is determined whether the model needs to be calibrated according to the online hydraulic model acceptance criteria, and then a prompt is given.
[0200] The calculation formula for the pressure simulation error of S town is:
[0201]
[0202] Among them, ε is the multi-period mean absolute error (MPa); H t is the pressure value of a certain pressure measuring point in the tth period (MPa); is the pressure value (MPa) of a pressure measuring point in the tth period calculated according to the hydraulic model; T is the total number of periods.
[0203] The flow simulation error calculation formula for town S is:
[0204]
[0205] Among them, δ is the average relative error of multiple periods; Q t is the measured flow value of the tth period at a flow measurement point (m3 / h); is the flow simulation value of the tth period (m 3 / h), T is the total number of time periods.
[0206] In some embodiments, Table 3 statistics the simulation error data of S town in the past period of time (March 8 to March 22), a total of 15 days. According to the requirements of the "Technical Regulations for the Construction and Application of Urban Water Supply Pipeline Network Models", the accuracy of the online hydraulic model must meet the simulation results of at least 7 consecutive days each quarter, and the calibration accuracy standards of the offline model. The calibration accuracy requirements of the offline hydraulic model are as follows: For pressure accuracy, the number of pressure calibration points with a multi-period absolute error mean controlled within the range of 0.02MPa should account for more than 80% of the total, and the number controlled within the range of 0.01MPa should account for more than 50% of the total; for flow accuracy, the multi-period relative error mean of the factory flow is controlled within 10%; for water distribution trunks that meet the economic flow rate, the number of flow calibration points with a multi-period relative error mean controlled within 15% accounts for more than 80% of the total.
[0207] From the statistical results in Table 3, it can be seen that the online hydraulic model of S town meets the acceptance criteria of the offline model for 12 consecutive days, therefore, it meets the accuracy requirements of the online hydraulic model.
[0208] Table 3 Statistical results of S urban simulation error data
[0209]
[0210] It can be seen from the above embodiments that, compared with the prior art, the present application aims at the problems in the prior art that, with the in-depth development of towns and the frequent transformation of pipelines, the topological structure of the water supply network is constantly changing, and the topological structure cannot be automatically updated to effectively cope with this challenge, and due to the imperfect advanced metering facilities, there is a large amount of data with a long metering cycle, which makes the allocation of water on a time scale difficult. The present application includes but is not limited to the following beneficial effects:
[0211] The present application constructs an online hydraulic model of the water supply network in the target area according to the mass conservation equation, energy conservation equation, pipeline pressure drop equation, network topology of the target area, network node monitoring data, and node water demand data corresponding to each network node in the regional metering area. It realizes the simultaneous online update of the topology of the water supply network model and the node water demand, reduces the influence of the change of the network topology on the model accuracy, and thus greatly saves the manpower, material and financial resources spent on the later update and maintenance of the online hydraulic model.
[0212] Furthermore, in terms of water distribution, by using the same type of remote water meter data with similar daily average water volume for interpolation, the water consumption mode of the hand-copied meter is obtained online, making the water distribution more realistic in terms of time scale, and effectively improving the accuracy of the model. This technical solution can better adapt to the application scenarios of rapid urban development and frequent pipeline transformation, effectively respond to the continuous changes in the topological structure of the water supply network, reduce the tedious work of later model updates and maintenance, and improve the simulation accuracy of the hydraulic model of the water supply network, thereby further guiding the planning and management of the water supply network system and promoting the digital development of the water industry;
[0213] Furthermore, the present application simulates and calculates the operating status of the urban water supply network through an online hydraulic model of the water supply network, so as to obtain the actual operating conditions of the network in a timely manner, make the operation of the urban water supply network safer and more stable, reduce the harm caused by abnormal accidents to the network system, and ensure normal water use for residents.
[0214] See also Fig. 9A water supply network online hydraulic model building device provided to meet one of the purposes of the present application includes a data acquisition module 1100, a manual meter water volume determination module 1200, a leakage water volume determination module 1300, a node water demand determination module 1400 and a hydraulic model building module 1500. Among them, the data acquisition module 1100 is configured to respond to the water supply network online hydraulic model construction instruction, and obtain the network node monitoring data, network node revenue data and network geographic information data corresponding to each network node in the regional metering area of the target area water supply network, wherein the target area water supply network includes multiple regional metering areas, the network node revenue data includes remote meter time series data, and the network node monitoring data represents the node pressure data and its corresponding pipe section flow data for real-time monitoring of each network node; the manual meter water volume determination module 1200 is configured to calculate and determine the water consumption data of each manual meter in each time period according to the daily average water volume of each manual meter, the first remote meter time series data with a similar daily average water volume and the same water use type as each manual meter, and the second remote meter time series data, and calculate and determine the water consumption data of each network node in the regional metering area according to the water consumption data of each manual meter in each time period. The corresponding hand-read meter water volume; the leakage water volume determination module 1300 calculates and determines the leakage water volume corresponding to each pipe network node in the regional metering area according to the leakage water volume of the regional metering area, the total length of the pipelines in the regional metering area and the total length of the pipelines corresponding to each pipe network node in the regional metering area; the node water demand determination module 1400 is configured to calculate and determine the node water demand data corresponding to each pipe network node in the regional metering area according to the sum of the remote meter water volume, the hand-read meter water volume and the leakage water volume corresponding to each pipe network node in the regional metering area; the hydraulic model construction module 1500 is configured to construct an online hydraulic model of the water supply network in the target area according to the mass conservation equation, the energy conservation equation, the pipeline pressure drop equation of the water supply network in the target area, the pipe network topology structure of the regional metering area, the pipe network node monitoring data and the node water demand data corresponding to each pipe network node in the regional metering area.
[0215] Based on any embodiment of this application, please refer to Fig.10 Another embodiment of the present application further provides an electronic device, which can be implemented by a computer device, such as Fig.10As shown, a schematic diagram of the internal structure of a computer device. The computer device includes a processor, a computer-readable storage medium, a memory, and a network interface connected via a system bus. Among them, the computer-readable storage medium of the computer device stores an operating system, a database, and computer-readable instructions. The database may store a control information sequence. When the computer-readable instructions are executed by the processor, the processor can implement a method for building an online hydraulic model of a water supply network. The processor of the computer device is used to provide computing and control capabilities to support the operation of the entire computer device. The memory of the computer device may store computer-readable instructions. When the computer-readable instructions are executed by the processor, the processor can execute the method for building an online hydraulic model of a water supply network of the present application. The network interface of the computer device is used to connect and communicate with a terminal. Those skilled in the art will understand that Fig.10 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.
[0216] In this embodiment, the processor is used to execute Fig. 9 The memory stores the program code and various data required to execute the above modules or submodules. The network interface is used to transmit data between user terminals or servers. The memory in this embodiment stores the program code and data required to execute all modules in the online hydraulic model building device of the water supply network of this application, and the server can call the program code and data of the server to execute the functions of all modules.
[0217] The present application also provides a storage medium storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, the one or more processors execute the steps of the method for constructing an online hydraulic model of a water supply network described in any embodiment of the present application.
[0218] The present application also provides a computer program product, including a computer program / instruction, which, when executed by one or more processors, implements the steps of the method for constructing an online hydraulic model of a water supply network described in any embodiment of the present application.
[0219] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiments of the present application can be implemented by instructing the relevant hardware through a computer program, and the computer program can be stored in a computer-readable storage medium. When the program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, the aforementioned storage medium can be a computer-readable storage medium such as a disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM).
[0220] The above description is only a partial implementation method of the present application. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present application. These improvements and modifications should also be regarded as the scope of protection of the present application.
[0221] To sum up, this application simulates and calculates the operating status of the urban water supply network through an online hydraulic model of the water supply network, which can timely obtain the actual operating conditions of the network, make the operation of the urban water supply network safer and more stable, reduce the harm caused by abnormal accidents to the network system, and ensure normal water use for residents.
Claims
1. A method for constructing an online hydraulic model of a water supply network, characterized in that: include: In response to the instruction to build an online hydraulic model of the water supply network, the network node monitoring data, network node revenue data and network geographic information data corresponding to each network node in the regional metering area of the target area water supply network are obtained, wherein the target area water supply network includes multiple regional metering areas, the network node revenue data includes remote meter time series data, and the network node monitoring data represents the node pressure data of each network node monitored in real time and its corresponding pipe section flow data; Calculate and determine the water consumption data of each hand-copied meter in each time period according to the daily average water volume of each hand-copied meter, the time series data of the first remote meter with a similar daily average water volume and the same water type as that of each hand-copied meter, and the time series data of the second remote meter; and calculate and determine the hand-copied meter water volume corresponding to each pipe network node in the regional metering area according to the water consumption data of each hand-copied meter in each time period; Calculate and determine the amount of water loss corresponding to each pipe network node in the regional metering area according to the amount of water loss in the regional metering area, the total length of the pipes in the regional metering area, and the total length of the pipes corresponding to each pipe network node in the regional metering area; Calculate and determine the node water demand data corresponding to each pipe network node in the regional metering area according to the sum of the remote meter water volume, the hand-read meter water volume and the leakage water volume corresponding to each pipe network node in the regional metering area; An online hydraulic model of the water supply network in the target area is constructed based on the mass conservation equation, energy conservation equation, pipeline pressure drop equation of the water supply network in the target area, the network topology structure of the regional metering area, the network node monitoring data and the node water demand data corresponding to each network node in the regional metering area.
2. The method for constructing an online hydraulic model of a water supply network according to claim 1, characterized in that: After the steps of obtaining the pipe network node monitoring data and pipe network node revenue data corresponding to each pipe network node in the regional metering area of the target regional water supply pipe network, the method includes: In response to the data preprocessing instruction, the pipeline node monitoring data and pipeline node revenue data corresponding to each pipeline node in the regional metering area are cleaned to obtain regular, continuous and complete time series data.
3. The method for constructing an online hydraulic model of a water supply network according to claim 1, characterized in that: The steps of calculating and determining the water consumption data of each hand-copied meter in each time period according to the daily average water volume of each hand-copied meter, the time series data of the first remote meter which is similar to the daily average water volume of each hand-copied meter and has the same water consumption type, and the time series data of the second remote meter, and calculating and determining the hand-copied meter water volume corresponding to each pipe network node in the regional metering area according to the water consumption data of each hand-copied meter in each time period, include: Calculate and determine the average daily water volume of each manual meter and the average daily water volume of the same type of remote meters; Matching the first remote meter and the second remote meter with a daily average water volume similar to that of each hand-copied meter and the same water use type to obtain time series data of the first remote meter and the second remote meter; According to the daily average water volume corresponding to the first remote meter, the daily average water volume corresponding to the second remote meter, the time series data of the first remote meter and the time series data of the second remote meter, each interpolation water consumption curve value of the hand-copied meter is calculated and determined, and according to each interpolation water consumption curve value, an interpolation curve average value of each hand-copied meter is calculated and determined; According to each interpolation water consumption curve value of each hand-copied meter and the average value of the interpolation curve, the water consumption mode value of each hand-copied meter is calculated and determined; Determine the basic water volume of each hand-copied meter, determine the water consumption data of each hand-copied meter in each time period according to the first product between the water consumption mode value of each hand-copied meter and the basic water volume of each hand-copied meter, and calculate and determine the hand-copied meter water volume corresponding to each pipe network node in the regional metering area according to the water consumption data of each hand-copied meter in each time period.
4. The method for constructing an online hydraulic model of a water supply network according to claim 1, characterized in that: The step of calculating and determining the amount of water loss corresponding to each pipe network node in the regional metering area according to the amount of water loss in the regional metering area, the total length of the pipes in the regional metering area, and the total length of the pipes corresponding to each pipe network node in the regional metering area comprises: Calculating and determining a first difference between an inlet water volume of the regional metering area and an outlet water volume of the regional metering area to determine a total water consumption of the regional metering area; The first sum of the total water volume of the remote meters in the regional metering area and the total water volume of the hand-read meters in the regional metering area is calculated and determined, and the second difference between the total water consumption in the regional metering area and the first sum is calculated and determined to determine the water loss in the regional metering area.
5. The method for constructing an online hydraulic model of a water supply network according to claim 4, characterized in that: The step of calculating and determining the amount of water loss corresponding to each pipe network node in the regional metering area according to the amount of water loss in the regional metering area, the total length of the pipes in the regional metering area, and the total length of the pipes corresponding to each pipe network node in the regional metering area comprises: Determine the water loss in the regional metering area, calculate and determine a first ratio between the water loss in the regional metering area and the total length of the pipeline in the regional metering area to determine the specific flow rate; The second product between one half of the total length of the pipeline corresponding to each pipe network node in the regional metering area and the specific flow rate is calculated to determine the leakage water volume corresponding to each pipe network node in the regional metering area.
6. The method for constructing an online hydraulic model of a water supply network according to claim 1, characterized in that: After the step of constructing an online hydraulic model of the target area water supply network according to the mass conservation equation, energy conservation equation, pipeline pressure drop equation of the target area water supply network, the network topology of the regional metering area, the network node monitoring data, and the node water demand data corresponding to each network node in the regional metering area, the method comprises: The node water demand data corresponding to each network node in the target area water supply network is input into the online hydraulic model of the target area water supply network to determine the node pressure data and pipe section flow data corresponding to each network node in the target area water supply network.
7. The method for constructing an online hydraulic model of a water supply network according to any one of claims 1 to 6, characterized in that: The target area includes a town or a city, the regional metering area includes a commercial area, a residential area and an industrial area, and the pipeline network node represents a commercial area, a residential area or an industrial area.
8. A device for constructing an online hydraulic model of a water supply network, characterized in that: include: A data acquisition module is configured to respond to an instruction to construct an online hydraulic model of a water supply network, and acquire network node monitoring data, network node revenue data, and network geographic information data corresponding to each network node in a regional metering area of a target regional water supply network, wherein the target regional water supply network includes multiple regional metering areas, the network node revenue data includes remote meter time series data, and the network node monitoring data represents node pressure data for real-time monitoring of each network node and its corresponding pipe section flow data; The manual meter water volume determination module is configured to calculate and determine the water consumption data of each manual meter in each time period based on the daily average water volume of each manual meter, the time series data of the first remote meter that is similar to the daily average water volume of each manual meter and has the same water use type, and the time series data of the second remote meter, and calculate and determine the manual meter water volume corresponding to each pipe network node in the regional metering area based on the water consumption data of each manual meter in each time period; A leakage water volume determination module is configured to calculate and determine the leakage water volume corresponding to each pipe network node in the regional metering area according to the leakage water volume of the regional metering area, the total length of the pipes in the regional metering area, and the total length of the pipes corresponding to each pipe network node in the regional metering area; A node water demand determination module is configured to calculate and determine the node water demand data corresponding to each pipe network node in the regional metering area according to the sum of the remote meter water volume, the hand-read meter water volume and the leakage water volume corresponding to each pipe network node in the regional metering area; The hydraulic model construction module is configured to construct an online hydraulic model of the water supply network in the target area based on the mass conservation equation, energy conservation equation, pipeline pressure drop equation of the water supply network in the target area, the network topology structure of the regional metering area, the network node monitoring data, and the node water demand data corresponding to each network node in the regional metering area.
9. An electronic device, comprising a central processing unit and a memory, characterized in that: The central processing unit is used to call and run the computer program stored in the memory to execute the steps of the method according to any one of claims 1 to 7.
10. A computer-readable storage medium, characterized in that: It stores a computer program implemented according to the method described in any one of claims 1 to 7 in the form of computer-readable instructions, and when the computer program is called and executed by a computer, the steps included in the corresponding method are executed.
Citation Information
Patent Citations
Water supply network leakage monitoring method, computer device and storage medium
CN115218129A
Intelligent water meter metering system
CN118670469A