Online Hydraulic Model Construction Method, Device, Equipment and Medium for Water Supply Network
By constructing an online hydraulic model of the water supply pipeline network, and using the interpolation of remote transmission table data with similar daily average water volume, the problems of changes in the topology structure of the water supply pipeline network and incomplete metrology facilities are solved, high-precision and real-time update of the model are achieved, and the stability and safety of the water supply system are ensured.
Patent Information
- Application Number
- CN202411932248.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-26
- Publication Date
- 2025-07-29
- Estimated Expiration
- 2044-12-26
AI Technical Summary
The existing online hydraulic model of the water supply network cannot automatically update the topology, and due to the incomplete advanced metrology facilities, it is difficult to allocate water volume on the time scale, affecting the model accuracy and real-time performance.
By obtaining monitoring data, revenue data and geographical information data of pipeline nodes, combining 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, and the distant transmission table data interpolation with similar daily average water volume is used to realize online update of the node's water demand and automatic adjustment of the topological structure.
The model topology structure and node water demand of the water supply pipeline network have been realized online, which improves the model accuracy, adapts to the rapid development of urban areas and pipeline transformation, reduces updates and maintenance work, and ensures the safe and stable operation of the water supply pipeline network.
Smart Images

Figure CN119862177B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of water supply pipe networks, and particularly 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 pipe network system is an important part of urban infrastructure and accounts for a relatively large proportion of the investment in the entire water supply system. The safe and stable operation of the entire water supply pipe network system can not only improve the guarantee of urban water use in terms of water volume, water quality, and water pressure, but also reduce the waste of water resources and increase the revenue of water service companies.
[0003] The hydraulic model can reflect the operating conditions of the actual pipe network and is used by water service companies to plan and manage the entire water supply pipe network system. The hydraulic model includes an offline hydraulic model and an online hydraulic model. The offline hydraulic model requires manual data update, which has limitations such as poor real-time performance, strong manual dependence, and low intelligence level, especially for emergency events. In contrast, the online hydraulic model has the functions of automatic update of operation data and automatic simulation calculation at regular intervals, and can obtain the operating conditions of the pipe network in a timely manner. However, with the in-depth development of cities and the frequent transformation of pipelines, the topological structure of the water supply pipe network is constantly changing. The existing online hydraulic models mainly focus on the online update of node water demand and cannot automatically update the topological structure to effectively address this challenge.
[0004] At the same time, as the most uncertain dynamic variable in the hydraulic model of the water supply pipe network, the reasonable allocation of node water demand is the premise for ensuring the accuracy of the model. However, in some developing countries or underdeveloped regions, due to the imperfect advanced metering facilities, there are a large number of data with long metering cycles, which makes the allocation of water volume on the time scale difficult and further affects the accuracy of the model.
[0005] In summary, in order to adapt to the problems in the prior art that with the in-depth development of cities and the frequent transformation of pipelines, the topological structure of the water supply pipe network is constantly changing and cannot automatically update the topological structure to effectively address this challenge, and due to the imperfect advanced metering facilities, there are a large number of data with long metering cycles, which makes the allocation of water volume on the time scale difficult, etc., the applicant has made corresponding explorations in consideration of solving these problems. Summary of the Invention
[0006] The purpose of the present application is to solve the above problems and provide 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.
[0007] To achieve the various purposes of the present application, the following technical solutions are adopted:
[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 an instruction for constructing an online hydraulic model of a water supply network, obtain the network node monitoring data, network node revenue data, and network geographic information data corresponding to each network node in the district metering area of the target area water supply network. Among them, the target area water supply network includes multiple district metering areas, the network node revenue data includes remote meter time series data, and the network node monitoring data represents the node pressure data obtained by real-time monitoring of each network node and its corresponding pipe segment flow data;
[0010] According to the daily water volume of each manual meter, the first remote meter time series data and the second remote meter time series data that are similar to the daily water volume of each manual meter and have the same water use type, calculate and determine the water consumption data of each manual meter in each time period. According to the water consumption data of each manual meter in each time period, calculate and determine the manual meter water volume corresponding to each network node in the district metering area;
[0011] According to the leakage water volume of the district metering area, the total length of the pipelines in the district metering area, and the total length of the pipelines corresponding to each network node in the district metering area, calculate and determine the leakage water volume corresponding to each network node in the district metering area;
[0012] According to the sum value among the remote meter water volume, manual meter water volume, and leakage water volume corresponding to each network node in the district metering area, calculate and determine the node water demand data corresponding to each network node in the district metering area;
[0013] 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 district metering area, the network node monitoring data, and the node water demand data corresponding to each network node in the district metering area, construct the online hydraulic model of the target area water supply network.
[0014] Optionally, after the step of obtaining the network node monitoring data and network node revenue data corresponding to each network node in the district metering area of the target area water supply network, it includes:
[0015] In response to a data preprocessing instruction, perform data cleaning on the network node monitoring data and network node revenue data corresponding to each network node in the district metering area to obtain regular, continuous, and complete time series data.
[0016] Optionally, 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 usage type, and the time series data of the second remote meter, calculate and determine the water consumption data of each manual meter in each time period. The steps of calculating and determining the water volume of the manual meter 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 include:
[0017] Calculate and determine the daily average water volume of each manual meter and the daily average water volume of the remote meter of the same type as it;
[0018] Match the first remote meter and the second remote meter that are similar to the daily average water volume of each manual meter and have the same water usage type, and obtain the time series data of the first remote meter and the time series data of the second remote meter;
[0019] Based on 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, calculate and determine each interpolation water curve value of the manual meter, and calculate and determine the average value of the interpolation curves of each manual meter according to each interpolation water curve value;
[0020] Calculate and determine the water usage pattern value of each manual meter according to each interpolation water curve value and the average value of the interpolation curves of each manual meter;
[0021] Determine the basic water volume of each manual meter, and determine the water consumption data of each manual meter in each time period according to the first product between the water usage pattern value of each manual meter and the basic water volume of each manual meter. Calculate and determine the water volume of the manual meter corresponding to each pipe network node in the regional metering area according to the water consumption data of each manual meter in each time period.
[0022] Optionally, the steps of calculating and determining the leakage water volume corresponding to each pipe network node in the regional metering area based on 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 include:
[0023] Calculate and determine the first difference between the inlet water volume and the outlet water volume of the regional metering area to determine the total water consumption of the regional metering area;
[0024] Calculate and determine the first sum value between the total water volume of the remote meters in the regional metering area and the total water volume of the manual meters in the regional metering area, and calculate and determine the second difference between the total water consumption of the regional metering area and the first sum value to determine the leakage water volume of the regional metering area.
[0025] Optionally, the step of calculating and determining the water leakage volume corresponding to each pipe network node in the regional metering area according to the water leakage volume of the regional metering area, the total pipe length of the regional metering area, and the total pipe length corresponding to each pipe network node in the regional metering area includes:
[0026] Determine the water leakage volume of the regional metering area, calculate and determine the first ratio between the water leakage volume of the regional metering area and the total pipe length of the regional metering area to determine the specific discharge;
[0027] Calculate and determine the second product between half of the total pipe length corresponding to each pipe network node in the regional metering area and the specific discharge to determine the water leakage volume corresponding to each pipe network node in the regional metering area.
[0028] Optionally, after the step of constructing the online hydraulic model of the target regional water supply network according to the mass conservation equation, energy conservation equation, pipe pressure drop equation of the target regional water supply network, 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, it includes:
[0029] Input the node water demand data corresponding to each pipe network node in the target regional water supply network into the online hydraulic model of the target regional water supply network to determine the node pressure data and pipe segment flow data corresponding to each pipe network node in the target regional water supply network.
[0030] Optionally, the target region includes a town or a city, the regional metering area includes a commercial area, a residential area, and an industrial area, and the pipe network nodes represent a commercial area, a residential area, or an industrial area.
[0031] A device for constructing an online hydraulic model of a water supply network provided to meet another object of the present application includes:
[0032] A data acquisition module, configured to respond to an instruction for constructing an online hydraulic model of a water supply network, and acquire pipe network node monitoring data, pipe network node revenue data, and pipe network geographic information data corresponding to each pipe network node in the regional metering area of the target regional water supply network. Among them, the target regional water supply network includes multiple regional metering areas, the pipe network node revenue data includes remote meter time series data, and the pipe network node monitoring data represents the node pressure data obtained by real-time monitoring of each pipe network node and its corresponding pipe segment 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 area metering area according to the water consumption data of each manual meter in each time period;
[0034] The leakage water volume determination module calculates and determines the leakage water volume corresponding to each pipe network node in the area metering area according to the leakage water volume of the area metering area, the total pipe length of the area metering area, and the total pipe length corresponding to each pipe network node in the area metering area;
[0035] The node water demand determination module is configured to calculate and determine the node water demand data corresponding to each pipe network node in the area metering area 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 area metering area;
[0036] The hydraulic model construction module is configured to construct an online hydraulic model of the target area water supply network according to the mass conservation equation, the energy conservation equation, the pipe pressure drop equation of the target area water supply network, the pipe network topology structure of the area metering area, the pipe network node monitoring data, and the node water demand data corresponding to each pipe network node in the area metering area.
[0037] An electronic device provided to meet another object of the present application includes a central processing unit and a memory. 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 the water supply network described in the present application.
[0038] A computer-readable storage medium provided to meet another object of the present application stores a computer program implemented according to the method for constructing an online hydraulic model of the water supply network in the form of computer-readable instructions. When the computer program is called and run by a computer, it executes the steps included in the corresponding method.
[0039] Compared with the prior art, in view of the problems in the prior art that as the urban area develops in depth and the pipelines are frequently renovated, the topology structure of the water supply network constantly changes, and it is impossible to automatically update the topology structure to effectively address this challenge, and 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 volume on the time scale, etc., the present application includes but is not limited to the following beneficial effects:
[0040] This application constructs 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, network topology of the district metering area, monitoring data of network nodes, and node water demand data corresponding to each network node in the district metering area. It realizes the simultaneous online update of the topological structure of the water supply network model and the node water demand, reduces the impact of changes in the network topology on the model accuracy, and thus significantly saves the manpower, material resources, and financial resources spent on the later update and maintenance of the online hydraulic model;
[0041] Furthermore, in terms of water volume distribution, by interpolating data from remote water meters of the same type with similar daily average water volumes, the water usage pattern of manual meter readings is obtained online, making the water volume distribution more in line with reality on the time scale, effectively improving the accuracy of the model. This technical solution can better adapt to the application scenarios of rapid urban development and frequent pipeline renovations, effectively cope with the continuous changes in the topological structure of the water supply network, reduce the cumbersome work of model later update and maintenance, improve the simulation accuracy of the water supply network hydraulic model, and thus further guide the planning and management of the water supply network system and promote the digital development of the water service industry;
[0042] Even further, this application simulates and calculates the operation status of the urban water supply network through the online hydraulic model of the water supply network, can timely obtain the actual operation situation 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 the normal water use of residents. BRIEF DESCRIPTION OF THE DRAWINGS
[0043] The above and / or additional aspects and advantages of this application will become obvious and easy to understand from the following description of the embodiments in conjunction with the drawings, where:
[0044] Figure 1 is a schematic flowchart of the method for constructing an online hydraulic model of the water supply network in an embodiment of this application;
[0045] Figure 2 is a schematic flowchart of determining the water volume of manual meter readings corresponding to each network node in the district metering area in an embodiment of this application;
[0046] Figure 3 is a schematic flowchart of determining the leakage water volume in the district metering area in an embodiment of this application;
[0047] Figure 4 is a schematic flowchart of determining the leakage water volume corresponding to each network node in the district metering area in an embodiment of this application;
[0048] Figure 5 is a schematic diagram of the topological structure of the hydraulic model of Town S constructed online using EPyT in an embodiment of this application;
[0049] Figure 6 Schematic diagram for comparing inconsistent collection time points and data loss of monitoring data or revenue data in S Town in the embodiments of the present application;
[0050] Figure 7 Schematic diagram of partial pressure simulation error results in S Town in the embodiments of the present application;
[0051] Figure 8 Schematic diagram of partial flow simulation error results in S Town in the embodiments of the present application;
[0052] Figure 9 Principle block diagram of the on-line hydraulic model construction device for water supply network in the embodiments of the present application;
[0053] Figure 10 Schematic diagram of the structure of the computer device in the embodiments of the present application. Detailed implementation manners
[0054] The embodiments of the present application will be described in detail below. Examples of the embodiments are shown in the accompanying drawings, where the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the accompanying drawings are exemplary only for explaining the present application and should not be construed as limiting the present application.
[0055] Those skilled in the art of the present technology can understand that, unless specifically stated otherwise, the singular forms "a", "an", "the" and "said" used herein may also include the plural forms. It should be further understood that the term "including" used in the specification of the present application means the presence of the described 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 their groups. It should be understood that when we say that an element is "connected" or "coupled" to another element, it can be directly connected or coupled to other elements, or there may also be intermediate elements. In addition, the "connection" or "coupling" used herein may include wireless connection or wireless coupling. The phrase "and / or" used herein includes all or any unit and all combinations of one or more related listed items.
[0056] Those skilled in the art of the present technology can understand that, unless otherwise defined, all terms (including technical terms and scientific terms) used herein have the same meaning as the general understanding of those of ordinary skill in the art to which the present application belongs. It should also be understood that terms such as those defined in a general dictionary should be understood to have a meaning consistent with the meaning in the context of the prior art, and will not be interpreted with an idealized or overly formal meaning unless specifically defined as here.
[0057] Those skilled in the art can understand that the "client", "terminal", and "terminal device" used herein include both devices with a wireless signal receiver that only has the ability to receive and no transmitting ability, and devices with receiving and transmitting hardware that have the 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, etc., which have a single-line display or a multi-line display or a cellular or other communication device without a multi-line display; PCS (Personal Communications Service), which can combine voice, data processing, fax, and / or data communication capabilities; PDA (Personal Digital Assistant), which may include a radio frequency receiver, pager, Internet / intranet access, web browser, notepad, calendar, and / or GPS (Global Positioning System) receiver; conventional laptop and / or palm-held computers or other devices, which are conventional laptop and / or palm-held computers or other devices with and / or including a radio frequency receiver. The "client", "terminal", and "terminal device" used herein can be portable, transportable, installed in a vehicle (air, sea, and / or land), or suitable for and / or configured to operate locally, and / or operate in a distributed manner at any other location on the earth and / or in space. The "client", "terminal", and "terminal device" used herein can also be a communication terminal, an Internet access terminal, a music / video playback terminal, such as a PDA, MID (Mobile Internet Device), and / or a mobile phone with music / video playback function, or can also be devices such as a smart TV, a set-top box, etc.
[0058] The hardware referred to by names such as "server", "client", and "service node" in this application is essentially an electronic device with the equivalent capabilities of a personal computer, and is a hardware device with the necessary components disclosed by the von Neumann principle, including 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 loads the program stored in the external memory into the memory for execution, executes the instructions in the program, and interacts with the input / output devices to complete specific functions.
[0059] It should be noted that the concept of "server" in this application can similarly be extended to the case of server clusters. According to the network deployment principles understood by those skilled in the art, the servers should be logically divided. Physically, these servers can either be independent of each other but can be invoked through interfaces, or integrated into a single physical computer or a set of computer clusters. Those skilled in the art should understand this flexibility and should not be restricted by this in the implementation manner of the network deployment method of this application.
[0060] One or several technical features of this application, unless explicitly specified, can either be deployed on the server and accessed by the client remotely invoking the online service interface provided by the server, or directly deployed and run on the client for access.
[0061] The neural network models cited or possibly cited in this application, unless explicitly specified, can either be deployed on a remote server and remotely invoked on the client, or deployed on a client with sufficient device capabilities for direct invocation. 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] All kinds of data involved in this application, unless explicitly specified, can either be remotely stored on the server or stored on the local terminal device, as long as it is suitable for being invoked by the technical solution of this application.
[0063] Those skilled in the art should be aware that although the various methods of this application are described based on the same concept and thus show commonality with each other, unless otherwise specified, these methods can be executed independently. Similarly, for the various embodiments disclosed in this application, they are all proposed based on the same inventive concept. Therefore, for concepts with the same expression, as well as concepts that are only appropriately transformed for convenience although the concept expressions are different, they should be equivalently understood.
[0064] For the various embodiments to be disclosed in this application, unless explicitly pointed out that there is a mutually exclusive relationship between them, the relevant technical features involved in each embodiment can be cross-combined to flexibly construct new embodiments, as long as this combination does not deviate from the creative spirit of this application and can meet the requirements in the prior art or solve certain deficiencies in the prior art. Those skilled in the art should be aware of this flexibility.
[0065] Please refer to Figure 1 , in one embodiment of the method for constructing an online hydraulic model of a water supply network in this application, it includes:
[0066] Step S10: In response to an instruction for constructing an online hydraulic model of a water supply network, obtain the network node monitoring data, network node revenue data, and network geographic information data corresponding to each network node in the district metering areas of the water supply network in the target area. Among them, the water supply network in the target area includes multiple district metering areas, the network node revenue data includes remote meter time series data, and the network node monitoring data represents the node pressure data obtained by real-time monitoring of each network node and the corresponding pipe segment flow data.
[0067] The online hydraulic model construction system of the water supply network can respond to an instruction for constructing an online hydraulic model of the water supply network, obtain the network node monitoring data, network node revenue data, and network geographic information data corresponding to each network node in the district metering areas of the water supply network in the target area. Among them, the water supply network in the target area includes multiple district metering areas, the network node revenue data includes remote meter time series data, and the network node monitoring data represents the node pressure data obtained by real-time monitoring of each network node and the corresponding pipe segment flow data; Network geographic information data (network GIS data) refers to data on the geographical location information and related attributes of the water supply network. These data usually include information such as the spatial location, shape, length, diameter, material, and connection points of the pipeline, which can help manage and optimize the network system; The network node revenue data represents the revenue data corresponding to each network node in the water supply 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 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 network system.
[0068] In some embodiments, a district metering area (DMA) refers to dividing a city, town, or water supply network system into smaller areas, and each area 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 the area where an online hydraulic model of the water supply network needs to be constructed, usually referring to areas with concentrated populations such as towns or cities where tap water is supplied through the network system. Since the pipelines are buried underground, they are highly concealed and intricate, and 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 volume, water quality, and water pressure. Among them, the target area includes but is not limited to towns or cities, such as Town S, etc. The district metering area includes commercial areas, residential communities, and industrial areas, and the network nodes represent commercial areas, residential communities, or industrial areas, etc.
[0070] In some embodiments, the method for constructing an online hydraulic model of a water supply network according to the present application is applied to an online hydraulic model construction system of a water supply network. The online hydraulic model construction system of the water supply network is provided with a processor, and the method for constructing an online hydraulic model of the water supply network provided by the present application is implemented by the execution of the processor. The processor may be an actual processor in the online hydraulic model construction system of the water supply network or a virtual cloud processor, which is not limited herein.
[0071] In some embodiments, the online hydraulic model construction system of the water supply network includes PostGIS, Python, and an 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, which can convert the PostgreSQL database management system into a spatial database.
[0072] PostgreSQL is an object-relational database management system and also the most powerful, feature-rich, and complex free software database system. Python is a high-level, interpreted, general-purpose programming language, known for its simple and easy-to-learn syntax, powerful libraries, and wide application fields, suitable for various programming needs of developers. EPANET-PythonToolkit (EPyT) is a third-party library of Python, which provides a Python-based programming interface for the open-source hydraulic and water quality modeling software EPANET, has rich modeling functions, and supports modeling from scratch.
[0073] In some embodiments, the pipeline network node monitoring data may be SCADA monitoring data. The SCADA monitoring data refers to the node pressure data and pipeline flow data obtained by the SCADA system for real-time monitoring of various devices and parameters of the pipeline network nodes in the water supply network. The full name of SCADA is Supervisory Control And Data Acquisition, which is the core system for monitoring and controlling the water supply network. It can real-time monitor various parameters in the water supply network, 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 the 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 devices in the water supply network, such as starting or stopping pumps, adjusting the valve opening, etc.
[0074] In some embodiments, the pipeline network geographic information data (pipeline network GIS data), SCADA monitoring data, and revenue data can be obtained from water supply companies or relevant 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 pipeline network in the target area is established in PostGIS according to the mapping relationships between the pipeline network geographic information data (pipeline network GIS data), SCADA monitoring data, revenue data, and pipeline network elements.
[0075] In some embodiments, the steps of establishing a spatial database of the water supply pipeline network in the target area in PostGIS according to the mapping relationships between the pipeline network geographic information data (pipeline network GIS data), SCADA monitoring data, revenue data, and pipeline network elements include:
[0076] Step S101: Determine the mapping relationships between the SCADA monitoring tables of the water supply pipeline network in the target area and user water meters, pipeline network nodes, or pipe segments, and establish a basic information data table for the SCADA monitoring tables and user water meters.
[0077] Specifically, according to the actual geographical and spatial positions of the SCADA monitoring tables, determine the numbers of all nodes associated with the SCADA pressure monitoring tables and the numbers of pipe segments associated with the SCADA flow monitoring tables, and statistically organize the user numbers, associated node or pipe numbers, and table types of the SCADA monitoring tables in a *.csv format file; then, according to the actual geographical and spatial positions of the user water meters, determine the numbers of all nodes associated with the user water meters, and summarize and organize the user numbers, associated node numbers, water usage types, and names of the regions of the district metering areas (DMA) to which they belong 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 relationships between the SCADA monitoring tables and pipeline network nodes or pipe segments refer to the nodes or pipes associated with the tables in the pipeline network model; the basic information data table includes information such as the table numbers, types, and associated node or pipe numbers.
[0079] Step S102: Determine the boundaries of the district metering areas (DMA) in the target area and establish a model calculation summary data table.
[0080] Specifically, find the locations of all truncated pipe networks and closed valves in the actual pipe network, and obtain the district metering area (DMA) partition situation of the entire pipe network according to the truncated pipe network or closed valve; then summarize the names of each district metering area (DMA) region, the numbers of the inlet and outlet SCADA flow monitoring tables, and the numbers of all pipes and nodes in a *.csv format file; the model calculation summary data table contains information such as all nodes, pipe segments, and inlet and outlet flow monitoring table numbers in the district metering area (DMA).
[0081] Step S103, establish a spatial database of the water supply pipe network in the target area in PostGIS according to the pipe network geographic information data (pipe 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 the pipe network geographic information data (pipe network GIS data) into the database, where the pipe network geographic information data (pipe network GIS data) includes pipe points, reservoirs, water tanks, pipes, 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 constructing an online hydraulic model.
[0083] In some embodiments, the GIS data of nodes, reservoirs, water tanks, pipes, pumps, and valves are respectively two Shapefile (*.shp) format files of point data and line data that conform to the ESRI standard. ESRIShapefile is an open spatial data format developed by Environmental Systems Research Institute, Inc. (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 management tool for the PostgreSQL database management system and provides an easy-to-use interface to perform database management tasks and query data.
[0085] In some embodiments, the steps of querying and obtaining the pipe network geographic information data (pipe network GIS data) of the target area from a preset database and using EPyT to online establish the pipe network topology of the target area include:
[0086] Step S1001, query and obtain the pipe network geographic information data (pipe network GIS data) of the target area from a preset database;
[0087] Specifically, psycopg2 can be used to connect to the database, and then SQL query language can be written to query the pipe network geographic information data (pipe network GIS data). Psycopg2 is a third-party library for the Python programming language, used to access the PostgreSQL database system. It provides a set of tools and methods that can easily perform database operations in a Python program, including operations such as querying, inserting, updating, and deleting. SQL (Structured Query Language) is a structured query language, which is an operation language for relational databases and can be applied to all relational databases.
[0088] Step S1002: According to the numbers, coordinate values, and other corresponding attribute information of the Node class elements in the pipe network geographic information data (pipe network GIS data), use EPyT to establish a Node class element model in the water supply pipe network topology.
[0089] Use the 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 a Node class element model based on the X and Y coordinate values and their attribute information.
[0090] In some embodiments, in the water supply pipe network hydraulic model, the Node class elements include three elements: nodes, reservoirs, and water tanks, and the main attribute information is shown in Table 1.
[0091] Table 1 Main attribute information of Node class elements
[0092] Name of pipe network element Attribute information Node Number, elevation and geographical coordinates Reservoir Number, elevation and geographical coordinates Water tank Number, bottom elevation of the tank and geographical coordinates
[0093] Step S1003: According to the numbers, starting Node class element numbers, ending Node class element numbers, and other corresponding attribute information of the Link class elements in the pipe network geographic information data (pipe network GIS data), use EPyT to establish a Link class element model, thereby obtaining a complete water supply pipe network topology. Obtain the Node class element numbers connected to each Link class element. For the two pipe network elements of pipes and pumps, call the addLinkPipe and addLinkPump functions in EPyT respectively. For the valve pipe network element, call functions such as addLinkValveFCV, addLinkValvePRV, or addLinkValveTCV according to the type of the valve, and then establish a Link class element model based on the Node class element numbers and the attribute information of the Link class elements, thereby obtaining the pipe network topology and realizing the online construction function of the water supply pipe network online hydraulic model topology.
[0094] In some embodiments, the Link class elements include three elements: pipelines, water pumps, and valves, and the main attribute information is shown in Table 2.
[0095] Table 2 Main Attribute Information of Link Class Elements
[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 looped pipe networks, while rural or economically underdeveloped areas mainly use branched pipe networks.
[0098] In some embodiments, 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 area metering area of the water supply pipe network in the target area, it includes:
[0099] Responding to a data preprocessing instruction, cleaning the pipe network node monitoring data and pipe network node revenue data corresponding to each pipe network node in the area metering area to obtain regular, continuous, and complete time series data.
[0100] Specifically, the steps of cleaning the pipe network node monitoring data and pipe network node revenue data corresponding to each pipe network node in the area metering area to obtain regular, continuous, and complete time series data include:
[0101] Step S1100: Query and obtain SCADA monitoring data and pipe network node revenue data from the database;
[0102] Connect to the database using psycopg2, and then write SQL query language to query SCADA monitoring data and pipe network node revenue data.
[0103] Step S1200: Use a data processing algorithm to clean the SCADA monitoring data and pipe 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 duplicates;
[0106] 2. Resample the non-duplicate time series data to obtain time series data with regular time points;
[0107] 3. Use the data at the nearest time point to fill in the data with inconsistent data acquisition time points;
[0108] 4. Fill in the missing data using the method of linear interpolation to obtain regular, continuous, and complete time series data.
[0109] The mathematical expression of the linear interpolation method is:
[0110]
[0111] where 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: 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 time series data of the first remote meter with a similar daily average water volume and the same water use type as each manual meter, and the time series data of the second remote meter. Calculate and determine the water volume of the manual meter corresponding to each pipe network node in the regional metering area according to the water consumption data of each manual meter in each time period;
[0113] After obtaining the pipe network node monitoring data, pipe network node revenue data, and pipe network geographic information data corresponding to each pipe network node in the regional metering area of the target area water supply pipe network, 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 time series data of the first remote meter with a similar daily average water volume and the same water use type as each manual meter, and the time series data of the second remote meter. Calculate and determine the water volume of the manual meter corresponding to each pipe network node in the regional metering area according to the water consumption data of each manual meter in each time period;
[0114] Please refer to Figure 2 , the steps of calculating and determining the water consumption data of each manual meter in each time period according to the daily average water volume of each manual meter, the time series data of the first remote meter with a similar daily average water volume and the same water use type as each manual meter, and the time series data of the second remote meter, and calculating and determining the water volume of the manual meter corresponding to each pipe network node in the regional metering area according to the water consumption data of each manual meter in each time period, include:
[0115] Step S201: Calculate and determine the daily average water volume of each manual meter and the daily average water volume of the remote meter of the same type as it;
[0116] Step S202: Match the first remote meter and the second remote meter with a similar daily average water volume and the same water use type as each manual meter to obtain the time series data of the first remote meter and the time series data of the second remote meter;
[0117] Step S203: Calculate and determine the interpolated water consumption curve values of each manual meter based on the average daily water volume corresponding to the first remote meter, the average daily 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, and calculate and determine the average value of the interpolated curve for each manual meter according to the interpolated water consumption curve values.
[0118] Step S204: Calculate and determine the water consumption pattern value of each manual meter according to the interpolated water consumption curve values and the average value of the interpolated curve of each manual meter.
[0119] Step S205: Determine the basic water volume of each manual meter, determine the water consumption data of each manual meter in each time period according to the first product between the water consumption pattern value of each manual meter and the basic water volume of each manual meter, and calculate and determine the water volume of the manual meter corresponding to each pipe network node in the regional metering area according to the water consumption data of each manual meter in each time period.
[0120] Specifically, the time series data of the remote meter represents the remote meter measurement data corresponding to each time period within a preset time range to construct the time series data of the remote meter.
[0121] Suppose the measurement data X i远传 and Y i远传 of the first remote meter X and the second remote meter Y that are similar to the average daily water volume of the manual meter and have the same water use type are respectively:
[0122] X i远传 = [X1, X2, …, X 23 , X 24 ,
[0123] Y i远传 = [Y1, Y2, …, Y 23 , Y 24 .
[0124] Among them, the measurement data of the first remote meter X within one day is divided into the remote meter measurement data within 24 time periods (the time unit is hour), expressed as X i remote = [X1, X2, …, X 23 , X 24 , and the measurement data of the second remote meter Y within one day is divided into the remote meter measurement data within 24 time periods (the time unit is hour), expressed as Y i远传 = [Y1, Y2, …, Y 23 , Y 24 .
[0125] Furthermore, the average daily water volumes Q Xave and Q Yave of the remote meters X and Y are respectively:
[0126]
[0127]
[0128] Assume that the average daily water volume of the manual meter i is Q iave , and the interpolated water consumption curve value I i is:
[0129]
[0130] The average value of the interpolation curve I iave is:
[0131]
[0132] The water consumption pattern value P of the manual meter i i is (normalization process):
[0133]
[0134] The basic water volume D of the manual meter i ibase is:
[0135] where the unit of the value 24 is hours;
[0136] The water consumption data D of the manual meter i i is:
[0137] D i = [P1×D base , P2×D base , …, P 23 ×D base , P 24 ×D base ,
[0138] After determining the water consumption data of each manual meter in each time period by the above formula, according to the water consumption data of each manual meter in each time period, calculate and determine the water volume of the manual meter corresponding to each pipe network node in the regional measurement area. The water consumption of each pipe network node can be obtained by adding the water consumption of the manual meters connected downstream of it.
[0139] In some embodiments, the revenue data includes remote meter reading data and manual meter reading data. For remote meter reading data, the data collection frequency is relatively high, and it can generally be accurately allocated on the time scale. For manual meter reading, usually one data is recorded every one or two months, and the collection frequency is seriously insufficient, so the water volume cannot be accurately allocated on the time scale. The water use pattern refers to the law and trend of the water use demand of water users in the water supply system changing with time within a specific time period. The water use type refers to the water use methods in different scenarios and for different purposes, and the water use patterns of water meters of the same water use type are similar; the water use volume data is equal to the product of the basic water volume and the water use pattern value, and the water use volume data refers to the actual water use volume recorded within a specific time period (such as hours, days, months, etc.).
[0140] Step S30: 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 pipelines in the regional metering area, and the total length of the pipelines corresponding to each pipe network node in the regional metering area;
[0141] After calculating and determining the water volume of the manual meter corresponding to each pipe network node in the regional metering area according to the water use volume data of each manual 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 pipelines in the regional metering area, and the total length of the pipelines corresponding to each pipe network node in the regional metering area;
[0142] In some embodiments, please refer to Figure 3 , the step of calculating and determining 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 includes:
[0143] Step S301: Calculate and determine the first difference between the inlet water volume and the outlet water volume of the regional metering area to determine the total water use volume of the regional metering area;
[0144] Step S302: Calculate and determine the first sum value between the total water volume of the remote meters in the regional metering area and the total water volume of the manual meters in the regional metering area, and calculate and determine the second difference between the total water use volume of the regional metering area and the first sum value to determine the leakage water volume of the regional metering area.
[0145] More specifically, the mathematical expression of the calculation process of the leakage water volume of each regional metering area includes:
[0146] Calculating and determining a first difference between the inlet water volume and the outlet water volume of the regional metering area to determine the total water consumption of the regional metering area, the total water consumption Q of the regional metering area 总 The expression is:
[0147] Q 总 =Q 入 -Q 出 ,
[0148] where Q 入 is the sum of the inlet water volumes of the regional metering area, and Q 出 is the sum of the outlet water volumes of the regional metering area;
[0149] The total remote meter water volume Q of the regional metering area 远传 is:
[0150]
[0151] where n is the number of remote meters in the regional metering area, and R j is the water volume data measured by remote meter j.
[0152] The total manual meter water volume Q of the regional metering area 手抄 is:
[0153]
[0154] where m is the number of manual meters in the regional metering area, and D i is the water consumption data of manual meter i.
[0155] Calculating and determining a first sum value between the total remote meter water volume and the total manual meter water volume of the regional metering area, calculating and determining a second difference between the total water consumption of the regional metering area and the first sum value to determine the leakage water volume of the regional metering area, the leakage water volume Q of the regional metering area 漏 The expression is:
[0156] Q 漏 =Q 总 -Q 远传 -Q 手抄 .
[0157] The leakage water volume of each regional metering area can be obtained by calculating according to the above formula.
[0158] Furthermore, please refer to Figure 4 , the steps of calculating and determining 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 pipe length of the regional metering area, and the total pipe length corresponding to each pipe network node in the regional metering area include:
[0159] Step S3001: Determine the leakage water volume of the regional metering area, and calculate and determine the first ratio between the leakage water volume of the regional metering area and the total pipeline length of the regional metering area to determine the specific flow rate.
[0160] Step S3002: Calculate and determine the second product between half of the total pipeline length 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 of the calculation process for the leakage water volume allocated to each pipe network node includes:
[0162] Calculate and determine the first ratio between the leakage water volume of the regional metering area and the total pipeline length of the regional metering area to determine the specific flow rate. The specific flow rate q s The expression is:
[0163]
[0164] where L 总 is the equivalent length of the pipeline in the regional metering area.
[0165] Calculate and determine the second product between half of the total pipeline length 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. The leakage water volume Q k漏 allocated to the pipe network node k is expressed as:
[0166]
[0167] where uk is the number of pipelines connected to the pipe network node k, and L p is the length of the p-th pipeline connected to the pipe network node k.
[0168] The leakage water volume corresponding to each pipe network node in each regional metering area can be obtained from the above calculation formula.
[0169] Step S40: Calculate and determine the node water demand data corresponding to each pipe network node in the regional metering area according to the sum value among the remote meter water volume, manual meter water volume and leakage water volume corresponding to each pipe network node in the regional metering area.
[0170] Calculate and determine the water leakage volume corresponding to each pipe network node in the regional metering area according to the water leakage volume of the regional metering area, the total pipe length of the regional metering area, and the total pipe length 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 value among the remote meter reading water volume, the manual meter reading water volume, and the water leakage volume corresponding to each pipe network node in the regional metering area.
[0171] In some embodiments, aggregate according to the remote meter reading water volume, the manual meter reading water volume, and the water leakage volume corresponding to each pipe network node in the regional metering area by node to obtain the node water demand data corresponding to each pipe network node of the target regional water supply pipe network. Among them, 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 value among the remote meter reading water volume, the manual meter reading water volume, and the water leakage 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 consists of user water consumption and water leakage. When distributing the model flow, all water volumes are distributed to the pipe network nodes.
[0172] Step S50: Construct an online hydraulic model of the target regional water supply pipe network according to the mass conservation equation, the energy conservation equation, the pipe pressure drop equation of the target regional water supply pipe network, the pipe network topology 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.
[0173] After calculating and determining the node water demand data corresponding to each pipe network node in the regional metering area according to the sum value among the remote meter reading water volume, the manual meter reading water volume, and the water leakage volume corresponding to each pipe network node in the regional metering area, construct an online hydraulic model of the target regional water supply pipe network according to the mass conservation equation, the energy conservation equation, the pipe pressure drop equation of the target regional water supply pipe network, the pipe network topology 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 regional water supply pipe network according to the mass conservation equation, the energy conservation equation, the pipe pressure drop equation of the target regional water supply pipe network, the pipe network topology 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, it includes:
[0175] Input the node water demand data corresponding to each pipe network node in the target area water supply pipe network into the online hydraulic model of the target area water supply pipe network to determine the node pressure data and pipe segment flow data corresponding to each pipe network node in the target area water supply pipe network.
[0176] In some embodiments, according to the node water demand data corresponding to each pipe network node in the area metering zone and the basic information data table of user water meters, set the node water demand and preset control rules in the pipe network topology structure of the area metering zone, establish an online hydraulic model of the target area water supply pipe network, set simulation options and parameters in the model, and then use EPyT for hydraulic calculation to obtain the hydraulic data of the water supply pipe network. Among them, the hydraulic data of the water supply pipe network includes the node pressure and pipe flow of each pipe network node in the target area water supply pipe network. The preset control rules refer to the rules and logics used to automatically or manually operate water pumps, valves or other regulating devices in the actual water supply pipe network. Through these control rules, the flow and pressure of the pipe network can be adjusted according to demands, 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 networks such as the Internet, connected to the pipe network online monitoring system, and having functions of automatically updating operation data and performing timed automatic simulation calculations. The pipe network model refers to a computer simulation model based on the pipe network topology structure, using hydraulics, reaction kinetics and mathematical algorithms, etc. to describe the water flow movement and water quality change of all nodes and pipe segments in the pipe network, and to simulate and analyze the operation state of the pipe network.
[0177] In some embodiments, the simulation options and parameters include information such as flow unit, head loss calculation formula, simulation method, total simulation time, hydraulic calculation step size, simulation start time, simulation end time, and pump efficiency.
[0178] In some embodiments, the mass conservation equation indicates that the sum of the inflow flows at any node is equal to the sum of the outflow flows. That is, at each node, the flow leaving the node (specified as positive) is added to the flow entering the node (specified as negative), and their algebraic sum is zero. The specific mathematical expression is:
[0179] ∑±q ij +Q i =0,
[0180] where q ij is the flow of the pipe segment connected to node i, i is the starting node number of the pipe, j is the ending node number of the pipe, "+" indicates the flow in the direction of leaving the node, "-" indicates the flow in the direction of leaving the node, and Q i is the flow of node i.
[0181] In some embodiments, the energy conservation equation indicates that the total change in energy within any closed loop in a closed pipe network system is zero, and its specific mathematical expression is:
[0182]
[0183] where L is the number of basic loops in the pipe network model, h ij is the head loss of pipe segment ij within basic loop k, and ΔH k is the closure difference of basic loop k or the water pressure difference generated by pressure boosting (such as a pumping station) and pressure reducing equipment (such as a pressure reducing valve). In a single-source pipe network, ΔH k equals 0. In a multi-source pipe network, ΔH k is the water pressure difference of multiple water supply sources.
[0184] In some embodiments, the pipeline pressure drop equation represents the relationship between the head loss of a pipe segment in the pipe network and the node heads at both ends of the pipe segment,
[0185] that is, the pressure drop of any pipe segment is equal to the head difference between the nodes at both ends of the pipe segment, and its specific mathematical expression is:
[0186]
[0187] where H i , H j are the total node heads of nodes i and j at both ends of the pipe segment, h ij is the head loss of the pipe segment (m), S ij is the pipe segment friction resistance, q ij is the pipe segment flow rate (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, according to the hydraulic data of the water supply pipe network in 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 steps of online evaluating the model accuracy and prompting for verification include:
[0189] Step S501: Calculate the simulation error data based on the hydraulic data of the water supply pipe network in the target area, SCADA monitoring data, and the basic information data table of the SCADA monitoring table to online evaluate the model accuracy.
[0190] Specifically, in implementation, the steps of model accuracy evaluation include:
[0191] Step S5011: Call the getNodePressure and getLinkFlows functions of EPyT respectively to obtain the pressure simulation data of all nodes and the flow simulation data of pipe segments at all times;
[0192] Step S5012: Determine the monitoring values and simulation values of the monitoring points based on the user numbers in the SCADA monitoring table in the basic information data table and the numbers of associated nodes or pipelines, and calculate the simulation error data between the two;
[0193] Step S5013: Use psycopg2 to connect to the database, and then store the simulation data of all pipeline 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 multi-period mean absolute error is used as the model accuracy evaluation index for the pressure simulation error, and the multi-period mean relative error is used as the model accuracy evaluation index for the flow simulation error.
[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 criteria should meet the "Technical Specification for the Construction and Application of Urban Water Supply Network Models" (T / CUWA 20059-2022).
[0197] In some embodiments, the target area includes Town S, Figure 5 which is a schematic diagram of the topological structure of the hydraulic model of Town S constructed online using EPyT in the embodiments of the present application; Figure 6 which is a comparison schematic diagram of the inconsistent collection time points and data missing of the monitoring data or revenue data in Town S in the embodiments of the present application;
[0198] In some embodiments, specifically, according to the node water demand data corresponding to each pipeline network node in the district metering area in Town S and the basic information data table of user water meters, set the node water demand and control rules in the water supply network topological structure, and establish an online hydraulic model of Town S; set the simulation option parameters in the model, and then use EPyT for hydraulic calculation to obtain the hydraulic data of the water supply network in Town S. Among them, the pressure simulation error results of a part of Town S (March 8th) are as Figure 7 shown, and the flow simulation error results of a part of Town S (March 8th) are as Figure 8 shown.
[0199] Furthermore, call the getNodePressure and getLinkFlows functions of EPyT respectively to obtain the pressure simulation data of all nodes and the flow simulation data of pipeline segments in S Town at all times; determine the monitoring values and simulation values of the monitoring points according to the user numbers in the SCADA monitoring table and the numbers of associated nodes or pipelines in the basic information data table of S Town, and calculate the error between the two; use psycopg2 to connect to the database of S Town, and then store the simulation data of all nodes or pipelines and the simulation error data of the monitoring points into the database of S Town; query the simulation error data of S Town in the past quarter, judge whether the model needs to be calibrated according to the acceptance criteria of the online hydraulic model, and then give a prompt.
[0200] The calculation formula for the pressure simulation error in S Town is:
[0201]
[0202] Among them, ε is the multi-period average absolute error (MPa); H t is the pressure value (MPa) of a certain pressure measurement point at the t-th period; is the pressure value (MPa) of a certain pressure measurement point calculated according to the hydraulic model at the t-th period; T is the total number of periods.
[0203] The calculation formula for the flow simulation error in S Town is:
[0204]
[0205] Among them, δ is the multi-period average relative error; Q t is the measured flow value (m3 / h) of a certain flow measurement point at the t-th period; is the simulated flow value at the t-th period (m 3 / h), and T is the total number of periods.
[0206] In some embodiments, Table 3 statistically analyzes the simulation error data of S Town in the past period (from March 8th to March 22nd), a total of 15 days. According to the requirements of the "Technical Specification for the Construction and Application of Urban Water Supply Network Models", the accuracy of the online hydraulic model needs to meet the requirement that the simulation results for at least 7 consecutive days per quarter are not lower than the calibration accuracy standard of the offline model. The calibration accuracy requirements for the offline hydraulic model are as follows: for pressure accuracy, the number of pressure calibration points with the multi-period absolute error mean controlled within 0.02 MPa should account for more than 80% of the total number, and the number of those controlled within 0.01 MPa should account for more than 50% of the total number; for flow accuracy, the multi-period relative error mean of the factory outlet flow is controlled within 10%; for the distribution main pipes meeting the economic flow velocity, the number of flow calibration points with the multi-period relative error mean controlled within 15% should account for more than 80% of the total number.
[0207] It can be seen from the statistical results in Table 3 that the online hydraulic model of Town S has met 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 Simulation Error Data of Town S
[0209]
[0210] As can be seen from the above embodiments, compared with the prior art, in view of the problems in the prior art that as the town develops in depth and the pipelines are frequently renovated, the topological structure of the water supply network constantly changes and it is impossible to automatically update the topological structure to effectively address this challenge, and 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 volume on the time scale, etc., the present application includes but is not limited to the following beneficial effects:
[0211] The present application constructs the 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, the topological structure of the pipe network in the regional metering area, the monitoring data of the pipe network nodes, and the node water demand data corresponding to each pipe network node in the regional metering area. It realizes the simultaneous online update of the topological structure of the water supply network model and the node water demand, reduces the impact of the change of the pipe network topological structure on the model accuracy, and thus greatly saves the manpower, material resources and financial resources spent on the update and maintenance of the online hydraulic model in the later stage;
[0212] Furthermore, in terms of water volume allocation, by interpolating the data of the same type of remote water meters with similar daily average water volumes, the manual meter reading water use pattern is obtained online, making the water volume allocation more in line with the actual situation on the time scale, effectively improving the accuracy of the model. This technical solution can better adapt to the application scenarios of rapid urban development and frequent pipeline renovation, effectively address the continuous change of the topological structure of the water supply network, reduce the cumbersome work of model update and maintenance in the later stage, improve the simulation accuracy of the water supply network hydraulic model, and thus further guide the planning and management of the water supply network system and promote the digital development of the water service industry;
[0213] Even further, the present application simulates and calculates the operation status of the urban water supply network through the online hydraulic model of the water supply network, can timely obtain the actual operation situation of the pipe network, make the operation of the urban water supply network safer and more stable, reduce the harm caused by abnormal accidents to the pipe network system, and ensure the normal water use of residents.
[0214] Please refer to Figure 9, A device for constructing an online hydraulic model of a water supply network 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 construction module 1500. Among them, the data acquisition module 1100 is configured to respond to an instruction for constructing 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 the district metering area of the target area water supply network. Among them, the target area water supply network includes multiple district metering areas, the network node revenue data includes remote meter time series data, and the network node monitoring data represents the node pressure data obtained by real-time monitoring of each network node and its corresponding pipe segment flow data; 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 similar to the daily average water volume of each manual meter and with the same water use type, and the second remote meter time series data, and calculate and determine the manual meter water volume corresponding to each network node in the district metering area according to the water consumption data of each manual meter in each time period; the leakage water volume determination module 1300 calculates and determines the leakage water volume corresponding to each network node in the district metering area according to the leakage water volume of the district metering area, the total length of the pipelines in the district metering area, and the total length of the pipelines corresponding to each network node in the district metering area; the node water demand determination module 1400 is configured to calculate and determine the node water demand data corresponding to each network node in the district metering area according to the sum of the remote meter water volume, the manual meter water volume, and the leakage water volume corresponding to each network node in the district metering area; the hydraulic model construction module 1500 is configured to construct an online hydraulic model of the target area water supply network according to the mass conservation equation, the energy conservation equation, the pipeline pressure drop equation of the target area water supply network, the network topology structure of the district metering area, the network node monitoring data, and the node water demand data corresponding to each network node in the district metering area.
[0215] Based on any embodiment of the present application, please refer to Figure 10 , Another embodiment of the present application further provides an electronic device, which can be implemented by a computer device, such as Figure 10As shown, it is 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 through 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 can store a control information sequence. When the computer-readable instructions are executed by the processor, the processor can implement a method for constructing 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 can store computer-readable instructions. When the computer-readable instructions are executed by the processor, the processor can execute the method for constructing 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 can understand, Figure 10 The structure shown in is only a block diagram of some structures 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 some components, or have different component arrangements.
[0216] In this embodiment, the processor is used to execute Figure 9 the specific functions of each module in. The memory stores the program codes and various types of data required to execute the above-mentioned modules or sub-modules. The network interface is used for data transmission between a user terminal and a server. The memory in this embodiment stores the program codes and data required to execute all modules in the device for constructing an online hydraulic model of a water supply network of the present application. The server can call the program codes 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 are caused to execute the steps of the method for constructing an online hydraulic model of a water supply network according to any embodiment of the present application.
[0218] The present application also provides a computer program product, including a computer program / instructions. When the computer program / instructions are executed by one or more processors, the steps of the method for constructing an online hydraulic model of a water supply network according to any embodiment of the present application are implemented.
[0219] Those of ordinary skill in the art can understand that all or part of the processes in the above-described embodiments of the method of this application can be completed by instructing relevant hardware through a computer program. This 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 various methods. Among them, the aforementioned storage medium can be a computer-readable storage medium such as a magnetic disk, an optical disc, a read-only memory (ROM), or a random access memory (RAM), etc.
[0220] The above are only some embodiments of this application. It should be noted that for those of ordinary skill in the art of this technology, without departing from the principle of this application, several improvements and refinements can be made, and these improvements and refinements should also be regarded as the protection scope of this application.
[0221] In summary, this application uses an online hydraulic model of the water supply network to simulate and calculate the operation status of the urban water supply network, can timely obtain the actual operation situation 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 the normal water use of residents.
Claims
1. An online hydraulic model construction method for a water supply network, characterized in that Including: In response to the instruction for constructing an online hydraulic model of the water supply pipe network, obtaining the network node monitoring data, network node revenue data, and network geographical information data corresponding to each network node in the district metering areas of the water supply pipe network in the target area. Among them, the water supply pipe network in the target area includes multiple district metering areas, the network node revenue data includes remote meter time series data, and the network node monitoring data represents the node pressure data obtained by real-time monitoring of each network node and the corresponding pipe segment flow data; Calculating and determining 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 and the second remote meter time series data that are similar to the daily average water volume of each manual meter and have the same water use type, and calculating and determining the water volume of the manual meter corresponding to each network node in the district metering area according to the water consumption data of each manual meter in each time period; Calculating and determining the leakage water volume corresponding to each network node in the district metering area according to the leakage water volume of the district metering area, the total length of the pipelines in the district metering area, and the total length of the pipelines corresponding to each network node in the district metering area; Calculating and determining the node water demand data corresponding to each network node in the district metering area according to the sum value among the remote meter water volume, manual meter water volume, and leakage water volume corresponding to each network node in the district metering area; Constructing the online hydraulic model of the water supply pipe network in the target area according to the mass conservation equation, energy conservation equation, pipeline pressure drop equation of the water supply pipe network in the target area, the network topology structure of the district metering area, the network node monitoring data, and the node water demand data corresponding to each network node in the district metering area.
2. The method for constructing an online hydraulic model of a water supply pipe network according to claim 1, wherein After the step of obtaining the network node monitoring data and network node revenue data corresponding to each network node in the district metering area of the water supply pipe network in the target area, including: In response to the data preprocessing instruction, cleaning the network node monitoring data and network node revenue data corresponding to each network node in the district metering area to obtain regular, continuous, and complete time series data.
3. The method for constructing an online hydraulic model of a water supply pipe network according to claim 1, characterized in that The step of calculating and determining 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 and the second remote meter time series data that are similar to the daily average water volume of each manual meter and have the same water use type, and calculating and determining the water volume of the manual meter corresponding to each network node in the district metering area according to the water consumption data of each manual meter in each time period, includes: Calculating and determining the daily average water volume of each manual meter and the daily average water volume of the remote meter of the same type as it; Matching the first remote meter and the second remote meter that are similar to the daily average water volume of each manual meter and have the same water use type to obtain the first remote meter time series data and the second remote meter time series data; Calculate and determine each interpolated water consumption curve value of the manual meter based on 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, and calculate and determine the average value of the interpolation curve for each manual meter based on each interpolated water consumption curve value; Calculate and determine the water consumption pattern value for each manual meter based on each interpolated water consumption curve value and the average value of the interpolation curve for each manual meter; Determine the basic water volume for each manual meter, determine the water consumption data for each manual meter in each time period based on the first product between the water consumption pattern value of each manual meter and the basic water volume of each manual 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; 4. The method for constructing an online hydraulic model of a water supply network according to claim 1, wherein The steps of calculating and determining the leakage water volume corresponding to each pipe network node in the regional metering area based on the leakage water volume of the regional metering area, the total pipe length of the regional metering area, and the total pipe length corresponding to each pipe network node in the regional metering area include: Calculate and determine the first difference between the inlet water volume and the outlet water volume of the regional metering area to determine the total water consumption of the regional metering area; Calculate and determine the first sum value between the total remote meter water volume and the total manual meter water volume of the regional metering area, and calculate and determine the second difference between the total water consumption of the regional metering area and the first sum value to determine the leakage water volume of the regional metering area; 5. The method for constructing an online hydraulic model of a water supply pipe network according to claim 4, characterized in that, The steps of calculating and determining the leakage water volume corresponding to each pipe network node in the regional metering area based on the leakage water volume of the regional metering area, the total pipe length of the regional metering area, and the total pipe length corresponding to each pipe network node in the regional metering area include: Determine the leakage water volume of the regional metering area, and calculate and determine the first ratio between the leakage water volume of the regional metering area and the total pipe length of the regional metering area to determine the specific discharge; Calculate and determine the second product between half of the total pipe length corresponding to each pipe network node in the regional metering area and the specific discharge 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 pipe network according to claim 1, wherein After the steps of constructing the online hydraulic model of the target regional water supply pipe network based on the mass conservation equation, energy conservation equation, pipe pressure drop equation of the target regional water supply pipe network, the pipe network topology 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, include: Input the node water demand data corresponding to each pipe network node in the target regional water supply pipe network into the online hydraulic model of the target regional water supply pipe network to determine the node pressure data and pipe segment flow data corresponding to each pipe network node in the target regional water supply pipe 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 pipe network nodes represent a commercial area, a residential area, or an industrial area; 8. An on-line hydraulic model construction device for a water supply pipe network, characterized in that, Include: A data acquisition module, configured to respond to an instruction for constructing an online hydraulic model of a water supply pipe network, and acquire network node monitoring data, network node revenue data, and network geographical information data corresponding to each network node in the district metering areas of the water supply pipe network in the target area. Among them, the water supply pipe network in the target area includes multiple district metering areas, the network node revenue data includes remote meter time series data, and the network node monitoring data represents the node pressure data obtained by real-time monitoring of each network node and the corresponding pipe segment flow data; A manual meter water volume determination module, 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 and the second remote meter time series data that are similar to the daily average water volume of each manual meter and have the same water use type, and calculate and determine the manual meter water volume corresponding to each network node in the district metering area according to the water consumption data of each manual meter in each time period; A leakage water volume determination module, configured to calculate and determine the leakage water volume corresponding to each network node in the district metering area according to the leakage water volume of the district metering area, the total length of the pipelines in the district metering area, and the total length of the pipelines corresponding to each network node in the district metering area; A node water demand determination module, configured to calculate and determine the node water demand data corresponding to each network node in the district metering area according to the sum of the remote meter water volume, the manual meter water volume, and the leakage water volume corresponding to each network node in the district metering area; A hydraulic model construction module, configured to construct an online hydraulic model of the water supply pipe network in the target area according to the mass conservation equation, the energy conservation equation, the pipeline pressure drop equation of the water supply pipe network in the target area, the network topology of the district metering area, the network node monitoring data, and the node water demand data corresponding to each network node in the district 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 according to any one of claims 1 to 7 in the form of computer-readable instructions. When the computer program is called and run by the computer, it executes the steps included in the corresponding method.
Citation Information
Patent Citations
Water supply network leakage monitoring method, computer device and storage medium
CN115218129A
Intelligent water meter metering system
CN118670469A