CN107707399A - The method and optical cable segment querying method of line resource is presented in a kind of GIS - Google Patents

The method and optical cable segment querying method of line resource is presented in a kind of GIS Download PDF

Info

Publication number
CN107707399A
CN107707399A CN201710911747.6A CN201710911747A CN107707399A CN 107707399 A CN107707399 A CN 107707399A CN 201710911747 A CN201710911747 A CN 201710911747A CN 107707399 A CN107707399 A CN 107707399A
Authority
CN
China
Prior art keywords
mrow
longitude
latitude
line
gis
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201710911747.6A
Other languages
Chinese (zh)
Other versions
CN107707399B (en
Inventor
赵杰
陈天奇
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fiberhome Telecommunication Technologies Co Ltd
Original Assignee
Fiberhome Telecommunication Technologies Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Fiberhome Telecommunication Technologies Co Ltd filed Critical Fiberhome Telecommunication Technologies Co Ltd
Priority to CN201710911747.6A priority Critical patent/CN107707399B/en
Publication of CN107707399A publication Critical patent/CN107707399A/en
Application granted granted Critical
Publication of CN107707399B publication Critical patent/CN107707399B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L41/00Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
    • H04L41/02Standardisation; Integration
    • H04L41/0246Exchanging or transporting network management information using the Internet; Embedding network management web servers in network elements; Web-services-based protocols
    • H04L41/0253Exchanging or transporting network management information using the Internet; Embedding network management web servers in network elements; Web-services-based protocols using browsers or web-pages for accessing management information
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/29Geographical information databases
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L41/00Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
    • H04L41/22Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks comprising specially adapted graphical user interfaces [GUI]
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network arrangements or protocols for supporting network services or applications
    • H04L67/01Protocols
    • H04L67/06Protocols specially adapted for file transfer, e.g. file transfer protocol [FTP]
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network arrangements or protocols for supporting network services or applications
    • H04L67/50Network services
    • H04L67/52Network services specially adapted for the location of the user terminal

Landscapes

  • Engineering & Computer Science (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Signal Processing (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Remote Sensing (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Human Computer Interaction (AREA)
  • Light Guides In General And Applications Therefor (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The method and optical cable segment querying method of line resource is presented in a kind of GIS, is related to ODN and GIS fields, and pipeline modules download the line resource, and Web client accesses pipeline modules, resource file is loaded into GIS map in the form of a figure layer and line chart layer;When GIS map is inquired about, duct section or messenger wire section are selected, determines the pipe well or electric pole at both ends;Respectively using pipe well or electric pole as the center of circle, two circular query contexts are formed by pre-set radius r, inquire about all optical cross boxes and connector box in each query context, the data of repetition are removed in filtering, all optical cable segments after query filter, filter off again except duplicate data, obtain optical cable segment all in query context.The present invention intuitively shows optical cable segment in GIS map, avoids optical cable overlaying influence from identifying.Optical cable segment querying method can fast and accurately find out optical cable segment.

Description

The method and optical cable segment querying method of line resource is presented in a kind of GIS
Technical field
The present invention relates to ODN and GIS fields, the method and optical cable segment of line resource is presented in particular to a kind of GIS Querying method.
Background technology
In optical transfer network, ODN (Optical Distribution Network, Optical Distribution Network) plays crucial backbone Net linkage function, under PON (Passive Optical Network, EPON) network, ODN is OLT (Optical Line Terminal, optical line terminal) and ONU (Optical Network Unit, optical network unit) the two active equipments Between all passive fibers, inactive component (optical branching device) composition a network, its effect is carried between OLT and ONU For transmission line.
In Optical Distribution Network practice of construction, it is necessary to using pipeline, pole line etc., the deployment of light distribution facility is carried out, can be with Find out, the pipeline facility such as pipeline, pole line is the essential infrastructure of optical distribution.In the laying work of optical cable, trend Identical is very universal with route optical cable segment situation.In current existing intelligent ODN GIS management systems, optical cable is only able to display Circuit, as ODN equipment, cable resource data volume increase, cause the office at same office station excessive to optical cable, then to move towards identical Optical cable can in GIS map Overlapping display, can not intuitively identify actually there is which optical cable, can not also be obtained in GIS map To optical cable segment information.
The content of the invention
For defect present in prior art, it is an object of the invention to provide the side that line resource is presented in a kind of GIS Method, optical cable segment is intuitively shown in GIS map, avoid optical cable overlaying influence from identifying.The present invention also provides optical cable segment issuer Method, it can fast and accurately find out optical cable segment.
To achieve the above objectives, the present invention takes a kind of method that line resource is presented in GIS, based on fiber optic cable management system, Characterized in that, fiber optic cable management system includes pipeline modules, ODN NM servers and Web client, in ODN NM servers There is line resource, line resource includes the relevant information of pipe well, pipeline, duct section, electric pole, pole line and messenger wire section, correlation letter Breath includes title, and corresponding longitude and latitude or longitude and latitude set, the step include:
S1. pipeline modules download the line resource;
S2.Web clients access pipeline modules, pipe well, pipeline, electric pole and the bar of inquiry request will be met in resource file The form of Lu Yidian figure layers is loaded into GIS map and presented, by duct section and messenger wire section in the form of line chart layer with being loaded into GIS Presented on figure.
On the basis of above-mentioned technical proposal, the fiber optic cable management system also includes ftp server, ODN NM servers The resource file packing of line resource is uploaded to the ftp server, and is sent to pipeline modules and carries ftp server correlation The PUSH message of information, pipeline modules download the line resource of ODN NM servers upload from ftp server indirectly.
On the basis of above-mentioned technical proposal, the line resource also includes pore, sub-aperture and messenger wire, the mouth of pipe and son Hole is shown in the cross section of the duct section, and the messenger wire is shown in the messenger wire section.
On the basis of above-mentioned technical proposal, the Web client first obtains current GIS map visual range, visits again The pipeline modules, and to send inquiry current visible in the range of line resource inquiry request, the pipeline modules according to ask Ask and inquire line resource in the range of current visible, and give Query Result list response to the Web client.
On the basis of above-mentioned technical proposal, the Web client travels through the list, according to the longitude and latitude and bar of pipeline The longitude and latitude on road graphical pointv covering in GIS map, and shown respectively with pipeline icon and pole line icon, according to pipe well and electricity The longitude and latitude of bar graphical pointv covering in GIS map, shown with.
On the basis of above-mentioned technical proposal, the relevant information of the duct section includes title, the pipe well and pipeline at both ends The longitude and latitude set passed through;The relevant information of the messenger wire section includes the longitude and latitude that title, the electric pole at both ends and pole line are passed through Degree set;Web client travels through the list, and the flex point using the longitude and latitude set of duct section as line is drawn in GIS map Line covering, the flex point using the longitude and latitude set of messenger wire section as line draws line covering in GIS map, and passes through different face Color distinguishes duct section and messenger wire section.
The present invention provides a kind of optical cable segment querying method, and optical cable segment includes duct section or messenger wire section, including step:
Step 1. usage right requires that line resource is presented in GIS map in any methods describeds of 1-6;
Step 2. selectes duct section or messenger wire section in the GIS map, and determines both ends according to selected duct section Pipe well, or determine according to selected messenger wire section the electric pole at both ends;
Step 3. respectively using the pipe well at both ends or electric pole as the center of circle, by pre-set radius r formed two it is circular Query context, inquire about all optical cross boxes and connector box in each query context;
Step 4. filters to the optical cross box and connector box that inquire, removes the data of repetition;
All optical cable segments that optical cross box after step 5. query filter connects with connector box, are filtered off except repeat number again According to obtaining optical cable segment all in the query context.
All optical cross boxes and the mode of connector box in query context are obtained on the basis of above-mentioned technical proposal, in step 3 For:
The maximum longitude and latitude of query context and minimum longitude and latitude where step 31. calculates optical cross box and connector box;
Step 32. further filters out and distance of center circle in the rectangular extent that maximum longitude and latitude and minimum longitude and latitude obtain From the optical cross box and connector box less than pre-set radius r.
On the basis of above-mentioned technical proposal, step 31 specifically includes:
By the longitude and latitude of any two points in GIS map, distance between two points distance is calculated,
Wherein, lon1 and lat1 is longitude and latitude wherein, and lon2 and lat2 are the longitude and latitude of another point, R is earth radius, and π is pi;The longitude and latitude for setting the center of circle are respectively lon and lat, calculate in query context longitude and The deviation of latitude is as follows:
Wherein, toDegrees represents to change radian into angled, deltaLon expression difference of longitude, deltaLat expressions Latitudinal difference;Obtain minimum longitude lon-deltaLon, maximum longitude lon+deltaLon;Minimum latitude lat-deltaLat, Maximum latitude lat+deltaLat.
On the basis of above-mentioned technical proposal, the pre-set radius r=500m.
The beneficial effects of the present invention are:
1st, the method that line resource is presented by GIS, presented in GIS map in a manner of a figure layer and line chart layer various Pipeline resource, intuitively shows optical cable segment very much, there is provided optical cable segment information.Also, GIS map shows pore and son by pipeline Hole, the specifying information of optical cable must be identified by optical cable segment, the entanglement for avoiding optical cable superposition is shown.
2nd, can be the GIS of cable resource be presented by calculating maximum longitude and latitude and minimum longitude and latitude in GIS map In figure, optical cross box and connector box in query context are fast and accurately found, and then obtain the optical cable segment in query context.
3rd, the line resource includes pipe well, pipeline, duct section, pore, sub-aperture, electric pole, pole line, messenger wire and messenger wire section Relevant information, the relevant information comprise at least title and corresponding longitude and latitude.Web client according to pipe well, pipeline, pole line and The longitude and latitude of electric pole, respectively the graphical pointv covering in GIS map, pipeline and pole line and respectively with pipeline icon and electric pole icon It has been shown that, pipe well and electric pole are shown with, and can be distinguished by different colours.Web client is by the longitude and latitude of duct section Set and the longitude and latitude set of pole line are divided into the flex point as line, and line covering is drawn in GIS map, and with different colors Duct section and pole line are made a distinction.Allow users to the positional information of global all resources of assurance and substantially walking for optical routing To clear patterns understand, facilitate user to search resource.Can be by pipeline system query available resources then before optical cable laying Planned again, efficiency can be provided, and accuracy can be ensured.
Brief description of the drawings
Fig. 1 is the method flow diagram that line resource is presented in GIS of the present invention;
Fig. 2 is that line resource is presented to the flow chart in GIS map in the present invention;
Fig. 3 is optical cable section querying method flow chart.
Embodiment
The present invention is described in further detail below in conjunction with drawings and Examples.
The method that line resource is presented in GIS of the present invention, based on fiber optic cable management system.Fiber optic cable management system includes pipeline mould Block, ODN NM servers and Web client, pipeline modules connect ODN NM servers, ODN nets by WebService agreements Pipe server memory has line resource, and line resource includes pipe well, pipeline, duct section, electric pole, pole line letter related to messenger wire section Breath, relevant information include title and corresponding longitude and latitude or longitude and latitude set;Line resource also includes pore, sub-aperture and hung Line, the mouth of pipe and sub-aperture are shown in the cross section of duct section, and messenger wire is shown in the messenger wire section.
As shown in figure 1, the method that line resource is presented in GIS comprises the following steps:
S1. pipeline modules download line resource.Specifically, pipeline modules can be downloaded directly from ODN NM servers Line resource, line resource can also be indirectly downloaded by other means.For example, fiber optic cable management system also includes a FTP Server, when pipeline modules initialize, the packing notice to ODN NM server outgoing pipeline resources;Then ODN network manager services Device packs the resource file of line resource, and is uploaded to ftp server by File Transfer Protocol, then sends and carry to pipeline modules The PUSH message of ftp server relevant information;Pipeline modules parse PUSH message, connect ftp server, download the resource text Part is to locally.So by ftp server, line resource is downloaded indirectly in a manner of resource file, can greatly improve resource The loading efficiency of data, ensure that fiber optic cable management system is rapidly and effectively run.
S2.Web clients access pipeline modules, pipe well, pipeline, electric pole and the bar of inquiry request will be met in resource file The form of Lu Yidian figure layers is loaded into GIS map and presented, by duct section and messenger wire section in the form of line chart layer with being loaded into GIS Presented on figure.
As shown in Fig. 2 in S2, mode line resource being presented in GIS map is as follows:
S201.Web clients obtain current GIS map visual range, and send inquiry current visible model to pipeline modules Enclose the request of gut line resource.
S202. pipeline modules are according to the inquiry request of Web client, from local cache inquiry meet the pipeline money of condition Source.For example, when line resource is pipeline, relevant information includes pipe name and corresponding longitude and latitude etc.;When line resource is pole line, Relevant information includes pole line name and corresponding longitude and latitude etc..When line resource is duct section, relevant information include pipeline name section, The longitude and latitude set that pipe ends and duct section are passed through, the longitude and latitude of two end points of pipeline is comprised at least in longitude and latitude set Degree, and two end points of pipeline are pipe well.When line resource is messenger wire section, relevant information includes messenger wire name section, messenger wire section two The longitude and latitude set that end and messenger wire section are passed through, comprises at least the longitude and latitude of messenger wire section two-end-point in longitude and latitude set, and hangs Two end points of line segment are electric pole.
S203. pipeline modules by Query Result list response to Web client.
All line resources in the traversal response results list of S204.Web clients, in the form of a figure layer and line chart layer It is loaded into GIS map.Specifically, according to the longitude and latitude of pipeline and the longitude and latitude of pole line, graphical pointv covers in GIS map respectively Cover material, and shown respectively with pipeline icon and electric pole icon, pipe well and electric pole are also the graphical pointv covering in GIS map, point Do not represented with, the point of different colours can be used to distinguish.In pipeline can also TV pore and sub-aperture, the messenger wire between messenger wire section Have on GIS shown.The longitude and latitude set of duct section and the longitude and latitude set of messenger wire section are divided into the flex point as line, Line covering is drawn in GIS map, and is made a distinction duct section and pole line with different colors.
As shown in figure 3, optical cable section querying method, optical cable segment includes duct section or messenger wire section, including step:
Line resource is presented in GIS map according to the method described above in step 1..
Step 2. selectes duct section or messenger wire section in the GIS map, and determines both ends according to selected duct section Pipe well, or determine according to selected messenger wire section the electric pole at both ends.
Step 3. respectively using the pipe well at both ends or electric pole as the center of circle, by pre-set radius r formed two it is circular Query context, inquire about all optical cross boxes and connector box in each query context.Wherein, pre-set radius r can be according in implementation Different situations and set, r=500m in the present embodiment.
Step 4. filters to the optical cross box and connector box that inquire, removes the data of repetition.
All optical cable segments that optical cross box after step 5. query filter connects with connector box, are filtered off except repeat number again According to obtaining optical cable segment all in the query context.
In above-mentioned steps 3, all optical cross boxes and the mode of connector box in query context of obtaining are:
The maximum longitude and latitude of query context and minimum longitude and latitude where step 31. calculates optical cross box and connector box.
Step 32. further filters out and distance of center circle in the rectangular extent that maximum longitude and latitude and minimum longitude and latitude obtain From the optical cross box and connector box less than pre-set radius r.
The specific algorithm of step 31 is as follows:
Step 310. by the longitudes and latitudes of any two points in GIS map, if longitude and latitude wherein be lon1 and Lat1, the longitude and latitude of another point are lon2 and lat2, calculate distance between two points distance, calculation formula is as follows:
Wherein, R is earth radius, and π is pi;
The longitude and latitude in the step 311. setting center of circle are respectively lon and lat, calculate longitude and latitude in query context Deviation.
Difference of longitude
Latitudinal difference
Wherein, toDegrees represents to change radian into angled, deltaLon expression difference of longitude, deltaLat expressions Latitudinal difference.
Therefore query context can be contracted to following scope by step 312.:
Minimum longitude lon-deltaLon, maximum longitude lon+deltaLon;
Minimum latitude lat-deltaLat, maximum latitude lat+deltaLat.
The present invention is not limited to the above-described embodiments, for those skilled in the art, is not departing from On the premise of the principle of the invention, some improvements and modifications can also be made, these improvements and modifications are also considered as the protection of the present invention Within the scope of.The content not being described in detail in this specification belongs to prior art known to professional and technical personnel in the field.

Claims (10)

1. a kind of method that line resource is presented in GIS, based on fiber optic cable management system, it is characterised in that fiber optic cable management system includes Pipeline modules, ODN NM servers and Web client, have line resource in ODN NM servers, and line resource includes pipe Well, pipeline, duct section, electric pole, the relevant information of pole line and messenger wire section, relevant information include title, and corresponding longitude and latitude Or longitude and latitude set, the step include:
S1. pipeline modules download the line resource;
S2.Web clients access pipeline modules, will meet in resource file pipe well, pipeline, electric pole and the pole line of inquiry request with The form of point figure layer, which is loaded into GIS map, to be presented, and duct section and messenger wire section are loaded into GIS map in the form of line chart layer Present.
2. the method that line resource is presented in GIS as claimed in claim 1, it is characterised in that:The fiber optic cable management system is also wrapped Including ftp server, the resource file packing of line resource is uploaded to the ftp server by ODN NM servers, and to pipeline Module sends the PUSH message for carrying ftp server relevant information, and pipeline modules download ODN webmasters clothes from ftp server indirectly The line resource that business device uploads.
3. the method that line resource is presented in GIS as claimed in claim 1, it is characterised in that:The line resource also includes pipe Hole, sub-aperture and messenger wire, the mouth of pipe and sub-aperture are shown in the cross section of the duct section, and the messenger wire is shown in the messenger wire section In.
4. the method that line resource is presented in GIS as claimed in claim 1, it is characterised in that:The Web client, which first obtains, to be worked as Preceding GIS map visual range, the pipeline modules are visited again, and the inquiry of line resource in the range of current visible is inquired about to transmission Request, the line resource that the pipeline modules go out in the range of current visible according to requesting query, and by Query Result list response To the Web client.
5. the method that line resource is presented in GIS as claimed in claim 4, it is characterised in that:Described in the Web client traversal List, the graphical pointv covering in GIS map according to the longitude and latitude of pipeline and the longitude and latitude of pole line, and respectively with pipeline icon and Pole line icon shows, according to the longitude and latitude of pipe well and electric pole in GIS map graphical pointv covering, shown with.
6. the method that line resource is presented in GIS as claimed in claim 5, it is characterised in that:The relevant information of the duct section The longitude and latitude set passed through including title, the pipe well at both ends and pipeline;The relevant information of the messenger wire section includes title, both ends Electric pole and the longitude and latitude set passed through of pole line;Web client travels through the list, using the longitude and latitude set of duct section as The flex point of line draws line covering in GIS map, and the flex point using the longitude and latitude set of messenger wire section as line is painted in GIS map Line covering processed, and distinguish duct section and messenger wire section by different colours.
7. a kind of optical cable segment querying method, optical cable segment includes duct section or messenger wire section, it is characterised in that including step:
Step 1. usage right requires that line resource is presented in GIS map in any methods describeds of 1-6;
Step 2. selectes duct section or messenger wire section in the GIS map, and the pipe at both ends is determined according to selected duct section Well, or determine according to selected messenger wire section the electric pole at both ends;
Step 3. forms two circular inquiries respectively using the pipe well at both ends or electric pole as the center of circle, by a pre-set radius r Scope, inquire about all optical cross boxes and connector box in each query context;
Step 4. filters to the optical cross box and connector box that inquire, removes the data of repetition;
All optical cable segments that optical cross box after step 5. query filter connects with connector box, filter off except duplicate data, obtain again All optical cable segments in the query context.
8. optical cable segment querying method as claimed in claim 7, it is characterised in that all light in query context are obtained in step 3 The mode for handing over case and connector box is:
The maximum longitude and latitude of query context and minimum longitude and latitude where step 31. calculates optical cross box and connector box;
Step 32. further filters out small with circle center distance in the rectangular extent that maximum longitude and latitude and minimum longitude and latitude obtain In pre-set radius r optical cross box and connector box.
9. optical cable segment querying method as claimed in claim 8, it is characterised in that step 31 specifically includes:
By the longitude and latitude of any two points in GIS map, distance between two points distance is calculated,
<mrow> <mi>d</mi> <mi>i</mi> <mi>s</mi> <mi>t</mi> <mi>a</mi> <mi>c</mi> <mi>n</mi> <mi>e</mi> <mo>=</mo> <mn>2</mn> <mo>*</mo> <mi>arctan</mi> <mn>2</mn> <mrow> <mo>(</mo> <msqrt> <mi>a</mi> </msqrt> <mo>,</mo> <msqrt> <mrow> <mn>1</mn> <mo>-</mo> <mi>a</mi> </mrow> </msqrt> <mo>)</mo> </mrow> <mo>*</mo> <mi>R</mi> <mo>;</mo> </mrow>
<mrow> <mi>a</mi> <mo>=</mo> <msup> <mi>sin</mi> <mn>2</mn> </msup> <mrow> <mo>(</mo> <mfrac> <mrow> <mi>d</mi> <mi>L</mi> <mi>a</mi> <mi>t</mi> </mrow> <mn>2</mn> </mfrac> <mo>)</mo> </mrow> <mo>+</mo> <mi>cos</mi> <mrow> <mo>(</mo> <mfrac> <mrow> <mi>l</mi> <mi>a</mi> <mi>t</mi> <mn>1</mn> <mo>*</mo> <mi>&amp;pi;</mi> </mrow> <mn>180</mn> </mfrac> <mo>)</mo> </mrow> <mo>*</mo> <mi>cos</mi> <mrow> <mo>(</mo> <mfrac> <mrow> <mi>l</mi> <mi>a</mi> <mi>t</mi> <mn>2</mn> <mo>*</mo> <mi>&amp;pi;</mi> </mrow> <mn>180</mn> </mfrac> <mo>)</mo> </mrow> <mo>*</mo> <msup> <mi>sin</mi> <mn>2</mn> </msup> <mrow> <mo>(</mo> <mfrac> <mrow> <mi>d</mi> <mi>L</mi> <mi>o</mi> <mi>n</mi> </mrow> <mn>2</mn> </mfrac> <mo>)</mo> </mrow> <mo>;</mo> </mrow>
Wherein, lon1 and lat1 is longitude and latitude wherein, and lon2 and lat2 are the longitude and latitude of another point, and R is Earth radius, π are pi;
It is respectively lon and lat to set the longitude in the center of circle and latitude, and it is as follows to calculate the deviation of longitude and latitude in query context:
<mrow> <mi>d</mi> <mi>e</mi> <mi>l</mi> <mi>t</mi> <mi>a</mi> <mi>L</mi> <mi>o</mi> <mi>n</mi> <mo>=</mo> <mi>t</mi> <mi>o</mi> <mi>D</mi> <mi>e</mi> <mi>g</mi> <mi>r</mi> <mi>e</mi> <mi>e</mi> <mi>s</mi> <mrow> <mo>(</mo> <mn>2</mn> <mo>*</mo> <mi>arcsin</mi> <mo>(</mo> <mfrac> <mrow> <mi>sin</mi> <mrow> <mo>(</mo> <mfrac> <mi>r</mi> <mrow> <mn>2</mn> <mo>*</mo> <mi>R</mi> </mrow> </mfrac> <mo>)</mo> </mrow> </mrow> <mrow> <mi>c</mi> <mi>o</mi> <mi>s</mi> <mrow> <mo>(</mo> <mi>t</mi> <mi>o</mi> <mi>R</mi> <mi>a</mi> <mi>d</mi> <mi>i</mi> <mi>a</mi> <mi>n</mi> <mi>s</mi> <mo>(</mo> <mrow> <mi>l</mi> <mi>a</mi> <mi>t</mi> </mrow> <mo>)</mo> <mo>)</mo> </mrow> </mrow> </mfrac> <mo>)</mo> <mo>)</mo> </mrow> <mo>;</mo> </mrow>
<mrow> <mi>d</mi> <mi>e</mi> <mi>l</mi> <mi>t</mi> <mi>a</mi> <mi>L</mi> <mi>a</mi> <mi>t</mi> <mo>=</mo> <mi>t</mi> <mi>o</mi> <mi>D</mi> <mi>e</mi> <mi>g</mi> <mi>r</mi> <mi>e</mi> <mi>e</mi> <mi>s</mi> <mrow> <mo>(</mo> <mfrac> <mi>r</mi> <mi>R</mi> </mfrac> <mo>)</mo> </mrow> <mo>;</mo> </mrow>
Wherein, toDegrees represents to change radian into angled, deltaLon expression difference of longitude, deltaLat expression latitudes Deviation;
Obtain minimum longitude lon-deltaLon, maximum longitude lon+deltaLon;Minimum latitude lat-deltaLat, maximum latitude Spend lat+deltaLat.
10. optical cable segment querying method as claimed in claim 7, it is characterised in that:The pre-set radius r=500m.
CN201710911747.6A 2017-09-29 2017-09-29 Method for presenting pipeline resources by GIS and method for inquiring optical cable section Active CN107707399B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710911747.6A CN107707399B (en) 2017-09-29 2017-09-29 Method for presenting pipeline resources by GIS and method for inquiring optical cable section

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710911747.6A CN107707399B (en) 2017-09-29 2017-09-29 Method for presenting pipeline resources by GIS and method for inquiring optical cable section

Publications (2)

Publication Number Publication Date
CN107707399A true CN107707399A (en) 2018-02-16
CN107707399B CN107707399B (en) 2021-02-26

Family

ID=61175718

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710911747.6A Active CN107707399B (en) 2017-09-29 2017-09-29 Method for presenting pipeline resources by GIS and method for inquiring optical cable section

Country Status (1)

Country Link
CN (1) CN107707399B (en)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108833002A (en) * 2018-04-28 2018-11-16 烽火通信科技股份有限公司 A kind of optical link detection method and system based on passive optical network
CN109101688A (en) * 2018-07-06 2018-12-28 烽火通信科技股份有限公司 A kind of method of template type customization duct section sectional view
CN110401598A (en) * 2018-04-25 2019-11-01 中国移动通信集团设计院有限公司 Pipeline topological automatic discovering method, apparatus and system
CN111404601A (en) * 2020-03-20 2020-07-10 南京科舜通信科技有限公司 Method for accurately positioning physical position of optical cable
CN114118947A (en) * 2021-11-09 2022-03-01 南京亿合尤讯信息技术有限公司 Automatic arrangement method for pipeline resource data
CN114362814A (en) * 2022-01-12 2022-04-15 南京昕天卫光电科技有限公司 GIS map-based display method and monitoring system for optical cable positioning points

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101988961A (en) * 2009-08-04 2011-03-23 武汉武大卓越科技有限责任公司 Geographic location data collecting system
CN103166774A (en) * 2011-12-09 2013-06-19 中国移动通信集团福建有限公司 Checking method and device of the same route
CN104090927A (en) * 2014-06-20 2014-10-08 北京奇虎科技有限公司 Lineation searching method and device based on electronic map
CN104767642A (en) * 2015-04-08 2015-07-08 烽火通信科技股份有限公司 ODN line distribution management method and system based on GIS platform

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101988961A (en) * 2009-08-04 2011-03-23 武汉武大卓越科技有限责任公司 Geographic location data collecting system
CN103166774A (en) * 2011-12-09 2013-06-19 中国移动通信集团福建有限公司 Checking method and device of the same route
CN104090927A (en) * 2014-06-20 2014-10-08 北京奇虎科技有限公司 Lineation searching method and device based on electronic map
CN104767642A (en) * 2015-04-08 2015-07-08 烽火通信科技股份有限公司 ODN line distribution management method and system based on GIS platform

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
SOFTFAIR: "根据2个经纬度点,计算这2个经纬度点之间的距离", 《HTTPS://WWW.CNBLOGS.COM/SOFTFAIR/P/DISTANCE_OF_TWO_LATITUDE_AND_LONGITUDE_POINTS.HTML》 *
杨焕新: "基于Openlayer的通信网GIS平台的研究", 《中国优秀硕士学位论文全文数据库基础科学辑》 *

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110401598A (en) * 2018-04-25 2019-11-01 中国移动通信集团设计院有限公司 Pipeline topological automatic discovering method, apparatus and system
CN108833002A (en) * 2018-04-28 2018-11-16 烽火通信科技股份有限公司 A kind of optical link detection method and system based on passive optical network
CN109101688A (en) * 2018-07-06 2018-12-28 烽火通信科技股份有限公司 A kind of method of template type customization duct section sectional view
CN109101688B (en) * 2018-07-06 2022-06-17 烽火通信科技股份有限公司 Method for drawing pipeline section sectional drawing in template mode
CN111404601A (en) * 2020-03-20 2020-07-10 南京科舜通信科技有限公司 Method for accurately positioning physical position of optical cable
CN114118947A (en) * 2021-11-09 2022-03-01 南京亿合尤讯信息技术有限公司 Automatic arrangement method for pipeline resource data
CN114362814A (en) * 2022-01-12 2022-04-15 南京昕天卫光电科技有限公司 GIS map-based display method and monitoring system for optical cable positioning points

Also Published As

Publication number Publication date
CN107707399B (en) 2021-02-26

Similar Documents

Publication Publication Date Title
CN107707399A (en) The method and optical cable segment querying method of line resource is presented in a kind of GIS
CN104104595B (en) A kind of optical cable based on GIS is the same as route analysis method and device
CN103379032B (en) The acquisition methods and device, sub-route computational entity of cross-domain end-to-end route
CN103684582A (en) Distribution network communication optical cable fault location method and device
ATE326805T1 (en) METHOD AND ARRANGEMENTS IN A TELECOMMUNICATIONS SYSTEM
CN107959681B (en) Access path determines method and device to IP network end to end
CN109155760A (en) Path is grouped using fixed header size to record
CN104348691B (en) A kind of fiber link dispatching method, equipment and system
CN104796193A (en) Method for quick querying and locating of optical cable link relation
CN105007220B (en) Inter-domain routing manages system, method, field adapter and transmission network
CN107782329A (en) A kind of the determination method, apparatus and system of the voice that navigates
CN107566236A (en) For obtaining the methods, devices and systems in client&#39;s special line teleservice path
CN107749872A (en) A kind of fiber optic cable management system and resource loading method based on GIS
CN103618974B (en) A kind of expansion method of optical-fiber network
CN105429798A (en) Network configuration system for the internet of things
CN107925702B (en) Method, apparatus, computer readable medium for detecting a broken binder
CN104156828A (en) Portable communication resource management system based on geographic information
CN106685521A (en) Method and apparatus of predicting resource margin early warning for optical communication network
CN109450661A (en) Service release surveying method and device based on GIS map
CN102811256B (en) A kind of method and system for realizing application layer transmission optimization
CN105530135B (en) A kind of Topology display method and apparatus
CN107302467A (en) The management method and access device of access device
CN102780617A (en) Method and apparatus for dividing provider-defined network location identifier (PID), and application-layer traffic optimization (ALTO) server
CN113381803A (en) Network monitoring method and device
CN114199227B (en) Navigation path planning method and device

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant