External water quantitative analysis method and system based on three-dimensional fluorescence peak value pickup method and medium

Abstract

The invention provides an external water quantitative analysis method and system based on a three-dimensional fluorescence peak value pickup method and a medium, and the method comprises the steps: obtaining a problem pipe section, and carrying out block division to obtain a plurality of flow calculation blocks; upstream sewage, external water and mixed sewage samples of the pipeline in each flow calculation block are collected, the upstream sewage, external water and mixed sewage samples are scanned based on the set wavelength range of a three-dimensional fluorescence spectrometer, and a three-dimensional fluorescence spectrum is obtained; preprocessing the three-dimensional fluorescence spectrum, and screening out a characteristic peak region; a mixing experiment is simulated based on the proportion of sewage and external water, a standard curve of the volume ratio of sewage and the characteristic peak fluorescence intensity of a mixed sewage sample is established, and the upstream sewage flow, the external water flow and the mixed sewage sample flow are calculated based on Lambert-Beer law verification analysis; through the three-dimensional fluorescence spectrum, the problem of geological flow measurement in a pipe network operation and maintenance actual scene under a complex condition can be effectively solved, and quantitative analysis of external water in a sewage pipeline is realized.

Description

Technical Field

[0001] The present application relates to the technical field of robot parameter calibration, and in particular to a method, system and medium for quantitative analysis of external water based on a three-dimensional fluorescence peak picking method. Background Art

[0002] Three-dimensional fluorescence technology has been extensively studied for identifying water types in urban wastewater pipe networks. Using methods such as peak extraction, parallel factor analysis, and artificial neural networks, water types can be quickly and accurately analyzed and identified, enabling the tracing of wastewater pollution sources. However, during pipe network operation and maintenance, the severity of pollution issues often needs to be assessed to facilitate reporting and remediation planning. This requires measuring the amount of pollution at the source or the amount of wastewater flowing out. Urban pipe networks are long construction cycles and often suffer from problems such as misconnections, aging, damage, and leaks. Conventional flow measurement methods are inadequate for measuring wastewater flow in situations where the leak location is unknown or flow rates are slow. Currently, research on three-dimensional fluorescence technology has focused on quantitative flow measurement. Patent CN119784746A applies three-dimensional fluorescence to the diagnosis of low-pollution water inflow and infiltration in urban sewage pipe networks. This method, based on image recognition and machine learning techniques, relies on big data models for analysis and judgment, lacking a mechanistic understanding of the fluorescence spectrum and water status. Summary of the Invention

[0003] The purpose of the embodiments of the present application is to provide a method, system and medium for quantitative analysis of external water based on a three-dimensional fluorescence peak picking method. The three-dimensional fluorescence spectrum can effectively solve the flow measurement problem in complex situations in actual pipeline operation and maintenance scenarios to achieve quantitative analysis of external water in sewage pipes.

[0004] The present application also provides a method for quantitative analysis of external water based on a three-dimensional fluorescence peak picking method, comprising:

[0005] Obtain the problematic pipe section, analyze its distribution information, and divide it into blocks based on the distribution information to obtain multiple flow calculation blocks;

[0006] Collect upstream sewage, external water, and mixed sewage samples from the pipeline in each flow calculation block respectively. Scan the upstream sewage, external water, and mixed sewage samples based on the wavelength range set by the three-dimensional fluorescence spectrometer to obtain a three-dimensional fluorescence spectrum.

[0007] Preprocessing the three-dimensional fluorescence spectrum, generating the fluorescence intensity of upstream sewage, external water and mixed sewage samples based on the preprocessed three-dimensional fluorescence spectrum, and screening the characteristic peak area based on the fluorescence intensity;

[0008] Based on the simulated mixing experiment of sewage and external water ratio, a standard curve of sewage volume ratio and characteristic peak fluorescence intensity of mixed sewage samples was established. The upstream sewage ratio result was obtained based on the Lambert-Beer law verification analysis.

[0009] Based on the upstream sewage proportion results, the upstream sewage flow, external water flow and mixed sewage sample flow are calculated.

[0010] Optionally, in the external water quantitative analysis method based on the three-dimensional fluorescence peak picking method described in the embodiment of the present application, a problem pipe section is obtained, distribution information of the problem pipe section is analyzed, and the problem pipe section is divided into blocks based on the distribution information of the problem pipe section to obtain multiple flow calculation blocks, specifically including:

[0011] Check abnormal information of pipelines in the pipeline network and find the problematic pipe sections;

[0012] Analyze the location and direction of problem pipe sections based on the pipe network distribution map;

[0013] Set the segmentation area, divide the area into blocks based on the location and direction of the problem pipe section, and obtain the segmentation result;

[0014] Determine whether the same problematic pipe section is divided into different blocks based on the division results;

[0015] If it is divided into different blocks, the same problem pipe section will be divided into the same block. If it is divided into the same block, multiple flow calculation blocks will be obtained.

[0016] Optionally, in the external water quantitative analysis method based on the three-dimensional fluorescence peak picking method described in the embodiment of the present application, upstream sewage, external water, and mixed sewage samples are collected from the pipeline in each flow calculation block respectively, and the upstream sewage, external water, and mixed sewage samples are scanned based on the wavelength range set by the three-dimensional fluorescence spectrometer to obtain a three-dimensional fluorescence spectrum, specifically including:

[0017] Set up multiple sampling points upstream and downstream of the pipeline and on the external water pipeline to obtain the upstream sewage, external water and mixed sewage sampling values ​​at each sampling point;

[0018] The upstream sewage, external water and mixed sewage sampling values ​​at different sampling points were averaged to obtain the sample mean;

[0019] Based on the sample mean values, upstream sewage, external water and mixed sewage samples were obtained;

[0020] Obtain initial parameters based on a three-dimensional fluorescence spectrometer, calibrate the initial parameters using ultrapure water or a standard fluorescent substance solution to obtain calibrated parameters, and set the excitation wavelength range and emission wavelength range based on the calibrated parameters;

[0021] Based on the excitation wavelength range and emission wavelength range, upstream sewage, external water and mixed sewage samples were scanned to obtain a three-dimensional fluorescence spectrum.

[0022] Optionally, in the external water quantitative analysis method based on the three-dimensional fluorescence peak picking method described in the embodiment of the present application, upstream sewage, external water and mixed sewage samples are scanned based on the excitation wavelength range and the emission wavelength range to obtain a three-dimensional fluorescence spectrum; specifically, the method includes:

[0023] The 3D-scan mode is adopted, with an excitation wavelength range of 200-500nm, an emission wavelength range of 250-500nm, a scanning interval of 5nm, a voltage of 600-800V, a scanning speed of 10000-12000nm / min, a slit width of 3-5nm, and a response time of 0.1s-0.3s.

[0024] Optionally, in the external water quantitative analysis method based on the three-dimensional fluorescence peak picking method described in the embodiment of the present application, the three-dimensional fluorescence spectrum is preprocessed, and the fluorescence intensity of the upstream sewage, external water and mixed sewage samples is generated based on the preprocessed three-dimensional fluorescence spectrum. The characteristic peak area is screened based on the fluorescence intensity, specifically including:

[0025] Acquire three-dimensional fluorescence spectra and remove spectral noise data;

[0026] Baseline correction is performed on the three-dimensional fluorescence spectrum after noise removal based on polynomial fitting or discrete wavelet transform;

[0027] The three-dimensional fluorescence spectra after baseline correction were normalized to obtain the fluorescence intensity of upstream sewage, external water and mixed sewage samples;

[0028] Based on the fluorescence intensity, the fluorescence peak area that can significantly distinguish upstream sewage, external water and mixed sewage is screened out to obtain the characteristic peak area.

[0029] Optionally, in the external water quantitative analysis method based on the three-dimensional fluorescence peak picking method described in the embodiment of the present application, based on the simulated mixing experiment of the sewage and external water ratio, a standard curve of the sewage volume ratio and the fluorescence intensity of the characteristic peak of the mixed sewage sample is established, and based on the Lambert-Beer law verification analysis, the upstream sewage ratio result is obtained, specifically including:

[0030] Different ratios of sewage to external water volumes were set to conduct proportional simulation mixing experiments, and the linear relationship between the upstream sewage volume ratio and the fluorescence intensity of the characteristic peak of the mixed sample was analyzed.

[0031] The comparison results were obtained based on the linear relationship between the volume ratio of upstream sewage and the fluorescence intensity of the characteristic peak of the mixed sample and the standard curve of the volume ratio of sewage and the fluorescence intensity of the characteristic peak of the mixed sewage sample.

[0032] Based on the analysis and comparison results of Lambert-Beer law, the proportion of upstream sewage was obtained.

[0033] In a second aspect, an embodiment of the present application provides a system for quantitatively analyzing external water based on a three-dimensional fluorescence peak picking method, the system comprising: a memory and a processor, the memory comprising a program for a method for quantitatively analyzing external water based on a three-dimensional fluorescence peak picking method, the program for quantitatively analyzing external water based on a three-dimensional fluorescence peak picking method, when executed by the processor, implementing the following steps:

[0034] Obtain the problematic pipe section, analyze its distribution information, and divide it into blocks based on the distribution information to obtain multiple flow calculation blocks;

[0035] Collect upstream sewage, external water, and mixed sewage samples from the pipeline in each flow calculation block respectively. Scan the upstream sewage, external water, and mixed sewage samples based on the wavelength range set by the three-dimensional fluorescence spectrometer to obtain a three-dimensional fluorescence spectrum.

[0036] Preprocessing the three-dimensional fluorescence spectrum, generating the fluorescence intensity of upstream sewage, external water and mixed sewage samples based on the preprocessed three-dimensional fluorescence spectrum, and screening the characteristic peak area based on the fluorescence intensity;

[0037] Based on the simulated mixing experiment of sewage and external water ratio, a standard curve of sewage volume ratio and characteristic peak fluorescence intensity of mixed sewage samples was established. The upstream sewage ratio result was obtained based on the Lambert-Beer law verification analysis.

[0038] Based on the upstream sewage proportion results, the upstream sewage flow, external water flow and mixed sewage sample flow are calculated.

[0039] Optionally, in the external water quantitative analysis system based on the three-dimensional fluorescence peak picking method described in the embodiment of the present application, a problem pipe section is obtained, distribution information of the problem pipe section is analyzed, and the problem pipe section is divided into blocks based on the distribution information of the problem pipe section to obtain multiple flow calculation blocks, specifically including:

[0040] Check abnormal information of pipelines in the pipeline network and find the problematic pipe sections;

[0041] Analyze the location and direction of problem pipe sections based on the pipe network distribution map;

[0042] Set the segmentation area, divide the area into blocks based on the location and direction of the problem pipe section, and obtain the segmentation result;

[0043] Determine whether the same problematic pipe section is divided into different blocks based on the division results;

[0044] If it is divided into different blocks, the same problem pipe section will be divided into the same block. If it is divided into the same block, multiple flow calculation blocks will be obtained.

[0045] Optionally, in the external water quantitative analysis system based on the three-dimensional fluorescence peak picking method described in the embodiment of the present application, upstream sewage, external water, and mixed sewage samples are collected from the pipeline in each flow calculation block respectively, and the upstream sewage, external water, and mixed sewage samples are scanned based on the wavelength range set by the three-dimensional fluorescence spectrometer to obtain a three-dimensional fluorescence spectrum, specifically including:

[0046] Set up multiple sampling points upstream and downstream of the pipeline and on the external water pipeline to obtain the upstream sewage, external water and mixed sewage sampling values ​​at each sampling point;

[0047] The upstream sewage, external water and mixed sewage sampling values ​​at different sampling points were averaged to obtain the sample mean;

[0048] Based on the sample mean values, upstream sewage, external water and mixed sewage samples were obtained;

[0049] Obtain initial parameters based on a three-dimensional fluorescence spectrometer, calibrate the initial parameters using ultrapure water or a standard fluorescent substance solution to obtain calibrated parameters, and set the excitation wavelength range and emission wavelength range based on the calibrated parameters;

[0050] Based on the excitation wavelength range and emission wavelength range, upstream sewage, external water and mixed sewage samples were scanned to obtain a three-dimensional fluorescence spectrum.

[0051] In a third aspect, an embodiment of the present application also provides a computer-readable storage medium, which includes a program for a method for quantitative analysis of external water based on a three-dimensional fluorescence peak picking method. When the program for quantitative analysis of external water based on a three-dimensional fluorescence peak picking method is executed by a processor, the steps of the method for quantitative analysis of external water based on a three-dimensional fluorescence peak picking method as described in any one of the above items are implemented.

[0052] As can be seen from the above, the embodiment of the present application provides a method, system and medium for quantitative analysis of external water based on the three-dimensional fluorescence peak picking method, which obtains the problem pipe section, analyzes the distribution information of the problem pipe section, divides the problem pipe section into blocks based on the distribution information of the problem pipe section, and obtains multiple flow calculation blocks; collects upstream sewage, external water and mixed sewage samples of the pipeline in each flow calculation block respectively, and scans the upstream sewage, external water and mixed sewage samples based on the wavelength range set by the three-dimensional fluorescence spectrometer to obtain a three-dimensional fluorescence spectrum; pre-processes the three-dimensional fluorescence spectrum, generates the fluorescence intensity of the upstream sewage, external water and mixed sewage samples based on the pre-processed three-dimensional fluorescence spectrum, and screens out the characteristic peak area based on the fluorescence intensity; based on the sewage and external water ratio simulation mixing experiment, establishes a standard curve of sewage volume ratio and characteristic peak fluorescence intensity of mixed sewage sample, and verifies and analyzes based on the Lambert-Beer law to obtain the upstream sewage ratio result; calculates the upstream sewage flow, external water flow and mixed sewage sample flow based on the upstream sewage ratio result; the present application can effectively solve the flow measurement problem in complex situations in the actual scenario of pipe network operation and maintenance through three-dimensional fluorescence spectroscopy to realize quantitative analysis of external water in sewage pipes. BRIEF DESCRIPTION OF THE DRAWINGS

[0053] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the following is a brief introduction to the drawings required for use in the embodiments of the present application. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other relevant drawings can be obtained based on these drawings without creative work.

[0054] Figure 1 Flow chart of the external water quantitative analysis method based on the three-dimensional fluorescence peak picking method provided in the embodiment of the present application;

[0055] Figure 2 A flow chart of a flow calculation block division method for the external water quantitative analysis method based on the three-dimensional fluorescence peak picking method provided in an embodiment of the present application;

[0056] Figure 3 This is a flow chart of the three-dimensional fluorescence spectrum acquisition method for the external water quantitative analysis method based on the three-dimensional fluorescence peak picking method provided in the embodiment of the present application. DETAILED DESCRIPTION

[0057] The technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all of the embodiments. The components of the embodiments of the present application generally described and shown in the drawings here can be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the present application provided in the drawings is not intended to limit the scope of the application for protection, but merely represents the selected embodiments of the present application. Based on the embodiments of the present application, all other embodiments obtained by those skilled in the art without making creative work fall within the scope of protection of the present application.

[0058] It should be noted that similar reference numerals and letters represent similar items in the following drawings. Therefore, once an item is defined in one drawing, it does not need to be further defined or explained in subsequent drawings. At the same time, in the description of this application, the terms "first", "second", etc. are only used to distinguish the description and should not be understood as indicating or implying relative importance.

[0059] Please refer to Figure 1 , Figure 1 This is a flow chart of a method for quantitatively analyzing external water based on a three-dimensional fluorescence peak picking method in some embodiments of the present application. The method for quantitatively analyzing external water based on a three-dimensional fluorescence peak picking method is used in a terminal device and includes the following steps:

[0060] S101, obtaining a problem pipe section, analyzing distribution information of the problem pipe section, and dividing the problem pipe section into blocks based on the distribution information to obtain multiple flow calculation blocks;

[0061] S102, collecting upstream sewage, external water, and mixed sewage samples from the pipeline in each flow calculation block, scanning the upstream sewage, external water, and mixed sewage samples based on the wavelength range set by the three-dimensional fluorescence spectrometer to obtain a three-dimensional fluorescence spectrum;

[0062] S103, preprocessing the three-dimensional fluorescence spectrum, generating fluorescence intensities of upstream sewage, external water, and mixed sewage samples based on the preprocessed three-dimensional fluorescence spectrum, and screening characteristic peak regions based on the fluorescence intensities;

[0063] S104: Based on a simulated mixing experiment of sewage and external water ratio, a standard curve of sewage volume ratio and fluorescence intensity of characteristic peaks of mixed sewage samples was established. The upstream sewage ratio was obtained by verification and analysis based on the Lambert-Beer law.

[0064] S105, calculating the upstream sewage flow, external water flow and mixed sewage sample flow based on the upstream sewage proportion result.

[0065] It should be noted that by analyzing the upstream sewage, external water and mixed sewage samples in different blocks, a three-dimensional fluorescence spectrum is obtained. The upstream sewage proportion results are verified and analyzed according to the Lambert-Beer law, so as to accurately analyze the upstream sewage flow, external water flow and mixed sewage sample flow, and realize the quantitative analysis of external water.

[0066] Please refer to Figure 2 , Figure 2 This is a flow chart of a flow calculation block division method for a method of quantitative external water analysis based on a three-dimensional fluorescence peak picking method in some embodiments of the present application. According to an embodiment of the present invention, a problem pipe section is obtained, its distribution information is analyzed, and the problem pipe section is divided into blocks based on the distribution information to obtain multiple flow calculation blocks, specifically including:

[0067] S201, checking abnormal information of pipelines in the pipeline network to obtain problematic pipeline sections;

[0068] S202, analyzing the location and direction of the problem pipe section based on the pipe network distribution map;

[0069] S203, setting the area of ​​the segmented region, and dividing the segmented region into blocks based on the location and direction of the problem pipe section to obtain a segmentation result;

[0070] S204: Determine whether the same problematic pipe section is divided into different blocks based on the division result;

[0071] S205: If the pipe section is divided into different blocks, the same problematic pipe section is divided into the same block. If the pipe section is divided into the same block, multiple flow calculation blocks are obtained.

[0072] It should be noted that the location and direction of the problem pipe section can be accurately analyzed through the pipeline network distribution map, so that the problem pipe section can be divided into different blocks to improve the analysis accuracy.

[0073] Please refer to Figure 3 , Figure 3 This is a flow chart of a method for acquiring a three-dimensional fluorescence spectrum for a quantitative analysis method of external water based on a three-dimensional fluorescence peak picking method in some embodiments of the present application. According to an embodiment of the present invention, upstream sewage, external water, and mixed sewage samples are collected from each pipeline within a flow calculation block. These samples are scanned using a three-dimensional fluorescence spectrometer within a set wavelength range to obtain a three-dimensional fluorescence spectrum, specifically including:

[0074] S301, setting multiple sampling points on the upstream and downstream of the pipeline and the external water pipeline, and obtaining the upstream sewage, external water and mixed sewage sampling values ​​at each sampling point;

[0075] S302, performing mean processing on the upstream sewage, external water and mixed sewage sampling values ​​at different sampling points to obtain a sample mean;

[0076] S303, obtaining upstream sewage, external water and mixed sewage samples based on the sample mean value;

[0077] S304, obtaining initial parameters based on the three-dimensional fluorescence spectrometer, calibrating the initial parameters using ultrapure water or a standard fluorescent substance solution to obtain calibrated parameters, and setting the excitation wavelength range and emission wavelength range based on the calibrated parameters;

[0078] S305 , scanning upstream sewage, external water, and mixed sewage samples based on the excitation wavelength range and the emission wavelength range to obtain a three-dimensional fluorescence spectrum.

[0079] It should be noted that by calibrating the parameters of the three-dimensional fluorescence spectrometer, the analysis results are improved and the upstream sewage, external water and mixed sewage samples are scanned according to the three-dimensional fluorescence spectrometer to obtain an accurate three-dimensional fluorescence spectrum.

[0080] According to an embodiment of the present invention, upstream sewage, external water, and mixed sewage samples are scanned based on the excitation wavelength range and the emission wavelength range to obtain a three-dimensional fluorescence spectrum; specifically, the following steps are performed:

[0081] The 3D-scan mode is adopted, with an excitation wavelength range of 200-500nm, an emission wavelength range of 250-500nm, a scanning interval of 5nm, a voltage of 600-800V, a scanning speed of 10000-12000nm / min, a slit width of 3-5nm, and a response time of 0.1s-0.3s.

[0082] Specifically, the voltage is across the photomultiplier tube (PMT) in a three-dimensional fluorescence spectrometer. The PMT is the core component of the fluorescence detector, responsible for converting weak fluorescence photon signals into measurable electrical signals. When photons strike the PMT's photocathode, they excite photoelectrons. These photoelectrons are accelerated and collided with a series of dynodes charged with positive high voltage. Each collision excites more secondary electrons (electron multiplication effect).

[0083] The high voltage (600-800V) applied to the PMT determines the strength of this accelerating electric field, which directly controls the electron multiplication gain (amplification factor). The higher the voltage, the stronger the multiplication effect and the higher the PMT gain (sensitivity), allowing the instrument to detect weaker fluorescence signals.

[0084] Scan speed refers to the speed at which a monochromator changes wavelengths. Specifically, it refers to the rate at which the excitation or emission monochromator changes its transmission or reflection wavelength during a scan. The faster the speed, the shorter the time required to complete an excitation or emission scan (and thus obtain a spectrum or EEM spectrum).

[0085] Slit width refers to the physical opening of the entrance and exit slits of a monochromator (both the excitation and emission monochromators have their own slits), and is usually expressed in terms of its corresponding spectral bandwidth (SBW). Narrower slits reduce the bandwidth and increase the spectral resolution, allowing for better resolution of fluorescence peaks with closely spaced wavelengths.

[0086] Response time is the time constant it takes a detection circuit (usually an amplifier) ​​to respond to a change in the input signal and reach a stable output value. It is essentially the time constant of an electronic filter (usually a low-pass RC filter) in a signal processing circuit. A longer response time improves high-frequency noise suppression and results in a smoother output signal curve.

[0087] Optionally, the excitation range is 300nm, 400nm; the emission wavelength range is 300nm, 350nm, 400nm; the voltage is 650V, 700V, 750V; the scanning speed is 10500nm / min, 11000nm / min; the slit width is 3.5nm, 4nm, 4.5nm; and the response time is 0.15s, 0.2s, 0.25s.

[0088] According to an embodiment of the present invention, the three-dimensional fluorescence spectrum is preprocessed, and the fluorescence intensity of the upstream sewage, external water and mixed sewage samples is generated based on the preprocessed three-dimensional fluorescence spectrum. The characteristic peak area is screened based on the fluorescence intensity, specifically including:

[0089] Acquire three-dimensional fluorescence spectra and remove spectral noise data;

[0090] Baseline correction is performed on the three-dimensional fluorescence spectrum after noise removal based on polynomial fitting or discrete wavelet transform;

[0091] The three-dimensional fluorescence spectra after baseline correction were normalized to obtain the fluorescence intensity of upstream sewage, external water and mixed sewage samples;

[0092] Based on the fluorescence intensity, the fluorescence peak area that can significantly distinguish upstream sewage, external water and mixed sewage is screened out to obtain the characteristic peak area.

[0093] It should be noted that the characteristic peak area can be accurately analyzed by denoising, correcting and normalizing the three-dimensional fluorescence spectrum.

[0094] According to an embodiment of the present invention, based on a simulated mixing experiment of sewage and external water ratio, a standard curve of sewage volume ratio and characteristic peak fluorescence intensity of mixed sewage samples was established. Based on the Lambert-Beer law verification analysis, the upstream sewage ratio result was obtained, specifically including:

[0095] Different ratios of sewage to external water volumes were set to conduct proportional simulation mixing experiments, and the linear relationship between the upstream sewage volume ratio and the fluorescence intensity of the characteristic peak of the mixed sample was analyzed.

[0096] The comparison results were obtained based on the linear relationship between the volume ratio of upstream sewage and the fluorescence intensity of the characteristic peak of the mixed sample and the standard curve of the volume ratio of sewage and the fluorescence intensity of the characteristic peak of the mixed sewage sample.

[0097] Based on the analysis and comparison results of Lambert-Beer law, the proportion of upstream sewage was obtained.

[0098] It should be noted that, according to the actual measurable flow conditions, one of the upstream sewage flow vx, external water flow vy, and downstream sewage flow v on a sunny day is measured.

[0099] According to the Lambert-Beer law of fluorescence, FDOM concentration needs to be at a low level to show a linear relationship with fluorescence intensity. Measuring FDOM concentration is relatively cumbersome. Based on existing experimental data, the linear fit results of the mixing experiment after diluting the sample to COD < 50 mg / L are better. Therefore, COD = 50 mg / L is used as the concentration limit for the effectiveness of the Lambert-Beer law. That is, the FDOM concentration and fluorescence intensity of the water sample within this COD concentration range meet the Lambert-Beer law. This is an empirical value, so in order to rule out the possibility that the Lambert-Beer law does not apply to this concentration range in individual cases, it is necessary to add a verification step to each mixing simulation experiment. If the verification does not meet the Lambert-Beer law, it is necessary to reset the applicable COD concentration range and sample dilution factor.

[0100] Sewage-external water ratio mixing simulation experiment: The collected upstream sewage, external water and mixed water samples are diluted to a COD concentration of <50 mg / L according to their COD test results. The dilution ratio is recorded as n. Subsequent simulation experiments are all based on the sample dilution of more than n times. The characteristic peak fluorescence intensities hx, hy, and h after dilution are measured and recorded. According to the upstream sewage volume ratio of 0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, and 0.9 (this is only an example and not the content of the claim application. The mixing ratio distribution can also be changed according to the actual situation, but the mixing ratio distribution should cover at least 80% of the sewage ratio, such as from 0.1 to 0.9 and at least increase by 0.05), respectively, mixed with external water samples, and the characteristic peak fluorescence intensity hi of the mixed sample is measured using a three-dimensional fluorescence instrument. A linear regression analysis is performed on the sewage volume ratio xi-the characteristic peak fluorescence intensity hi of the mixed sample to establish a sewage volume ratio-mixed sample characteristic peak fluorescence intensity standard curve h=ax+b(R 2 Need to be greater than 0.99, R 2 ( represents the coefficient of determination of the standard curve, which is common knowledge to those skilled in the art.) Verification Steps: To verify that the experimental FDOM concentration range conforms to the Beer-Lambert law, after establishing the standard curve, substitute the wastewater concentrations x = 0 and x = 1, respectively, into the standard curve equation h = ax + b to obtain the theoretical upstream wastewater fluorescence intensity h0 = a + b and the external water fluorescence intensity h1 = b. Compare h0 and h1 with the actual fluorescence intensities hx and hy, and calculate the relative error.

[0101] Relative error of fluorescence intensity of upstream sewage Δx=|hx-h0| / hx

[0102] The relative error of the fluorescence intensity of external water is Δy = |hy-h1| / hy;

[0103] Specifically, hx: the characteristic peak fluorescence intensity of the upstream sewage sample after dilution n times, which is the detection value;

[0104] h0: When the sewage ratio x = 1, the theoretical upstream sewage fluorescence intensity is calculated by substituting the standard curve formula h = ax + b, which is the calculated value;

[0105] hy: The characteristic peak fluorescence intensity of the external water sample after dilution n times, which is the detection value;

[0106] h1: When the sewage proportion x = 0, the theoretical upstream sewage fluorescence intensity is calculated by substituting the standard curve formula h = ax + b, which is the calculated value, where a and b are constants.

[0107] According to existing data and practical experience, if Δx and Δy are both less than 0.04, it can be considered that the FDOM concentration of the water sample in the experiment conforms to the Lambert-Beer law and the experimental results are valid; otherwise, it is considered that there is a concentration range that does not conform to the Lambert-Beer law, and the dilution factor n needs to be reset.

[0108] If the experimental results are verified to be valid, the fluorescence intensity h of the actual mixed water sample is substituted into the calculation to obtain the proportion x of upstream sewage in the actual mixed water sample.

[0109] The calculated upstream sewage proportion x and flow measurement results are used to calculate the upstream sewage flow vx, external water flow vy, and mixed flow v.

[0110] Measure vx and calculate vy and v: vy = vx(1-x) / xv = vx / x

[0111] Measure vy and calculate vx and v: vy = vxx / (1-x)v = vx / (1-x)

[0112] Measure v, calculate vx and vy: vx = vx v = v(1-x)

[0113] Based on the actual project situation, a section of a sewage pipe network in a certain city was selected. This section was not connected to other pipelines and had damage that led to groundwater intrusion. The flow pattern in the section was good, with a velocity greater than 0.6 m / s. Both upstream and downstream observation wells were drop wells, making it suitable for flow measurement. The volumetric flow measurement results were selected as the experimental standard value. That is, a container was used to hold the water flowing out of the pipe section for a certain period of time t (unit: s). The total water volume was V (unit: L), and the flow rate v = V / t (L / s) could be calculated. This method was used to measure the upstream and downstream water volumes vup and vdown. The two were subtracted to obtain the external water intrusion volume vout. Then, using the three-dimensional fluorescence external water quantitative analysis method, vup, vdown, and vout were used as the baseline values, respectively, to calculate the theoretical flow rate vx, the external water flow vy, the mixed flow v, and the relative error. The results show that the error between the calculation results of the three-dimensional fluorescence external water quantitative analysis method and the actual measurement results of the volume method does not exceed 4%. It can be used in situations where the flow measurement accuracy of on-site process drainage pipelines is required to be above 96%. It meets the flow measurement accuracy requirements of most pipeline networks and is a practical flow measurement method.

[0114] When conducting sewage-external water ratio simulation mixing experiments, the mixing ratio distribution should cover at least 80% of the sewage ratio (such as from 0.1 to 0.9) and increase by at least 0.05.

[0115] Furthermore, the upstream sewage proportion x and the flow measurement result of S103 are calculated to calculate the upstream sewage flow vx, the external water flow vy, and the mixed flow v.

[0116] The calculated upstream sewage ratio is x = 0.216. Combined with the flow measurement result of S103, vx = 432.5m 3 / d, calculate vy and v:

[0117] vy=vx(1-x) / x=432.5×(1-0.216) / 0.216=1569.8m 3 / d

[0118] v=vx / x=432.5 / 0.216=2002.3m 3 / d

[0119] After the backflow point of the river was blocked, the water flow of the sewage treatment plant was monitored for a week. Compared with the average water flow before the blockage, the water flow was reduced by about 1520m 3 / d, with an error of about 3.3% from the calculated result, which has good accuracy.

[0120] In a second aspect, an embodiment of the present application provides a system for quantitative analysis of external water based on a three-dimensional fluorescence peak picking method, the system comprising: a memory and a processor, the memory comprising a program for a method for quantitative analysis of external water based on a three-dimensional fluorescence peak picking method, and when the program for quantitative analysis of external water based on a three-dimensional fluorescence peak picking method is executed by the processor, the following steps are implemented:

[0121] Obtain the problematic pipe section, analyze its distribution information, and divide it into blocks based on the distribution information to obtain multiple flow calculation blocks;

[0122] Collect upstream sewage, external water, and mixed sewage samples from the pipeline in each flow calculation block respectively. Scan the upstream sewage, external water, and mixed sewage samples based on the wavelength range set by the three-dimensional fluorescence spectrometer to obtain a three-dimensional fluorescence spectrum.

[0123] Preprocessing the three-dimensional fluorescence spectrum, generating the fluorescence intensity of upstream sewage, external water and mixed sewage samples based on the preprocessed three-dimensional fluorescence spectrum, and screening the characteristic peak area based on the fluorescence intensity;

[0124] Based on the simulated mixing experiment of sewage and external water ratio, a standard curve of sewage volume ratio and characteristic peak fluorescence intensity of mixed sewage samples was established. The upstream sewage ratio result was obtained based on the Lambert-Beer law verification analysis.

[0125] Based on the upstream sewage proportion results, the upstream sewage flow, external water flow and mixed sewage sample flow are calculated.

[0126] It should be noted that by analyzing the upstream sewage, external water and mixed sewage samples in different blocks, a three-dimensional fluorescence spectrum is obtained. The upstream sewage proportion results are verified and analyzed according to the Lambert-Beer law, so as to accurately analyze the upstream sewage flow, external water flow and mixed sewage sample flow, and realize the quantitative analysis of external water.

[0127] According to an embodiment of the present invention, a problem pipe section is obtained, distribution information of the problem pipe section is analyzed, and the problem pipe section is divided into blocks based on the distribution information to obtain multiple flow calculation blocks, specifically including:

[0128] Check abnormal information of pipelines in the pipeline network and find the problematic pipe sections;

[0129] Analyze the location and direction of problem pipe sections based on the pipe network distribution map;

[0130] Set the segmentation area, divide the area into blocks based on the location and direction of the problem pipe section, and obtain the segmentation result;

[0131] Determine whether the same problematic pipe section is divided into different blocks based on the division results;

[0132] If it is divided into different blocks, the same problem pipe section will be divided into the same block. If it is divided into the same block, multiple flow calculation blocks will be obtained.

[0133] According to an embodiment of the present invention, upstream sewage, external water, and mixed sewage samples are collected from the pipeline in each flow calculation block, and the upstream sewage, external water, and mixed sewage samples are scanned based on the wavelength range set by the three-dimensional fluorescence spectrometer to obtain a three-dimensional fluorescence spectrum, specifically including:

[0134] Set up multiple sampling points upstream and downstream of the pipeline and on the external water pipeline to obtain the upstream sewage, external water and mixed sewage sampling values ​​at each sampling point;

[0135] The upstream sewage, external water and mixed sewage sampling values ​​at different sampling points were averaged to obtain the sample mean;

[0136] Based on the sample mean values, upstream sewage, external water and mixed sewage samples were obtained;

[0137] Obtain initial parameters based on a three-dimensional fluorescence spectrometer, calibrate the initial parameters using ultrapure water or a standard fluorescent substance solution to obtain calibrated parameters, and set the excitation wavelength range and emission wavelength range based on the calibrated parameters;

[0138] Based on the excitation wavelength range and emission wavelength range, upstream sewage, external water and mixed sewage samples were scanned to obtain a three-dimensional fluorescence spectrum.

[0139] It should be noted that by calibrating the parameters of the three-dimensional fluorescence spectrometer, the analysis results are improved and the upstream sewage, external water and mixed sewage samples are scanned according to the three-dimensional fluorescence spectrometer to obtain an accurate three-dimensional fluorescence spectrum.

[0140] According to an embodiment of the present invention, upstream sewage, external water, and mixed sewage samples are scanned based on the excitation wavelength range and the emission wavelength range to obtain a three-dimensional fluorescence spectrum; specifically, the following steps are performed:

[0141] The 3D-scan mode is adopted, with an excitation wavelength range of 200-500nm, an emission wavelength range of 250-500nm, a scanning interval of 5nm, a voltage of 600-800V, a scanning speed of 10000-12000nm / min, a slit width of 3-5nm, and a response time of 0.1s-0.3s.

[0142] Optionally, the excitation range is 300nm, 400nm; the emission wavelength range is 300nm, 350nm, 400nm; the voltage is 650V, 700V, 750V; the scanning speed is 10500nm / min, 11000nm / min; the slit width is 3.5nm, 4nm, 4.5nm; and the response time is 0.15s, 0.2s, 0.25s.

[0143] According to an embodiment of the present invention, the three-dimensional fluorescence spectrum is preprocessed, and the fluorescence intensity of the upstream sewage, external water and mixed sewage samples is generated based on the preprocessed three-dimensional fluorescence spectrum. The characteristic peak area is screened based on the fluorescence intensity, specifically including:

[0144] Acquire three-dimensional fluorescence spectra and remove spectral noise data;

[0145] Baseline correction is performed on the three-dimensional fluorescence spectrum after noise removal based on polynomial fitting or discrete wavelet transform;

[0146] The three-dimensional fluorescence spectra after baseline correction were normalized to obtain the fluorescence intensity of upstream sewage, external water and mixed sewage samples;

[0147] Based on the fluorescence intensity, the fluorescence peak area that can significantly distinguish upstream sewage, external water and mixed sewage is screened out to obtain the characteristic peak area.

[0148] It should be noted that the characteristic peak area can be accurately analyzed by denoising, correcting and normalizing the three-dimensional fluorescence spectrum.

[0149] According to an embodiment of the present invention, based on a simulated mixing experiment of sewage and external water ratio, a standard curve of sewage volume ratio and characteristic peak fluorescence intensity of mixed sewage samples was established. Based on the Lambert-Beer law verification analysis, the upstream sewage ratio result was obtained, specifically including:

[0150] Different ratios of sewage to external water volumes were set to conduct proportional simulation mixing experiments, and the linear relationship between the upstream sewage volume ratio and the fluorescence intensity of the characteristic peak of the mixed sample was analyzed.

[0151] The comparison results were obtained based on the linear relationship between the volume ratio of upstream sewage and the fluorescence intensity of the characteristic peak of the mixed sample and the standard curve of the volume ratio of sewage and the fluorescence intensity of the characteristic peak of the mixed sewage sample.

[0152] Based on the analysis and comparison results of Lambert-Beer law, the proportion of upstream sewage was obtained.

[0153] It should be noted that, according to the actual measurable flow conditions, one of the upstream sewage flow vx, external water flow vy, and downstream sewage flow v on a sunny day is measured.

[0154] According to the Lambert-Beer law of fluorescence, FDOM concentration needs to be at a low level to show a linear relationship with fluorescence intensity. Measuring FDOM concentration is relatively cumbersome. Based on existing experimental data, the linear fit results of the mixing experiment after diluting the sample to COD < 50 mg / L are better. Therefore, COD = 50 mg / L is used as the concentration limit for the effectiveness of the Lambert-Beer law. That is, the FDOM concentration and fluorescence intensity of the water sample within this COD concentration range meet the Lambert-Beer law. This is an empirical value, so in order to rule out the possibility that the Lambert-Beer law does not apply to this concentration range in individual cases, it is necessary to add a verification step to each mixing simulation experiment. If the verification does not meet the Lambert-Beer law, it is necessary to reset the applicable COD concentration range and sample dilution factor.

[0155] Sewage-external water ratio mixing simulation experiment: The collected upstream sewage, external water and mixed water samples are diluted to a COD concentration of <50 mg / L according to their COD test results. The dilution ratio is recorded as n. Subsequent simulation experiments are all based on the sample dilution of more than n times. The characteristic peak fluorescence intensities hx, hy, and h after dilution are measured and recorded. According to the upstream sewage volume ratio of 0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, and 0.9 (this is only an example and not the content of the claim application. The mixing ratio distribution can also be changed according to the actual situation, but the mixing ratio distribution should cover at least 80% of the sewage ratio, such as from 0.1 to 0.9 and at least increase by 0.05), respectively, mixed with external water samples, and the characteristic peak fluorescence intensity hi of the mixed sample is measured using a three-dimensional fluorescence instrument. A linear regression analysis is performed on the sewage volume ratio xi-the characteristic peak fluorescence intensity hi of the mixed sample to establish a sewage volume ratio-mixed sample characteristic peak fluorescence intensity standard curve h=ax+b(R 2Verification Steps: To verify that the experimental FDOM concentration range conforms to the Beer-Lambert law, after establishing the standard curve, substitute the wastewater concentrations x = 0 and x = 1, respectively, into the standard curve equation h = ax + b to obtain the theoretical upstream wastewater fluorescence intensity h0 = a + b and the external water fluorescence intensity h1 = b. Compare h0 and h1 with the actual fluorescence intensities hx and hy, and calculate the relative error.

[0156] Relative error of fluorescence intensity of upstream sewage Δx=|hx-h0| / hx

[0157] Relative error of fluorescence intensity of external water Δy=|hy-h1| / hy

[0158] According to existing data and practical experience, if Δx and Δy are both less than 0.04, it can be considered that the FDOM concentration of the water sample in the experiment conforms to the Lambert-Beer law and the experimental results are valid; otherwise, it is considered that there is a concentration range that does not conform to the Lambert-Beer law, and the dilution factor n needs to be reset.

[0159] If the experimental results are verified to be valid, the fluorescence intensity h of the actual mixed water sample is substituted into the calculation to obtain the proportion x of upstream sewage in the actual mixed water sample.

[0160] The calculated upstream sewage proportion x and flow measurement results are used to calculate the upstream sewage flow vx, external water flow vy, and mixed flow v.

[0161] Measure vx and calculate vy and v: vy = vx(1-x) / xv = vx / x

[0162] Measure vy and calculate vx and v: vy = vxx / (1-x)v = vx / (1-x)

[0163] Measure v, calculate vx and vy: vx = vx v = v(1-x)

[0164] Based on the actual project situation, a section of a sewage pipe network in a certain city was selected. This section was not connected to other pipelines and had damage that led to groundwater intrusion. The flow pattern in the section was good, with a velocity greater than 0.6 m / s. Both upstream and downstream observation wells were drop wells, making it suitable for flow measurement. The volumetric flow measurement results were selected as the experimental standard value. That is, a container was used to hold the water flowing out of the pipe section for a certain period of time t (unit: s). The total water volume was V (unit: L), and the flow rate v = V / t (L / s) could be calculated. This method was used to measure the upstream and downstream water volumes vup and vdown. The two were subtracted to obtain the external water intrusion volume vout. Then, using the three-dimensional fluorescence external water quantitative analysis method, vup, vdown, and vout were used as the baseline values, respectively, to calculate the theoretical flow rate vx, the external water flow vy, the mixed flow v, and the relative error. The results show that the error between the calculation results of the three-dimensional fluorescence external water quantitative analysis method and the actual measurement results of the volume method does not exceed 4%. It can be used in situations where the flow measurement accuracy of on-site process drainage pipelines is required to be above 96%. It meets the flow measurement accuracy requirements of most pipeline networks and is a practical flow measurement method.

[0165] When conducting sewage-external water ratio simulation mixing experiments, the mixing ratio distribution should cover at least 80% of the sewage ratio (such as from 0.1 to 0.9) and increase by at least 0.05.

[0166] Furthermore, the upstream sewage proportion x and the flow measurement result of S103 are calculated to calculate the upstream sewage flow vx, the external water flow vy, and the mixed flow v.

[0167] The calculated upstream sewage ratio is x = 0.216. Combined with the flow measurement result of S103, vx = 432.5m 3 / d, calculate vy and v:

[0168] vy=vx(1-x) / x=432.5×(1-0.216) / 0.216=1569.8m 3 / d

[0169] v=vx / x=432.5 / 0.216=2002.3m 3 / d

[0170] After the backflow point of the river was blocked, the water flow of the sewage treatment plant was monitored for a week. Compared with the average water flow before the blockage, the water flow was reduced by about 1520m 3 / d, with an error of about 3.3% from the calculated result, which has good accuracy.

[0171] The third aspect of the present invention provides a computer-readable storage medium, which includes a program for the quantitative analysis method of external water based on the three-dimensional fluorescence peak picking method. When the program for the quantitative analysis method of external water based on the three-dimensional fluorescence peak picking method is executed by a processor, the steps of the quantitative analysis method of external water based on the three-dimensional fluorescence peak picking method as described above are implemented.

[0172] The present invention discloses a method, system and medium for quantitative analysis of external water based on a three-dimensional fluorescence peak picking method. The method comprises the following steps: obtaining a problem pipe section, analyzing the distribution information of the problem pipe section, dividing the problem pipe section into blocks based on the distribution information of the problem pipe section, and obtaining a plurality of flow calculation blocks; collecting upstream sewage, external water and mixed sewage samples of the pipeline in each flow calculation block respectively, scanning the upstream sewage, external water and mixed sewage samples based on a wavelength range set by a three-dimensional fluorescence spectrometer, and obtaining a three-dimensional fluorescence spectrum; preprocessing the three-dimensional fluorescence spectrum, generating the fluorescence intensity of the upstream sewage, external water and mixed sewage samples based on the preprocessed three-dimensional fluorescence spectrum, and screening out a characteristic peak area based on the fluorescence intensity; establishing a standard curve of sewage volume proportion and characteristic peak fluorescence intensity of mixed sewage samples based on a simulated mixing experiment of sewage and external water ratio, and obtaining an upstream sewage proportion result through verification and analysis based on the Lambert-Beer law; and calculating the upstream sewage flow, external water flow and mixed sewage sample flow based on the upstream sewage proportion result. The present application can effectively solve the flow measurement problem under complex circumstances in actual scenarios of pipe network operation and maintenance through three-dimensional fluorescence spectroscopy to realize quantitative analysis of external water in sewage pipes.

[0173] In the several embodiments provided in this application, it should be understood that the disclosed devices and methods can be implemented in other ways. The device embodiments described above are merely schematic. For example, the division of units is merely a logical function division. In actual implementation, there may be other division methods, such as: multiple units or components can be combined, or can be integrated into another system, or some features can be ignored or not executed. In addition, the coupling, direct coupling, or communication connection between the components shown or discussed can be through some interfaces, and the indirect coupling or communication connection of devices or units can be electrical, mechanical or other forms.

[0174] The units described above as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units; they may be located in one place or distributed across multiple network units; some or all of the units may be selected according to actual needs to achieve the purpose of the scheme of this embodiment.

[0175] In addition, all functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may be separately used as a unit, or two or more units may be integrated into one unit; the above-mentioned integrated units may be implemented in the form of hardware or in the form of hardware plus software functional units.

[0176] Those skilled in the art will appreciate that all or part of the steps of the above-mentioned method embodiments may be implemented by hardware associated with program instructions, and the aforementioned program may be stored in a readable storage medium. When the program is executed, the program executes the steps of the above-mentioned method embodiments. The aforementioned storage medium includes various media that can store program codes, such as mobile storage devices, read-only memories (ROMs), random access memories (RAMs), magnetic disks, or optical disks.

[0177] Alternatively, if the above-mentioned integrated unit of the present invention is implemented in the form of a software functional module and sold or used as an independent product, it can also be stored in a readable storage medium. Based on this understanding, the technical solution of the embodiment of the present invention, or the part that contributes to the existing technology, can be embodied in the form of a software product. The software product is stored in a storage medium and includes a number of instructions for enabling a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the methods described in each embodiment of the present invention. The aforementioned storage medium includes: various media that can store program code, such as mobile storage devices, ROM, RAM, magnetic disks or optical disks.

Claims

1. A method for quantitative analysis of external water based on three-dimensional fluorescence peak picking method, characterized in that: include: Obtain the problematic pipe section, analyze its distribution information, and divide it into blocks based on the distribution information to obtain multiple flow calculation blocks; Collect upstream sewage, external water, and mixed sewage samples from the pipeline in each flow calculation block respectively. Scan the upstream sewage, external water, and mixed sewage samples based on the wavelength range set by the three-dimensional fluorescence spectrometer to obtain a three-dimensional fluorescence spectrum. Preprocessing the three-dimensional fluorescence spectrum, generating the fluorescence intensity of upstream sewage, external water and mixed sewage samples based on the preprocessed three-dimensional fluorescence spectrum, and screening the characteristic peak area based on the fluorescence intensity; Based on the simulated mixing experiment of sewage and external water ratio, a standard curve of sewage volume ratio and characteristic peak fluorescence intensity of mixed sewage samples was established. The upstream sewage ratio result was obtained based on the Lambert-Beer law verification analysis. Based on the upstream sewage proportion results, the upstream sewage flow, external water flow and mixed sewage sample flow are calculated.

2. The external water quantitative analysis method based on the three-dimensional fluorescence peak picking method according to claim 1, characterized in that: Obtain the problem pipe section, analyze its distribution information, and divide it into blocks based on the distribution information to obtain multiple flow calculation blocks, including: Check abnormal information of pipelines in the pipeline network and find the problematic pipe sections; Analyze the location and direction of problem pipe sections based on the pipe network distribution map; Set the segmentation area, divide the area into blocks based on the location and direction of the problem pipe section, and obtain the segmentation result; Determine whether the same problematic pipe section is divided into different blocks based on the division results; If it is divided into different blocks, the same problem pipe section will be divided into the same block. If it is divided into the same block, multiple flow calculation blocks will be obtained.

3. The external water quantitative analysis method based on the three-dimensional fluorescence peak picking method according to claim 2, characterized in that: Collect upstream sewage, external water and mixed sewage samples from the pipeline in each flow calculation block respectively. Scan the upstream sewage, external water and mixed sewage samples based on the wavelength range set by the three-dimensional fluorescence spectrometer to obtain a three-dimensional fluorescence spectrum, specifically including: Set up multiple sampling points upstream and downstream of the pipeline and on the external water pipeline to obtain the upstream sewage, external water and mixed sewage sampling values ​​at each sampling point; The upstream sewage, external water and mixed sewage sampling values ​​at different sampling points were averaged to obtain the sample mean; Based on the sample mean values, upstream sewage, external water and mixed sewage samples were obtained; Obtain initial parameters based on a three-dimensional fluorescence spectrometer, calibrate the initial parameters using ultrapure water or a standard fluorescent substance solution to obtain calibrated parameters, and set the excitation wavelength range and emission wavelength range based on the calibrated parameters; Based on the excitation wavelength range and emission wavelength range, upstream sewage, external water and mixed sewage samples were scanned to obtain a three-dimensional fluorescence spectrum.

4. The method for quantitative analysis of external water based on three-dimensional fluorescence peak picking method according to claim 3, characterized in that: Scan upstream sewage, external water, and mixed sewage samples based on the excitation wavelength range and emission wavelength range to obtain a three-dimensional fluorescence spectrum; specifically, The 3D-scan mode is adopted, with an excitation wavelength range of 200-500nm, an emission wavelength range of 250-500nm, a scanning interval of 5nm, a voltage of 600-800V, a scanning speed of 10000-12000nm / min, a slit width of 3-5nm, and a response time of 0.1s-0.3s.

5. The external water quantitative analysis method based on the three-dimensional fluorescence peak picking method according to claim 4, characterized in that: The three-dimensional fluorescence spectrum is preprocessed, and the fluorescence intensity of upstream sewage, external water and mixed sewage samples is generated based on the preprocessed three-dimensional fluorescence spectrum. The characteristic peak area is screened based on the fluorescence intensity, specifically including: Acquire three-dimensional fluorescence spectra and remove spectral noise data; Baseline correction is performed on the three-dimensional fluorescence spectrum after noise removal based on polynomial fitting or discrete wavelet transform; The three-dimensional fluorescence spectra after baseline correction were normalized to obtain the fluorescence intensity of upstream sewage, external water and mixed sewage samples; Based on the fluorescence intensity, the fluorescence peak area that can significantly distinguish upstream sewage, external water and mixed sewage is screened out to obtain the characteristic peak area.

6. The method for quantitative analysis of external water based on three-dimensional fluorescence peak picking method according to claim 5, characterized in that: Based on the simulated mixing experiment of sewage and external water ratio, a standard curve of sewage volume ratio and characteristic peak fluorescence intensity of mixed sewage samples was established. Based on the Lambert-Beer law, the upstream sewage ratio results were obtained, including: Different ratios of sewage to external water volumes were set to conduct proportional simulation mixing experiments, and the linear relationship between the upstream sewage volume ratio and the fluorescence intensity of the characteristic peak of the mixed sample was analyzed. The comparison results were obtained based on the linear relationship between the volume ratio of upstream sewage and the fluorescence intensity of the characteristic peak of the mixed sample and the standard curve of the volume ratio of sewage and the fluorescence intensity of the characteristic peak of the mixed sewage sample. Based on the analysis and comparison results of Lambert-Beer law, the proportion of upstream sewage was obtained.

7. A system for quantitative analysis of external water based on three-dimensional fluorescence peak picking method, characterized in that: The system includes: a memory and a processor, wherein the memory includes a program for a method for quantitatively analyzing external water based on a three-dimensional fluorescence peak picking method, and when the program for quantitatively analyzing external water based on a three-dimensional fluorescence peak picking method is executed by the processor, the following steps are implemented: Obtain the problematic pipe section, analyze its distribution information, and divide it into blocks based on the distribution information to obtain multiple flow calculation blocks; Collect upstream sewage, external water, and mixed sewage samples from the pipeline in each flow calculation block respectively. Scan the upstream sewage, external water, and mixed sewage samples based on the wavelength range set by the three-dimensional fluorescence spectrometer to obtain a three-dimensional fluorescence spectrum. Preprocessing the three-dimensional fluorescence spectrum, generating the fluorescence intensity of upstream sewage, external water and mixed sewage samples based on the preprocessed three-dimensional fluorescence spectrum, and screening the characteristic peak area based on the fluorescence intensity; Based on the simulated mixing experiment of sewage and external water ratio, a standard curve of sewage volume ratio and characteristic peak fluorescence intensity of mixed sewage samples was established. The upstream sewage ratio result was obtained based on the Lambert-Beer law verification analysis. Based on the upstream sewage proportion results, the upstream sewage flow, external water flow and mixed sewage sample flow are calculated.

8. The external water quantitative analysis system based on the three-dimensional fluorescence peak picking method according to claim 7, characterized in that: Obtain the problem pipe section, analyze its distribution information, and divide it into blocks based on the distribution information to obtain multiple flow calculation blocks, including: Check abnormal information of pipelines in the pipeline network and find the problematic pipe sections; Analyze the location and direction of problem pipe sections based on the pipe network distribution map; Set the segmentation area, divide the area into blocks based on the location and direction of the problem pipe section, and obtain the segmentation result; Determine whether the same problematic pipe section is divided into different blocks based on the division results; If it is divided into different blocks, the same problem pipe section will be divided into the same block. If it is divided into the same block, multiple flow calculation blocks will be obtained.

9. The external water quantitative analysis system based on the three-dimensional fluorescence peak picking method according to claim 8, characterized in that: Collect upstream sewage, external water and mixed sewage samples from the pipeline in each flow calculation block respectively. Scan the upstream sewage, external water and mixed sewage samples based on the wavelength range set by the three-dimensional fluorescence spectrometer to obtain a three-dimensional fluorescence spectrum, specifically including: Set up multiple sampling points upstream and downstream of the pipeline and on the external water pipeline to obtain the upstream sewage, external water and mixed sewage sampling values ​​at each sampling point; The upstream sewage, external water and mixed sewage sampling values ​​at different sampling points were averaged to obtain the sample mean; Based on the sample mean values, upstream sewage, external water and mixed sewage samples were obtained; Obtain initial parameters based on a three-dimensional fluorescence spectrometer, calibrate the initial parameters using ultrapure water or a standard fluorescent substance solution to obtain calibrated parameters, and set the excitation wavelength range and emission wavelength range based on the calibrated parameters; Based on the excitation wavelength range and emission wavelength range, upstream sewage, external water and mixed sewage samples were scanned to obtain a three-dimensional fluorescence spectrum.

10. A computer-readable storage medium, characterized in that The computer-readable storage medium includes a program for the method for quantitative analysis of external water based on the three-dimensional fluorescence peak picking method. When the program for quantitative analysis of external water based on the three-dimensional fluorescence peak picking method is executed by the processor, the steps of the method for quantitative analysis of external water based on the three-dimensional fluorescence peak picking method as described in any one of claims 1 to 6 are implemented.

Images