CN105389300A - Method for importing two-dimensional table data into distribution network GIS (Geographic Information System) system to automatically generate 10kV device data - Google Patents
Method for importing two-dimensional table data into distribution network GIS (Geographic Information System) system to automatically generate 10kV device data Download PDFInfo
- Publication number
- CN105389300A CN105389300A CN201510707873.0A CN201510707873A CN105389300A CN 105389300 A CN105389300 A CN 105389300A CN 201510707873 A CN201510707873 A CN 201510707873A CN 105389300 A CN105389300 A CN 105389300A
- Authority
- CN
- China
- Prior art keywords
- data
- distribution network
- distribution
- gis
- information system
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Abstract
The present invention provides a method for importing a two-dimensional table data into a distribution network GIS (Geographic Information System) system to automatically generate 10Kv device data. The distribution network GIS system that is used as a management platform of graphical data and account data of a distribution network device provides an informatization means for distribution network service personnel in daily management work of distribution network. However, since the number of the distribution network device is enormous, if a traditional data maintenance means is adopted, a large number of data entry personnel is needed to perform data entry for a long period, and problematic data is prone to being generated in an entry process. The method provided by the present invention implements conversion from simple two-dimensional table data to complex multi-dimensional distribution network GIS data; and automatic generation of distribution network GIS data is performed by the method, so that data quality of the power distribution GIS system can be effectively ensured, and various data entry problems possibly caused by manual entry are avoided.
Description
Technical field
Distribution GIS device comprises the multidimensional information such as graphic assembly, attribute assembly, electric topology relationship component, present invention achieves the automatic generation from two-dimentional list data to distribution GIS device information, complete the automatic drafting of distribution GIS device, the sequence of operations such as electric topology relation is set up, the Auto-writing of attribute information.
Background technology
China's electrical network scale development is rapid, and the development of particularly distribution is maked rapid progress.Along with the continuous expansion of distribution scale, distribution management level is had higher requirement.The graph data of distribution generalized information system as distribution net equipment, the management platform of account data, for distribution business personnel provides information-based means in the daily management mission of distribution.
But due to distribution net equipment enormous amount, as adopted traditional data maintenance means, the mode of namely one by one manual typing, needing a large amount of data inputting personnel, in distribution generalized information system, carrying out long data inputting work.And the use of distribution generalized information system exists certain complexity, distribution generalized information system data are also comparatively various, comprise the multiple types of datas such as attribute data, graph data, topological data.If rely on manual entry and maintenance completely, there is maintenance workload large, drop into personnel many, and the problem of easily makeing mistakes.
Summary of the invention
A kind ofly import two-dimentional list data generates 10kV device data automatically method to distribution generalized information system, the technology of the present invention feature is: adopt Excel form as data carrier, fill in through data, data check, data pre-generatmg, data submit four steps to, realize the automatic generation of distribution GIS data;
First, the distribution GIS device data generated are needed according to Excel template filling in documents; Secondly, fill in laggard row data check, only have the data meeting distribution generalized information system rule just by verification, can to point out for the data not meeting rule.3rd, by data pre-generatmg, realize the automatic mapping of distribution GIS device, data genaration.4th, for pregenerated data, can submit to.If need to adjust Excel file, also can select destruction operation, after adjustment completes, again import into figure.
The invention has the beneficial effects as follows the conversion achieved from simple bivariate table lattice data to complex multi-dimensional data, the automatic generation of distribution GIS data is carried out by this technical method, effectively can ensure the quality of data of its distribution generalized information system, avoid the various data quality problems that manual entry may bring.Simultaneously, be automatically imported into the batch input that figure achieves distribution GIS data, this simplifies the data inputting work of distribution generalized information system effectively, drastically increase data inputting, maintenance efficiency, reduce exponentially traditional data typing, safeguard needed for working time, saved a large amount of data inputting and maintenance cost thus.
Accompanying drawing explanation
Fig. 1 is block diagram of the present invention.
Embodiment
See Fig. 1, a kind ofly import two-dimentional list data generates 10kV device data automatically method to distribution generalized information system, the technology of the present invention feature is: adopt Excel form as data carrier, fill in through data, data check, data pre-generatmg, data submit four steps to, realize the automatic generation of distribution GIS data;
First, the distribution GIS device data generated are needed according to Excel template filling in documents; Secondly, fill in laggard row data check, only have the data meeting distribution generalized information system rule just by verification, can to point out for the data not meeting rule.3rd, by data pre-generatmg, realize the automatic mapping of distribution GIS device, data genaration.4th, for pregenerated data, can submit to.If need to adjust Excel file, also can select destruction operation, after adjustment completes, again import into figure.
Embodiment imports the process of two-dimentional list data to distribution generalized information system automatic mapping:
Step 1: fill in the facility information needing to import in Excel form, mainly comprise several kind equipments such as shaft tower, pole type transformer, on-pole switch, wire, cable;
Step 2: verify the Excel list data filled in, verification rule comprises the contents such as subordinate relation correctness, power grid topological relation correctness, data required item, the correct span of data.For meet verification rule, clearly point out the mistake of existence, be convenient to modify and adjust; For completely meet rule, then by verification, prompting can carry out import operation.
Step 3: data pre-generatmg, carries out the automatic mapping operation of batch by the electric network data of satisfied rule.Automatically equipment in Excel form is drawn in graphical interfaces in distribution generalized information system, and the attribute data of automatic filling equipment, automatically generate the grid topology data of equipment room, namely build the annexation of equipment room, relation of inclusion, set membership.
Step 4: after data pre-generatmg, directly can carry out submit operation, submits to after also can finely tuning pre-generatmg data again, submits pregenerated device data for actual data to.Meanwhile, also can perform rollback operation, cancel pregenerated equipment.
Claims (1)
1. one kind imports two-dimentional list data generates 10kV device data automatically method to distribution generalized information system, the technology of the present invention feature is: adopt Excel form as data carrier, fill in through data, data check, data pre-generatmg, data submit four steps to, realize the automatic generation of distribution GIS data; First, the distribution GIS device data generated are needed according to Excel template filling in documents; Then, fill in laggard row data check, only have the data meeting distribution generalized information system rule just by verification, can to point out for the data not meeting rule; 3rd, by data pre-generatmg, realize the automatic mapping of distribution GIS device, data genaration; 4th, for pregenerated data, can submit to; If need to adjust Excel file, also can select destruction operation, after adjustment completes, again import into figure.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510707873.0A CN105389300A (en) | 2015-10-27 | 2015-10-27 | Method for importing two-dimensional table data into distribution network GIS (Geographic Information System) system to automatically generate 10kV device data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510707873.0A CN105389300A (en) | 2015-10-27 | 2015-10-27 | Method for importing two-dimensional table data into distribution network GIS (Geographic Information System) system to automatically generate 10kV device data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105389300A true CN105389300A (en) | 2016-03-09 |
Family
ID=55421597
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510707873.0A Pending CN105389300A (en) | 2015-10-27 | 2015-10-27 | Method for importing two-dimensional table data into distribution network GIS (Geographic Information System) system to automatically generate 10kV device data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105389300A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107146165A (en) * | 2017-04-24 | 2017-09-08 | 国网江西省电力公司经济技术研究院 | A kind of distribution layout data management method and system |
| CN108595372A (en) * | 2017-12-27 | 2018-09-28 | 广东电网有限责任公司东莞供电局 | A kind of large-scale data quick calculation method based on 10 KV distribution net generalized information systems |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20030062029A (en) * | 2002-01-16 | 2003-07-23 | 주식회사 타스테크 | A thematic mapping method for a statistical and analytical purpose based on the Excel program |
| CN102819766A (en) * | 2011-06-09 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method, device and enterprise system for checking forms |
| CN103577550A (en) * | 2013-10-16 | 2014-02-12 | 广东电网公司电力科学研究院 | Grid equipment data verification method |
| CN103606032A (en) * | 2013-11-05 | 2014-02-26 | 广东电网公司电力科学研究院 | Two-dimensional grid GIS data concentration method |
| CN103970862A (en) * | 2014-05-08 | 2014-08-06 | 国家电网公司 | Automatic generating system and method of power grid operation mode data |
| CN103970887A (en) * | 2014-05-20 | 2014-08-06 | 华南理工大学广州学院 | Information stream display system and method based on GIS distribution network graphs |
| CN104572653A (en) * | 2013-10-12 | 2015-04-29 | 北京航天长峰科技工业集团有限公司 | Method for quickly constructing topological relation of metro mass video camera |
-
2015
- 2015-10-27 CN CN201510707873.0A patent/CN105389300A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20030062029A (en) * | 2002-01-16 | 2003-07-23 | 주식회사 타스테크 | A thematic mapping method for a statistical and analytical purpose based on the Excel program |
| CN102819766A (en) * | 2011-06-09 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method, device and enterprise system for checking forms |
| CN104572653A (en) * | 2013-10-12 | 2015-04-29 | 北京航天长峰科技工业集团有限公司 | Method for quickly constructing topological relation of metro mass video camera |
| CN103577550A (en) * | 2013-10-16 | 2014-02-12 | 广东电网公司电力科学研究院 | Grid equipment data verification method |
| CN103606032A (en) * | 2013-11-05 | 2014-02-26 | 广东电网公司电力科学研究院 | Two-dimensional grid GIS data concentration method |
| CN103970862A (en) * | 2014-05-08 | 2014-08-06 | 国家电网公司 | Automatic generating system and method of power grid operation mode data |
| CN103970887A (en) * | 2014-05-20 | 2014-08-06 | 华南理工大学广州学院 | Information stream display system and method based on GIS distribution network graphs |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107146165A (en) * | 2017-04-24 | 2017-09-08 | 国网江西省电力公司经济技术研究院 | A kind of distribution layout data management method and system |
| CN107146165B (en) * | 2017-04-24 | 2021-04-13 | 国网江西省电力公司经济技术研究院 | Distribution network planning data management method and system |
| CN108595372A (en) * | 2017-12-27 | 2018-09-28 | 广东电网有限责任公司东莞供电局 | A kind of large-scale data quick calculation method based on 10 KV distribution net generalized information systems |
| CN108595372B (en) * | 2017-12-27 | 2020-08-04 | 广东电网有限责任公司东莞供电局 | Large-scale data rapid calculation method based on 10 kV power distribution network GIS system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102999671A (en) | Computer design method of standard distribution network line | |
| CN104123227A (en) | Method for automatically generating testing cases | |
| CN104376171A (en) | Automatic design method and system for terminal block drawing and cable detailed list | |
| CN105701271B (en) | Method for creating and deleting equipment in graph-model hybrid simulation modeling of power system | |
| CN102779156A (en) | Configuration method for database of communication device in digital substation | |
| CN103093007A (en) | Power transmission iron tower three-dimensional virtual assembly method | |
| CN102521343A (en) | Transformation method of input data of simulation software of power system | |
| CN102999524A (en) | Method and system for searching document association | |
| CN103606032B (en) | A kind of method in two dimension power grid GIS data set | |
| CN104682560A (en) | Graphical verifying method for power distribution network model transaction | |
| CN104698374A (en) | Method for improving testing efficiency and accuracy of automatic relay protecting tester | |
| CN102591808A (en) | System and method for DCS (distributed control system) hardware configuration based on Excel | |
| CN105205039A (en) | Customizable SCD (substation configuration description) file verification method | |
| CN105389300A (en) | Method for importing two-dimensional table data into distribution network GIS (Geographic Information System) system to automatically generate 10kV device data | |
| US20170075923A1 (en) | Distribution management system | |
| CN104392104A (en) | Determination method for length and number of low-frequency cable conductors of spacecraft | |
| CN104750468A (en) | Server side topological data conversion method and device | |
| CN104243218B (en) | A kind of communication of power system mode list preparation method based on more schedule constraints | |
| CN109802487A (en) | A kind of main plant stand source maintenance function implementation method and device | |
| CN204258439U (en) | Intelligent electric power scheduling operation management system | |
| CN104298800A (en) | Three-dimensional integrated model of intelligent substation | |
| CN111026451A (en) | Parameter configuration method and configuration tool for transformer substation terminal interval | |
| CN105574002A (en) | SQL database-data file transmission method | |
| Peng et al. | Design and development of intelligent operation and maintenance training system for substation based on augmented reality | |
| CN114398742A (en) | Optical cable three-dimensional laying data processing system and processing method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160309 |