A method and device for fusion of subsidence data
Through the combination of inverse distance weighted interpolation and tree data structure, the problem of low efficiency in traditional settlement data processing is solved, efficient settlement data fusion is achieved, and more accurate and continuous surface settlement monitoring information is provided.
Patent Information
- Application Number
- CN202411075586.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-07
- Publication Date
- 2024-11-26
- Estimated Expiration
- 2044-08-07
AI Technical Summary
Traditional settlement data processing methods are low efficiency and low accuracy when fusing multi-phase settlement results, making it difficult to meet the needs of increasing data volume in surface settlement monitoring.
Using the inverse distance weighted interpolation method, the settlement result tables of the first and second time periods are matched and processed through a tree data structure (such as KDTREE), and merged into the settlement result tables under the target time period to maintain the number of monitoring points. Unchanged, improving the accuracy and efficiency of data fusion.
It realizes more comprehensive and continuous settlement monitoring information, improves the accuracy, accuracy and efficiency of data fusion, and is suitable for processing large-scale surface settlement data.
Smart Images

Figure CN118585519B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of computer technology, and in particular to a method and device for fusion of settlement data. Background Art
[0002] In surface subsidence monitoring, SBAS-InSAR technology can effectively monitor small surface deformations, and the subsidence results of different time periods can be obtained through this technology. However, due to the differences in monitoring time and range, multiple periods of subsidence results may be obtained, and these results need to be fused to obtain more complete and accurate long-term monitoring results. In addition, with the increase in data volume, traditional data processing methods are less efficient and accurate when fusing multiple periods of subsidence results, and more efficient solutions need to be found. Summary of the invention
[0003] The present application provides a settlement data fusion method and device to solve the problem that in surface settlement monitoring, as the amount of settlement result data increases, the traditional settlement result data processing method has low efficiency and low accuracy when fusing multiple settlement results, and a more efficient solution needs to be found.
[0004] In a first aspect, the present application provides a method for fusion of sedimentation data, the method comprising:
[0005] Obtain a first settlement result table in a first time period and a second settlement result table in a second time period; wherein, at least a portion of the time periods overlap between the first time period and the second time period; the first settlement result table includes a plurality of settlement information, and the second settlement result table includes at least one settlement information, each settlement information includes an information identifier, coordinate information of a monitoring point, and time-series settlement amounts of the monitoring point at each information monitoring time;
[0006] For each settlement information in the second settlement result table, using the first settlement result table in the first time period and the coordinate information of the monitoring point of the settlement information, determine a number of target monitoring points in the first settlement result table corresponding to the monitoring point of the settlement information; using the settlement information respectively corresponding to the several target monitoring points, perform inverse distance weighted interpolation processing on the monitoring point of the settlement information to obtain the settlement information of the monitoring point of the settlement information in the first time period;
[0007] Determine a second settlement result table for the first time period according to the settlement information of the monitoring points of all settlement information in the second settlement result table for the first time period;
[0008] For each settlement information in the first settlement result table, using the second settlement result table in the second time period and the coordinate information of the monitoring point of the settlement information, determine a number of target monitoring points in the second settlement result table corresponding to the monitoring point of the settlement information; using the settlement information respectively corresponding to the several target monitoring points, perform inverse distance weighted interpolation processing on the monitoring point of the settlement information to obtain the settlement information of the monitoring point of the settlement information in the second time period;
[0009] Determine the first settlement result table for the second time period according to the settlement information of the monitoring points of all settlement information in the first settlement result table for the second time period;
[0010] According to the first settlement result table under the first time period, the first settlement result table under the second time period, the second settlement result table under the first time period and the second settlement result table under the second time period, a settlement result table under the target time period is obtained; wherein the target time period is the splicing time period of the first time period and the second time period.
[0011] In a second aspect, the present application provides a sedimentation data fusion device, the device comprising:
[0012] The first unit is used to obtain a first settlement result table in a first time period and a second settlement result table in a second time period; wherein, there is at least a partial overlap between the first time period and the second time period; the first settlement result table includes a plurality of settlement information, and the second settlement result table includes at least one settlement information, each settlement information includes an information identifier, coordinate information of a monitoring point, and time-series settlement amounts of the monitoring point at each information monitoring time;
[0013] The second unit is used to determine, for each settlement information in the second settlement result table, a number of target monitoring points corresponding to the monitoring points of the settlement information in the first settlement result table by using the first settlement result table in the first time period and the coordinate information of the monitoring points of the settlement information; and to perform inverse distance weighted interpolation processing on the monitoring points of the settlement information by using the settlement information respectively corresponding to the several target monitoring points to obtain the settlement information of the monitoring points of the settlement information in the first time period;
[0014] A third unit is used to determine a second settlement result table in the first time period according to the settlement information of the monitoring points of all settlement information in the second settlement result table in the first time period;
[0015] The fourth unit is used to determine, for each settlement information in the first settlement result table, a number of target monitoring points corresponding to the monitoring points of the settlement information in the second settlement result table by using the second settlement result table in the second time period and the coordinate information of the monitoring points of the settlement information; perform inverse distance weighted interpolation processing on the monitoring points of the settlement information by using the settlement information respectively corresponding to the several target monitoring points, so as to obtain the settlement information of the monitoring points of the settlement information in the second time period;
[0016] A fifth unit is used to determine the first settlement result table in the second time period according to the settlement information of the monitoring points of all settlement information in the first settlement result table in the second time period;
[0017] The sixth unit is used to obtain a settlement result table under a target time period based on the first settlement result table under the first time period, the first settlement result table under the second time period, the second settlement result table under the first time period and the second settlement result table under the second time period; wherein the target time period is the splicing time period of the first time period and the second time period.
[0018] In a third aspect, the present application provides a readable medium comprising execution instructions. When a processor of an electronic device executes the execution instructions, the electronic device executes any method described in the first aspect.
[0019] In a fourth aspect, the present application provides an electronic device, comprising a processor and a memory storing execution instructions, wherein when the processor executes the execution instructions stored in the memory, the processor executes any method described in the first aspect.
[0020] It can be seen from the above technical scheme that the present application provides a settlement data fusion method, which can merge a first settlement result table in a first time period and a second settlement result table in a second time period into a settlement result table in a target time period. At the same time, the number of monitoring points can be kept unchanged, thereby providing more comprehensive and continuous settlement monitoring information. In addition, the present application adopts an inverse distance weighted interpolation method, which can more accurately estimate the settlement information of the monitoring point of the settlement information in other time periods based on the settlement information of several target monitoring points closest to the monitoring point of the settlement information, thereby improving the data fusion precision, data fusion accuracy and data fusion efficiency of the fusion of the settlement result tables.
[0021] The further effects of the above-mentioned non-conventional preferred manner will be described below in conjunction with specific embodiments. BRIEF DESCRIPTION OF THE DRAWINGS
[0022] In order to more clearly illustrate the embodiments of the present application or the existing technical solutions, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.
[0023] Figure 1 A flow chart of a settlement data fusion method provided in this application;
[0024] Figure 2 A structural schematic diagram of a settlement data fusion device provided in one embodiment of the present application;
[0025] Figure 3 A schematic diagram of the structure of an electronic device provided in one embodiment of the present application. DETAILED DESCRIPTION
[0026] In order to make the purpose, technical solution and advantages of the present application clearer, the technical solution of the present application will be clearly and completely described below in conjunction with specific embodiments and corresponding drawings. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in the field without creative work are within the scope of protection of the present application.
[0027] Various non-limiting implementations of the present application are described in detail below in conjunction with the accompanying drawings.
[0028] See also Figure 1 , shows a method for fusion of settlement data in an embodiment of the present application. In this embodiment, the method may include the following steps:
[0029] S101: Obtain a first settlement result table in a first time period and a second settlement result table in a second time period.
[0030] There is at least a partial overlap between the first time period and the second time period. For example, the first time period may be from January 2013 to August 2019, and the second time period may be from January 2018 to March 2024.
[0031] The first settlement result table may include multiple settlement information, and the second settlement result table may include at least one settlement information. Each settlement information includes an information identifier, the coordinate information of a monitoring point, and the time-series settlement amount of the monitoring point at each information monitoring time. It should be noted that different monitoring points have unique corresponding information identifiers, that is, the information identifiers corresponding to different monitoring points are also different. The coordinate information of the monitoring point may include the longitude and latitude of the monitoring point. The information monitoring time is the specific time when the time-series settlement amount of the monitoring point is specifically collected, for example, 20130123 (i.e. January 23, 2013). The monitoring points of all settlement information in the first settlement result table and the second settlement result table are located in the same area.
[0032] It should be noted that the information identifiers and the coordinate information of the monitoring points in each settlement information in the first settlement result table are different. The information identifiers and the coordinate information of the monitoring points in each settlement information in the second settlement result table are different. The information identifiers and the coordinate information of the monitoring points in at least part of the settlement information in the first settlement result table are the same as the information identifiers and the coordinate information of the monitoring points in at least part of the settlement information in the second settlement result table.
[0033] In one implementation, the cosmo-skymed satellite data can be used to obtain the first settlement result in the first time period and the second settlement result in the second time period in the same area using SBAS-InSAR technology. The first settlement result in the first time period and the second settlement result in the second time period are both stored in the SHP data format. SBAS-InSAR (Small Baseline Subset Interferometric Synthetic Aperture Radar) is a radar interferometric measurement technology that uses multi-period short baseline radar images to effectively monitor small surface deformations through differential interferometric measurement.
[0034] Then, the first settlement result in the first time period and the second settlement result in the second time period can be imported into the PostgreSQL database to obtain the first settlement result table in the first time period and the second settlement result table in the second time period. PostgreSQL is a powerful open source, object-relational database management system (ORDBMS), known for its reliability, data integrity and rich feature set. It can store and process massive amounts of data and is a very suitable database choice for big data applications.
[0035] For example, you can use cosmo-skymed satellite data and SBAS-InSAR technology to obtain two periods of settlement results for the same area from January 2013 to August 2019 (i.e., the first time period) and from January 2018 to March 2024 (i.e., the second time period) (i.e., the first settlement result in the first time period and the second settlement result in the second time period in the same area). The results (i.e., the first settlement result in the first time period and the second settlement result in the second time period in the same area) are stored in the SHP data format. The SHP data format is a vector data storage format that stores multiple monitoring points obtained by SBAS-InSAR technology. Each point contains values of multiple monitoring dates, and all values are called time series settlement.
[0036] The two-phase results (i.e., the first settlement results in the first time period and the second settlement results in the second time period of the same area) are imported into the PostgreSQL database. The results from January 2013 to August 2019 are stored in Table 1 in the database (i.e., the first settlement results table in the first time period), and the results from January 2018 to March 2024 are stored in Table 2 in the database (i.e., the second settlement results table in the second time period). Tables 1 and 2 are shown below.
[0037] The structure of Table 1 (i.e. the first settlement result table for the first time period) is as follows:
[0038]
[0039] The structure of Table 2 (i.e., the second settlement result table for the second time period) is as follows:
[0040]
[0041] Among them, ID is the unique identification number (information identifier) of the monitoring point in each settlement information, LON is the longitude of each monitoring point, LAT is the latitude of each monitoring point, and the series of numbers such as 20130123 are the time series monitoring dates. Table A has a total of 70 monitoring dates, and Table B has 76 monitoring dates.
[0042] S102: For each piece of settlement information in the second settlement result table, determine a number of target monitoring points in the first settlement result table corresponding to the monitoring points of the settlement information by using the first settlement result table in the first time period and the coordinate information of the monitoring points of the settlement information; perform inverse distance weighted interpolation processing on the monitoring points of the settlement information by using the settlement information respectively corresponding to the several target monitoring points to obtain the settlement information of the monitoring points of the settlement information in the first time period.
[0043] In this embodiment, because the amount of data in the settlement result table that needs to be merged is huge, in order to improve the efficiency of searching and matching, a tree data structure can be constructed for the first settlement result table and the second settlement result table. For example, it can be a KDTREE (K-Dimensional Tree) so that the entire space of the settlement result table can be divided into multiple small parts, thereby speeding up the calculation speed of any monitoring point in one settlement result table to search for several (for example, four) monitoring points with the closest spatial distance in another settlement result table. Subsequently, inverse distance weighted interpolation is performed through these several target points to obtain the settlement information of the monitoring point in another time period.
[0044] Specifically, after the step of obtaining the first settlement result table in the first time period and the second settlement result table in the second time period, the method may further include: using the coordinate information of the monitoring points of the settlement information in the first settlement result table to generate a first tree data structure corresponding to the first settlement result table. In one implementation, the first tree data structure may be a K-dimensional tree; the first tree data structure includes multiple data parts, each data part includes part of the settlement information in the first settlement result table, and the settlement information in each data part is different. It should be noted that the K-dimensional tree is a tree data structure used to store spatial data, which is used to improve the efficiency of spatial range queries and nearest neighbor searches.
[0045] Accordingly, the method of determining the target monitoring points corresponding to the monitoring points of the settlement information in the first settlement result table by using the first settlement result table in the first time period and the coordinate information of the monitoring points of the settlement information can be: using the first tree data structure and the coordinate information of the monitoring points of the settlement information to determine the target monitoring points corresponding to the monitoring points of the settlement information in the first settlement result table; wherein the distance between the monitoring points of the settlement information and the target monitoring points meets the preset distance condition. In one implementation, the first tree data structure and the coordinate information of the monitoring points of the settlement information can be used to determine the preset number of target monitoring points in the first settlement result table that are closest to the monitoring points of the settlement information, for example, determine the four monitoring points in the first settlement result table that are closest to the monitoring points of the settlement information, and use these four monitoring points as target monitoring points. It can be understood that the preset distance condition is the preset number of monitoring points in the first settlement result table that are closest to the monitoring points of the settlement information.
[0046] The method of using the settlement information corresponding to each of the plurality of target monitoring points to perform inverse distance weighted interpolation processing on the monitoring points of the settlement information to obtain the settlement information of the monitoring points of the settlement information in the first time period may include the following steps:
[0047] The settlement information corresponding to each of the several target monitoring points may be used to perform inverse distance weighted interpolation processing on the monitoring points of the settlement information to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the first time period. In one implementation, the following formula may be used to perform inverse distance weighted interpolation processing on the monitoring points of the settlement information based on the settlement information corresponding to each of the several target monitoring points to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the first time period (that is, the inverse distance weighted interpolation formula is):
[0048] ;
[0049] ;
[0050] in, is the time series settlement amount of the monitoring point of the settlement information at an information monitoring time in the first time period; is the longitude of the monitoring point of the settlement information; is the latitude of the monitoring point of the settlement information; n is the number of target monitoring points corresponding to the monitoring point of the settlement information; is the weight coefficient of the i-th target monitoring point at the information monitoring time in the first time period; is the time-series settlement amount of the i-th target monitoring point at the information monitoring time in the first time period; is the longitude of the i-th target monitoring point; is the latitude of the i-th target monitoring point; is the distance from the i-th target monitoring point to the monitoring point of the settlement information.
[0051] For example, read the contents of all monitoring points in Table 2 (i.e., the second settlement result table) in blocks, find the four monitoring point locations closest to the longitude and latitude in Table 2 (i.e., the second settlement result table) through the longitude and latitude of each monitoring point in Table 2 (i.e., the second settlement result table), perform inverse distance weighted interpolation on the longitude and latitude position through the four monitoring points found in Table 1, and obtain the time series settlement monitoring value from January 2013 to August 2019 (i.e., the first time period) at the location. Until the longitude and latitude of all points on B are interpolated by inverse distance weighted interpolation to obtain the time series settlement monitoring value from January 2013 to August 2019 (i.e., the settlement information of the monitoring point of the settlement information in the first time period).
[0052] Then, the settlement information of the monitoring point of the settlement information in the first time period can be generated according to the time-series settlement amount of the monitoring point of the settlement information at each information monitoring time in the first time period, the information identifier of the settlement information and the coordinate information of the monitoring point of the settlement information. That is, the time-series settlement amount of the monitoring point of the settlement information at each information monitoring time in the first time period, the information identifier of the settlement information and the coordinate information of the monitoring point of the settlement information are used as the settlement information of the monitoring point of the settlement information in the first time period.
[0053] S103: Determine a second settlement result table for the first time period according to the settlement information of the monitoring points of all settlement information in the second settlement result table for the first time period.
[0054] That is to say, after obtaining all the settlement information of the monitoring points of all the settlement information in the second settlement result table during the first time period, the settlement information of all the monitoring points of the settlement information in the second settlement result table during the first time period can be used as the second settlement result table during the first time period.
[0055] S104: For each piece of settlement information in the first settlement result table, determine a number of target monitoring points in the second settlement result table corresponding to the monitoring points of the settlement information by using the second settlement result table in the second time period and the coordinate information of the monitoring points of the settlement information; perform inverse distance weighted interpolation processing on the monitoring points of the settlement information by using the settlement information respectively corresponding to the several target monitoring points to obtain the settlement information of the monitoring points of the settlement information in the second time period.
[0056] In this embodiment, because the amount of data in the settlement result table that needs to be merged is huge, in order to improve the efficiency of searching and matching, a tree data structure can be constructed for the first settlement result table and the second settlement result table. For example, it can be a KDTREE (K-Dimensional Tree) so that the entire space of the settlement result table can be divided into multiple small parts, thereby speeding up the calculation speed of any monitoring point in one settlement result table to search for several (for example, four) monitoring points with the closest spatial distance in another settlement result table. Subsequently, inverse distance weighted interpolation is performed through these several target points to obtain the settlement information of the monitoring point in another time period.
[0057] Specifically, after the step of obtaining the first settlement result table in the first time period and the second settlement result table in the second time period, the method further includes: using the coordinate information of the monitoring points of the settlement information in the second settlement result table to generate a second tree data structure corresponding to the second settlement result table. In one implementation, the second tree data structure is a K-dimensional tree; the second tree data structure includes multiple data parts, each of which includes part of the settlement information in the second settlement result table, and the settlement information in each data part is different.
[0058] Accordingly, the method of determining the target monitoring points corresponding to the monitoring points of the settlement information in the second settlement result table by using the second settlement result table in the second time period and the coordinate information of the monitoring points of the settlement information can be: using the second tree data structure and the coordinate information of the monitoring points of the settlement information to determine the target monitoring points corresponding to the monitoring points of the settlement information in the second settlement result table; wherein the distance between the monitoring points of the settlement information and the target monitoring points meets the preset distance condition. In one implementation, the second tree data structure and the coordinate information of the monitoring points of the settlement information can be used to determine the preset number of target monitoring points in the second settlement result table that are closest to the monitoring points of the settlement information, for example, determine the four monitoring points in the second settlement result table that are closest to the monitoring points of the settlement information, and use these four monitoring points as target monitoring points. It can be understood that the preset distance condition is the preset number of monitoring points in the second settlement result table that are closest to the monitoring points of the settlement information.
[0059] The method of using the settlement information corresponding to each of the plurality of target monitoring points to perform inverse distance weighted interpolation processing on the monitoring points of the settlement information to obtain the settlement information of the monitoring points of the settlement information in the second time period may include the following steps:
[0060] The settlement information corresponding to each of the several target monitoring points may be used to perform inverse distance weighted interpolation processing on the monitoring points of the settlement information to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the second time period. In one implementation, the following formula may be used to perform inverse distance weighted interpolation processing on the monitoring points of the settlement information based on the settlement information corresponding to each of the several target monitoring points to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the second time period (that is, the inverse distance weighted interpolation formula is):
[0061] ;
[0062] ;
[0063] in, is the time series settlement amount of the monitoring point of the settlement information at an information monitoring time in the second time period; is the longitude of the monitoring point of the settlement information; is the latitude of the monitoring point of the settlement information; n is the number of target monitoring points corresponding to the monitoring point of the settlement information; is the weight coefficient of the i-th target monitoring point at the information monitoring time in the second time period; is the time series settlement amount of the i-th target monitoring point at the information monitoring time in the second time period; is the longitude of the i-th target monitoring point; is the latitude of the i-th target monitoring point; is the distance from the i-th target monitoring point to the monitoring point of the settlement information.
[0064] Then, the settlement information of the monitoring point of the settlement information in the second time period can be generated according to the time-series settlement amount of the monitoring point of the settlement information at each information monitoring time in the second time period, the information identifier of the settlement information and the coordinate information of the monitoring point of the settlement information. That is, the time-series settlement amount of the monitoring point of the settlement information at each information monitoring time in the second time period, the information identifier of the settlement information and the coordinate information of the monitoring point of the settlement information are used as the settlement information of the monitoring point of the settlement information in the second time period.
[0065] That is to say, through inverse distance weighted interpolation, the longitude and latitude positions of all points in Table 1 (i.e., the first settlement result table) have been interpolated to time-series settlement amounts that are consistent with the longitude and latitude in Table 2 (i.e., the second settlement result table).
[0066] S105: Determine a first settlement result table for the second time period according to the settlement information of the monitoring points of all settlement information in the first settlement result table for the second time period.
[0067] That is to say, after obtaining all the settlement information of the monitoring points of all the settlement information in the first settlement result table during the second time period, the settlement information of all the monitoring points of the settlement information in the first settlement result table during the second time period can be used as the first settlement result table during the second time period.
[0068] S106: Obtain a settlement result table for a target time period according to the first settlement result table for the first time period, the first settlement result table for the second time period, the second settlement result table for the first time period, and the second settlement result table for the second time period. For example, the first time period is from January 2013 to August 2019, the second time period is from January 2018 to March 2024, and the target time period is from January 2013 to March 2024.
[0069] Wherein, the target time period is the splicing time period of the first time period and the second time period. For example, the first settlement result table in the first time period, the first settlement result table in the second time period, the second settlement result table in the first time period and the second settlement result table in the second time period can be spliced by array splicing to obtain the settlement result table in the target time period. Because the first time period and the second time period overlap in time, the positions of the monitoring points in the first settlement result table in the first time period and the second settlement result table in the second time period also overlap partially, so as to merge the first settlement result table in the first time period (for example, January 2013 to August 2019) and the second settlement result table in the second time period (for example, January 2018 to March 2024) into the long-term monitoring results of the target time period (for example, January 2013 to March 2024), and keep the number of monitoring points unchanged. Now, through the method of specific point interpolation, all monitoring points of all monitoring dates in the first settlement result table are interpolated to the corresponding longitude and latitude positions in the second settlement result table, so as to realize the extraction of the time series settlement amount (i.e. settlement information) of the first time period (e.g. January 2013 to January 2018) in the first settlement result table and the time series settlement amount (i.e. settlement information) of the second time period (e.g. January 2018 to March 2024) in the second settlement result table under the same longitude and latitude. Through the array splicing method, the cumulative settlement amount of the ultra-long time series of the target time period (i.e. January 2013 to March 2024) is formed.
[0070] It can be seen from the above technical scheme that the present application provides a settlement data fusion method, which can merge a first settlement result table in a first time period and a second settlement result table in a second time period into a settlement result table in a target time period. At the same time, the number of monitoring points can be kept unchanged, thereby providing more comprehensive and continuous settlement monitoring information. In addition, the present application adopts an inverse distance weighted interpolation method, which can more accurately estimate the settlement information of the monitoring point of the settlement information in other time periods based on the settlement information of several target monitoring points closest to the monitoring point of the settlement information, thereby improving the data fusion precision, data fusion accuracy and data fusion efficiency of the fusion of the settlement result tables.
[0071] That is to say, the present application provides a method for fusion of settlement data, which can merge the first settlement result table under the first time period and the second settlement result table under the second time period into the settlement result table under the target time period, and at the same time, the number of monitoring points can be kept unchanged, thereby providing more comprehensive and continuous settlement monitoring information. The present application uses KDTREE to construct a tree structure for the longitude and latitude of the first settlement result table, which can speed up the operation speed of any point in the second settlement result table to find the four monitoring points with the closest spatial distance in the first settlement result table, improve the efficiency of data search and matching, and have obvious advantages in processing large-scale data. The inverse distance weighted interpolation method is adopted, and the time series settlement monitoring value of the point to be inserted can be more accurately estimated according to the settlement value of the four monitoring points closest to the point to be inserted, thereby improving the accuracy of the settlement monitoring result. Through the method of array splicing, the time series settlement amount in the first time period of the first settlement result table and the time series settlement amount in the second time period of the second settlement result table are composed of the cumulative settlement amount of the super long time series, which provides richer data support for the analysis and research of surface settlement, and helps to better understand the development trend and law of surface settlement.
[0072] like Figure 2 As shown, it is a specific embodiment of a settlement data fusion device described in this application. The device described in this embodiment is a physical device for executing the method described in the above embodiment. Its technical solution is essentially consistent with the above embodiment, and the corresponding description in the above embodiment is also applicable to this embodiment. The device described in this embodiment includes:
[0073] The first unit 201 is used to obtain a first settlement result table in a first time period and a second settlement result table in a second time period; wherein, there is at least a partial overlap between the first time period and the second time period; the first settlement result table includes a plurality of settlement information, and the second settlement result table includes at least one settlement information, each settlement information includes an information identifier, coordinate information of a monitoring point, and time-series settlement amounts of the monitoring point at each information monitoring time;
[0074] The second unit 202 is used to determine, for each settlement information in the second settlement result table, a number of target monitoring points corresponding to the monitoring points of the settlement information in the first settlement result table by using the first settlement result table in the first time period and the coordinate information of the monitoring points of the settlement information; perform inverse distance weighted interpolation processing on the monitoring points of the settlement information by using the settlement information respectively corresponding to the several target monitoring points, so as to obtain the settlement information of the monitoring points of the settlement information in the first time period;
[0075] The third unit 203 is used to determine a second settlement result table in the first time period according to the settlement information of the monitoring points of all settlement information in the second settlement result table in the first time period;
[0076] The fourth unit 204 is used to determine, for each settlement information in the first settlement result table, a number of target monitoring points corresponding to the monitoring points of the settlement information in the second settlement result table by using the second settlement result table in the second time period and the coordinate information of the monitoring points of the settlement information; perform inverse distance weighted interpolation processing on the monitoring points of the settlement information by using the settlement information respectively corresponding to the several target monitoring points, so as to obtain the settlement information of the monitoring points of the settlement information in the second time period;
[0077] A fifth unit 205 is used to determine a first settlement result table in the second time period according to the settlement information of the monitoring points of all settlement information in the first settlement result table in the second time period;
[0078] The sixth unit 206 is used to obtain a settlement result table under a target time period based on the first settlement result table under the first time period, the first settlement result table under the second time period, the second settlement result table under the first time period and the second settlement result table under the second time period; wherein the target time period is the splicing time period of the first time period and the second time period.
[0079] Optionally, the second unit 202 is used to:
[0080] Generate a first tree data structure corresponding to the first settlement result table by using the coordinate information of the monitoring points of the settlement information in the first settlement result table;
[0081] Accordingly, the method of using the first settlement result table in the first time period and the coordinate information of the monitoring points of the settlement information to determine a number of target monitoring points in the first settlement result table corresponding to the monitoring points of the settlement information includes:
[0082] Using the first tree data structure and the coordinate information of the monitoring points of the settlement information, several target monitoring points corresponding to the monitoring points of the settlement information in the first settlement result table are determined; wherein the distance between the monitoring points of the settlement information and the target monitoring points meets a preset distance condition.
[0083] Optionally, the first tree data structure is a K-dimensional tree; the first tree data structure includes multiple data parts, each data part includes part of the settlement information in the first settlement result table, and the settlement information in each data part is different.
[0084] Optionally, the second unit 202 is used to:
[0085] Using the settlement information corresponding to each of the plurality of target monitoring points, inverse distance weighted interpolation processing is performed on the monitoring points of the settlement information to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the first time period;
[0086] The settlement information of the monitoring point of the settlement information in the first time period is generated according to the time-series settlement amount of the monitoring point of the settlement information at each information monitoring time in the first time period, the information identifier of the settlement information and the coordinate information of the monitoring point of the settlement information.
[0087] Optionally, the second unit 202 is used to:
[0088] Using the following formula, based on the settlement information corresponding to each of the several target monitoring points, inverse distance weighted interpolation processing is performed on the monitoring points of the settlement information to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the first time period:
[0089] ;
[0090] ;
[0091] in, is the time series settlement amount of the monitoring point of the settlement information at an information monitoring time in the first time period; is the longitude of the monitoring point of the settlement information; is the latitude of the monitoring point of the settlement information; n is the number of target monitoring points corresponding to the monitoring point of the settlement information; is the weight coefficient of the i-th target monitoring point at the information monitoring time in the first time period; is the time-series settlement amount of the i-th target monitoring point at the information monitoring time in the first time period; is the longitude of the i-th target monitoring point; is the latitude of the i-th target monitoring point; is the distance from the i-th target monitoring point to the monitoring point of the settlement information.
[0092] Optionally, the fourth unit 204 is used to:
[0093] Generate a second tree data structure corresponding to the second settlement result table by using the coordinate information of the monitoring points of the settlement information in the second settlement result table;
[0094] Accordingly, the method of using the second settlement result table in the second time period and the coordinate information of the monitoring points of the settlement information to determine a number of target monitoring points in the second settlement result table corresponding to the monitoring points of the settlement information includes:
[0095] Using the second tree data structure and the coordinate information of the monitoring points of the settlement information, determine several target monitoring points in the second settlement result table corresponding to the monitoring points of the settlement information; wherein the distance between the monitoring points of the settlement information and the target monitoring points meets the preset distance condition.
[0096] Optionally, the second tree data structure is a K-dimensional tree; the second tree data structure includes multiple data parts, each data part includes part of the settlement information in the second settlement result table, and the settlement information in each data part is different.
[0097] Optionally, the fourth unit 204 is used to:
[0098] Using the settlement information respectively corresponding to the plurality of target monitoring points, inverse distance weighted interpolation processing is performed on the monitoring points of the settlement information to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the second time period;
[0099] According to the time-series settlement amount of the monitoring point of the settlement information at each information monitoring time in the second time period, the information identifier of the settlement information and the coordinate information of the monitoring point of the settlement information, the settlement information of the monitoring point of the settlement information in the second time period is generated.
[0100] Optionally, the fourth unit 204 is used to:
[0101] Using the following formula, based on the settlement information corresponding to each of the several target monitoring points, inverse distance weighted interpolation processing is performed on the monitoring points of the settlement information to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the second time period:
[0102] ;
[0103] ;
[0104] in, is the time series settlement amount of the monitoring point of the settlement information at an information monitoring time in the second time period; is the longitude of the monitoring point of the settlement information; is the latitude of the monitoring point of the settlement information; n is the number of target monitoring points corresponding to the monitoring point of the settlement information; is the weight coefficient of the i-th target monitoring point at the information monitoring time in the second time period; is the time series settlement amount of the i-th target monitoring point at the information monitoring time in the second time period; is the longitude of the i-th target monitoring point; is the latitude of the i-th target monitoring point; is the distance from the i-th target monitoring point to the monitoring point of the settlement information.
[0105] Optionally, the information identifier and the coordinate information of the monitoring point in each settlement information in the first settlement result table are different, the information identifier and the coordinate information of the monitoring point in each settlement information in the second settlement result table are different, and the information identifier and the coordinate information of the monitoring point in at least part of the settlement information in the first settlement result table are the same as the information identifier and the coordinate information of the monitoring point in at least part of the settlement information in the second settlement result table.
[0106] Optionally, the first unit 201 is used for:
[0107] Using cosmo-skymed satellite data, SBAS-InSAR technology is used to obtain a first sedimentation result in a first time period and a second sedimentation result in a second time period in the same area; wherein the first sedimentation result in the first time period and the second sedimentation result in the second time period are both stored in the SHP data format;
[0108] The first sedimentation result in the first time period and the second sedimentation result in the second time period are both imported into the PostgreSQL database to obtain a first sedimentation result table in the first time period and a second sedimentation result table in the second time period.
[0109] It can be seen from the above technical solution that the device provided by the present application can merge the first settlement result table in the first time period and the second settlement result table in the second time period into the settlement result table in the target time period. At the same time, the number of monitoring points can be kept unchanged, thereby providing more comprehensive and continuous settlement monitoring information. In addition, the present application adopts an inverse distance weighted interpolation method, which can more accurately estimate the settlement information of the monitoring point of the settlement information in other time periods based on the settlement information of several target monitoring points closest to the monitoring point of the settlement information, thereby improving the data fusion precision, data fusion accuracy and data fusion efficiency of the fusion of the settlement result tables.
[0110] Figure 3It is a structural diagram of an electronic device provided in an embodiment of the present application. At the hardware level, the electronic device includes a processor, and optionally also includes an internal bus, a network interface, and a memory. Among them, the memory may include a memory, such as a high-speed random access memory (Random-Access Memory, RAM), and may also include a non-volatile memory (non-volatile memory), such as at least one disk storage, etc. Of course, the electronic device may also include hardware required for other services.
[0111] The processor, network interface and memory can be interconnected through an internal bus, which can be an ISA (Industry Standard Architecture) bus, a PCI (Peripheral Component Interconnect) bus or an EISA (Extended Industry Standard Architecture) bus. The bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 3 Only one bidirectional arrow is used in the diagram, but this does not mean that there is only one bus or only one type of bus.
[0112] The memory is used to store execution instructions. Specifically, the execution instructions are computer programs that can be executed. The memory may include internal memory and non-volatile memory, and provides execution instructions and data to the processor.
[0113] In one possible implementation, the processor reads the corresponding execution instructions from the non-volatile memory into the memory and then runs them, and can also obtain the corresponding execution instructions from other devices to form a settlement data fusion device at the logical level. The processor executes the execution instructions stored in the memory to implement the settlement data fusion method provided in any embodiment of the present application through the executed execution instructions.
[0114] The above application Figure 1The method performed by the settlement data fusion device provided in the illustrated embodiment can be applied to a processor or implemented by a processor. The processor may be an integrated circuit chip with signal processing capabilities. In the implementation process, each step of the above method can be completed by an integrated logic circuit of hardware in the processor or an instruction in the form of software. The above processor may be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it may also be a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components. The various methods, steps and logic block diagrams disclosed in the embodiments of the present application can be implemented or executed. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc.
[0115] The steps of the method disclosed in the embodiments of the present application can be directly embodied as being executed by a hardware decoding processor, or can be executed by a combination of hardware and software modules in the decoding processor. The software module can be located in a storage medium mature in the art such as a random access memory, a flash memory, a read-only memory, a programmable read-only memory, or an electrically erasable programmable memory, a register, etc. The storage medium is located in a memory, and the processor reads the information in the memory and completes the steps of the above method in combination with its hardware.
[0116] An embodiment of the present application also proposes a readable storage medium, which stores execution instructions. When the stored execution instructions are executed by a processor of an electronic device, the electronic device can execute the settlement data fusion method provided in any embodiment of the present application, and is specifically used to execute the above-mentioned settlement data fusion method.
[0117] The electronic device described in the above embodiments may be a computer.
[0118] Those skilled in the art should understand that the embodiments of the present application can be provided as methods or computer program products. Therefore, the present application can adopt a complete hardware embodiment, a complete software embodiment, or a combination of software and hardware.
[0119] Each embodiment in this application is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.
[0120] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.
[0121] The above is only an embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims
1. A method for fusion of sedimentation data, characterized in that: The method comprises: Obtain a first settlement result table in a first time period and a second settlement result table in a second time period; wherein, at least a portion of the time periods overlap between the first time period and the second time period; the first settlement result table includes a plurality of settlement information, and the second settlement result table includes at least one settlement information, each settlement information includes an information identifier, coordinate information of a monitoring point, and time-series settlement amounts of the monitoring point at each information monitoring time; For each settlement information in the second settlement result table, using the first settlement result table in the first time period and the coordinate information of the monitoring point of the settlement information, determine a number of target monitoring points in the first settlement result table corresponding to the monitoring point of the settlement information; using the settlement information respectively corresponding to the several target monitoring points, perform inverse distance weighted interpolation processing on the monitoring point of the settlement information to obtain the settlement information of the monitoring point of the settlement information in the first time period; Determine a second settlement result table for the first time period according to the settlement information of the monitoring points of all settlement information in the second settlement result table for the first time period; For each settlement information in the first settlement result table, using the second settlement result table in the second time period and the coordinate information of the monitoring point of the settlement information, determine a number of target monitoring points in the second settlement result table corresponding to the monitoring point of the settlement information; using the settlement information respectively corresponding to the several target monitoring points, perform inverse distance weighted interpolation processing on the monitoring point of the settlement information to obtain the settlement information of the monitoring point of the settlement information in the second time period; Determine the first settlement result table for the second time period according to the settlement information of the monitoring points of all settlement information in the first settlement result table for the second time period; According to the first settlement result table under the first time period, the first settlement result table under the second time period, the second settlement result table under the first time period and the second settlement result table under the second time period, a settlement result table under the target time period is obtained; wherein the target time period is the splicing time period of the first time period and the second time period.
2. The method according to claim 1, characterized in that After the step of obtaining a first settling result table in a first time period and a second settling result table in a second time period, the method further includes: Generate a first tree data structure corresponding to the first settlement result table by using the coordinate information of the monitoring points of the settlement information in the first settlement result table; Accordingly, the method of using the first settlement result table in the first time period and the coordinate information of the monitoring points of the settlement information to determine a number of target monitoring points in the first settlement result table corresponding to the monitoring points of the settlement information includes: Using the first tree data structure and the coordinate information of the monitoring points of the settlement information, several target monitoring points corresponding to the monitoring points of the settlement information in the first settlement result table are determined; wherein the distance between the monitoring points of the settlement information and the target monitoring points meets a preset distance condition.
3. The method according to claim 2, characterized in that The first tree data structure is a K-dimensional tree; the first tree data structure includes multiple data parts, each data part includes part of the settlement information in the first settlement result table, and the settlement information in each data part is different.
4. The method according to claim 1, characterized in that: The using the settlement information respectively corresponding to the plurality of target monitoring points to perform inverse distance weighted interpolation processing on the monitoring points of the settlement information to obtain the settlement information of the monitoring points of the settlement information in the first time period includes: Using the settlement information respectively corresponding to the plurality of target monitoring points, inverse distance weighted interpolation processing is performed on the monitoring points of the settlement information to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the first time period; The settlement information of the monitoring point of the settlement information in the first time period is generated according to the time-series settlement amount of the monitoring point of the settlement information at each information monitoring time in the first time period, the information identifier of the settlement information and the coordinate information of the monitoring point of the settlement information.
5. The method according to claim 4, characterized in that The method of using the settlement information corresponding to each of the plurality of target monitoring points to perform inverse distance weighted interpolation processing on the monitoring points of the settlement information to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the first time period includes: Using the following formula, based on the settlement information corresponding to each of the several target monitoring points, inverse distance weighted interpolation processing is performed on the monitoring points of the settlement information to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the first time period: ; ; in, is the time series settlement amount of the monitoring point of the settlement information at an information monitoring time in the first time period; is the longitude of the monitoring point of the settlement information; is the latitude of the monitoring point of the settlement information; n is the number of target monitoring points corresponding to the monitoring point of the settlement information; is the weight coefficient of the i-th target monitoring point at the information monitoring time in the first time period; is the time-series settlement amount of the i-th target monitoring point at the information monitoring time in the first time period; is the longitude of the i-th target monitoring point; is the latitude of the i-th target monitoring point; is the distance from the i-th target monitoring point to the monitoring point of the settlement information.
6. The method according to claim 1, characterized in that After the step of obtaining a first settling result table in a first time period and a second settling result table in a second time period, the method further includes: Generate a second tree data structure corresponding to the second settlement result table by using the coordinate information of the monitoring points of the settlement information in the second settlement result table; Accordingly, the method of using the second settlement result table in the second time period and the coordinate information of the monitoring points of the settlement information to determine a number of target monitoring points in the second settlement result table corresponding to the monitoring points of the settlement information includes: Using the second tree data structure and the coordinate information of the monitoring points of the settlement information, determine several target monitoring points in the second settlement result table corresponding to the monitoring points of the settlement information; wherein the distance between the monitoring points of the settlement information and the target monitoring points meets the preset distance condition.
7. The method according to claim 6, characterized in that The second tree data structure is a K-dimensional tree; the second tree data structure includes multiple data parts, each data part includes part of the settlement information in the second settlement result table, and the settlement information in each data part is different.
8. The method according to claim 1, characterized in that The using the settlement information respectively corresponding to the plurality of target monitoring points to perform inverse distance weighted interpolation processing on the monitoring points of the settlement information to obtain the settlement information of the monitoring points of the settlement information in the second time period includes: Using the settlement information corresponding to each of the plurality of target monitoring points, inverse distance weighted interpolation processing is performed on the monitoring points of the settlement information to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the second time period; According to the time-series settlement amount of the monitoring point of the settlement information at each information monitoring time in the second time period, the information identifier of the settlement information and the coordinate information of the monitoring point of the settlement information, the settlement information of the monitoring point of the settlement information in the second time period is generated.
9. The method according to claim 8, characterized in that The method of using the settlement information corresponding to each of the plurality of target monitoring points to perform inverse distance weighted interpolation processing on the monitoring points of the settlement information to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the second time period includes: Using the following formula, based on the settlement information corresponding to each of the several target monitoring points, inverse distance weighted interpolation processing is performed on the monitoring points of the settlement information to obtain the time series settlement amount of the monitoring points of the settlement information at each information monitoring time in the second time period: ; ; in, is the time series settlement amount of the monitoring point of the settlement information at an information monitoring time in the second time period; is the longitude of the monitoring point of the settlement information; is the latitude of the monitoring point of the settlement information; n is the number of target monitoring points corresponding to the monitoring point of the settlement information; is the weight coefficient of the i-th target monitoring point at the information monitoring time in the second time period; is the time series settlement amount of the i-th target monitoring point at the information monitoring time in the second time period; is the longitude of the i-th target monitoring point; is the latitude of the i-th target monitoring point; is the distance from the i-th target monitoring point to the monitoring point of the settlement information.
10. The method according to claim 1, characterized in that The information identifiers and the coordinate information of the monitoring points in each piece of settlement information in the first settlement result table are different, and the information identifiers and the coordinate information of the monitoring points in each piece of settlement information in the second settlement result table are different. The information identifiers and the coordinate information of the monitoring points in at least some of the settlement information in the first settlement result table are the same as the information identifiers and the coordinate information of the monitoring points in at least some of the settlement information in the second settlement result table.
11. The method according to claim 1, characterized in that The obtaining of a first settlement result table in a first time period and a second settlement result table in a second time period comprises: Using cosmo-skymed satellite data, SBAS-InSAR technology is used to obtain a first sedimentation result in a first time period and a second sedimentation result in a second time period in the same area; wherein the first sedimentation result in the first time period and the second sedimentation result in the second time period are both stored in the SHP data format; The first sedimentation result in the first time period and the second sedimentation result in the second time period are both imported into the PostgreSQL database to obtain a first sedimentation result table in the first time period and a second sedimentation result table in the second time period.
12. A sedimentation data fusion device, characterized in that: The device comprises: The first unit is used to obtain a first settlement result table in a first time period and a second settlement result table in a second time period; wherein, there is at least a partial overlap between the first time period and the second time period; the first settlement result table includes a plurality of settlement information, and the second settlement result table includes at least one settlement information, each settlement information includes an information identifier, coordinate information of a monitoring point, and time-series settlement amounts of the monitoring point at each information monitoring time; The second unit is used to determine, for each settlement information in the second settlement result table, a number of target monitoring points corresponding to the monitoring points of the settlement information in the first settlement result table by using the first settlement result table in the first time period and the coordinate information of the monitoring points of the settlement information; and to perform inverse distance weighted interpolation processing on the monitoring points of the settlement information by using the settlement information respectively corresponding to the several target monitoring points to obtain the settlement information of the monitoring points of the settlement information in the first time period; A third unit is used to determine a second settlement result table in the first time period according to the settlement information of the monitoring points of all settlement information in the second settlement result table in the first time period; The fourth unit is used to determine, for each settlement information in the first settlement result table, a number of target monitoring points corresponding to the monitoring points of the settlement information in the second settlement result table by using the second settlement result table in the second time period and the coordinate information of the monitoring points of the settlement information; perform inverse distance weighted interpolation processing on the monitoring points of the settlement information by using the settlement information respectively corresponding to the several target monitoring points, so as to obtain the settlement information of the monitoring points of the settlement information in the second time period; A fifth unit is used to determine the first settlement result table in the second time period according to the settlement information of the monitoring points of all settlement information in the first settlement result table in the second time period; The sixth unit is used to obtain a settlement result table under a target time period based on the first settlement result table under the first time period, the first settlement result table under the second time period, the second settlement result table under the first time period and the second settlement result table under the second time period; wherein the target time period is the splicing time period of the first time period and the second time period.
