CN113177100A - Method for rapidly drawing and revising line positioning diagram - Google Patents

Method for rapidly drawing and revising line positioning diagram Download PDF

Info

Publication number
CN113177100A
CN113177100A CN202110561597.7A CN202110561597A CN113177100A CN 113177100 A CN113177100 A CN 113177100A CN 202110561597 A CN202110561597 A CN 202110561597A CN 113177100 A CN113177100 A CN 113177100A
Authority
CN
China
Prior art keywords
line
positioning
equipment
starting point
diagram
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
CN202110561597.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.)
Individual
Original Assignee
Individual
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 Individual filed Critical Individual
Priority to CN202110561597.7A priority Critical patent/CN113177100A/en
Publication of CN113177100A publication Critical patent/CN113177100A/en
Pending legal-status Critical Current

Links

Images

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/29Geographical information databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/06Energy or water supply
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06TIMAGE DATA PROCESSING OR GENERATION, IN GENERAL
    • G06T11/002D [Two Dimensional] image generation
    • G06T11/20Drawing from basic elements, e.g. lines or circles
    • G06T11/206Drawing of charts or graphs

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Health & Medical Sciences (AREA)
  • Economics (AREA)
  • Databases & Information Systems (AREA)
  • Water Supply & Treatment (AREA)
  • Primary Health Care (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • General Health & Medical Sciences (AREA)
  • Public Health (AREA)
  • Remote Sensing (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Navigation (AREA)

Abstract

The invention relates to a method for rapidly drawing and revising a line location diagram. The method is characterized by comprising the following steps: 1) drawing a line positioning diagram: 1.1) compiling a hierarchical relation directory tree of the line equipment; 1.2) setting a starting point device unit and an end point device unit, and respectively inputting positioning coordinates; 1.3) respectively calculating the positioning coordinates of other equipment units such as electric poles between two points; 1.4) drawing a line positioning diagram containing the positioning information of the equipment; 2) changing and modifying the line positioning diagram: 2.1) modifying the positioning coordinate of equipment units such as a certain electric pole, and setting the modified positioning coordinate as a starting point; 2.2) starting from the starting point, searching each line segment connected with the starting point, and screening equipment units such as electric poles and the like one by one from near to far; 2.3) recalculating the positioning coordinates of other electric poles and other equipment units between the two points; 2.4) automatically drawing the line positioning diagram again. The method can draw the initially used route walking diagram in a short time and is convenient to update quickly in the using process.

Description

Method for rapidly drawing and revising line positioning diagram
Technical Field
The invention relates to a method for rapidly drawing and revising a line location diagram.
Background
Generally, the distribution line location diagram used at present is inconvenient to draw and revise. According to the results of the actual on-site investigation, the reasons are mainly:
1. the primary drawing workload is large, the drawing period is long, and the drawing cannot be put into use in a short time.
2. When the drawing is changed after the drawing is finished, the modification is inconvenient, and the drawing can not be used as soon as the modification is finished, so that the drawing can be obtained as soon as the viewing is finished.
Disclosure of Invention
The invention aims to provide a method for quickly drawing and revising a line positioning diagram, which can draw a line positioning diagram which can be used preliminarily in a short time and is convenient to update quickly in the using process.
In order to realize the purpose of the invention, the technical scheme adopted by the invention is as follows: a method for rapidly drawing and revising a route positioning diagram is characterized by comprising the following steps:
1) drawing a line positioning diagram
1.1) compiling a line equipment hierarchical relation directory tree in a computer or a mobile phone APP;
1.2) setting a starting point device unit and a terminal point device unit in a hierarchical relation directory tree of the line device, and respectively inputting positioning coordinates;
1.3) respectively calculating the positioning coordinates of other electric poles and other equipment units between the two points by a computer according to the positioning coordinates of the starting point and the ending point and an equipment list in a hierarchical relation directory tree of the line equipment;
1.4) automatically drawing the line positioning diagram containing the positioning information of the equipment by a computer according to the positioning coordinates of the starting point, the terminal point and other equipment units such as electric poles;
2) changing and modifying the line location diagram
2.1) after the line positioning diagram line segment is drawn, modifying the positioning coordinate of a certain electric pole and other equipment units on a computer or a mobile phone APP, and setting the modified positioning coordinate as a starting point;
2.2) starting from the starting point, searching each line segment connected with the starting point, screening equipment units such as electric poles and the like one by one from near to far, and if the positioning coordinate information of the equipment units is generated by non-automatic calculation, setting the positioning coordinate information as the end points of the line segment;
2.3) the computer recalculates the positioning coordinates of other electric poles and other equipment units between the two points according to the positioning coordinates of the starting point and the ending point and the equipment list in the directory tree;
and 2.4) automatically drawing the line positioning diagram again by the computer according to the positioning coordinates of the starting point, the end point and other equipment units such as electric poles.
According to the technical scheme, in the step 2.3), if the coordinate of a certain node in the line is changed and the lower-level T-connection line needs to be updated, the node is added into an update task table, and the update tasks are sequentially executed.
The APP also includes executable files and applications such as micro websites, public numbers or applets (APP refers to third party application of the smartphone).
The invention has the beneficial effects that: 1. the primary drawing workload is small, and the primary service cycle is short. Only need on the computer or install the cell-phone of APP the starting point and the terminal point of manual positioning line respectively, the computer just can be according to line equipment directory tree (being line equipment hierarchical relation directory tree), and preliminary line location picture is accomplished in the automatic drawing, can provide basic show and the location function of approximate direction, has reduced drawing work load, has shortened the drawing cycle, can put into preliminary use in the short time.
2. The later change is convenient to modify, and the time consumed for automatically redrawing after modification is short. When the coordinate positioning of a certain line device is changed, the line positioning diagram which is drawn is convenient to modify. As long as on computer or the cell-phone of installing APP, line equipment unit coordinates such as a certain pole of relocation can be according to preset program, in the short time, the automatic drawing accomplishes new circuit location picture, realizes on the APP map basically promptly and changes promptly, sees promptly and obtains.
Drawings
FIG. 1 is a template diagram of filling out an electronic form according to the present invention.
FIG. 2 is a screenshot of an automatically generated directory tree of the present invention.
FIG. 3 is a diagram of the present invention defining starting point latitude and longitude coordinates.
FIG. 4 is a diagram of the present invention defining the latitude and longitude coordinates of an endpoint.
FIG. 5 is a diagram of the computer automatically drawing the completed route location.
Fig. 6 is a diagram in which modified location coordinates are set as a starting point in accordance with the present invention.
FIG. 7 is a diagram of the present invention for automatically drawing a new line location map.
Detailed Description
As shown in fig. 1-7, a method for rapidly drawing and revising a route location diagram includes the following steps:
1. step-by-step drawing of line positioning diagram
1.1, compiling a hierarchical relation directory tree of the line equipment in a computer or a mobile phone APP.
1.1.1 compiling a hierarchical relation table of the line equipment. And describing the associated information according to the relationship between the line equipment, and filling the electronic form according to the following format template. As depicted in fig. 1, the second row "012 switch" is depicted as "10 kV municipal 116 line [57], (10kV municipal 116 line #003) town branch line [17], (town branch line # 002)", which means "10 kV municipal 116 line-total 57-base pole, with town branch line branching at 3 rd base pole; the 17-base electric pole is used as a branch, and a 012 disconnecting link is arranged on the 2 nd base electric pole of the branch.
1.1.2, writing an automatic import program, importing the hierarchical relationship table of the line equipment into a computer, and automatically generating a hierarchical relationship directory tree of the line equipment, wherein the following is a screenshot of the hierarchical relationship directory tree of the line equipment, as shown in fig. 2.
1.2 setting a starting point device unit and an end point device unit in the hierarchical relation directory tree of the line device, and respectively inputting positioning coordinates.
1.2.1 defines the starting point of the line.
As shown in fig. 3, longitude and latitude coordinates of the starting point (pole No. 0) of a 10kV little yellow dragon line are defined, and the address is the national hospital (main road of people 170) in city town in north and Hu province.
1.2.2 defines the line end point.
In the hierarchical relation directory tree of the line equipment, a starting point equipment unit and an end point equipment unit are arranged, and positioning coordinates are respectively input. As shown in fig. 4, longitude and latitude coordinates of a 10kV miniyellow dragon line terminal point (428 # electric pole) are defined, and the address is the people's government of stone town of chongyang county in Hubei province (No. 6 new street construction).
1.3 according to the positioning coordinates of the starting point and the ending point and the equipment list in the hierarchical relation directory tree of the line equipment, the computer respectively calculates the positioning coordinates of other equipment units such as electric poles between the two points. The algorithm specifically includes the following functions:
atan () is used to calculate the arctan, returning an angular range between-pi/2 to pi/2.
Abs () returns the absolute value of the argument. The parameters may be int, float, long, double, short, byte types.
Pi calculates the circumference of a given radius.
And the Getinglats () calculates the longitude and latitude of each node through the longitude and latitude of the a, the latitude of the b and the number of the nodes.
1.4 according to the starting point, the end point and the positioning coordinates of other electric poles and other equipment units, the computer automatically draws the line positioning diagram containing the positioning information of the equipment. The algorithm specifically includes the following functions:
the Map component is used to show maps.
Markers marker points are used to display the location of the marker on the map.
Polyline specifies a series of coordinate points, connecting the first to the last entry of the array.
The computer automatically draws a line positioning diagram of the completed 10kV small yellow dragon line, as shown in fig. 5.
2. Changing and modifying line positioning diagram
2.1 after the line positioning diagram line segment is drawn, in a computer or a mobile phone with an APP, modifying the positioning coordinates of equipment units (line equipment units) such as a certain electric pole, and setting the modified positioning coordinates as a starting point.
As shown in fig. 6, the coordinate position of the 100 th base electric pole of the 10kV little yellow dragon line is manually modified as follows: tongcheng county, sand town, nine well street number 1.
2.2 the computer searches each line segment connected with the starting point, screens the equipment units such as the electric pole and the like from near to far one by one, and sets the line segment as the end point if the positioning coordinate information of the equipment units is generated by non-automatic calculation. The algorithm specifically comprises the following query statements:
after the modification of SELECT id, text, latitudelengiute, startequi-frequency FROM equality WHERE pid ═ id + ',' and isdel ═ 0'and left (type,1) ═ line' ORDER BY sort ASC// start point, each line segment connected with the same is found.
The method comprises the steps of modifying a UPDATE equipment SET coordinate ═ '+ lathelinggitude +', a lathelinggitedjes ═ '+ lathelinggitude +', a zt ═ 1'where id ═ one id +', and a starting point, sequentially updating the coordinates of the first rods of the line segments connected with the updated initial rods, and setting an artificial dotting mark.
SELECT FROM (SELECT CASE WHEN SIGN (ID- "+ thisid +") >0THEN 'Next' ELSE 'Prev' END AS DIR, CASE WHERE SIGN (ID- "+ thisid +") >0THEN MIN (ID) WHERE SIGN (ID- "+ thisid +") <0THEN MAX (ID) END AS ID FROM (SELECT FROM equivalent WHERE pid '"+ 0 and type ═ rod' and zt '1' ORDER BY sour ASC) equivalent WHERE ID <" > "+ pid +" + position "+ SIGN" + 0'and type "+ rod and zt" + 1' ORDER BY soap) is connected to the origin DIR "+ ground + SIGN (ID-" + thisid + ") or DIR BY" + i + grid + SIGN (ID- + DIR + ") and DIR + wt +/wt + DIR +.
2.3 the computer recalculates the positioning coordinates of other electric poles and other equipment units between the two points according to the positioning coordinates of the starting point and the ending point and the equipment list in the directory tree; if the coordinate of a certain node in the line changes and the next-level T-connection line needs to be updated, the node is added into the update task table, and the update tasks are executed in sequence. The algorithm specifically includes the following functions or statements:
atan () is used to calculate the arctan, returning an angular range between-pi/2 to pi/2.
Abs () returns the absolute value of the argument. The parameters may be int, float, long, double, short, byte types.
Pi calculates the circumference of a given radius.
And the Getinglats () calculates the longitude and latitude of each node through the longitude and latitude of the a, the latitude of the b and the number of the nodes.
Linemarkerupdata () updates all tower coordinates of the line, the first tower coordinates of the line and the coordinates of other equipment of the line. If the coordinate of a certain node in the line changes and the next-level T-connection line needs to be updated, the node is added into the update task table, and the update tasks are executed in sequence.
And 2.4, automatically drawing the line positioning diagram again by the computer according to the starting point, the end point and the positioning coordinates of other equipment units such as electric poles. The algorithm specifically includes the following functions:
the Map component is used to show maps.
Markers marker points are used to display the location of the marker on the map.
Polyline specifies a series of coordinate points, connecting the first to the last entry of the array.
After changing the coordinate position of the 100 th base electric pole of the 10kV small yellow dragon line, the computer automatically draws and completes a new line positioning diagram as shown in fig. 7.

Claims (3)

1. A method for rapidly drawing and revising a route positioning diagram is characterized by comprising the following steps:
1) drawing a line positioning diagram
1.1) compiling a line equipment hierarchical relation directory tree in a computer or a mobile phone APP;
1.2) setting a starting point device unit and a terminal point device unit in a hierarchical relation directory tree of the line device, and respectively inputting positioning coordinates;
1.3) respectively calculating the positioning coordinates of other electric poles and other equipment units between the two points by a computer according to the positioning coordinates of the starting point and the ending point and an equipment list in a hierarchical relation directory tree of the line equipment;
1.4) automatically drawing the line positioning diagram containing the positioning information of the equipment by a computer according to the positioning coordinates of the starting point, the terminal point and other equipment units such as electric poles;
2) changing and modifying the line location diagram
2.1) after the line positioning diagram line segment is drawn, modifying the positioning coordinate of a certain electric pole and other equipment units on a computer or a mobile phone APP, and setting the modified positioning coordinate as a starting point;
2.2) starting from the starting point, searching each line segment connected with the starting point, screening equipment units such as electric poles and the like one by one from near to far, and if the positioning coordinate information of the equipment units is generated by non-automatic calculation, setting the positioning coordinate information as the end points of the line segment;
2.3) the computer recalculates the positioning coordinates of other electric poles and other equipment units between the two points according to the positioning coordinates of the starting point and the ending point and the equipment list in the directory tree;
and 2.4) automatically drawing the line positioning diagram again by the computer according to the positioning coordinates of the starting point, the end point and other equipment units such as electric poles.
2. The method for rapidly drawing and revising the line location graph according to claim 1, wherein in the step 2.3), if the coordinate of a node in the line changes and the next-level T-line needs to be updated, the node is added into the update task table, and the update tasks are sequentially executed.
3. The method for rapidly drawing and revising the route location graph according to claim 1, wherein the APP also includes a micro website, a public account or an applet.
CN202110561597.7A 2021-05-22 2021-05-22 Method for rapidly drawing and revising line positioning diagram Pending CN113177100A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110561597.7A CN113177100A (en) 2021-05-22 2021-05-22 Method for rapidly drawing and revising line positioning diagram

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110561597.7A CN113177100A (en) 2021-05-22 2021-05-22 Method for rapidly drawing and revising line positioning diagram

Publications (1)

Publication Number Publication Date
CN113177100A true CN113177100A (en) 2021-07-27

Family

ID=76929776

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110561597.7A Pending CN113177100A (en) 2021-05-22 2021-05-22 Method for rapidly drawing and revising line positioning diagram

Country Status (1)

Country Link
CN (1) CN113177100A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114936442A (en) * 2022-07-22 2022-08-23 国网江西省电力有限公司电力科学研究院 System and method for accurately positioning power distribution network equipment and forming topological graph

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101086787A (en) * 2007-06-07 2007-12-12 朱桂永 A method for quickly drawing power line map or geographical roadmap
CN102737393A (en) * 2012-06-13 2012-10-17 朱桂永 Method and system for drawing vector diagram of overhead line
CN109460911A (en) * 2018-10-30 2019-03-12 云南电网有限责任公司昆明供电局 A kind of the path drawing drawing method and device of power equipment

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101086787A (en) * 2007-06-07 2007-12-12 朱桂永 A method for quickly drawing power line map or geographical roadmap
CN102737393A (en) * 2012-06-13 2012-10-17 朱桂永 Method and system for drawing vector diagram of overhead line
CN109460911A (en) * 2018-10-30 2019-03-12 云南电网有限责任公司昆明供电局 A kind of the path drawing drawing method and device of power equipment

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
陈世君等: "基于自动成图算法的城市配电网走径图设计", 《广东科技》 *
雷聚超等: "电力线路CAD图形自动生成研究", 《西安工业大学学报》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114936442A (en) * 2022-07-22 2022-08-23 国网江西省电力有限公司电力科学研究院 System and method for accurately positioning power distribution network equipment and forming topological graph
CN114936442B (en) * 2022-07-22 2022-12-09 国网江西省电力有限公司电力科学研究院 System and method for accurately positioning power distribution network equipment and forming topological graph

Similar Documents

Publication Publication Date Title
CN109918832B (en) Modeling method and device for expressway tunnel project
US10921136B2 (en) Efficient processing for vector tile generation
CN105138793B (en) Distribution network line QuickDraw method
CN111639408B (en) AR technology-based urban pipe network pipeline 3D model display method and system
CN103984556B (en) A kind of map area construction equipment, method and monitor terminal
KR20140109198A (en) User based map manufacturing apparatus
CN103955566A (en) Electric transmission line three-dimensional design method based on Google Earth and electric transmission line three-dimensional design system based on Google Earth
CN111506685A (en) Fusion drawing method and system and electronic equipment
CN105808578A (en) Method and device for incremental updating of electronic map
CN113177100A (en) Method for rapidly drawing and revising line positioning diagram
CN104867402A (en) Offline reverse geocoding method, device thereof and terminal equipment
CN104462402A (en) Pipe network data compilation system
CN103646091A (en) Generation method and device of grid graph data
CN106294484B (en) A kind of method and device updating electronic map data
CN105045815A (en) Data collecting method and apparatus
JP2021179959A (en) Method and apparatus for updating road network data, electronic device and storage medium
Pylarinos et al. Incorporating open/free GIS and GPS software in power transmission line routine work: the case of Crete and Rhodes
CN107480306A (en) In rapid extraction OSM data in self-defined polygonal region road network method
CN105466418A (en) A map positioning method and a device
CN108470363A (en) A kind of hand-drawing map location method based on geographic reference point and triangulation
CN111581311A (en) Data processing method and device, readable storage medium and electronic equipment
CN101290675A (en) Electric network information management system and its exhibition method
CN103729800A (en) Water conservancy planning system
CN106529841A (en) Handheld GIS modern agricultural park management system based on Android platform
CN107665211A (en) Geographic data updates maintenance system based on mobile planning application 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: 20210727