CN110866026B - Automatic updating method and device for Sqlite image tile database - Google Patents
Automatic updating method and device for Sqlite image tile database Download PDFInfo
- Publication number
- CN110866026B CN110866026B CN201911102776.3A CN201911102776A CN110866026B CN 110866026 B CN110866026 B CN 110866026B CN 201911102776 A CN201911102776 A CN 201911102776A CN 110866026 B CN110866026 B CN 110866026B
- Authority
- CN
- China
- Prior art keywords
- sqlite
- remote sensing
- tile
- sensing image
- database
- 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.)
- Active
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/23—Updating
-
- 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
Abstract
The invention discloses a method and a device for automatically updating a Sqlite image tile database, which relate to the technical field of Internet map services, and comprise the following steps: obtaining a remote sensing image; slicing the remote sensing image into a plurality of first Sqlite tiles; generating a mosaic line according to the remote sensing image, wherein the mosaic line is the effective value range of the remote sensing image; calculating an effective value of the first Sqlite tile according to the mosaic line; generating a second Sqlite tile according to the effective value of the first Sqlite tile; obtaining a total Sqlite database; determining whether the second Sqlite tile is contained in the total Sqlite database; updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not included in the total Sqlite database. The technical effects of automatically updating the image tiles, improving the working efficiency and simultaneously avoiding human errors are achieved.
Description
Technical Field
The invention relates to the technical field of internet map services, in particular to an automatic updating method and device of a Sqlite image tile database.
Background
In the existing internet map service, the mainstream technology of the video map service is to slice a remote sensing image into a Sqlite tile database, then distribute the Sqlite tile database into a standard OGC map service, and load and present the standard OGC map service to a user at the front end. The maintenance and updating method flow of the image map service is that after the remote sensing image is subjected to map cutting processing by using software, as the map cutting range is the outer envelope rectangular range of the remote sensing image, the output tiles contain blank tiles, complete tiles and partial effective value tiles, then the complete tiles and partial effective value tiles need to be manually extracted, and then the partial tiles are updated into a total Sqlite tile database.
However, in the process of implementing the technical solution in the embodiment of the present invention, the inventor of the present invention finds that the above prior art has at least the following technical problems:
in the prior art, due to the fact that human intervention is needed at multiple places in the tile updating link, the technical problems that the working efficiency is low, mistakes are easy to occur, and large-scale updating of image tiles is not facilitated are caused.
Disclosure of Invention
The embodiment of the invention provides an automatic updating method and device for a Sqlite image tile database, which are used for solving the technical problems that in the prior art, due to the fact that multiple places need to be manually intervened in a tile updating link, the work efficiency is low, errors are easy to occur, and large-scale updating of image tiles is not facilitated. The technical effects of automatically updating the image tiles, improving the working efficiency and simultaneously avoiding human errors are achieved.
In view of the foregoing problems, embodiments of the present invention provide an automatic updating method and apparatus for a Sqlite image tile database.
In a first aspect, the invention provides a method for automatically updating a Sqlite image tile database, the method comprising obtaining a remote sensing image; slicing the remote sensing image into a plurality of first Sqlite tiles; generating a mosaic line according to the remote sensing image, wherein the mosaic line is the effective value range of the remote sensing image; calculating an effective value of the first Sqlite tile according to the mosaic line; generating a second Sqlite tile according to the effective value of the first Sqlite tile; obtaining a total Sqlite database; determining whether the second Sqlite tile is contained in the total Sqlite database; updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not included in the total Sqlite database.
Preferably, generating a mosaic line according to the remote sensing image, wherein the mosaic line is an effective value range of the remote sensing image, and the method comprises the following steps: obtaining the width and the height of the remote sensing image; calculating the effective value range of the remote sensing image according to the width and the height of the remote sensing image; and generating a mosaic line according to the effective value range of the remote sensing image.
Preferably, the calculating the effective value range of the remote sensing image according to the width and the height of the remote sensing image includes: obtaining all pixel values of the remote sensing image according to the width and the height of the remote sensing image; judging whether a first pixel value of the remote sensing image is a non-null value or not; if the first pixel value of the remote sensing image is a non-null value, reserving the first pixel value; and generating an effective value range of the remote sensing image according to the first pixel value.
Preferably, the calculating the effective value of the first Sqlite tile according to the mosaic line includes: obtaining a row number, a column number, and a level of the first Sqlite tile; calculating the range of the first Sqlite tile according to the row number, column number and level of the first Sqlite tile; judging the inclusion relation between the range of the first Sqlite tile and the inlaid line; determining that the valid value of the first Sqlite tile is the first Sqlite tile if the range of the first Sqlite tile is completely inside the inlaid line.
Preferably, the determining the inclusion relationship between the range of the first Sqlite tile and the mosaic line further includes: determining that the valid value of the first Sqlite tile is null if the range of the first Sqlite tile is completely outside the tessellation line.
Preferably, the determining the inclusion relationship between the range of the first Sqlite tile and the mosaic line further includes: determining an effective value of the first Sqlite tile as a pixel value of the first Sqlite tile within the mosaic line if the range of the first Sqlite tile intersects the mosaic line.
Preferably, the determining whether the total Sqlite database includes the second Sqlite tile further includes: not updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is included in the total Sqlite database.
In a second aspect, the present invention provides an apparatus for automatically updating a database of Sqlite image tiles, the apparatus comprising:
the first obtaining unit is used for obtaining a remote sensing image;
the first slicing unit is used for slicing the remote sensing image into a plurality of first Sqlite tiles;
the first generation unit is used for generating a mosaic line according to the remote sensing image, wherein the mosaic line is an effective value range of the remote sensing image;
a first calculation unit for calculating an effective value of the first Sqlite tile according to the mosaic line;
a second generation unit, configured to generate a second Sqlite tile according to the effective value of the first Sqlite tile;
a second obtaining unit for obtaining a total Sqlite database;
a first judging unit configured to judge whether the second Sqlite tile is included in the total Sqlite database;
a first updating unit to update the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not contained in the total Sqlite database.
Preferably, the first generation unit includes:
a third obtaining unit, configured to obtain a width and a height of the remote sensing image;
the second calculating unit is used for calculating the effective value range of the remote sensing image according to the width and the height of the remote sensing image;
and the third generating unit is used for generating a mosaic line according to the effective value range of the remote sensing image.
Preferably, the second calculation unit includes:
the fourth obtaining unit is used for obtaining all pixel values of the remote sensing image according to the width and the height of the remote sensing image;
the second judging unit is used for judging whether the first pixel value of the remote sensing image is a non-null value or not;
the first retaining unit is used for retaining a first pixel value of the remote sensing image if the first pixel value is a non-null value;
and the fourth generating unit is used for generating an effective value range of the remote sensing image according to the first pixel value.
Preferably, the first calculation unit includes:
a fifth obtaining unit for obtaining a row number, a column number, and a level of the first Sqlite tile;
a third computing unit to compute a range of the first Sqlite tile according to a row number, a column number, and a level of the first Sqlite tile;
a third judgment unit configured to judge an inclusion relationship between a range of the first Sqlite tile and the inlaid line;
a first determination unit to determine that the valid value of the first Sqlite tile is the first Sqlite tile if the range of the first Sqlite tile is completely inside the mosaic line.
Preferably, the third judging unit further includes:
a second determination unit to determine that the valid value of the first Sqlite tile is null if the range of the first Sqlite tile is completely outside the tessellation line.
Preferably, the third judging unit further includes:
a third determination unit to determine that the effective value of the first Sqlite tile is a pixel value of the first Sqlite tile within the mosaic line if the range of the first Sqlite tile intersects the mosaic line.
Preferably, the first judging unit further includes:
a second update unit to not update the second Sqlite tile into the total Sqlite database if the second Sqlite tile is included in the total Sqlite database.
In a third aspect, the present invention provides an apparatus for automatically updating a Sqlite image tile database, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor executes the program to perform the following steps:
obtaining a remote sensing image; slicing the remote sensing image into a plurality of first Sqlite tiles; generating a mosaic line according to the remote sensing image, wherein the mosaic line is the effective value range of the remote sensing image; calculating an effective value of the first Sqlite tile according to the mosaic line; generating a second Sqlite tile according to the effective value of the first Sqlite tile; obtaining a total Sqlite database; determining whether the second Sqlite tile is contained in the total Sqlite database; updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not included in the total Sqlite database.
In a fourth aspect, the invention provides a computer-readable storage medium having a computer program stored thereon, the program, when executed by a processor, implementing the steps of:
obtaining a remote sensing image; slicing the remote sensing image into a plurality of first Sqlite tiles; generating a mosaic line according to the remote sensing image, wherein the mosaic line is the effective value range of the remote sensing image; calculating an effective value of the first Sqlite tile according to the mosaic line; generating a second Sqlite tile according to the effective value of the first Sqlite tile; obtaining a total Sqlite database; determining whether the second Sqlite tile is contained in the total Sqlite database; updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not included in the total Sqlite database.
One or more technical solutions in the embodiments of the present invention at least have one or more of the following technical effects:
the embodiment of the invention provides an automatic updating method and device of a Sqlite image tile database, wherein the method comprises the steps of obtaining a remote sensing image; slicing the remote sensing image into a plurality of first Sqlite tiles; generating a mosaic line according to the remote sensing image, wherein the mosaic line is the effective value range of the remote sensing image; calculating an effective value of the first Sqlite tile according to the mosaic line; generating a second Sqlite tile according to the effective value of the first Sqlite tile; obtaining a total Sqlite database; determining whether the second Sqlite tile is contained in the total Sqlite database; updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not included in the total Sqlite database. The method solves the technical problems that in the prior art, due to the fact that human intervention is needed at multiple positions in the tile updating link, the working efficiency is low, mistakes are easy to occur, and large-scale updating of the image tiles is not facilitated. Further, the technical effects of automatically updating the image tiles, improving the working efficiency and simultaneously avoiding human errors are achieved.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
Drawings
FIG. 1 is a flowchart illustrating a method for automatically updating a Sqlite image tile database according to an embodiment of the present invention;
FIG. 2 is a schematic diagram illustrating an apparatus for automatically updating a Sqlite image tile database according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of another automatic update apparatus for a Sqlite image tile database according to an embodiment of the present invention.
Description of reference numerals: a first obtaining unit 11, a first slicing unit 12, a first generating unit 13, a first calculating unit 14, a second generating unit 15, a second obtaining unit 16, a first judging unit 17, a first updating unit 18, a bus 300, a receiver 301, a processor 302, a transmitter 303, a memory 304, and a bus interface 306.
Detailed Description
The embodiment of the invention provides an automatic updating method and device for a Sqlite image tile database, and solves the technical problems that in the prior art, due to the fact that multiple places need to be manually intervened in a tile updating link, the work efficiency is low, errors are prone to occurring, and large-scale updating of image tiles is not facilitated.
In order to solve the technical problems, the technical scheme provided by the invention has the following general idea: obtaining a remote sensing image; slicing the remote sensing image into a plurality of first Sqlite tiles; generating a mosaic line according to the remote sensing image, wherein the mosaic line is the effective value range of the remote sensing image; calculating an effective value of the first Sqlite tile according to the mosaic line; generating a second Sqlite tile according to the effective value of the first Sqlite tile; obtaining a total Sqlite database; determining whether the second Sqlite tile is contained in the total Sqlite database; updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not included in the total Sqlite database. Further, the technical effects of automatically updating the image tiles, improving the working efficiency and simultaneously avoiding human errors are achieved.
The technical solutions of the present invention are described in detail below with reference to the drawings and the specific embodiments, and it should be understood that the specific features in the embodiments and the embodiments of the present invention are not intended to limit the technical solutions of the present invention, but may be combined with each other without conflict.
Example one
Fig. 1 is a flowchart illustrating an automatic updating method of a Sqlite image tile database according to an embodiment of the present invention, as shown in fig. 1, the method includes:
step 110: obtaining a remote sensing image;
step 120: slicing the remote sensing image into a plurality of first Sqlite tiles;
step 130: generating a mosaic line according to the remote sensing image, wherein the mosaic line is the effective value range of the remote sensing image;
step 140: calculating an effective value of the first Sqlite tile according to the mosaic line;
step 150: generating a second Sqlite tile according to the effective value of the first Sqlite tile;
step 160: obtaining a total Sqlite database;
step 170: determining whether the second Sqlite tile is contained in the total Sqlite database;
step 180: updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not included in the total Sqlite database.
Further, the determining whether the total Sqlite database includes the second Sqlite tile further comprises: not updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is included in the total Sqlite database.
Specifically, the automatic updating method for the Sqlite image tile database provided by the embodiment of the invention is developed by adopting python language, calls unilateral modules gdal and arcpy, and supports cross-platform deployment. Firstly, obtaining a remote sensing image to be updated, slicing the remote sensing image into a plurality of first Sqlite tile databases by using software, then generating a mosaic line according to the remote sensing image, wherein the mosaic line is an effective value range of the remote sensing image, the slicing range is an outer envelope rectangular range of the remote sensing image, the output first Sqlite tile comprises a blank tile, a complete tile and a partial effective value tile, the blank tile is a first Sqlite tile completely positioned outside the mosaic line, the complete tile is a first Sqlite tile completely positioned inside the mosaic line, the partial effective value tile is a first Sqlite tile partially positioned inside the mosaic line, namely the first Sqlite tile is intersected with the mosaic line, so that an effective value of the first Sqlite tile is calculated according to the mosaic line, and then generating a second Sqlite tile by using the effective value of the first Sqlite tile, this avoids updating a blank tile and a partial invalid value tile into the total Sqlite tile database, wherein the partial invalid value tile is a pixel value of the first Sqlite tile that is outside the mosaic line. After the second Sqlite tile is obtained, obtaining a total Sqlite database, comparing the second Sqlite tile with the total Sqlite database, judging whether the second Sqlite tile is contained in the total Sqlite database, and if the second Sqlite tile is not contained in the total Sqlite database and indicates that the second Sqlite tile is a new image, updating the second Sqlite tile into the total Sqlite database; if the second Sqlite tile is contained in the total Sqlite database, namely the pixels of the second Sqlite tile are repeated with the pixels in the total Sqlite database, namely the second Sqlite tile does not need to be updated into the total Sqlite database, and the process is repeated until a plurality of first Sqlite tiles are subjected to the series of processing, whether the first Sqlite tiles are updated into the total Sqlite database or not is determined, so that the defect that the whole tiles and part of effective value tiles are manually extracted is overcome, the image tiles are automatically updated, the working efficiency is improved, and the technical effect of avoiding human errors is achieved.
Further, according to the remote sensing image, a mosaic line is generated, wherein the mosaic line is an effective value range of the remote sensing image, and the mosaic line comprises: obtaining the width and the height of the remote sensing image; calculating the effective value range of the remote sensing image according to the width and the height of the remote sensing image; and generating a mosaic line according to the effective value range of the remote sensing image.
Further, the calculating the effective value range of the remote sensing image according to the width and the height of the remote sensing image includes: obtaining all pixel values of the remote sensing image according to the width and the height of the remote sensing image; judging whether a first pixel value of the remote sensing image is a non-null value; if the first pixel value of the remote sensing image is a non-null value, reserving the first pixel value; and generating an effective value range of the remote sensing image according to the first pixel value.
Specifically, the width and the height of the remote sensing image are read, all pixel values of the remote sensing image are obtained within the width and the height range of the remote sensing image, then one pixel value is arbitrarily extracted from all the pixel values to serve as a first pixel value, whether the first pixel value of the remote sensing image is a non-null value or not is judged, if the first pixel value of the remote sensing image is the non-null value, the first pixel value is reserved, and finally all pixel composition ranges with the non-null value, namely the effective value range of the remote sensing image, are extracted, and a mosaic line shp file is generated. And if the width and height ranges of the remote sensing image are larger, calculating the effective value range of the remote sensing image in a multithreading mode, and exporting the inlaid line shp file, so that the aim of improving the working efficiency is fulfilled.
Further, the calculating the effective value of the first Sqlite tile according to the mosaic line includes: obtaining a row number, a column number, and a level of the first Sqlite tile; calculating the range of the first Sqlite tile according to the row number, column number and level of the first Sqlite tile; judging the inclusion relation between the range of the first Sqlite tile and the inlaid line; determining that the valid value of the first Sqlite tile is the first Sqlite tile if the range of the first Sqlite tile is completely inside the inlaid line.
Further, the determining the inclusion relationship between the range of the first Sqlite tile and the inlaid line further includes: determining that the valid value of the first Sqlite tile is null if the range of the first Sqlite tile is completely outside the tessellation line.
Further, the determining the inclusion relationship between the range of the first Sqlite tile and the inlaid line further includes: determining an effective value of the first Sqlite tile as a pixel value of the first Sqlite tile within the mosaic line if the range of the first Sqlite tile intersects the mosaic line.
Specifically, in step 140, sequentially obtaining the row number, column number and level of each first Sqlite tile, thereby calculating the range of the first Sqlite tile, and then comparing the range of the first Sqlite tile with the mosaic line, in order to determine which kind of the first Sqlite tile is a blank tile, a complete tile or a partial valid value tile, in short, determining the inclusion relationship between the range of the first Sqlite tile and the mosaic line, if the range of the first Sqlite tile is completely located inside the mosaic line, that is, the mosaic line contains the first Sqlite tile, determining that the first Sqlite tile has the valid value of the first Sqlite tile itself, that is, the first Sqlite tile is a complete tile; if the range of the first Sqlite tile is completely outside of the mosaic line, i.e., the mosaic line does not contain the first Sqlite tile, then determining that the valid value of the first Sqlite tile is null, i.e., the first Sqlite tile is a blank tile; if the range of the first Sqlite tile intersects the mosaic line, i.e., the mosaic line contains a portion of the first Sqlite tile, then the valid value of the first Sqlite tile is determined to be the pixel value of the first Sqlite tile within the mosaic line, i.e., the first Sqlite tile is a partial valid value tile. Further, the technical effects of automatically extracting complete tiles and partial effective value tiles, avoiding human errors and greatly improving efficiency are achieved.
Example two
Based on the same inventive concept as the automatic updating method of the Sqlite image tile database in the foregoing embodiment, the present invention further provides an automatic updating apparatus of the Sqlite image tile database, as shown in fig. 2, the apparatus includes:
the device comprises a first obtaining unit 11, a second obtaining unit 11 and a control unit, wherein the first obtaining unit 11 is used for obtaining remote sensing images;
a first slicing unit 12, wherein the first slicing unit 12 is configured to slice the remote sensing image into a plurality of first Sqlite tiles;
a first generating unit 13, where the first generating unit 13 is configured to generate a mosaic line according to the remote sensing image, where the mosaic line is an effective value range of the remote sensing image;
a first calculation unit 14, said first calculation unit 14 being configured to calculate an effective value of said first Sqlite tile according to said tessellation line;
a second generating unit 15, configured to generate a second Sqlite tile according to the effective value of the first Sqlite tile by using the second generating unit 15;
a second obtaining unit 16, the second obtaining unit 16 being configured to obtain a total Sqlite database;
a first judging unit 17, configured to judge whether the second Sqlite tile is included in the total Sqlite database or not;
a first updating unit 18, the first updating unit 18 being configured to update the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not contained in the total Sqlite database.
Further, the first generation unit 13 includes:
a third obtaining unit, configured to obtain a width and a height of the remote sensing image;
the second calculating unit is used for calculating the effective value range of the remote sensing image according to the width and the height of the remote sensing image;
and the third generating unit is used for generating a mosaic line according to the effective value range of the remote sensing image.
Further, the second calculation unit includes:
the fourth obtaining unit is used for obtaining all pixel values of the remote sensing image according to the width and the height of the remote sensing image;
the second judging unit is used for judging whether the first pixel value of the remote sensing image is a non-null value or not;
the first retaining unit is used for retaining the first pixel value of the remote sensing image if the first pixel value is a non-null value;
and the fourth generating unit is used for generating an effective value range of the remote sensing image according to the first pixel value.
Further, the first calculation unit 14 includes:
a fifth obtaining unit for obtaining a row number, a column number, and a level of the first Sqlite tile;
a third computing unit to compute a range of the first Sqlite tile according to a row number, a column number, and a level of the first Sqlite tile;
a third judgment unit configured to judge an inclusion relationship between a range of the first Sqlite tile and the inlaid line;
a first determination unit to determine that the valid value of the first Sqlite tile is the first Sqlite tile if the range of the first Sqlite tile is completely inside the mosaic line.
Further, the third determining unit further includes:
a second determination unit to determine that the valid value of the first Sqlite tile is null if the range of the first Sqlite tile is completely outside the tessellation line.
Further, the third determining unit further includes:
a third determination unit to determine that the effective value of the first Sqlite tile is a pixel value of the first Sqlite tile within the mosaic line if the range of the first Sqlite tile intersects the mosaic line.
Further, the first judging unit 17 further includes:
a second update unit to not update the second Sqlite tile into the total Sqlite database if the second Sqlite tile is included in the total Sqlite database.
Various changes and embodiments of the aforementioned automatic update method for a Sqlite image tile database in the first embodiment of fig. 1 are also applicable to the automatic update device for a Sqlite image tile database in this embodiment, and through the aforementioned detailed description of the automatic update method for a Sqlite image tile database, those skilled in the art can clearly understand the implementation method of the automatic update device for a Sqlite image tile database in this embodiment, so for the brevity of the description, detailed description is omitted here.
EXAMPLE III
Based on the same inventive concept as the method for automatically updating the Sqlite image tile database in the previous embodiment, the present invention further provides an automatic updating apparatus for the Sqlite image tile database, wherein a computer program is stored thereon, and when the program is executed by a processor, the steps of any one of the above methods for automatically updating the Sqlite image tile database are implemented.
Where in fig. 3 a bus architecture (represented by bus 300), bus 300 may include any number of interconnected buses and bridges, bus 300 linking together various circuits including one or more processors, represented by processor 302, and memory, represented by memory 304. The bus 300 may also link together various other circuits such as peripherals, voltage regulators, power management circuits, and the like, which are well known in the art, and therefore, will not be described any further herein. A bus interface 306 provides an interface between the bus 300 and the receiver 301 and transmitter 303. The receiver 301 and the transmitter 303 may be the same element, i.e., a transceiver, providing a means for communicating with various other apparatus over a transmission medium.
The processor 302 is responsible for managing the bus 300 and general processing, and the memory 304 may be used for storing data used by the processor 302 in performing operations.
Example four
Based on the same inventive concept as the automatic updating method of the Sqlite image tile database in the previous embodiment, the present invention further provides a computer readable storage medium having a computer program stored thereon, which when executed by a processor, implements the following steps:
obtaining a remote sensing image; slicing the remote sensing image into a plurality of first Sqlite tiles; generating a mosaic line according to the remote sensing image, wherein the mosaic line is the effective value range of the remote sensing image; calculating an effective value of the first Sqlite tile according to the mosaic line; generating a second Sqlite tile according to the effective value of the first Sqlite tile; obtaining a total Sqlite database; determining whether the second Sqlite tile is contained in the total Sqlite database; updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not included in the total Sqlite database.
In a specific implementation, when the program is executed by a processor, any method step in the first embodiment may be further implemented.
One or more technical solutions in the embodiments of the present invention at least have one or more of the following technical effects:
the embodiment of the invention provides an automatic updating method and device of a Sqlite image tile database, wherein the method comprises the steps of obtaining a remote sensing image; slicing the remote sensing image into a plurality of first Sqlite tiles; generating a mosaic line according to the remote sensing image, wherein the mosaic line is the effective value range of the remote sensing image; calculating an effective value of the first Sqlite tile according to the mosaic line; generating a second Sqlite tile according to the effective value of the first Sqlite tile; obtaining a total Sqlite database; determining whether the second Sqlite tile is contained in the total Sqlite database; updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not included in the total Sqlite database. The method solves the technical problems that in the prior art, due to the fact that human intervention is needed at multiple positions in the tile updating link, the working efficiency is low, mistakes are easy to occur, and large-scale updating of the image tiles is not facilitated. Further, the technical effects of automatically updating the image tiles, improving the working efficiency and simultaneously avoiding human errors are achieved.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include such modifications and variations.
Claims (8)
1. A method for automatically updating a database of Sqlite image tiles, the method comprising:
obtaining a remote sensing image;
slicing the remote sensing image into a plurality of first Sqlite tiles;
generating a mosaic line according to the remote sensing image, wherein the mosaic line is the effective value range of the remote sensing image;
calculating an effective value of the first Sqlite tile according to the mosaic line;
generating a second Sqlite tile according to the effective value of the first Sqlite tile;
obtaining a total Sqlite database;
determining whether the second Sqlite tile is included in the total Sqlite database;
updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not contained in the total Sqlite database;
generating a mosaic line according to the remote sensing image, wherein the mosaic line is an effective value range of the remote sensing image and comprises:
obtaining the width and the height of the remote sensing image;
calculating the effective value range of the remote sensing image according to the width and the height of the remote sensing image;
generating a mosaic line according to the effective value range of the remote sensing image;
wherein, according to the width and the height of the remote sensing image, calculating the effective value range of the remote sensing image comprises the following steps:
obtaining all pixel values of the remote sensing image according to the width and the height of the remote sensing image;
judging whether a first pixel value of the remote sensing image is a non-null value;
if the first pixel value of the remote sensing image is a non-null value, reserving the first pixel value;
and generating an effective value range of the remote sensing image according to the first pixel value.
2. The method of claim 1, wherein said calculating a valid value for the first Sqlite tile according to the tessellation line comprises:
obtaining a row number, a column number, and a level of the first Sqlite tile;
calculating the range of the first Sqlite tile according to the row number, column number and level of the first Sqlite tile;
judging the inclusion relation between the range of the first Sqlite tile and the inlaid line;
determining that the valid value of the first Sqlite tile is the first Sqlite tile if the range of the first Sqlite tile is completely inside the inlaid line.
3. The method of claim 2, wherein the determining the inclusive relationship of the extent of the first Sqlite tile to the tessellation line further comprises:
determining that the valid value of the first Sqlite tile is a null value if the range of the first Sqlite tile is completely outside the tessellation line.
4. The method of claim 2, wherein said determining a containment relationship of a range of the first Sqlite tile to the mosaic line further comprises:
determining an effective value of the first Sqlite tile as a pixel value of the first Sqlite tile within the mosaic line if the range of the first Sqlite tile intersects the mosaic line.
5. The method of claim 1, wherein the determining whether the second Sqlite tile is contained in the total Sqlite database further comprises:
not updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is included in the total Sqlite database.
6. An apparatus for automatically updating a database of Sqlite tiles, the apparatus comprising:
the first obtaining unit is used for obtaining a remote sensing image;
the first slicing unit is used for slicing the remote sensing image into a plurality of first Sqlite tiles;
the remote sensing image processing device comprises a first generating unit, a second generating unit and a control unit, wherein the first generating unit is used for generating a mosaic line according to the remote sensing image, and the mosaic line is an effective value range of the remote sensing image;
a first calculation unit for calculating an effective value of the first Sqlite tile according to the mosaic line;
a second generation unit, configured to generate a second Sqlite tile according to the effective value of the first Sqlite tile;
a second obtaining unit for obtaining a total Sqlite database;
a first determination unit configured to determine whether the second Sqlite tile is included in the total Sqlite database;
a first updating unit for updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not contained in the total Sqlite database;
wherein the first generation unit includes:
a third obtaining unit, configured to obtain a width and a height of the remote sensing image;
the second calculating unit is used for calculating the effective value range of the remote sensing image according to the width and the height of the remote sensing image;
the third generating unit is used for generating mosaic lines according to the effective value range of the remote sensing image;
wherein the second calculation unit includes:
the fourth obtaining unit is used for obtaining all pixel values of the remote sensing image according to the width and the height of the remote sensing image;
the second judging unit is used for judging whether the first pixel value of the remote sensing image is a non-null value or not;
the first retaining unit is used for retaining the first pixel value of the remote sensing image if the first pixel value is a non-null value;
and the fourth generating unit is used for generating an effective value range of the remote sensing image according to the first pixel value.
7. An apparatus for automatically updating a database of Sqlite image tiles, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor when executing the program performs the steps of:
obtaining a remote sensing image;
slicing the remote sensing image into a plurality of first Sqlite tiles;
generating a mosaic line according to the remote sensing image, wherein the mosaic line is the effective value range of the remote sensing image;
calculating an effective value of the first Sqlite tile according to the mosaic line;
generating a second Sqlite tile according to the effective value of the first Sqlite tile;
obtaining a total Sqlite database;
determining whether the second Sqlite tile is contained in the total Sqlite database;
updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not contained in the total Sqlite database;
generating a mosaic line according to the remote sensing image, wherein the mosaic line is an effective value range of the remote sensing image and comprises:
obtaining the width and the height of the remote sensing image;
calculating the effective value range of the remote sensing image according to the width and the height of the remote sensing image;
generating a mosaic line according to the effective value range of the remote sensing image;
wherein, according to the width and the height of the remote sensing image, calculating the effective value range of the remote sensing image comprises the following steps:
obtaining all pixel values of the remote sensing image according to the width and the height of the remote sensing image;
judging whether a first pixel value of the remote sensing image is a non-null value;
if the first pixel value of the remote sensing image is a non-null value, reserving the first pixel value;
and generating an effective value range of the remote sensing image according to the first pixel value.
8. A computer-readable storage medium, on which a computer program is stored, which program, when executed by a processor, carries out the steps of:
obtaining a remote sensing image;
slicing the remote sensing image into a plurality of first Sqlite tiles;
generating a mosaic line according to the remote sensing image, wherein the mosaic line is the effective value range of the remote sensing image;
calculating an effective value of the first Sqlite tile according to the mosaic line;
generating a second Sqlite tile according to the effective value of the first Sqlite tile;
obtaining a total Sqlite database;
determining whether the second Sqlite tile is contained in the total Sqlite database;
updating the second Sqlite tile into the total Sqlite database if the second Sqlite tile is not contained in the total Sqlite database;
generating a mosaic line according to the remote sensing image, wherein the mosaic line is an effective value range of the remote sensing image and comprises:
obtaining the width and the height of the remote sensing image;
calculating the effective value range of the remote sensing image according to the width and the height of the remote sensing image;
generating a mosaic line according to the effective value range of the remote sensing image;
wherein, according to the width and the height of the remote sensing image, calculating the effective value range of the remote sensing image comprises the following steps:
obtaining all pixel values of the remote sensing image according to the width and the height of the remote sensing image;
judging whether a first pixel value of the remote sensing image is a non-null value;
if the first pixel value of the remote sensing image is a non-null value, reserving the first pixel value;
and generating an effective value range of the remote sensing image according to the first pixel value.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911102776.3A CN110866026B (en) | 2019-11-12 | 2019-11-12 | Automatic updating method and device for Sqlite image tile database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911102776.3A CN110866026B (en) | 2019-11-12 | 2019-11-12 | Automatic updating method and device for Sqlite image tile database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110866026A CN110866026A (en) | 2020-03-06 |
| CN110866026B true CN110866026B (en) | 2022-08-09 |
Family
ID=69653898
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911102776.3A Active CN110866026B (en) | 2019-11-12 | 2019-11-12 | Automatic updating method and device for Sqlite image tile database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110866026B (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103090876A (en) * | 2011-11-07 | 2013-05-08 | 伊莱比特汽车公司 | Technique for structuring navigation data |
| CN105426372A (en) * | 2014-09-17 | 2016-03-23 | 高德软件有限公司 | Electronic map data manufacturing and updating method and apparatus |
| CN106844537A (en) * | 2016-12-30 | 2017-06-13 | 重庆知行地理信息咨询服务有限公司 | A kind of organization and management method of space-time map tile data |
| CN107193923A (en) * | 2017-05-16 | 2017-09-22 | 中国科学院遥感与数字地球研究所 | A kind of method and system of two-dimentional geographical space rapid vector superposition |
| CN108287845A (en) * | 2017-01-09 | 2018-07-17 | 北京四维图新科技股份有限公司 | A kind of Automatic extraction method for road information and device and hybrid navigation system |
| CN108664619A (en) * | 2018-05-14 | 2018-10-16 | 江西理工大学 | The magnanimity line of one type tile technology draws the storage of topographic map basis and dispatching method |
| CN108764168A (en) * | 2018-05-31 | 2018-11-06 | 合肥工业大学 | The method and system of target are moved in multi-obstacle avoidance surface-search for imaging satellite |
| CN109635844A (en) * | 2018-11-14 | 2019-04-16 | 网易传媒科技（北京）有限公司 | The method and device and method of detecting watermarks and device of training classifier |
| CN109841282A (en) * | 2018-12-10 | 2019-06-04 | 广东省中医院 | A kind of Chinese medicine health control cloud system and its building method based on cloud computing |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9075822B2 (en) * | 2011-02-11 | 2015-07-07 | Here Global B.V. | Incremental testing of a navigation database |
| US10275164B2 (en) * | 2015-05-27 | 2019-04-30 | Nutech Ventures | Enforcing persistency for battery-backed mobile devices |
-
2019
- 2019-11-12 CN CN201911102776.3A patent/CN110866026B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103090876A (en) * | 2011-11-07 | 2013-05-08 | 伊莱比特汽车公司 | Technique for structuring navigation data |
| CN105426372A (en) * | 2014-09-17 | 2016-03-23 | 高德软件有限公司 | Electronic map data manufacturing and updating method and apparatus |
| CN106844537A (en) * | 2016-12-30 | 2017-06-13 | 重庆知行地理信息咨询服务有限公司 | A kind of organization and management method of space-time map tile data |
| CN108287845A (en) * | 2017-01-09 | 2018-07-17 | 北京四维图新科技股份有限公司 | A kind of Automatic extraction method for road information and device and hybrid navigation system |
| CN107193923A (en) * | 2017-05-16 | 2017-09-22 | 中国科学院遥感与数字地球研究所 | A kind of method and system of two-dimentional geographical space rapid vector superposition |
| CN108664619A (en) * | 2018-05-14 | 2018-10-16 | 江西理工大学 | The magnanimity line of one type tile technology draws the storage of topographic map basis and dispatching method |
| CN108764168A (en) * | 2018-05-31 | 2018-11-06 | 合肥工业大学 | The method and system of target are moved in multi-obstacle avoidance surface-search for imaging satellite |
| CN109635844A (en) * | 2018-11-14 | 2019-04-16 | 网易传媒科技（北京）有限公司 | The method and device and method of detecting watermarks and device of training classifier |
| CN109841282A (en) * | 2018-12-10 | 2019-06-04 | 广东省中医院 | A kind of Chinese medicine health control cloud system and its building method based on cloud computing |
Non-Patent Citations (2)
| Title |
|---|
| MV-FTL: An FTL That Provides Page-Level Multi-Version Management;Doogie Lee 等;《IEEE Transactions on Knowledge and Data Engineering》;20180101;第30卷(第1期);87-100 * |
| 基于Android平台的街景采集系统的研究;任东风 等;《测绘与空间地理信息》;20161125;第39卷(第11期);22-24 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110866026A (en) | 2020-03-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103544711B (en) | The autoegistration method of remote sensing image | |
| WO2019041842A1 (en) | Image processing method and device, storage medium and computer device | |
| CN114170360B (en) | Merging and rendering method and system suitable for multiple terrain data and electronic equipment | |
| US10909724B2 (en) | Method, apparatus, and computer readable medium for adjusting color annotation of an image | |
| CN109616080B (en) | Special-shaped screen contour compensation method and terminal | |
| CN110490181B (en) | Form filling and auditing method, device and equipment based on OCR (optical character recognition) technology and computer storage medium | |
| CN114880337B (en) | Map data integrated updating method, device, equipment and storage medium | |
| CN110866026B (en) | Automatic updating method and device for Sqlite image tile database | |
| US10580198B2 (en) | System and method for optimized sparse volume rendering | |
| CN111462278B (en) | Depth-based material sequencing rendering method, medium, equipment and device | |
| CN112927147B (en) | Display data correction method and device of display module, computer equipment and medium | |
| CN111985471A (en) | License plate positioning method and device and storage medium | |
| CN115690180A (en) | Vector map registration method, registration system, electronic device and storage medium | |
| JP2022006180A (en) | Hand shaking correction method of image, device, electronic device, storage media, computer program product, roadside machine and cloud control platform | |
| CN113850757A (en) | Mosaic detection method, mosaic detection device, electronic equipment and readable storage medium | |
| CN111047498B (en) | GPU hardware copy buffer algorithm-oriented TLM microstructure | |
| CN106569767B (en) | Window elements drafting, display methods and the system of combination | |
| KR101028767B1 (en) | A Method For Updating Geographic Image Information | |
| CN104240275A (en) | Image repairing method and device | |
| CN110852936B (en) | Method and device for mixing pictures | |
| CN103957457B (en) | LED programs broadcast control device, system and method | |
| CN115100081B (en) | LCD display screen gray scale image enhancement method, device, equipment and storage medium | |
| CN111967781B (en) | Impact assessment method and device for system transformation | |
| CN115457432B (en) | Data processing method and device for video frame extraction | |
| CN114546869A (en) | Visual restoration testing method and device for interface development |
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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: Floor 9, block B, Huihang Plaza, middle section of Hangtuo Road, national civil aerospace industry base, Xi'an, Shaanxi 710000 Applicant after: Zhongke Xingtu Space Technology Co.,Ltd. Address before: Floor 9, block B, Huihang Plaza, middle section of Hangtuo Road, national civil aerospace industry base, Xi'an, Shaanxi 710000 Applicant before: Xi'an Zhongke Xingtu Spatial Data Technology Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |