CN109241216A - The method for realizing grid-based management using power grid hierarchical storage database schema - Google Patents

The method for realizing grid-based management using power grid hierarchical storage database schema Download PDF

Info

Publication number
CN109241216A
CN109241216A CN201810858325.1A CN201810858325A CN109241216A CN 109241216 A CN109241216 A CN 109241216A CN 201810858325 A CN201810858325 A CN 201810858325A CN 109241216 A CN109241216 A CN 109241216A
Authority
CN
China
Prior art keywords
grid
project
power grid
parameter
max
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201810858325.1A
Other languages
Chinese (zh)
Other versions
CN109241216B (en
Inventor
余清润
刘向实
张静
胡志勇
尚光伟
龚正国
徐华楠
杨娟
司都
秦亚东
陈庆岩
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Nanyang Power Supply Co of State Grid Henan Electric Power Co Ltd
Original Assignee
Nanyang Power Supply Co of State Grid Henan 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 Nanyang Power Supply Co of State Grid Henan Electric Power Co Ltd filed Critical Nanyang Power Supply Co of State Grid Henan Electric Power Co Ltd
Priority to CN201810858325.1A priority Critical patent/CN109241216B/en
Publication of CN109241216A publication Critical patent/CN109241216A/en
Application granted granted Critical
Publication of CN109241216B publication Critical patent/CN109241216B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • 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/00Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/06Electricity, gas or water supply

Abstract

The invention discloses provide a kind of method for realizing grid-based management using power grid hierarchical storage database schema, first, according to the natural characteristic of electric network composition, to classified using the contents of a project as the project volume data of separate storage body, data base administration in subregional, and store and transmit project volume data using densification format;Later, each project volume data includes the operational management parameter and geographic information data of the predefined various power grid elements of data base management system, and the associated calculation method of project volume data is automatically performed the electric topology of project needs, electrical parameter statistics and geometric parameter and calculates;Based on the present invention is according to power grid grade, operational management unit, using power grid project as the data base administration framework of basic unit of storage, by conventional GIS system with power grid element be management granularity be promoted to power grid project be management granularity, the storage unit that power grid element is opened up in project, greatly improves data management efficiency.

Description

The method for realizing grid-based management using power grid hierarchical storage database schema
Technical field
The present invention relates to the technical fields of power grid grid-based management, use power grid hierarchical storage data more particularly, to a kind of The method of library framework realization grid-based management.
Background technique
Currently, the background data base of electric power GIS application system is substantially relevant database, such as: Oracle, The classical relations type data base management system such as SQLserver, DB2, is stored in different record sheets by power grid element classification, number When less according to storage size, efficiency is not problem, and when forming mass data, the retrieval of project objective data will be seriously affected The efficiency of foreground application system, many systems seriously affect functionization because of the high speed expansion of database in practical application It is horizontal;Gridding planning, management and service are the important ideas that management is unfolded in each Utilities Electric Co. the present and the future, are grid The information system that change theory provides data supporting will have the technical capability of power grid element in quick, dynamic performance grid.
However, prior art frame is often manual retrieval and the integrated data for calculating grid interior element, inefficiency, number According to the problems such as inaccuracy than more serious.Relational data storage is due to constitution reasons in structure building quickly steady gridding support Framework is realized upper extremely difficult in informationization technology.
Application publication number is that the patent application of 108182194 A of CN discloses a kind of gridding division based on power grid GIS Management method, step 1: in power grid GIS geographical map press occupied area grid division;Step 2: calculating separately in a period of time Quantifiable indicator of each key business visual angle in each grid in range, and the power distributed according to each key business visual angle Weight ratio calculates the distribution operation trend overall performane in each grid;Step 3: by degree of concern that distribution operation trend is total Index is divided into 5 grades, with from shallowly filling grid to deep color.The patent application, will be multiple by ZOOM analysis unit The data of operation system carry out horizontal integrating, are effectively analyzed key business data and depth is excavated, and formation one can be with The achievement data of quantization, and it is weaker to combine power grid GIS figure with different colors intuitively to indicate which block region, according to face The operation trend situation of distribution is grasped in the variation of color in time, guarantees the healthy and stable operation of distribution.However, the patent application can only The management for carrying out operation of power networks parameter, can not realize the management of geographic information data.
Application publication number is that the patent application of CN105069703A discloses a kind of electrical network mass data management method, the party Method includes: building power grid user data management system, and each collected data of power grid subsystem are integrated, and using simultaneously Row Computational frame is excavated and is analyzed to the data of power grid user;Management system based on the data utilizes distributed terminator Prediction algorithm realizes parallel load prediction.The invention proposes a kind of electrical network mass data management method, is respectively by power grid user The data of system are merged and are integrated, and traditional data calculation method is moved in distributed platform, meet mass data Operation requirement.However, the invention can not be suitable for grid automation management of computing.
Summary of the invention
In view of this, using power grid hierarchical storage number in view of the deficiencies of the prior art, it is an object of the present invention to provide a kind of It is basic with power grid project based on power grid grade, operational management unit according to the method that library framework realizes grid-based management Conventional GIS system with power grid element is that management granularity is promoted to and is with power grid project by the data base administration framework of storage unit Granularity is managed, the storage unit of power grid element is opened up in project, data management efficiency is greatly improved, with this data service frame The gridding tenability provided based on frame, can automatically, accurately calculate grid contents, reach the various applications of gridding Real time implementation operation level.
In order to achieve the above objectives, the invention adopts the following technical scheme:
The method for realizing grid-based management using power grid hierarchical storage database schema, comprising the following steps:
Step 1, the natural characteristic according to electric network composition, to being carried out point using the contents of a project as the project volume data of separate storage body etc. Grade, data base administration in subregional, and project volume data is stored and transmitted using densification format;
Step 2, each project volume data include the operational management parameter of the predefined various power grid elements of data base management system And geographic information data, the associated calculation method of project volume data are automatically performed the electric topology of project needs, electrical parameter statistics It is calculated with geometric parameter;
Step 3, the mesh-managing parameter that various types and rank are defined according to regulatory requirement, calculate grids at different levels automatically The geometric parameter of nested management attribute and grid;
Step 4, the geometric parameter in conjunction with grid and data base management system mean terms purpose mesh-managing parameter utilize geometrical plane Enter option in Collision Detection mass-election grid, to greatly improve the rapidity, validity and overall efficiency of grid computing;
Project carries out intersection in step 5, the grid being selected in mass-election and comprising calculating, accurate calculation goes out the power grid for including in grid Project and electrical elements carry out statistics calculating to a variety of mesh parameters.
Further, in the step 1, the natural characteristic of electric network composition includes grade and operational management.
Further, in the step 1, the storage scheme of project volume data is as follows:
Data base management system manages multiple entity Grids simultaneously, and each entity Grid forms a partition holding, Each partition holding is a unit service example of data base management system, and is responsible for account in this subregion, status project, rule Project, whole management roles of grid system are drawn, opens up different storage sub-districts respectively according to item types in each subregion, respectively Project memory bank uses file densification storage format, and file name associated item meaning, and extension name is unified to use " .geplan " Suffix.
Further, in the step 3, the calculating of mesh-managing parameter includes the geometric area in geographical face domain, geometry packet Enclose box, geometric center, radius of electricity supply and profile set of vertices parameter.
Further, the profile set of vertices gain of parameter method is as follows:
A. the geometric coordinate scatter plot arrangement of project interior element is marked;
B. a border element is arbitrarily extracted as first starting point, then makees horizontal/vertical ray to right/left, later the inverse time Needle/rotate clockwise ray is then first element with the element of ray intersection;
C. using first element as second starting point, then obtain second element in the method for step b, and so on circulation Operation terminates operation when being first starting point with the element of ray intersection, then each starting point obtained in cycle operation process The as profile set of vertices in project geometric surface domain.
Further, in the step 2, it includes grid bounding box, profile set of vertices that the geometric parameter of grid, which calculates, Parameter calculates.
Further, in the profile set of vertices in the project geometric surface domain of acquisition, with continuous toe-in in four sides Square surrounds profile set of vertices, and each side stops convergence when encountering vertex for the first time, and square when all terminating convergence is institute Grid bounding box is stated, the angle steel joint coordinate of square is the grid bounding box coordinate.
Further, in the step 4, the side for entering option in geometrical plane Collision Detection mass-election grid is utilized Method is as follows: assuming that grid bounding box top-left coordinates parameter is (Wj_min, Ww_max), lower right coordinate parameter is (Wj_max, Ww_ Min), any project bounding box top-left coordinates parameter is (Xj_min, Xw_max), and lower right coordinate parameter is (Xj_max, Xw_ Min), the algorithm criterion of crash type detection are as follows:
It 1) include criterion
[(Wj_min<Xj_min<Wj_max)and(Wj_min<Xj_max<Wj_max)]and[(Ww_min<Xw_min<Ww_ max)and(Ww_min<Xw_max<Ww_max)];
2) mutually from criterion
[(Xj_min>Wj_maxorXj_min<Wj_min)and(Xj_max>Wj_maxorXj_max<Wj_min)]or[(Xw_ min>Ww_maxorXw_min<Ww_min)and(Xw_max>Ww_maxorXw_max<Ww_min)];
3) intersection criterion: while the calculating event being unsatisfactory for comprising criterion and phase from criterion is judged as intersection.
Further, the step 5 further includes judge polygonal region that a certain element and profile set of vertices are constituted several What relationship, the judgment rule of the geometrical relationship are as follows:
1) it is located at the outer criterion of polygonal region: makees horizontally or vertically ray from target point, calculates cumulative ray in two directions With the intersection point number of zone boundary, determine target point outside region if intersection point number is all even number;
In polygonal region 2) (criterion: making horizontally or vertically ray from target point, calculate cumulative ray in two directions with area The intersection point number on domain boundary determines target point in region if intersection point number is all odd number;
3) criterion on the boundary of polygonal region: can be judged as comprising target point on side in ray and the intersection point of zone boundary In boundary.
The beneficial effects of the present invention are:
The present invention seriously affects foreground application system when forming mass data for power grid GIS tradition backstage relevant database Efficiency, provide one kind according to power grid grade, operational management unit based on, using power grid project as basic unit of storage Data base administration framework, by conventional GIS system with power grid element be management granularity be promoted to power grid project be management granularity, pipe The increase of reason granularity makes the extraction efficiency of power grid project data improve manyfold, reaches data management efficiency in practical applications Practical level is arrived;Using manual retrieval and the presence of grid integrated data is calculated for existing grid-based management and project planning The problem of, propose a set of gridding solution, can automatically, accurately calculate grid contents, make the various applications of gridding Reach real time implementation operation level, grid of solving over handles the problems such as human cost height, the low, poor reliability of accuracy. In addition, the retrieval scheme of project cluster uses business administration level attribute, power grid topological relation attribute, geographical relationship in the present invention A variety of index technologies such as attribute (gridding), administrative region attribute, make the data retrieval speed of project cluster be greatly improved.
Other features and advantages of the present invention will be illustrated in the following description, also, partly becomes from specification It obtains it is clear that understand through the implementation of the invention.The objectives and other advantages of the invention can be by written explanation Specifically noted structure is achieved and obtained in book, claims and attached drawing.
Detailed description of the invention
Fig. 1 is flow chart of the invention;
Fig. 2 is power grid hierarchical storage database schema schematic diagram in the present invention;
Fig. 3 is the preparation method schematic diagram of profile set of vertices parameter in the present invention;
Fig. 4 is the acquisition schematic diagram of grid bounding box in the present invention;
Fig. 5 is to realize the algorithm schematic diagram that project mass-election is shortlisted for and is eliminated in grid using Collision Detection in the present invention;
Fig. 6 is the schematic diagram that precisely geometrical relationship calculates in the present invention.
Specific embodiment
Embodiments of the present invention are described below in detail, the example of the embodiment is shown in the accompanying drawings, wherein from beginning Same or similar element or element with the same or similar functions are indicated to same or similar label eventually.Below by ginseng The embodiment for examining attached drawing description is exemplary, and for explaining only the invention, and is not construed as limiting the claims.
Those skilled in the art of the present technique are appreciated that unless expressly stated, singular " one " used herein, " one It is a ", " described " and "the" may also comprise plural form.It is to be further understood that being arranged used in specification of the invention Diction " comprising " refer to that there are the feature, integer, step, operation, element and/or component, but it is not excluded that in the presence of or addition Other one or more features, integer, step, operation, element, component and/or their group.It should be understood that when we claim member Part is " connected " or when " coupled " to another element, it can be directly connected or coupled to other elements, or there may also be Intermediary element.In addition, " connection " used herein or " coupling " may include being wirelessly connected or coupling.Wording used herein "and/or" includes one or more associated any cells for listing item and all combinations.
Those skilled in the art of the present technique are appreciated that unless otherwise defined, all terms used herein (including technology art Language and scientific term) there is meaning identical with the general understanding of those of ordinary skill in fields of the present invention.Should also Understand, those terms such as defined in the general dictionary, which should be understood that, to be had and the meaning in the context of the prior art The consistent meaning of justice, and unless defined as here, it will not be explained in an idealized or overly formal meaning.It should manage Solution, in order to enable technical solution is definitely, " front, back, left, right, up, down " used herein etc. indicates that the term in orientation is Relative to the term position of Fig. 1, not because of the conversion changing location form of presentation of view.
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention Attached drawing, the technical solution of the embodiment of the present invention is clearly and completely described.Obviously, described embodiment is this hair Bright a part of the embodiment, instead of all the embodiments.Based on described the embodiment of the present invention, ordinary skill Personnel's every other embodiment obtained, shall fall within the protection scope of the present invention.
As shown in Figure 1, the method for realizing grid-based management using power grid hierarchical storage database schema, including following step It is rapid:
Step 1, the natural characteristic according to electric network composition, to being carried out point using the contents of a project as the project volume data of separate storage body etc. Grade, data base administration in subregional, and project volume data is stored and transmitted using densification format;
Step 2, each project volume data include the operational management parameter of the predefined various power grid elements of data base management system And geographic information data, the associated calculation method of project volume data are automatically performed the electric topology of project needs, electrical parameter statistics It is calculated with geometric parameter;
Step 3, the mesh-managing parameter that various types and rank are defined according to regulatory requirement, calculate grids at different levels automatically The geometric parameter of nested management attribute and grid;
Step 4, the geometric parameter in conjunction with grid and data base management system mean terms purpose mesh-managing parameter utilize geometrical plane Enter option in Collision Detection mass-election grid, to greatly improve the rapidity, validity and overall efficiency of grid computing;
Project carries out intersection in step 5, the grid being selected in mass-election and comprising calculating, accurate calculation goes out the power grid for including in grid Project and electrical elements carry out statistics calculating to a variety of mesh parameters.
In the step 1, the natural characteristic of electric network composition includes grade and operational management.
As shown in Fig. 2, being power grid hierarchical storage database schema schematic diagram, in the step 1, project volume data is deposited Storage scheme is as follows:
Data base management system manages multiple entity Grids simultaneously, and each entity Grid forms a partition holding, Each partition holding is a unit service example of data base management system, and is responsible for account in this subregion, status project, rule Project, whole management roles of grid system are drawn, opens up different storage sub-districts respectively according to item types in each subregion, respectively Project memory bank uses file densification storage format, and file name associated item meaning, and extension name is unified to use " .geplan " Suffix.
As shown in figure 3, be the preparation method schematic diagram of profile set of vertices parameter, in the step 3, mesh-managing parameter Calculate geometric area, geometry bounding box, geometric center, radius of electricity supply and profile set of vertices parameter including geographical face domain.
The profile set of vertices gain of parameter method is as follows:
A. the geometric coordinate scatter plot arrangement for marking project interior element, is YS0-YS7;
B. a border element YS0 is arbitrarily extracted as first starting point, then horizontal rays to the right, later rotary irradiating counterclockwise Line is then first element with the element YS3 of ray intersection;
C. using first element YS3 as second starting point, second element YS4 then is obtained in the method for step b, with such Cycle operation is pushed away, to terminate operation when first starting point YS0, is then obtained during cycle operation until with the element of ray intersection Each starting point (YS0YS3YS4YS7YS6) be project geometric surface domain profile set of vertices.
In the step 2, the geometric parameter of grid calculates the parameter including grid bounding box, profile set of vertices and calculates.
As shown in figure 4, being the acquisition schematic diagram of grid bounding box, oabcd is polygon vertex group, several in the project of acquisition In the profile set of vertices in what face domain, profile set of vertices is surrounded with the square of a continuous toe-in in four sides, each side is for the first time Stop convergence when encountering vertex, all terminating square when convergence is the grid bounding box, the angle steel joint coordinate of square The as described grid bounding box coordinate using upper left (JWmin_Max) and bottom right (JWmax_min) set of coordinates is of the invention in figure The bounding box parameter used;Shape changeable is decomposed into △ 1, △ 2, △ 3 ... △ n by vertex of o in figure and forms triangle sector.Benefit Calculate each edge lengths with point-to-point transmission length formula (see Practical Formula 1), using edge lengths each known to triangle quadrature formula (see Practical Formula 2) each triangle area is calculated, finally calculate gross area Sz=∑ △ s1 ... △ sn.
Practical Formula 1: ((lat1, lng1), B (lat2, lng2) two o'clock latitude and longitude coordinates calculate distance Lab to known A
Enabling R is earth radius constant R=6378.137
π/180 r1=lat1* are enabled to enable π/180 r2=lat2*
A=π/180 (lat1-lat2) * are enabled to enable b=π/180 (lng1-lng2) *
Enable c=2*Sin (Sqrt (Pow (Sin (a/2), 2)+Cos (r1) * Cos (r2) * Pow (Sin (b/2), 2)))
Then Lab=c*R;
Practical Formula 2: known each side length a of triangle, b, c quadrature Sabc
Enable a2=a*a that b2=b*b is enabled to enable c2=c*c
Enable d=a2+c2-b2
Then Sabc=0.25*Sqrt (Abs (4*a2*c2-d*d)).
As shown in figure 5, for the algorithm schematic diagram be shortlisted for and eliminated using project mass-election in Collision Detection realization grid; It is as follows using the method for entering option in geometrical plane Collision Detection mass-election grid: assuming that grid packet in the step 4 Enclosing box top-left coordinates parameter is (Wj_min, Ww_max), and lower right coordinate parameter is (Wj_max, Ww_min), and any project is surrounded Box top-left coordinates parameter is (Xj_min, Xw_max), and lower right coordinate parameter is (Xj_max, Xw_min), crash type detection Algorithm criterion are as follows:
It 1) include criterion
[(Wj_min<Xj_min<Wj_max)and(Wj_min<Xj_max<Wj_max)]and[(Ww_min<Xw_min<Ww_ max)and(Ww_min<Xw_max<Ww_max)];
2) mutually from criterion
[(Xj_min>Wj_maxorXj_min<Wj_min)and(Xj_max>Wj_maxorXj_max<Wj_min)]or[(Xw_ min>Ww_maxorXw_min<Ww_min)and(Xw_max>Ww_maxorXw_max<Ww_min)];
3) intersection criterion: while the calculating event being unsatisfactory for comprising criterion and phase from criterion is judged as intersection.
As shown in fig. 6, realizing the original that accurate geometrical relationship calculates for geometric surface domain and element ray intersection odd-even symmetry method Reason figure, the step 5 further includes the geometrical relationship for the polygonal region for judging that a certain element and profile set of vertices are constituted, described several The judgment rule of what relationship is as follows:
Irregular polygon is the polygonal region that grid or project profile set of vertices are constituted in figure, A, B, C, D be to judge with The element apex coordinate of polygon geometrical relationship, the judgment rule of geometrical relationship are as follows: 1) polygon outer (A, D point in figure) is sentenced According to making horizontally or vertically ray from target point, the cumulative ray intersection point number with zone boundary in two directions calculated, if handing over Point number is all that even number (noticing that 0 is even number) then determines target point outside region;2) (C point in figure) criterion in polygon, from mesh Punctuate makees horizontally or vertically ray, the cumulative ray intersection point number with zone boundary in two directions is calculated, if intersection point number All then determine target point in region for odd number;3) it is wrapped in the intersection point of (B point in the figure) criterion on boundary, ray and zone boundary It can be judged as on boundary containing target point, the present invention is in order to improve the accuracy comprising content, and element is used as on boundary It is handled in region.
Finally, it is stated that the above examples are only used to illustrate the technical scheme of the present invention and are not limiting, this field is common Other modifications or equivalent replacement that technical staff makes technical solution of the present invention, without departing from technical solution of the present invention Spirit and scope, be intended to be within the scope of the claims of the invention.

Claims (9)

1. the method for realizing grid-based management using power grid hierarchical storage database schema, which comprises the following steps:
Step 1, the natural characteristic according to electric network composition, to being carried out point using the contents of a project as the project volume data of separate storage body etc. Grade, data base administration in subregional, and project volume data is stored and transmitted using densification format;
Step 2, each project volume data include the operational management parameter of the predefined various power grid elements of data base management system And geographic information data, the associated calculation method of project volume data are automatically performed the electric topology of project needs, electrical parameter statistics It is calculated with geometric parameter;
Step 3, the mesh-managing parameter that various types and rank are defined according to regulatory requirement, calculate grids at different levels automatically The geometric parameter of nested management attribute and grid;
Step 4, the geometric parameter in conjunction with grid and data base management system mean terms purpose mesh-managing parameter utilize geometrical plane Enter option in Collision Detection mass-election grid, to greatly improve the rapidity, validity and overall efficiency of grid computing;
Project carries out intersection in step 5, the grid being selected in mass-election and comprising calculating, accurate calculation goes out the power grid for including in grid Project and electrical elements carry out statistics calculating to a variety of mesh parameters.
2. the method according to claim 1 for realizing grid-based management using power grid hierarchical storage database schema, special Sign is: in the step 1, the natural characteristic of electric network composition includes grade and operational management.
3. the method according to claim 2 for realizing grid-based management using power grid hierarchical storage database schema, special Sign is, in the step 1, the storage scheme of project volume data is as follows:
Data base management system manages multiple entity Grids simultaneously, and each entity Grid forms a partition holding, Each partition holding is a unit service example of data base management system, and is responsible for account in this subregion, status project, rule Project, whole management roles of grid system are drawn, opens up different storage sub-districts respectively according to item types in each subregion, respectively Project memory bank uses file densification storage format, and file name associated item meaning, and extension name is unified to use " .geplan " Suffix.
4. the method according to claim 1 for realizing grid-based management using power grid hierarchical storage database schema, special Sign is: in the step 3, it includes the geometric area in geographical face domain, geometry bounding box, in geometry that mesh-managing parameter, which calculates, The heart, radius of electricity supply and profile set of vertices parameter.
5. the method according to claim 4 for realizing grid-based management using power grid hierarchical storage database schema, special Sign is that the profile set of vertices gain of parameter method is as follows:
A. the geometric coordinate scatter plot arrangement of project interior element is marked;
B. a border element is arbitrarily extracted as first starting point, then makees horizontal/vertical ray to right/left, later the inverse time Needle/rotate clockwise ray is then first element with the element of ray intersection;
C. using first element as second starting point, then obtain second element in the method for step b, and so on circulation Operation terminates operation when being first starting point with the element of ray intersection, then each starting point obtained in cycle operation process The as profile set of vertices in project geometric surface domain.
6. the method according to claim 5 for realizing grid-based management using power grid hierarchical storage database schema, special Sign is: in the step 2, the geometric parameter of grid calculates the parameter including grid bounding box, profile set of vertices and calculates.
7. the method according to claim 6 for realizing grid-based management using power grid hierarchical storage database schema, special Sign is: in the profile set of vertices in the project geometric surface domain of acquisition, being surrounded with the square of a continuous toe-in in four sides Profile set of vertices, each side stop convergence when encountering vertex for the first time, terminate square when convergence all as grid encirclement Box, the angle steel joint coordinate of square are the grid bounding box coordinate.
8. the method according to claim 7 for realizing grid-based management using power grid hierarchical storage database schema, special Sign is: as follows using the method for entering option in geometrical plane Collision Detection mass-election grid in the step 4: false If grid bounding box top-left coordinates parameter is (Wj_min, Ww_max), lower right coordinate parameter is (Wj_max, Ww_min), any Project bounding box top-left coordinates parameter is (Xj_min, Xw_max), and lower right coordinate parameter is (Xj_max, Xw_min), collides class The algorithm criterion of type detection are as follows:
It 1) include criterion
[(Wj_min<Xj_min<Wj_max)and(Wj_min<Xj_max<Wj_max)]and[(Ww_min<Xw_min<Ww_ max)and(Ww_min<Xw_max<Ww_max)];
2) mutually from criterion
[(Xj_min>Wj_maxorXj_min<Wj_min)and(Xj_max>Wj_maxorXj_max<Wj_min)]or[(Xw_ min>Ww_maxorXw_min<Ww_min)and(Xw_max>Ww_maxorXw_max<Ww_min)];
3) intersection criterion: while the calculating event being unsatisfactory for comprising criterion and phase from criterion is judged as intersection.
9. the method according to claim 8 for realizing grid-based management using power grid hierarchical storage database schema, special Sign is: the step 5 further includes the geometrical relationship for the polygonal region for judging that a certain element and profile set of vertices are constituted, described The judgment rule of geometrical relationship is as follows:
1) it is located at the outer criterion of polygonal region: makees horizontally or vertically ray from target point, calculates cumulative ray in two directions With the intersection point number of zone boundary, determine target point outside region if intersection point number is all even number;
In polygonal region 2) (criterion: making horizontally or vertically ray from target point, calculate cumulative ray in two directions with area The intersection point number on domain boundary determines target point in region if intersection point number is all odd number;
3) criterion on the boundary of polygonal region: can be judged as comprising target point on side in ray and the intersection point of zone boundary In boundary.
CN201810858325.1A 2018-07-31 2018-07-31 Method for realizing gridding management by using power grid level storage database architecture Active CN109241216B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810858325.1A CN109241216B (en) 2018-07-31 2018-07-31 Method for realizing gridding management by using power grid level storage database architecture

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810858325.1A CN109241216B (en) 2018-07-31 2018-07-31 Method for realizing gridding management by using power grid level storage database architecture

Publications (2)

Publication Number Publication Date
CN109241216A true CN109241216A (en) 2019-01-18
CN109241216B CN109241216B (en) 2021-08-17

Family

ID=65073313

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810858325.1A Active CN109241216B (en) 2018-07-31 2018-07-31 Method for realizing gridding management by using power grid level storage database architecture

Country Status (1)

Country Link
CN (1) CN109241216B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111415346A (en) * 2020-03-23 2020-07-14 河海大学 Particle model damage characterization method based on gridding
CN112596814A (en) * 2020-12-24 2021-04-02 北京百度网讯科技有限公司 Method, apparatus, device, medium and program product for integrated packaging of items

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102131202A (en) * 2011-02-28 2011-07-20 浪潮通信信息系统有限公司 Method for geographic gridding of communication network information based on area method
US20140114844A1 (en) * 2012-10-24 2014-04-24 Joseph W. Forbes, Jr. System, method, and apparatus for settlement for participation in an electric power grid
CN105046449A (en) * 2015-08-26 2015-11-11 国网冀北电力有限公司 Evaluation method based on gridding power distribution network
CN105303259A (en) * 2015-11-06 2016-02-03 国网上海市电力公司 Gridding concept based power distribution network planning management method
CN108182194A (en) * 2017-11-22 2018-06-19 国电南瑞科技股份有限公司 The management method that a kind of gridding based on power grid GIS divides
CN108199367A (en) * 2017-12-11 2018-06-22 上海交通大学 One kind is based on medium voltage distribution network unit style grid power supply plan method

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102131202A (en) * 2011-02-28 2011-07-20 浪潮通信信息系统有限公司 Method for geographic gridding of communication network information based on area method
US20140114844A1 (en) * 2012-10-24 2014-04-24 Joseph W. Forbes, Jr. System, method, and apparatus for settlement for participation in an electric power grid
CN105046449A (en) * 2015-08-26 2015-11-11 国网冀北电力有限公司 Evaluation method based on gridding power distribution network
CN105303259A (en) * 2015-11-06 2016-02-03 国网上海市电力公司 Gridding concept based power distribution network planning management method
CN108182194A (en) * 2017-11-22 2018-06-19 国电南瑞科技股份有限公司 The management method that a kind of gridding based on power grid GIS divides
CN108199367A (en) * 2017-12-11 2018-06-22 上海交通大学 One kind is based on medium voltage distribution network unit style grid power supply plan method

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
李久程 等: "配电网网格化规划及应用", 《电力勘测设计》 *
王赛一 等: "基于网格化理念的城市中心区配电网规划策略", 《陕西电力》 *

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111415346A (en) * 2020-03-23 2020-07-14 河海大学 Particle model damage characterization method based on gridding
CN111415346B (en) * 2020-03-23 2022-02-11 河海大学 Particle model damage characterization method based on gridding
CN112596814A (en) * 2020-12-24 2021-04-02 北京百度网讯科技有限公司 Method, apparatus, device, medium and program product for integrated packaging of items
CN112596814B (en) * 2020-12-24 2024-03-01 北京百度网讯科技有限公司 Integrated packaging method, apparatus, device, medium and program product for items

Also Published As

Publication number Publication date
CN109241216B (en) 2021-08-17

Similar Documents

Publication Publication Date Title
He et al. Measuring urban spatial interaction in Wuhan Urban Agglomeration, Central China: A spatially explicit approach
Liu et al. How polycentric is urban China and why? A case study of 318 cities
CN108446293A (en) A method of based on urban multi-source isomeric data structure city portrait
CN105206057B (en) Detection method and system based on Floating Car resident trip hot spot region
CN105808672A (en) Browser based mass three-dimensional point cloud data release method
Deng et al. Compact or disperse? Evolution patterns and coupling of urban land expansion and population distribution evolution of major cities in China, 1998–2018
CN105956165B (en) A kind of big file storage organization method of the tile type of three-dimensional modeling data
Xiao et al. Exploring the coordination between physical space expansion and social space growth of China’s urban agglomerations based on hierarchical analysis
CN106849353B (en) Project of transmitting and converting electricity environment monitoring and sensitizing range forecasting system and method
CN106980668A (en) A kind of cyberspace surveys and draws the Formal Modeling of key element
CN109241216A (en) The method for realizing grid-based management using power grid hierarchical storage database schema
CN110032610A (en) A kind of scale vector method for exhibiting data and system
CN111784830B (en) Rule-based three-dimensional geographic information model space analysis method and system
CN103049640B (en) Power grid multi-state multi-dimensional display control based on GIS-Geographic Information System
CN108038734A (en) City commercial facility space distribution detection method and system based on comment data
CN109767491A (en) A kind of power network development data platform based on three-dimensional geographic information
WO2018196214A1 (en) Statistics system and statistics method for geographical influence on vernacular architectural form
Zhang et al. Application of multi-agent models to urban expansion in medium and small cities: A case study in Fuyang City, Zhejiang Province, China
Rao et al. Comparisons of three‐dimensional urban forms in different urban expansion types: 58 sample cities in China
CN104537254A (en) Fine drawing method based on social statistical data
Pan et al. Quantitative delimitation of urban influential hinterland in China
CN109472862A (en) A kind of substation&#39;s 3 d modeling system
CN109741206A (en) A kind of Multiple Time Scales characteristic analysis method of magnanimity load data
Guo et al. Time-series nighttime imagery for measuring the growth of Urban agglomeration in the Guangdong-Hong Kong-Macao Greater Bay Area
Dou et al. Construction of smart community based on GIS and tilt photogrammetry

Legal Events

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