A sewer network mixed connection checking method and device, electronic equipment and storage medium

Abstract

The present application relates to the technical field of drainage system treatment, and discloses a drainage pipe network mixed connection checking method and device, electronic equipment and storage medium, the present application utilizes the pre-constructed drainage pipe network geographic information, combines the proton mass spectrometer monitoring method, utilizes the multi-dimensional similarity comprehensive analysis algorithm, obtains the similarity result of the VOCs fingerprint spectrum of each rainwater pipeline; then, the first threshold value is used for screening, the rainwater pipeline to be checked suspected to exist in the mixed connection is positioned from the area to be checked, then the upstream and downstream fingerprint spectrums of VOCs of the upstream and downstream of the rainwater pipeline and the inspection well of the surrounding sewage pipeline respectively are checked, the second threshold value is used for further determining the mixed connection area of the rainwater pipeline and the sewage pipeline, and finally, the actual video monitoring is used for completing the on-site verification, ensuring that the checking result is real and reliable, and overcoming the defect that the drainage pipe network mixed connection checking method disclosed in the related art has low efficiency in pipeline mixed connection checking.

Description

Technical Field

[0001] This invention relates to the field of drainage system management technology, specifically to a method, device, electronic equipment, and storage medium for investigating mixed connections in drainage pipe networks. Background Technology

[0002] The common problem of mixing rainwater pipes and sewage pipes in urban drainage networks is one of the main reasons why sewage is connected to rainwater pipes or even directly discharged into rivers and lakes during dry weather. This poses a serious risk to the urban water environment and urgently needs to be investigated and addressed.

[0003] The commonly disclosed methods for investigating mixed connections in drainage pipe networks in related technologies generally employ video imaging detection, which identifies mixed connection issues by capturing images of the connections between rainwater and sewage pipes. However, in order to effectively obtain clear video data, the process of investigating mixed connections using the disclosed methods in related technologies requires prior dewatering and dredging of all rainwater pipes in the area to be investigated, resulting in low efficiency. Summary of the Invention

[0004] This invention provides a method, apparatus, electronic device, and storage medium for investigating mixed connections in drainage pipe networks, in order to solve the problem of low efficiency in the investigation of mixed connections in drainage pipe networks disclosed in related technologies.

[0005] In a first aspect, the present invention provides a method for investigating mixed connections in drainage pipe networks, the method comprising:

[0006] Based on the pre-constructed geographical information of the drainage pipe network in the area to be investigated, the VOCs fingerprint spectrum of the upstream and downstream of each rainwater pipe in the area to be investigated is obtained using the proton mass spectrometry monitoring method; the geographical information of the drainage pipe network in the area to be investigated includes the direction of the drainage pipes and the corresponding service areas in the area to be investigated.

[0007] Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint maps of each rainwater pipe are obtained by using a pre-constructed multi-dimensional similarity comprehensive analysis algorithm.

[0008] Based on the similarity results of the VOCs fingerprint spectrum of each rainwater pipe, the first threshold is used for screening to obtain the rainwater pipes to be investigated in the area to be investigated.

[0009] For each rainwater pipe to be investigated in the area to be investigated, the upstream and downstream fingerprints of VOCs of the corresponding rainwater pipe and the surrounding sewage pipe inspection wells are combined. A pre-constructed multi-dimensional similarity comprehensive analysis algorithm is used, and combined with the second threshold for evaluation, to obtain the preliminary investigation results of the rainwater pipe and sewage pipe connection.

[0010] Based on the preliminary investigation results of each rainwater pipe and sewage pipe being mixed, the results were verified using actual video monitoring to obtain the final investigation results of each rainwater pipe and sewage pipe being mixed.

[0011] Through the above implementation method, by utilizing pre-constructed geographical information of the drainage pipe network and combining it with proton mass spectrometry monitoring, VOCs fingerprint spectra of the upstream and downstream of each rainwater pipe are obtained. Then, a multi-dimensional similarity comprehensive analysis algorithm is used to obtain the similarity results of the VOCs fingerprint spectra of each rainwater pipe, accurately capturing the subtle differences in VOCs fingerprint spectra between the upstream and downstream of each rainwater pipe. Subsequently, a first threshold is used for initial screening, which can quickly locate suspected mixed rainwater pipes from a large number of rainwater pipes in the area to be investigated, thereby narrowing down the scope of rainwater pipe investigation. Then, by combining the upstream and downstream VOCs fingerprint spectra of the rainwater pipes with the surrounding sewage pipe inspection wells, a second threshold is used to further determine the mixed areas of rainwater pipes and sewage pipes, shortening the investigation time. Finally, on-site verification is completed with actual video monitoring to ensure the authenticity and reliability of the investigation results, overcoming the low efficiency of the drainage pipe network mixed connection investigation methods disclosed in related technologies.

[0012] In one optional implementation, the construction of the geographical information of the drainage pipe network in the area to be investigated includes:

[0013] Based on the survey materials of the drainage pipe network in the area to be investigated, the flow direction and service area of ​​each drainage pipe are sorted out to obtain the geographical information of the drainage pipe network in the area to be investigated. The survey materials of the drainage pipe network include pipe type, manhole number and coordinates, and connection relationship.

[0014] Through the above implementation methods, based on the survey materials of the drainage pipe network in the area to be investigated, a geographical information of the drainage pipe network containing key elements such as pipe flow direction, service area, and spatial location is constructed. This provides a clear spatial reference for obtaining the upstream and downstream VOCs fingerprint spectrum of each rainwater pipe using the proton mass spectrometer monitoring method, thereby improving the efficiency of pipe investigation.

[0015] In one optional implementation, the step of obtaining VOCs fingerprints of the upstream and downstream of each rainwater pipe in the area to be investigated using a proton mass spectrometer monitoring method based on pre-constructed geographical information of the drainage pipe network in the area to be investigated includes:

[0016] Based on the preprocessed geographical information of the drainage pipe network in the area to be investigated, the VOCs detection data in the upstream and downstream inspection wells of each rainwater pipe were obtained by using the proton mass spectrometry monitoring method along the flow direction of each rainwater pipe.

[0017] Based on VOCs detection data from the upstream and downstream inspection wells of each rainwater pipe, data processing methods are used to obtain VOCs fingerprints for the upstream and downstream of each rainwater pipe; the data processing methods include removing strong background peaks and baseline peaks, normalization, and smoothing.

[0018] Through the above implementation method, relying on the pre-constructed geographical information of the drainage pipe network, upstream and downstream inspection wells are accurately selected as monitoring points along the flow direction of rainwater pipes. This ensures that the VOCs detection data collected by the proton mass spectrometer strictly corresponds to the spatial location of the pipes and the direction of water flow, achieving full coverage of all rainwater pipes in the area to be investigated. Furthermore, by using data processing methods, the influence of irrelevant factors such as instrument noise and environmental interference on the detection data is effectively eliminated. At the same time, the VOCs detection data of different monitoring points are converted to a unified dimension, ensuring that the VOCs fingerprint spectra of each rainwater pipe upstream and downstream and between different pipes are comparable, providing reliable basic data for subsequent multi-dimensional similarity comprehensive analysis algorithms.

[0019] In one optional implementation, based on the preprocessed geographical information of the drainage pipe network in the area to be investigated, VOCs detection data in the upstream and downstream inspection wells of each rainwater pipe are obtained using a proton mass spectrometry monitoring method, along the flow direction of each rainwater pipe, including:

[0020] Based on the pre-processed geographical information of the drainage pipe network in the area to be investigated, for each rainwater pipe, the air intake pipe is placed into the corresponding rainwater pipe along the upstream or downstream inspection well to extract VOCs in the pipe. The VOCs detection data in the upstream or downstream inspection well of each rainwater pipe are obtained by using a proton mass spectrometer monitoring method.

[0021] The above implementation method first clarifies the flow direction of each rainwater pipe and the location of upstream and downstream inspection wells based on the geographical information of the drainage pipe network. Then, by placing an air intake pipe to extract VOCs from each rainwater pipe, the monitoring object of the proton mass spectrometer is strictly matched with the actual gas environment upstream and downstream of the rainwater pipe. This avoids data distortion caused by external air interference or misalignment of the monitoring points, ensures a one-to-one correspondence between the detection data and the spatial location of the pipe, and improves the accuracy of the final identification of the rainwater pipes to be investigated.

[0022] In one optional implementation, obtaining the first threshold includes:

[0023] Based on multiple interconnected rainwater pipes in the area to be investigated, obtain the VOCs fingerprint spectrum of the upstream and downstream of each pipe.

[0024] Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint maps of each rainwater pipe are obtained by using a preset multidimensional similarity comprehensive analysis algorithm.

[0025] By combining the similarity results of the VOCs fingerprint spectrum of each rainwater pipe, the maximum similarity of the VOCs fingerprint spectrum is obtained by using the maximum value screening method, and is used as the first threshold.

[0026] Through the above implementation method, based on the VOCs fingerprint spectrum of upstream and downstream samples of rainwater pipes with mixed connections in the area to be investigated, and using a multidimensional similarity analysis algorithm combined with the maximum value screening method to determine the first threshold, the first threshold can accurately match the characteristics of the mixed connection scenario in the area to be investigated, which facilitates the rapid acquisition of pipes suspected of being mixed from the area to be investigated, narrows the scope of subsequent investigation, and effectively avoids the defect of missing rainwater pipes with mixed connections.

[0027] In one optional implementation, obtaining the second threshold includes:

[0028] Based on multiple unconnected rainwater pipes in the area to be investigated, obtain the VOCs fingerprint spectrum of the upstream and downstream of each pipe.

[0029] Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint maps of each rainwater pipe are obtained by using a preset multidimensional similarity comprehensive analysis algorithm.

[0030] By combining the similarity results of VOCs fingerprint spectra of each rainwater pipe, the minimum similarity of the VOCs fingerprint spectra is obtained using the minimum value screening method, and this minimum similarity is used as the second threshold.

[0031] Through the above implementation method, based on the VOCs fingerprint spectrum of upstream and downstream of the rainwater pipe samples without cross-connection in the area to be investigated, a second threshold is determined by using a multidimensional similarity analysis algorithm combined with a minimum value screening method. This second threshold can be used as the lower limit of the similarity between the cross-connected pipes and the surrounding sewage pipes, thereby improving the efficiency of screening areas where rainwater pipes and surrounding sewage pipes are cross-connected.

[0032] In one optional implementation, the similarity result of the VOCs fingerprint spectrum of each rainwater pipe is obtained by using a pre-built multi-dimensional similarity comprehensive analysis algorithm based on the upstream and downstream VOCs fingerprint spectra of each rainwater pipe, including:

[0033] Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, various basic similarities between the upstream and downstream VOCs fingerprint maps of each rainwater pipe are obtained; the basic similarities include: cosine similarity, Pearson correlation coefficient and Euclidean distance similarity.

[0034] For the VOCs fingerprint spectrum between the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint spectrum are obtained by summing the weight coefficients corresponding to each basic similarity after correction.

[0035] Through the above implementation method, cosine similarity, Pearson correlation coefficient and Euclidean distance similarity are calculated for the VOCs fingerprint spectrum of each upstream and downstream of each rainwater pipe. Then, these basic similarities are corrected by combining the corresponding weight coefficients and summed. This makes it convenient to comprehensively and accurately quantify the similarity of the VOCs fingerprint spectrum of each upstream and downstream of each rainwater pipe. The contribution of key indicators can also be highlighted by adjusting the weights, ensuring that the similarity results of the VOCs fingerprint spectrum of each rainwater pipe obtained in the end are more in line with the needs of rainwater pipe mixed connection investigation.

[0036] Secondly, the present invention provides a device for investigating mixed connections in drainage pipe networks, the device comprising:

[0037] The data acquisition module is used to obtain the VOCs fingerprint spectrum of the upstream and downstream of each rainwater pipe in the area to be investigated by using a proton mass spectrometer monitoring method based on the pre-constructed geographical information of the drainage pipe network in the area to be investigated; the geographical information of the drainage pipe network in the area to be investigated includes the direction of the drainage pipes and the corresponding service area in the area to be investigated.

[0038] The similarity evaluation module is used to obtain the similarity result of the VOCs fingerprint spectrum of each rainwater pipe based on the upstream and downstream VOCs fingerprint spectrum of each rainwater pipe using a pre-built multi-dimensional similarity comprehensive analysis algorithm.

[0039] The first screening module is used to screen based on the similarity results of the VOCs fingerprint spectrum of each rainwater pipe using a first threshold to obtain the rainwater pipes to be investigated in the area to be investigated.

[0040] The second screening module is used to evaluate each rainwater pipe to be investigated in the area to be investigated by combining the upstream and downstream fingerprints of VOCs of the corresponding rainwater pipe with the surrounding sewage pipe inspection wells, using a pre-constructed multi-dimensional similarity comprehensive analysis algorithm, and combining it with a second threshold to obtain the preliminary investigation results of the corresponding rainwater pipe and sewage pipe mixed connection.

[0041] The result verification module is used to verify the preliminary investigation results of each rainwater pipe and sewage pipe connection using actual video monitoring, and obtain the final investigation results of each rainwater pipe and sewage pipe connection.

[0042] Thirdly, the present invention provides an electronic device, comprising: a memory and a processor, wherein the memory and the processor are communicatively connected to each other, the memory stores computer instructions, and the processor executes the computer instructions to perform the drainage pipe network mixed connection investigation method described in the first aspect or any corresponding embodiment.

[0043] Fourthly, the present invention provides a computer-readable storage medium storing computer instructions for causing a computer to execute the drainage network mixed connection investigation method described in the first aspect or any corresponding embodiment. Attached Figure Description

[0044] To more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the specific embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0045] Figure 1 This is a schematic diagram of an application scenario according to an embodiment of the present invention;

[0046] Figure 2 This is a schematic diagram of the first step in the drainage pipe network mixed connection investigation method according to an embodiment of the present invention;

[0047] Figure 3 This is a geographic information map of a drainage pipe network in a certain area to be investigated in the drainage pipe network mixed connection investigation method according to an embodiment of the present invention.

[0048] Figure 4 This is a schematic diagram of the second process of the drainage pipe network mixed connection investigation method according to an embodiment of the present invention;

[0049] Figure 5 This is a schematic diagram of the VOCs fingerprint spectrum of the upstream and downstream inspection wells of a certain rainwater pipe in the drainage pipe network mixed connection investigation method according to an embodiment of the present invention;

[0050] Figure 6 This is a schematic diagram of the third process of the drainage pipe network mixed connection investigation method according to an embodiment of the present invention;

[0051] Figure 7 This is a structural block diagram of a drainage pipe network mixed connection investigation device according to an embodiment of the present invention;

[0052] Figure 8 This is a schematic diagram of the hardware structure of an electronic device according to an embodiment of the present invention. Detailed Implementation

[0053] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0054] It is understood that before using the technical solutions disclosed in the various embodiments of the present invention, users should be informed of the types, scope of use, and usage scenarios of the personal information involved in the present invention and their authorization should be obtained in accordance with relevant laws and regulations through appropriate means.

[0055] The terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of this invention, "a plurality of" means two or more, unless otherwise explicitly specified.

[0056] As an optional application scenario of this invention, such as Figure 1 As shown, application 101 is installed in terminal device 110, and user 130 can interact with application 101 through terminal device 110 and / or access device of terminal device 110.

[0057] For example, application 101 can be any application that provides question-and-answer related services. For instance, application 101 could be a question-and-answer interactive application, such as a text-to-text application, an image-to-text application, etc. Figure 1 In the application scenario shown, if application 101 is active, the terminal device 110 can display the interface 102 of application 101. The interface 102 may include various pages that application 101 can provide, such as interactive pages, settings pages, query pages, etc.

[0058] In some embodiments, terminal device 110 is communicatively connected to server 120 to provide services to application 101. Terminal device 110 may be a mobile terminal, fixed terminal, or portable terminal, etc., including but not limited to mobile phones, desktop computers, laptop computers, multimedia tablets, e-book devices, gaming devices, or any combination thereof, including accessories and peripherals of these devices or any combination thereof. In some embodiments, terminal device 110 may also support any type of interface, and server 120 may be various types of computing systems or servers capable of providing computing power, including but not limited to mainframes, edge computing nodes, computing devices in cloud environments, etc.

[0059] It should be noted that, Figure 1 This is merely an example of an application scenario and does not limit the scope of protection of this invention.

[0060] The embodiments of the present invention will now be described with reference to the accompanying drawings. It should be understood that the pages shown in the drawings are merely examples, and various page designs are possible in practice. The various graphic elements on the page may have different arrangements and different visual representations; one or more elements may be omitted or replaced, and one or more other elements may also be present, without any limitation in the embodiments of the present invention. Furthermore, the embodiments described below primarily pertain to terminal device 110. It should be understood that the actions described relative to terminal device 110 can be performed by application 101 on terminal device 110, or can be performed by application 101 in conjunction with its server (e.g., server 120).

[0061] Since the essence of the problem of mixed connections in drainage pipe networks is the illegal connection of sewage pipes to stormwater pipes, resulting in direct discharge of sewage into stormwater pipes, identifying the connection points between sewage and stormwater pipes is the core of investigating and addressing mixed connections in drainage pipe networks. In urban drainage systems, there are significant differences in volatile organic compounds (VOCs) in water bodies from different sources. This difference stems from the combined effects of factors such as water source, hydrogeological conditions, microbial activity, and the degree of human intervention. Therefore, water bodies from different sources will acquire specific VOC fingerprint profiles after flowing through drainage pipes.

[0062] Based on the above, the drainage pipe network cross-connection investigation method provided in this embodiment utilizes pre-constructed drainage pipe network geographic information combined with proton mass spectrometry monitoring to obtain VOCs fingerprint spectra of the upstream and downstream of each rainwater pipe. Then, a multi-dimensional similarity comprehensive analysis algorithm is used to obtain the similarity results of the VOCs fingerprint spectra of each rainwater pipe, accurately capturing the subtle differences in VOCs fingerprint spectra between the upstream and downstream of each rainwater pipe. Subsequently, a first threshold is used for initial screening, which can quickly locate suspected cross-connection rainwater pipes from a large number of rainwater pipes in the area to be investigated, thereby narrowing down the scope of rainwater pipe investigation. Then, by combining the upstream and downstream VOCs fingerprint spectra of the rainwater pipes with the surrounding sewage pipe inspection wells, a second threshold is used to further determine the cross-connection area of ​​rainwater pipes and sewage pipes, shortening the investigation time. Finally, on-site verification is completed with actual video monitoring to ensure the authenticity and reliability of the investigation results, overcoming the low efficiency of the drainage pipe network cross-connection investigation methods disclosed in related technologies.

[0063] According to an embodiment of the present invention, a method for investigating mixed connections in drainage pipe networks is provided. It should be noted that the steps shown in the flowchart in the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions. Furthermore, although a logical order is shown in the flowchart, in some cases, the steps shown or described may be executed in a different order than that shown here.

[0064] This embodiment provides a method for troubleshooting mixed connections in drainage pipe networks, which can be used in the aforementioned drainage system management server terminal. Figure 2 This is a flowchart of a drainage pipe network mixed connection investigation method according to an embodiment of the present invention, such as... Figure 2 As shown, the process includes the following steps:

[0065] S201, based on the pre-constructed geographical information of the drainage pipe network in the area to be investigated, the VOCs fingerprint spectrum of the upstream and downstream of each rainwater pipe in the area to be investigated is obtained using the proton mass spectrometry monitoring method; the geographical information of the drainage pipe network in the area to be investigated includes the direction of the drainage pipes and the corresponding service areas in the area to be investigated.

[0066] Geographic information of drainage pipe network refers to the collection of relevant data such as spatial location, attributes and topological relationships of drainage system in the area to be investigated. In this embodiment, it specifically includes the direction of drainage pipe (the direction of water flow and laying path of the pipe) and the corresponding service area (the geographical range in which the drainage pipe is responsible for collecting and transporting rainwater or sewage).

[0067] Specifically, the construction of geographic information for the drainage pipe network in the area to be investigated includes:

[0068] Based on the survey materials of the drainage pipe network in the area to be investigated, the flow direction and service area of ​​each drainage pipe are sorted out to obtain the geographical information of the drainage pipe network in the area to be investigated. The survey materials of the drainage pipe network include pipe type, manhole number and coordinates, and connection relationship.

[0069] The survey data of drainage pipe networks are various original data reflecting the basic conditions of the drainage system in the area to be investigated, such as the general survey data of municipal drainage pipe networks, construction plans, and pipe renovation records.

[0070] Pipe type is a functional classification of pipes in drainage pipe network, mainly including rainwater pipes (pipes specifically for collecting and transporting rainwater) and sewage pipes (pipes specifically for collecting and transporting domestic sewage or industrial wastewater).

[0071] The manhole number is a unique identifier assigned to each manhole within the area to be investigated, used to distinguish different manholes and facilitate the recording, management, and on-site location of pipeline network information. Manhole coordinates, on the other hand, refer to the geographic spatial location information of the manhole and are key spatial data for constructing pipeline network geographic information.

[0072] Connection relationships refer to the topological connections between drainage pipes and manholes, and between different drainage pipes, such as "which pipe section connects to which manhole" and "which pipe section connects the manholes". Clarifying connection relationships is an important foundation for understanding the water flow path of the pipe network and dividing service zones.

[0073] The flow direction of drainage pipes refers to the direction of water flow within the drainage pipes. It can be determined by analyzing survey materials such as the elevation difference of inspection wells and pipe connection relationships. It is the core basis for selecting upstream and downstream monitoring points of rainwater pipes.

[0074] Service zones refer to the catchment area corresponding to a certain section of drainage pipe or a certain manhole. That is, the pipe / manhole is responsible for collecting and transporting rainwater or sewage in that area. Identifying service zones helps to carry out investigation work by area and analyze the possible sources of mixed sewage.

[0075] Proton mass spectrometry (PMS) is an analytical method for detecting VOCs in rainwater pipes. PMS ionizes VOC molecules and then separates and detects them based on differences in their mass-to-charge ratios, enabling rapid and accurate identification of VOC component types and concentrations.

[0076] Rainwater pipes are pipes in the drainage network specifically designed to collect and transport rainwater. Under normal circumstances, they only handle rainwater runoff. If sewage is mixed in, it indicates a potential problem of cross-contamination and is the core monitoring target of this investigation method.

[0077] Reference Figure 3 , Figure 3 The map shows a geographic information map of the drainage pipe network in an area to be investigated. The blue lines represent different rainwater pipes, and the numbers are the corresponding rainwater pipe numbers. The arrows on the blue lines indicate the flow direction of the rainwater pipes. The red triangles represent the outlets of the drainage pipe network in this area.

[0078] S202, based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint maps of each rainwater pipe are obtained by using a pre-constructed multi-dimensional similarity comprehensive analysis algorithm.

[0079] Specifically, the multidimensional similarity comprehensive analysis algorithm can be expressed as:

[0080] ,

[0081] ,

[0082] ,

[0083] ,

[0084] ,

[0085] ,

[0086] in, This indicates the similarity result of the VOCs fingerprint spectrum of a certain rainwater pipe; This represents the first VOCs fingerprint of the current rainwater pipe. A basic similarity, specifically... This represents the cosine similarity of the VOCs fingerprints of two inspection wells in the current rainwater pipeline. This represents the Pearson correlation coefficient of the VOCs fingerprint spectra of two inspection wells in the current rainwater pipeline. This indicates the Euclidean distance similarity between the VOCs fingerprints of two inspection wells in the current rainwater pipeline; This represents the first VOCs fingerprint corresponding to the current rainwater pipe. The weights for the basic similarity scores can be implemented as [0.3, 0.3, 0.4]. For the current rainwater pipe inspection well The mass-to-charge ratio in the VOCs fingerprint spectrum is Normalized intensity of the molecular ion peak; This indicates the current stormwater pipe inspection well. The mass-to-charge ratio in the VOCs fingerprint spectrum is Normalized intensity of the molecular ion peak; This indicates the current stormwater pipe inspection well. The normalized intensity of the average molecular ion peak in the VOCs fingerprint spectrum; This indicates the current stormwater pipe inspection well. The normalized intensity of the average molecular ion peak in the VOCs fingerprint spectrum.

[0087] S203, based on the similarity results of the VOCs fingerprint spectrum of each rainwater pipe, a first threshold is used for screening to obtain the rainwater pipes to be investigated in the area to be investigated.

[0088] Specifically, the acquisition of the first threshold includes:

[0089] Based on multiple interconnected rainwater pipes in the area to be investigated, obtain the VOCs fingerprint spectrum of the upstream and downstream of each pipe.

[0090] Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint maps of each rainwater pipe are obtained by using a preset multidimensional similarity comprehensive analysis algorithm.

[0091] By combining the similarity results of the VOCs fingerprint spectrum of each rainwater pipe, the maximum similarity of the VOCs fingerprint spectrum is obtained by using the maximum value screening method, and is used as the first threshold.

[0092] Multiple unconnected stormwater pipes within the investigation area can be detected using geophysical methods. For example, if there are n connected stormwater pipe samples within the investigation area, the similarity of the VOCs fingerprint spectra of the upstream and downstream of these n stormwater pipes can be analyzed and denoted as follows: , , , Then the first threshold is expressed as:

[0093] ,

[0094] The rainwater pipes to be investigated in the area to be investigated are those with similarity results below the first threshold, indicating that there are suspected mixed rainwater pipes in the area to be investigated.

[0095] Based on the VOCs fingerprints of upstream and downstream samples of unconnected rainwater pipes in the area to be investigated, and using a multidimensional similarity analysis algorithm combined with a maximum value screening method to determine the first threshold, the first threshold can accurately match the characteristics of the connection scenario in the area to be investigated. This facilitates the rapid identification of pipes suspected of being connected in the area to be investigated, narrows down the scope of subsequent investigations, and effectively avoids the defect of missing connected rainwater pipes.

[0096] S204. For each rainwater pipe to be investigated in the area to be investigated, the upstream and downstream fingerprint maps of VOCs of the corresponding rainwater pipe and the surrounding sewage pipe inspection wells are combined. A pre-constructed multi-dimensional similarity comprehensive analysis algorithm is used, and combined with the second threshold for evaluation, to obtain the preliminary investigation results of the corresponding rainwater pipe and sewage pipe connection.

[0097] Specifically, obtaining the second threshold includes:

[0098] Based on multiple unconnected rainwater pipes in the area to be investigated, obtain the VOCs fingerprint spectrum of the upstream and downstream of each pipe.

[0099] Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint maps of each rainwater pipe are obtained by using a preset multidimensional similarity comprehensive analysis algorithm.

[0100] By combining the similarity results of VOCs fingerprint spectra of each rainwater pipe, the minimum similarity of the VOCs fingerprint spectra is obtained using the minimum value screening method, and this minimum similarity is used as the second threshold.

[0101] Multiple interconnected rainwater pipes within the area to be investigated can also be detected using geophysical methods. For example, if the sample of non-interconnected rainwater pipes within the area to be investigated is... By analyzing the above The similarity of VOCs fingerprint profiles between the upstream and downstream of a rainwater pipe is denoted as follows: , , , Then the second threshold is expressed as:

[0102] ,

[0103] The preliminary investigation results of the corresponding rainwater pipes and sewage pipes are that the similarity results of the rainwater pipes are greater than or equal to the second threshold. This indicates that the rainwater pipes in the area to be investigated have a high similarity with the current sewage pipes, reaching the level of direct connection, that is, there is a cross-connection.

[0104] Based on the VOCs fingerprints of upstream and downstream samples of actual mixed stormwater pipes in the area to be investigated, a second threshold is determined using a multidimensional similarity analysis algorithm combined with a minimum value screening method. This second threshold can be used as the lower limit of the similarity between the mixed pipes and the surrounding sewage pipes, thereby improving the efficiency of screening areas where stormwater pipes are mixed with surrounding sewage pipes.

[0105] For example, for each rainwater pipe (denoted as x=[1,2,...,X]) in the area to be investigated, a similarity analysis of its VOCs fingerprint spectrum with that of the surrounding sewage pipes (denoted as u=[1,2,...,U]) is performed, and the samples are labeled as follows: .when ≥ At that time, the VOCs fingerprint spectrum of rainwater pipe x and the VOCs fingerprint spectrum of sewage pipe u have a high similarity, indicating that the two have a spatial connectivity relationship.

[0106] S205, based on the preliminary investigation results of the mixed connection of each rainwater pipe and sewage pipe, is verified by actual video monitoring to obtain the final investigation results of the mixed connection of each rainwater pipe and sewage pipe, supporting the renovation of the mixed connection of pipes.

[0107] The actual video monitoring method involves using video acquisition equipment (such as pipeline robots, periscopes, high-definition cameras, etc.) to penetrate deep into the rainwater pipes or inspection wells to capture real-time images of the water flow, pollutant characteristics, and pipe connections. Video monitoring allows for direct observation of whether sewage is flowing from sewage pipes into rainwater pipes, making it a crucial on-site verification method for identifying potential cross-connections.

[0108] The drainage pipe network cross-connection investigation method provided in this embodiment utilizes pre-constructed drainage pipe network geographic information combined with proton mass spectrometry monitoring to obtain VOCs fingerprint spectra of the upstream and downstream of each rainwater pipe. Then, a multi-dimensional similarity comprehensive analysis algorithm is used to obtain the similarity results of the VOCs fingerprint spectra of each rainwater pipe, accurately capturing subtle differences in VOCs fingerprint spectra between the upstream and downstream of each rainwater pipe. Next, a first threshold is used for initial screening, quickly locating suspected cross-connected rainwater pipes from a large number of rainwater pipes in the investigation area, thus narrowing the investigation scope. Then, by combining the upstream and downstream VOCs fingerprint spectra of the rainwater pipes with those of the surrounding sewage pipe inspection wells, a second threshold is used to further determine the cross-connection areas of rainwater and sewage pipes, shortening the investigation time. Finally, on-site verification is completed using actual video monitoring to ensure the authenticity and reliability of the investigation results. This method overcomes the low efficiency of existing drainage pipe network cross-connection investigation methods in related technologies.

[0109] This embodiment provides a method for troubleshooting mixed connections in drainage pipe networks, which can be used in the aforementioned drainage system management server terminal. Figure 4 This is a flowchart of a drainage pipe network mixed connection investigation method according to an embodiment of the present invention, such as... Figure 4 As shown, the process includes the following steps:

[0110] S401, based on the pre-constructed geographical information of the drainage pipe network in the area to be investigated, the upstream and downstream VOCs fingerprint spectrum of each rainwater pipe in the area to be investigated is obtained using the proton mass spectrometry monitoring method; the geographical information of the drainage pipe network in the area to be investigated includes the direction of the drainage pipes and the corresponding service areas in the area to be investigated.

[0111] Specifically, S401 includes:

[0112] S4011, based on the preprocessed geographical information of the drainage pipe network in the area to be investigated, uses a proton mass spectrometer monitoring method to obtain VOCs detection data in the upstream and downstream inspection wells of each rainwater pipe along the flow direction of each rainwater pipe.

[0113] In some alternative implementations, S4011 includes:

[0114] Based on the pre-processed geographical information of the drainage pipe network in the area to be investigated, for each rainwater pipe, the air intake pipe is placed into the corresponding rainwater pipe along the upstream or downstream inspection well to extract VOCs in the pipe. The VOCs detection data in the upstream or downstream inspection well of each rainwater pipe are obtained by using a proton mass spectrometer monitoring method.

[0115] The proton mass spectrometer used in the proton mass spectrometry monitoring method can be implemented as a proton transfer reaction time-of-flight mass spectrometer. The air intake pipe of the proton mass spectrometer is used to extract VOCs from the rainwater pipes through a manhole. Simultaneously, the tip of the air intake pipe for VOC extraction is placed as close as possible to the space above the water flow in the pipe. When there is no water flow in the pipe, the tip of the air intake pipe can be lowered into the interior space of the pipe, for example, placing it within 25cm above the water surface. When there is no water flow in the pipe, the tip of the air intake pipe is lowered to the center of the pipe. This avoids interference from external air VOCs due to the placement of the air intake pipe near the manhole opening, thus improving the accuracy of the VOCs detection data for each rainwater pipe.

[0116] S4012, based on the VOCs detection data in the upstream and downstream inspection wells of each rainwater pipe, the data processing method is used to process the data to obtain the VOCs fingerprint spectrum of the upstream and downstream of each rainwater pipe; the data processing method includes removing strong background peaks and baseline peaks, normalization and smoothing processing.

[0117] Removal of strong background peaks includes removal of hydrated cluster ions H3O + (H2O) n The characteristic peaks and baseline peaks include electronic noise, environmental interference, and detector local signals. By utilizing normalization and smoothing processing, the VOCs fingerprint spectrum is simplified. At the same time, the VOCs data collected from different inspection wells are converted to a unified dimension, and the intensity of molecular ion peaks under different mass-to-charge ratios is normalized to ensure that the VOCs fingerprint spectra of each rainwater pipe upstream and downstream and between different rainwater pipes are comparable.

[0118] Reference Figure 5 , Figure 5 This indicates the use of data processing methods to... Figure 3 The VOCs fingerprint spectra of the upstream and downstream inspection wells of the rainwater pipe 1 were obtained after processing. The vertical axis represents the molecular ion peak intensity, and the horizontal axis represents the mass-to-charge ratio. The upper half of the table is the VOCs fingerprint spectra of the upstream inspection well, and the lower half of the table is the VOCs fingerprint spectra of the downstream inspection well.

[0119] First, based on the geographical information of the drainage pipe network, the flow direction of each rainwater pipe and the location of the upstream and downstream inspection wells are determined. Then, by placing an air intake pipe to extract VOCs from each rainwater pipe, the monitoring object of the proton mass spectrometer is strictly matched with the actual gas environment upstream and downstream of the rainwater pipe. This avoids data distortion caused by external air interference or misalignment of the monitoring points, ensures a one-to-one correspondence between the detection data and the spatial location of the pipe, and improves the accuracy of the final identification of the rainwater pipes to be investigated.

[0120] S402, based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, a pre-constructed multi-dimensional similarity comprehensive analysis algorithm is used to obtain the similarity results of the VOCs fingerprint maps of each rainwater pipe. For details, please refer to [link to relevant documentation]. Figure 2 S202 of the illustrated embodiment will not be described again here.

[0121] S403, based on the similarity results of the VOCs fingerprint spectrum of each rainwater pipe, a first threshold is used for filtering to obtain the rainwater pipes to be investigated for cross-connection in the area to be investigated. For details, please refer to... Figure 2 S203 of the illustrated embodiment will not be described again here.

[0122] S404: For each identified mixed-connection stormwater pipe in the area to be investigated, the upstream and downstream VOCs fingerprints of the corresponding stormwater pipe and its surrounding sewage pipe inspection wells are combined. A pre-constructed multi-dimensional similarity comprehensive analysis algorithm is used, along with a second threshold, for evaluation, to obtain the preliminary investigation results of the mixed-connection of stormwater and sewage pipes. For details, please refer to... Figure 2 S204 of the illustrated embodiment will not be described again here.

[0123] S405, based on the preliminary investigation results of each rainwater pipe and sewage pipe connection, is verified using actual video monitoring to obtain the final investigation results of each rainwater pipe and sewage pipe connection. For details, please refer to... Figure 2 S205 of the illustrated embodiment will not be described again here.

[0124] The drainage pipe network cross-connection investigation method provided in this embodiment utilizes pre-constructed drainage pipe network geographic information combined with proton mass spectrometry monitoring to obtain VOCs fingerprint spectra of the upstream and downstream of each rainwater pipe. Then, a multi-dimensional similarity comprehensive analysis algorithm is used to obtain the similarity results of the VOCs fingerprint spectra of each rainwater pipe, accurately capturing subtle differences in VOCs fingerprint spectra between the upstream and downstream of each rainwater pipe. Next, a first threshold is used for initial screening, quickly locating suspected cross-connected rainwater pipes from a large number of rainwater pipes in the investigation area, thus narrowing the investigation scope. Then, by combining the upstream and downstream VOCs fingerprint spectra of the rainwater pipes with those of the surrounding sewage pipe inspection wells, a second threshold is used to further determine the cross-connection areas of rainwater and sewage pipes, shortening the investigation time. Finally, on-site verification is completed using actual video monitoring to ensure the authenticity and reliability of the investigation results. This method overcomes the low efficiency of existing drainage pipe network cross-connection investigation methods in related technologies.

[0125] This embodiment provides a method for troubleshooting mixed connections in drainage pipe networks, which can be used in the aforementioned drainage system management server terminal. Figure 6This is a flowchart of a drainage pipe network mixed connection investigation method according to an embodiment of the present invention, such as... Figure 6 As shown, the process includes the following steps:

[0126] S601, based on pre-constructed geographical information of the drainage pipe network in the area to be investigated, a proton mass spectrometry monitoring method is used to obtain the VOCs fingerprint spectrum of the upstream and downstream of each rainwater pipe in the area to be investigated; the geographical information of the drainage pipe network in the area to be investigated includes the direction of the drainage pipes and the corresponding service areas within the area. For details, please refer to... Figure 2 S201 of the illustrated embodiment will not be described again here.

[0127] S602, based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint maps of each rainwater pipe are obtained by using a pre-constructed multi-dimensional similarity comprehensive analysis algorithm.

[0128] Specifically, the above S602 includes:

[0129] S6021, Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, obtain various basic similarities between the upstream and downstream VOCs fingerprint maps of each rainwater pipe; the basic similarities include: cosine similarity, Pearson correlation coefficient and Euclidean distance similarity.

[0130] S6022, for the multiple basic similarities of the VOCs fingerprint spectrum between the upstream and downstream of each rainwater pipe, the weight coefficients corresponding to each basic similarity are used for correction and summation to obtain the similarity result of the VOCs fingerprint spectrum for each rainwater pipe.

[0131] First, for the VOCs fingerprint spectra of the upstream and downstream of each stormwater pipe, cosine similarity, Pearson correlation coefficient, and Euclidean distance similarity are calculated respectively. Then, these basic similarities are corrected by combining the corresponding weight coefficients and summed. This makes it convenient to comprehensively and accurately quantify the similarity of the VOCs fingerprint spectra of the upstream and downstream of each stormwater pipe. The contribution of key indicators can also be highlighted by adjusting the weights, ensuring that the final similarity results of the VOCs fingerprint spectra of each stormwater pipe are more in line with the needs of stormwater pipe mixed connection investigation.

[0132] S603, based on the similarity results of the VOCs fingerprint spectrum of each rainwater pipe, a first threshold is used for filtering to obtain the rainwater pipes to be investigated for cross-connection in the area to be investigated. For details, please refer to... Figure 2 S203 of the illustrated embodiment will not be described again here.

[0133] S604: For each identified mixed-connection rainwater pipe in the area to be investigated, the upstream and downstream VOCs fingerprints of the corresponding rainwater pipe and its surrounding sewage pipe inspection wells are combined. A pre-constructed multi-dimensional similarity comprehensive analysis algorithm is used, along with a second threshold, for evaluation, to obtain the preliminary investigation results of the mixed-connection of rainwater and sewage pipes. For details, please refer to... Figure 2 S204 of the illustrated embodiment will not be described again here.

[0134] S605, based on the preliminary investigation results of each rainwater pipe and sewage pipe connection, verifies the findings using actual video monitoring to obtain the final investigation results for each rainwater pipe and sewage pipe connection. For details, please refer to [link to relevant documentation]. Figure 2 S205 of the illustrated embodiment will not be described again here.

[0135] The drainage pipe network cross-connection investigation method provided in this embodiment utilizes pre-constructed drainage pipe network geographic information combined with proton mass spectrometry monitoring to obtain VOCs fingerprint spectra of the upstream and downstream of each rainwater pipe. Then, a multi-dimensional similarity comprehensive analysis algorithm is used to obtain the similarity results of the VOCs fingerprint spectra of each rainwater pipe, accurately capturing subtle differences in VOCs fingerprint spectra between the upstream and downstream of each rainwater pipe. Next, a first threshold is used for initial screening, quickly locating suspected cross-connected rainwater pipes from a large number of rainwater pipes in the investigation area, thus narrowing the investigation scope. Then, by combining the upstream and downstream VOCs fingerprint spectra of the rainwater pipes with those of the surrounding sewage pipe inspection wells, a second threshold is used to further determine the cross-connection areas of rainwater and sewage pipes, shortening the investigation time. Finally, on-site verification is completed using actual video monitoring to ensure the authenticity and reliability of the investigation results. This method overcomes the low efficiency of existing drainage pipe network cross-connection investigation methods in related technologies.

[0136] This embodiment also provides a drainage pipe network mixed connection investigation device, which is used to implement the above embodiments and preferred embodiments, and will not be repeated for details already described. As used below, the term "module" can be a combination of software and / or hardware that implements a predetermined function. Although the device described in the following embodiments is preferably implemented in software, hardware implementation, or a combination of software and hardware, is also possible and contemplated.

[0137] This embodiment provides a device for troubleshooting mixed connections in drainage pipe networks, such as... Figure 7 As shown, it includes:

[0138] The data acquisition module 710 is used to obtain the VOCs fingerprint spectrum of the upstream and downstream of each rainwater pipe in the area to be investigated by using a proton mass spectrometer monitoring method based on the pre-constructed geographical information of the drainage pipe network in the area to be investigated; the geographical information of the drainage pipe network in the area to be investigated includes the direction of the drainage pipes and the corresponding service area in the area to be investigated.

[0139] The similarity evaluation module 720 is used to obtain the similarity result of the VOCs fingerprint spectrum of each rainwater pipe based on the upstream and downstream VOCs fingerprint spectrum of each rainwater pipe and using a pre-built multi-dimensional similarity comprehensive analysis algorithm.

[0140] The first screening module 730 is used to screen based on the similarity results of the VOCs fingerprint spectrum of each rainwater pipe using a first threshold to obtain the rainwater pipes to be investigated in the area to be investigated.

[0141] The second screening module 740 is used to evaluate each rainwater pipe to be investigated in the area to be investigated by combining the upstream and downstream fingerprint maps of VOCs of the corresponding rainwater pipe with the surrounding sewage pipe inspection wells, using a pre-constructed multi-dimensional similarity comprehensive analysis algorithm, and combining it with a second threshold to obtain the preliminary investigation results of the corresponding rainwater pipe and sewage pipe connection.

[0142] The result verification module 750 is used to verify the preliminary investigation results of each rainwater pipe and sewage pipe connection using actual video monitoring, and obtain the final investigation results of each rainwater pipe and sewage pipe connection.

[0143] In some alternative embodiments, the apparatus further includes:

[0144] The pipeline network information construction module is used to sort out the flow direction and service area of ​​each drainage pipe based on the survey materials of the drainage pipeline network in the area to be investigated, so as to obtain the geographical information of the drainage pipeline network in the area to be investigated. The survey materials of the drainage pipeline network include pipe type, manhole number and coordinates, and connection relationship.

[0145] In some optional implementations, the data acquisition module 710 includes

[0146] The data detection unit is used to obtain VOCs detection data in the upstream and downstream inspection wells of each rainwater pipe based on the pre-processed geographical information of the drainage pipe network in the area to be investigated, using the proton mass spectrometry monitoring method along the flow direction of each rainwater pipe.

[0147] The data processing unit is used to process VOCs detection data from the upstream and downstream inspection wells of each rainwater pipe using data processing methods to obtain VOCs fingerprints for the upstream and downstream of each rainwater pipe; the data processing methods include removing strong background peaks and baseline peaks, normalization, and smoothing.

[0148] In some optional implementations, the data detection unit is specifically used for:

[0149] Based on the pre-processed geographical information of the drainage pipe network in the area to be investigated, for each rainwater pipe, the air intake pipe is placed into the corresponding rainwater pipe along the upstream or downstream inspection well to extract VOCs in the pipe. The VOCs detection data in the upstream or downstream inspection well of each rainwater pipe are obtained by using a proton mass spectrometer monitoring method.

[0150] In some optional implementations, obtaining the first threshold in the first filtering module 730 includes:

[0151] Based on multiple interconnected rainwater pipes in the area to be investigated, obtain the VOCs fingerprint spectrum of the upstream and downstream of each pipe.

[0152] Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint maps of each rainwater pipe are obtained by using a preset multidimensional similarity comprehensive analysis algorithm.

[0153] By combining the similarity results of the VOCs fingerprint spectrum of each rainwater pipe, the maximum similarity of the VOCs fingerprint spectrum is obtained by using the maximum value screening method, and is used as the first threshold.

[0154] In some optional implementations, obtaining the second threshold in the second filtering module 740 includes:

[0155] Based on multiple unconnected rainwater pipes in the area to be investigated, obtain the VOCs fingerprint spectrum of the upstream and downstream of each pipe.

[0156] Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint maps of each rainwater pipe are obtained by using a preset multidimensional similarity comprehensive analysis algorithm.

[0157] By combining the similarity results of VOCs fingerprint spectra of each rainwater pipe, the minimum similarity of the VOCs fingerprint spectra is obtained using the minimum value screening method, and this minimum similarity is used as the second threshold.

[0158] In some optional implementations, the similarity evaluation module 720 includes:

[0159] The basic similarity acquisition unit is used to acquire multiple basic similarities between the upstream and downstream VOCs fingerprint spectra of each rainwater pipe based on the upstream and downstream VOCs fingerprint spectra of each rainwater pipe; the basic similarities include: cosine similarity, Pearson correlation coefficient and Euclidean distance similarity.

[0160] The similarity evaluation unit is used to calculate the similarity result of the VOCs fingerprint spectrum for each rainwater pipe by summing the weight coefficients corresponding to each basic similarity of the upstream and downstream VOCs fingerprint spectrum.

[0161] The drainage pipe network mixed connection investigation device provided in this embodiment of the invention can execute the drainage pipe network mixed connection investigation method provided in any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the method. Further functional descriptions of the above modules and units are the same as those in the corresponding embodiments above, and will not be repeated here.

[0162] Figure 8 This is a schematic diagram of the structure of an electronic device provided in an embodiment of the present invention.

[0163] The following is a detailed reference. Figure 8 This diagram illustrates a suitable structural schematic for implementing an electronic device according to embodiments of the present invention. The electronic device may include a processor (e.g., a central processing unit, graphics processor, etc.) 801, which can perform various appropriate actions and processes based on a program stored in read-only memory (ROM) 802 or a program loaded from memory 808 into random access memory (RAM) 803. The RAM 803 also stores various programs and data required for the operation of the electronic device. The processor 801, ROM 802, and RAM 803 are interconnected via a bus 804. An input / output (I / O) interface 805 is also connected to the bus 804.

[0164] Typically, the following devices can be connected to I / O interface 805: input devices 806 including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, gyroscopes, etc.; output devices 807 including, for example, liquid crystal displays (LCDs), speakers, vibrators, etc.; memory devices 808 including, for example, magnetic tapes, hard disks, etc.; and communication devices 809. Communication device 809 allows electronic devices to communicate wirelessly or wiredly with other devices to exchange data. Although Figure 8 Electronic devices with various devices are shown, but it should be understood that it is not required to implement or have all of the devices shown, and more or fewer devices may be implemented or have instead.

[0165] In particular, according to embodiments of the present invention, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of the present invention include a computer program product comprising a computer program carried on a non-transitory computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via a communication device 809, or installed from a memory 808, or installed from a ROM 802. When the computer program is executed by the processor 801, it performs the functions defined in the drainage network mixed connection investigation method of the embodiments of the present invention.

[0166] Figure 8 The electronic device shown is merely an example and should not be construed as limiting the functionality and scope of use of the embodiments of the present invention.

[0167] This invention also provides a computer-readable storage medium. The methods described above according to embodiments of the invention can be implemented in hardware or firmware, or implemented as computer code that can be recorded on a storage medium, or implemented as computer code downloaded via a network and originally stored on a remote storage medium or a non-transitory machine-readable storage medium and then stored on a local storage medium. Thus, the methods described herein can be processed by software stored on a storage medium using a general-purpose computer, a dedicated processor, or programmable or dedicated hardware. The storage medium can be a magnetic disk, optical disk, read-only memory, random access memory, flash memory, hard disk, or solid-state drive, etc.; further, the storage medium can also include combinations of the above types of memory. It is understood that computers, processors, microprocessor controllers, or programmable hardware include storage components capable of storing or receiving software or computer code. When the software or computer code is accessed and executed by the computer, processor, or hardware, the drainage network mixed connection investigation method shown in the above embodiments is implemented.

[0168] A portion of this invention can be applied as a computer program product, such as computer program instructions, which, when executed by a computer, can invoke or provide the methods and / or technical solutions according to the invention through the operation of the computer. Those skilled in the art will understand that the forms in which computer program instructions exist in a computer-readable medium include, but are not limited to, source files, executable files, installation package files, etc. Correspondingly, the ways in which computer program instructions are executed by a computer include, but are not limited to: the computer directly executing the instructions, or the computer compiling the instructions and then executing the corresponding compiled program, or the computer reading and executing the instructions, or the computer reading and installing the instructions and then executing the corresponding installed program. Here, the computer-readable medium can be any available computer-readable storage medium or communication medium accessible to a computer.

[0169] Although embodiments of the invention have been described in conjunction with the accompanying drawings, those skilled in the art can make various modifications and variations without departing from the spirit and scope of the invention, and such modifications and variations all fall within the scope defined by the appended claims.

Claims

1. A method for investigating mixed connections in drainage pipe networks, characterized in that, The method includes: Based on the pre-constructed geographical information of the drainage pipe network in the area to be investigated, the VOCs fingerprint spectrum of the upstream and downstream of each rainwater pipe in the area to be investigated is obtained using the proton mass spectrometry monitoring method; the geographical information of the drainage pipe network in the area to be investigated includes the direction of the drainage pipes and the corresponding service areas in the area to be investigated. Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint maps of each rainwater pipe are obtained by using a pre-constructed multi-dimensional similarity comprehensive analysis algorithm. Based on the similarity results of the VOCs fingerprint spectrum of each rainwater pipe, the first threshold is used for screening to obtain the rainwater pipes to be investigated in the area to be investigated. For each rainwater pipe to be investigated in the area to be investigated, the upstream and downstream fingerprints of VOCs of the corresponding rainwater pipe and the surrounding sewage pipe inspection wells are combined. A pre-constructed multi-dimensional similarity comprehensive analysis algorithm is used, and combined with the second threshold for evaluation, to obtain the preliminary investigation results of the rainwater pipe and sewage pipe connection. Based on the preliminary investigation results of each rainwater pipe and sewage pipe being mixed, the results were verified using actual video monitoring to obtain the final investigation results of each rainwater pipe and sewage pipe being mixed.

2. The method according to claim 1, characterized in that, The construction of the geographical information of the drainage pipe network in the area to be investigated includes: Based on the survey materials of the drainage pipe network in the area to be investigated, the flow direction and service area of ​​each drainage pipe are sorted out to obtain the geographical information of the drainage pipe network in the area to be investigated. The survey materials of the drainage pipe network include pipe type, manhole number and coordinates, and connection relationship.

3. The method according to claim 1, characterized in that, Based on the pre-constructed geographical information of the drainage pipe network in the area to be investigated, the VOCs fingerprint spectrum of the upstream and downstream of each rainwater pipe in the area to be investigated is obtained using a proton mass spectrometry monitoring method, including: Based on the preprocessed geographical information of the drainage pipe network in the area to be investigated, the VOCs detection data in the upstream and downstream inspection wells of each rainwater pipe were obtained by using the proton mass spectrometry monitoring method along the flow direction of each rainwater pipe. Based on VOCs detection data from the upstream and downstream inspection wells of each rainwater pipe, data processing methods are used to obtain VOCs fingerprints for the upstream and downstream of each rainwater pipe; the data processing methods include removing strong background peaks and baseline peaks, normalization, and smoothing.

4. The method according to claim 3, characterized in that, Based on the preprocessed geographical information of the drainage pipe network in the area to be investigated, VOCs detection data in the upstream and downstream inspection wells of each rainwater pipe are obtained using a proton mass spectrometer monitoring method, along the flow direction of each rainwater pipe. This includes: Based on the pre-processed geographical information of the drainage pipe network in the area to be investigated, for each rainwater pipe, the air intake pipe is placed into the corresponding rainwater pipe along the upstream or downstream inspection well to extract VOCs in the pipe. The VOCs detection data in the upstream or downstream inspection well of each rainwater pipe are obtained by using a proton mass spectrometer monitoring method.

5. The method according to claim 1, characterized in that, Obtaining the first threshold includes: Based on multiple interconnected rainwater pipes in the area to be investigated, obtain the VOCs fingerprint spectrum of the upstream and downstream of each pipe. Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint maps of each rainwater pipe are obtained by using a preset multidimensional similarity comprehensive analysis algorithm. By combining the similarity results of the VOCs fingerprint spectrum of each rainwater pipe, the maximum similarity of the VOCs fingerprint spectrum is obtained by using the maximum value screening method, and is used as the first threshold.

6. The method according to claim 1, characterized in that, Obtaining the second threshold includes: Based on multiple unconnected rainwater pipes in the area to be investigated, obtain the VOCs fingerprint spectrum of the upstream and downstream of each pipe. Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint maps of each rainwater pipe are obtained by using a preset multidimensional similarity comprehensive analysis algorithm. By combining the similarity results of VOCs fingerprint spectra of each rainwater pipe, the minimum similarity of the VOCs fingerprint spectra is obtained using the minimum value screening method, and this minimum similarity is used as the second threshold.

7. The method according to claim 1, characterized in that, Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, a pre-constructed multi-dimensional similarity comprehensive analysis algorithm is used to obtain the similarity results of the VOCs fingerprint maps of each rainwater pipe, including: Based on the VOCs fingerprint maps of the upstream and downstream of each rainwater pipe, various basic similarities between the upstream and downstream VOCs fingerprint maps of each rainwater pipe are obtained; the basic similarities include: cosine similarity, Pearson correlation coefficient and Euclidean distance similarity. For the VOCs fingerprint spectrum between the upstream and downstream of each rainwater pipe, the similarity results of the VOCs fingerprint spectrum are obtained by summing the weight coefficients corresponding to each basic similarity after correction.

8. A device for investigating mixed connections in drainage pipe networks, characterized in that, The device includes: The data acquisition module is used to obtain the VOCs fingerprint spectrum of the upstream and downstream of each rainwater pipe in the area to be investigated by using a proton mass spectrometer monitoring method based on the pre-constructed geographical information of the drainage pipe network in the area to be investigated; the geographical information of the drainage pipe network in the area to be investigated includes the direction of the drainage pipes and the corresponding service area in the area to be investigated. The similarity evaluation module is used to obtain the similarity result of the VOCs fingerprint spectrum of each rainwater pipe based on the upstream and downstream VOCs fingerprint spectrum of each rainwater pipe using a pre-built multi-dimensional similarity comprehensive analysis algorithm. The first screening module is used to screen based on the similarity results of the VOCs fingerprint spectrum of each rainwater pipe using a first threshold to obtain the rainwater pipes to be investigated in the area to be investigated. The second screening module is used to evaluate each rainwater pipe to be investigated in the area to be investigated by combining the upstream and downstream fingerprints of VOCs of the corresponding rainwater pipe with the surrounding sewage pipe inspection wells, using a pre-constructed multi-dimensional similarity comprehensive analysis algorithm, and combining it with a second threshold to obtain the preliminary investigation results of the corresponding rainwater pipe and sewage pipe mixed connection. The result verification module is used to verify the preliminary investigation results of each rainwater pipe and sewage pipe connection using actual video monitoring, and obtain the final investigation results of each rainwater pipe and sewage pipe connection.

9. An electronic device, characterized in that, include: The system includes a memory and a processor, which are interconnected. The memory stores computer instructions, and the processor executes the computer instructions to perform the drainage network mixed connection investigation method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer instructions for causing the computer to execute the drainage network mixed connection investigation method according to any one of claims 1 to 7.

Images