Joint surveying and mapping result data fusion and index analysis method and system

Abstract

The invention discloses a joint surveying and mapping result data fusion and index analysis method and system, and the method comprises the steps: building a table structure of a joint surveying and mapping fusion database, obtaining joint surveying and mapping result data with a land parcel as a unit, and building a field mapping relation between the joint surveying and mapping result data and the table structure in the joint surveying and mapping fusion database, storing the combined surveying and mapping result data into the same table structure according to the hierarchy; and then, establishing a logic association relationship among the data of each level in the combined surveying and mapping fusion database, and distributing a GUID for the data of each level to form a complete data chain with an association relationship among a land parcel, an engineering planning license, a natural building, a logic building, a floor and a user, so as to complete the creation of the combined surveying and mapping fusion database. And finally, on the basis of the combined surveying and mapping fusion database, cross-business and cross-level query statistics and index analysis are realized, and decision making of an administrative department is supported.

Description

Technical Field

[0001] This invention belongs to the field of geographic information system technology, specifically relating to a method and system for data fusion and index analysis of joint surveying and mapping results. Background Technology

[0003] Because different business focuses have different priorities—for example, planning condition verification focuses on the floor area ratio of each function, and the statistical granularity of indicators can be down to the building level; real estate business focuses on the building area of ​​each function, and the statistical granularity of indicators can be down to the household level; civil defense business focuses on the building area of ​​civil defense facilities, especially the location, area and function of civil defense basements; in addition, the different software used by various surveying and mapping units in the market leads to different data output formats for the same business, and the lack of horizontal correlation between the outputs of different businesses, which further increases the difficulty of data integration, easily creates data silos, and affects the sharing of results services.

[0004] The applicant's search revealed the following existing technologies for processing joint surveying and mapping results, as detailed below: (1) A surveying system and method based on multi-source data fusion, patent number CN202510333849.9, focuses on field data collection and indoor data processing. The specific process is that the field data collection is carried out by an UAV equipped with an image acquisition device and a laser device to collect images and perform lidar ranging on the area to be surveyed, thereby obtaining image data and point cloud data respectively; the indoor data collection is carried out by fusing the image data and point cloud data to obtain a high-precision regional surveying model.

[0005] (2) A multi-source data fusion mapping intelligent analysis system and method, patent number CN202510637757.X, relates to the field of mapping analysis, focusing on the deformation of buildings. The specific process is as follows: acquire three-dimensional point cloud data of urban buildings and real-time foundation information, construct corresponding three-dimensional building models, and generate multi-source building fusion models based on the three-dimensional building models; acquire building mapping data and floor mapping data of each floor through the multi-source building fusion model, analyze the building mapping data, obtain offset and crack degree, and obtain the floor turbulence degree based on offset and crack degree; obtain the floor building interference value based on turbulence degree and floor mapping data, and obtain the occupancy value based on the floor building interference value; analyze the occupancy of residents on the floor and the occupancy of the building through the occupancy value, obtain the analysis results, and maintain the building based on the analysis results to obtain maintenance strategies.

[0006] (3) The paper “Research and Application of Historical Data Integration and Database of Joint Surveying and Mapping Business in Zhuhai City” was published in the third issue of Urban Surveying and Mapping in 2024. It mainly discusses the method of structuring and establishing databases for unstructured or semi-structured joint surveying and mapping historical business data (planning condition verification measurement, civil air defense completion acceptance measurement and real estate surveying and mapping) according to business type. However, it does not integrate and associate the data between different businesses. They are still working independently and cannot carry out cross-business data statistical analysis and application.

[0007] In general, existing joint surveying and mapping results are stored separately by different business departments, lacking effective data correlation. Data processing is often done manually or with the help of office software (such as Excel or WPS Spreadsheets) only when needed. Therefore, this approach has the following drawbacks: First, it results in high labor costs, long processing times, low efficiency, and a high risk of data omissions, severely impacting the accuracy and efficiency of data statistics. Second, the independent storage of joint surveying and mapping results across different business types creates data silos, hindering the integration and application of data from different business sectors. Third, the manual statistical methods rely on a single technical approach, often requiring restarting when needs change, leading to significant repetitive work. Fourth, there is a lack of data update mechanisms and a lack of unified data governance solutions, preventing the creation of high-quality data assets.

[0008] Therefore, it is necessary to design a data fusion processing and index analysis method and system for joint surveying and mapping data to solve the problems existing in the current joint surveying and mapping data sharing service, break down data barriers between different businesses and departments, truly achieve joint surveying and mapping and result sharing, and provide data support for the scientific decision-making of administrative departments. Summary of the Invention

[0009] This invention aims to solve at least one of the technical problems existing in the prior art. To this end, this invention proposes a method and system for data fusion and index analysis of joint surveying and mapping results, which realizes true fusion of joint surveying and mapping results data, makes up for the shortcomings of different granularity of indicators of various business in joint surveying and mapping and insufficient horizontal correlation between various business, realizes cross-business and cross-level business query and statistical analysis, and supports the decision-making of administrative management departments.

[0010] In a first aspect, the present invention provides a method for data fusion and index analysis of joint surveying and mapping results, including: S1. Create the table structure of the joint surveying and mapping fusion database. There are multiple table structures with hierarchical relationships. Each table structure integrates fields from multiple joint surveying and mapping services. S2. Based on land parcels, acquire joint surveying and mapping results data, and by creating a field mapping relationship between the joint surveying and mapping results data and the table structure of the joint surveying and mapping fusion database, store the joint surveying and mapping results data into the table structure of the joint surveying and mapping fusion database; S3. Establish logical relationships between data at each level in the joint surveying and mapping fusion database. By assigning GUIDs to data at each level, a chain of relationships from land parcels to households is formed, thus completing the creation of the joint surveying and mapping fusion database. S4. Based on the joint surveying and mapping fusion database, perform cross-business and cross-level query statistics and indicator analysis.

[0011] Furthermore, in S1, the table structure includes a land parcel table, an engineering planning permit table, a natural building table, a logical building table, a floor table, and a household table, which together form the overall architecture of the joint surveying and mapping fusion database. Each table structure integrates fields from the planning condition verification measurement results, the civil air defense completion acceptance measurement results, and the real estate surveying and mapping results. In S2, the joint surveying and mapping results data include the planning conditions verification survey results, the civil air defense completion acceptance survey results, and the real estate surveying and mapping results.

[0012] Furthermore, in S1, for cases where there is no household information in the surveying results for the verification of planning conditions and the surveying results for the completion acceptance of civil air defense projects, it is also necessary to continue to attach the table structure of floors and households on the basis of logical buildings in order to form a complete data chain.

[0013] Furthermore, in S2, if the joint surveying and mapping results data are altered due to changes in measurement or policy issues, resulting in different names for different business buildings, the joint surveying and mapping results data will be entered into the database only after the buildings are confirmed to be the same through comparison and verification of certificate information or spatial data.

[0014] Furthermore, in S3, the process of assigning GUIDs to data at each level to form a chain of relationships from land parcels to households specifically involves: assigning a different GUID to each construction planning permit, a different GUID to each building, a different GUID to each logical building, a different GUID to each floor, and a different GUID to each household. The hierarchical relationships between land parcels, construction planning permits, buildings, logical buildings, floors, and households are established through these GUIDs. Specifically, each land parcel corresponds to multiple construction planning permits, each construction planning permit corresponds to multiple buildings, each building corresponds to multiple logical buildings, each logical building corresponds to multiple floors, and each floor corresponds to multiple households.

[0015] Furthermore, after the joint surveying and mapping fusion database is created in S3, if a data update occurs, the project and level that need to be updated are first located. The update process will regenerate the GUID of the corresponding level and update the association relationship and the value of the corresponding field, and then enter the database in an incremental manner.

[0016] Furthermore, in S4, the query statistics and indicator analysis include one or more of the following: project construction scale, functional area ratio, building height analysis, regional development intensity, and prediction of the development trend of the construction project based on time series analysis.

[0017] Secondly, the present invention also provides a joint surveying and mapping results data fusion and index analysis system, comprising: The processor, when executing computer-executable instructions or computer programs stored in the memory, implements the program module processing method of the present invention; The memory is used to store the joint mapping fusion database created by the above method, as well as to store computer-executable instructions or computer programs; The program module includes The data entry module is used to acquire joint surveying and mapping results data on a parcel-by-parcel basis, and to enter the joint surveying and mapping results data into the joint surveying and mapping fusion database through field mapping. The association establishment module is used to establish logical associations between data at various levels in the joint surveying and mapping fusion database. By assigning a globally unique identifier (GUID) to each level of data, an association chain is formed from land parcel to household. The query and statistics module is used to perform cross-business and cross-level query statistics and indicator analysis based on the joint surveying and mapping fusion database.

[0018] Furthermore, the query statistics and indicator analysis include one or more of the following: project construction scale, functional area ratio, building height analysis, regional development intensity, and prediction of the development trend of construction projects based on time series analysis.

[0019] Furthermore, the system of the present invention also includes a visualization program module and a display unit for displaying query statistics and indicator analysis results.

[0020] Compared with the prior art, the beneficial effects of the present invention are as follows: This invention, through the aforementioned technical solution, achieves true integration of joint surveying and mapping results data, effectively promoting the efficient integration and seamless connection of data resources, forming a data resource element set, providing strong technical support for data information query, statistics, and application, facilitating subsequent analysis of various indicators of the overall joint surveying and mapping business based on the joint surveying and mapping fusion database, and ensuring the timeliness of the joint surveying and mapping fusion database. Simultaneously, it employs visual data display methods such as bar charts, pie charts, and line charts, providing data support for urban planning decisions, dynamic monitoring of engineering projects, and assessment and utilization of land resources. It provides data-driven decision-making basis for urban planning preparation, adjustment, project approval, and supervision, activating data value, empowering efficient urban management and scientific decision-making, and contributing to the construction of a digital government. Attached Figure Description

[0021] Figure 1 This is a flowchart illustrating the method for data fusion and index analysis of joint surveying and mapping results described in this invention. Figure 2 This is a diagram of the household table structure in the joint surveying and mapping results data fusion and index analysis method described in this invention; Figure 3 for Figure 2 A magnified view of a portion of the household meter structure; Figure 4 This is a schematic block diagram of the joint surveying and mapping results data fusion and index analysis system described in this invention; Figure 5 This is a user interface diagram of an embodiment of the joint surveying and mapping results data fusion and index analysis system described in this invention. Detailed Implementation

[0022] To enable those skilled in the art to more clearly understand the technical solutions described in this invention, the following embodiments are provided for illustration. It should be noted that the following embodiments do not constitute a limitation on the scope of protection claimed by this invention.

[0023] like Figure 1 As shown, the joint surveying and mapping results data fusion and index analysis method of this invention requires special explanation. The index analysis described in this invention refers to the systematic analysis of the construction scale, construction progress, and other information of one or more projects or a certain area. For example, the building scale includes square meters, the number of buildings, the commercial area, the residential area, the number of residential / commercial / office / talent apartments / affordable housing units, the number of high-rise buildings, the area of ​​underground civil defense shelters, etc. Step S1. Create the table structure of the joint surveying and mapping fusion database. There are multiple table structures with hierarchical relationships. Each table structure integrates fields from multiple joint surveying and mapping services. Specifically, when the joint surveying and mapping services include planning condition verification surveying, real estate surveying, and civil air defense completion acceptance surveying, the table structure includes a hierarchical table of land parcels, engineering planning permits, natural buildings, logical buildings, floors, and households, which together form the overall architecture of the joint surveying and mapping fusion database. Each table structure integrates fields from the planning condition verification survey results, civil air defense completion acceptance survey results, and real estate surveying results.

[0024] Although the overall logic of the three thematic surveying and mapping services—planning condition verification surveying, real estate surveying, and civil air defense completion acceptance surveying—is based on a data structure organized from land parcel to household, the different policies and requirements of each thematic service result in different table structures and fields at each level. Furthermore, some services lack data at certain levels. Therefore, this invention, when establishing the joint surveying and mapping fusion database, uses the aforementioned table structure creation method to aggregate the fields of each service at each level onto a single table structure, ultimately forming a complete database that integrates all fields from the joint surveying and mapping. Moreover, when creating the table structure of the joint surveying and mapping fusion database, for the planning condition verification surveying and mapping results and the civil air defense completion acceptance surveying results, which lack household information, it is necessary to continue attaching floor and household table structures based on the logical building to form a complete data chain.

[0025] Step S2. Acquire joint surveying and mapping results data on a parcel-by-parcel basis. Then, by creating a field mapping relationship between the joint surveying and mapping results data and the table structure of the joint surveying and mapping fusion database, input the joint surveying and mapping results data into the table structure of the joint surveying and mapping fusion database. If the joint surveying and mapping results data undergoes changes due to measurement changes or policy issues resulting in different building names for different business operations, the data will be entered into the database only after verification through certificate information or spatial data comparison to confirm that it is the same building. Specifically, the certificate information can be used to query the correspondence between the old and new building names, thus confirming whether they are the same building. Since each building has coordinate information, spatial data can be plotted and overlaid to confirm whether it is the same building. Then, it can be determined whether it is a new result for that building; if so, the new data replaces the old data. As mentioned above, when the joint surveying and mapping business includes planning condition verification surveying, real estate surveying, and civil air defense completion acceptance surveying, the joint surveying and mapping results data includes planning condition verification surveying results, civil air defense completion acceptance surveying results, and real estate surveying results.

[0026] Step S3. Establish logical relationships between data at each level in the joint surveying and mapping fusion database. By assigning a GUID (Globally Unique Identifier) ​​to each level of data, a chain of relationships is formed from land parcel to household. This results in a complete data chain with relationships: land parcel → engineering planning permit → building → logical building → floor → household, thus completing the creation of the joint surveying and mapping fusion database. Specifically, the GUID can preferably use the UUID v4 algorithm based on random numbers to ensure its global uniqueness in the distributed system. It is randomly generated by the system when generating data at each level, such as 123e4567-e89b-12d3-a456-426614174000; or the snowflake algorithm can be used, ensuring uniqueness while also providing time order and indexing performance. Different GUIDs are assigned to each engineering planning permit, each building, each logical building, each floor, and each household. These GUIDs are then used to establish relationships between land parcels, engineering planning permits, buildings, logical buildings, and floors. The hierarchical relationships between floors and units (that is, associating the GUID of each construction planning permit with the GUID of the land parcel, the GUID of each building with the GUID of the corresponding construction planning permit, the GUID of each logical building with the GUID of the corresponding building, the GUID of each floor with the GUID of the corresponding logical building, and assigning the GUID of each unit with the GUID of the corresponding floor), that is, each land parcel corresponds to multiple construction planning permits, each construction planning permit corresponds to multiple buildings, each building corresponds to multiple logical buildings, each logical building corresponds to multiple floors, and each floor corresponds to multiple units. For example: Figure 2 and Figure 3 This is the household table structure, which is also the most detailed level. When multiple natural buildings on the same land parcel are entered into the joint surveying and mapping fusion database, the system (i.e., the joint surveying and mapping results data fusion and index analysis system of this invention) automatically assigns a different buildingguid to each natural building and associates it with the land parcel's GUID. One land parcel (landguid) corresponds to multiple licenses (licenceguid, mostly issued according to the development phase). Similarly, each license (licenceguid) corresponds to multiple natural buildings (buildingguid), each natural building (buildingguid) corresponds to multiple logical buildings (logicbuildingguid), each logical building (logicbuildingguid) corresponds to multiple floors (floorguid), and each floor (floorguid) corresponds to multiple households (houseguid), ultimately forming a complete data chain with related relationships.

[0027] Step S4. Based on the joint surveying and mapping fusion database, perform cross-business and cross-level query statistics and indicator analysis. The query statistics and indicator analysis include one or more of the following: project construction scale, functional area ratio, building height analysis, regional development intensity, and prediction of project development trends based on time series analysis. For example: Figure 5 The diagram shows the user interface of the joint surveying and mapping results data fusion and index analysis system. This system is built based on the joint surveying and mapping results data fusion and index analysis method described in this invention. Figure 5 As shown, it includes a processor 100 and a memory 200; wherein, the processor 100 is used to execute computer-executable instructions or computer programs stored in the memory to implement the program module processing method of the present invention; the memory 200 is used to store a joint surveying and mapping fusion database 300 created by the joint surveying and mapping result data fusion and index analysis method of the present invention, and to store computer-executable instructions or computer programs; the program module includes a data entry program module 400, an association establishment program module 500, and a query and statistics program module 600, wherein the data entry program module 400 is used to obtain joint data fusion results data fusion and index analysis methods on a parcel-by-parcel basis. The surveying and mapping results data are entered into the joint surveying and mapping fusion database through field mapping; the association establishment program module 500 is used to establish logical association relationships between data at various levels in the joint surveying and mapping fusion database, and form an association chain from land parcel to household by assigning GUID to data at each level; the query and statistics program module 600 is used to perform cross-business and cross-level query statistics and indicator analysis based on the joint surveying and mapping fusion database, including project construction scale, functional area ratio, building height analysis, regional development intensity, and prediction of the development trend of construction projects based on time series analysis.

[0028] In addition, the system of the present invention also includes a visualization program module 700 and a display unit 800. The display unit 800 can be a monitor or display screen (such as a touch screen) for human-computer interaction, and together with the visualization program module 700, it realizes the display of query statistics and indicator analysis results. The query statistics and indicator analysis results can be visualized through bar charts, pie charts, line charts and other expression methods.

[0029] This invention analyzes the relationships between different business operations and establishes a strict logical association from land parcel → construction planning permit → natural building → logical building → floor → household by assigning a unique GUID. This forms a joint surveying and mapping fusion database covering three types of business indicators, achieving true integration of joint surveying and mapping results data. It overcomes the shortcomings of inconsistent granularity of business indicators and insufficient horizontal correlation between different business operations, rather than simply building separate databases based on business type. Furthermore, through the established associations, it effectively promotes the efficient integration and seamless connection of data resources, forming a data resource element set, and providing powerful support for data information query, statistics, and application. The technical support facilitates subsequent analysis of various indicators at all levels or across levels of the joint surveying and mapping business based on the joint surveying and mapping fusion database. Furthermore, it allows for the import and updating of new joint surveying and mapping data through mapping relationships, ensuring the database's timeliness. The database also provides data visualization through bar charts, pie charts, and line charts, offering data support for urban planning decisions, dynamic monitoring of engineering projects, and land resource assessment and utilization. It provides data-driven decision-making basis for urban planning, adjustments, project approval, and supervision, activating data value, empowering efficient urban management and scientific decision-making, and contributing to the construction of a digital government.

[0030] As a preferred embodiment of the present invention, in step S3, after the joint surveying and mapping fusion database is created, if a data update occurs, the project and level that need to be updated are first located. The update process regenerates the GUID of the corresponding level and updates the association relationships and values ​​of the corresponding fields, incrementally storing the data. In this way, the joint surveying and mapping fusion database can subsequently update the database by storing new joint surveying and mapping data through mapping relationships, maintaining the database's current status. Furthermore, the incremental storage method improves the processing efficiency of the operating system. Specifically, when there are projects and levels that need to be updated, old data must be used as a basis for verification to ensure the correctness of the updated data. Specifically, when updating data, old data information needs to be provided. The system provides search fields, such as project name, construction unit, address, and engineering planning permit number, which can easily locate the old data and then perform the update operation. For computer technicians, SQL statements can also be used to search the database to find the projects and levels that need to be updated.

[0031] The above description represents the preferred embodiments of the present invention. It should be noted that those skilled in the art can make various improvements and modifications without departing from the principles of the present invention, and these improvements and modifications are also considered to be within the scope of protection of the present invention.

Claims

1. A method for data fusion and index analysis of joint surveying and mapping results, characterized in that, include: S1. Create the table structure of the joint surveying and mapping fusion database. There are multiple table structures with hierarchical relationships. Each table structure integrates fields from multiple joint surveying and mapping services. S2. Based on land parcels, acquire joint surveying and mapping results data, and by creating a field mapping relationship between the joint surveying and mapping results data and the table structure of the joint surveying and mapping fusion database, store the joint surveying and mapping results data into the table structure of the joint surveying and mapping fusion database; S3. Establish logical relationships between data at each level in the joint surveying and mapping fusion database. By assigning GUIDs to data at each level, a chain of relationships from land parcels to households is formed, thus completing the creation of the joint surveying and mapping fusion database. S4. Based on the joint surveying and mapping fusion database, perform cross-business and cross-level query statistics and indicator analysis.

2. The method according to claim 1, characterized in that, In S1, the table structure includes a hierarchical relationship of land parcel table, engineering planning permit table, natural building table, logical building table, floor table and household table, which together form the overall architecture of the joint surveying and mapping fusion database. Each table structure integrates fields of planning condition verification measurement results, civil air defense completion acceptance measurement results and real estate surveying and mapping results. In S2, the joint surveying and mapping results data include the planning conditions verification survey results, the civil air defense completion acceptance survey results, and the real estate surveying and mapping results.

3. The method according to claim 2, characterized in that, In S1, for cases where the survey results for verifying planning conditions and the survey results for civil air defense completion acceptance do not contain household information, it is also necessary to continue to attach the table structure of floors and households on the basis of logical buildings in order to form a complete data chain.

4. The method according to claim 1, characterized in that, In S2, if the joint surveying and mapping results data are altered due to changes in measurement or policy issues, resulting in different names for different business buildings, the joint surveying and mapping results data will be entered into the database only after the same building is confirmed through comparison and verification of certificate information or spatial data.

5. The method according to claim 1, characterized in that, In S3, the process of assigning GUIDs to data at each level to form a chain of relationships from land parcels to households is specifically as follows: each construction planning permit is assigned a different GUID, each building is assigned a different GUID, each logical building is assigned a different GUID, each floor is assigned a different GUID, and each household is assigned a different GUID. The hierarchical relationships between land parcels, construction planning permits, buildings, logical buildings, floors, and households are established through the GUIDs. That is, each land parcel corresponds to multiple construction planning permits, each construction planning permit corresponds to multiple buildings, each building corresponds to multiple logical buildings, each logical building corresponds to multiple floors, and each floor corresponds to multiple households.

6. The method according to claim 1, characterized in that, After the joint surveying and mapping fusion database is created in S3, if a data update occurs, first find the project and level that need to be updated. The update process will regenerate the GUID of the corresponding level and update the association relationship and the value of the corresponding field, and then add it to the database in an incremental manner.

7. The method according to claim 1, characterized in that, In S4, the query statistics and indicator analysis include one or more of the following: project construction scale, functional area ratio, building height analysis, regional development intensity, and prediction of the development trend of construction projects based on time series analysis.

8. A system for data fusion and index analysis of joint surveying and mapping results, characterized in that, include: The processor, when executing computer-executable instructions or computer programs stored in the memory, implements the program module processing method of the present invention; The memory is used to store the joint mapping fusion database created by the method of any one of claims 1-7, and to store computer-executable instructions or computer programs; The program module includes The data entry module is used to acquire joint surveying and mapping results data on a parcel-by-parcel basis, and to enter the joint surveying and mapping results data into the joint surveying and mapping fusion database through field mapping. The association establishment module is used to establish logical associations between data at various levels in the joint surveying and mapping fusion database, forming an association chain from land parcel to household by assigning a globally unique identifier (GUID) to each level of data; and, The query and statistics module is used to perform cross-business and cross-level query statistics and indicator analysis based on the joint surveying and mapping fusion database.

9. The system according to claim 8, characterized in that, The query statistics and indicator analysis include one or more of the following: project construction scale, functional area ratio, building height analysis, regional development intensity, and prediction of the development trend of construction projects based on time series analysis.

10. The system according to claim 8, characterized in that, It also includes a visualization module and a display unit for showing query statistics and indicator analysis results.

Images