Detection data visual management method and system, electronic equipment and medium

Abstract

The invention discloses a visual management method and system for detection data, electronic equipment and a medium, and relates to the technical field of detection data management. The method comprises the following steps: performing equal-proportion three-dimensional modeling on a detected building to obtain a three-dimensional model of the detected building; querying a query result of the detected building in a database; the query result comprises detection data corresponding to detection points in the detected building, security levels and three-dimensional coordinates of the detection points; and according to the three-dimensional coordinates of the detection points in the detected building, displaying the detection data and security levels corresponding to the detection points in the detected building in the query result at corresponding positions of the three-dimensional model of the detected building. According to the method, the query result can be intuitively and clearly presented.

Description

Technical Field

[0001] The present invention relates to the technical field of detection data management, and in particular to a detection data visualization management method, system, electronic device and medium. Background Art

[0002] The health detection and tracking of buildings often require regular collection of detection data from different key parts of the buildings, and the detection data is uploaded to the data center for storage, analysis and management to provide data basis for building health analysis and health comparison. The existing technical solutions for querying the detection data at different detection positions and different times of the same building are to query and retrieve the data by inputting keywords such as project name, detection period, detection position, detection method, etc., and present the query results in the form of a form or a list. However, because the query results are presented in the form of a form or a list, the corresponding relationship between the query results and the target of the detected building is not clear enough, which is not convenient for obtaining the detection data and further obtaining and analyzing the detection results. Presenting the data in the form of a list, the comparison of the longitudinal detection result data (data at the same position at different time points) is not intuitive enough. Therefore, how to present the query results intuitively and clearly is a problem that needs special attention. Summary of the Invention

[0003] The purpose of the present invention is to provide a detection data visualization management method, system, electronic device and medium, which can intuitively and clearly present the query results.

[0004] To achieve the above purpose, the present invention provides the following solutions:

[0005] A detection data visualization management method includes:

[0006] Performing an equal-proportion three-dimensional modeling on the detected building to obtain a three-dimensional model of the detected building;

[0007] Querying the query results of the detected building in the database; the query results include the respective detection data, safety levels and three-dimensional coordinates of each detection point in the detected building;

[0008] Displaying the respective detection data and safety levels corresponding to each detection point in the detected building in the query results at the corresponding positions of the three-dimensional model of the detected building according to the three-dimensional coordinates of each detection point in the detected building.

[0009] Optionally, the construction process of the database includes;

[0010] Identifying the respective detection data corresponding to each detection point in the detected building according to the contract number, detection task order number, detection point number and detection data collection date, and storing them in the database;

[0011] Create an evaluation table for the analysis results of the detection data in the database, classify the detection data corresponding to each detection point in the detected building according to the safety status, and save them in the evaluation table for the analysis results of the detection data.

[0012] Create a three-dimensional modeling coordinate information table in the database, establish a corresponding relationship between the number of the detected building, the detected data corresponding to each detection point in the labeled detected building, and the three-dimensional coordinates of each detection point in the detected building, and store them in the three-dimensional modeling coordinate information table.

[0013] In practical applications, query the query results of the detected building in the database, specifically including:

[0014] Search in the three-dimensional modeling coordinate information table for the number of the detected building, the detected data corresponding to each detection point in the labeled detected building, and the three-dimensional coordinates of each detection point in the detected building.

[0015] Search in the evaluation table for the analysis results of the detection data for the safety levels of each detection point in the detected building.

[0016] In practical applications, according to the three-dimensional coordinates of each detection point in the detected building, display the detected data and safety levels corresponding to each detection point in the query results at the corresponding positions of the three-dimensional model of the detected building, specifically including:

[0017] For any detection point in the detected building, display the detected data corresponding to the labeled detection point and the color label corresponding to the safety level at the corresponding position of the detection point in the three-dimensional model of the detected building according to the three-dimensional coordinates of the detection point.

[0018] A detection data visualization management system, including:

[0019] A three-dimensional modeling module for performing equal-proportion three-dimensional modeling on the detected building to obtain a three-dimensional model of the detected building.

[0020] A query module for querying the query results of the detected building in the database; the query results include the detected data, safety levels, and three-dimensional coordinates of each detection point in the detected building.

[0021] A display module for displaying the detected data and safety levels corresponding to each detection point in the query results at the corresponding positions of the three-dimensional model of the detected building according to the three-dimensional coordinates of each detection point in the detected building.

[0022] Optionally, the detection data visualization management system further includes;

[0023] An identification module, configured to identify each piece of detection data corresponding to each detection point in the building to be detected according to the contract number, the detection task order number, the detection point number, and the detection data collection date, and store them in a database;

[0024] A grading module, configured to establish an evaluation table for the analysis results of the detection data in the database, and grade each piece of detection data corresponding to each detection point in the building to be detected according to the safety status, and store them in the evaluation table for the analysis results of the detection data;

[0025] An association module, configured to establish a three-dimensional modeling coordinate information table in the database, and establish a corresponding relationship between the number of the building to be detected, each piece of detection data corresponding to each detection point in the identified building to be detected, and the three-dimensional coordinates of each detection point in the building to be detected, and store them in the three-dimensional modeling coordinate information table.

[0026] Optionally, the query module specifically includes:

[0027] A data search unit, configured to search in the three-dimensional modeling coordinate information table for the number corresponding to the building to be detected, each piece of detection data corresponding to each detection point in the identified building to be detected, and the three-dimensional coordinates of each detection point in the building to be detected;

[0028] A grade search unit, configured to search in the evaluation table for the analysis results of the detection data for the safety grades of each detection point in the building to be detected.

[0029] Optionally, the display module specifically includes:

[0030] A display unit, configured to, for any one detection point in the building to be detected, display the corresponding color identification of each piece of detection data and the safety grade corresponding to the identified detection point at the corresponding position of the detection point in the three-dimensional model of the building to be detected according to the three-dimensional coordinates of the detection point.

[0031] An electronic device, comprising:

[0032] A memory and a processor, where the memory is used to store a computer program, and the processor runs the computer program to enable the electronic device to execute the detection data visualization management method according to the above.

[0033] A computer-readable storage medium, which stores a computer program, and when the computer program is executed by a processor, it implements the detection data visualization management method as described above.

[0034] According to the specific embodiments provided by the present invention, the present invention discloses the following technical effects:

[0035] According to the three-dimensional coordinates of each detection point in the building to be detected, the present invention displays the detection data and safety levels corresponding to each detection point in the building to be detected in the query result at the corresponding positions of the three-dimensional model of the building to be detected, which can visually and clearly present the query result. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings required for use in the embodiments. Obviously, the drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other drawings can also be obtained based on these drawings.

[0037] Figure 1 It is a flowchart of the detection data visualization management method provided by the embodiment of the present invention;

[0038] Figure 2 It is a result diagram obtained by the detection data visualization management method provided by the embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0039] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, rather than all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts belong to the scope of protection of the present invention.

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

[0041] As Figure 1 shown, the present invention provides a detection data visualization management method, including:

[0042] Step 101: Perform an isometric three-dimensional modeling on the building to be detected to obtain a three-dimensional model of the building to be detected.

[0043] Step 102: Query the query result of the building to be detected in the database; the query result includes the detection data, safety level, and three-dimensional coordinates of each detection point corresponding to each detection point in the building to be detected.

[0044] Step 103: According to the three-dimensional coordinates of each detection point in the building to be detected, display the detection data and safety level corresponding to each detection point in the building to be detected in the query result at the corresponding positions of the three-dimensional model of the building to be detected, as Figure 2 shown.

[0045] In practical applications, the construction process of the database includes:

[0046] Identify each piece of detection data corresponding to each detection point in the building to be detected according to the contract number, detection task order number, detection point number, and detection data collection date, and save it in the database.

[0047] Establish an evaluation table for the analysis results of detection data in the database, classify each piece of detection data corresponding to each detection point in the building to be detected according to the safety status, and save it in the evaluation table for the analysis results of detection data.

[0048] Establish a three-dimensional modeling coordinate information table in the database, establish a corresponding relationship between the number of the building to be detected, each piece of detection data corresponding to each detection point in the identified building to be detected, and the three-dimensional coordinates of each detection point in the building to be detected, and store them in the three-dimensional modeling coordinate information table.

[0049] In practical applications, querying the query results of the building to be detected in the database specifically includes:

[0050] Search in the three-dimensional modeling coordinate information table for the number of the building to be detected, each piece of detection data corresponding to each detection point in the identified building to be detected, and the three-dimensional coordinates of each detection point in the building to be detected.

[0051] Search in the evaluation table for the analysis results of detection data for the safety levels of each detection point in the building to be detected.

[0052] In practical applications, according to the three-dimensional coordinates of each detection point in the building to be detected, display each piece of detection data and the safety level corresponding to each detection point in the query results at the corresponding positions of the three-dimensional model of the building to be detected. Specifically, it includes:

[0053] For any detection point in the building to be detected, display each piece of detection data corresponding to the identified detection point and the color identification corresponding to the safety level at the corresponding position of the detection point in the three-dimensional model of the building to be detected according to the three-dimensional coordinates of the detection point.

[0054] The present invention also provides a more specific embodiment to elaborate on the above method in detail. The general steps are as follows: Establish a three-dimensional model (set the model number as A001), establish detection positions in the model (the position coordinates are x, y, z), establish a retrieval table in the database. The retrieval table includes columns for the three-dimensional model number, x coordinate, y coordinate, z coordinate, and detection data file identifier. When the user opens the three-dimensional model, according to the number of the three-dimensional model and the xyz coordinates of each detection point it contains, and then according to the retrieval table, the required detection data can be retrieved and then displayed as needed. The specific steps are as follows:

[0055] Step 1: Perform an equal-proportion 3D modeling on the building to be detected. During the modeling process, simplify the building structure and retain the main components of the building (reduce the impact of non-critical components on the overall presentation of the building structure), generate a 3D graphic of the building to be detected, and determine a point in the 3D graphic as the coordinate origin of the 3D modeling. In this way, the positions of each point in the building can be confirmed through the 3D xyz coordinates, and then proceed to Step 2.

[0056] Step 2: According to the relative position information (xyz-direction distances) between the actual detection points required for the building to be detected and the geographical location of the origin determined by the 3D modeling, and based on the 3D modeling scaling ratio value and the position of the 3D modeling coordinate origin, determine the 3D coordinates of each detection point to obtain the 3D coordinates of each detection point, and then proceed to Step 3.

[0057] Step 3: Identify the detection data according to the contract number + detection task order number + detection point number + detection data collection date, and store the detection data and the identification in the database to ensure that the detection data identification is unique and non-repetitive, and can indicate the detection data information, and then proceed to Step 4. For the detection company, there are many buildings for the detection target. For the same building, there are different detection positions. For the same position, there are detection behaviors in different periods. However, the detection data must distinguish these differences. Therefore, this method is used to identify the detection data to ensure uniqueness. In the database, the detection data identification is unique, and it can be corresponding to the number and coordinate position of the 3D model. In this way, the required detection data can be retrieved through the model number and coordinate information.

[0058] Step 4: Establish an evaluation table for the analysis results of building detection data in the database, and classify the detection data from 0 to 99. The smaller the value, the worse the safety condition.

[0059] Step 5: Establish a 3D modeling coordinate information table in the database, and establish a corresponding relationship between the detection data identification, the building number to be detected, and the 3D coordinates of the 3D modeling.

[0060] Step 6: When querying the detection data, according to the building to be detected input or selected, with the help of the 3D modeling coordinate information table, find the corresponding detection data file information (all the detected data queried) and the bound detection point coordinate information, and graphically display the corresponding detected data information at the corresponding positions.

[0061] Step 7: When displaying the query of the detection data, through retrieving the analysis results of the building detection data analysis result evaluation table, indicate the change trend of the safety condition of each detection through different colors.

[0062] The embodiment of the present invention also provides a visualization management system for detection data, including:

[0063] A three-dimensional modeling module for performing an equal-proportion three-dimensional modeling on the building to be detected to obtain a three-dimensional model of the building to be detected.

[0064] A query module for querying a query result of the building to be detected in a database; the query result includes various detection data, safety levels, and three-dimensional coordinates of each detection point corresponding to each detection point in the building to be detected.

[0065] A display module for displaying the various detection data and safety levels corresponding to each detection point in the building to be detected in the query result at corresponding positions of the three-dimensional model of the building to be detected according to the three-dimensional coordinates of each detection point in the building to be detected.

[0066] As an optional implementation manner, the detection data visualization management system further includes:

[0067] An identification module for identifying the various detection data corresponding to each detection point in the building to be detected according to the contract number, detection task order number, detection point number, and detection data collection date, and storing them in the database.

[0068] A grading module for establishing an evaluation table of detection data analysis results in the database, grading the various detection data corresponding to each detection point in the building to be detected according to the safety condition, and storing them in the detection data analysis result evaluation table.

[0069] An association module for establishing a three-dimensional modeling coordinate information table in the database, establishing a corresponding relationship between the number of the building to be detected, the various detection data corresponding to each detection point in the identified building to be detected, and the three-dimensional coordinates of each detection point in the building to be detected, and storing them in the three-dimensional modeling coordinate information table.

[0070] As an optional implementation manner, the query module specifically includes:

[0071] A data search unit for searching in the three-dimensional modeling coordinate information table for the number corresponding to the building to be detected, the various detection data corresponding to each detection point in the identified building to be detected, and the three-dimensional coordinates of each detection point in the building to be detected.

[0072] A level search unit for searching in the detection data analysis result evaluation table for the safety levels of each detection point in the building to be detected.

[0073] As an optional implementation manner, the display module specifically includes:

[0074] A display unit, for any detection point in the building to be detected, according to the three-dimensional coordinates of the detection point, display the detection data corresponding to the identified detection point and the color identification corresponding to the safety level at the corresponding position of the detection point in the three-dimensional model of the building to be detected.

[0075] The present invention also provides an electronic device, including:

[0076] A memory and a processor, the memory is used to store a computer program, and the processor runs the computer program to enable the electronic device to execute the detection data visualization management method according to the method embodiment described above.

[0077] The present invention also provides a computer-readable storage medium, which stores a computer program, and when the computer program is executed by a processor, it implements the detection data visualization management method as described in the method embodiment above.

[0078] Adopting the building graphics method, the change trends of the monitoring data of each detection point can be seen globally and comprehensively. The present invention has the following beneficial effects:

[0079] 1. The corresponding relationship between the detection data query result and the detection point position of the building to be detected is clearly visible.

[0080] 2. The relative position relationship between all detection data of the building to be detected is clearly visible.

[0081] 3. The change trend of the data analysis result of the detection position of the building to be detected is clearly visible.

[0082] 4. The health status of the building to be detected is intuitively visible, and the change trend is intuitively visible.

[0083] In this specification, each embodiment is described in a progressive manner. The key point of each embodiment is to illustrate the differences from other embodiments. The same or similar parts among the embodiments can be referred to each other. For the system disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and the relevant parts can be referred to the description in the method part.

[0084] Specific examples are used in this article to elaborate on the principle and implementation manner of the present invention. The description of the above embodiments is only used to help understand the method and its core idea of the present invention; at the same time, for those of ordinary skill in the art, according to the idea of the present invention, there will be changes in the specific implementation manner and application scope. In summary, the content of this specification should not be construed as a limitation to the present invention.

Claims

1. A method for visual management of detection data, characterized in that: include: Performing proportional three-dimensional modeling on the inspected building to obtain a three-dimensional model of the inspected building; Querying the query results of the detected buildings in the database; The query result includes each detection data corresponding to each detection point in the detected building, the safety level and the three-dimensional coordinates of each detection point; According to the three-dimensional coordinates of each detection point in the detected building, the detection data and safety level corresponding to each detection point in the detected building in the query result are displayed at the corresponding position of the three-dimensional model of the detected building.

2. The method for visual management of detection data according to claim 1, characterized in that: The database construction process includes: Identify each test data corresponding to each test point in the tested building according to the contract number, test task order number, test point number and test data collection date, and save them in the database; Establishing a test data analysis result evaluation table in the database, and grading each test data corresponding to each test point in the tested building according to the safety status, and saving the grading data in the test data analysis result evaluation table; A three-dimensional modeling coordinate information table is established in the database, and a correspondence is established between the number of the detected building, the detection data corresponding to each detection point in the detected building after identification, and the three-dimensional coordinates of each detection point in the detected building and stored in the three-dimensional modeling coordinate information table.

3. The method for visual management of detection data according to claim 2, characterized in that: The query results of the detected buildings are queried in the database, including: Searching the number corresponding to the detected building, the detection data corresponding to each detection point in the detected building after identification, and the three-dimensional coordinates of each detection point in the detected building in the three-dimensional modeling coordinate information table; Find the safety level of each inspection point in the inspected building in the inspection data analysis result evaluation table.

4. The method for visual management of detection data according to claim 1, characterized in that: Displaying the detection data and safety level corresponding to each detection point in the detected building in the query result at the corresponding position of the three-dimensional model of the detected building according to the three-dimensional coordinates of each detection point in the detected building, specifically including: For any detection point in the detected building, the detection data corresponding to the identified detection point and the color identification corresponding to the security level are displayed at the corresponding position of the detection point in the three-dimensional model of the detected building according to the three-dimensional coordinates of the detection point.

5. A visual management system for detection data, characterized in that: include: A three-dimensional modeling module is used to perform proportional three-dimensional modeling on the inspected building to obtain a three-dimensional model of the inspected building; A query module, used to query the query results of the detected building in the database; the query results include the detection data corresponding to each detection point in the detected building, the safety level and the three-dimensional coordinates of each detection point; The display module is used to display the detection data and security level corresponding to each detection point in the detected building in the query result at the corresponding position of the three-dimensional model of the detected building according to the three-dimensional coordinates of each detection point in the detected building.

6. The detection data visualization management system according to claim 5, characterized in that: Also includes; An identification module, used to identify each test data corresponding to each test point in the inspected building according to the contract number, the test task order number, the test point number and the test data collection date, and save it in the database; A grading module is used to establish a test data analysis result evaluation table in the database, and to grade each test data corresponding to each test point in the tested building according to the safety status, and save it in the test data analysis result evaluation table; The association module is used to establish a three-dimensional modeling coordinate information table in the database, establish a corresponding relationship between the number of the detected building, the detection data corresponding to each detection point in the detected building after identification, and the three-dimensional coordinates of each detection point in the detected building, and store them in the three-dimensional modeling coordinate information table.

7. The detection data visualization management system according to claim 6, characterized in that: The query module specifically includes: A data search unit is used to search the number corresponding to the detected building, the detection data corresponding to each detection point in the detected building after identification, and the three-dimensional coordinates of each detection point in the detected building in the three-dimensional modeling coordinate information table; The level search unit is used to search the safety level of each detection point in the detected building in the detection data analysis result evaluation table.

8. The inspection data visualization management system according to claim 5, characterized in that: The display module specifically includes: The display unit is used to display, for any detection point in the detected building, the detection data corresponding to the marked detection point and the color identification corresponding to the security level according to the three-dimensional coordinates of the detection point at the corresponding position of the detection point in the three-dimensional model of the detected building.

9. An electronic device, characterized in that: include: A memory and a processor, wherein the memory is used to store a computer program, and the processor runs the computer program to enable the electronic device to perform the detection data visualization management method according to any one of claims 1 to 4.

10. A computer-readable storage medium, characterized in that: It stores a computer program, which, when executed by a processor, implements the detection data visualization management method as described in any one of claims 1 to 4.

Images