A method for automatically updating attributes of single buildings based on multi-source data

Abstract

The application discloses a kind of based on multi-source data's single building attribute automatic updating method, including single building height attribute updating method and single building other attribute updating method;In height attribute updating process, projection conversion is carried out to single and target layer, format standardization is carried out and is superimposed, and overlapping information is recorded;With single building ID as index, eliminate non-overlapping map spot, find the target map spot of the largest overlapping proportion, according to independent, add calculation space in the case of containing body or body;Height calculation is carried out to the map spot in calculation space, according to type selection method, finally select the highest value as result;In other attribute updating process, according to map spot quantity and type, according to different assignment strategy calculation.The application adopts the above steps a kind of based on multi-source data's single building attribute automatic updating method, and multi-source, multi-period data attribute is fused and updated to single building data, to enhance the comprehensiveness and accuracy of data, improve the efficiency of data updating.

Description

TECHNICAL FIELD

[0001] The present application relates to the field of computer information technology, in particular to a single building attribute automatic updating method based on multi-source data. BACKGROUND

[0002] Single building refers to a building unit with independent function and physical boundary, including various types such as residential buildings, commercial buildings and office buildings. Monitoring single buildings can provide fine data support for land space planning, improve the accuracy and efficiency of urban management, and benefit city health examination, illegal construction rectification and rational allocation of resources. In this context, in order to implement the policy of coordinated development of population, land and housing, detailed monitoring and dynamic updating of single buildings are carried out to obtain comprehensive, accurate and timely single building data, which can better serve land space planning.

[0003] However, the current single building data still has some defects: (1) incomplete height attribute, only the number of floors collected by field personnel, which cannot accurately represent the actual height of the building, and the number of floors collected by field personnel is limited by the observation angle of the collector, which may lead to misjudgment of the floor information; (2) insufficient attribute abundance, single building data lacks some important attributes related to social livelihood, such as text information of building function, and numerical information such as number of commercial housing and affordable housing; (3) insufficient dynamic updating: single building attribute updating relies on local municipal government's annual city monitoring project, which makes it difficult to reflect the latest status of the building in a timely manner, affecting the timeliness of urban planning and management.

[0004] How to improve the attribute abundance and update frequency of single building data has become a difficult problem to be solved in the housing single building monitoring project. SUMMARY

[0005] The purpose of the present application is to provide a single building attribute automatic updating method based on multi-source data, which integrates and updates the data attributes of multi-source and multi-period into single building data to enhance the comprehensiveness and accuracy of the data and improve the efficiency of data updating.

[0006] To achieve the above purpose, the present application provides a single building attribute automatic updating method based on multi-source data, which can be derived from multi-source third-party data such as point of interest data, new basic surveying and mapping data, and housing and construction commission data. Open source geographic data processing packages such as GDAL, GeoPandas, Numpy and Pandas are used, Python is used as the basic language, and a single building attribute updating algorithm based on multi-source data is constructed, as shown in Figure 1 which specifically includes a single building height attribute updating method and a single building other attribute updating method;

[0007] The steps of the height attribute updating method are as follows:

[0008] S1.1, projection conversion, format standardization and superposition are performed on the individual and target layers, and overlapping information is recorded;

[0009] S1.2, taking the individual building ID as the index, the non-overlapping polygons are removed, the target polygon with the largest overlapping ratio is found, and the calculation space is added according to the independent, containing sub-body or sub-body conditions;

[0010] S1.3, height calculation is performed on the polygons in the calculation space, the highest value is finally selected as the result according to the type selection method, and the results of flat roof and non-flat roof are preferentially considered;

[0011] The steps of the other attribute updating method are as follows:

[0012] S2.1, the attributes of the individual building and the target building are extracted into a list, the numerical attributes are standardized, and then the overlapping unique sequence is obtained after de-duplication;

[0013] S2.2, taking the de-duplicated ID as the index, the original overlapping sequence list is traversed by slicing, and each slice is reconstructed to ensure that all associated polygons are included;

[0014] S2.3, according to the number relationship of ID and target ID in the table, the one-to-one, one-to-many, many-to-one and many-to-many assignment strategies are executed.

[0015] Preferably, S1.1 specifically includes:

[0016] 1) using GeoPandas to read vector polygons from the database and converting them into an attribute list,

[0017] The individual building polygon (Individual Building Units) is read as IBU=[ID,UP_FLOOR S,COR], wherein ID is a unique code, UP_FLOORS is the number of floors, and COR is the coordinate system;

[0018] The height target (TargetUnits) reads as TU=[FGUID, ELEVATION_MAX, ELEVATION_EAVE, ELEVATION_FLOOR, WDLX, DTCODE, COR], wherein FGUID is a surveying identification code, ELEVATION_MAX, ELEVATION_EAVE and ELEVATION_FLOOR respectively represent the elevations of the highest point, eave and downspout of the building, WDLX is a roof type, including “flat roof building” and “non-flat roof building”, DTCODE is a building type identification code, divided into “single house” and “split house [FGUID]”, and the split house [FGUID] indicates that the plot is a split house and belongs to a single building with an identification code FGUID;

[0019] 2) unify the coordinate attribute COR in IBU and TU into CGCS2000 (EPSG:4490), and then superimpose each other to calculate the overlapping area OVERLAP_AREA.

[0020] Preferably, S1.2 specifically comprises:

[0021] 1) under the premise that all attributes are not empty, eliminate the non-overlapping elements and the edge-eliminating target building plot with an overlapping area less than 1 square meter, and then sort the single building ID to construct an overlapping sequence list IBU_TU=[IDUP_FLOORS, FGUID, ELEVATION_MAX, ELEVATION_EAVE, ELEVATION_FLOOR, WDLX, DTCODE, OVERLAP_AREA, COR];

[0022] 2) extract the single building ID column in IBU_TU and perform a de-duplication process to obtain a unique sequence list UN_ID of all single building IDs with overlapping phenomena, and slice and traverse the original sequence list IBU_TU with the values in UN_ID as the index, and each slice is named IBU_TU_ID=[...], wherein the slice is all rows with the same single building ID obtained from the original sequence list, and each iteration is a single building and all target building plots overlapping with the single building which need to be assigned a height;

[0023] 3) according to the OVERLAP_AREA attribute value of IBU_TU_ID, calculate the overlapping percentage of all target plots in the slice, select the target plot with the largest overlapping percentage and mark it as MAX_OVERLAP, and retrieve the DTCODE attribute of the target plot with the largest overlapping percentage to obtain complete building information;

[0024] If DTCODE is a single house, according to the FGUID attribute of MAX_OVERLAP, retrieve and obtain all rows containing this FGUID attribute in the original table TU, to find all sub-houses contained in this single house, and then build a new empty table COM_TABLE to copy all attribute values of all sub-houses found into the empty table;

[0025] If DTCODE is a sub-house [FGUID], according to the FGUID value, retrieve and obtain the equal row of this FGUID value in the original table TU, to find the single house to which this sub-house [FGUID] belongs, and then find other sub-houses carried by this single house according to the steps of DTCODE being a single house, and finally all are added to COM_TABLE.

[0026] Preferably, S1.3 specifically includes:

[0027] 1) Read each row in COM_TABLE, according to the attribute of WDLX, execute different building height calculation methods to obtain the height value HIGH, and record to the temporary table T_HIGH=[...]:

[0028] If it is a "flat roof building", the height value HIGH=ELEVATION_MAX-ELEVATION_FLOOR;

[0029] If it is a "non-flat roof building", the height value HIGH=(ELEVATION_MAX-ELEVATION_EAVE) / 2+(ELEVATION_EAVE-ELEVATION_FLOOR);

[0030] 2) Read the temporary table T_HIGH and select the maximum value as the height value of the current single building ID;

[0031] 3) If T_HIGH is empty, indicating that the ELEVATION series height attribute of the overlapping target building has a null value, then use the UP_FLOORS attribute value of the single building plot multiplied by the preset floor height FLOOR_high as the height value of the current single building ID;

[0032] 4) Traverse all IDs in the unique sequence table UN_ID to complete the single building height attribute assignment.

[0033] Preferably, S2.1 specifically includes:

[0034] 1) Use GeoPandas to read vector plots from the database and convert them to an attribute list,

[0035] The individual building patch is read as IBU=[ID,FINALST,COR], where ID is a unique code, FINALST is the final above-ground scale of the individual building, and COR is the coordinate system;

[0036] Other numerical target building units (TargetUnits) are read as TU = [TID, SETS_NUM, SETS_STR, COR], where TID is the ID of the target building unit, SETS_NUM is the numerical attribute of the target building unit, and SETS_STR is the text attribute;

[0037] 2) Unify the coordinate attribute COR in IBU and TU to CGCS2000 (EPSG:4490), standardize the numerical attributes of TU, ​​remove null, error and "" and other non-specific numerical values ​​in the table, convert strings containing numerical values ​​such as "100" and '100 to standard numerical values ​​under NumPy type, and unify all numerical formats to floating point type and retain two decimal places;

[0038] 3) Overlay IBU and TU to calculate the overlap area. Under the premise that all attributes are not empty, remove non-overlapping elements and target building patches with an overlap area of ​​less than 1 square meter. Then sort them by the individual building ID and construct the overlap sequence table IBU_TU=[ID,TID,SETS_NUM,SETS_STR,COR];

[0039] 4) Extract the individual building ID column from IBU_TU and perform deduplication to obtain a unique sequence table UN_ID of all individual building IDs that have overlap.

[0040] Preferably, S2.2 specifically includes:

[0041] 1) Use the value in UN_ID as an index to slice and traverse the original sequence list IBU_TU, and name each slice IBU_TU_ID = [...].

[0042] 2) Based on the ID and TID values ​​of IBU_TU_ID, retrieve other associated polygons from the overlap sequence table IBU_TU, construct a new empty table COM_TABLE, and copy the information of all associated polygons into COM_TABLE. For example, if a single building polygon A overlaps with a target building polygon B, IBU_TU_ID should only contain information about polygons A and B. However, if the target building polygon B also overlaps with single building polygons C and D, in order to ensure global numerical consistency, construct a new empty table COM_TABLE and copy the information of polygons A, B, C, and D together into COM_TABLE.

[0043] Preferably, S2.3 specifically includes: executing different assignment strategies based on the number of IDs and TIDs in the COM_TABLE.

[0044] 1) If the number of ID and TID is both 1, the assignment strategy is one-to-one, and the numerical attribute SETS_NUM and text attribute SETS_STR of the target building patch are directly assigned to the current single building ID.

[0045] 2) If the number of IDs is 1 and the number of TIDs is greater than 1, the assignment strategy is one-to-many. The numerical attribute SETS_NUM of multiple target building patches is added together and then assigned to the current single building ID. There are two ways to assign the text attribute of the single building ID: one is to select the SETS_STR attribute of the target building patch with the largest overlapping area as the unique value, and the other is to deduplicate the SETS_STR attribute in the entire COM_TABLE, concatenate the non-repeating SETS_STR attributes with "," and retain the most complete text attribute.

[0046] 3) If the number of IDs is greater than 1 and the number of TIDs is equal to 1, the assignment strategy is many-to-one, requiring simultaneous assignment to multiple individual buildings. The numerical attribute value SETS_NUM assigned to each individual building ID is the proportion of the final ground scale FINALST_ID of the current individual building ID overlap to the total overlapping ground scale SUM(FINALST_ID) OVERLAP_PRC_ID; the text attribute of this individual building ID is assigned equal to the text attribute SETS_STR of the target building patch;

[0047] 4) If the number of IDs is greater than 1 and the number of TIDs is also greater than 1, the assignment strategy is many-to-many. The many-to-many case needs to be split into multiple many-to-one cases to avoid duplicate assignments. Based on a TID, the entire COM_TABLE is divided into multiple many-to-one tables, and then processed according to the many-to-one assignment strategy. If, after the calculation, a single building is assigned to multiple target buildings, it is converted into a one-to-many form for assignment. Specifically, first, the SETS_NUM is obtained according to the many-to-one assignment strategy. SET S_NUM is the proportion of the final ground scale FINALST_ID of the current single building ID overlap to the total overlapping ground scale SUM(FINALST_ID) OVERLAP_PRC_ID. Then, the numerical attributes SETS_NUM of multiple target building patches are added according to the one-to-many strategy and assigned to the current single building ID.

[0048] Therefore, this invention employs a method for automatically updating the attributes of individual buildings based on multi-source data, as described above. By constructing an algorithm for updating the attributes of individual buildings based on multi-source data, it integrates and updates data attributes from multiple sources and time periods into the individual building data, thereby improving the comprehensiveness and accuracy of the data. Through automated data matching and fusion technology, combined with dynamic monitoring methods, it achieves real-time updates of key attributes such as building function, height, and use, ensuring that the frequency and quality of data updates meet the needs of urban management and planning. Ultimately, it constructs a comprehensive and timely individual building data system, providing strong support for refined urban management, resource allocation, and policy formulation.

[0049] The technical solution of the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. Attached Figure Description

[0050] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0051] Figure 1 This is a flowchart of a method for automatically updating the attributes of a single building based on multi-source data according to the present invention.

[0052] Figure 2 This is a data map of a single building in a certain region, according to an embodiment of the present invention.

[0053] Figure 3 This is an example diagram illustrating attribute update overlap in an embodiment of the present invention;

[0054] Figure 4 This is a schematic diagram of the software interface for updating the height and other attributes of a single building according to an embodiment of the present invention.

[0055] Figure 5 This is an example diagram showing the height attribute update result of an embodiment of the present invention;

[0056] Figure 6 The following is an example diagram showing other attribute update results in an embodiment of the present invention. Detailed Implementation

[0057] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0058] To make the above-mentioned objects, features and advantages of the present invention more apparent and understandable, the present invention will be further described in detail below with reference to the accompanying drawings and specific embodiments.

[0059] Example

[0060] To verify the efficiency of this method, we compared the multi-source data update method proposed in this application with the traditional manual patch-by-patch update method. The experimental data used were individual building data of a certain region (approximately 15M, 38,000 building patches, such as...). Figure 2 Blue patches), high-altitude target building patches (approximately 20 meters, 49,000 building patches, such as...) Figure 2 The green patch on the left) updates the target building patch (approximately 5M, 13000 building patches) with other attributes, such as... Figure 2 (Right red patch), all coordinate systems are CGCS2000.

[0061] The attribute update involves some overlapping patches, as shown in Figure 3. Figure 3 The number 1 in the figure illustrates the relationship between single-unit and multi-unit buildings in the height attribute update. Single-unit buildings are the main body of the building, while multi-unit buildings are auxiliary buildings, such as annex buildings. Figure 3 The number 2 represents a one-to-one situation in other attribute updates, where the individual building (blue patch) and the target building (red patch) are perfectly matched in topology. Figure 3 The case of 3 represents a many-to-one relationship, meaning that a target building patch contains multiple individual building patches. Figure 3 The number 4 represents a one-to-many situation, meaning that a single building feature contains multiple target building features. Figure 3 The number 5 represents a many-to-many situation, indicating that multiple individual building patches overlap with multiple target building patches.

[0062] Based on the methods for updating the height and other attributes of individual buildings proposed in this application, two independent calculation levels are designed, and their operation interfaces are as follows: Figure 4 As shown in the diagram, users only need to enter the data path in the interface and click "Calculate." All output data is in a uniform format, and any alarms or error messages during the calculation process will be directly displayed on the interface. Traditional methods require overlaying individual building layers and target building layers using ArcGIS software, manually determining the type of each overlapping building, and then performing tabular calculations. This repetitive and tedious operation greatly increases complexity, time cost, and error rate. Compared to the traditional manual patch-by-patch processing method, this method significantly simplifies the operation process.

[0063] The efficiency of the method in this application is compared with that of the traditional manual patch-by-patch update method, and the results are shown in Table 1. It can be seen that the single-building attribute update technology based on multi-source data improves the efficiency of height update by more than 1000 times, and the efficiency of other attribute updates by more than 2500 times.

[0064] Table 1. Efficiency Comparison of the Method in this Application and the Traditional Manual Patch-by-Patch Update Method

[0065] Inspection method Automatic update technique based on multi-source data Traditional manual update High update 40 seconds 12 hours Other attribute update 10 seconds 7 hours

[0066] Figure 5 The table displays a partial result of the height update, including the target building ID, individual building ID, overlap sequence (a string consisting of multiple target building IDs that overlap with this individual building), overlap area, number of overlaps, height source building ID (the source of the final height attribute value), height calculation method, and estimated building height. Figure 6 The table displays partial results of other attribute updates, including numerical results such as individual building ID, target building ID, and number of housing units, as well as textual results such as housing type and calculation methods.

[0067] The remaining technical features in the above embodiments can be flexibly selected by those skilled in the art to meet different specific practical needs. However, it is obvious to those skilled in the art that these specific details are not necessary to implement the present invention. In other instances, to avoid obscuring the present invention, well-known components, structures, or parts are not specifically described, and all are within the scope of technical protection defined by the claims of the present invention.

[0068] Modifications and variations made by those skilled in the art that do not depart from the spirit and scope of this invention should be within the protection scope of the appended claims. In the above description, numerous specific details have been set forth to provide a thorough understanding of the invention. However, it will be apparent to those skilled in the art that these specific details are not necessary to practice the invention. In other instances, to avoid obscuring the invention, well-known techniques, such as specific construction details, operating conditions, and other technical conditions, have not been specifically described.

[0069] This document uses specific examples to illustrate the principles and implementation methods of the present invention. The descriptions of the above embodiments are only for the purpose of helping to understand the method and core ideas of the present invention. Furthermore, those skilled in the art will recognize that, based on the ideas of the present invention, there will be changes in the specific implementation methods and application scope. Therefore, the content of this specification should not be construed as a limitation of the present invention.

Claims

1. A method for automatically updating the attributes of a single building based on multi-source data, characterized in that, This includes methods for updating the height attribute of individual buildings and methods for updating other attributes of individual buildings; The steps for updating the height attribute are as follows: S1.1 Perform projection transformation, format standardization, and overlay on the individual units and target layers, and record the overlap information; S1.

2. Using the ID of a single building as an index, remove non-overlapping polygons, find the target polygon with the largest overlap ratio, and add it to the calculation space according to whether it is independent, contains split parts, or is split. S1.3 Calculate the height of the map pieces in the computational space. First, select the appropriate height calculation method according to the building type corresponding to the map piece. Then, summarize and compare the calculation results of all building types. Finally, select the highest value as the building height result of the computational space. The steps for updating other attributes are as follows: S2.1 Extract the attributes of individual buildings and target buildings into a list, standardize the numerical attributes, and then stack them to remove duplicates, obtaining a unique sequence of all overlapping elements. S2.2 Using the deduplicated ID as the index, perform a slice traversal on the original overlapping sequence list, reconstruct each slice, and ensure that all associated polygons are included. S2.

3. Based on the quantity relationship between ID and target ID in the table, execute one-to-one, one-to-many, many-to-one, and many-to-many assignment strategies.

2. The method for automatically updating the attributes of a single building based on multi-source data according to claim 1, characterized in that: S1.1 specifically includes: 1) Use GeoPandas to read vector graphics from the database and convert them into a list of attributes. The map of a single building is read as IBU = [ID, UP_FLOORS, COR], where ID is a unique code, UP_FLOORS is the number of floors, and COR is the coordinate system; The height target is read as TU = [FGUID, ELEVATION_MAX, ELEVATION_EAVE, ELEVATION_FLOOR, WDLX, DTCODE, COR], where FGUID is the surveying identification code, ELEVATION_MAX, ELEVATION_EAVE, and ELEVATION_FLOOR represent the elevation of the highest point, eaves, and drainage of the building, respectively, WDLX is the roof type, including "flat roof building" and "non-flat roof building", and DTCODE is the building type identification code, which is divided into two categories: "single house" and "split house [FGUID]". Split house [FGUID] indicates that the patch is a split house and belongs to the single building with the identification code FGUID; 2) Unify the coordinate attribute COR in IBU and TU to CGCS2000, then superimpose them and calculate the overlapping area OVERLAP_AREA.

3. The method for automatically updating the attributes of a single building based on multi-source data according to claim 1, characterized in that: S1.2 specifically includes: 1) Under the premise that all attributes are not empty, remove non-overlapping elements and target building patches with overlapping areas of less than 1 square meter, and then sort them by individual building ID to construct an overlapping sequence table IBU_TU=[IDUP_FLOORS,FGUID,ELEVATION_MAX,ELEVATION_EAVE,ELEVATION_FLOOR,WDLX,DTCODE,OVERLAP_AREA,COR]; 2) Extract the individual building ID column from IBU_TU and perform deduplication to obtain a unique sequence table UN_ID of all overlapping individual building IDs. Use the values ​​in UN_ID as indexes to slice and traverse the original sequence table IBU_TU. Each slice is named IBU_TU_ID = [...]. The slice is obtained from all rows with the same individual building ID from the original sequence table, ensuring that each iteration is a single building that needs to be assigned a height and all its overlapping target building patches. 3) Based on the OVERLAP_AREA attribute value of IBU_TU_ID, calculate the overlap percentage of all target patches in the slice, select the target patch with the largest overlap percentage and mark it as MAX_OVE RLAP, retrieve the DTCODE attribute of the target patch with the largest overlap percentage, and obtain complete building information; If the DTCODE is a single house, retrieve all rows in the original table TU that contain the FGUID attribute of the MAX_OVERLAP, thereby finding all the sub-houses contained in this single house. Then, construct a new empty table COM_TABLE and copy all the attribute values ​​of all the sub-houses found into the empty table. If DTCODE is a split house [FGUID], based on the FGUID value, search the original table TU and obtain the row with the same FGUID value to find the single house to which this split house [FGUID] belongs. Then, follow the steps for DTCODE being a single house to find other split houses associated with this single house, and finally add them all to COM_TABLE.

4. The method for automatically updating the attributes of a single building based on multi-source data according to claim 3, characterized in that: S1.3 specifically includes: 1) Read each row in COM_TABLE, perform different building height calculations based on the WDLX attributes, obtain the height value HIGH, and record it in a temporary table T_HIGH = [...]: For a "flat-roofed building", the height value HIGH = ELEVATION_MAX - ELEVATION_FLOOR; If it is a "non-flat roof building", the height value HIGH = (ELEVATION_MAX - ELEVATI ON_EAVE) / 2 + (ELEVATION_EAVE - ELEVATI ON_EAVE); 2) Read the temporary table T_HIGH and select the maximum value as the height value of the current building ID; 3) If T_HIGH is empty, it means that the ELEVATION series height attribute of the overlapping target building has an empty value. Then, the UP_FLOORS attribute value of the individual building patch is multiplied by the preset floor height FLOOR_high as the height value of the current individual building ID. 4) After traversing all IDs in the unique sequence list UN_ID, complete the assignment of the height attribute of the individual building.

5. The method for automatically updating the attributes of a single building based on multi-source data according to claim 4, characterized in that: S2.1 specifically includes: 1) Use GeoPandas to read vector graphics from the database and convert them into a list of attributes. The individual building patch is read as IBU=[ID,FINALST,COR], where ID is a unique code, FINALST is the final above-ground scale of the individual building, and COR is the coordinate system; Other numerical target building features are read as TU = [TID, SETS_NUM, SETS_STR, CO R], where TID is the ID of the target building feature, SETS_NUM is the numerical attribute of the target building feature, and SETS_STR is the text attribute; 2) Unify the coordinate attribute COR in IBU and TU to CGCS2000, standardize the numerical attribute of TU, ​​remove erroneous values ​​that are not specific values ​​in the table, convert strings containing numerical values ​​to standard numerical values ​​under NumPy type, and unify all numerical formats to floating point type and retain two decimal places. 3) Overlay IBU and TU to calculate the overlap area. Under the premise that all attributes are not empty, remove non-overlapping elements and target building patches with an overlap area of ​​less than 1 square meter. Then sort them by the individual building ID and construct the overlap sequence table IBU_TU=[ID,TID,SETS_NUM,SETS_STR,COR]; 4) Extract the individual building ID column from IBU_TU and perform deduplication to obtain a unique sequence table UN_ID of all individual building IDs that have overlap.

6. The method for automatically updating the attributes of a single building based on multi-source data according to claim 5, characterized in that: S2.2 specifically includes: 1) Use the value in UN_ID as an index to slice and traverse the original sequence list IBU_TU, and name each slice IBU_TU_ID = [...]; 2) Based on the values ​​of ID and TID of IBU_TU_ID, retrieve other associated polygons from the overlapping sequence list IBU_TU, construct a new empty table COM_TABLE, and copy the information of all associated polygons into COM_TABLE.

7. The method for automatically updating the attributes of a single building based on multi-source data according to claim 6, characterized in that: S2.3 specifically includes: implementing different assignment strategies based on the number of IDs and TIDs in the COM_TABLE. 1) If the number of ID and TID is both 1, the assignment strategy is one-to-one, and the numerical attribute SETS_NUM and text attribute SETS_STR of the target building patch are directly assigned to the current single building ID. 2) If the number of IDs is 1 and the number of TIDs is greater than 1, the assignment strategy is one-to-many. The numerical attribute SETS_NUM of multiple target building patches is added together and then assigned to the current single building ID. There are two ways to assign the text attribute of the single building ID: one is to select the SETS_STR attribute of the target building patch with the largest overlapping area as the unique value, and the other is to deduplicate the SETS_STR attribute in the entire COM_TABLE, concatenate the non-repeating SETS_STR attributes with commas, and retain the most complete text attribute. 3) If the number of IDs is greater than 1 and the number of TIDs is equal to 1, the assignment strategy is many-to-one, requiring simultaneous assignment to multiple individual buildings. The numerical attribute value SETS_NUM assigned to each individual building ID is the proportion of the final ground scale FINALST_ID of the current individual building ID overlap to the total overlapping ground scale SUM(FINALST_ID) OVERLAP_PRC_ID; the text attribute of this individual building ID is assigned equal to the text attribute SETS_STR of the target building patch; 4) If the number of IDs is greater than 1 and the number of TIDs is also greater than 1, the assignment strategy is many-to-many. The many-to-many case is split into multiple many-to-one cases to avoid duplicate assignments. Based on a TID, the entire COM_TABLE is divided into multiple many-to-one tables, and then processed according to the many-to-one assignment strategy. If, after the calculation, a single building is assigned to multiple target buildings, the form is converted and the assignment is performed according to the one-to-many assignment strategy.

Images