CN114118947A - Automatic arrangement method for pipeline resource data - Google Patents
Automatic arrangement method for pipeline resource data Download PDFInfo
- Publication number
- CN114118947A CN114118947A CN202111317034.XA CN202111317034A CN114118947A CN 114118947 A CN114118947 A CN 114118947A CN 202111317034 A CN202111317034 A CN 202111317034A CN 114118947 A CN114118947 A CN 114118947A
- Authority
- CN
- China
- Prior art keywords
- pipeline
- position information
- latitude
- longitude
- data
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 20
- 238000009434 installation Methods 0.000 claims abstract description 8
- XEEYBQQBJWHFJM-UHFFFAOYSA-N Iron Chemical compound [Fe] XEEYBQQBJWHFJM-UHFFFAOYSA-N 0.000 claims description 6
- 238000013507 mapping Methods 0.000 claims description 4
- 229910052742 iron Inorganic materials 0.000 claims description 3
- 238000012545 processing Methods 0.000 abstract description 3
- 239000013589 supplement Substances 0.000 abstract description 3
- 230000008676 import Effects 0.000 abstract description 2
- 230000003287 optical effect Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/10—Complex mathematical operations
- G06F17/18—Complex mathematical operations for evaluating statistical data, e.g. average values, frequency distributions, probability functions, regression analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F18/00—Pattern recognition
- G06F18/20—Analysing
- G06F18/24—Classification techniques
- G06F18/241—Classification techniques relating to the classification model, e.g. parametric or non-parametric approaches
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Mathematical Optimization (AREA)
- Pure & Applied Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- Evolutionary Biology (AREA)
- Mathematical Physics (AREA)
- Health & Medical Sciences (AREA)
- Bioinformatics & Computational Biology (AREA)
- Computational Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Operations Research (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Marketing (AREA)
- Life Sciences & Earth Sciences (AREA)
- Mathematical Analysis (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Water Supply & Treatment (AREA)
- Artificial Intelligence (AREA)
- Primary Health Care (AREA)
- General Health & Medical Sciences (AREA)
- Probability & Statistics with Applications (AREA)
- Public Health (AREA)
- Algebra (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Evolutionary Computation (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Laying Of Electric Cables Or Lines Outside (AREA)
Abstract
The invention relates to the technical field of cable bundling management, in particular to a method for automatically arranging pipeline resource data; classifying the pipeline resources according to an installation mode, numbering each pipeline, collecting position information of the pipeline resources by collection personnel, completing classification statistics of the position information, automatically searching the head and the tail of each subsection and each time collection according to the longitude and latitude trend of a pipeline line through simple numbering rules of pipeline resource equipment and data reporting or Excel import data, and automatically connecting the pipeline resources to present the pipeline resources in sequence; the possibility of data repetition is reduced by the classification and collection of personnel, and when the pipeline is disconnected, the actual location is searched according to the longitude and latitude of the disconnection point through the head and tail longitude and latitude collection of pipeline resources, so that the subsequent supplement is facilitated, the manual processing amount is reduced through the automatic table connection, and the accuracy is improved.
Description
Technical Field
The invention relates to the technical field of cable bundling management, in particular to a method for automatically arranging pipeline resource data.
Background
With the development of modern social economic technology, the demand of electric power consumption is continuously increased, the cable laying is complicated, the pipeline resource is a huge project in data acquisition and collection, and the data volume is huge, so that the on-site acquisition is required, and different groups of personnel are required to acquire the data simultaneously.
In the arrangement process, repeated collection and missing collection often occur, different optical cables or electric data are arranged on two sides of a road, and the positions of the data longitude and latitude are too close and often cross, so that the data longitude and latitude on a map are disordered.
Disclosure of Invention
The invention aims to provide an automatic sorting method for pipeline resource data, and aims to solve the technical problems that in the prior art, repeated collection and missing collection often occur in the sorting process, different optical cables or electric power data are arranged on two sides of a road, and the longitude and latitude positions of the data are too close and often cross, so that the longitude and latitude of the data on a map are disordered.
In order to achieve the above object, the present invention provides a method for automatically arranging pipeline resource data, comprising the following steps:
classifying the pipeline resources according to the installation mode, and numbering each pipeline;
collecting the position information of the pipeline resources by collection personnel to complete classification statistics of the position information;
summarizing the acquired address information and guiding the address information into a table of a PC (personal computer) end;
and connecting each pipeline by using the longitude and latitude of the head and the tail in the position information, displaying the pipelines in sequence, and mapping the pipelines to an electronic map to finish data arrangement of pipeline resources.
The pipeline resources are divided into an overhead section, a wall hanging section, a direct-buried section, a pipeline section, a channel section and a tunnel section.
The overhead section comprises an electric pole, a base station, an iron tower and a transformer substation, and the direct-buried section comprises an identifier and a cable well.
The method comprises the steps that collection personnel are grouped, and each group of collection personnel collect position information of the same category.
The position information comprises the starting longitude and latitude and the ending longitude and latitude of each pipeline resource and the trend of the pipeline.
The data are arranged by using a table, and two sections of position information of the initial longitude and latitude and the final longitude and latitude with the same value are arranged, so that the position information of each pipeline is separated.
The invention relates to a method for automatically arranging pipeline resource data, which classifies pipeline resources according to an installation mode, numbers each pipeline, collects position information of the pipeline resources by collection personnel, completes classification statistics of the position information, summarizes the collected address information, guides the collected address information into a table at a PC (personal computer) end, automatically searches the head and the tail of each subsection and each-time collection according to the longitude and latitude trend of a pipeline line by simple rule of pipeline resource equipment numbering and data reporting or Excel guide-in data, and enables the pipeline resources to be automatically connected to present the pipeline resources in sequence; the possibility of data repetition is reduced by the classification and collection of personnel, and when the pipeline is disconnected, the actual location is searched according to the longitude and latitude of the disconnection point through the head and tail longitude and latitude collection of pipeline resources, so that the subsequent supplement is facilitated, the manual processing amount is reduced through the automatic table connection, and the accuracy is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart of steps of a method for automatically sorting pipeline resource data provided by the present invention.
Fig. 2 is a partial tabular diagram after the concatenation of the location information provided by the present invention.
Detailed Description
Referring to fig. 1 and fig. 2, the present invention provides a method for automatically sorting pipeline resource data, including the following steps:
s1: classifying the pipeline resources according to the installation mode, and numbering each pipeline;
s2: collecting the position information of the pipeline resources by collection personnel to complete classification statistics of the position information;
s3: summarizing the acquired address information and guiding the address information into a table of a PC (personal computer) end;
s4: and connecting each pipeline by using the longitude and latitude of the head and the tail in the position information, displaying the pipelines in sequence, and mapping the pipelines to an electronic map to finish data arrangement of pipeline resources.
In step S1, the pipeline resources include cables and optical cables, and are classified according to installation methods as follows:
an overhead section: the system is composed of N electric poles, N base stations, N iron towers, N transformer substations and the like.
Wall hanging section: is formed by hanging N wall hanging positions.
A direct-buried section: consists of N monuments, a manhole/hand manhole.
A pipeline section: the system consists of N control component sections.
And (3) a trench section: consists of N landmark segments.
And (3) tunnel section: the device consists of N tunnel wall hanging points.
In step S2, the collection persons are grouped, and each group of collection persons collects position information of the same category, so that the collection targets of the collection persons are simplified, and the possibility of data omission and data repetition is reduced; the position information comprises the starting longitude and latitude and the ending longitude and latitude of each section of pipeline resource and the trend of the pipeline.
In step S3, the collection point is divided into regions, the point where the pipeline contacts the boundary of the region is used as the pipeline starting point, the pipeline is numbered, and the number and the collected position information are imported into the table; in the importing process, the data input sequence does not affect the final linking result, so that the data importing speed is increased.
In step S4, the data is arranged by using a table, and two pieces of position information of the start longitude and latitude and the end longitude and latitude of the same value are arranged, thereby separating the position information of each pipeline; as shown in fig. 2, X and Y respectively represent coordinates obtained by latitude and longitude, Z represents the direction of a pipeline, measurement is performed with the starting point of the section, the south on the map is taken as 0 °, the offset angle of the extending part of the pipeline is Z °, the end point of a single-section pipeline is the starting point of an adjacent pipeline, the same data is captured for arrangement, the pipelines are connected, and the pipelines are mapped to an electronic map one by one through latitude data in a table, so that the formed pipeline map is clearer; automatically searching the head and the tail of each subsection and fractional acquisition according to the longitude and latitude trend of the pipeline line through the simple numbering rule of the pipeline resource equipment and data reporting or Excel import data, and automatically connecting the head and the tail to enable pipeline resources to be presented in sequence; the possibility of data repetition is reduced by the classification and collection of personnel, and when the pipeline is disconnected, the actual location is searched according to the longitude and latitude of the disconnection point through the head and tail longitude and latitude collection of pipeline resources, so that the subsequent supplement is facilitated, the manual processing amount is reduced through the automatic table connection, and the accuracy is improved.
While the invention has been described with reference to a preferred embodiment, it will be understood by those skilled in the art that various changes in form and detail may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.
Claims (6)
1. A method for automatically arranging pipeline resource data is characterized by comprising the following steps:
classifying the pipeline resources according to the installation mode, and numbering each pipeline;
collecting the position information of the pipeline resources by collection personnel to complete classification statistics of the position information;
summarizing the acquired address information and guiding the address information into a table of a PC (personal computer) end;
and connecting each pipeline by using the longitude and latitude of the head and the tail in the position information, displaying the pipelines in sequence, and mapping the pipelines to an electronic map to finish data arrangement of pipeline resources.
2. The method of claim 1, wherein in the step of sorting pipeline resources by installation and numbering each pipeline:
the pipeline resources are divided into an overhead section, a wall hanging section, a direct-buried section, a pipeline section, a ditch section and a tunnel section.
3. The method of claim 2, wherein in the step of sorting the pipeline resources according to installation and numbering each pipeline:
the overhead section comprises an electric pole, a base station, an iron tower and a transformer substation, and the direct-buried section comprises an identifier and a cable shaft.
4. The method for automatically arranging the pipeline resource data according to claim 3, wherein in the step of collecting the position information of the pipeline resource by the collecting personnel and finishing the classified statistics of the position information:
the collection personnel are grouped, and each group of collection personnel collects the position information of the same category.
5. The pipeline resource data finishing method of claim 4,
the position information comprises the starting longitude and latitude and the ending longitude and latitude of each section of pipeline resource and the trend of the pipeline.
6. The method for automatically arranging the data of the pipeline resources according to claim 5, wherein in the step of finishing the data arrangement of the pipeline resources by utilizing the longitude and latitude of the head and the tail in the position information, connecting each pipeline, presenting the pipelines in sequence, and mapping the pipelines to an electronic map:
and arranging the data by using a table, and arranging two sections of position information of the initial longitude and latitude and the final longitude and latitude with the same value, thereby separating the position information of each pipeline.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111317034.XA CN114118947A (en) | 2021-11-09 | 2021-11-09 | Automatic arrangement method for pipeline resource data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111317034.XA CN114118947A (en) | 2021-11-09 | 2021-11-09 | Automatic arrangement method for pipeline resource data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114118947A true CN114118947A (en) | 2022-03-01 |
Family
ID=80377612
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111317034.XA Pending CN114118947A (en) | 2021-11-09 | 2021-11-09 | Automatic arrangement method for pipeline resource data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114118947A (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101930470A (en) * | 2010-09-07 | 2010-12-29 | 上海盈隽实业有限公司 | Urban power network geographic information system and urban pipeline geographic information system |
| CN101988961A (en) * | 2009-08-04 | 2011-03-23 | 武汉武大卓越科技有限责任公司 | Geographic location data collecting system |
| CN102842265A (en) * | 2012-08-27 | 2012-12-26 | 西安煤航信息产业有限公司 | Underground pipeline plane and cross section integration showing method |
| CN104820759A (en) * | 2015-05-20 | 2015-08-05 | 湖南大麓管道工程有限公司 | Data acquisition method and system of pipeline facility |
| CN107527079A (en) * | 2017-08-22 | 2017-12-29 | 李树平 | A kind of communication line resource management platform and communication line resource administration method |
| CN107707399A (en) * | 2017-09-29 | 2018-02-16 | 烽火通信科技股份有限公司 | The method and optical cable segment querying method of line resource is presented in a kind of GIS |
| CN110955741A (en) * | 2019-11-07 | 2020-04-03 | 国网甘肃省电力公司金昌供电公司 | Method for efficiently searching and positioning transmission line fault |
| CN112233251A (en) * | 2020-10-23 | 2021-01-15 | 广东电网有限责任公司广州供电局 | Cable direction marking method and device, electronic equipment and storage medium |
| CN112989527A (en) * | 2021-01-28 | 2021-06-18 | 上海淀山勘测有限公司 | Method for quickly mapping underground pipeline |
-
2021
- 2021-11-09 CN CN202111317034.XA patent/CN114118947A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101988961A (en) * | 2009-08-04 | 2011-03-23 | 武汉武大卓越科技有限责任公司 | Geographic location data collecting system |
| CN101930470A (en) * | 2010-09-07 | 2010-12-29 | 上海盈隽实业有限公司 | Urban power network geographic information system and urban pipeline geographic information system |
| CN102842265A (en) * | 2012-08-27 | 2012-12-26 | 西安煤航信息产业有限公司 | Underground pipeline plane and cross section integration showing method |
| CN104820759A (en) * | 2015-05-20 | 2015-08-05 | 湖南大麓管道工程有限公司 | Data acquisition method and system of pipeline facility |
| CN107527079A (en) * | 2017-08-22 | 2017-12-29 | 李树平 | A kind of communication line resource management platform and communication line resource administration method |
| CN107707399A (en) * | 2017-09-29 | 2018-02-16 | 烽火通信科技股份有限公司 | The method and optical cable segment querying method of line resource is presented in a kind of GIS |
| CN110955741A (en) * | 2019-11-07 | 2020-04-03 | 国网甘肃省电力公司金昌供电公司 | Method for efficiently searching and positioning transmission line fault |
| CN112233251A (en) * | 2020-10-23 | 2021-01-15 | 广东电网有限责任公司广州供电局 | Cable direction marking method and device, electronic equipment and storage medium |
| CN112989527A (en) * | 2021-01-28 | 2021-06-18 | 上海淀山勘测有限公司 | Method for quickly mapping underground pipeline |
Non-Patent Citations (5)
| Title |
|---|
| 尹薇薇;: "电力通信管线数据采集入库的设计和实现", 电力信息化, vol. 11, no. 05, 15 May 2013 (2013-05-15), pages 67 - 71 * |
| 曹艳杰等: "校园光缆资源的可视化管理研究", 中国教育信息化, no. 09, 5 May 2016 (2016-05-05), pages 64 - 67 * |
| 李志刚;: "地下管线自动编号方法的研究与实现", 城市勘测, no. 1, 28 February 2012 (2012-02-28), pages 104 - 106 * |
| 段杰;张德强;梁鹏;: "电信管线GIS的功能设计与数据组织", 山西建筑, vol. 34, no. 04, 1 February 2008 (2008-02-01), pages 362 - 363 * |
| 程霞;: "城镇埋地市政管线档案数字化及其应用", 科技视界, no. 23, 15 August 2016 (2016-08-15), pages 203 - 204 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102136192B (en) | Method for identifying trip mode based on mobile phone signal data | |
| CN109286188B (en) | 10kV power distribution network theoretical line loss calculation method based on multi-source data set | |
| CN111308264B (en) | Power distribution network single-phase earth fault section positioning method based on cosine similarity | |
| CN102879788A (en) | Power line extraction method of electric transmission line based on on-board LiDAR data | |
| CN104104595A (en) | GIS based optical cable same-route analysis method and device | |
| CN105046959B (en) | Urban Travel Time extracting method based on Dual-window shiding matching mechanism | |
| CN103812554A (en) | Method and auxiliary device for positioning fault point of optical cable | |
| CN109035783A (en) | A kind of virtual networks missing section automatic identifying method based on public transport GPS track | |
| CN107133236A (en) | The method and apparatus of geographical position track optimizing | |
| CN109408492A (en) | Railway power equipment record management system and its method based on fault location function | |
| CN113343396B (en) | Incremental distribution method from single line diagram of power distribution network to geographical wiring diagram | |
| CN114118947A (en) | Automatic arrangement method for pipeline resource data | |
| CN116958841B (en) | Unmanned aerial vehicle inspection system for power distribution line based on image recognition | |
| CN112364218B (en) | Ubiquitous access power optical cable data management system based on physical ID | |
| CN115276792B (en) | Optical cable common mode risk assessment method and system based on optical cable routing | |
| CN116170283A (en) | Processing method based on network communication fault system | |
| CN115375084B (en) | Graph database construction method and system based on power data | |
| CN110719445A (en) | Remote meter reading system and method based on image recognition | |
| CN114363824B (en) | Commute track depiction method and system based on MR (magnetic resonance) position and road GIS (geographic information System) information | |
| CN115546148A (en) | Method, device, equipment and medium for measuring length of overhead conductor in digital twin station area | |
| CN113076573B (en) | Computer-aided system for weak current design of rail transit | |
| CN102592108B (en) | Picture label information extracting method and device | |
| CN114123190A (en) | Method and device for determining target region to which ammeter belongs, electronic equipment and storage medium | |
| CN108427842B (en) | Power pipe network pipeline checking method based on interpolation point buffer area | |
| CN107807963B (en) | Method for rapidly searching power transmission network line collection area based on divide-and-conquer strategy |
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 |