CN107844569A - Electric power special optical wire three-dimensional operational system - Google Patents

Electric power special optical wire three-dimensional operational system Download PDF

Info

Publication number
CN107844569A
CN107844569A CN201711070741.7A CN201711070741A CN107844569A CN 107844569 A CN107844569 A CN 107844569A CN 201711070741 A CN201711070741 A CN 201711070741A CN 107844569 A CN107844569 A CN 107844569A
Authority
CN
China
Prior art keywords
data
shaft tower
optical cable
electric power
equipment operation
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.)
Pending
Application number
CN201711070741.7A
Other languages
Chinese (zh)
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.)
Wuxi Power Supply Co of State Grid Jiangsu Electric Power Co Ltd
Original Assignee
Wuxi Power Supply Co of State Grid Jiangsu Electric Power 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 Wuxi Power Supply Co of State Grid Jiangsu Electric Power Co Ltd filed Critical Wuxi Power Supply Co of State Grid Jiangsu Electric Power Co Ltd
Priority to CN201711070741.7A priority Critical patent/CN107844569A/en
Publication of CN107844569A publication Critical patent/CN107844569A/en
Pending legal-status Critical Current

Links

Classifications

    • 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/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database
    • 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/26Visual data mining; Browsing structured data
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Remote Sensing (AREA)
  • Instructional Devices (AREA)
  • Electric Cable Installation (AREA)

Abstract

The present invention relates to a kind of electric power special optical wire three-dimensional operational system, it is characterized in that:Including data storage cell, using display unit, geographical information collection unit and equipment operation management unit;The data storage cell is connected with application display unit, geographical information collection unit and equipment operation management unit, and data storage cell stores to satellite map data, shaft tower and lightguide cable link geography information, shaft tower and optical cable three-dimensional modeling data and optical cable and all kinds of attribute informations of shaft tower;The application display unit carries out 3-D graphic displaying to lightguide cable link, shaft tower, landform;The geographical information collection unit is acquired to lightguide cable link and shaft tower geography information;The equipment operation management unit is managed maintenance to optical cable service data, and the optical cable data of collection in worksite are shown by tree menu.The present invention can improve the accuracy of lightguide cable link service data, subsidiary communications O&M and construction management, improve person works' efficiency.

Description

Electric power special optical wire three-dimensional operational system
Technical field
The present invention relates to a kind of electric power special optical wire three-dimensional operational system, belong to technical field of power systems.
Background technology
With the continuous expansion of power network scale, the distribution of the electric power special optical wire such as attached extension OPGW and ADSS is also more and more wider. The geographical position residing for overhead line structures, the topography and geomorphology around shaft tower, the geography information such as tour path of lightguide cable link are complete at present With operation maintenance personnel's inspection of the scene of a crime and Microsoft Excel is manually entered, efficiency is low, easily error, such as does not go to check for a long time, The geography information of these shaft towers will be smudgy, or even forgets, and optical cable is maked an inspection tour and maintainer often goes to the wrong way path, confuses bar Tower, the efficiency of work is had a strong impact on.
The content of the invention
The purpose of the present invention is to overcome the deficiencies in the prior art, there is provided a kind of electric power special optical wire three-dimensional O&M system System, improves the accuracy of lightguide cable link service data, while can reduce optical cable project design, the installing intersection frequency, and auxiliary is logical Believe O&M and construction management, improve person works' efficiency.
According to technical scheme provided by the invention, the electric power special optical wire three-dimensional operational system, it is characterized in that:Including number According to memory cell, using display unit, geographical information collection unit and equipment operation management unit;
The data storage cell is connected with application display unit, geographical information collection unit and equipment operation management unit, number According to memory cell to satellite map data, shaft tower and lightguide cable link geography information, shaft tower and optical cable three-dimensional modeling data and light Cable and all kinds of attribute informations of shaft tower are stored;
The application display unit carries out 3-D graphic displaying to lightguide cable link, shaft tower, landform;
The geographical information collection unit is acquired to lightguide cable link and shaft tower geography information;
The equipment operation management unit is managed maintenance to optical cable service data, and collection in worksite is shown by tree menu Optical cable data.
Further, the method that the data storage cell is stored is:Using SQL Server database technologys pair Various types of data carries out structured storage.
Further, the method using display unit progress 3-D graphic displaying is:Should based on satellite offline map With the electric force pole tower threedimensional model of 3Dmax technology to drawing is shown in map Local Data figure layers.
Further, the geographical information collection unit is to the method that geography information is acquired:Use Excell tables Lattice import data, convert KML format files by Utf-8 code compilers and automatically generate in Local Data figure layers.
Further, the optical cable data for the collection in worksite that the equipment operation management unit is shown include electric force pole tower type Number, optical cable hang high and connector box position.
Further, the equipment operation management unit carries out query modification and calling, selection to data using SQL statement The field attribute numerical information of lightguide cable link is checked in field instruction needed for inquiry, is changed using compiler and is preserved field information simultaneously Upload database real-time update lightguide cable link field information.
The present invention has advantages below:
(1)Based on satellite map technology, the particular geographic location of electric force pole tower, topography and geomorphology, electric power special optical wire laying are realized Situation carries out Three-dimensional Display, provides first-hand clear accurate operational data for optic cable design, construction operation, help is built and transported Administrative staff carries out decision-making;
(2)Using hierarchical architecture design, accomplish the slight coupling between functional hierarchy, and use database linking technology, realize The functions such as the inquiry of optical cable data message, typing, modification, carry out directly perceived with concentration showing under three-dimensional scenic;
(3)Using text formatting switch technology, Excel table statistics shaft towers geography information conversion KML formatted data information is led Enter system, realize Mass production lightguide cable link geography information function, improve Data Enter efficiency.
Brief description of the drawings
Fig. 1 is the schematic diagram of electric power special optical wire three-dimensional operational system of the present invention.
Fig. 2 is the schematic diagram that the geographical information collection cell data imports.
Fig. 3 is the schematic diagram that the equipment operation management cell data is safeguarded.
Description of reference numerals:1- data storage cells, 2- applications display unit, 3- geographical information collections unit, 4- equipment Operation management unit.
Embodiment
With reference to specific accompanying drawing, the invention will be further described.
As shown in figure 1, electric power special optical wire three-dimensional operational system of the present invention includes data storage cell 1, using exhibition Show unit 2, geographical information collection unit 3 and equipment operation management unit 4;
The data storage cell 1 connects with application display unit 2, geographical information collection unit 3 and equipment operation management unit 4 Connect, data storage cell 1 is to satellite map data, shaft tower and lightguide cable link geography information, shaft tower and optical cable three-dimensional modeling data And optical cable and all kinds of attribute informations of shaft tower are stored, specific method is:Using SQL Server database technologys to all kinds of Data carry out structured storage, and number is provided for application display unit 2, geographical information collection unit 3 and equipment operation management unit 4 According to basis;
The application display unit 2 carries out 3-D graphic displaying to lightguide cable link, shaft tower, landform, and specific method is:Based on satellite Offline map application, by the electric force pole tower threedimensional model of 3Dmax technology to drawing in map Local Data(Local data)Figure layer Middle displaying, and the geography information of optical cable segment, the operation surrounding environment of true reappearance electric power special optical wire and attached extension situation are combined, dash forward Go out to show optical cable segment is whether there is across emphasis geography information such as high speed, railway, navigation channels;
The geographical information collection unit 3 is acquired to lightguide cable link and shaft tower geography information, and specific method is:Use UEditor building block techniques and hierarchical architecture design, accomplish the slight coupling between functional hierarchy;Number is imported using Excell forms According to being converted and KML format files and automatically generated in Local Data figure layers by Utf-8 code compilers(As shown in Figure 2), it is real Editor, modification and the inquiry of existing geography information;
The equipment operation management unit 4 is managed maintenance to optical cable service data, and collection in worksite is shown by tree menu Optical cable data, including electric force pole tower model, optical cable hang height, the service data such as connector box position(As shown in table 1).It can pass through The data of focus are checked after click icon, equipment the defects of point, cable run joint image content, cable can be selected Circuit profile, display is removed by closing display, the data gathered can also be inquired by input condition and carry For function corresponding to a coordinate.Specific method is:Data are carried out with query modification and calling, selection inquiry using SQL statement The field attribute numerical information of lightguide cable link is checked in required field instruction, and system is changed using compiler and preserves field information simultaneously Upload database real-time update lightguide cable link field information(As shown in Figure 3).
Table 1
The present invention is realized geo-location and the displaying of dimensional topography landforms of lightguide cable link, realized by aforementioned four unit The attribute of cable line section optical cable and the inquiry editor of shaft tower coordinate attributes and correction, greatly improve Construction of Optical Cable Line design With the operating efficiency of attendant, avoid the field exploring verification of repetition and effectively reduce geographical location information error Rate.
By electric power special optical wire, the outdoor scene on map shows the present invention using 3-D technology, and by optical cable model, tower, shelves It is associated away from frequently-used datas such as, hanging points, improves the matching degree with live fiber cable laying situation, improves lightguide cable link service data Accuracy, while can reduce optical cable project design, the installing intersection frequency, subsidiary communications O&M and construction management, improve people Member's operating efficiency.

Claims (6)

1. a kind of electric power special optical wire three-dimensional operational system, it is characterized in that:Including data storage cell(1), using display unit (2), geographical information collection unit(3)With equipment operation management unit(4);
The data storage cell(1)With using display unit(2), geographical information collection unit(3)With equipment operation management list Member(4)Connection, data storage cell(1)It is three-dimensional to satellite map data, shaft tower and lightguide cable link geography information, shaft tower and optical cable Model data and all kinds of attribute informations of optical cable and shaft tower are stored;
It is described to apply display unit(2)3-D graphic displaying is carried out to lightguide cable link, shaft tower, landform;
The geographical information collection unit(3)Lightguide cable link and shaft tower geography information are acquired;
The equipment operation management unit(4)Maintenance is managed to optical cable service data, showing scene by tree menu adopts The optical cable data of collection.
2. electric power special optical wire three-dimensional operational system as claimed in claim 1, it is characterized in that:The data storage cell(1) The method stored is:Structured storage is carried out to Various types of data using SQL Server database technologys.
3. electric power special optical wire three-dimensional operational system as claimed in claim 1, it is characterized in that:Specific method is:The application Display unit(2)Carry out 3-D graphic displaying method be:Based on satellite offline map application, by the electricity of 3Dmax technology to drawing Power pole tower three-dimensional model is shown in map Local Data figure layers.
4. electric power special optical wire three-dimensional operational system as claimed in claim 1, it is characterized in that:Specific method is:The geography Information acquisition unit(3)It is to the method that geography information is acquired:Data are imported using Excell forms, are compiled by Utf-8 Code compiler conversion KML format files are simultaneously automatically generated in Local Data figure layers.
5. electric power special optical wire three-dimensional operational system as claimed in claim 1, it is characterized in that:Specific method is:The equipment Operation management unit(4)The optical cable data of the collection in worksite shown include electric force pole tower model, optical cable hangs high and connector box position Put.
6. electric power special optical wire three-dimensional operational system as claimed in claim 1, it is characterized in that:Specific method is:The equipment Operation management unit(4)Data are carried out with query modification and calling using SQL statement, light is checked in field instruction needed for selection inquiry The field attribute numerical information on cable road, changed using compiler and preserve field information and upload database real-time update optical cable Line field information.
CN201711070741.7A 2017-11-03 2017-11-03 Electric power special optical wire three-dimensional operational system Pending CN107844569A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201711070741.7A CN107844569A (en) 2017-11-03 2017-11-03 Electric power special optical wire three-dimensional operational system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201711070741.7A CN107844569A (en) 2017-11-03 2017-11-03 Electric power special optical wire three-dimensional operational system

Publications (1)

Publication Number Publication Date
CN107844569A true CN107844569A (en) 2018-03-27

Family

ID=61682236

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201711070741.7A Pending CN107844569A (en) 2017-11-03 2017-11-03 Electric power special optical wire three-dimensional operational system

Country Status (1)

Country Link
CN (1) CN107844569A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114638938A (en) * 2022-04-11 2022-06-17 北京信义恒科技有限公司 Optical cable monitoring method, device, system, electronic equipment and storage medium
CN116881670A (en) * 2023-09-01 2023-10-13 国网江苏省电力有限公司扬州供电分公司 Communication optical cable attachment checking method based on GIS map

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102760255A (en) * 2012-07-19 2012-10-31 福建省电力有限公司福州电业局 Underground power network data management and power network planning system and management method
CN102945297A (en) * 2012-10-17 2013-02-27 西宁供电公司 Display system for assembly of electric power poles and towers
CN103258256A (en) * 2013-04-12 2013-08-21 国家电网公司 Cable line condition monitoring multi-dimensional visual management platform
CN103632240A (en) * 2013-12-13 2014-03-12 云南电网公司昆明供电局 Power transmission line three-dimensional visual operation system and establishing method thereof
CN106557892A (en) * 2016-12-08 2017-04-05 天津市矩辉数据科技有限公司 City Buried Pipeline GIS-Geographic Information System
CN106610958A (en) * 2015-10-21 2017-05-03 星际空间(天津)科技发展有限公司 Integrated management system of geographic information data

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102760255A (en) * 2012-07-19 2012-10-31 福建省电力有限公司福州电业局 Underground power network data management and power network planning system and management method
CN102945297A (en) * 2012-10-17 2013-02-27 西宁供电公司 Display system for assembly of electric power poles and towers
CN103258256A (en) * 2013-04-12 2013-08-21 国家电网公司 Cable line condition monitoring multi-dimensional visual management platform
CN103632240A (en) * 2013-12-13 2014-03-12 云南电网公司昆明供电局 Power transmission line three-dimensional visual operation system and establishing method thereof
CN106610958A (en) * 2015-10-21 2017-05-03 星际空间(天津)科技发展有限公司 Integrated management system of geographic information data
CN106557892A (en) * 2016-12-08 2017-04-05 天津市矩辉数据科技有限公司 City Buried Pipeline GIS-Geographic Information System

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
段慧娟: "基于Google Earth的海洋物理场数据可视化研究", 《海洋测绘》 *
赵静: "三维配电网地理信息系统的开发与研究", 《中国优秀硕士学位论文全文数据库》 *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114638938A (en) * 2022-04-11 2022-06-17 北京信义恒科技有限公司 Optical cable monitoring method, device, system, electronic equipment and storage medium
CN116881670A (en) * 2023-09-01 2023-10-13 国网江苏省电力有限公司扬州供电分公司 Communication optical cable attachment checking method based on GIS map
CN116881670B (en) * 2023-09-01 2024-06-11 国网江苏省电力有限公司扬州供电分公司 Communication optical cable attachment checking method based on GIS map

Similar Documents

Publication Publication Date Title
CN102760255B (en) Underground electric network data management and Electric Power Network Planning system and management method
CN105938613B (en) Intelligent city pipe network comprehensive platform based on BIM and VR and management method and construction method thereof
CN102509330B (en) Application of virtual three-dimensional system of transformer substation on the basis of electric power geographic information system (GIS)
CN104794755B (en) A kind of high-tension cable three-dimensional tube field of line scape construction method
CN106056349A (en) Province-city-county three-level power grid programming GIS drawing system and method
CN109360287A (en) Transmission line of electricity three-dimensional digital fortune inspection management system
CN106802993A (en) A kind of exhibiting method of the operation of the electric network swim under three-dimensional scenic
CN104899922A (en) Three-dimensional holographic generation method for intelligent power grid visualization application
CN103823935A (en) Three-dimensional remote monitoring system for wind power plant
CN107292989A (en) High voltage power transmission cruising inspection system based on 3DGIS technologies
CN103093008A (en) System and method for power transmission and transformation project three-dimensional-aided preliminary design
CN108491649A (en) A kind of design method and processing equipment of wind power plant digital Platform
CN104008218A (en) Electric power engineering three-dimensional integrated design platform
CN108764812A (en) A kind of digitalized design method of UHV transmission line
CN110188989A (en) One kind being based on three-dimensional visualization outdoor scene wisdom municipal administration system
CN110175368A (en) A kind of rail traffic data display systems based on BIM+GIS
CN108664666A (en) A kind of underground pipe gallery three dimensional device cruising inspection system
CN111489431A (en) Smart city planning simulation dynamic simulation system and operation method thereof
CN110134750A (en) A kind of information system of underground pipeline
CN107844569A (en) Electric power special optical wire three-dimensional operational system
CN103605680A (en) Function realization method for database map
CN105741340A (en) Transmission line 3D scene simulation method and transmission line 3D scene simulation system for webpage display
Bi et al. Research on the construction of City information modelling basic platform based on multi-source data
CN104281633B (en) Water conservancy information mobile navigation positioning system
CN202870564U (en) Digital mine safety production local area network system

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
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20180327