Optical cable fault point locating method, device, equipment and medium
By obtaining the first illumination distance and splice distance of the optical cable fault point, the reference point is determined and combined with the location of the optical cable marker stake, the problem of inaccurate optical cable fault point location is solved, and higher positioning accuracy is achieved.
Patent Information
- Application Number
- CN202111645841.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-12-30
- Publication Date
- 2024-11-15
- Estimated Expiration
- 2041-12-30
AI Technical Summary
In the existing technology, the location of optical cable faults is inaccurate, mainly due to the deviation between the illumination distance and the actual distance caused by the bending of the optical cable and the sparse density of the optical cable marker stakes, which affects the positioning accuracy of maintenance personnel.
By obtaining the first illumination distance of the fault point and the distance of the splice point on the optical cable segment under test, the first and second reference points are determined. Combined with the location of the optical cable marker stakes, the accurate location of the fault point is calculated, eliminating the influence of the optical cable bending distribution.
It improves the accuracy of optical cable fault location and reduces the impact of optical cable bending distribution on location, making fault location calculation more accurate.
Smart Images

Figure CN114362819B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of network communication technology, and in particular to a method, device, equipment and medium for locating an optical cable fault point. Background Art
[0002] With the application of optical fiber communication technology, the number of optical cables laid underground in cities is increasing, and the maintenance of optical cables has become more arduous. In the maintenance of optical cables, the location of the fault point of the optical cable is the focus of the maintenance work.
[0003] At present, the method for locating the fault point of the optical cable is mainly to rely on the optical time-domain reflectometer (OTDR) and other equipment in the machine room to transmit optical signals to the optical cable to obtain the lighting distance between the machine room and the fault point. Then, the maintenance personnel, based on years of experience, determine the approximate location of the fault point based on the lighting distance and the sum of the straight-line distances between all adjacent optical cable identification piles on the optical cable laying route.
[0004] Optical cables are usually not completely straight, but have certain bends, and the optical cable identification stakes are not set very densely. In order to facilitate the maintenance of optical cables, optical cables are reserved in some positions by curling during the laying of optical cables. The lighting distance obtained by equipment such as OTDR is the length of the optical cable between the fault point and the equipment room, so there is a large deviation between the lighting distance and the sum of the straight-line distances between all adjacent optical cable identification stakes on the optical cable laying route. This deviation will cause maintenance personnel to be unable to find the exact location of the fault point when locating the optical cable fault point, and the accuracy of fault point positioning is poor. Summary of the invention
[0005] The purpose of the embodiments of the present application is to provide a method, device, equipment and medium for locating an optical cable fault point, so as to accurately locate the optical cable fault point. The specific technical solution is as follows:
[0006] In a first aspect, an embodiment of the present application discloses a method for locating an optical cable fault point, the method comprising:
[0007] Acquire a first lighting distance between a measurement starting point and a fault point, wherein the first lighting distance is the lighting distance between the measurement starting point and the fault point obtained by transmitting an optical signal to the optical cable segment to be measured at the measurement starting point;
[0008] Based on the first lighting distance and the lighting distance from the measurement starting point to each fusion point on the optical cable segment to be measured, determine a first reference point and a second reference point, wherein the first reference point is the fusion point on one side of the fault point that is closest to the fault point, and the second reference point is the fusion point on the other side of the fault point that is closest to the fault point;
[0009] Acquire the position of the optical cable identification pile between the first reference point and the second reference point;
[0010] The location of the fault point is determined based on the first lighting distance and the location of the optical cable identification pile between the first reference point and the second reference point.
[0011] In a second aspect, an embodiment of the present application discloses a device for locating an optical cable fault point, the device comprising:
[0012] A first acquisition module is used to acquire a first lighting distance between a measurement starting point and a fault point, wherein the first lighting distance is the lighting distance between the measurement starting point and the fault point acquired by transmitting an optical signal to the optical cable segment to be measured at the measurement starting point;
[0013] A first determination module is used to determine a first reference point and a second reference point based on the first lighting distance and the lighting distance from the measurement starting point to each fusion point on the optical cable segment to be measured, wherein the first reference point is the fusion point on one side of the fault point that is closest to the fault point, and the second reference point is the fusion point on the other side of the fault point that is closest to the fault point;
[0014] A second acquisition module, used to acquire the position of the optical cable identification pile between the first reference point and the second reference point;
[0015] The second determination module is used to determine the position of the fault point based on the first lighting distance and the position of the optical cable identification pile between the first reference point and the second reference point.
[0016] In a third aspect, an embodiment of the present application discloses an electronic device, including a processor, a communication interface, a memory, and a communication bus, wherein the processor, the communication interface, and the memory communicate with each other via the communication bus;
[0017] Memory, used to store computer programs;
[0018] The processor is used to implement the method steps described in any one of the above aspects when executing the program stored in the memory.
[0019] In a fourth aspect, an embodiment of the present application discloses a computer-readable storage medium, characterized in that a computer program is stored in the computer-readable storage medium, and when the computer program is executed by a processor, the method steps described in any of the above aspects are implemented.
[0020] In a fifth aspect, an embodiment of the present application further provides a computer program product comprising instructions, which, when executed on a computer, enables the computer to execute any of the methods described above.
[0021] By adopting the above-mentioned technical scheme, the optical cable fault point positioning method, device, equipment and medium provided in the embodiments of the present application obtain the first lighting distance of the fault point, and determine the first reference point and the second reference point of the fault point based on the first lighting distance of the fault point and the lighting distances of each fusion point on the optical cable segment to be measured, and accurately locate the range of the optical cable fault point between the first reference point and the second reference point, which is equivalent to removing the influence of the reserved optical cable on the optical cable segment to be measured and the bending distribution of the optical cable outside the first reference point to the second reference point on the fault point positioning, thereby greatly improving the accuracy of the fault point positioning. Afterwards, the position of the fault point can be obtained by comprehensively calculating the position of the optical cable identification pile between the first reference point and the second reference point and the first lighting distance, which can reduce the influence of the bending distribution of the optical cable between the first reference point and the second reference point on the positioning of the optical cable fault point, thereby improving the accuracy of the positioning of the optical cable fault point.
[0022] Of course, implementing any product or method of the present application does not necessarily require achieving all of the advantages described above at the same time. BRIEF DESCRIPTION OF THE DRAWINGS
[0023] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application, and for ordinary technicians in this field, other embodiments can also be obtained based on these drawings.
[0024] Figure 1 A flowchart of a method for locating an optical cable fault point provided in an embodiment of the present application;
[0025] Figure 2 Another flow chart of a method for locating an optical cable fault point provided in an embodiment of the present application;
[0026] Figure 3a A schematic diagram of a method for querying optical cable fault points provided in an embodiment of the present application;
[0027] Figure 3b A schematic diagram of another optical cable fault point query method provided in an embodiment of the present application;
[0028] Figure 4 A flowchart of another optical cable fault point locating method provided in an embodiment of the present application;
[0029] Figure 5a A schematic diagram of a reference point determination method provided in an embodiment of the present application;
[0030] Figure 5b A schematic diagram of another reference point determination method provided in an embodiment of the present application;
[0031] Figure 6 Another flow chart of a method for locating an optical cable fault point provided in an embodiment of the present application;
[0032] Figure 7 A schematic diagram of another optical cable fault point query method provided in an embodiment of the present application;
[0033] Figure 8 A schematic diagram of the structure of an optical cable fault point locating device provided in an embodiment of the present application;
[0034] Fig. 9 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION
[0035] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field based on the present application belong to the scope of protection of the present application.
[0036] The optical cable fault point locating method provided in the embodiment of the present application can be executed by an electronic device, and the electronic device can be a smart phone, a tablet computer, a desktop computer, a server, or the like.
[0037] The following is a detailed description of the optical cable fault point locating method provided in the embodiment of the present application. Figure 1 As shown, an embodiment of the present application provides a method for locating an optical cable fault point, the method comprising:
[0038] S101, obtaining a first lighting distance between a measurement starting point and a fault point.
[0039] The first lighting distance is the lighting distance between the measurement starting point and the fault point obtained by transmitting an optical signal from the measurement starting point to the optical cable segment to be measured.
[0040] In an embodiment of the present application, the fault point is a breakpoint of an underground or overhead optical cable, and the measurement starting point is an active device in a communication room that can communicate with any section of the optical cable section to be measured where the fault point exists.
[0041] When a fault point exists in the optical cable segment between two communication rooms, resulting in communication interruption, the technician can view the fault warning from the port of the device connected to the optical cable segment in one of the communication rooms. Then, the technician can use the OTDR device to transmit an optical signal to the port so that the optical signal is transmitted in the optical cable segment connected to the port, thereby measuring the lighting distance from the active device in the communication room to the fault point of the optical cable segment.
[0042] Since the optical signal emitted by the OTDR device will reach the fault point from the measurement starting point through the optical cable, the first optical distance is the length of the optical cable between the measurement starting point and the fault point.
[0043] S102: Determine a first reference point and a second reference point based on the first lighting distance and the lighting distances from the measurement starting point to each fusion point on the optical cable segment to be measured.
[0044] The first reference point is the welding point on one side of the fault point that is closest to the fault point, and the second reference point is the welding point on the other side of the fault point that is closest to the fault point;
[0045] In an embodiment of the present application, the optical cable connecting two communication rooms is usually formed by fusing multiple shorter sections of optical cables. There will be a fusing point between two adjacent sections of optical cables. The lighting distance from the communication room to these fusing points can be measured by transmitting an optical signal using an OTDR device.
[0046] In one implementation, for two adjacent communication rooms, there are multiple optical cable segments between the two adjacent communication rooms, and there are fusion points between each optical cable segment. The lighting distance between the communication room and each fusion point can be collected in advance by an OTDR device, and the lighting distance can be saved in a database. Furthermore, when locating the fault point, the electronic device can obtain the lighting distance from the measurement starting point to each fusion point on the optical cable segment to be measured from the database according to the measurement starting point and the optical cable segment information to be measured input by the user.
[0047] For example, there are optical cables 1, 2 and 3 between communication room 1 and communication room 2. Optical cable 1 and optical cable 2 are connected through fusion point A, and optical cable 2 and optical cable 3 are connected through fusion point B.
[0048] An OTDR device can be used in communication room 1 to shine light in the optical cable in the direction of communication room 2, thereby obtaining the lighting distance from communication room 1 to welding point A and the lighting distance to welding point B.
[0049] In addition, an OTDR device can be used in communication room 2 to shine light in the optical cable in the direction of communication room 1, so as to obtain the lighting distance from communication room 2 to welding point A and the lighting distance to welding point B.
[0050] S103: Acquire the position of the optical cable identification pile between the first reference point and the second reference point.
[0051] Optical cable identification piles are identification piles set on the ground to mark the location of optical cables, manholes in underground pipelines, electric poles in pole lines, etc. Usually, there will be words "Optical cables are below, excavation is prohibited" on the optical cable identification piles. The location of the optical cable identification pile is the longitude and latitude of the optical cable identification pile.
[0052] In an embodiment of the present application, the technicians can collect the longitude and latitude of the fusion points on each optical cable segment and the longitude and latitude of the optical cable identification piles in advance through the Global Positioning System (GPS) positioning device, and save them in a database. After the electronic device determines the position of the first reference point and the position of the second reference point, the position of the optical cable identification pile between the first reference point and the second reference point can be obtained from the database.
[0053] S104: Determine the location of the fault point based on the first lighting distance and the location of the optical cable identification stake between the first reference point and the second reference point.
[0054] The method provided in the embodiment of the present application obtains the first lighting distance of the fault point, determines the first reference point and the second reference point of the fault point based on the first lighting distance of the fault point and the lighting distances of each fusion point on the optical cable segment to be tested, and accurately locates the range of the optical cable fault point between the first reference point and the second reference point, which is equivalent to removing the influence of the reserved optical cable on the optical cable segment to be tested and the bending distribution of the optical cable outside the first reference point to the second reference point on the fault point positioning, thereby greatly improving the accuracy of the fault point positioning. Afterwards, the position of the fault point can be obtained by comprehensively calculating the position of the optical cable identification pile between the first reference point and the second reference point and the first lighting distance, which can reduce the influence of the bending distribution of the optical cable between the first reference point and the second reference point on the positioning of the optical cable fault point, thereby improving the accuracy of the positioning of the optical cable fault point.
[0055] In another embodiment of the present disclosure, Figure 2 As shown, the method comprises the following steps:
[0056] S201. Obtain information of a measurement starting point and an optical cable segment to be measured input by a user in a Geographic Information System (GIS) interface.
[0057] S202: Receive a measurement instruction from a user.
[0058] The technician can input the first lighting distance, the measurement starting point, and the information of the optical cable segment to be measured into the electronic device, and click the start measurement button. Accordingly, the electronic device can receive the user's measurement instruction.
[0059] In practice, the optical cable connecting the two communication rooms A and B is composed of multiple fiber cores, but not all the fiber cores in the optical cable are connected from A to B. There may be an optical cross-connection point in the optical cable between AB, that is, some of the fiber cores in this section of the optical cable are branched to other communication rooms at the optical cross-connection point.
[0060] Therefore, users have two input methods on the fault point query interface:
[0061] 1. If Figure 3a As shown, if all the fiber cores of the optical cable segment between the communication rooms AB are not tapped, it is necessary to enter the first lighting distance, the measurement starting point and the measurement direction in the query interface.
[0062] 2. If Figure 3b As shown, if part of the fiber cores of the optical cable segment between communication rooms AB are branched to other rooms, and the port of the fiber core connecting room A to room B is 2TA-01-02-A-2-11-1, you need to enter the first lighting distance, the measurement starting point, and the fiber core port 2TA-01-02-A-2-11-1 connecting room A to room B in the query interface.
[0063] S203, in response to the measurement instruction, obtaining a first lighting distance from the measurement starting point to the fault point, and obtaining the lighting distances from the measurement starting point to each fusion point on the optical cable segment to be measured based on the information of the optical cable segment to be measured.
[0064] After S203 , S102 to S104 may be executed.
[0065] With this method, the user only needs to input the first lighting distance, the measurement starting point and the information of the optical cable section to be measured, and click the measurement button to accurately locate the fault point. The fault point location does not require manual calculation and the operation is simple and fast.
[0066] In another embodiment of the present application, Figure 4 As shown, based on the above embodiment, S102 can be specifically implemented as follows:
[0067] S1021. Determine a target fusion point closest to the fault point based on the first fusion distance and the fusion distances from the measurement starting point to each fusion point on the optical cable segment to be measured.
[0068] S1021 can be specifically implemented as follows:
[0069] Subtract the lighting distances from the measuring starting point to each fusion point on the optical cable segment to be measured from the first lighting distance, take the absolute value of each difference, and obtain the distance between each fusion point and the fault point;
[0070] The minimum value of the distance between each welding point and the fault point is determined to obtain the target welding point closest to the fault point.
[0071] That can be achieved through the following formula:
[0072] P=min(|BM1-BP|,|BM2-BP|,…,|BMn-BP|)
[0073] Among them, P is the target splice point closest to the fault point, BMn represents the lighting distance from the measurement starting point to the nth splice point on the optical cable segment to be measured, and BP represents the OTDR lighting distance from the current fault point to the measurement starting point, that is, the lighting distance from the measurement starting point to the fault point. In actual operation, the measurement starting point of the BMn value and the measurement starting point of the BP value and the measured optical cable segment should be kept consistent, so that the OTDR lighting direction of the BMn and BP values are consistent.
[0074] |BM1-BP|,|BM2-BP|,…,|BMn-BP| respectively represent the distance between each welding point and the fault point.
[0075] The minimum value among |BM1-BP|, |BM2-BP|, ..., |BMn-BP| is obtained, that is, the minimum value of the distance between each welding point and the fault point is determined, and the target welding point closest to the fault point can be obtained.
[0076] For example, if the minimum distance between each welding point and the fault point is |BM2-BP|, the target welding point is determined to be the welding point corresponding to the lighting distance BM2.
[0077] By subtracting the lighting distance from the measurement starting point to each fusion point on the optical cable segment to be measured from the first lighting distance and taking the absolute value of each difference, it is equivalent to obtaining the length of the optical cable between each fusion point and the fault point. Furthermore, by determining the minimum value of the absolute value of each difference, it is equivalent to determining the fusion point with the shortest optical cable length from the fault point, that is, determining the target fusion point closest to the fault point. The target fusion point closest to the fault point can be accurately determined, thereby improving the accuracy of fault point locating.
[0078] S1022: If the second lighting distance from the measurement starting point to the target welding point is less than the first lighting distance, the first reference point is determined to be the target welding point, and the second reference point is the next welding point of the target welding point in the direction from the measurement starting point to the target welding point.
[0079] For example, Figure 5a As shown, the measurement starting point is the machine room A, the fault point is C, and the target welding point is B. It can be understood that the three points ACB are on the same optical cable segment, the lighting distance from A to B is the second lighting distance, and the lighting distance from A to C is the first lighting distance.
[0080] Assume that in the direction from A to B, the next weld point of B is E, and the previous weld point of B is D;
[0081] If the second lighting distance is smaller than the first lighting distance, B is the first reference point and E is the second reference point.
[0082] S1023. If the second lighting distance is greater than the first lighting distance, the second reference point is the target welding point, and the first reference point is the previous welding point of the target welding point in the direction from the measurement starting point to the target welding point.
[0083] Continuing with the above example, Figure 5b As shown, if the second lighting distance is greater than the first lighting distance, B is the second reference point and D is the first reference point.
[0084] In another embodiment of the present application, if the first lighting distance is equal to the second lighting distance, the positions of the fault point and the target welding point coincide with each other, and the electronic device can directly determine the position of the fault point as the position of the target welding point.
[0085] By adopting this method, the target welding point closest to the fault point can be determined through the first lighting distance and the lighting distance of each welding point on the optical cable segment to be measured, and then the positional relationship between the target welding point and the fault point can be obtained by comparing the size relationship between the first lighting distance and the second lighting distance from the measurement starting point to the target welding point. Furthermore, the welding point on the other side of the fault point that is closest to the fault point can be determined, that is, the position of the fault point is accurately located between two adjacent welding points, that is, between the first reference point and the second reference point. Since the lighting distance can reflect the actual length of the optical cable from the measurement starting point to the fault point or the welding point, the fault point is located between the first reference point and the second reference point, which eliminates the influence of the reserved length of the optical cable and the bending of the optical cable outside the first reference point and the second reference point on the positioning accuracy of the fault point, thereby improving the positioning accuracy.
[0086] In another embodiment of the present application, based on the above embodiment, the above step S104 can be specifically implemented as follows:
[0087] First, use the st_makeline() function to obtain the position information of the curve between the first reference point and the second reference point:
[0088] geometryBM=st_makeline(geometry[g1, g2...gn-1, gn])
[0089] g1 is the GIS information corresponding to the longitude and latitude of the first reference point, gn is the GIS information corresponding to the longitude and latitude of the second reference point, and g2…gn-1 respectively represent the GIS information corresponding to the longitude and latitude of the optical cable identification pile in the direction from the first reference point to the second reference point.
[0090] The built-in functions of PostGIS are commonly used functions in the development process of geographic information systems. The function st_makeline() in the built-in functions of PostGIS is a function for generating a line from the positions of multiple points. In the embodiment of the present application, the function can generate a curve in the order of g1, g2...gn-1, gn, and the two ends of the curve are the first reference point and the second reference point.
[0091] geometry() is used to convert data types. Since g1, g2…gn-1, gn in this application are GIS information corresponding to longitude and latitude, which are the data types of separate points, the function st_makeline() can convert the point data type into the line data type, that is, the generated geometryBM is the position information of the curve from the first reference point to the second reference point.
[0092] Introduce the built-in function ST_LineInterpolatePoint() of PostGIS:
[0093] The function ST_LineInterpolatePoint() is a function used to calculate the position of an unknown point when conditions 1 and 2 are met.
[0094] The unknown point is located between two endpoints, and condition 1 is that the positions of the two endpoints are known, and the positions of multiple points between the two endpoints are also known.
[0095] Condition 2 is the ratio of the distance from the known unknown point to one of the endpoints to the distance between the two endpoints.
[0096] The application scenario of the built-in function is replaced with the scenario in the embodiment of the present application, that is, in the embodiment of the present application, the above-mentioned two endpoints are the first reference point and the second reference point, the unknown point is the fault point, and the position between the two endpoints is the position of the optical cable identification pile between the first reference point and the second reference point.
[0097] By replacing the above scenarios, we can get the GIS positioning formula of the fault point:
[0098] Bpgeometry=ST_LineInterpolatePoint(geometryBM,(BP-BMg1) / (ST_Length(sd_st_transform(geometryBM,26986))));
[0099] Among them, Bpgeometry is the location of the fault point;
[0100] geometryBM is the position information of the curve between the first reference point and the second reference point;
[0101] BP is the first lighting distance;
[0102] BMg1 is the lighting distance from the test starting point to the first reference point;
[0103] The function sd_st_transform(, 26986) is used to convert the position information of the curve between the first reference point and the second reference point into the position coordinates in the 26986 coordinate system;
[0104] The function ST_Length() calculates the length of the curve between the first reference point and the second reference point in the 26986 coordinate system based on the coordinate points of the 26986 coordinate system obtained by conversion.
[0105] It can be understood that (BP-BMg1) / (ST_Length(sd_st_transform(geometryBM,26986))) is the ratio of the distance from the first reference point to the fault point to the length of the curve from the first reference point to the second reference point. Furthermore, the function ST_LineInterpolatePoint() can calculate the longitude and latitude of the fault point based on the ratio and geometryBM.
[0106] It should be noted that the functions ST_LineInterpolatePoint() and st_makeline() are both built-in functions of PostGIS. The calculation principles of the above functions can refer to the relevant descriptions.
[0107] This method is based on the principle of PostGIS routing positioning. The GIS information corresponding to the longitude and latitude of the first reference point, the GIS information corresponding to the longitude and latitude of the second reference point, and the GIS information corresponding to the longitude and latitude of the optical cable identification pile between the first reference point and the second reference point are used to generate the position information of the curve between the first reference point and the second reference point, and the position information of the curve is converted into the position coordinates in the 26986 coordinate system. Then, the length of the curve in the 26986 coordinate system is calculated based on the coordinates and the function ST_Length(), instead of directly calculating the straight-line distance between the first reference point and the second reference point, so that the calculated length of the curve between the first reference point and the second reference point is closer to the length of the bent optical cable between the first reference point and the second reference point. By calculating the ratio of the distance from the first reference point to the fault point to the length of the curve from the first reference point to the second reference point, a more accurate calculation of the position of the fault point in the direction from the first reference point to the second reference point is achieved. Furthermore, combined with the position information of the curve between the first reference point and the second reference point, the position of the fault point can be obtained by the function ST_LineInterpolatePoint(), which can minimize the influence of optical cable reservation and optical cable bending on the fault point positioning, and effectively improve the accuracy of fault point positioning.
[0108] In the embodiments of the present application, Figure 6 As shown, based on the above embodiment, after step S104, the following steps are further included:
[0109] S601, displaying the fault point location on a GIS map of a geographic information system (GIS) interface.
[0110] like Figure 7 As shown, for example, the user enters in the GIS interface that the first lighting distance is 6530m, the measurement starting point is the transmission room on the second floor of the hub building, and the direction is from the transmission room on the second floor of the hub building to the Shilihe room. Click the Start Measurement button, and the location of the optical cable line to be measured and the fault point on the line will be displayed in the GIS map of the geographic information platform.
[0111] By adopting this method, the location of the fault point will be directly displayed on the geographic information platform GIS map interface, making the location of the optical cable fault point intuitive and accurate, getting rid of the reliance on experience of line maintenance personnel, and allowing maintenance personnel who are not familiar with on-site routes to quickly locate the location of the optical cable fault point; when an optical cable fault occurs, the line maintenance personnel can go directly to the corresponding location to repair the optical cable according to the location of the fault point displayed on the map, without the need for a full-course inspection.
[0112] In the embodiment of the present application, the geographic information platform is used to execute the optical cable fault point locating method provided in the embodiment of the present application, and the specific construction process of the geographic information platform is as follows:
[0113] The geodetic map is loaded through the geographic server GeoServer, and the system platform is built in combination with the administrative area planning boundary information.
[0114] The technicians input the information of all optical cables, splice boxes, optical cross-connects and other dumb resources in the area, associate the fiber cores with the terminals, and configure the optical cable calculation functions and formulas in the above embodiment in the system.
[0115] The GIS information provided by the PostgresSQL database generates a geographic layer including the optical cable route on GeoServer and displays the geographic layer, wherein PostgreSQL is an object-relational database management system.
[0116] By adopting this method, the geographic information platform can automatically locate the fault point according to the first lighting distance input by the user and the position of the optical cable identification pile and the welding point in the platform, and display the calculated position of the fault point on the GIS map of the geographic information platform. That is, the user only needs to input the first lighting distance and the measurement starting point and the optical cable section to be measured in the user interface, and click to start measuring to conveniently and intuitively see the geographical location of the fault point in the user interface. The platform can solve the problem of cable fault point positioning of telecom operators in various production scenarios and has strong applicability.
[0117] Corresponding to the above method embodiment, the present application embodiment also provides a device for locating an optical cable fault point, such as Figure 8 As shown, the device comprises:
[0118] The first acquisition module 801 is used to acquire a first lighting distance between a measurement starting point and a fault point, where the first lighting distance is the lighting distance between the measurement starting point and the fault point acquired by transmitting an optical signal from the measurement starting point to the optical cable segment to be measured;
[0119] A first determination module 802 is used to determine a first reference point and a second reference point based on the first lighting distance and the lighting distance from the measurement starting point to each fusion point on the optical cable segment to be measured, wherein the first reference point is the fusion point closest to the fault point on one side of the fault point, and the second reference point is the fusion point closest to the fault point on the other side of the fault point;
[0120] The second acquisition module 803 is used to acquire the position of the optical cable identification pile between the first reference point and the second reference point;
[0121] The second determination module 804 is used to determine the location of the fault point based on the first lighting distance and the location of the optical cable identification stake between the first reference point and the second reference point.
[0122] In another embodiment of the present application, the first determining module 802 is specifically configured to:
[0123] Based on the first lighting distance and the lighting distances from the measuring starting point to each welding point on the optical cable segment to be measured, determine the target welding point closest to the fault point;
[0124] If the second lighting distance from the measuring starting point to the target welding point is less than the first lighting distance, the first reference point is determined to be the target welding point, and the second reference point is the next welding point of the target welding point in the direction from the measuring starting point to the target welding point;
[0125] If the second lighting distance is greater than the first lighting distance, the second reference point is the target welding point, and the first reference point is the previous welding point of the target welding point in the direction from the measurement starting point to the target welding point.
[0126] In another embodiment of the present application, the first determining module 802 is specifically configured to:
[0127] Subtract the lighting distances from the measuring starting point to each fusion point on the optical cable segment to be measured from the first lighting distance, take the absolute value of each difference, and obtain the distance between each fusion point and the fault point;
[0128] The minimum value of the distance between each welding point and the fault point is determined to obtain the target welding point closest to the fault point.
[0129] In another embodiment of the present application, the second determining module 804 is specifically configured to:
[0130] The location of the fault point is calculated according to the following expression:
[0131] The location of the fault point is calculated according to the following expression:
[0132] Bpgeometry=ST_LineInterpolatePoint(geometryBM,(BP-BMg1) / (ST_Length(sd_st_transform(geometryBM,26986))));
[0133] Wherein, geometryBM = st_makeline(geometry[g1, g2 ... gn-1, gn]);
[0134] geometryBM is the position information of the curve between the first reference point and the second reference point;
[0135] The st_makeline() function is used to generate lines from points;
[0136] g1 is the GIS information corresponding to the longitude and latitude of the first reference point, gn is the GIS information corresponding to the longitude and latitude of the second reference point, and g2…gn-1 sequentially represent the GIS information corresponding to the longitude and latitude of the optical cable identification pile in the direction from the first reference point to the second reference point;
[0137] BP is the first lighting distance;
[0138] BMg1 is the lighting distance from the test starting point to the first reference point;
[0139] The function sd_st_transform(, 26986) is used to convert the position information of the curve between the first reference point and the second reference point into the position coordinates in the 26986 coordinate system;
[0140] The function ST_Length() is used to calculate the length of the curve between the first reference point and the second reference point in the 26986 coordinate system based on the position coordinates of the converted 26986 coordinate system.
[0141] In another embodiment of the present application, the device further includes:
[0142] The display module is used to display the location of the fault point on the GIS map of the Geographic Information System (GIS) interface.
[0143] In another embodiment of the present application, the device further includes:
[0144] The third acquisition module is used to obtain the information of the measurement starting point and the optical cable section to be measured input by the user in the GIS interface;
[0145] A receiving module, used for receiving a measurement instruction from a user;
[0146] The response module is used to respond to the measurement instruction, execute the step of obtaining the first lighting distance between the measurement starting point and the fault point, and obtain the lighting distance from the measurement starting point to each fusion point on the optical cable segment to be measured based on the information of the optical cable segment to be measured.
[0147] The present application also provides an electronic device, such as Fig. 9 As shown, it includes a processor 901, a communication interface 902, a memory 903 and a communication bus 904, wherein the processor 901, the communication interface 902, and the memory 903 communicate with each other through the communication bus 904.
[0148] Memory 903, used for storing computer programs;
[0149] The processor 901 is configured to implement the method steps in the above method embodiment when executing the program stored in the memory 903 .
[0150] The communication bus mentioned in the above electronic device can be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The communication bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, only one thick line is used in the figure, but it does not mean that there is only one bus or one type of bus.
[0151] The communication interface is used for communication between the above electronic device and other devices.
[0152] The memory may include a random access memory (RAM) or a non-volatile memory (NVM), such as at least one disk memory. Optionally, the memory may also be at least one storage device located away from the aforementioned processor.
[0153] The above-mentioned processor can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.
[0154] In another embodiment provided in the present application, a computer-readable storage medium is provided, in which a computer program is stored. When the computer program is executed by a processor, the steps of any of the above-mentioned optical cable fault point locating methods are implemented.
[0155] In another embodiment provided by the present application, a computer program product including instructions is also provided, which, when executed on a computer, enables the computer to execute the steps of any of the optical cable fault point locating methods in the above embodiments.
[0156] In the above embodiments, it can be implemented in whole or in part by software, hardware, firmware or any combination thereof. When implemented using software, it can be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the process or function described in the embodiment of the present application is generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions may be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium, for example, the computer instructions may be transmitted from a website site, computer, server or data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.) mode to another website site, computer, server or data center. The computer-readable storage medium may be any available medium that a computer can access or a data storage device such as a server or data center that includes one or more available media integrated. The available medium may be a magnetic medium, (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a solid-state drive Solid State Disk (SSD)), etc.
[0157] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.
[0158] Each embodiment in this specification is described in a related manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.
[0159] The above description is only a preferred embodiment of the present application and is not intended to limit the protection scope of the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application are included in the protection scope of the present application.
Claims
1. A method for locating an optical cable fault point, characterized in that: include: Acquire a first lighting distance between a measurement starting point and a fault point, wherein the first lighting distance is the lighting distance between the measurement starting point and the fault point obtained by transmitting an optical signal to the optical cable segment to be measured at the measurement starting point; Based on the first lighting distance and the lighting distance from the measurement starting point to each fusion point on the optical cable segment to be measured, determine a first reference point and a second reference point, wherein the first reference point is the fusion point on one side of the fault point that is closest to the fault point, and the second reference point is the fusion point on the other side of the fault point that is closest to the fault point; Acquire the position of the optical cable identification pile between the first reference point and the second reference point; Determine the location of the fault point based on the first lighting distance and the location of the optical cable identification stake between the first reference point and the second reference point; Determining a first reference point and a second reference point based on the first lighting distance and the lighting distance from the measurement starting point to each fusion point on the optical cable segment to be measured includes: Determine the target fusion point closest to the fault point based on the first fusion distance and the fusion distance from the measurement starting point to each fusion point on the optical cable segment to be measured; If the second lighting distance from the measuring starting point to the target welding point is less than the first lighting distance, the first reference point is determined to be the target welding point, and the second reference point is the next welding point of the target welding point in the direction from the measuring starting point to the target welding point; If the second lighting distance is greater than the first lighting distance, the second reference point is the target welding point, and the first reference point is the previous welding point of the target welding point in the direction from the measurement starting point to the target welding point; Determining the location of the fault point based on the first lighting distance and the location of the optical cable identification pile between the first reference point and the second reference point includes: The position of the fault point is calculated according to the following expression: , in, ; is the position information of the curve between the first reference point and the second reference point; Functions are used to generate lines from points; g1 is the GIS information corresponding to the longitude and latitude of the first reference point, gn is the GIS information corresponding to the longitude and latitude of the second reference point, and g2…gn-1 sequentially represent the GIS information corresponding to the longitude and latitude of the optical cable identification pile in the direction from the first reference point to the second reference point; BP is the first lighting distance; BMg1 is the lighting distance from the measurement starting point to the first reference point; The function sd_st_transform(, 26986) is used to convert the position information of the curve between the first reference point and the second reference point into position coordinates in the 26986 coordinate system; The function ST_Length() is used to calculate the length of the curve between the first reference point and the second reference point in the 26986 coordinate system according to the position coordinates of the 26986 coordinate system obtained by conversion; The function ST_LineInterpolatePoint() is used to interpolate points according to the ratio The longitude and latitude of the fault point are calculated using (BP-BMg1) / (ST_Length(sd_st_transform(geometryBM ,26986))) and geometryBM.
2. The method according to claim 1, characterized in that Determining a target fusion point closest to the fault point based on the first fusion distance and the fusion distance from the measurement starting point to each fusion point on the optical cable segment to be measured includes: Subtract the lighting distances from the measurement starting point to each fusion point on the optical cable segment to be measured from the first lighting distance, take the absolute value of each difference, and obtain the distance between each fusion point and the fault point; The minimum value of the distance between each welding point and the fault point is determined to obtain the target welding point that is closest to the fault point.
3. The method according to any one of claims 1 to 2, characterized in that: After determining the location of the fault point based on the first lighting distance and the location of the optical cable identification pile between the first reference point and the second reference point, the method further includes: The location of the fault point is displayed on a GIS map of a geographic information system (GIS) interface.
4. The method according to claim 3, characterized in that Before obtaining the first lighting distance between the measurement starting point and the fault point, the method further includes: Acquire the information of the measurement starting point and the optical cable segment to be measured input by the user in the GIS interface; Receive measurement instructions from users; In response to the measurement instruction, the step of obtaining the first lighting distance from the measurement starting point to the fault point is executed, and the lighting distances from the measurement starting point to each fusion point on the optical cable segment to be measured are obtained based on the information of the optical cable segment to be measured.
5. An optical cable fault point locating device, characterized in that: include: A first acquisition module is used to acquire a first lighting distance between a measurement starting point and a fault point, wherein the first lighting distance is the lighting distance between the measurement starting point and the fault point acquired by transmitting an optical signal to the optical cable segment to be measured at the measurement starting point; A first determination module is used to determine a first reference point and a second reference point based on the first lighting distance and the lighting distance from the measurement starting point to each fusion point on the optical cable segment to be measured, wherein the first reference point is the fusion point on one side of the fault point that is closest to the fault point, and the second reference point is the fusion point on the other side of the fault point that is closest to the fault point; A second acquisition module, used to acquire the position of the optical cable identification pile between the first reference point and the second reference point; A second determination module is used to determine the position of the fault point based on the first lighting distance and the position of the optical cable identification pile between the first reference point and the second reference point; The first determining module is specifically configured to: Determine the target fusion point closest to the fault point based on the first fusion distance and the fusion distance from the measurement starting point to each fusion point on the optical cable segment to be measured; If the second lighting distance from the measuring starting point to the target welding point is less than the first lighting distance, the first reference point is determined to be the target welding point, and the second reference point is the next welding point of the target welding point in the direction from the measuring starting point to the target welding point; If the second lighting distance is greater than the first lighting distance, the second reference point is the target welding point, and the first reference point is the previous welding point of the target welding point in the direction from the measurement starting point to the target welding point; The second determining module is specifically used to: The position of the fault point is calculated according to the following expression: , in, ; geometryBM is the position information of the curve between the first reference point and the second reference point; The st_makeline() function is used to generate a line from points; g1 is the GIS information corresponding to the longitude and latitude of the first reference point, and gn is the GIS information corresponding to the longitude and latitude of the second reference point. Sequentially represent the GIS information corresponding to the longitude and latitude of the optical cable identification piles in the direction from the first reference point to the second reference point; BP is the first lighting distance; BMg1 is the lighting distance from the measurement starting point to the first reference point; The function sd_st_transform(, 26986) is used to convert the position information of the curve between the first reference point and the second reference point into position coordinates in the 26986 coordinate system; The function ST_Length() is used to calculate the length of the curve between the first reference point and the second reference point in the 26986 coordinate system according to the position coordinates of the 26986 coordinate system obtained by conversion; The function ST_LineInterpolatePoint() is used to interpolate points according to the ratio The longitude and latitude of the fault point are calculated using (BP-BMg1) / (ST_Length(sd_st_transform(geometryBM ,26986))) and geometryBM.
6. The device according to claim 5, characterized in that The first determining module is specifically configured to: Subtract the lighting distances from the measurement starting point to each fusion point on the optical cable segment to be measured from the first lighting distance, take the absolute value of each difference, and obtain the distance between each fusion point and the fault point; The minimum value of the distance between each welding point and the fault point is determined to obtain the target welding point that is closest to the fault point.
7. The device according to any one of claims 5-6, characterized in that: The device also includes: The display module is used to display the location of the fault point on a GIS map of a geographic information system (GIS) interface.
8. The device according to claim 7, characterized in that The device also includes: A third acquisition module is used to obtain the information of the measurement starting point and the optical cable segment to be measured input by the user in the GIS interface; A receiving module, used for receiving a measurement instruction from a user; The response module is used to respond to the measurement instruction, execute the step of obtaining the first lighting distance between the measurement starting point and the fault point, and obtain the lighting distance from the measurement starting point to each fusion point on the optical cable segment to be measured based on the information of the optical cable segment to be measured.
9. An electronic device, characterized in that: It includes a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other through the communication bus; Memory, used to store computer programs; A processor, for implementing the method steps described in any one of claims 1 to 4 when executing a program stored in a memory.
10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method steps described in any one of claims 1 to 4 are implemented.
