System, method, device, equipment and storage medium for rapid extraction of three-dimensional data

By establishing spatial indexes for osgb files and tile files and using RTree and PostGIS databases, rapid extraction of osgb data is achieved, solving the problems of data distortion and system lag in existing technologies, improving file search and copying efficiency, and ensuring data security.

CN117171107BActive Publication Date: 2025-09-09GUANGZHOU URBAN PLANNING & DESIGN SURVEY RES INST
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202311139279.7
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2023-09-05
Publication Date
2025-09-09
Estimated Expiration
2043-09-05

AI Technical Summary

Technical Problem

The existing technology has problems such as data distortion, system lag and low file extraction efficiency when loading and processing OSGB data files. Especially when processing large-scale OSGB files, lightweight processing leads to data distortion and requires loading files one by one, which is time-consuming and unsafe.

Method used

By establishing spatial indexes of osgb files and tile files, and using RTree spatial index rules and PostGIS spatial database, the server traverses the tile information list, obtains the tile coordinate range, and performs fast query and index establishment of data files based on the target vector coordinate range. The client generates a call instruction, and the server automatically completes the query and sending of data files.

Benefits of technology

It realizes the rapid extraction of osgb files, preserves data integrity, reduces manual operation time, improves file search and copying efficiency, and ensures data security.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN117171107B_ABST
    Figure CN117171107B_ABST
Patent Text Reader

Abstract

The present invention provides a rapid three-dimensional data extraction system, method, device, electronic device, and storage medium. The system comprises a server and client for constructing a rapid three-dimensional data extraction system. The server traverses an OSGB data file to obtain a tile information list, and then traverses the tile information list to obtain a tile coordinate range. An index relationship is then established between the tile coordinate range and the OSGB data file according to an RTree spatial index rule. The client generates an OSGB data file retrieval instruction and sends it to the server. The server then queries the OSGB data file according to the OSGB data file retrieval instruction, obtains a target OSGB data file, and sends it to the client. The present invention ensures data integrity when extracting OSGB data files and can specify and call OSGB data files within a desired range, thereby improving file extraction efficiency and ensuring data security.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The embodiments of the present application relate to the field of data processing, and in particular to a system, method, apparatus, device, and storage medium for quickly extracting three-dimensional data. Background Art

[0002] As a standardized result of new basic surveying and mapping, real-scene 3D reflects the spatiotemporal information of human production, life and ecological space more realistically and intuitively with its real, three-dimensional and time-series characteristics. Among them, the results of 3D oblique photography are important basic data of real-scene 3D.

[0003] Existing software often loads and processes OSGB (Open Scene Graph Binary) data files by lightweighting them, browsing and querying them on a front-end webpage, loading them one by one, and then selecting and exporting specific tiles or tile names. However, the simplified and compressed OSGB files can cause data distortion. Furthermore, when retrieving the required OSGB files, the system needs to load a large number of them, causing system lag and manual selection of specific OSGB tiles for data extraction, resulting in low file extraction efficiency. Summary of the Invention

[0004] The present invention provides a system, method, device, electronic equipment and storage medium for rapid extraction of three-dimensional data, which realizes rapid extraction of OSGB files by establishing a spatial index between OSGB files and their tile file ranges.

[0005] In a first aspect, the present invention provides a system for rapidly extracting three-dimensional data, comprising:

[0006] A server and a client, wherein the server is connected to the client by signal;

[0007] The server is used to traverse the osgb data file to obtain a tile information list, and obtain the tile coordinate range by traversing the tile information list, and then establish an index relationship between the tile coordinate range and the osgb data file according to the RTree spatial index rule;

[0008] The client is used to generate an osgb data file calling instruction and send it to the server, wherein the osgb data file calling instruction includes a target vector coordinate range;

[0009] The server is used to query the osgb data file according to the osgb data file calling instruction, obtain the target osgb data file and send it to the client.

[0010] Furthermore, it also includes:

[0011] The server side is also used to read the plug-in through the OSG file to obtain the tile coordinate range, wherein the tile coordinate range indicates the coordinate point of the minimum circumscribed rectangle boundary of the tile, and when the osgb data file is queried in response to the osgb data file call instruction, all tile coordinate ranges that intersect with the target vector coordinate range are obtained, and the osgb data files corresponding to all the tile coordinate ranges that have intersections are returned to the client.

[0012] Furthermore, it also includes:

[0013] The server side is further used to establish a PostGIS spatial database and enter the RTree spatial index result information into the PostGIS spatial database for storage, wherein the RTree spatial index result information includes the tile coordinate range, the osgb data file and path information.

[0014] Furthermore, it also includes:

[0015] The server side also includes a main server and a plurality of data servers, wherein the main server is signal-connected to the data servers;

[0016] The main server is configured to generate an osgb data file sending instruction in response to the generating osgb data file calling instruction and send the instruction to the data server, wherein the osgb data file sending instruction includes address information of the target client;

[0017] The data server is used to store the PostGIS spatial database, and confirms the data sending server according to the osgb data file sending instruction and the idle status of the data server, and sends the target osgb data file to the target client through the data sending server.

[0018] In a second aspect, the present invention further provides a method for rapidly extracting three-dimensional data, which is applied to a server, comprising:

[0019] Traverse the osgb data file and obtain the tile information list;

[0020] Traverse the tile information list to obtain the tile coordinate range;

[0021] According to the RTree spatial index rule, an index relationship is established between the tile coordinate range and the osgb data file;

[0022] The osgb data file is queried according to an osgb data file retrieval instruction, a target osgb data file is obtained and sent to a client, wherein the osgb data file retrieval instruction is generated by the client and includes a target vector coordinate range.

[0023] Furthermore, the obtaining of the tile coordinate range further includes:

[0024] Reading a plug-in through an OSG file to obtain the tile coordinate range, wherein the tile coordinate range indicates the coordinate points of the minimum circumscribed rectangle boundary of the tile;

[0025] When querying the osgb data file in response to the osgb data file retrieval instruction, obtaining all tile coordinate ranges that intersect with the target vector coordinate range;

[0026] The osgb data files corresponding to all the tile coordinate ranges with intersections are returned to the client.

[0027] Furthermore, after establishing an index relationship between the tile coordinate range and the osgb data file, the method further includes:

[0028] A PostGIS spatial database is established, and RTree spatial index result information is entered into the PostGIS spatial database for storage, wherein the RTree spatial index result information includes the tile coordinate range, the osgb data file and path information.

[0029] In a third aspect, the present invention further provides a device for rapidly extracting three-dimensional data, comprising:

[0030] Tile information list acquisition device, used for traversing the osgb data file to obtain the tile information list;

[0031] Tile coordinate range acquisition means, configured to traverse the tile information list and acquire the tile coordinate range;

[0032] An index relationship establishment module, configured to establish an index relationship between the tile coordinate range and the osgb data file according to RTree spatial index rules;

[0033] The file sending module is used to query the osgb data file according to the osgb data file calling instruction, obtain the target osgb data file and send it to the client, wherein the osgb data file calling instruction is generated by the client and the osgb data file calling instruction includes a target vector coordinate range.

[0034] In a fourth aspect, an embodiment of the present application provides an electronic device, including:

[0035] at least one memory and at least one processor;

[0036] The memory is used to store one or more programs;

[0037] When the one or more programs are executed by the at least one processor, the at least one processor implements the steps of the method for quickly extracting three-dimensional data as described in the second aspect.

[0038] In a fifth aspect, an embodiment of the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of a method for rapidly extracting three-dimensional data as described in the second aspect are implemented.

[0039] The present invention builds a server and client side of a rapid three-dimensional data extraction system. The server side traverses an OSGB data file to obtain a tile information list, and by traversing the tile information list, obtains the tile coordinate range. Then, according to the RTree spatial index rule, an index relationship is established between the tile coordinate range and the OSGB data file. The client side generates an OSGB data file retrieval instruction and sends it to the server side, wherein the OSGB data file retrieval instruction includes a target vector coordinate range. The server side then queries the OSGB data file according to the OSGB data file retrieval instruction, obtains the target OSGB data file, and sends it to the client side. Through the system implemented by the present application, the OSGB file does not need to be lightweight processed, and the integrity of the data is retained. At the same time, the user only needs to provide the coordinate range line of the osgb file that needs to be retrieved, and send it directly to the server through the client. The server will automatically complete the data query and retrieval within the specified range. The user does not need to load multiple osgb files at one time through the software to find the osgb files within the required range, and then export or copy the osgb files. This greatly reduces the time for personnel to load and operate osgb files and improves the efficiency of osgb file search or copying; users do not need to obtain a large range of osgb original files, which ensures the security of the data.

[0040] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Figure 1 A schematic diagram of an osgb file directory structure provided in an exemplary embodiment;

[0042] Figure 2 A schematic diagram of modules of a system for rapidly extracting three-dimensional data provided in an exemplary embodiment;

[0043] Figure 3 A schematic diagram of tile range coordinates of a system for rapid extraction of three-dimensional data provided in an exemplary embodiment;

[0044] Figure 4 A schematic diagram of the relationship between target vector range and tile range coordinates of a fast three-dimensional data extraction system provided in an exemplary embodiment;

[0045] Figure 5 A schematic diagram of the spatial index relationship between a target vector range and tile range coordinates of a fast extraction system for three-dimensional data provided in an exemplary embodiment;

[0046] Figure 6 A flowchart of a method for rapidly extracting three-dimensional data provided in an exemplary embodiment;

[0047] Figure 7 A schematic diagram of a module of a device for rapidly extracting three-dimensional data provided in an exemplary embodiment;

[0048] Figure 8 A schematic diagram of an electronic device provided in an exemplary embodiment. DETAILED DESCRIPTION

[0049] In order to make the objectives, technical solutions and advantages of the present application clearer, the embodiments of the present application will be described in further detail below with reference to the accompanying drawings.

[0050] It should be clear that the embodiments described are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments of the present application, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the embodiments of the present application.

[0051] The terms used in the embodiments of the present application are for the purpose of describing specific embodiments only and are not intended to limit the embodiments of the present application. The singular forms "a," "the," and "the" used in the embodiments of the present application and the appended claims are also intended to include plural forms unless the context clearly indicates otherwise. It should also be understood that the term "and / or" used herein refers to and includes any or all possible combinations of one or more associated listed items.

[0052] When the following description refers to the accompanying drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. On the contrary, they are merely examples of devices and methods consistent with some aspects of the present application as detailed in the appended claims. In the description of the present application, it should be understood that the terms "first", "second", "third", etc. are only used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence, nor can they be understood as indicating or implying relative importance. For those of ordinary skill in the art, the specific meanings of the above terms in the present application can be understood according to the specific circumstances.

[0053] In addition, in this application, unless otherwise specified, "plurality" refers to two or more. "And / or" describes the relationship between associated objects, indicating that three possible relationships exist. For example, "A and / or B" can mean: A exists alone, A and B exist simultaneously, or B exists alone. The character " / " generally indicates that the associated objects are in an "or" relationship.

[0054] like Figure 1 As shown in the figure, the 3D oblique photography data currently produced by various companies on the market, especially the oblique photography 3D model data processed by Smart3D software, is generally organized in the Open Scene Graphic Binary (osgb) format, which is a binary storage format with embedded linked texture data (.jpg). Each osgb file is divided into multiple tiles, each of which is a separate folder. The tiles represent the oblique photography data of a specific field location range. However, the names of the osgb tile files do not correspond to the field location in space.

[0055] This type of data output is characterized by fragmented files, numerous folders, and large high-level pyramid files. As the scope of aerial photography expands, the size of OSGB data files can reach terabytes or even tens of terabytes. Existing software can load and display OSGB files one by one or in batches until the OSGB file at a specified location is loaded into the software for viewing or processing. However, as the number of loaded OSGB files increases, existing computer memory and graphics cards cannot effectively support the display of massive amounts of graphical data, resulting in a gradual decline in software usability.

[0056] To ensure system smoothness, when a large number of OSGB data files need to be processed, the OSGB data files will be lightweighted. However, the essence of OSGB data file lightweighting is data simplification and compression, which means that the process is lossy. This creates inconvenience for some tasks that require the use of lossless files, such as using 2D and 3D integrated mapping software for internal mapping, which requires the use of original lossless OSGB files. At the same time, the higher the degree of lightweighting, the smaller the OSGB file will be after lightweighting, and the higher the data distortion, so lightweighting cannot be performed indefinitely. When processing OSGB files at the terabyte level or larger, even after lightweighting, the simplified and compressed OSGB file will still require hundreds of GB, which makes data storage and transmission still difficult.

[0057] Moreover, when it is necessary to retrieve osgb tile files within a certain range, since it is impossible to know which osgb tile files correspond to the range, it is necessary to load the osgb tile files one by one until all osgb tile files within a certain range are loaded into the software. This process requires manual loading and processing of data, and software loading, selection or exporting of tiles. For large files, the process is not only stuck and time-consuming, but all osgb files need to be exposed to users for reading, which causes certain disadvantages in the security of data files.

[0058] Based on the above thinking and the content of background technology, such as Figure 2 As shown, the embodiment of the present application provides a system for rapidly extracting three-dimensional data, including:

[0059] A server and a client, wherein the server is signal-connected to the client.

[0060] Specifically, the server can be implemented as a standalone server or a server cluster consisting of multiple servers. The client is a terminal device that can communicate with the server via wired or wireless means. Clients include, but are not limited to, various personal computers, laptops, smartphones, tablets, IoT devices, and portable wearable devices. IoT devices include smart speakers, smart TVs, smart air conditioners, and smart car devices. Portable wearable devices include smart watches, smart bracelets, and head-mounted devices.

[0061] The server side is used to traverse the osgb data file, obtain the tile information list, and obtain the tile coordinate range by traversing the tile information list, and then establish an index relationship between the tile coordinate range and the osgb data file according to the RTree spatial index rule.

[0062] Specifically, the server stores an osgb data file, which can be uploaded by an acquisition device or copied to a specified location on the server through other storage devices. The server runs a related program. When the program starts running, it traverses the tile information of each osgb data file and finally obtains a list of all osgb tile information.

[0063] In a preferred embodiment, the server side obtains the tile coordinate range through the OSG file reading plug-in, wherein the tile coordinate range indicates the coordinate point of the minimum circumscribed rectangle boundary of the tile, and when the osgb data file is queried in response to the osgb data file call instruction, all tile coordinate ranges that intersect with the target vector coordinate range are obtained, and the osgb data files corresponding to all the tile coordinate ranges that intersect are returned to the client. Specifically, the embodiment of the present application is based on the osgb file information list, and uses the Qt development language to write a program to traverse the osgb file information list one by one to obtain any osgb file, and then writes a program based on the open source OSG library interface to open the osgb file and automatically read the coordinate range of each tile in the osgb data file. Among them, if Figure 3 As shown, the tile coordinate range indicates the coordinate points of the minimum circumscribed rectangle boundary of the tile, that is, the tile coordinate range finally obtained is the vertex coordinate values ​​of the four rectangles TopLeft (X1, Y1), TopRight (X2, Y2), BottomLeft (X3, Y3), and BottomRight (X4, Y4).

[0064] The code for traversing the osgb file information and obtaining the coordinate range is as follows:

[0065]

[0066] The structure code part about MBR (minimum bounding rectangle) is as follows:

[0067]

[0068] QPointF is a Qt class that defines the coordinate position (X, Y) of a point. Generally, the size of a rectangle can be determined by determining the two points on its diagonal, so two points can also be specified in practice.

[0069] QMap<MBRptr*,QString> mbrmap; / / QString is used to record the file name and path. Therefore, based on the RTree spatial indexing rules, the coordinate range of each tile in the osgb data file and the spatial index of the tile file information are established. That is, all the MBRs calculated in the previous step are summarized to obtain the mbrmap.

[0070] In the embodiment of the present application, a program is written based on the open source OSG library interface to open the osgb file, and the range coordinates corresponding to the tiles can be obtained without reading the contents of the osgb file. In some other examples, the range coordinates corresponding to the tiles can also be obtained by other means.

[0071] R-tree is a tree-like data structure used for spatial data storage. The spatial retrieval method of searching for a specified spatial range and the RTree spatial index is compared with the method of traversing the coordinate values ​​one by one and comparing the coordinate value relationship to calculate the spatial relationship, which can greatly improve the retrieval efficiency. Therefore, the embodiment of the present application associates the tile coordinate range, tile file data, osgb file data and their corresponding path information through the RTree spatial index rules to establish an RTree spatial index. At the same time, a PostGIS spatial database is established, and the RTree spatial index result information is entered into the PostGIS spatial database for storage, wherein the RTree spatial index result information includes the tile coordinate range, the osgb data file and the path information.

[0072] The client is used to generate an osgb data file calling instruction and send it to the server, wherein the osgb data file calling instruction includes a target vector coordinate range.

[0073] Specifically, when there is a need to retrieve an osgb data file, the user creates a vector range line, such as a shapefile file, according to the actual working range, and then the client sends the shapefile file and the osgb data retrieval instruction to the server.

[0074] The server is used to query the osgb data file according to the osgb data file calling instruction, obtain the target osgb data file and send it to the client.

[0075] Specifically, the server turns on the TCP listening mode, receives the shapefile file and instructions sent by the client, and then performs a spatial query with the RTree spatial index storage results to obtain the OSGB tile file list information that partially overlaps with the shapefile file vector range line, and finally divides the OSGB tile file list information.

[0076] In a preferred embodiment, the server side includes a master server and multiple data servers, the master server being signal-connected to the data servers. In response to the generated OSGB data file retrieval instruction, the master server generates an OSGB data file sending instruction and sends it to the data servers, wherein the OSGB data file sending instruction includes the target client's address information and OSGB tile file list information. The data servers store a PostGIS spatial database and, in response to the OSGB data file sending instruction sent by the master server and the availability of the data servers, identify the data sending server. Specifically, because network transmission speed is related to distance and bandwidth, the embodiments of the present application deploy multiple data storage servers based on distributed storage technology. During actual data transmission, after receiving an OSGB tile transmission task sent by the master server, data servers in different regions can select the nearest data server and a data server with idle transmission tasks based on the client's location. After determining the data sending server, the corresponding OSGB file is retrieved based on the OSGB tile file list information and transmitted to the target client via the TCP data transmission protocol.

[0077] In a specific example, if R11 is the target vector range, the tile coordinate ranges close to the coordinate range of R11 are R1, R13, R16 and R14. The minimum bounding rectangle relationship of the above tiles is as follows: Figure 4 By establishing an RTree spatial index, the relationship between the above tiles is shown as follows. Figure 5 As shown, it is obvious that the tile coordinates that intersect and overlap with R11 can be quickly obtained as R13 and R1. R14 and R16 do not intersect or overlap with R11 and can be quickly excluded.

[0078] The embodiment of the present application builds a server and client side of a rapid three-dimensional data extraction system. The server side traverses an OSGB data file to obtain a tile information list, and by traversing the tile information list, obtains the tile coordinate range. Then, according to the RTree spatial index rule, an index relationship is established between the tile coordinate range and the OSGB data file. The client side generates an OSGB data file retrieval instruction and sends it to the server side, wherein the OSGB data file retrieval instruction includes a target vector coordinate range. The server side then queries the OSGB data file according to the OSGB data file retrieval instruction, obtains the target OSGB data file, and sends it to the client side. Through the system implemented by the present application, the OSGB file does not need to be lightweight processed, and the integrity of the data is preserved. At the same time, the user only needs to provide the coordinate range line of the osgb file that needs to be retrieved, and send it directly to the server through the client. The server will automatically complete the data query and retrieval within the specified range. The user does not need to load multiple osgb files at one time through the software to find the osgb files within the required range, and then export or copy the osgb files. This greatly reduces the time for personnel to load and operate osgb files and improves the efficiency of osgb file search or copying; users do not need to obtain a large range of osgb original files, which ensures the security of the data.

[0079] The present application also provides a method for quickly extracting three-dimensional data, which is applied to the server side. Figure 6 As shown, the following steps are included:

[0080] S201: Traverse the osgb data file and obtain the tile information list.

[0081] S202: Traverse the tile information list to obtain the tile coordinate range.

[0082] S203: According to the RTree spatial index rule, an index relationship is established between the tile coordinate range and the osgb data file.

[0083] S204: querying the osgb data file according to the osgb data file retrieval instruction, obtaining the target osgb data file and sending it to the client, wherein the osgb data file retrieval instruction is generated by the client and includes a target vector coordinate range.

[0084] In a preferred embodiment, obtaining the tile coordinate range further includes:

[0085] Reading a plug-in through an OSG file to obtain the tile coordinate range, wherein the tile coordinate range indicates the coordinate points of the minimum circumscribed rectangle boundary of the tile;

[0086] When querying the osgb data file in response to the osgb data file retrieval instruction, obtaining all tile coordinate ranges that intersect with the target vector coordinate range;

[0087] The osgb data files corresponding to all the tile coordinate ranges with intersections are returned to the client.

[0088] In a preferred embodiment, after establishing an index relationship between the tile coordinate range and the osgb data file, the method further includes:

[0089] A PostGIS spatial database is established, and RTree spatial index result information is entered into the PostGIS spatial database for storage, wherein the RTree spatial index result information includes the tile coordinate range, the osgb data file and path information.

[0090] It should be noted that the three-dimensional data rapid extraction method and the three-dimensional data rapid extraction system provided in the above embodiment belong to the same concept. The specific implementation process is detailed in the system embodiment and will not be repeated here.

[0091] This application also provides a device for quickly extracting three-dimensional data, such as Figure 7 Shown, including:

[0092] Tile information list acquisition device, used for traversing the osgb data file to obtain the tile information list;

[0093] Tile coordinate range acquisition means, configured to traverse the tile information list and acquire the tile coordinate range;

[0094] An index relationship establishment module, configured to establish an index relationship between the tile coordinate range and the osgb data file according to RTree spatial index rules;

[0095] The file sending module is used to query the osgb data file according to the osgb data file calling instruction, obtain the target osgb data file and send it to the client, wherein the osgb data file calling instruction is generated by the client and the osgb data file calling instruction includes a target vector coordinate range.

[0096] It should be noted that the three-dimensional data rapid extraction device and the three-dimensional data rapid extraction system provided in the above embodiment belong to the same concept. The specific implementation process is detailed in the system embodiment and will not be repeated here.

[0097] like Figure 8 As shown, Figure 8It is a structural block diagram of an electronic device according to an exemplary embodiment of the present application.

[0098] The electronic device includes a processor 910 and a memory 920. The number of processors 910 in the main control chip can be one or more. Figure 8 In the example, a processor 910 is used. The number of memories 920 in the main control chip can be one or more. Figure 8 A memory 920 is taken as an example.

[0099] Memory 920, as a computer-readable storage medium, can be used to store software programs, computer-executable programs, and modules, such as the program for a method for rapidly extracting three-dimensional data described in any of the embodiments of the present application, and the program instructions / modules corresponding to the method for rapidly extracting three-dimensional data described in any of the embodiments of the present application. Memory 920 may primarily include a program storage area and a data storage area. The program storage area may store an operating system and at least one application required for a function; the data storage area may store data generated based on device usage, etc. Furthermore, memory 920 may include high-speed random access memory and non-volatile memory, such as at least one disk storage device, flash memory device, or other non-volatile solid-state memory device. In some instances, memory 920 may further include memory remotely located relative to processor 910, which may be connected to the device via a network. Examples of such networks include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0100] The processor 910 executes various functional applications and data processing of the device by running the software programs, instructions and modules stored in the memory 920, that is, implements a method for quickly extracting three-dimensional data described in any of the above embodiments.

[0101] An embodiment of the present application further provides a computer-readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the method for rapidly extracting three-dimensional data as described in any one of the above embodiments is implemented.

[0102] The present invention may take the form of a computer program product implemented on one or more storage media (including but not limited to magnetic disk storage, CD-ROM, optical storage, etc.) containing program code. Computer-readable storage media include permanent and non-permanent, removable and non-removable media, and may be implemented by any method or technology for information storage. The information may be computer-readable instructions, data structures, program modules, or other data. Examples of computer storage media include but are not limited to: phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device.

[0103] It should be understood that the embodiments of the present application are not limited to the precise structures described above and shown in the drawings, and various modifications and changes can be made without departing from the scope thereof. The scope of the embodiments of the present application is limited only by the appended claims.

[0104] The above-described embodiments merely represent several implementation methods of the embodiments of the present application. While the descriptions are relatively specific and detailed, they should not be construed as limiting the scope of the invention. It should be noted that a person skilled in the art may make various modifications and improvements without departing from the concept of the embodiments of the present application, and these modifications and improvements fall within the scope of protection of the embodiments of the present application.

Claims

1. A rapid extraction system for three-dimensional data, characterized in that: include: A server and a client, wherein the server is connected to the client by signal; The server is used to traverse the osgb data file to obtain a tile information list, and obtain the tile coordinate range by traversing the tile information list, and then establish an index relationship between the tile coordinate range and the osgb data file according to the RTree spatial index rule; The client is used to generate an osgb data file calling instruction and send it to the server, wherein the osgb data file calling instruction includes a target vector coordinate range; The server is used to query the osgb data file according to the osgb data file calling instruction, obtain the target osgb data file and send it to the client; The server is further configured to read a plug-in through an OSG file to obtain the tile coordinate range, wherein the tile coordinate range indicates the coordinate points of the boundary of the minimum circumscribed rectangle of the tile, and when querying the OSGb data file in response to the OSGb data file retrieval instruction, obtain all tile coordinate ranges that intersect with the target vector coordinate range, and return the OSGb data files corresponding to all the tile coordinate ranges that intersect to the client; The server is further configured to establish a PostGIS spatial database and enter RTree spatial index result information into the PostGIS spatial database for storage, wherein the RTree spatial index result information includes the tile coordinate range, the osgb data file, and path information; The server side also includes a main server and a plurality of data servers, wherein the main server is signal-connected to the data servers; The main server is configured to generate an osgb data file sending instruction in response to the generating osgb data file calling instruction and send the instruction to the data server, wherein the osgb data file sending instruction includes address information of the target client; The data server is used to store the PostGIS spatial database, and confirms the data sending server according to the osgb data file sending instruction and the idle status of the data server, and sends the target osgb data file to the target client through the data sending server.

2. A method for rapid extraction of three-dimensional data, characterized in that: Applied to the server side, including: Traverse the osgb data file and obtain the tile information list; Traverse the tile information list to obtain the tile coordinate range; According to the RTree spatial index rule, an index relationship is established between the tile coordinate range and the osgb data file; querying the osgb data file according to an osgb data file retrieval instruction, obtaining a target osgb data file and sending the result to the client, wherein the osgb data file retrieval instruction is generated by the client and includes a target vector coordinate range; The obtaining of the tile coordinate range further includes: Reading a plug-in through an OSG file to obtain the tile coordinate range, wherein the tile coordinate range indicates the coordinate points of the minimum circumscribed rectangle boundary of the tile; When querying the osgb data file in response to the osgb data file retrieval instruction, obtaining all tile coordinate ranges that intersect with the target vector coordinate range; Returning the osgb data files corresponding to all the tile coordinate ranges with intersections to the client; After establishing an index relationship between the tile coordinate range and the osgb data file, the method further includes: A PostGIS spatial database is established, and RTree spatial index result information is entered into the PostGIS spatial database for storage, wherein the RTree spatial index result information includes the tile coordinate range, the osgb data file and path information.

3. A rapid extraction device for three-dimensional data, using the rapid extraction system for three-dimensional data according to claim 1, characterized in that: include: Tile information list acquisition device, used for traversing the osgb data file to obtain the tile information list; Tile coordinate range acquisition means, configured to traverse the tile information list and acquire the tile coordinate range; An index relationship establishment module, configured to establish an index relationship between the tile coordinate range and the osgb data file according to RTree spatial index rules; The file sending module is used to query the osgb data file according to the osgb data file calling instruction, obtain the target osgb data file and send it to the client, wherein the osgb data file calling instruction is generated by the client and the osgb data file calling instruction includes a target vector coordinate range.

4. An electronic device, characterized in that: include: at least one memory and at least one processor; The memory is used to store one or more programs; When the one or more programs are executed by the at least one processor, the at least one processor implements the steps of the method for quickly extracting three-dimensional data as claimed in claim 2.

5. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the method for quickly extracting three-dimensional data as claimed in claim 2 are implemented.

Citation Information

Patent Citations

  • Refined efficient dynamic tile map service publishing method, medium and electronic equipment

    CN114297206A

  • Method for making OSGB index file

    CN116578532A