CN104573047A - Transformer substation factory boundary noise statistics and analysis method - Google Patents

Abstract

The invention discloses a statistical analysis method for noise at the boundary of a substation. The statistical analysis method for noise at the boundary of a substation includes statistics of monitoring results of noise at the boundary of the substation, noise emission levels at the boundary of the factory, and analysis of the noise compliance at the boundary of the substation. Acoustic environment planning in the region, judging whether the noise at the boundary of the substation is up to standard, calculating the rate of compliance, and at the same time linking substations that exceed the standard, finding substations that exceed the standard, and providing a basis for taking relevant control measures. Provide a basis for selecting the appropriate operating parameters for the transformer.

Description

Statistical Analysis Method of Substation Boundary Noise

technical field

The invention relates to a statistical analysis method for substation boundary noise, which belongs to the technical field of substation environmental monitoring.

Background technique

As the voltage level rises, the impact of the operation of power transmission and transformation equipment on surrounding residents increases significantly. For example: inside and outside the substation and around residential buildings near high-voltage lines, if the audible noise generated by high-voltage lines exceeds the standard, it will affect the normal life of residents, especially in rainy days, high-voltage lines that exceed the standard often produce large noises, accompanied by spark Discharge causes certain psychological fear to the residents, and has a great impact on the production and life of the residents and the whole society. Noise is a typical environmental parameter of the power grid. If it is not strictly controlled, it will inevitably affect people's life and health. Especially with the acceleration of urbanization, the public is more and more closely exposed to more substations and transmission lines. , There are more and more complaints about the noise of the power grid, which seriously endangers the stability of the society and the sustainable development of enterprises.

Contents of the invention

The technical problem to be solved by the present invention is to provide a noise statistical analysis method at the boundary of a transformer substation, realize the analysis of the noise at the boundary of the transformer substation, and provide a basis for selecting suitable operating parameters for the transformer.

In order to solve the above technical problems, the present invention provides a statistical analysis method for substation boundary noise, which is characterized in that it includes the following steps:

1) Statistics of noise monitoring results at the substation boundary:

11) Obtain the source of the main transformer noise data for substation monitoring, and the data source is stored in the system database;

12) The data source includes voltage level value, substation type, daytime factory boundary noise and nighttime factory boundary noise; the data source is stored in the system database physical table SY_DWJCYSJL;

13) Through the SQL language operation table SY_DWJCYSJL, the number of substations and the minimum, maximum and average values of the daytime factory boundary noise and nighttime factory boundary noise are obtained by grouping voltage levels and substation types, and the results of each voltage level and each type are obtained. The number of substations and the maximum, minimum and average values of daytime factory boundary noise and nighttime factory boundary noise;

14) Query results through SQL statement and physical table association analysis, and display the results in a dynamic and intuitive form with the FusionCharts plug-in;

2) To calculate the noise emission level at the substation boundary, including the following steps:

21) Prepare to obtain the source of the main transformer noise data for substation monitoring, and the data source is stored in the system database;

22) The data source includes the voltage level value, the substation type in the data source, the daytime factory boundary noise in the data source, the nighttime factory boundary noise, the time period and the daytime and nighttime factory boundary noise level limit; the data source is stored in the system database physical table SY_DWJCYSJL middle;

23) Through the SQL statement, the proportion and quantity of daytime and night-time noise values of categories 0, 1, 2, 3, and 4 are obtained by grouping by time period, voltage level, and substation type, and the status of each level is obtained ;

14) Query results through SQL statements and physical table association analysis, and display the results in a dynamic and intuitive form with the FusionCharts plug-in.

3) Analyze the noise compliance of the substation boundary. According to the acoustic environment planning of the area where the substation is located, judge whether the noise of the substation boundary is up to the standard, calculate the compliance rate, and link the substations that exceed the standard, find the substation that exceeds the standard, and provide a basis for taking relevant control measures.

31) Prepare to obtain the main transformer noise data source for substation monitoring. The data source is stored in the system database (DB2). The data source includes voltage level value, substation type, daytime factory boundary noise, nighttime factory boundary noise, time period and acoustic environment function Classification; the data source is stored in the system database physical table (SY_DWJCYSJL);

32) Through the SQL statement, grouped by time period, equal pressure level, and substation type, the total number of substations of category 1, category 2, category 3, and category 4, the number of substations exceeding the standard, and the percentage of the standard are obtained; this statistics uses javascript JQuery, SQL, Java language and FusionCharts;

33) Query the results through SQL statement and physical table association analysis, and display the results in a dynamic and intuitive form with the FusionCharts plug-in.

The beneficial effect achieved:

The noise statistical analysis method at the substation boundary of the present invention analyzes the noise at the boundary of the substation from three aspects: the statistics of the monitoring results of the noise at the boundary, the emission level of the noise at the boundary, and the compliance of the noise of the substation through the above steps. Provide a basis for selecting the appropriate operating parameters for the transformer.

Description of drawings

Fig. 1 is a flow chart showing the statistical analysis method of the main transformer noise of the present invention.

Detailed ways

The noise statistics at the transformer substation boundary of the present invention analyze the noise at the boundary of the transformer substation from three aspects: the statistics of the noise monitoring results at the boundary of the transformer, the emission level of the noise at the boundary of the factory, and the compliance of the noise of the transformer substation.

1. Statistics of noise monitoring results at substation boundary

The day and night noise levels of substations with different voltage levels are counted indoors and outdoors, and the advantages and disadvantages of the boundary noise of different types of substations are compared as a whole.

1) Obtain the source of the main transformer noise data for substation monitoring, and the data source is stored in the system database (DB2);

2) The data source includes voltage level value, substation type, daytime factory boundary noise and nighttime factory boundary noise; the data source is stored in the system database physical table (SY_DWJCYSJL);

Table 1 is FPUS.SY_DWJCYSJL:

data item (logical name) data item (physical name) length type test ID ID 20 number Substation ID RPT_TASKID 20 number Transformation level of substation BYDJ 20 character the SUPERFORMID 500 character Creator ID NEWUSERID the BIGINT creator time NEWTIME the TIMESTAMP Updater ID UPDUSERID the BIGINT updater time UPD TIME the TIMESTAMP the DTS_TWO_WAY_FLAG the SMALLINT Substation name SUBSTATION_NAME 100 character coordinate COORDINATE 20 character Basic location of substation ADDRESS 200 character Substation type SUBSTATION_TYPE1 3 character Are there any sensitive spots around? POINT 1 character Type of incoming and outgoing lines IMPORT_LINE 2 character Is there any dispute DISPUTE 1 character noise processing NOISE 1 character Sensitive point situation POINT_MEMO 1000 character Description of the dispute DISPUTE_MEMO 1000 character Description of Noise Control NOISE_MEMO 1000 character image ID IMAGEID 20 character Remark MEMO 1000 character monitoring date JCRQ the DATE ambient temperature HJWD 10 character environment humidity HJSD 10 character weather T Q 10 character wind speed FS 10 character Instrument name, model and serial number YQMCXHBH2 200 character Acoustic Environment Function Zoning SHJGNQH 10 character Monitoring time daytime JCSJZJ2 50 character Monitoring time at night JCSJYJ2 50 character Condition GK 500 character Calibrator label wxya 500 character Calibration value before monitoring JCQJZZ 500 character Calibration value after monitoring JCHJZZ 500 character Monitoring Schematic Ginger JCSYT 500 character Remark BZ2 500 character Point description E DWMSE 100 character Point DescriptionS DWMSS 100 character Point description W DWMSW 100 character Point DescriptionN DWMSN 100 character diurnaldbE1 ZJDBE1 100 character diurnaldbE2 ZJDBE2 100 character diurnaldbE3 ZJDBE3 100 character diurnaldbE4 ZJDBE4 100 character diurnal dbS1 ZJDBS1 100 character diurnal dbS2 ZJDBS2 100 character diurnal dbS3 ZJDBS3 100 character diurnal dbS4 ZJDBS4 100 character diurnal dbW1 ZJDBW1 100 character diurnal dbW2 ZJDBW2 100 character diurnaldbW3 ZJDBW3 100 character diurnaldbW4 ZJDBW4 100 character diurnal dbN1 ZJDBN1 100 character diurnaldbN2 ZJDBN2 100 character diurnaldbN3 ZJDBN3 100 character diurnaldbN4 ZJDBN4 100 character night dbE1 YJDBE1 100 character nocturnal dbE2 YJDBE2 100 character nocturnal dbE3 YJDBE3 100 character night dbE4 YJDBE4 100 character night dbS1 YJDBS1 100 character dbS2 at night YJDBS2 100 character night dbS3 YJDBS3 100 character night dbS4 YJDBS4 100 character night dbW1 YJDBW1 100 character night dbW2 YJDBW2 100 character night dbW3 YJDBW3 100 character night dbW4 YJDBW4 100 character nocturnal dbN1 YJDBN1 100 character nighttime dbN2 YJDBN2 100 character nocturnal dbN3 YJDBN3 100 character night dbN4 YJDBN4 100 character Whether it exceeds the standard E1 SFCBE1 5 character Whether it exceeds the standard E2 SFCBE2 5 character Whether it exceeds the standard E3 SFCBE3 5 character Whether it exceeds the standard E4 SFCBE4 5 character Whether it exceeds the standard S1 SFCBS1 5 character Whether it exceeds the standard S2 SFCBS2 5 character Whether it exceeds the standard S3 SFCBS3 5 character Whether it exceeds the standard S4 SFCBS4 5 character Whether it exceeds the standard W1 SFCBW1 5 character Whether it exceeds the standard W2 SFCBW2 5 character Whether it exceeds the standard W3 SFCBW3 5 character Whether it exceeds the standard W4 SFCBW4 5 character Whether it exceeds the standard N1 SFCBN1 5 character Whether it exceeds the standard N2 SFCBN2 5 character Whether it exceeds the standard N3 SFCBN3 5 character Whether it exceeds the standard N4 SFCBN4 5 character project name XMMC3 100 character Instrument name, model and serial number YQMCXHBH3 200 character Monitoring time daytime JCSJZJ3 50 character Monitoring time at night JCSJYJ3 50 character Remark BZ3 500 character measuring person CLR 50 character Reviewer SHR 50 character

3) Through the SQL language operation table (SY_DWJCYSJL), obtain the number of substations and the minimum, maximum and average values of the daytime factory boundary noise and nighttime factory boundary noise by voltage level and substation type grouping, and obtain the substations at each voltage level and each The number of substations under the type and the maximum, minimum and average values of daytime factory boundary noise and nighttime factory boundary noise. This statistics uses javascript JQuery, SQL, Java language and FusionCharts.

4) Query results through SQL statement and physical table association analysis, and display the results in a dynamic and intuitive form with the FusionCharts plug-in.

2. Noise emission level at substation boundary

The number and proportion of the acoustic environment categories reached by the day and night boundary noise of different types of substations are counted, and the contribution of different types of substations to the surrounding environmental noise is generally analyzed.

Specifically include the following steps:

1) Prepare to obtain the main transformer noise data source for substation monitoring, and the data source is stored in the system database (DB2);

2) The data source includes the voltage level value, the substation type in the data source, the daytime plant boundary noise, the nighttime plant boundary noise in the data source, the time period and the day and night plant boundary noise level limit; the data source is stored in the physical table of the system database ( SY_DWJCYSJL);

3) Through the SQL statement, the proportion and quantity of daytime and night-time noise values of categories 0, 1, 2, 3, and 4 are obtained by grouping by time period, voltage level, and substation type, and the status of each level is obtained. ;This statistics uses javascript JQuery, SQL, Java language and FusionCharts;

4) Query results through SQL statement and physical table association analysis, and display the results in a dynamic and intuitive form with the FusionCharts plug-in.

3. Analysis of Noise Reaching Standards at Substation Boundary

According to the acoustic environment planning of the area where the substation is located, it is judged whether the noise at the boundary of the substation reaches the standard, and the compliance rate is calculated. At the same time, the substations that exceed the standard are linked to find the substation that exceeds the standard, so as to provide a basis for taking relevant control measures.

1) Prepare to obtain the main transformer noise data source for substation monitoring. The data source is stored in the system database (DB2). The data source includes voltage level value, substation type, daytime factory boundary noise, nighttime factory boundary noise, time period and acoustic environment function Classification; the data source is stored in the system database physical table (SY_DWJCYSJL);

2) Through SQL statements, grouped by time period, equal pressure level, and substation type, the total number of substations of category 1, category 2, category 3, and category 4, the number of substations reaching the standard and the percentage of reaching the standard are obtained; this statistics uses javascript JQuery, SQL, Java language and FusionCharts;

3) Query results through SQL statement and physical table association analysis, and display the results in a dynamic and intuitive form with the FusionCharts plug-in.

The above descriptions are only preferred embodiments of the present invention, and are not intended to limit the present invention in any form. Any simple modifications made to the above embodiments according to the technical essence of the present invention, equivalent changes and modifications, all belong to this invention. within the scope of the technical solution of the invention.

Claims (2)

1. A method for statistical analysis of transformer substation boundary noise, is characterized in that, comprises the following steps: 1) Statistics of noise monitoring results at the substation boundary: 11) Obtain the source of the main transformer noise data for substation monitoring, and the data source is stored in the system database; 12) The data source includes voltage level value, substation type, daytime factory boundary noise and nighttime factory boundary noise; the data source is stored in the system database physical table SY_DWJCYSJL; 13) Through the SQL language operation table SY_DWJCYSJL, the number of substations and the minimum, maximum and average values of the daytime factory boundary noise and nighttime factory boundary noise are obtained by grouping voltage levels and substation types, and the results of each voltage level and each type are obtained. The number of substations and the maximum, minimum and average values of daytime factory boundary noise and nighttime factory boundary noise; 14) Query results through SQL statements and physical table association analysis, and display the results in a dynamic and intuitive form with the FusionCharts plug-in; 2) To calculate the noise emission level at the substation boundary, including the following steps: 21) Prepare to obtain the source of the main transformer noise data for substation monitoring, and the data source is stored in the system database; 22) The data source includes the voltage level value, the substation type in the data source, the daytime factory boundary noise in the data source, the nighttime factory boundary noise, the time period and the daytime and nighttime factory boundary noise level limit; the data source is stored in the system database physical table SY_DWJCYSJL middle; 23) Through the SQL statement, the proportion and quantity of daytime and night-time noise values of categories 0, 1, 2, 3, and 4 are obtained by grouping by time period, voltage level, and substation type, and the status of each level is obtained ; 24) Query results through SQL statements and physical table association analysis, and display the results in a dynamic and intuitive form with FusionCharts plug-ins; 3) Analyze the noise compliance of the substation boundary. According to the acoustic environment planning of the area where the substation is located, judge whether the noise of the substation boundary is up to the standard, calculate the compliance rate, and link the substations that exceed the standard, find the substation that exceeds the standard, and provide a basis for taking relevant control measures. 2. The statistical analysis method for substation boundary noise according to claim 1, characterized in that, in the step 3), specifically comprising the following steps: 31) Prepare to obtain the source of main transformer noise data for substation monitoring. The data source is stored in the system database. The data source includes voltage level value, substation type, daytime factory boundary noise, nighttime factory boundary noise, time period and acoustic environment function classification; data The source is stored in the system database physical table SY_DWJCYSJL; 32) Through the SQL statement, grouped by time period, equal pressure level, and substation type, the total number of substations of category 1, category 2, category 3, and category 4, the number of substations exceeding the standard, and the percentage of the standard are obtained; this statistics uses javascript JQuery, SQL, Java language and FusionCharts; 33) Query the results through SQL statement and physical table association analysis, and display the results in a dynamic and intuitive form with the FusionCharts plug-in.