Inspection method for multiple households at one address in electric power system

Abstract

The invention provides a one-address multi-household inspection method for a power system, and belongs to the technical field of power system analysis. Comprising the steps of obtaining user information of all high-voltage users and industrial users of a target power supply unit; formatting the power utilization addresses of all users into standard addresses according to the standard names of administrative divisions and roads in the jurisdiction of the target power supply unit; grouping all the users according to the user names, the taxpayer identification numbers and the contact phone numbers, and determining the groups with the user number greater than 1 as a first group, a second group and a third group; fusing all the first groups, all the second groups and all the third groups into a to-be-checked group list; performing clustering analysis on each group in the to-be-checked group list according to the power utilization address, and splitting the corresponding group into new groups according to a clustering result; and traversing the group with more than one user number in the to-be-checked group list, and judging whether the group has a one-address multi-user condition or not according to a one-address multi-user rule.

Description

Technical Field

[0001] The invention belongs to the technical field of power system analysis, and in particular relates to a method for auditing multiple households at one site in a power system. Background Art

[0002] "One address, multiple households" means that a customer opens two or more electricity household numbers at the same electricity address, and splits the electricity capacity, electricity consumption, etc. into different household numbers in order to maintain the original electricity fee level and nature of electricity consumption when expanding production, thereby avoiding the fees to be paid.

[0003] At present, the screening and verification of multiple households at one address mostly rely on traditional manual mode. During manual verification, it is necessary to export customer files and high-voltage user details of the power supply unit separately, and then check the user address, electricity consumption category, transformer capacity, etc. one by one for further analysis, which is inefficient and labor-intensive.

[0004] Therefore, there is a need for an automated means to conduct audits of multiple households at one address. Summary of the invention

[0005] The technical problem to be solved by the present invention is to provide a method for auditing multiple households at one site in an electric power system in view of the deficiencies in the prior art.

[0006] In order to solve the above technical problems, the technical solution adopted by the present invention is: A method for inspecting multiple households at one address in a power system, comprising: Obtain user information of all high-voltage users of the target power supply unit that are industrial users; Format all users' electricity addresses into standard addresses according to the standard names of administrative divisions and roads within the jurisdiction of the target power supply unit; All users are grouped according to user name, taxpayer identification number and contact phone number, and the groups with more than 1 users are respectively determined as the first group, the second group and the third group; Merge all first groups, all second groups and all third groups into a list of groups to be checked; Cluster analysis is performed on each group in the group list to be investigated according to the electricity usage address, and the corresponding group is split into new groups according to the clustering results; Traverse the groups with more than 1 users in the list of groups to be checked, and determine whether the group has multiple households at one address according to the multiple households at one address rule.

[0007] Furthermore, the method for formatting the electricity address into a standard address includes: The standard address includes a five-level address structure, the first level is the administrative districts of the same level such as the city district and the county, the second level is the administrative districts of the same level such as the street, township, town, etc., the third level is the administrative districts of the same level such as the community, village, etc., the fourth level is the address mark such as the road, and the fifth level is the other parts of the address; Perform character normalization on the address to be formatted; Obtain the standard names of all administrative divisions and roads within the jurisdiction of the power supply unit; The electricity address is split from the beginning, the split strings are matched with the standard names of administrative divisions and roads, the first four levels of standard names corresponding to the address are obtained, and the first four levels of standard names and the rest of the address are merged into the standard address.

[0008] Furthermore, the method of merging all the first groups, all the second groups and all the third groups into a list of groups to be checked includes: Traversing the taxpayer identification numbers of all users in the second groups, if the taxpayer identification number in a second group is consistent with the taxpayer identification number of a user in some first groups, merging the second group and all corresponding first groups into a new first group, and deleting the second group; Then, the contact phone numbers of all users in the third group are traversed. If the contact phone number in a certain third group is consistent with the contact phone number of a user in some first groups, the third group and all corresponding first groups are merged into a new first group, and the third group is deleted; Combine all first groups, all second groups, and all third groups into a list of groups to be checked.

[0009] Furthermore, the method of clustering the groups according to the electricity usage addresses includes: Get the longitude and latitude coordinates of all electricity addresses in the group; Convert the longitude and latitude coordinates of the electricity address into points in a three-dimensional Cartesian coordinate system; Cluster analysis was performed using the K-means algorithm in Cartesian space.

[0010] Furthermore, the relevant formula for converting longitude and latitude coordinates to points in a three-dimensional Cartesian coordinate system is: , , , Lng and Lat are longitude and latitude respectively, x, y, z are the coordinates of a point in a three-dimensional Cartesian coordinate system, and R is the radius of the earth.

[0011] Furthermore, the relevant formula for converting the longitude and latitude coordinates into points in the three-dimensional Cartesian coordinate system is: In cluster analysis, the distance between points i and j is: , the coordinates of point i are , the coordinates of point j are .

[0012] Furthermore, the method for obtaining the longitude and latitude coordinates of the electricity usage address includes: determining whether the electricity usage address exists in the longitude and latitude cache data, and if so, directly obtaining the corresponding longitude and latitude coordinates from the cache data; if not, obtaining the longitude and latitude coordinates of the address by reverse geocoding, and storing the address and the corresponding longitude and latitude coordinates in the longitude and latitude cache data.

[0013] Further, the method of applying the K-means algorithm to perform cluster analysis in Cartesian space includes: a. Randomly select K data points as the initial cluster centers; b. For each data point, calculate its distance from each cluster center and assign the data point to the cluster corresponding to the cluster center closest to it; c. For each cluster, calculate the average value of all data points in the cluster and update the cluster center of the cluster to this average value; repeat until the cluster center no longer changes or reaches the predetermined number of iterations; d. Repeat steps b and c until the algorithm converges; e. Output the final cluster to which each data point belongs.

[0014] Furthermore, the user information includes the electricity user number, user name, contact phone number, electricity address, taxpayer identification number, power supply line, power supply area, transformer type, power supply capacity and implemented electricity price.

[0015] Furthermore, the one-address-multiple-households rule includes: If the power supply area of ​​the users in the group is the same, there is a suspicion of evading power factor assessment; If the power supply lines of users in a group are different and the transformer types of users in the group are all special transformers, there is a suspicion of evading high-reliability power supply fees; If the power supply lines of users in a group are the same, but the transformer types and electricity prices are different, there is a suspicion of mixed high and low voltage supply to circumvent the basic electricity fee; If the power supply capacity of each user in the group is less than 160kVA, and the total power supply capacity of all users in the group is greater than 160kVA, there is a suspicion of evading high-voltage investment and household registration; If the power supply capacity of each user in the group is not less than 160kVA and less than 315kVA, and the total power supply capacity of all users in the group is greater than 315kVA, there is suspicion of evading the implementation of the two-part electricity price.

[0016] Compared with the prior art, the present invention has the following beneficial effects: The traditional way of auditing multiple households at one address is to manually repeat the export, screening, classification and identification on the marketing system, which is time-consuming, labor-intensive and error-prone. The present invention can automatically audit multiple households at one address, saving time and effort, and can greatly improve the efficiency of audit work. Through the audit of multiple households at one address, the present invention can effectively control the hidden dangers of electricity bill errors and electricity safety hazards, and improve the quality and efficiency of operations and management. DETAILED DESCRIPTION

[0017] In order to better understand the present invention, the content of the present invention is further clearly set forth in conjunction with the embodiments below, but the protection content of the present invention is not limited to the following embodiments. In the following description, a large number of specific details are provided in order to provide a more thorough understanding of the present invention. However, it is obvious to those skilled in the art that the present invention can be implemented without one or more of these details.

[0018] Embodiment 1: The purpose of this embodiment is to provide a method for auditing multiple households at one address in a power system. The method comprises: S1. Obtain user information of all high-voltage users of the target power supply unit that are industrial users.

[0019] This step uses the data center to obtain data from the electricity information collection system, marketing pipeline system, PMS system, and integrated power and line loss management system. The power supply unit (power supply station level) is used as the screening unit, and high-voltage users, industrial users (large industrial, non-industrial and ordinary industrial users) and 10kV voltage level are used as screening conditions to obtain the user information such as the user number, user name, contact number, electricity address, taxpayer identification number, power supply line, power supply area, transformer type, power supply capacity and execution price of all matching users under the target power supply unit. Among them, the transformer type is divided into special transformer and comprehensive transformer, the power supply capacity is the contract capacity agreed upon by the customer when signing the contract, and the power supply line is the name of the 10kV power supply line directly connected to the customer.

[0020] S2. Format the electricity addresses of all users into standard addresses according to the standard names of administrative divisions and roads within the jurisdiction of the target power supply unit.

[0021] The electricity usage address entered into the current power marketing service system may not be a standard address or an accurate address. To facilitate subsequent steps, the electricity usage address needs to be formatted into a standard address.

[0022] The standard address of this step includes a five-level address structure. The first level is the administrative districts of the same level such as urban districts and counties, the second level is the administrative districts of the same level such as streets, townships, and towns, the third level is the administrative districts of the same level such as communities and villages, the fourth level is address signs such as roads, and the fifth level is other parts of the address.

[0023] First, the address to be formatted is normalized, such as deleting blank characters and invalid characters, converting full-width characters to half-width characters, etc.

[0024] Then, the standard names of all administrative divisions and roads within the jurisdiction of the power supply unit are obtained, the formatted address is split from the beginning, the split strings are matched with the standard names of the administrative divisions, the first four levels of standard names corresponding to the address are obtained, and the first four levels of standard names and the rest of the address are merged into the standard address.

[0025] S3. All users are grouped according to user name, taxpayer identification number and contact phone number, and the groups with more than 1 users are respectively determined as the first group, the second group and the third group.

[0026] All users are grouped according to user name, and the group with more than 1 users in the group is determined as the first group; all users are grouped according to taxpayer identification number, and the group with more than 1 users in the group is determined as the second group; all users are grouped according to contact phone number, and the group with more than 1 users in the group is determined as the third group.

[0027] Among all users, two or more users with the same user name, the same taxpayer identification number or the same contact phone number are users who need to be checked for multiple accounts at one address. Therefore, this step groups all users according to user name, taxpayer identification number and contact phone number, and determines the groups with more than 1 users as the first group, the second group and the third group respectively.

[0028] S4. All first groups, all second groups and all third groups are merged into a list of groups to be checked.

[0029] This step first traverses the taxpayer identification numbers of all users in the second group. If the taxpayer identification number in a second group is consistent with the taxpayer identification number of a user in some first groups, the second group and all corresponding first groups are merged into a new first group, and the second group is deleted.

[0030] Then, the contact phone numbers of users in all third groups are traversed. If the contact phone number in a third group is consistent with the contact phone number of a user in some first groups, the third group and all corresponding first groups are merged into a new first group, and the third group is deleted.

[0031] Finally, all first groups, all second groups and all third groups are combined into a list of groups to be checked.

[0032] S5. Perform cluster analysis on each group in the group list to be checked according to the electricity usage address, and split the corresponding group into new groups according to the clustering results.

[0033] The method for clustering analysis of groups according to electricity usage addresses includes: obtaining the longitude and latitude coordinates of all electricity usage addresses in the group; converting the longitude and latitude coordinates of the electricity usage addresses into points in a three-dimensional Cartesian coordinate system; and applying a K-means algorithm to perform cluster analysis in Cartesian space.

[0034] The method for obtaining the longitude and latitude coordinates of the electricity address includes: firstly determining whether the electricity address exists in the longitude and latitude cache data, and if so, directly obtaining the corresponding longitude and latitude coordinates from the cache data; if not, obtaining the longitude and latitude coordinates of the address by reverse geocoding, and storing the address and the corresponding longitude and latitude coordinates in the longitude and latitude cache data. Reverse geocoding is an existing technology and can also be implemented by a third-party service, which will not be described in detail.

[0035] The relevant formula for converting the latitude and longitude coordinates of the electricity address to a point in the three-dimensional Cartesian coordinate system is: , , , Lng and Lat are longitude and latitude respectively, x, y, z are the coordinates of a point in a three-dimensional Cartesian coordinate system, and R is the radius of the earth.

[0036] In cluster analysis, the distance between points i and j is: .

[0037] The method of applying the K-means algorithm to perform cluster analysis in Cartesian space includes: randomly selecting K data points as initial cluster centers; for each data point, calculating its distance from each cluster center, and assigning the data point to the cluster corresponding to the cluster center closest to it; for each cluster, calculating the average value of all data points in the cluster, and updating the cluster center of the cluster to this average value; repeating the execution until the cluster center no longer changes or a predetermined number of iterations is reached; repeating the data assignment and data point update until the algorithm converges; and outputting the final cluster cluster to which each data point belongs.

[0038] By converting longitude and latitude coordinates into points in the Cartesian coordinate system, distance calculation can be performed in Euclidean space. K-means algorithm is applied to clustering in Cartesian space to divide the data set into multiple clusters according to the spherical distance characteristics between data points. Finally, the cluster to which each data point belongs is output to realize cluster analysis of electricity usage addresses.

[0039] S6. Traverse the groups with a user number greater than 1 in the list of groups to be checked, and determine whether the group has a one-address-multiple-households situation according to the one-address-multiple-households rule.

[0040] If the power supply areas of users in a group are the same, it is judged that the group has multiple households at one address, and there is a suspicion of evading power factor assessment.

[0041] If the power supply lines of users in a certain group are different, and the transformer types of users in the group are all special transformers, it is judged that the group has multiple households at one address, and there is suspicion of evading high-reliability power supply fees.

[0042] If the users in a group have the same power supply lines but different transformer types and electricity prices, it is judged that the group has multiple households at one address, and there is suspicion of mixed high and low voltage supply to circumvent basic electricity charges.

[0043] If the power supply capacity of each user in a group is less than 160kVA, and the total power supply capacity of all users in the group is greater than 160kVA, it is judged that the group has multiple households at one address, and there is suspicion of evading high-voltage investment to establish households.

[0044] If the power supply capacity of each user in a group is not less than 160kVA and less than 315kVA, and the total power supply capacity of all users in the group is greater than 315kVA, then it is judged that the group has multiple households at one address, and there is suspicion of evading the implementation of the two-part electricity price.

[0045] Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention rather than to limit it. Other modifications or equivalent substitutions made to the technical solution of the present invention by ordinary technicians in the field should be included in the scope of the claims of the present invention as long as they do not depart from the spirit and scope of the technical solution of the present invention.

Claims

1. A method for inspecting multiple households at one address in a power system, characterized in that: include: Obtain user information of all high-voltage users of the target power supply unit that are industrial users; Format all users' electricity addresses into standard addresses according to the standard names of administrative divisions and roads within the jurisdiction of the target power supply unit; All users are grouped according to user name, taxpayer identification number and contact phone number, and the groups with more than 1 users are respectively determined as the first group, the second group and the third group; Merge all first groups, all second groups and all third groups into a list of groups to be checked; Cluster analysis is performed on each group in the group list to be investigated according to the electricity usage address, and the corresponding group is split into new groups according to the clustering results; Traverse the groups with more than 1 users in the list of groups to be checked, and determine whether the group has multiple households at one address according to the multiple households at one address rule.

2. The method for checking multiple households at one address in a power system according to claim 1, characterized in that: Methods for formatting telephone addresses into standard addresses include: The standard address includes a five-level address structure, the first level is the administrative districts of the same level such as the city district and the county, the second level is the administrative districts of the same level such as the street, township, town, etc., the third level is the administrative districts of the same level such as the community, village, etc., the fourth level is the address mark such as the road, and the fifth level is the other parts of the address; Perform character normalization on the address to be formatted; Obtain the standard names of all administrative divisions and roads within the jurisdiction of the power supply unit; The electricity address is split from the beginning, the split strings are matched with the standard names of administrative divisions and roads, the first four levels of standard names corresponding to the address are obtained, and the first four levels of standard names and the rest of the address are merged into the standard address.

3. The method for checking multiple households at one address in a power system according to claim 1, characterized in that: The method of merging all first groups, all second groups, and all third groups into a list of groups to be checked includes: Traversing the taxpayer identification numbers of all users in the second groups, if the taxpayer identification number in a second group is consistent with the taxpayer identification number of a user in some first groups, merging the second group and all corresponding first groups into a new first group, and deleting the second group; Then, the contact phone numbers of all users in the third group are traversed. If the contact phone number in a certain third group is consistent with the contact phone number of a user in some first groups, the third group and all corresponding first groups are merged into a new first group, and the third group is deleted; Combine all first groups, all second groups, and all third groups into a list of groups to be checked.

4. The method for checking multiple households at one address in a power system according to claim 1, characterized in that: The method of clustering the groups according to the electricity usage addresses includes: Get the longitude and latitude coordinates of all electricity addresses in the group; Convert the longitude and latitude coordinates of the electricity consumption address into a point in a three-dimensional Cartesian coordinate system; Cluster analysis was performed using the K-means algorithm in Cartesian space.

5. The method for checking multiple households at one address in a power system according to claim 4, characterized in that: The relevant formula for converting latitude and longitude coordinates to points in a three-dimensional Cartesian coordinate system is: , , , Lng and Lat are longitude and latitude respectively, x, y, z are the coordinates of a point in a three-dimensional Cartesian coordinate system, and R is the radius of the earth.

6. The method for checking multiple households at one address in a power system according to claim 4, characterized in that: The relevant formula for converting longitude and latitude coordinates to points in a three-dimensional Cartesian coordinate system is: In cluster analysis, the distance between points i and j is: , the coordinates of point i are , the coordinates of point j are .

7. The method for checking multiple households at one address in a power system according to claim 4, characterized in that: The method for obtaining the longitude and latitude coordinates of the electricity usage address includes: determining whether the electricity usage address exists in the longitude and latitude cache data, and if so, directly obtaining the corresponding longitude and latitude coordinates from the cache data; if not, obtaining the longitude and latitude coordinates of the address by reverse geocoding, and storing the address and the corresponding longitude and latitude coordinates in the longitude and latitude cache data.

8. The method for checking multiple households at one address in a power system according to claim 4, characterized in that: Methods for clustering analysis using the K-means algorithm in Cartesian space include: a. Randomly select K data points as the initial cluster centers; b. For each data point, calculate its distance from each cluster center and assign the data point to the cluster corresponding to the cluster center closest to it; c. For each cluster, calculate the average value of all data points in the cluster and update the cluster center of the cluster to this average value; repeat until the cluster center no longer changes or reaches the predetermined number of iterations; d. Repeat steps b and c until the algorithm converges; e. Output the final cluster to which each data point belongs.

9. The method for checking multiple households at one address in a power system according to claim 1, characterized in that: The user information includes the electricity user number, user name, contact phone number, electricity usage address, taxpayer identification number, power supply line, power supply area, transformer type, power supply capacity and implemented electricity price.

10. The method for checking multiple households at one address in a power system according to claim 1, characterized in that: The one-address-multiple-accounts rule includes: If the power supply area of ​​the users in the group is the same, there is a suspicion of evading power factor assessment; If the power supply lines of users in a group are different and the transformer types of users in the group are all special transformers, there is a suspicion of evading high-reliability power supply fees; If the power supply lines of users in a group are the same, but the transformer types and electricity prices are different, there is a suspicion of mixed high and low voltage supply to circumvent the basic electricity fee; If the power supply capacity of each user in the group is less than 160kVA, and the total power supply capacity of all users in the group is greater than 160kVA, there is a suspicion of evading high-voltage investment and household registration; If the power supply capacity of each user in the group is not less than 160kVA and less than 315kVA, and the total power supply capacity of all users in the group is greater than 315kVA, there is suspicion of evading the implementation of the two-part electricity price.

Images