Method and system for verifying photographing parameters of online monitoring device in power transmission field

Abstract

The invention provides a method and system for verifying photographing parameters of an online monitoring device in the power transmission field, and the method comprises the steps: obtaining the equipment number of a monitoring device in a historical time period and the corresponding snapshot interval time, and constructing a first data set; traversing the equipment number of the monitoring device, obtaining first picture data of the monitoring device, and performing internal connection on the first picture data to obtain a first time interval corresponding to each record; grouping according to the size of the first time interval to obtain a second data set of the total number of pictures in each time interval; sequencing the total number of pictures to obtain a maximum total number of pictures and a second time interval under each time interval; and setting the confidence degree of the monitoring device in drawing according to the photographing interval, and if the ratio of the maximum total drawing number to the total drawing number is greater than the confidence degree, drawing according to a second time interval. Based on the method, the invention further provides a system for checking the photographing parameters of the online monitoring device in the power transmission field. According to the invention, the online monitoring device can be maintained in time to improve the safety of a power transmission scene.

Description

Technical Field

[0001] The present invention belongs to the technical field of electric power monitoring, and in particular relates to a method and system for verifying photographing parameters of an online monitoring device in the field of power transmission. Background Art

[0002] With the rapid development of the power industry, the application of online monitoring devices in the field of power transmission is becoming more and more widespread. Online monitoring devices can monitor the status of transmission lines in real time and record key information by taking photos, etc., providing important basis for fault detection and line maintenance.

[0003] However, due to human operating errors or not directly operating the equipment through the system, the equipment photo taking time record in the system may not match the current actual operating status of the equipment, which in turn affects the probability and reliability of human discovery of problematic equipment, and further affects the safety of various scenarios under the transmission line, such as line tripping. Therefore, it is of great practical significance to develop a method that can automatically verify whether the photo taking parameters of online monitoring devices in the transmission field are correct when displayed in the system. Summary of the invention

[0004] In order to solve the above technical problems, the present invention proposes a method and system for verifying the photographing parameters of an online monitoring device in the field of power transmission, which can automatically verify whether the photographing parameters of the online monitoring device in the field of power transmission are correctly displayed in the monitoring system.

[0005] To achieve the above object, the present invention adopts the following technical solutions:

[0006] A method for verifying photographing parameters of an online monitoring device in the field of power transmission, comprising the following steps:

[0007] Obtain the monitoring device equipment number and the corresponding capture interval time in the historical time period to construct a first data set; traverse the monitoring device equipment number in the first data set to obtain the first upper image data of the monitoring device, wherein the first upper image data includes: a unique identifier of each image and a capture time of each image;

[0008] Perform an inner connection on the first upper image data of any device to obtain the first time interval corresponding to each record; group the first time interval corresponding to each record to obtain a second data set of the total number of upper images in each time interval; sort the total number of upper images in each time interval in the second data set to obtain the maximum total number of upper images in each time interval and the second time interval;

[0009] The confidence level of the monitoring device for uploading images is set according to the shooting interval. If the maximum total number of images uploaded at each time interval accounts for a larger proportion of the total number of images uploaded at each time interval than the confidence level, the second time interval is considered reliable and images are uploaded at the second time interval.

[0010] Furthermore, the method also includes: traversing the monitoring devices in the first data set, obtaining the capture interval of each monitoring device in the first data set, if the capture interval is not equal to the capture time of each image, then determining that the capture interval of each monitoring device in the first data set is wrong, re-issuing the capture interval acquisition instruction to the monitoring device, and correcting the first data set.

[0011] Furthermore, the historical time period is a time period between a set minimum start working time and a set maximum start working time.

[0012] Furthermore, the process of performing an inner connection on the first upper graph data of any device to obtain the first time interval corresponding to each record is: performing an inner connection on the first upper graph data of any device using a Cartesian product method to obtain the first time interval corresponding to each record.

[0013] Furthermore, the method for determining the first time interval corresponding to each record is:

[0014] time_diff=pictureCaptureDT(1)-pictureCaptureDT;

[0015] Wherein, time_diff is the first time interval corresponding to each record; pictureCaptureDT(1) is the capture time after inner connection; pictureCaptureDT is the capture time of each image.

[0016] Furthermore, the method further includes: obtaining data where time_diff>0, and grouping and deduplicating data by pictureID, taking the record with the smallest time_diff value in each group, and then grouping the data by time_diff.

[0017] Furthermore, the method for determining the total number of images at each time interval is as follows:

[0018] The count(time_diff) values ​​in the second data set are added together to obtain the total number of images uploaded at each time interval.

[0019] Furthermore, the specific process of sorting the total number of upper images in each time interval in the second data set to obtain the maximum total number of upper images in each time interval and the second time interval includes: sorting the total number of upper images in each time interval in the second data set according to the bubble algorithm to obtain the maximum total number of upper images in each time interval and the second time interval.

[0020] The present invention also proposes a system for verifying photographing parameters of an online monitoring device in the field of power transmission, comprising: a first building module, a second building module and a first verification module;

[0021] The first construction module is used to obtain the monitoring device equipment number and the corresponding capture interval time in the historical time period to construct a first data set; traverse the monitoring device equipment number in the first data set to obtain the first upper image data of the monitoring device, the first upper image data including: a unique identifier of each image and the capture time of each image;

[0022] The second construction module is used to perform an inner connection on the first upper image data of any device to obtain the first time interval corresponding to each record; group according to the size of the first time interval corresponding to each record to obtain a second data set of the total number of upper images in each time interval; sort the total number of upper images in each time interval in the second data set to obtain the maximum total number of upper images in each time interval and the second time interval;

[0023] The first verification module is used to set the confidence level of the monitoring device uploading images according to the shooting interval. If the maximum total number of images uploaded in each time interval accounts for a larger proportion of the total number of images uploaded in each time interval than the confidence level, the second time interval is considered reliable and images are uploaded according to the second time interval.

[0024] Furthermore, the system also includes a second verification module;

[0025] The second inspection module is used to traverse the monitoring devices in the first data set and obtain the capture interval of each monitoring device in the first data set. If the capture interval is not equal to the capture time of each image, it is determined that the capture interval of each monitoring device in the first data set is wrong, and the capture interval acquisition instruction is re-issued to the monitoring device to correct the first data set.

[0026] The effects provided in the content of the invention are only the effects of the embodiments, not all the effects of the invention. One of the above technical solutions has the following advantages or beneficial effects:

[0027] The present invention proposes a method and system for verifying photographing parameters of an online monitoring device in the field of power transmission, the method comprising the following steps: obtaining a monitoring device equipment number and a corresponding snapshot interval time in a historical time period to construct a first data set; traversing the monitoring device equipment number in the first data set to obtain the first image data of the monitoring device, the first image data comprising: a unique identifier of each image and a snapshot time of each image; performing an inner connection on the first image data of any device to obtain a first time interval corresponding to each record; grouping according to the size of the first time interval corresponding to each record to obtain a second data set of the total number of images in each time interval; sorting the total number of images in each time interval in the second data set to obtain the maximum total number of images in each time interval and the second time interval; setting the confidence level of the monitoring device according to the image snapshot interval, if the proportion of the maximum total number of images in each time interval to the total number of images in each time interval is greater than the confidence level, the second time interval is considered to be reliable, and the image is snapshotted according to the second time interval. Traverse the monitoring devices in the first data set, obtain the capture interval of each monitoring device in the first data set, if the capture interval is not equal to the capture time of each image, then determine that the capture interval of each monitoring device in the first data set is wrong, re-issue the acquisition capture interval instruction to the monitoring device, and correct the first data set. Based on a method for verifying the photographing parameters of an online monitoring device in the field of power transmission, a system for verifying the photographing parameters of an online monitoring device in the field of power transmission is also proposed. The present invention can automatically verify whether the photographing parameters of an online monitoring device in the field of power transmission are displayed correctly when performing monitoring, so that the probability that the displayed online monitoring device parameters can truly feedback the operating status of the equipment is greatly improved, which helps to discover equipment problems in a timely manner, and then the online monitoring device can be maintained in time to improve the safety of the power transmission scene. BRIEF DESCRIPTION OF THE DRAWINGS

[0028] Figure 1 A flow chart of a method for verifying photographing parameters of an online monitoring device in the field of power transmission proposed in Embodiment 1 of the present invention;

[0029] Figure 2 This is a schematic diagram of system connection for verifying photographing parameters of an online monitoring device in the power transmission field, as proposed in Example 2 of the present invention. DETAILED DESCRIPTION

[0030] In order to clearly illustrate the technical features of the present solution, the present invention is described in detail below through specific implementation methods and in conjunction with the accompanying drawings. The disclosure below provides many different embodiments or examples for realizing different structures of the present invention. In order to simplify the disclosure of the present invention, the components and settings of specific examples are described below. In addition, the present invention may repeat reference numbers and / or letters in different examples. This repetition is for the purpose of simplification and clarity, and does not itself indicate the relationship between the various embodiments and / or settings discussed. It should be noted that the components illustrated in the accompanying drawings are not necessarily drawn to scale. The present invention omits the description of known components and processing techniques and processes to avoid unnecessary limitations on the present invention.

[0031] Example 1

[0032] Embodiment 1 of the present invention proposes a method for verifying photographing parameters of an online monitoring device in the field of power transmission, so as to solve the technical problems existing in the prior art in verifying photographing parameters of online monitoring devices, so as to improve the safety of power transmission operation and maintenance.

[0033] Figure 1 A flow chart of a method for verifying photographing parameters of an online monitoring device in the field of power transmission proposed in Embodiment 1 of the present invention;

[0034] Figure 1 A flow chart of a method for verifying photographing parameters of an online monitoring device in the field of power transmission proposed in Embodiment 1 of the present invention;

[0035] In step S100, the process starts to be executed.

[0036] In step S110, the device number of the monitoring device in the historical time period and the corresponding snapshot interval are obtained to construct a first data set;

[0037] The historical time period is the time period between the set minimum start working time and the maximum start working time. The query includes the minimum start working time T1 = 00:00:00 and the maximum start working time T2 = 23:59:59 in the previous day. The device ID of the monitoring device in the figure above is deviceID. There is a terminal device numbered 99990000 (unique identifier of the online monitoring device) and the corresponding capture interval time T, which is constructed into the first data set C 0 The following table 1 is the first data set C 0 records.

[0038] Table 1: Records of the first dataset

[0039] deviceID T 99990000 60

[0040] In step S120, the monitoring device device numbers in the first data set are traversed to obtain first image data of the monitoring device, wherein the first image data includes: a unique identifier of each image and a capture time of each image;

[0041] Traverse the first data set C 0 In the deviceID, the above data includes: pictureID is the unique identifier of each picture, pictureCaptureDT is the picture capture time, and deviceID is the unique identifier of the online monitoring device.

[0042] In step S130, an inner connection is performed on the first upper image data of any device to obtain the first time interval corresponding to each record; grouping is performed according to the size of the first time interval corresponding to each record to obtain a second data set of the total number of upper images in each time interval;

[0043] The process of performing an inner connection on the first upper graph data of any device to obtain the first time interval corresponding to each record is: performing an inner connection on the first upper graph data of any device by using a Cartesian product method to obtain the first time interval corresponding to each record.

[0044] The method for determining the first time interval corresponding to each record is:

[0045] time_diff=pictureCaptureDT(1)-pictureCaptureDT;

[0046] Among them, time_diff is the first time interval corresponding to each record; pictureCaptureDT(1) is the capture time after inner join; pictureCaptureDT is the capture time of each image. Then obtain the data where time_diff>0, and group them by pictureID to remove duplicates, take the record with the smallest time_diff value in each group, and group them again according to time_diff. After completing the above steps, we can get the second data set of the total number of images uploaded at each time interval. The second data set should contain two columns: time_diff and count(time_diff), where count(time_diff) is the number of images uploaded in the current interval.

[0047] The present invention also provides a MySQL database statistical method, where photorecord is a database table that stores all the device picture details. Table 2 is a pseudo database table structure corresponding to the above statistical method. According to this method, the number of times the device takes pictures at each time interval can be iterated and circulated to obtain a second data set.

[0048] Table 2: A pseudo database table structure corresponding to the above statistical means;

[0049] Field Name type length pictureID varchar 20 pictureCaptureDT timestamp 0 deviceID varchar 20

[0050] PictureCaptureDT(1)-pictureCaptureDT is converted into minutes to get the time_diff column. Table 3 shows the content of the second data set.

[0051] Table 3: Contents of the second dataset;

[0052]

[0053]

[0054] Get the data where time_diff>0, and group them by pictureID to re-take the record with the smallest time_diff value in each group, and then group them according to time_diff. Table 4 shows the grouped records.

[0055] Table 4: Records after time_diff grouping.

[0056] time_diff(minutes) count(time_diff) 60 3 20 1

[0057] In step S140, the count(time_diff) values ​​in the second data set are added to obtain the total number of images uploaded in each time interval. The total sum obtained by adding the count(time_diff) values ​​in the second data set is 4, and sum should also be the total number of images uploaded on the device - 1.

[0058] In step S150, the total number of upper images in each time interval in the second data set is sorted to obtain the maximum total number of upper images in each time interval and the second time interval;

[0059] The total number of upper images in each time interval in the second data set is sorted according to the bubble algorithm to obtain the maximum total number of upper images in each time interval and the second time interval.

[0060] The second set is sorted by the total number of upper images in the corresponding time interval using a bubbling algorithm, and the maximum total number of upper images in a certain time interval is obtained as max 3, and the time interval TimeDiff is 60 (minutes).

[0061] In step S160, the confidence level of the monitoring device in uploading images according to the shooting interval is set. If the maximum total number of images uploaded at each time interval accounts for a larger proportion of the total number of images uploaded at each time interval than the confidence level, the second time interval is considered reliable and images are uploaded at the second time interval.

[0062] Set the confidenceRate confidence level to 0.7. The total number of images uploaded for TimeDiff at a 60-minute interval accounts for (3 / 4*=0.75), which is greater than 0.7. We believe that TimeDiff is reliable and the device should upload images every 60 minutes according to this setting.

[0063] In step S170, the online monitoring devices in the first data set are traversed to obtain the capture interval of each monitoring device in the first data set. If the capture interval is not equal to the capture time of each image, it is determined that the capture interval of each monitoring device in the first data set is wrong, and the capture interval acquisition instruction is re-issued to the monitoring device to correct the first data set.

[0064] Iterate through the online monitoring devices in the first data set to obtain the capture interval T of each line monitoring device in the first data set. If T is not equal to TimeDiff, it is considered that the T stored in the system for this line monitoring device is incorrect. Then, a command to obtain the capture interval can be sent to the device, and the command will be filled back into the system database after the device responds.

[0065] In this embodiment, the snapshot interval of the online monitoring device is 20, which is not equal to 60. Therefore, it is determined that the T=20 stored in the system by the online monitoring device is incorrectly stored due to some reason. Therefore, a command to obtain the snapshot interval can be sent to the device. After the device responds, it should be 60 minutes, and then 60 is filled back into the system database. At this point, we can complete the verification of a device.

[0066] A method for verifying the photographing parameters of an online monitoring device in the field of power transmission proposed in Example 1 of the present invention can automatically verify whether the photographing parameters of the online monitoring device in the field of power transmission are displayed correctly when performing monitoring, so that the probability that the displayed online monitoring device parameters can truly feedback the operating status of the equipment is greatly improved, which helps to discover equipment problems in time, and then the online monitoring device can be maintained in time to improve the safety of the power transmission scene.

[0067] Example 2

[0068] Based on the method for verifying the photographing parameters of an online monitoring device in the field of power transmission proposed in Example 1 of the present invention, Example 2 of the present invention further proposes a system for verifying the photographing parameters of an online monitoring device in the field of power transmission, Figure 2 This is a schematic diagram of a system connection for verifying photographing parameters of an online monitoring device in the field of power transmission proposed in Embodiment 2 of the present invention, the system comprising a first building module, a second building module and a first verification module;

[0069] The first construction module is used to obtain the monitoring device equipment number and the corresponding capture interval time in the historical time period to construct a first data set; traverse the monitoring device equipment number in the first data set to obtain the first upper image data of the monitoring device, wherein the first upper image data includes: a unique identifier of each image and a capture time of each image;

[0070] The second construction module is used to perform an inner connection on the first upper image data of any device to obtain the first time interval corresponding to each record; group according to the size of the first time interval corresponding to each record to obtain a second data set of the total number of upper images in each time interval; sort the total number of upper images in each time interval in the second data set to obtain the maximum total number of upper images in each time interval and the second time interval;

[0071] The first verification module is used to set the confidence level of the monitoring device uploading images according to the shooting interval. If the maximum total number of images uploaded in each time interval accounts for a larger proportion of the total number of images uploaded in each time interval than the confidence level, the second time interval is considered reliable and images are uploaded according to the second time interval.

[0072] The system also includes a second verification module; the second verification module is used to traverse the monitoring devices in the first data set and obtain the capture interval of each monitoring device in the first data set. If the capture interval is not equal to the capture time of each image, it is determined that the capture interval of each monitoring device in the first data set is wrong, and the capture interval acquisition instruction is re-issued to the monitoring device to correct the first data set.

[0073] In the first construction module of the present application: the historical time period is the time period between the set minimum start working time and the maximum start working time.

[0074] In the second construction module, the process of inner joining the first upper graph data of any device to obtain the first time interval corresponding to each record is: inner joining the first upper graph data of any device by using the Cartesian product method to obtain the first time interval corresponding to each record.

[0075] The method for determining the first time interval corresponding to each record is:

[0076] time_diff=pictureCaptureDT(1)-pictureCaptureDT;

[0077] Where time_diff is the first time interval corresponding to each record; pictureCaptureDT(1) is the capture time after inner join; pictureCaptureDT is the capture time of each image

[0078] Get the data where time_diff>0, and group them by pictureID to remove duplicates. Take the record with the smallest time_diff value in each group, and then group them by time_diff.

[0079] The method for determining the total number of images at each time interval is:

[0080] The count(time_diff) values ​​in the second data set are added together to obtain the total number of images uploaded at each time interval.

[0081] The specific process of sorting the total number of upper images in each time interval in the second data set to obtain the maximum total number of upper images in each time interval and the second time interval includes: sorting the total number of upper images in each time interval in the second data set according to the bubble algorithm to obtain the maximum total number of upper images in each time interval and the second time interval.

[0082] A system for verifying the photographing parameters of an online monitoring device in the power transmission field proposed in Example 2 of the present invention can automatically verify whether the photographing parameters of the online monitoring device in the power transmission field are displayed correctly when performing monitoring, so that the probability that the displayed online monitoring device parameters can truly feedback the operating status of the equipment is greatly improved, which helps to discover equipment problems in a timely manner, and then the online monitoring device can be maintained in time to improve the safety of the power transmission scenario.

[0083] The description of the relevant parts of a system for verifying the photographing parameters of an online monitoring device in the power transmission field proposed in Example 2 of the present application can be found in the detailed description of the corresponding parts of a method for verifying the photographing parameters of an online monitoring device in the power transmission field provided in Example 1 of the present application, and will not be repeated here.

[0084] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply that there is any such actual relationship or order between these entities or operations. Moreover, the term "include", "comprise" or any other variant thereof is intended to cover non-exclusive inclusion, so that the process, method, article or equipment that includes a series of elements are inherent to the elements. In the absence of more restrictions, the elements limited by the sentence "comprise one..." do not exclude the presence of other identical elements in the process, method, article or equipment that includes the elements. In addition, the above-mentioned technical solution provided in the embodiment of the present application is consistent with the corresponding technical solution in the prior art in principle, and the part is not described in detail, so as not to repeat too much.

[0085] Although the above describes the specific implementation of the present invention in conjunction with the accompanying drawings, it is not intended to limit the scope of protection of the present invention. For those skilled in the art, other different forms of modifications or deformations can be made on the basis of the above description. It is not necessary and impossible to list all the implementation methods here. On the basis of the technical solution of the present invention, various modifications or deformations that can be made by those skilled in the art without creative work are still within the scope of protection of the present invention.

Claims

1. A method for verifying the photographing parameters of an online monitoring device in the field of power transmission, characterized in that: The following steps are involved: Obtain the equipment number of the monitoring device and the corresponding snapshot interval time in the historical time period to construct a first data set; Traversing the monitoring device device numbers in the first data set, obtaining first image data of the monitoring device, wherein the first image data includes: a unique identifier of each image and a capture time of each image; Perform an inner connection on the first upper image data of any device to obtain the first time interval corresponding to each record; group the first time interval corresponding to each record to obtain a second data set of the total number of upper images in each time interval; sort the total number of upper images in each time interval in the second data set to obtain the maximum total number of upper images in each time interval and the second time interval; The confidence level of the monitoring device for uploading images is set according to the shooting interval. If the maximum total number of images uploaded at each time interval accounts for a larger proportion of the total number of images uploaded at each time interval than the confidence level, the second time interval is considered reliable and images are uploaded at the second time interval.

2. A method for verifying photographing parameters of an online monitoring device in the field of power transmission according to claim 1, characterized in that: The method also includes: traversing the monitoring devices in the first data set, obtaining the capture interval of each monitoring device in the first data set, and if the capture interval is not equal to the capture time of each image, determining that the capture interval of each monitoring device in the first data set is wrong, re-issuing the acquisition capture interval instruction to the monitoring device, and correcting the first data set.

3. A method for verifying photographing parameters of an online monitoring device in the field of power transmission according to claim 1, characterized in that: The historical time period is the time period between the set minimum start working time and the set maximum start working time.

4. A method for verifying photographing parameters of an online monitoring device in the field of power transmission according to claim 1, characterized in that: The process of performing an inner connection on the first upper graph data of any device to obtain the first time interval corresponding to each record is: performing an inner connection on the first upper graph data of any device by using a Cartesian product method to obtain the first time interval corresponding to each record.

5. A method for verifying photographing parameters of an online monitoring device in the field of power transmission according to claim 4, characterized in that: The method for determining the first time interval corresponding to each record is: time_diff=pictureCaptureDT(1)-pictureCaptureDT; Wherein, time_diff is the first time interval corresponding to each record; pictureCaptureDT(1) is the capture time after inner connection; pictureCaptureDT is the capture time of each image.

6. A method for verifying photographic parameters of an online monitoring device in the field of power transmission according to claim 5, characterized in that: The method further includes: acquiring data where time_diff>0, and performing grouping and deduplication based on pictureID, taking the record with the smallest time_diff value in each group, and then performing grouping based on time_diff.

7. A method for verifying photographic parameters of an online monitoring device in the field of power transmission according to claim 6, characterized in that: The total number of images uploaded at each time interval is determined by adding the count(time_diff) values ​​in the second data set to obtain the total number of images uploaded at each time interval.

8. A method for verifying photographic parameters of an online monitoring device in the field of power transmission according to claim 1, characterized in that: The specific process of sorting the total number of upper images in each time interval in the second data set to obtain the maximum total number of upper images in each time interval and the second time interval includes: sorting the total number of upper images in each time interval in the second data set according to the bubble algorithm to obtain the maximum total number of upper images in each time interval and the second time interval.

9. A system for verifying photographic parameters of an online monitoring device in the field of power transmission, characterized in that: include: A first building module, a second building module and a first verification module; The first construction module is used to obtain the equipment number of the monitoring device in the historical time period and the corresponding capture interval time to construct a first data set; Traversing the monitoring device device numbers in the first data set, obtaining first image data of the monitoring device, wherein the first image data includes: a unique identifier of each image and a capture time of each image; The second construction module is used to perform an inner connection on the first upper image data of any device to obtain the first time interval corresponding to each record; group according to the size of the first time interval corresponding to each record to obtain a second data set of the total number of upper images in each time interval; sort the total number of upper images in each time interval in the second data set to obtain the maximum total number of upper images in each time interval and the second time interval; The first verification module is used to set the confidence level of the monitoring device uploading images according to the shooting interval. If the maximum total number of images uploaded in each time interval accounts for a larger proportion of the total number of images uploaded in each time interval than the confidence level, the second time interval is considered reliable and images are uploaded according to the second time interval.

10. A system for verifying photographic parameters of an online monitoring device in the field of power transmission according to claim 9, characterized in that: The system also includes a second verification module; The second inspection module is used to traverse the monitoring devices in the first data set and obtain the capture interval of each monitoring device in the first data set. If the capture interval is not equal to the capture time of each image, it is determined that the capture interval of each monitoring device in the first data set is wrong, and the capture interval acquisition instruction is re-issued to the monitoring device to correct the first data set.

Images