A processing method and device based on sewage drug detection data

By automatically processing and analyzing sewage drug detection data, identifying abnormal data and calculating the location of drug discharge sources, the problem of low efficiency and data deviation of traditional manual statistics is solved, and efficient and accurate drug traceability is achieved.

CN119044440BActive Publication Date: 2025-01-24YUNNAN UNIV
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202411555338.3
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-11-04
Publication Date
2025-01-24
Estimated Expiration
2044-11-04

AI Technical Summary

Technical Problem

Traditional manual statistics area sewage drug testing data is inefficient and has data deviations, which cannot meet the needs of drug control departments.

Method used

By obtaining the sampling data of the sampling points of each sewage in the target area and the historical data coupling, the abnormal data is determined and marked on the map to verify the pipe network segment, combined with the sewage velocity and drug concentration of the drug discharge source.

Benefits of technology

Improve data processing efficiency and accuracy, quickly analyze a large amount of data, accurately calculate the distance between the source of drug emissions and the sampling point, and provide accurate location information to the law enforcement department.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119044440B_ABST
    Figure CN119044440B_ABST
Patent Text Reader

Abstract

The present invention relates to the field of data processing technology, specifically to a processing method and device based on sewage drug detection data, the method comprising obtaining sampling data of each sewage sampling point in a target area, coupling each sampling data with the historical sampling data of its corresponding sampling point, obtaining abnormal data, and determining the drug content in the sewage as a first drug concentration; determining a pipe network segment to be checked; obtaining sewage sampling data in a previous pipe network segment connected to the pipe network segment to be checked, and determining the drug content in the sewage as a second drug concentration; obtaining sewage sampling data at any position upstream of the sampling point position corresponding to the abnormal data in the pipe network segment to be checked, and determining the drug content in the sewage as a third drug concentration; and determining the source of drug discharge according to the comparison results of the first drug concentration, the second drug concentration and the third drug concentration. The present invention solves the problems of low efficiency and easy data error in traditional manual statistical analysis of sewage drug detection data.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to a method and device for processing sewage drug detection data. Background Art

[0002] After people take drugs, the active ingredients and metabolites in the drugs will be discharged into the urban sewage pipes in the form of urine or feces. By detecting the concentrations of various drugs and metabolites in domestic sewage, it is possible to timely grasp the types and forms of drug abuse in the region.

[0003] With the proliferation of drugs in recent years, the traditional method of manually counting drug detection data in sewage in the area and tracing the source of drugs based on the analysis results of the detection data is inefficient on the one hand and has data bias on the other hand, which can no longer meet the needs of drug enforcement departments.

[0004] Therefore, the present invention provides a processing method and device based on sewage drug detection data to solve the above problems. Summary of the invention

[0005] In view of the above situation, in order to overcome the defects of the prior art, the present invention provides a processing method and equipment based on sewage drug detection data, which solves the problems of low efficiency and data deviation in the traditional manual statistics of sewage drug detection data in the area and tracing the source of drugs based on the analysis results of the detection data.

[0006] In order to achieve the above-mentioned purpose, the technical scheme adopted by the present invention is: a processing method based on sewage drug detection data, comprising: obtaining sampling data of each sewage sampling point in the target area, coupling each sampling data with the historical sampling data of the corresponding sampling point, obtaining abnormal data, determining the sampling point position corresponding to the abnormal data, and determining that the drug content in the sewage is a first drug concentration; obtaining a sewage pipe network map in the target area, and according to the sampling point position corresponding to the abnormal data, obtaining the pipe network segment where the sampling point corresponding to the abnormal data is located on the sewage pipe network map, and marking the pipe network segment as the pipe network segment to be checked; obtaining sewage sampling data in the previous pipe network segment connected to the pipe network segment to be checked, and determining that the drug content in the sewage is a second drug concentration; obtaining sewage sampling data at any position upstream of the sampling point position corresponding to the abnormal data in the pipe network segment to be checked, and determining that the drug content in the sewage is a third drug concentration; according to the first drug concentration, the second drug concentration, the The drug concentration and the third drug concentration are compared to determine the source of drug emission, including: if it is determined that the drug emission source is located in the pipe network section to be verified, then, the sewage sampling data at any position upstream of the sampling point position corresponding to the abnormal data in the pipe network section to be verified is obtained, and recorded as the verification sampling data, and the sampling point position where the verification sampling data is located is different from the sampling point position where the third drug concentration is located, and the drug content in the sewage is determined to be a fourth drug concentration, and the fourth drug concentration is greater than the first drug concentration, wherein the verification sampling data includes the longitude and latitude of the sampling position, the sewage flow rate, and the concentration of the drug precursor and the drug metabolite in the sewage; the location of the drug emission source is obtained according to the sampling data of the abnormal data sampling point and the verification sampling data, including: obtaining the longitude and latitude of the abnormal data sampling point and the longitude and latitude of the verification sampling data sampling point, and determining the distance between the abnormal data sampling point and the verification sampling data sampling point, wherein the verification sampling data sampling point is recorded as a Point, the abnormal data sampling point is recorded as b point, the specific expression is:

[0007] (1),

[0008] In expression (1), d ab express a point, b The distance between two points, lat a Indicated a The longitude of the point, lon a represents the latitude of point a, lat b express b The longitude of the point, lon b express b The latitude of the point, r represents the radius of the Earth;

[0009] According to the fourth drug concentration, the first drug concentration, the sewage flow rate and a and b The distance between the source of drug emission and the sampling point for verifying sampling data d s , its specific expression is:

[0010] (2),

[0011] In expression (2), C a Indicates the fourth drug concentration, C b Indicates the concentration of the first drug, d ab express a point, b The distance between two points;

[0012] Obtain the water flow direction angle of the sampling point for verifying the sampling data through the geographic information system θ , and substitute expression (1) into expression (2) to obtain the latitude and longitude of the drug emission source, the specific expression is:

[0013] (3),

[0014] (4),

[0015] In expression (3), lat s represents the longitude of the source of drug emission. In expression (4), lon s Indicates the latitude of the source of drug release.

[0016] A further improvement of the present application is that the sampling data of the abnormal data sampling point includes the longitude and latitude of the sampling point, the sewage flow rate and the concentration of the drug precursor and drug metabolites in the sewage.

[0017] A further improvement of the present application is that the source of drug emission is determined based on the comparison results of the first drug concentration, the second drug concentration and the third drug concentration, and also includes: if the second drug concentration is lower than the normal value of the drug concentration in the sewage in the target area, then the source of drug emission is determined to be located in the pipe network section to be checked; if the third drug concentration is lower than the normal value of the drug concentration in the sewage in the target area or lower than the first drug concentration, then the source of drug emission is determined to be located in the pipe network section to be checked; if the third drug concentration is greater than the first drug concentration and less than the second drug concentration, then the source of drug emission is determined to be located in the pipe network section to be checked.

[0018] A further improvement of the present application is that, according to the fourth drug concentration, the first drug concentration, the sewage flow rate and a and b The distance between the source of drug emission and the sampling point for verifying sampling data d s ,include:

[0019] Set the distance between the drug emission source and the sampling point to be d s ,but d s The expression is:

[0020] (5),

[0021] In expression (5), v Indicates the sewage flow rate, t It indicates the time it takes for drugs and drug metabolites to arrive at the sampling point for verification sampling data from the drug emission source. t It is calculated by the following expression (6):

[0022] (6),

[0023] d ab express a point, b The distance between two points, v Indicates the sewage flow rate, C a Indicates the fourth drug concentration, C b Indicates the first drug concentration;

[0024] Substituting expression (6) into expression (5) yields expression (2).

[0025] A further improvement of the present application is to obtain sampling data of each sewage sampling point in the target area, couple each sampling data with the historical sampling data of the corresponding sampling point, and obtain abnormal data, including: obtaining the sampling data of each sewage sampling point in the target area within a continuous time period, and constructing a historical sampling data sequence according to the acquired time sequence; obtaining the average value of the historical data of each sewage sampling point according to the historical sampling data sequence, and using it as the benchmark value of the sampling point; traversing the sampling data of each sewage sampling point, comparing the current sampling data with the benchmark value of the corresponding sampling point, and if the current sampling data exceeds the threshold range of the benchmark value, marking the current sampling data as abnormal data.

[0026] In a second aspect, the present invention provides a processing device based on sewage drug detection data, comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute any one of the methods described above.

[0027] The beneficial effects of the present invention are: first, the data processing efficiency is high, and a large amount of sampling data can be quickly analyzed, thereby improving work efficiency; second, the data processing accuracy is high, and the distance between the drug emission source and the sampling point can be accurately calculated, providing accurate location information for law enforcement agencies; third, the operation is simple, and data processing and analysis can be completed by simply inputting the sampling data into the device without the need for complicated operations.

[0028] In summary, the present invention provides a processing method and device based on sewage drug detection data, which has the advantages of accurate positioning, high processing efficiency, and easy operation. It is of great significance for combating drug crimes and protecting environmental safety. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] Figure 1 A schematic flow chart of a method for processing sewage drug detection data according to the present invention;

[0030] Figure 2 A schematic flow chart of obtaining abnormal data based on the method for processing sewage drug detection data of the present invention;

[0031] Figure 3 It is a schematic structural diagram of the processing equipment based on sewage drug detection data of the present invention. DETAILED DESCRIPTION

[0032] The following will refer to Figures 1 to 3 The embodiments of the present invention are described in detail. It should be understood by those skilled in the art that these embodiments are only used to explain the technical principles of the present invention and are not intended to limit the protection scope of the present invention. Example

[0033] like Figure 1 As shown, a method for processing sewage drug detection data includes the following steps:

[0034] S1. Acquire sampling data of each sewage sampling point in the target area, couple each sampling data with historical sampling data of its corresponding sampling point, obtain abnormal data, determine the location of the sampling point corresponding to the abnormal data, and determine the content of drugs in the sewage as a first drug concentration;

[0035] S2. Obtain a sewage pipe network map within the target area, and according to the location of the sampling point corresponding to the abnormal data, obtain the pipe network segment where the sampling point corresponding to the abnormal data is located on the sewage pipe network map, and mark the pipe network segment as the pipe network segment to be checked;

[0036] S3, obtaining sewage sampling data in a previous pipe network segment connected to the pipe network segment to be checked, and determining that the drug content in the sewage is a second drug concentration;

[0037] S4, obtaining sewage sampling data at any location upstream of the sampling point location corresponding to the abnormal data in the pipe network segment to be checked, and determining that the drug content in the sewage is a third drug concentration;

[0038] S5. Determine the source of drug emission based on the comparison results of the first drug concentration, the second drug concentration and the third drug concentration.

[0039] In this embodiment, by comparing historical data with real-time data, abnormal data can be accurately identified. These abnormal data are often related to drug emissions. Preferably, the sampling data of the abnormal data sampling point includes the latitude and longitude of the sampling point, the sewage flow rate, and the concentration of drug precursors and drug metabolites in the sewage. Through the above steps, we can achieve fast, accurate and effective source positioning based on sewage drug detection data. This not only helps law enforcement agencies to crack down on drug crimes in a timely manner, but also effectively protects environmental safety and prevents drug pollution of water bodies and ecosystems.

[0040] It should be noted that, in the above steps, the first drug concentration, the second drug concentration and the third drug concentration are all obtained by solid phase extraction-liquid chromatography-mass spectrometry technology.

[0041] Preferably, Figure 2 As shown, the sampling data of each sewage sampling point in the target area is obtained, and each sampling data is coupled with the historical sampling data of the corresponding sampling point to obtain abnormal data, including the following steps:

[0042] S11, acquiring sampling data of each sewage sampling point in the target area within a continuous time period, and constructing a historical sampling data sequence according to the acquired time sequence;

[0043] S12. According to the historical sampling data sequence, the average value of the historical data of each sewage sampling point is obtained, and the average value is used as the benchmark value of the sampling point;

[0044] S13, traversing the sampling data of each sewage sampling point, comparing the current sampling data with the reference value of the corresponding sampling point, and if the current sampling data exceeds the threshold range of the reference value, marking the current sampling data as abnormal data.

[0045] In the above steps, the threshold range may be set to be the average value of the multiple historical data of each sampling point plus 1.5 standard deviations of the multiple historical data.

[0046] In one embodiment of the present invention, the source of drug emission is determined based on the comparison results of the first drug concentration, the second drug concentration and the third drug concentration. The conditions for determining the source of drug emission include:

[0047] If the second drug concentration is lower than the normal value of drug concentration in sewage in the target area, it is determined that the source of drug discharge is located in the pipe network section to be checked;

[0048] If the third drug concentration is less than the normal value of drug concentration in sewage in the target area or less than the first drug concentration, it is determined that the source of drug discharge is located in the pipe network section to be checked;

[0049] If the third drug concentration is greater than the first drug concentration and less than the second drug concentration, it is determined that the source of drug emission is located in the pipeline section to be inspected.

[0050] Preferably, determining the source of drug emission according to the comparison results of the first drug concentration, the second drug concentration and the third drug concentration comprises the following steps:

[0051] If it is determined that the source of drug release is located in the pipeline section to be verified, then,

[0052] S51. Obtain sewage sampling data at any position upstream of the sampling point position corresponding to the abnormal data in the pipe network segment to be verified, and record it as verification sampling data, and the sampling point position where the verification sampling data is located is different from the sampling point position where the third drug concentration is located, and determine that the drug content in the sewage is the fourth drug concentration, and the fourth drug concentration is greater than the first drug concentration, wherein the verification sampling data includes the latitude and longitude of the sampling position, the sewage flow rate, and the concentration of the drug precursor and drug metabolite in the sewage;

[0053] S52. Obtain the location of the drug emission source based on the sampling data of the abnormal data sampling point and the verified sampling data.

[0054] In this embodiment, by comparing the first drug concentration, the second drug concentration and the third drug concentration, the pipeline section to be checked is determined, and the fourth drug concentration is introduced. The location of the drug emission source is obtained based on the sampling data of the abnormal data sampling point and the verification sampling data, thereby further narrowing the verification scope and improving the efficiency of tracing.

[0055] In one embodiment of the present invention, a method for obtaining the location of a drug emission source based on sampling data of an abnormal data sampling point and verifying the sampling data includes:

[0056] S521, obtain the latitude and longitude of the abnormal data sampling point and the latitude and longitude of the verification sampling data sampling point, determine the distance between the abnormal data sampling point and the verification sampling data sampling point, wherein the verification sampling data sampling point is recorded as a Point, the abnormal data sampling point is recorded as b point, the specific expression is:

[0057] (1),

[0058] In expression (1), d ab express a point, b The distance between two points, lat a Indicated a The longitude of the point, lon a represents the latitude of point a, lat b express b The longitude of the point, lon b express b The latitude of the point, r represents the radius of the Earth;

[0059] S522, according to the fourth drug concentration, the first drug concentration, the sewage flow rate and the distance between a and b, obtain the distance between the drug discharge source and the sampling point for verifying the sampling data d s , its specific expression is:

[0060] (2),

[0061] In expression (2), C a Indicates the fourth drug concentration, C b Indicates the concentration of the first drug, d ab express a point, b The distance between two points;

[0062] S523. Obtain the water flow direction angle of the sampling point for verifying the sampling data through the geographic information system θ , and substitute expression (1) into expression (2) to obtain the latitude and longitude of the drug emission source, the specific expression is:

[0063] (3),

[0064] (4),

[0065] In expression (3), lat s represents the longitude of the source of drug emission. In expression (4), lon s Indicates the latitude of the source of drug release.

[0066] In the above embodiment, according to the fourth drug concentration, the first drug concentration, the sewage flow rate and a and b The distance between the source of drug emission and the sampling point for verifying sampling data d s ,include:

[0067] Set the distance between the drug emission source and the sampling point to be d s ,but d s The expression is:

[0068] (5),

[0069] In expression (5), Indicates the sewage flow rate, It indicates the time it takes for drugs and drug metabolites to arrive at the sampling point for verification sampling data from the drug emission source. It is calculated by the following expression (6):

[0070] (6),

[0071] express a point, b The distance between two points, Indicates the sewage flow rate, Indicates the fourth drug concentration, Indicates the first drug concentration;

[0072] Substituting expression (6) into expression (5) yields expression (2).

[0073] In this embodiment, the latitude and longitude of the final source of drug emission is obtained by limiting the sampling data of abnormal data sampling points and verifying the processing of sampling data. Compared with the traditional method of relying on manpower to analyze the test results, the accuracy of the analysis is improved and the efficiency is improved.

[0074] Compared with the prior art, the processing method based on sewage drug detection data of the present application has the following beneficial effects: first, the data processing efficiency is high, and a large amount of sampling data can be quickly analyzed, thereby improving work efficiency; second, the data processing accuracy is high, and the distance between the drug emission source and the sampling point can be accurately calculated, providing accurate location information for law enforcement agencies; third, the operation is simple, and the sampling data only needs to be input into the device to automatically complete data processing and analysis without the need for complicated operations.

[0075] In one embodiment of the present invention, Figure 3 As shown, a processing device based on sewage drug detection data includes:

[0076] at least one processor; and

[0077] a memory communicatively connected to the at least one processor; wherein,

[0078] The memory stores instructions that can be executed by the at least one processor. The instructions are executed by the at least one processor so that the at least one processor can perform the above method.

[0079] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0080] The program code for implementing the method of the present disclosure may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that the program code, when executed by the processor or controller, enables the functions / operations specified in the flow chart and / or block diagram to be implemented. The program code may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0081] In the context of the present disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or device, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0082] To provide interaction with a user, the systems and techniques described herein can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user can provide input to the computer. Other types of devices can also be used to provide interaction with the user; for example, the feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including acoustic input, voice input, or tactile input).

[0083] The systems and techniques described herein may be implemented in a computing system that includes back-end components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes front-end components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such back-end components, middleware components, or front-end components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), and the Internet.

[0084] A computer system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The relationship of client and server is generated by computer programs running on respective computers and having a client-server relationship with each other. The server may be a cloud server, a server of a distributed system, or a server combined with a blockchain.

[0085] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps recorded in this disclosure can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solutions disclosed in this disclosure can be achieved, and this document does not limit this.

[0086] The above specific implementations do not constitute a limitation on the protection scope of the present disclosure. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present disclosure shall be included in the protection scope of the present disclosure.

Claims

1. A processing method based on sewage drug detection data, characterized in that: include: Acquire sampling data of each sewage sampling point in the target area, couple each sampling data with historical sampling data of its corresponding sampling point, obtain abnormal data, determine the location of the sampling point corresponding to the abnormal data, and determine the content of drugs in the sewage as a first drug concentration; Obtain a sewage pipe network map within the target area, and according to the location of the sampling point corresponding to the abnormal data, obtain the pipe network segment where the sampling point corresponding to the abnormal data is located on the sewage pipe network map, and mark the pipe network segment as the pipe network segment to be checked; Obtaining sewage sampling data in a previous pipe network segment connected to the pipe network segment to be checked, and determining that the drug content in the sewage is a second drug concentration; Obtain sewage sampling data at any location upstream of the sampling point location corresponding to the abnormal data in the pipe network segment to be checked, and determine that the drug content in the sewage is a third drug concentration; According to the comparison results of the first drug concentration, the second drug concentration and the third drug concentration, the sources of drug emission are determined to include: If it is determined that the source of drug release is located in the pipeline section to be verified, then, Obtain sewage sampling data at any location upstream of the sampling point location corresponding to the abnormal data in the pipe network segment to be verified, and record it as verification sampling data, and the sampling point location where the verification sampling data is located is different from the sampling point location where the third drug concentration is located, and determine that the drug content in the sewage is the fourth drug concentration, and the fourth drug concentration is greater than the first drug concentration, wherein the verification sampling data includes the latitude and longitude of the sampling location, the sewage flow rate, and the concentration of the drug precursor and drug metabolite in the sewage; The location of the drug emission source is obtained based on the sampling data of the abnormal data sampling point and the verification sampling data, including: Obtain the latitude and longitude of the abnormal data sampling point and the latitude and longitude of the verification sampling data sampling point, and determine the distance between the abnormal data sampling point and the verification sampling data sampling point, where the verification sampling data sampling point is recorded as a Point, the abnormal data sampling point is recorded as b point, the specific expression is: (1), In expression (1), d ab express a point, b The distance between two points, lat a Indicated a The longitude of the point, lon a express a The latitude of the point, lat b express b The longitude of the point, lon b express b The latitude of the point, r represents the radius of the Earth; According to the fourth drug concentration, the first drug concentration, the sewage flow rate and a and b The distance between the source of drug emission and the sampling point for verification of sampling data d s , its specific expression is: (2), In expression (2), C a Indicates the fourth drug concentration, C b Indicates the concentration of the first drug, d ab express a point, b The distance between two points; The water flow direction angle θ of the sampling point of the verification sampling data is obtained through the geographic information system, and expression (1) is substituted into expression (2) to obtain the longitude and latitude of the drug emission source, the specific expression of which is: (3), (4), In expression (3), lat s represents the longitude of the source of drug emission. In expression (4), lon s Indicates the latitude of the source of drug release.

2. The method for processing sewage drug detection data according to claim 1 is characterized in that: The sampling data of the abnormal data sampling point includes the latitude and longitude of the sampling point, the sewage flow rate and the concentration of the drug precursor and drug metabolites in the sewage.

3. The method for processing sewage drug detection data according to claim 2 is characterized in that: According to the comparison results of the first drug concentration, the second drug concentration and the third drug concentration, the source of drug emission is determined, which also includes: If the second drug concentration is lower than the normal value of drug concentration in sewage in the target area, it is determined that the source of drug discharge is located in the pipe network section to be checked; If the third drug concentration is less than the normal value of drug concentration in sewage in the target area or less than the first drug concentration, it is determined that the source of drug discharge is located in the pipe network section to be checked; If the third drug concentration is greater than the first drug concentration and less than the second drug concentration, it is determined that the source of drug emission is located in the pipeline section to be inspected.

4. The method for processing sewage drug detection data according to claim 1 is characterized in that: According to the fourth drug concentration, the first drug concentration, the sewage flow rate and a and b The distance between the source of drug emission and the sampling point for verification of sampling data d s ,include: Set the distance between the drug emission source and the sampling point to be d s ,but d s The expression is: (5), In expression (5), v Indicates the sewage flow rate, t It indicates the time it takes for drugs and drug metabolites to arrive at the sampling point for verification sampling data from the drug emission source. t It is calculated by the following expression (6): (6), d ab express a point, b The distance between two points, v Indicates the sewage flow rate, C a Indicates the fourth drug concentration, C b Indicates the first drug concentration; Substituting expression (6) into expression (5) yields expression (2).

5. The method for processing sewage drug detection data according to claim 1 is characterized in that: Acquire the sampling data of each sewage sampling point in the target area, couple each sampling data with the historical sampling data of its corresponding sampling point, and obtain abnormal data, including: Acquire the sampling data of each sewage sampling point in the target area within a continuous time period, and construct a historical sampling data sequence according to the acquired time sequence; According to the historical sampling data sequence, the average value of the historical data of each sewage sampling point is obtained and used as the benchmark value of the sampling point; The sampling data of each sewage sampling point is traversed, and the current sampling data is compared with the benchmark value of the corresponding sampling point. If the current sampling data exceeds the threshold range of the benchmark value, the current sampling data is marked as abnormal data.

6. A processing device based on sewage drug detection data, characterized in that: include: at least one processor; as well as, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the method according to any one of claims 1 to 5.

Citation Information

Patent Citations

  • Sewage pollution tracing method

    CN112083132A

  • Water pollution tracing method and device and terminal equipment

    CN112559657A