CN114048271A - Storage method and device of Beidou grid data model in database - Google Patents
Storage method and device of Beidou grid data model in database Download PDFInfo
- Publication number
- CN114048271A CN114048271A CN202111143737.5A CN202111143737A CN114048271A CN 114048271 A CN114048271 A CN 114048271A CN 202111143737 A CN202111143737 A CN 202111143737A CN 114048271 A CN114048271 A CN 114048271A
- Authority
- CN
- China
- Prior art keywords
- coordinate information
- dimensional coordinate
- grid
- field
- subdivision
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Remote Sensing (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The utility model provides a storage method of Beidou grid data model in a database, which comprises the following steps: acquiring two-dimensional coordinate information or three-dimensional coordinate information in a relational database; determining the corresponding Beidou subdivision grid code hierarchy according to the actual application scene of the two-dimensional coordinate information or the three-dimensional coordinate information, and generating corresponding hierarchy field level; converting the two-dimensional coordinate information or the three-dimensional coordinate information into Beidou subdivision grid codes of corresponding levels, and generating corresponding longitude and latitude subdivision coding field codes and elevation subdivision coding field zcodes; and packaging the level field level, the longitude and latitude subdivision coding field code and the elevation subdivision coding field zcode into a same field grid, storing the field grid in a tb _ location table corresponding to two-dimensional coordinate information or three-dimensional coordinate information in the relational database, and generating grid cells. In this way, data encapsulation and consistency can be ensured, data management is convenient, and the parallel computing capability of the database can be fully utilized.
Description
Technical Field
The embodiment of the disclosure relates to the technical field of geographic information processing, and more particularly to a storage method and device of a Beidou grid data model in a database.
Background
With the rapid development of information technology, the cost for acquiring satellite remote sensing and satellite navigation data is reduced, and the requirements for storage, management and retrieval of mass spatial data are higher and higher.
The Spatial database has been developed for 20 years, and many excellent relational Spatial database products, such as Oracle Spatial and PostGIS, are emerged at home and abroad. These databases commonly employ a Geometry data model composed of coordinates or coordinate sequences, and spatial indexing commonly employs an R-Tree index. The traditional space geometric data model and space index have a plurality of problems in the aspects of data precision and massive data retrieval performance.
In the existing database, grid coding and hierarchical field storage are carried out, and data encapsulation and consistency cannot be guaranteed; the non-point elements and the grids are in one-to-many relationship, so that data management is inconvenient; storing data in a database, calculating the data outside the database, and inputting and outputting the data into the database for multiple times to generate a large number of redundant IO; and the parallel computing capability of the database cannot be fully utilized by computing outside the database.
Disclosure of Invention
According to the embodiment of the disclosure, a storage scheme of the Beidou grid data model in the database is provided, wherein the storage scheme can ensure the data encapsulation performance and consistency, is convenient for data management, and can fully utilize the parallel computing capability of the database.
In a first aspect of the disclosure, a storage method of a Beidou grid data model in a database is provided, which includes:
acquiring two-dimensional coordinate information or three-dimensional coordinate information in a relational database, wherein the two-dimensional coordinate information or the three-dimensional coordinate information is stored in the relational database in a tb _ location table form;
determining the corresponding Beidou subdivision grid code hierarchy according to the actual application scene of the two-dimensional coordinate information or the three-dimensional coordinate information, and generating corresponding hierarchy field level;
converting the two-dimensional coordinate information or the three-dimensional coordinate information into Beidou subdivision grid codes of corresponding levels, and generating corresponding longitude and latitude subdivision coding field codes and elevation subdivision coding field zcodes;
and packaging the level field level, the longitude and latitude subdivision coding field code and the elevation subdivision coding field zcode into a same field grid, storing the field grid in a tb _ location table corresponding to two-dimensional coordinate information or three-dimensional coordinate information in the relational database, and generating grid cells.
In some embodiments, the method further comprises:
and defining a type mark field dim in the grid cell gridcell, wherein the type mark field dim is used for distinguishing the two-dimensional coordinate information from the grid cell gridcell corresponding to the three-dimensional coordinate information.
In some embodiments, the longitude and latitude partitioning code field code in the grid cell gridcell is stored in the longitude and latitude partitioning code field code by combining the longitude code and the latitude code into a one-dimensional binary code through Morton coding.
In some embodiments, the coefficient database has a trellis-encoding algorithm stored therein;
the step of converting the two-dimensional coordinate information or the three-dimensional coordinate information into the Beidou subdivision grid codes of the corresponding levels comprises the following steps:
and calling a grid coding algorithm stored in a relational database, and converting the two-dimensional coordinate information or the three-dimensional coordinate information into the Beidou subdivision grid codes of the corresponding levels.
In some embodiments, the obtaining two-dimensional coordinate information or three-dimensional coordinate information in the relational database includes:
obtaining a tb _ location table in the relational database, and determining the longitude and the latitude of the current coordinate information according to the lng field and the lat field in the tb _ location table;
and determining the elevation of the current coordinate information according to the height field in the tb _ location table.
In some embodiments, the method further comprises:
and packaging the non-point elements in the relational database and the corresponding grid cells together to generate a grid set georgrid comprising the non-point elements and the grid cell set.
In some embodiments, the grid set georgrid includes a plurality of grid cells gridcell at different levels and a plurality of different grid cells gridcell at the same level.
In a second aspect of the present disclosure, there is provided a storage device of a beidou grid data model in a database, including:
the information acquisition module is used for acquiring two-dimensional coordinate information or three-dimensional coordinate information in a relational database, wherein the two-dimensional coordinate information or the three-dimensional coordinate information is stored in the relational database in a tb _ location table form;
the hierarchy determining module is used for determining the corresponding hierarchy of the Beidou subdivision grid codes according to the actual application scene of the two-dimensional coordinate information or the three-dimensional coordinate information and generating corresponding hierarchy field levels;
the encoding module is used for converting the two-dimensional coordinate information or the three-dimensional coordinate information into Beidou subdivision grid codes of corresponding levels and generating corresponding longitude and latitude subdivision encoding field codes and elevation subdivision encoding field zcodes;
and the data storage module is used for packaging the hierarchy field level, the longitude and latitude division coding field code and the elevation division coding field zcode into a same field grid, storing the field grid in a tb _ location table corresponding to the two-dimensional coordinate information or the three-dimensional coordinate information in the relational database, and generating grid cells.
In a third aspect of the present disclosure, an electronic device is provided, comprising a memory having stored thereon a computer program and a processor implementing the method as described above when executing the program.
In a fourth aspect of the present disclosure, a computer-readable storage medium is provided, on which a computer program is stored, which program, when being executed by a processor, is adapted to carry out the method as set forth above.
By the storage method of the Beidou grid data model in the database, data encapsulation performance and consistency can be guaranteed, data management is convenient, and parallel computing capacity of the database can be fully utilized.
It should be understood that the statements herein reciting aspects are not intended to limit the critical or essential features of the embodiments of the present disclosure, nor are they intended to limit the scope of the present disclosure. Other features of the present disclosure will become apparent from the following description.
Drawings
The above and other features, advantages and aspects of various embodiments of the present disclosure will become more apparent by referring to the following detailed description when taken in conjunction with the accompanying drawings. In the drawings, like or similar reference characters designate like or similar elements, and wherein:
fig. 1 shows a flowchart of a storage method of a Beidou grid data model in a database according to a first embodiment of the present disclosure;
fig. 2 shows a schematic structural diagram of a storage device of a Beidou grid data model in a database according to a second embodiment of the disclosure;
fig. 3 shows a schematic structural diagram of a storage device of the Beidou grid data model in the database according to the third embodiment of the present disclosure.
Detailed Description
To make the objects, technical solutions and advantages of the embodiments of the present disclosure more clear, the technical solutions of the embodiments of the present disclosure will be described clearly and completely with reference to the drawings in the embodiments of the present disclosure, and it is obvious that the described embodiments are some, but not all embodiments of the present disclosure. All other embodiments, which can be derived by a person skilled in the art from the embodiments disclosed herein without making any creative effort, shall fall within the protection scope of the present disclosure.
In addition, the term "and/or" herein is only one kind of association relationship describing an associated object, and means that there may be three kinds of relationships, for example, a and/or B, which may mean: a exists alone, A and B exist simultaneously, and B exists alone. In addition, the character "/" herein generally indicates that the former and latter related objects are in an "or" relationship.
The storage method of the Beidou grid data model in the database can ensure data encapsulation performance and consistency, is convenient to manage, and can fully utilize parallel computing capacity of the database. Specifically, as shown in fig. 1, it is a flowchart of a storage method of a Beidou grid data model in a database according to a first embodiment of the present disclosure. As can be seen from fig. 1, the storage method of the beidou grid data model in the database according to the embodiment may include the following steps:
s101: acquiring two-dimensional coordinate information or three-dimensional coordinate information in a relational database, wherein the two-dimensional coordinate information or the three-dimensional coordinate information is stored in the relational database in a tb _ location table form.
The method of this embodiment is used for processing the entering and exiting of coordinate information in a relational database, where the storage type of the coordinate information in the relational database is usually a Geometry (longitude and latitude coordinate implementation model), in which one coordinate represents one ground point and a plurality of coordinate sequences represent a line, a plane, or a volume. Because the common spatial database does not have a Beidou meshing code special data model, generating, converting, calculating and analyzing functions aiming at the meshing code model are not provided; spatial indexing based on a trellis split code model is not provided. Based on this, this embodiment converts the coordinate information in the relational database into the beidou subdivision code. The Beidou subdivision code consists of two parts: trellis coding and trellis hierarchy. Grid coding is used to characterize geographic locations and grid hierarchies are used to express grid granularity. The common relational spatial database does not have a special storage model for Beidou subdivision codes, and grid codes and grids need to be stored separately in the actual application process; for the case of lines and polygons, one Geometry corresponds to multiple lattice codes, and the relationship between multiple lattice codes and one Geometry needs to be maintained in the database.
First, two-dimensional coordinate information or three-dimensional coordinate information in a relational database needs to be acquired, wherein the two-dimensional coordinate information or the three-dimensional coordinate information is stored in the relational database in the form of a tb _ location table.
S102: and determining the corresponding Beidou subdivision grid code hierarchy according to the actual application scene of the two-dimensional coordinate information or the three-dimensional coordinate information, and generating a corresponding hierarchy field level.
After the two-dimensional coordinate information or the three-dimensional coordinate information in the relational database is obtained, the corresponding Beidou subdivision grid code hierarchy needs to be further determined, and a corresponding hierarchy field level is generated.
S103: and converting the two-dimensional coordinate information or the three-dimensional coordinate information into Beidou subdivision grid codes of corresponding levels, and generating corresponding longitude and latitude subdivision code fields and elevation subdivision code fields zcode.
Specifically, a coding algorithm customized by the user in the relational database may be invoked, that is, the database of the present embodiment supports the user-defined coding algorithm.
S104: and packaging the level field level, the longitude and latitude subdivision coding field code and the elevation subdivision coding field zcode into a same field grid, storing the field grid in a tb _ location table corresponding to two-dimensional coordinate information or three-dimensional coordinate information in the relational database, and generating grid cells.
Specifically, a composite type gridcell is defined in the relational database and is used for representing a 2D or 3D unit grid in the Beidou subdivision, and the 2D or 3D unit grid is coordinate information in the relational data. The Beidou subdivision grid is divided into a 2D grid and a 3D grid, wherein the 2D grid is subjected to binary subdivision through latitude and longitude respectively, and then combined into one-dimensional binary codes through Morton codes. The grid level is from 1-32 levels, each level is expressed by 2 binary bits, and 32-level two-dimensional codes can be stored by using 64-bit unsigned Long shape (unsigned Long). The 3D grid is added with elevation subdivision codes on the basis of the 2D grid, the range of elevation subdivision is also 1-32 levels, and 1 binary bit represents the first-level subdivision. A 32-bit unsigned Int may be used to store a 32-level program code. The hierarchy ranges from 1 to 32, and an unscheduled char can be used to store the hierarchy; since gridcell is compatible with 2D/3D, a type mark dim needs to be specified to distinguish two-dimensional grids from three-dimensional grids.
In summary, the structure of gridcell data types is as follows:
the variables in the structure are as follows:
in either 32-bit or 64-bit operating systems, after memory alignment, the memory space occupied by a gridcell object is 16 bytes.
And two three-dimensional gridcell generating functions are respectively realized, and the prototype is as follows:
gridcell ST_AsGridcell(double lng,double lat,integer level)
gridcell ST _ AsGridcell3D (double ng, double lat, double height, integer level) takes ST _ AsGridcell3D as an example to illustrate the calculation steps:
tb _ location is a table in the relational database, and long, lat, height are coordinates longitude, latitude, elevation, respectively.
2. Adding a field named grid with the type of gridcell to the tb _ location table
3. Determining the level of the grid according to the business requirement
4. The grid field in tb _ location is updated by the update statement.
Update tb_location set grid＝st_AsGridcell(lng,lat,height,level)。
5. And in st _ AsGridcell, for the lng, lat, height and level transmitted into each group, generating a corresponding longitude and latitude subdivision code and an elevation subdivision code zcode through a Beidou mesh subdivision algorithm, and packaging the longitude and latitude subdivision code and the elevation subdivision code together with the level into a gridcell object to return.
Serializing each gridcell object by an Update statement and writing the serialized gridcell object into a grid field
7. The execution loops until all rows in the table are executed.
By the method, the coordinate information in the relational database can be converted into the form of the Beidou subdivision grid code and stored. And the coordinate information in the Beidou grid code form and the original coordinate information in the relational database are packaged together, so that the data packaging property and consistency are ensured, the data management is convenient, and meanwhile, the conversion technology of the coordinate information coding form is completed in the database, so that the parallel computing capability of the database can be fully utilized.
As an optional embodiment of the present disclosure, in the above embodiment, the non-point elements in the relational database may be further packaged together with the corresponding multiple grid cells gridcell, so as to generate a grid set georgrid including the non-point elements and the grid cell set.
Specifically, a composite type georgrid is defined in the relational database, is an aggregate type of the Beidou navigation grid, and consists of one or more unit grids with the same or different hierarchies. The method can be used for representing non-point geometric elements, so that the one-to-one correspondence between the Geometry objects and the GeomGrids objects is realized.
Different levels of unit grids may exist in a georgrid, and the level of the grid unit with the highest level is the level of the georgrid object and is called detailLevel.
Geomgrids support 2D/3D grid cells, but do not support both 2D and 3D. It is required that the grid cells are either all 2D or all 3D. Dim members also exist in georgrids, storing dimension information.
The Geomgrids storage structure is as follows:
the variables in the structure are as follows:
cells stores the offset of the grid cell in a georgrid object. The length of the Cell depends on the number of grid cells and the type of dimension of the grid cells. The storage structure is different in the 2D/3D case, and in order to save storage space, when georgrids is 2D, the zcode value of the grid cell is not stored.
Cells inner structure (2D)
| code1 | level1 | code2 | level2 | …… | Code_n | Level_n |
Cells inner structure (3D)
| code1 | zcode1 | level1 | code2 | zcode2 | level2 | …… | Code_n | zcode_n | Level_n |
According to the method, the non-point elements in the relational database are stored in the form of the Beidou subdivision grid codes, the incidence relation between the longitude and latitude coordinate storage mode of the non-point elements and the Beidou subdivision grid code storage mode is established, the data encapsulation performance and consistency are guaranteed, and data management is convenient.
It is noted that while for simplicity of explanation, the foregoing method embodiments have been described as a series of acts or combination of acts, it will be appreciated by those skilled in the art that the present disclosure is not limited by the order of acts, as some steps may, in accordance with the present disclosure, occur in other orders and concurrently. Further, those skilled in the art should also appreciate that the embodiments described in this specification are all alternative embodiments and that the acts and modules involved are not necessarily essential to the disclosure.
The above is a description of embodiments of the method, and the embodiments of the apparatus are further described below.
As shown in fig. 2, a schematic structural diagram of a storage device of a Beidou grid data model in a database according to a second embodiment of the present disclosure is shown. The storage device of big dipper subdivision grid code of this embodiment includes:
the information acquiring module 201 is configured to acquire two-dimensional coordinate information or three-dimensional coordinate information in a relational database, where the two-dimensional coordinate information or the three-dimensional coordinate information is stored in the relational database in a tb _ location table.
The hierarchy determining module 202 is configured to determine a corresponding hierarchy of the beidou subdivision grid code according to the actual application scene of the two-dimensional coordinate information or the three-dimensional coordinate information, and generate a corresponding hierarchy field level.
The encoding module 203 is configured to convert the two-dimensional coordinate information or the three-dimensional coordinate information into a Beidou subdivision grid code of a corresponding hierarchy, and generate a corresponding longitude and latitude subdivision code field code and an elevation subdivision code field zcode.
And the data storage module 204 is configured to encapsulate the level field level, the longitude and latitude division coding field code, and the elevation division coding field zcode into a same field grid, store the field grid in a tb _ location table corresponding to the two-dimensional coordinate information or the three-dimensional coordinate information in the relational database, and generate a grid cell.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the described module may refer to the corresponding process in the foregoing method embodiment, and is not described herein again.
FIG. 3 shows a schematic block diagram of an electronic device 300 that may be used to implement embodiments of the present disclosure. As shown, device 300 includes a Central Processing Unit (CPU)301 that may perform various appropriate actions and processes in accordance with computer program instructions stored in a Read Only Memory (ROM)302 or loaded from a storage unit 308 into a Random Access Memory (RAM) 303. In the RAM 303, various programs and data necessary for the operation of the device 300 can also be stored. The CPU 301, ROM 302, and RAM 303 are connected to each other via a bus 304. An input/output (I/O) interface 305 is also connected to bus 304.
Various components in device 300 are connected to I/O interface 305, including: an input unit 306 such as a keyboard, a mouse, or the like; an output unit 307 such as various types of displays, speakers, and the like; a storage unit 308 such as a magnetic disk, optical disk, or the like; and a communication unit 309 such as a network card, modem, wireless communication transceiver, etc. The communication unit 309 allows the device 300 to exchange information/data with other devices via a computer network such as the internet and/or various telecommunication networks.
The processing unit 301, which tangibly embodies a machine-readable medium, such as the storage unit 308, performs the various methods and processes described above. In some embodiments, part or all of the computer program may be loaded and/or installed onto device 300 via ROM 302 and/or communication unit 309. When the computer program is loaded into RAM 303 and executed by CPU 301, one or more steps of the method described above may be performed. Alternatively, in other embodiments, the CPU 301 may be configured to perform the above-described method in any other suitable manner (e.g., by way of firmware).
The functions described herein above may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: a Field Programmable Gate Array (FPGA), an Application Specific Integrated Circuit (ASIC), an Application Specific Standard Product (ASSP), a system on a chip (SOC), a load programmable logic device (CPLD), and the like.
Program code for implementing the methods of the present disclosure may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the program codes, when executed by the processor or controller, cause the functions/operations specified in the flowchart and/or block diagram to be performed. The program code may execute entirely on the machine, partly on the machine, as a stand-alone software package partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
Further, while operations are depicted in a particular order, this should be understood as requiring that such operations be performed in the particular order shown or in sequential order, or that all illustrated operations be performed, to achieve desirable results. Under certain circumstances, multitasking and parallel processing may be advantageous. Likewise, while several specific implementation details are included in the above discussion, these should not be construed as limitations on the scope of the disclosure. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single implementation. Conversely, various features that are described in the context of a single implementation can also be implemented in multiple implementations separately or in any suitable subcombination.
Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are disclosed as example forms of implementing the claims.
Claims (10)
1. A storage method of a Beidou grid data model in a database is characterized by comprising the following steps:
acquiring two-dimensional coordinate information or three-dimensional coordinate information in a relational database, wherein the two-dimensional coordinate information or the three-dimensional coordinate information is stored in the relational database in a tb _ location table form;
determining the corresponding Beidou subdivision grid code hierarchy according to the actual application scene of the two-dimensional coordinate information or the three-dimensional coordinate information, and generating corresponding hierarchy field level;
converting the two-dimensional coordinate information or the three-dimensional coordinate information into Beidou subdivision grid codes of corresponding levels, and generating corresponding longitude and latitude subdivision coding field codes and elevation subdivision coding field zcodes;
and packaging the level field level, the longitude and latitude subdivision coding field code and the elevation subdivision coding field zcode into a same field grid, storing the field grid in a tb _ location table corresponding to two-dimensional coordinate information or three-dimensional coordinate information in the relational database, and generating grid cells.
2. The storage method of the Beidou grid data model in the database according to claim 1, wherein the method further comprises:
and defining a type mark field dim in the grid cell gridcell, wherein the type mark field dim is used for distinguishing the two-dimensional coordinate information from the grid cell gridcell corresponding to the three-dimensional coordinate information.
3. The storage method of the Beidou grid data model in the database according to claim 1, wherein the longitude and latitude subdivision code field code in the grid cell gridcell is stored in the longitude and latitude subdivision code field code by combining the longitude code and the latitude code into a one-dimensional binary code through Morton coding.
4. The storage method of the Beidou grid data model in the database according to claim 1,
a grid coding algorithm is stored in the coefficient database;
the step of converting the two-dimensional coordinate information or the three-dimensional coordinate information into the Beidou subdivision grid codes of the corresponding levels comprises the following steps:
and calling a grid coding algorithm stored in a relational database, and converting the two-dimensional coordinate information or the three-dimensional coordinate information into the Beidou subdivision grid codes of the corresponding levels.
5. The storage method of the Beidou grid data model in the database according to claim 1, wherein the obtaining of the two-dimensional coordinate information or the three-dimensional coordinate information in the relational database comprises:
obtaining a tb _ location table in the relational database, and determining the longitude and the latitude of the current coordinate information according to the lng field and the lat field in the tb _ location table;
and determining the elevation of the current coordinate information according to the height field in the tb _ location table.
6. The storage method of the Beidou grid data model in the database according to claim 1, wherein the method further comprises:
and packaging the non-point elements in the relational database and the corresponding grid cells together to generate a grid set georgrid comprising the non-point elements and the grid cell set.
7. The storage method of the Beidou grid data model in the database according to claim 6, wherein the grid sets georgrid comprise a plurality of grid cells gridcell of different levels and a plurality of different grid cells gridcell of the same level.
8. The utility model provides a storage device of big dipper net data model in database which characterized in that includes:
the information acquisition module is used for acquiring two-dimensional coordinate information or three-dimensional coordinate information in a relational database, wherein the two-dimensional coordinate information or the three-dimensional coordinate information is stored in the relational database in a tb _ location table form;
the hierarchy determining module is used for determining the corresponding hierarchy of the Beidou subdivision grid codes according to the actual application scene of the two-dimensional coordinate information or the three-dimensional coordinate information and generating corresponding hierarchy field levels;
the encoding module is used for converting the two-dimensional coordinate information or the three-dimensional coordinate information into Beidou subdivision grid codes of corresponding levels and generating corresponding longitude and latitude subdivision encoding field codes and elevation subdivision encoding field zcodes;
and the data storage module is used for packaging the hierarchy field level, the longitude and latitude division coding field code and the elevation division coding field zcode into a same field grid, storing the field grid in a tb _ location table corresponding to the two-dimensional coordinate information or the three-dimensional coordinate information in the relational database, and generating grid cells.
9. An electronic device comprising a memory and a processor, the memory having stored thereon a computer program, wherein the processor, when executing the program, implements the method of any of claims 1-7.
10. A computer-readable storage medium, on which a computer program is stored, which program, when being executed by a processor, carries out the method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111143737.5A CN114048271A (en) | 2021-09-28 | 2021-09-28 | Storage method and device of Beidou grid data model in database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111143737.5A CN114048271A (en) | 2021-09-28 | 2021-09-28 | Storage method and device of Beidou grid data model in database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114048271A true CN114048271A (en) | 2022-02-15 |
Family
ID=80204975
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111143737.5A Pending CN114048271A (en) | 2021-09-28 | 2021-09-28 | Storage method and device of Beidou grid data model in database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114048271A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114925043A (en) * | 2022-06-28 | 2022-08-19 | 北斗伏羲中科数码合肥有限公司 | Application method and device based on space-time grid block data and electronic equipment |
| CN115291257A (en) * | 2022-08-04 | 2022-11-04 | 贵阳欧比特宇航科技有限公司 | Geographic coordinate calculation method adopting Beidou grid position coding |
| CN115374237A (en) * | 2022-10-26 | 2022-11-22 | 北京数字政通科技股份有限公司 | Vector space data storage and query method based on Beidou grid code |
-
2021
- 2021-09-28 CN CN202111143737.5A patent/CN114048271A/en active Pending
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114925043A (en) * | 2022-06-28 | 2022-08-19 | 北斗伏羲中科数码合肥有限公司 | Application method and device based on space-time grid block data and electronic equipment |
| CN114925043B (en) * | 2022-06-28 | 2022-12-30 | 北斗伏羲中科数码合肥有限公司 | Application method and device based on space-time grid block data and electronic equipment |
| CN115291257A (en) * | 2022-08-04 | 2022-11-04 | 贵阳欧比特宇航科技有限公司 | Geographic coordinate calculation method adopting Beidou grid position coding |
| CN115374237A (en) * | 2022-10-26 | 2022-11-22 | 北京数字政通科技股份有限公司 | Vector space data storage and query method based on Beidou grid code |
| CN115374237B (en) * | 2022-10-26 | 2023-01-03 | 北京数字政通科技股份有限公司 | Vector space data storage and query method based on Beidou grid code |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114048271A (en) | Storage method and device of Beidou grid data model in database | |
| CN110199273B (en) | System and method for loading, aggregating and bulk computing in one scan in a multidimensional database environment | |
| CN107193911B (en) | BIM model-based three-dimensional visualization engine and WEB application program calling method | |
| CN112115198B (en) | Urban remote sensing intelligent service platform | |
| CN114048203A (en) | Beidou grid space indexing and retrieval method and device based on database B-tree index | |
| CN102411616B (en) | Method and system for storing data and data management method | |
| CN102184299B (en) | Model conversion method and system from CAD (Computer Aided Design) system to three-dimensional checking system | |
| CN114048204A (en) | Beidou grid space indexing method and device based on database inverted index | |
| CN113010620B (en) | Natural resource data index statistical method and system based on geographic multilevel grid | |
| CN106649882B (en) | Spatial data management middleware applied to telecommunication field and implementation method thereof | |
| CN104216961A (en) | Method and device for data processing | |
| CN113221297A (en) | Method for converting power grid information model into FBX three-dimensional model and storing attributes | |
| Li et al. | Method for managing and querying geo-spatial data using a grid-code-array spatial index | |
| CN116775661A (en) | Big space data storage and management method based on Beidou grid technology | |
| CN114238384B (en) | Area positioning method, device, equipment and storage medium | |
| CN111966707A (en) | Query statement generation method and device, electronic equipment and computer readable medium | |
| Magalhães et al. | Fast exact parallel map overlay using a two-level uniform grid | |
| CN110765298B (en) | Tile coding method for decoupling geometric attributes of vector data | |
| CN116049521A (en) | Space-time data retrieval method based on space grid coding | |
| CN110989886A (en) | Three-dimensional space grid selection method and device based on space map | |
| CN115774749A (en) | AutoCAD platform and general GIS platform data lossless conversion method | |
| CN113485638B (en) | Access optimization system for massive astronomical data | |
| CN112597262A (en) | Industry address serial number generation method and device based on spatial grid | |
| CN113312823A (en) | Finite element post-processing data processing method, system, equipment and storage medium | |
| Jianbo et al. | A Parallel Implementation of an XDraw Viewshed Algorithm with Spark |
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 |