Intelligent tower equipment type selection method and system based on spatial metadata driving

Abstract

The invention discloses an intelligent tower equipment type selection method and system based on spatial metadata driving, and relates to the technical field of electric power engineering and automation, and the method comprises the steps: extracting the description of a region where a project is located from a power distribution network construction drawing design report, querying and determining the meteorological combination condition of a geographic position according to a meteorological statistical table, and matching meteorological combinations. The method comprises the following steps: matching and comparing tower material codes and module names according to standard typical design in a typical design library, carrying out matching verification on a typical design template, framing a tower type selection range according to a pole load calculation rule, and carrying out pole type selection according to meteorological condition data, calculation technical parameters and a calculation result. By integrating a plurality of modules, full-process automation of tower equipment model selection is realized, the model selection process is simplified, the labor cost is reduced, the project period is shortened, and the overall management level of power grid construction is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of electric power engineering and automation, and particularly to an intelligent tower equipment selection method and system driven by spatial metadata. Background Art

[0002] In the technical field of electric power engineering and automation, the selection of tower equipment in the construction of distribution networks has always been a key and complex link. With the continuous expansion of the power grid scale and the increase in complexity, the limitations of traditional tower equipment selection methods have gradually emerged. These traditional methods mostly rely on manual experience, and by consulting a large number of design drawings and standard manuals, the material codes, module names, and related technical parameters of the towers are matched and verified. The whole process is time-consuming and error-prone.

[0003] In recent years, although some automated tools and database systems have been introduced into the tower equipment selection process, these systems often lack in-depth mining and utilization of spatial metadata. There are still obvious deficiencies in the existing technical means for processing geographical information, meteorological conditions, and tower load calculations in the distribution network construction drawing design report. For example, the existing technologies often cannot effectively extract the geographical location description from the design report, nor can they automatically match the corresponding meteorological combination conditions according to the geographical location, which makes it difficult to improve the accuracy and efficiency of tower selection. Summary of the Invention

[0004] In view of the above existing problems, the present invention provides an intelligent tower equipment selection method and system driven by spatial metadata to solve the problems that the existing technology cannot effectively extract the geographical location description from the design report and cannot automatically match the corresponding meteorological combination conditions according to the geographical location.

[0005] To solve the above technical problems, an intelligent tower equipment selection method driven by spatial metadata is proposed, including,

[0006] extracting the description of the project location area from the distribution network construction drawing design report, querying and determining the meteorological combination conditions of the geographical location according to the meteorological statistical table, and matching the meteorological combination; matching and comparing the tower material codes and module names according to the standard typical designs in the typical design library, and performing matching verification on the typical design template, and defining the tower selection range according to the pole load calculation rule; calculating technical parameters according to the meteorological condition data, and selecting the electric poles according to the calculation results.

[0007] As a preferred solution of the intelligent pole and tower equipment selection method driven by spatial metadata according to the present invention, wherein: the description of extracting the region where the project is located includes automatically extracting text information from the construction drawing design report by using a text parsing tool, identifying and extracting the descriptive text about the region where the project is located in the report, and using natural language processing technology to parse the extracted text, identifying the information of "county / district where it belongs" and "township where it belongs", and converting the text information into geographical codes;

[0008] The querying and determining of the meteorological combination conditions of the geographical location includes connecting to the database of the grid meteorological area statistical table issued by the power grid, using the geographical code as the query keyword, performing a database query, retrieving the meteorological combination conditions that match the geographical code, and determining the meteorological combination conditions of the geographical location according to the query result; the meteorological combination conditions include the annual average wind speed, maximum wind speed, ice coating thickness, and temperature range.

[0009] As a preferred solution of the intelligent pole and tower equipment selection method driven by spatial metadata according to the present invention, wherein: the matching of the meteorological combination includes comparing the extracted meteorological combination conditions with the standard meteorological combination template, using similarity calculation to evaluate the matching degree of the queried meteorological combination and the standard template, and setting a similarity threshold S th , to match the meteorological combination;

[0010] The matching of the meteorological combination further includes that when the calculated similarity exceeds the threshold, it is determined that the meteorological combination is successfully matched; when the similarity is less than or equal to the threshold, it is determined that the meteorological combination conditions to be queried need to be re-evaluated and adjusted. The user interface displays the queried meteorological combination conditions and the matching result, and manually adjusts the weights and thresholds to optimize the matching result.

[0011] As a preferred solution of the intelligent pole and tower equipment selection method driven by spatial metadata according to the present invention, wherein: the matching verification includes extracting the pole and tower material codes and module names from the typical design drawings, matching the extracted codes and module names with the standard codes and names in the typical design library, and using the parsed data in the specification codes to perform matching verification on the typical design template;

[0012] The framing of the pole and tower selection range includes reading the technical parameters of the overhead line conductors and pole parameters according to the annotation model information in the profile diagram and the typical design library table; the technical parameters include the outer diameter of the conductor, cross-section, unit weight, breaking force, wind speed, ice coating thickness, horizontal span, conductor safety factor, and turning angle; the pole parameters include the upper diameter of the pole, pole burial depth, lower diameter of the pole, pole height, windward area of the pole and tower, height of the upper cross-arm from the ground, and height of the lower cross-arm from the ground.

[0013] As a preferred solution of the intelligent tower equipment selection method based on spatial metadata driving according to the present invention, wherein: the framing of the tower selection range further includes framing the tower selection range according to the pole load calculation rules;

[0014] The formula for calculating the tower load is:

[0015] P = W d + W l + W s + W w

[0016] wherein, P is the total load, and W d is the weight of the conductor, W l is the weight of the ice coating, W S is the wind load on the pole, and W w is the external load;

[0017] The formula for calculating the resultant moment of the conductor acting on the pole is:

[0018] M 合 = M + M 大风

[0019] M = F1 * ∑h1 * 1.1

[0020] M 大风 = [W x × ∑h1 + W s × (h1 + h3) / 2] × Q

[0021]

[0022] wherein, M 合 is the resultant moment of the conductor acting on the pole, M is the horizontal moment of the conductor acting on the pole, and M 大风 is the moment in the case of strong wind, F1 is the maximum allowable tension of the conductor, h1 is the height of the upper cross arm from the ground, h3 is the height of the lower cross arm from the ground, F is the breaking force, Q is the additional bending moment coefficient, K is the safety factor of the conductor, and θ is the turning angle.

[0023] As a preferred solution of the intelligent tower equipment selection method based on spatial metadata driving according to the present invention, wherein: the calculation of technical parameters includes collecting on-site meteorological condition data, calculating technical parameters using the collected data, and setting the pole according to the specified standards;

[0024] The formula for calculating the wind load on the conductor is:

[0025] W x = α × μ s × d × L w × W0

[0026]

[0027] The calculation formula for the wind load on the pole is as follows:

[0028] W S = β × μ S × μ Z × A × W0

[0029] A = (d + D) * (H - h) / 2

[0030] D = d + 1 / 75 * (H - h)

[0031] The calculation formula for the height of the upper cross-arm from the ground is as follows:

[0032] h1 = H - h - 0.02

[0033] The calculation formula for the height of the lower cross-arm from the ground is as follows:

[0034] h3 = H - h - 1

[0035] Among them, α is the wind load span coefficient, μ s is the wind load shape coefficient, d is the upper diameter of the pole, L w is the horizontal span, W0 is the basic wind pressure, β is the wind vibration coefficient, A is the windward area of the pole tower, D is the lower diameter of the pole, H is the height of the pole, h is the buried depth of the pole, μ Z is the wind pressure height change coefficient, V0 is the basic wind speed, W x is the wind load on the conductor, W S is the wind load on the pole, h1 is the height of the upper cross-arm from the ground, and h3 is the height of the lower cross-arm from the ground.

[0036] As a preferred solution of the intelligent pole tower equipment selection method based on spatial metadata drive described in the present invention, wherein: the selection of the pole includes selecting the upper limit coefficient of the pole and the upper limit value of the pole bending moment, judging the upper and lower limits of the pole selection, and judging whether it is between the resultant moment and the upper limit value of the pole bending moment according to the pole tower specifications. When it is judged that the calculated resultant moment is not within the interval, it is prompted that the selected pole model does not meet the upper and lower limits of the bending moment. When it is judged that the calculated resultant moment is within the interval, according to the obtained pole parameters, compare with the standard pole parameters in the typical design library, and select the pole according to the comparison result;

[0037] The selected upper limit coefficient of the pole is 1.5, and the selected upper limit value of the pole bending moment is 1.5 × M 合 , calculate the upper and lower limits according to the selected pole tower model and environmental conditions, and compare with the values filled in the pole tower material list in the construction drawing design. If it does not meet the calculation interval, a prompt is given.

[0038] Another object of the present invention is to provide an intelligent pole and tower equipment selection system driven by spatial metadata. The present invention selects poles according to meteorological condition data, significantly improving the intelligent level and efficiency of pole and tower equipment selection. The system of the present invention extracts the description of the project location area from the distribution network construction drawing design report, uses natural language processing technology to convert the text information into geographic coding, then queries and determines the meteorological combination conditions of the geographical location, and through matching and verifying the typical design template, calculates technical parameters, and selects poles according to meteorological condition data, significantly improving the intelligent level and efficiency of pole and tower equipment selection.

[0039] As a preferred embodiment of the intelligent pole and tower equipment selection system driven by spatial metadata according to the present invention, it is characterized by including a spatial metadata extraction and processing module, a meteorological combination matching module, a pole and tower selection range framing module, and a pole parameter calculation and selection module.

[0040] The spatial metadata extraction and processing module is used to extract the descriptive information of the project location area from the distribution network construction drawing design report, and use text parsing tools and natural language processing technology to convert the extracted text information into geographic coding, connect to the power grid meteorological area statistical table database, and use geographic coding to query and determine the meteorological combination conditions of the geographical location.

[0041] The meteorological combination matching module is used to compare the extracted meteorological combination conditions with the standard meteorological combination template, use the similarity calculation formula to evaluate the matching degree of the queried meteorological combination and the standard template, set a similarity threshold, perform matching judgment on the meteorological combination, and provide functions for manually adjusting weights and thresholds.

[0042] The pole and tower selection range framing module is used to extract the pole and tower material codes and module names from the typical design drawings, perform matching verification, read the overhead line conductor technical parameters and pole parameters according to the flat section drawing annotation model information and the typical design library table, and calculate the pole and tower load and the resultant moment of the conductor acting on the pole according to the pole load calculation rule, and frame the pole and tower selection range.

[0043] The pole parameter calculation and selection module is used to collect on-site meteorological condition data, use data calculation technology parameters, set poles according to specified standards, calculate the conductor wind load, pole wind load, height of the upper cross-arm from the ground and height of the lower cross-arm from the ground, select the upper limit coefficient of the pole and the upper limit value of the pole bending moment, judge the upper and lower limits of pole selection, and compare the calculated pole parameters with the standard pole parameters in the typical design library, and perform pole selection according to the comparison results.

[0044] A computer device includes a memory and a processor. The memory stores a computer program. It is characterized in that when the processor executes the computer program, the steps of the method for intelligent selection of pole and tower equipment driven by spatial metadata are realized.

[0045] A computer-readable storage medium stores a computer program thereon. It is characterized in that when the computer program is executed by a processor, the steps of the method for intelligent selection of pole and tower equipment driven by spatial metadata are realized.

[0046] Advantages of the present invention: By extracting the description of the project location area from the distribution network construction drawing design report and using the meteorological statistical table query to determine the meteorological combination conditions of the geographical location, the present invention realizes the precision and automation of pole and tower equipment selection, ensures the adaptability and safety of pole and tower design, reduces the risk of pole and tower damage, and improves the stability and reliability of the power grid; by using text parsing tools and natural language processing technologies, the design report is efficiently processed, the data processing speed and accuracy are improved, and the errors and time consumption of manual operations are reduced; by intelligently matching meteorological conditions, the economy and safety of pole and tower design are optimized, and the adaptability to extreme meteorological conditions is improved; by extracting and matching pole and tower material codes and module names from typical design drawings, the standardized management of pole and tower design is realized, the quality and performance of pole and tower are ensured, and according to the pole load calculation rules, the pole and tower load is accurately calculated, the load adaptability of the design is improved, and structural failure is avoided; by collecting on-site meteorological data and calculating technical parameters, the pole selection is dynamically adjusted, ensuring the optimal performance of the design. By intelligently making decisions on pole selection, the selection efficiency and accuracy are improved, the error rate is reduced, and the overall efficiency of power grid construction is enhanced. Description of the Drawings

[0047] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following will briefly introduce the drawings required for the description of the embodiments. Obviously, the following drawings are only some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other drawings can also be obtained based on these drawings, where:

[0048] Figure 1 It is the overall flowchart of the method for intelligent selection of pole and tower equipment driven by spatial metadata provided by an embodiment of the present invention.

[0049] Figure 2 It is the system scheme flowchart of the system for intelligent selection of pole and tower equipment driven by spatial metadata provided by an embodiment of the present invention. Detailed Embodiments

[0050] To make the above objects, features, and advantages of the present invention more apparent and understandable, the following provides a detailed description of the specific embodiments of the present invention in conjunction with the accompanying drawings of the specification. Obviously, the described embodiments are part of the embodiments of the present invention, rather than all embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts shall fall within the scope of protection of the present invention.

[0051] In the following description, many specific details are set forth to facilitate a thorough understanding of the present invention. However, the present invention may be implemented in other ways different from those described herein. Those skilled in the art can make similar generalizations without departing from the spirit of the present invention. Therefore, the present invention is not limited by the specific embodiments disclosed below.

[0052] Secondly, the so-called "one embodiment" or "embodiment" herein refers to a specific feature, structure, or characteristic that may be included in at least one implementation manner of the present invention. The phrase "in one embodiment" appearing in different places in this specification does not necessarily refer to the same embodiment, nor is it an embodiment that is mutually exclusive of other embodiments individually or selectively.

[0053] The present invention is described in detail in conjunction with schematic diagrams. When detailing the embodiments of the present invention, for the convenience of explanation, the cross-sectional views showing the device structure will be enlarged locally in an abnormal proportion, and the schematic diagrams are only examples and should not limit the scope of protection of the present invention herein. In addition, in actual production, three-dimensional spatial dimensions including length, width, and depth should be included.

[0054] At the same time, in the description of the present invention, it should be noted that the orientation or positional relationship indicated by terms such as "upper, lower, inner, and outer" is based on the orientation or positional relationship shown in the drawings. It is only for the convenience of describing the present invention and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore should not be construed as a limitation of the present invention. In addition, the terms "first, second, or third" are only used for descriptive purposes and cannot be construed as indicating or implying relative importance.

[0055] Unless otherwise clearly defined and limited in the present invention, the terms "installation, connection, and coupling" should be understood in a broad sense. For example, it can be a fixed connection, a detachable connection, or an integral connection; it can also be a mechanical connection, an electrical connection, or a direct connection, or can be indirectly connected through an intermediate medium, or can be the communication inside two elements. For those of ordinary skill in the art, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0056] Example 1, referring to Figure 1 , which is the first embodiment of the present invention. This embodiment provides an intelligent tower equipment selection method based on spatial metadata driving, including:

[0057] S1: Extract the description of the project location from the construction drawing design report of the distribution network, query and determine the meteorological combination conditions of the geographical location according to the meteorological statistical table, and match the meteorological combination.

[0058] The description of extracting the project location includes automatically extracting text information from the construction drawing design report using a text parsing tool, identifying and extracting the descriptive text about the project location in the report, and using natural language processing technology to parse the extracted text, identify the information of "county under jurisdiction" and "township under jurisdiction", and convert the text information into geographical codes.

[0059] The query and determination of the meteorological combination conditions of the geographical location include connecting to the database of the grid meteorological area statistical table issued by the grid, using the geographical code as the query keyword, executing a database query, retrieving the meteorological combination conditions that match the geographical code, and determining the meteorological combination conditions of the geographical location according to the query results; the meteorological combination conditions include annual average wind speed, maximum wind speed, ice coating thickness, and temperature range.

[0060] It should be noted that the matching of the meteorological combination includes comparing the extracted meteorological combination conditions with the standard meteorological combination template, using similarity calculation to evaluate the matching degree of the queried meteorological combination and the standard template, and setting a similarity threshold S th , and matching the meteorological combination;

[0061] The similarity calculation formula is:

[0062]

[0063] where x i is the meteorological condition value of the standard template, y i is the meteorological condition value of the query result, w i is the weight of the i-th condition, S is the calculated similarity, n is the total number of meteorological conditions, and i is the variable index;

[0064] The matching of the meteorological combination also includes that when the calculated similarity exceeds the threshold, it is determined that the meteorological combination is successfully matched, and when the similarity is less than or equal to the threshold, it is determined that the meteorological combination conditions of the query need to be re-evaluated and adjusted. The user interface displays the meteorological combination conditions of the query and the matching results, and manually adjusts the weights and thresholds to optimize the matching results.

[0065] S2: Match and compare the pole tower material codes and module names according to the standard typical design in the typical design library, perform matching verification on the typical design template, and delimit the range of pole tower selection according to the pole load calculation rules.

[0066] Further, the matching verification includes extracting the pole tower material code and module name from the typical design drawings, matching the extracted code and name with the standard code and name in the typical design library, and using the parsing data in the specification code to perform matching verification on the typical design template;

[0067] The frame of the pole tower selection range includes reading the technical parameters of the overhead line conductor and the pole parameters according to the model information in the flat section drawing annotation and the typical design library table; the technical parameters include the outer diameter of the conductor, cross-section, unit weight, breaking force, wind speed, ice coating thickness, horizontal span, conductor safety factor, and turning angle; the pole parameters include the upper diameter of the pole, pole burial depth, lower diameter of the pole, pole height, windward area of the pole tower, height of the upper cross arm from the ground, and height of the lower cross arm from the ground.

[0068] Furthermore, the frame of the pole tower selection range also includes framing the pole tower selection range according to the pole load calculation rules;

[0069] The formula for calculating the pole tower load is:

[0070] P = W d + W l + W s + W w

[0071] Wherein, P is the total load, W d is the conductor weight, W l is the ice coating weight, W S is the wind load of the pole, W w is the external load;

[0072] The formula for calculating the resultant moment of the conductor acting on the pole is:

[0073] M 合 = M + M 大风

[0074] M = F1 * ∑h1 * 1.1

[0075] M 大风 = [W x × ∑h1 + W s × (h1 + h3) / 2] × Q

[0076]

[0077] Wherein, M 合 is the resultant moment of the conductor acting on the pole, M is the horizontal moment of the conductor acting on the pole, M 大风 is the moment under strong wind conditions, F1 is the maximum allowable tension of the conductor, h1 is the height of the upper cross arm from the ground, h3 is the height of the lower cross arm from the ground, F is the breaking force, Q is the additional bending moment coefficient, K is the conductor safety factor, and θ is the turning angle.

[0078] S3: Calculate the technical parameters based on the meteorological condition data, and select the pole type according to the calculation results.

[0079] Further, the calculation of technical parameters includes collecting on-site meteorological condition data, calculating technical parameters using the collected data, and setting the pole according to the specified standards.

[0080] The formula for the wind load of the conductor is:

[0081] W x = α × μ s × d × L w × W0

[0082]

[0083] The formula for the wind load of the pole is:

[0084] W S = β × μ S × μ Z × A × W0

[0085] A = (d + D) * (H - h) / 2

[0086] D = d + 1 / 75 * (H - h)

[0087] The formula for the height of the upper cross-arm from the ground is:

[0088] h1 = H - h - 0.02

[0089] The formula for the height of the lower cross-arm from the ground is:

[0090] h3 = H - h - 1

[0091] Among them, α is the wind load span coefficient, μ s is the wind load shape coefficient, d is the upper pole diameter, L w is the horizontal span, W0 is the basic wind pressure, β is the wind vibration coefficient, A is the windward area of the pole tower, D is the lower pole diameter, H is the pole height, h is the pole burial depth, μ Z is the wind pressure height change coefficient, V0 is the basic wind speed, W x is the conductor wind load, W S is the pole wind load, h1 is the height of the upper cross-arm from the ground, and h3 is the height of the lower cross-arm from the ground.

[0092] Further, the selection of the electric pole includes selecting the upper limit coefficient of the electric pole and the upper limit value of the electric pole bending moment, determining the upper and lower limits of the electric pole selection, and judging whether it is between the resultant moment and the upper limit value of the electric pole bending moment according to the pole tower specifications. When it is judged that the calculated resultant moment is not within the interval, it is prompted that the selected electric pole model does not meet the upper and lower limits of the bending moment. When it is judged that the calculated resultant moment is within the interval, according to the obtained electric pole parameters, they are compared with the standard electric pole parameters in the typical design library, and the electric pole is selected according to the comparison result;

[0093] The upper limit coefficient of the selected electric pole is 1.5, and the upper limit value of the electric pole bending moment is 1.5×M 合 , the upper and lower limits are obtained by calculation according to the selected pole tower model and environmental conditions, and compared with the values filled in the pole tower list in the construction drawing design materials. A prompt is given if the calculated interval is not met.

[0094] It should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and not to limit them. Although the present invention has been described in detail with reference to the preferred embodiments, those of ordinary skill in the art should understand that the technical solutions of the present invention can be modified or equivalently replaced without departing from the spirit and scope of the technical solutions of the present invention, and they should all be covered by the scope of the claims of the present invention.

[0095] Example 2, referring to Figure 2 , is the second embodiment of the present invention. This embodiment provides an intelligent pole tower equipment selection system driven by spatial metadata, including a spatial metadata extraction and processing module 100, a meteorological combination matching module 200, a pole tower selection range delimiting module 300, and an electric pole parameter calculation and selection module 400.

[0096] The spatial metadata extraction and processing module 100 is used to extract the descriptive information of the project location from the distribution network construction drawing design report, and use text parsing tools and natural language processing technology to convert the extracted text information into geographic codes, connect to the power grid meteorological area statistical table database, and use the geographic codes to query and determine the meteorological combination conditions of the geographical location.

[0097] The meteorological combination matching module 200 is used to compare the extracted meteorological combination conditions with the standard meteorological combination template, evaluate the matching degree of the queried meteorological combination and the standard template using the similarity calculation formula, set the similarity threshold, perform the matching judgment of the meteorological combination, and provide the function of manually adjusting the weight and threshold.

[0098] The tower type selection range determination module 300 is used to extract the tower material codes and module names from the typical design drawings, perform matching verification, read the overhead line conductor technical parameters and pole parameters according to the model information in the flat section drawing notes and the typical design library table, and calculate the tower load and the resultant moment of the conductor acting on the pole according to the pole load calculation rules, so as to determine the tower type selection range.

[0099] The pole parameter calculation and selection module 400 is used to collect on-site meteorological condition data, calculate technical parameters using data calculation techniques, set poles according to specified standards, calculate the conductor wind load, pole wind load, height of the upper cross-arm from the ground and height of the lower cross-arm from the ground, select the upper limit coefficient of the pole and the upper limit value of the pole bending moment, determine the upper and lower limits of pole type selection, and compare the calculated pole parameters with the standard pole parameters in the typical design library, and perform pole type selection according to the comparison results.

[0100] It should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not restrictive. Although the present invention has been described in detail with reference to the preferred embodiments, those of ordinary skill in the art should understand that the technical solutions of the present invention can be modified or equivalently replaced without departing from the spirit and scope of the technical solutions of the present invention, and they should all be covered within the scope of the claims of the present invention.

[0101] Embodiment 3, the third embodiment of the present invention, which is different from the previous two embodiments in that:

[0102] If the above functions are implemented in the form of software function units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the essence of the technical solution of the present invention, or the part that contributes to the prior art, or part of this technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in various embodiments of the present invention. The foregoing storage medium includes: various media such as USB flash drives, mobile hard disks, read-only memories (ROM, Read-Only Memory), random access memories (RAM, Random Access Memory), magnetic disks, or optical discs that can store program codes.

[0103] The logic and / or steps represented in the flowchart or otherwise described herein can, for example, be considered as a definable list of executable instructions for implementing logical functions and can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, a system including a processor, or other systems that can fetch and execute instructions from the instruction execution system, apparatus, or device. As used in this specification, a "computer-readable medium" can be any device that can contain, store, communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

[0104] More specific examples (non-exhaustive list) of computer-readable media include the following: an electrical connection (electronic device) having one or more wirings, a portable computer diskette (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium can even be paper or other suitable media on which the program can be printed, as the program can be obtained electronically, for example, by optically scanning the paper or other media, followed by editing, interpretation, or other suitable processing as necessary, and then storing it in a computer memory.

[0105] It should be understood that the various parts of the present invention can be implemented in hardware, software, firmware, or a combination thereof. In the above-described embodiments, the multiple steps or methods can be implemented in software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one or a combination of the following techniques well known in the art can be used: discrete logic circuits having logic gates for implementing logical functions on data signals, application specific integrated circuits having appropriate combinational logic gates, programmable gate arrays (PGAs), field programmable gate arrays (FPGAs), etc.

Claims

1. An intelligent pole and tower equipment selection method driven by spatial metadata, characterized in that: including Extract the description of the project location area from the construction drawing design report of the distribution network, query and determine the meteorological combination conditions of the geographical location according to the meteorological statistical table, and match the meteorological combination; Match and compare the pole tower material codes and module names according to the standard typical designs in the typical design library, and perform matching verification on the typical design templates. According to the pole load calculation rules, delimit the range of pole tower selection; Calculate technical parameters based on the meteorological condition data, and select the pole according to the calculation results.

2. The intelligent pole and tower equipment selection method based on spatial metadata driving according to claim 1, wherein: The extraction of the description of the project location area includes using a text parsing tool to automatically extract text information from the construction drawing design report, identifying and extracting the descriptive text about the project location area in the report, and using natural language processing technology to parse the extracted text, identify the information of "county under jurisdiction" and "township under jurisdiction", and convert the text information into geographical codes; The query and determination of the meteorological combination conditions of the geographical location include connecting to the database of the grid meteorological area statistical table issued by the grid, using the geographical code as the query keyword, performing database queries, retrieving the meteorological combination conditions that match the geographical code, and determining the meteorological combination conditions of the geographical location according to the query results; the meteorological combination conditions include the annual average wind speed, maximum wind speed, ice coating thickness, and temperature range.

3. The intelligent pole and tower equipment selection method based on spatial metadata drive according to claim 2, characterized in that: The matching meteorological combination includes comparing the extracted meteorological combination conditions with the standard meteorological combination template, evaluating the matching degree between the queried meteorological combination and the standard template using similarity calculation, and setting a similarity threshold S th , the matching meteorological combination; The matching of the meteorological combination also includes that when the calculated similarity exceeds the threshold, it is determined that the meteorological combination is successfully matched. When the similarity is less than or equal to the threshold, it is determined that the meteorological combination conditions to be queried need to be re-evaluated and adjusted. The user interface displays the queried meteorological combination conditions and the matching results, and manually adjusts the weights and thresholds to optimize the matching results.

4. The intelligent pole and tower equipment selection method based on spatial metadata driving according to claim 3, wherein: The matching verification includes extracting the pole tower material codes and module names from the typical design drawings, matching the extracted codes and module names with the standard codes and names in the typical design library, and performing matching verification on the typical design templates using the parsing data in the specification codes; The delimitation of the pole tower selection range includes reading the technical parameters of the overhead line conductors and pole parameters according to the model information in the flat section drawing notes and the typical design library table; the technical parameters include the outer diameter of the conductor, cross-section, unit weight, breaking force, wind speed, ice coating thickness, horizontal span, conductor safety factor, and turning angle; the pole parameters include the upper end diameter of the pole, pole burial depth, lower end diameter of the pole, pole height, wind area of the pole tower, height of the upper cross arm from the ground, and height of the lower cross arm from the ground.

5. The intelligent tower equipment selection method based on spatial metadata driving according to claim 4, characterized in that: The delimitation of the pole tower selection range also includes delimiting the pole tower selection range according to the pole load calculation rules; The formula for calculating the pole tower load is: P = W d + W l + W s + W w Among them, P is the total load, and W d is the weight of the wire, and W l is the weight of ice coating, and W S is the wind load on the pole, and W w is the external load; The formula for calculating the resultant moment of the conductor acting on the pole is: M 合 = M + M 大风 M = F1 * ∑h1 * 1.1 M 大风 = [W x × ∑h1 + W s × (h1 + h3) / 2] × Q Among them, M 合 is the resultant moment of the wire acting on the pole, M is the horizontal moment of the wire acting on the pole, M 大风 is the moment under strong wind conditions, F1 is the maximum allowable tension of the wire, h1 is the height of the upper cross arm from the ground, h3 is the height of the lower cross arm from the ground, F is the breaking force, Q is the additional bending moment coefficient, K is the safety factor of the wire, and θ is the angle of rotation.

6. The intelligent tower equipment selection method based on spatial metadata drive according to claim 5, characterized in that: The calculation of the technical parameters includes collecting on-site meteorological condition data, calculating the technical parameters using the collected data, and setting the pole according to the specified standards; The formula for calculating the wind load of the conductor is: W x = α × μ s × d × L w × W0 The formula for calculating the wind load of the pole is: W S = β × μ S × μ Z × A × W0 A = (d + D) * (H - h) / 2 D = d + 1 / 75 * (H - h) The formula for calculating the height of the upper cross arm from the ground is: h1 = H - h - 0.02 The formula for calculating the height of the lower cross arm from the ground is: h3 = H - h - 1 Among them, α is the wind load span coefficient, μ s is the wind load shape coefficient, d is the upper pole diameter, L w is the horizontal span, W0 is the basic wind pressure, β is the wind vibration coefficient, A is the windward area of the pole tower, D is the lower pole diameter, H is the pole height, h is the pole embedment depth, μ Z is the wind pressure height change coefficient, V0 is the basic wind speed, W x is the conductor wind load, W S is the pole wind load, h1 is the height of the upper crossarm from the ground, h3 is the height of the lower crossarm from the ground.

7. The intelligent tower equipment selection method based on spatial metadata driving according to claim 6, characterized in that: The selection of poles includes selecting the upper limit coefficient of the pole and the upper limit value of the pole moment, judging the upper and lower limits of the pole selection, and judging whether it is between the resultant moment and the upper limit value of the pole moment according to the tower specifications. When it is judged that the calculated resultant moment is not within the interval, it is prompted that the selected pole model does not meet the upper and lower limits of the moment. When it is judged that the calculated resultant moment is within the interval, the pole parameters obtained by calculation are compared with the standard pole parameters in the typical design library, and the pole is selected according to the comparison result; Select the upper limit coefficient of the pole to be 1.5, and select the upper limit value of the pole moment to be 1.5×M 合 , calculate the upper and lower limits based on the selected tower type and environmental conditions, compare with the values filled in the tower material list in the construction drawing design, and give a prompt if the calculated range is not met.

8. A system adopting the intelligent tower equipment selection method based on spatial metadata driving as described in any one of claims 1 to 7, characterized in that: It includes a spatial metadata extraction and processing module, a meteorological combination matching module, a tower selection range delimiting module, and a pole parameter calculation and selection module; The spatial metadata extraction and processing module is used to extract the descriptive information of the project location from the distribution network construction drawing design report, and use text parsing tools and natural language processing technologies to convert the extracted text information into geographical codes, connect to the power grid meteorological zone statistical table database, and use geographical codes to query and determine the meteorological combination conditions of the geographical location; The meteorological combination matching module is used to compare the extracted meteorological combination conditions with the standard meteorological combination template, evaluate the matching degree of the queried meteorological combination and the standard template using the similarity calculation formula, set the similarity threshold, perform the matching judgment of the meteorological combination, and provide the function of manually adjusting the weight and threshold; The tower selection range delimiting module is used to extract the tower material code and module name from the typical design drawings, perform matching verification, read the overhead line conductor technical parameters and pole parameters according to the flat section drawing annotation model information and the typical design library table, and calculate the tower load and the resultant moment of the conductor acting on the pole according to the pole load calculation rule, delimiting the tower selection range; The pole parameter calculation and selection module is used to collect on-site meteorological condition data, calculate technical parameters using data calculation technology, set poles according to the specified standards, calculate the conductor wind load, pole wind load, the height of the upper cross arm from the ground and the height of the lower cross arm from the ground, select the upper limit coefficient of the pole and the upper limit value of the pole moment, judge the upper and lower limits of the pole selection, and compare the pole parameters obtained by calculation with the standard pole parameters in the typical design library, and select the pole according to the comparison result.

9. A computer device, comprising a memory and a processor, the memory storing a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the intelligent tower equipment selection method based on spatial metadata drive described in any one of claims 1 to 7.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the steps of the intelligent tower equipment selection method based on spatial metadata drive described in any one of claims 1 to 7.

Images