CN107124035B - Method and device for processing station area identification information - Google Patents

Abstract

The invention discloses a method for processing station area identification information, which comprises the following steps: importing a meter information list, a transformer and a general list of a power grid marketing system into a processing terminal to form a local database; carrying out WIFI connection on the processing terminal and a detection extension, wherein the detection extension is a WIFI hotspot; receiving a detection result of the power supply point of the detection extension as the detected meter box; screening a user list meeting the conditions according to meter reading line information corresponding to a power point at a measured meter box; converting the detection result, and associating the converted detection result with the user list meeting the conditions; the processing terminal uploads the associated local database to a management server, and the invention also discloses a corresponding processing device. The method and the device can realize automatic acquisition of the information of the transformer area, and have the characteristics of high efficiency and high accuracy.

Description

Method and device for processing station area identification information

Technical Field

The invention belongs to the technical field of power system detection, and particularly relates to a method and a device for processing district identification information.

Background

The power utilization management department often needs to generally survey user data of various transformer districts, including which transformer the user is by which transformer power supply, by which busbar branch power supply (a transformer may have a plurality of branch busbars), by which looks power supply etc. to realize the refined management of transformer district, thereby provide real accurate basic data for consumption reduction and loss reduction.

Currently, to realize the refined management of the station area, a station area user identifier (also called a station area user query instrument, a business survey instrument, or the like) is generally used to determine the station area information and the phase of the user.

Usually, the station area user identification instrument adopts a power line carrier communication mode, and at the same time, when the station user identification information is managed, a manual input method is usually adopted.

Disclosure of Invention

The technical problem to be solved by the present invention is to provide a method and an apparatus for processing station zone identification information, which can realize automatic acquisition of user station zone identification information and have high accuracy.

In order to solve the above technical problem, the present invention provides a method for processing station area identification information, comprising the following steps:

the method comprises the steps of importing a meter information list, a transformer and a general list of a power grid marketing system into a processing terminal to form a local database, wherein the meter information list at least comprises the following components: the user number, the meter reading route, the sequence number, the station office number, the user name and the electricity utilization address corresponding to each user, wherein the transformer and the general table list at least comprise: the number plate of the transformer and the information of the general table bureau are compiled;

carrying out WIFI connection on the processing terminal and a detection extension, wherein the detection extension is a WIFI hotspot;

receiving a detection result of a power supply point at a detected meter box of a detection extension, wherein the detection result at least comprises a station area code, a current clamp number, a phase, a branch current and acquisition time;

screening a user list meeting the conditions according to meter reading line information corresponding to a power point at a measured meter box;

converting the detection result, and associating the converted detection result with the qualified user list, wherein the converted detection result at least comprises: the method comprises the following steps of (1) setting a number plate of a transformer, setting a general table office, setting a current clamp number, setting a cabinet number, numbering branches, phase difference of the branches, and acquiring time information of the branch current;

and the processing terminal uploads the associated local database to a management server.

Wherein, further include after the step of leading in table meter information list, transformer and summary table list of electric wire netting marketing system:

and in the local database of the processing terminal, a corresponding total table office is associated with each user to compile a transformer registration number, and the relation between the station area code and the transformer registration number is determined.

The step of screening the user list meeting the conditions according to the meter reading line information corresponding to the power point at the position of the meter box to be tested specifically comprises the following steps:

and filling the current meter reading line number and the value or/and the sequence number range of the sequence number in a local database, and searching to obtain a user list meeting the conditions.

Wherein, the step of associating the converted detection result with the qualified user list specifically comprises:

and filling the converted detection result into a corresponding column of each user list meeting the conditions.

Wherein, further include: and when the detection result is abnormal, recording and storing the related information.

Correspondingly, the invention also provides a device for processing the station area identification information, which comprises:

the data import module is used for importing a meter information list, a transformer and a general list of the power grid marketing system to form a local database, wherein the meter information list at least comprises: the user number, the meter reading route, the sequence number, the station office number, the user name and the electricity utilization address corresponding to each user, wherein the transformer and the general table list at least comprise: the number plate of the transformer and the information of the general table bureau are compiled;

the WIFI connection module is used for carrying out WIFI connection with a detection extension, wherein the detection extension is a WIFI hotspot;

the detection result receiving module is used for receiving the detection result of the power supply point at the position of the meter box to be detected, wherein the detection result at least comprises a station area code, a current clamp number, a phase, a branch current and acquisition time;

the user screening module is used for screening a user list meeting the conditions according to meter reading line information corresponding to the power point at the meter box to be tested;

a data association module, configured to convert the detection result and associate the converted detection result with the qualified user list, where the converted detection result at least includes: the method comprises the following steps of (1) setting a number plate of a transformer, setting a general table office, setting a current clamp number, setting a cabinet number, numbering branches, phase difference of the branches, and acquiring time information of the branch current;

and the data uploading module is used for uploading the associated local database to a management server.

Wherein, further include: and the parameter setting module is used for coding a transformer registration number for each user associated with the corresponding general table office and determining the relationship between the area code and the transformer registration number in the local database.

The user screening module screens users in the following modes:

and filling the current meter reading line number and the value or/and the sequence number range of the sequence number in a local database, and searching to obtain a user list meeting the conditions.

Wherein the data association module comprises:

and the filling module is used for filling the converted detection result into a corresponding column of each user list meeting the conditions.

Wherein, further include:

and the exception handling module is used for recording and storing the related information when the detection result is abnormal.

The implementation of the invention has the following beneficial effects:

according to the processing method and the processing device for the platform area identification information, provided by the invention, the detection result from the detection extension can be automatically received through the processing device, and the platform area identification information is associated with the stored power grid marketing data after being identified, so that the automatic acquisition of the detection data is realized; on one hand, the abnormity of information disorder and the like caused by manually collecting mass information is avoided, and the accuracy of data collection is ensured; on the other hand, the collection process is also intelligentized and simplified, and a large amount of manpower and material resources are saved.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.

Fig. 1 is a schematic diagram of an application environment of a method for processing area identification information according to the present invention;

fig. 2 is a schematic main flow chart of an embodiment of a method for processing area identification information according to the present invention;

FIG. 3 is a schematic diagram of the meter and user information list imported from the marketing system of FIG. 2;

FIG. 4 is a schematic diagram of the transformer and summary table list imported from the marketing system of FIG. 2;

FIG. 5 is a schematic view of an interface for setting parameters in FIG. 2;

FIG. 6 is a schematic diagram of the filtered list of satisfactory users of FIG. 2;

FIG. 7 is a schematic diagram of the user list of FIG. 2 associated with the transformed test results;

fig. 8 is a schematic structural diagram of an embodiment of a device for processing station identification information according to the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

Fig. 1 is a schematic diagram of an application environment of a method for processing station identification information according to the present invention. In this application environment, including setting up in the detection host computer 2 of distribution transformer 1 end and setting up in the detection extension 4 of being surveyed table case (user) 3, detect host computer 2 with adopt the power line to carry out carrier communication between the detection extension 4, and detect extension 4 and communicate through WIFI with a processing apparatus 6, this processing apparatus 6 can be realized in such as smart mobile phone or panel computer, this processing apparatus 6 communicates or is connected with a electric wire netting marketing system 7 and a management server 8.

Specifically, the host 2 may include the following components: a plurality of voltage terminals for connection to the low voltage side of the distribution transformer 1; at least one zero sequence current transformer, which is used for connecting with the low-voltage end of the distribution transformer 1 to induce the pulse current signal of the low-voltage end of the distribution transformer 1; a phase detection circuit connected to the plurality of voltage terminals and configured to perform phase detection; the host carrier communication circuit is connected with the voltage terminals and is used for injecting carrier signals into the selected voltage terminals or receiving the carrier signals when the power frequency passes through zero; the host pulse current receiving and transmitting circuit is connected with the zero sequence current transformer and is used for receiving and transmitting pulse current signals; the host central processing unit is connected with the phase detection circuit, the host carrier communication circuit and the host pulse current transceiving circuit; the host display screen is connected with the host central processing unit to display information detected or received by the host;

the extension 4 may comprise the following components: the extension carrier communication circuit is connected to the power line of the meter box 3 to be tested and used for receiving and transmitting carrier signals; the extension pulse current receiving and sending circuit is connected to a power line of the meter box 3 to be tested and is used for receiving and sending pulse current signals; the extension WIFI communication module is connected with the extension central processing unit, the extension 4 communicates with the processing device 6 through the extension WIFI communication module so as to send information detected or received by the extension 4 to the processing device 6, and the processing device 6 can be equipment such as a smart phone with a WIFI communication function, a tablet computer and the like.

When station area information is identified, connecting the detection branch to a power line at a power supply point of a measured meter box end at a position needing to be measured; the detection host is connected to each branch outgoing line of the transformer; the detection host and the detection extension are communicated through power line carriers;

sending a pulse current to the power grid through detecting the pulse current sending and receiving circuits of the extension; at the detection host end, the pulse current signal is detected through a zero sequence current transformer and is detected through a phase detection circuit, so that information such as a transformer area, a transformer and a phase connected to the user end which sends the pulse circuit is determined;

the host computer carrier communication circuit controls the power frequency zero crossing to inject a specific carrier signal, the carrier signal carries the information of the station area, the transformer, the phase and the like, and the carrier signal is sent to the power network and received by the detection extension; the corresponding detection extension receives the carrier signal from the power grid through an extension carrier communication circuit, and corresponding information is identified through demodulation processing and signal harmonic analysis processing; and displayed at the extension or sent to the processing device.

The above briefly describes the process of detecting and identifying the station area information according to the present invention, and the following describes the process of processing the identified station area identification information according to the present invention.

As shown in fig. 2, a main flow diagram of an embodiment of a method for processing station identification information provided by the present invention is shown. In this embodiment, the method is implemented in the processing terminal 6, and specifically, the method includes the following steps:

step S10, a meter information list, a transformer and a general list of the power grid marketing system are imported into the processing terminal to form a local database, wherein the meter information list at least comprises: the user number, the meter reading route, the sequence number, the station office number, the user name and the electricity utilization address corresponding to each user, wherein the transformer and the general table list at least comprise: the number plate of the transformer and the information of the general table bureau are compiled; specifically, the processing terminal can import the information through an SD card storing the information of the power grid marketing system, and can also import the information through communication with the power grid marketing system; as shown in fig. 3 and 4, a schematic diagram of an imported meter information list and a transformer and summary list are shown, respectively;

then, in the process of parameter setting, in the local database, a total table office corresponding to each user is associated with a transformer hang tag number, and a relationship between the zone code and the transformer hang tag number is determined, as shown in fig. 5, which is an interface schematic diagram for parameter setting, in which a relationship between the zone code, the transformer hang tag number, the total table office, the concentrator, the current clamp number, the cabinet number, and the branch number can be set.

Step S11, carrying out WIFI connection on the processing terminal and a detection extension set, wherein the detection extension set is set as a WIFI hotspot;

step S12, receiving the detection result of the power supply point of the detection extension as the detected meter box, wherein the detection result at least comprises a station area code, a current clamp number, a phase, a branch current and acquisition time; for example, after the processing terminal is successfully connected with the detection extension, the detection extension sends an information sending request to the processing terminal, and displays options such as "receive" and "reject" on the processing terminal, and after the "receive" is selected, the processing terminal receives a character string similar to "0012-02-a-100-;

step S13, according to meter reading circuit information corresponding to the power point at the meter box to be tested, screening a user list meeting the conditions; specifically, a current meter reading line number and a sequence number value or/and a sequence number range are/is filled in a local database, and retrieval is carried out to obtain a user list meeting conditions. For example, in step S13, after the concentrator corresponding to the meter box to be measured is input and "02003472" is input in the meter reading route number, 44, 101, and 102 may be input in the "single value" boxes in the sequence number, respectively; inputting' 93-95, 111-; namely, the user list with meter reading route number of 02003472 and sequence number of 44, 101, 102, 93-95, 111-123 can be screened out, as shown in fig. 6, that is, the schematic diagram of the screened-out user list meeting the requirement;

step S14, converting the detection result, and associating the converted detection result with the qualified user list, wherein the converted detection result at least includes: the method comprises the following steps of (1) setting a number plate of a transformer, setting a general table office, setting a current clamp number, setting a cabinet number, numbering branches, phase difference of the branches, and acquiring time information of the branch current;

for example, after the list of users meeting the requirement is screened in step S14, at least a part of the users may be selected (7 pieces of user information are selected in fig. 6), and after the selection of the information pieces is completed, the processing terminal may convert the information transmitted by the extension to be detected into form information by clicking a confirmation key, as shown in table 1 below:

TABLE 1 results of the converted measurements

Transformer hanging plate number

General table office

Current clamp number

Cabinet number

Branch numbering

Phase difference of branch

Branch current (A)

Time of acquisition

2000405387

E11115459

1

P03

40101

A

100

2016/10/16 10:15

Then, the converted detection result is filled into a corresponding field of each user list meeting the condition, for example, fig. 7 is a schematic diagram of the user list associated with the converted detection result information; it can be seen from this that it fills information such as acquisition time, concentrator, current clamp number, cabinet number, branch number, phase, branch current, etc. into the selected user on the basis of fig. 6, and changes the acquisition state from "to be acquired" to "acquired".

Step S15, the processing terminal uploads the associated local database to a management server.

It can be understood that when the detection result is abnormal, the related information is recorded and stored, and the recording can be combined with the form of photographing or pictures.

Meanwhile, in a local database, data query can be carried out by inputting a meter reading route number, a sequence number, a general bureau compiling, a collecting condition, a date, an address and a user number; and these can be easily exported and stored on other storage media.

It can be understood that, in the implementation process of the present invention, after the staff sends the low-voltage pulse current signal at the terminal site and receives the confirmation information (the transformer code and the current clamp number) sent back by the host via the carrier, it knows that the power point to be measured is measured by a current clamp of a certain transformer, and according to the transformer hang tag number, the total table office and the cabinet number and branch number corresponding to each current clamp which are preset transformer code, it naturally forms which cabinet number and branch supplied load of which transformer the power point to be measured is, at this time, the meter reading line number (example 02003274), sequence number (a certain number 15 or a certain digital section) and station number (similar to the meter of the resident terminal user) corresponding to the power point to be measured are input, since the meter reading line number and sequence number are the pre-imported marketing information, they are associated with the information of the terminal user, therefore, each terminal meter is finally associated with the transformer, the general table bureau, the cabinet number of the low-voltage metering cabinet and the branch number, and the automatic acquisition of the station area identification information is finally realized.

Accordingly, in another aspect of the present invention, there is also provided a processing apparatus for processing station area identification information, as shown in fig. 8, which shows a schematic structural diagram of an embodiment, in which the processing apparatus 6 includes:

the data import module 60 is configured to import a meter information list, a transformer and a summary list of the power grid marketing system to form a local database, where the meter information list at least includes: the user number, the meter reading route, the sequence number, the station office number, the user name and the electricity utilization address corresponding to each user, wherein the transformer and the general table list at least comprise: the number plate of the transformer and the information of the general table bureau are compiled;

the WIFI connection module 62 is used for carrying out WIFI connection with a detection extension, wherein the detection extension is a WIFI hotspot;

the detection result receiving module 63 is configured to receive a detection result of a power supply point at a meter box to be detected, where the detection result at least includes a station area code, a current clamp number, a phase, a branch current, and an acquisition time;

the user screening module 63 is used for screening a user list meeting the conditions according to the meter reading line information corresponding to the power point at the meter box to be tested; specifically, the user filtering module 63 filters the users in the following manner: filling a current meter reading line number and a sequence number value or/and a sequence number range in a local database, and searching to obtain a user list meeting conditions;

a data association module 64, configured to convert the detection result and associate the converted detection result with the qualified user list, where the converted detection result at least includes: the method comprises the following steps of (1) setting a number plate of a transformer, setting a general table office, setting a current clamp number, setting a cabinet number, numbering branches, phase difference of the branches, and acquiring time information of the branch current; the data association module 64 includes a padding module (not shown) for padding the converted detection result into a corresponding field of each of the qualified user lists;

a data uploading module 65, configured to upload the associated local database to a management server;

the parameter setting module 66 is used for compiling a transformer listing number for each user associated with the corresponding general table office in the local database and determining the relationship between the area code and the transformer listing number;

and the exception handling module 67 is used for recording and storing relevant information when the detection result is abnormal.

Further details, which may be combined with the descriptions of fig. 2 to 7, are not described in detail here.

The implementation of the invention has the following beneficial effects:

according to the processing method and the processing device for the platform area identification information, provided by the invention, the detection result from the detection extension can be automatically received through the processing device, and the platform area identification information is associated with the stored power grid marketing data after being identified, so that the automatic acquisition of the detection data is realized; on one hand, the abnormity of information disorder and the like caused by manually collecting mass information is avoided, and the accuracy of data collection is ensured; on the other hand, the collection process is also intelligentized and simplified, and a large amount of manpower and material resources are saved.

While the invention has been described in connection with what is presently considered to be the most practical and preferred embodiment, it is to be understood that the invention is not to be limited to the disclosed embodiment, but on the contrary, is intended to cover various modifications and equivalent arrangements included within the spirit and scope of the appended claims.

Claims (8)

1. A method for processing station zone identification information is characterized by comprising the following steps:

the method comprises the steps of importing a meter information list, a transformer and a general list of a power grid marketing system into a processing terminal to form a local database, wherein the meter information list at least comprises the following components: the user number, the meter reading route, the sequence number, the station office number, the user name and the electricity utilization address corresponding to each user, wherein the transformer and the general table list at least comprise: the number plate of the transformer and the information of the general table bureau are compiled;

in the local database of the processing terminal, a corresponding total table office is associated with each user to compile a transformer registration number, and the relation between the area code and the transformer registration number is determined;

when station area information is identified, connecting the detection branch to a power line at a power supply point of a measured meter box end at a position needing to be measured; the detection host is connected to each branch outgoing line of the transformer; the detection host and the detection extension are communicated through power line carriers;

sending a pulse current to the power grid through detecting the pulse current sending and receiving circuits of the extension; at the detection host end, the pulse current signal is detected through a zero sequence current transformer and is detected through a phase detection circuit, so that a transformer area, a transformer and phase information connected with a user end which sends the pulse circuit are determined;

the host computer carrier communication circuit controls the power frequency zero crossing to inject a specific carrier signal, the carrier signal carries the station area, the transformer and the phase information, and the carrier signal is sent to the power network and received by the detection extension; the corresponding detection extension receives the carrier signal from the power grid through an extension carrier communication circuit, and corresponding information is identified through demodulation processing and signal harmonic analysis processing;

carrying out WIFI connection on the processing terminal and a detection extension, wherein the detection extension is a WIFI hotspot;

receiving a detection result of a power supply point at a detected meter box of a detection extension, wherein the detection result at least comprises a station area code, a current clamp number, a phase, a branch current and acquisition time;

screening a user list meeting the conditions according to meter reading line information corresponding to a power point at a measured meter box;

converting the detection result, and associating the converted detection result with the qualified user list, wherein the converted detection result at least comprises:

the method comprises the following steps of (1) setting a number plate of a transformer, setting a general table office, setting a current clamp number, setting a cabinet number, numbering branches, phase difference of the branches, and acquiring time information of the branch current;

and the processing terminal uploads the associated local database to a management server.

2. The method for processing the transformer area identification information according to claim 1, wherein the step of screening the qualified user list according to the meter reading line information corresponding to the power point at the meter box to be tested specifically comprises the steps of:

and filling the current meter reading line number and the value or/and the sequence number range of the sequence number in a local database, and searching to obtain a user list meeting the conditions.

3. The method for processing the station area identification information according to claim 2, wherein the step of associating the converted detection result with the qualified user list specifically comprises:

and filling the converted detection result into a corresponding column of each user list meeting the conditions.

4. The method for processing station area identification information according to claim 3, further comprising:

and when the detection result is abnormal, recording and storing the related information.

5. A station area identification information processing apparatus, characterized in that:

the data import module is used for importing a meter information list, a transformer and a general list of the power grid marketing system to form a local database, wherein the meter information list at least comprises: the user number, the meter reading route, the sequence number, the station office number, the user name and the electricity utilization address corresponding to each user, wherein the transformer and the general table list at least comprise: the number plate of the transformer and the information of the general table bureau are compiled;

the parameter setting module is used for compiling a transformer registration number for each user associated with the corresponding general table office and determining the relation between the area code and the transformer registration number in the local database;

the detection extension is used for being arranged at a power supply point of a measured meter box end of a position to be measured and connected to a power line when the station area information is identified;

the detection host is used for being connected to each branch outgoing line of the transformer; the detection host and the detection extension are communicated through power line carriers;

the detection branch machine is also used for sending a pulse current to the power grid through the detection branch machine pulse current sending and receiving circuit;

the detection host is also used for detecting the pulse current signal through the zero sequence current transformer and detecting the pulse current signal through the phase detection circuit, so that the transformer area, the transformer and the phase information connected with the user side which sends the pulse circuit are determined;

the detection host is also used for controlling the power frequency zero crossing to inject a specific carrier signal through a host carrier communication circuit, wherein the carrier signal carries the station area, the transformer and the phase information and is sent to the power grid to be received by the detection extension;

the corresponding detection extension is also used for receiving the carrier signal from the power grid through an extension carrier communication circuit, and identifying corresponding information through demodulation processing and signal harmonic analysis processing;

the WIFI connection module is used for carrying out WIFI connection with a detection extension, wherein the detection extension is a WIFI hotspot;

the detection result receiving module is used for receiving the detection result of the power supply point at the position of the meter box to be detected, wherein the detection result at least comprises a station area code, a current clamp number, a phase, a branch current and acquisition time;

the user screening module is used for screening a user list meeting the conditions according to meter reading line information corresponding to the power point at the meter box to be tested;

a data association module, configured to convert the detection result and associate the converted detection result with the qualified user list, where the converted detection result at least includes: the method comprises the following steps of (1) setting a number plate of a transformer, setting a general table office, setting a current clamp number, setting a cabinet number, numbering branches, phase difference of the branches, and acquiring time information of the branch current;

and the data uploading module is used for uploading the associated local database to a management server.

6. The device for processing the station area identification information as claimed in claim 5, wherein the user filtering module filters the users by:

and filling the current meter reading line number and the value or/and the sequence number range of the sequence number in a local database, and searching to obtain a user list meeting the conditions.

7. The device for processing station area identification information as claimed in claim 6, wherein said data association module comprises:

and the filling module is used for filling the converted detection result into a corresponding column of each user list meeting the conditions.

8. The station area identification information processing apparatus as claimed in claim 7, comprising:

and the exception handling module is used for recording and storing the related information when the detection result is abnormal.

Images