CN117194384B - Urban safety information model platform data integration method based on trigger - Google Patents
Urban safety information model platform data integration method based on trigger Download PDFInfo
- Publication number
- CN117194384B CN117194384B CN202311255389.XA CN202311255389A CN117194384B CN 117194384 B CN117194384 B CN 117194384B CN 202311255389 A CN202311255389 A CN 202311255389A CN 117194384 B CN117194384 B CN 117194384B
- Authority
- CN
- China
- Prior art keywords
- library
- data
- trigger
- edge
- service
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 62
- 230000010354 integration Effects 0.000 title claims abstract description 11
- 230000008569 process Effects 0.000 claims abstract description 34
- 238000012545 processing Methods 0.000 claims abstract description 13
- 230000008859 change Effects 0.000 claims description 24
- 238000003860 storage Methods 0.000 claims description 20
- 238000013507 mapping Methods 0.000 claims description 6
- 238000001914 filtration Methods 0.000 claims description 5
- 238000004891 communication Methods 0.000 claims description 3
- 238000005520 cutting process Methods 0.000 claims description 3
- 238000013523 data management Methods 0.000 claims description 3
- 238000013461 design Methods 0.000 abstract description 6
- 238000010606 normalization Methods 0.000 abstract description 3
- 238000006243 chemical reaction Methods 0.000 description 12
- 238000007689 inspection Methods 0.000 description 12
- 238000007726 management method Methods 0.000 description 10
- 238000004458 analytical method Methods 0.000 description 5
- 230000007246 mechanism Effects 0.000 description 5
- 238000013439 planning Methods 0.000 description 4
- 230000008520 organization Effects 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 238000000605 extraction Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000011835 investigation Methods 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 231100000279 safety data Toxicity 0.000 description 2
- 238000004088 simulation Methods 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02A—TECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
- Y02A30/00—Adapting or protecting infrastructure or their operation
- Y02A30/60—Planning or developing urban green infrastructure
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a trigger-based urban safety information model platform data integration method, which relates to the technical field of data integration and comprises the following steps: step S1: creating a database based on the trigger, wherein the created database is used as an original service library; step S2: writing into a temporary library; step S3: updating an original business library: the method comprises four trigger flows of backup, edge connection, update and writing. The automatic configuration trigger scheme for creating the empty database normalizes, visualizes and processes three steps of trigger configuration, so that a manager of urban safety information data can realize database link through simple batch processing, and the operations of data table design, data normalization and the like are captured, thereby improving the working efficiency.
Description
Technical Field
The invention relates to the technical field of data integration, in particular to a trigger-based urban safety information model platform data integration method.
Background
The city safety information model platform is a basic operation platform for planning, constructing, managing and running a smart city facing city safety. The related content is wide in scope, large in quantity and complicated, the urban safety data sensing, simulating and early warning content and programs have the characteristics of the content and programs, and the content and programs have the capability of providing decision support, so that the system structural design is required to call basic geographic information, urban safety equipment sensing information, management information and the like, and the information can be effectively managed, queried and analyzed. The database structure is built by using a database, and hundreds of tables are created when the database structure is built, and the correlation among a plurality of data among the tables is strong, so that the original database structure can not meet the management requirement of the urban safety information model platform. The traditional urban safety data sensing, simulation, early warning and decision making processes are complex, and mainly relate to different departments (such as a plurality of departments of natural resources, living construction, emergency and the like), different business data (space-time basic data, resource investigation data, planning management data, engineering construction data, public thematic data, urban safety internet of things sensing data and the like), and different data standards (raster data, vector data, text data, graphic data and the like), wherein a plurality of sets of software or platforms based on different platforms and different technical systems are difficult to uniformly manage and maintain and expand formats and functions; in addition, in the aspect of data simulation analysis, an analysis early warning scheme is difficult to provide rapidly, scientifically and objectively, and the working efficiency and timeliness are low. For example, the conventional urban planning graphic data (DWG format) of the natural resource department has the problems of complex data and elements, symbol diversity filling, multiple geometric layers and the like, so that the difficulty of interacting with the vector data (GIS format) of the urban safety information model platform is caused, and a new technical method is needed to be explored to realize one-key lossless warehousing and ex-warehouse of the graphic data to the vector data.
Therefore, a set of data self-adaptation and management schemes are required to be designed and established, and the trigger provided by the scheme can automatically adjust the processing method, the processing sequence, the processing parameters, the boundary conditions or the constraint conditions according to the data characteristics, so that the trigger is suitable for the statistical distribution characteristics and the structural characteristics of the processed data, the data of different types are subjected to homogeneous organization, management, editing, display and the like, the requirements on various aspects such as data input and output storage, updating, format conversion, coordinate conversion and the like are met, and the problems of difficult interaction among databases and the like in the prior art are solved.
Disclosure of Invention
Aiming at the problems existing in the prior art, the invention provides a trigger-based urban safety information model platform data integration method.
In order to achieve the above purpose, the technical scheme adopted by the invention is as follows:
A trigger-based urban safety information model platform data integration method comprises the following steps: step S1: creating a database based on the trigger, wherein the created database is used as an original service library; step S2: writing into a temporary library; step S3: updating an original business library: the method comprises four trigger flows of backup, edge connection, update and writing.
Based on the above technical solution, in step S1, the database creation process includes the following steps: step S11: creating a service table and a cache table; taking the cache table as a node, and providing a node change capturing setting condition for the cache table by the service table; step S12: creating a storage table, and transmitting the data in the cache table to the storage table for storage; step S13: summarizing the data in the storage table, and directly writing the summarized data into a source end service library through a database connection function for creation and deployment; and (5) completing database creation.
Based on the above technical solution, step S2 further includes generating a frame according to the file name by combing the data change service, analyzing the table and field corresponding to the utilization change of the city safety information resource data reflected in the service, determining the data required for capturing the reflection change, converting the format data into a standard database format, and storing in a temporary database.
Based on the above technical solution, further, the step S2 is to determine the captured triggering condition and the geometric features and fields in the captured configuration file, perform format conversion on the format data, add the attribute fields, and write the attribute fields into the temporary library.
Based on the technical scheme, further, the communication between the original business library and the temporary library is ensured by geometric filtering of graphics in geometric features and adding of attribute fields, and the method comprises the following steps: 1. capturing geometrical characteristics in a configuration file of a trigger, configuring the geometrical characteristics according to the structure of a monitored table and a monitored field through a cache table and a summary table, and automatically generating the geometrical characteristics after the configuration of the trigger is completed;
2. Adding an attribute field mapping module in trigger configuration, corresponding the capture field with the data field of the submission table, and automatically adding a summary trigger in a database by a system for automatic submission after field mapping is completed;
3. And opening a data management system, extracting the data which are automatically connected to the cache table of the original business library and are changed into the temporary library, and clearing the cache table.
Based on the above technical solution, in step S3, the backup process of the original service library is as follows: the trigger copies the graph in the frame to be updated in the original service library to the backup library; if the updating fails, the original business library data is restored by using the data in the backup library, wherein the layer naming in the backup library is consistent with the original business library.
Based on the above technical solution, further, step S3, the edge connection triggering process includes edge connection of the service library; and performing edge splicing on the internally-spliced updated data and the existing data in the adjusted business library, and setting the updated time of the modified element as the latest time.
Based on the technical scheme, the service library edge connecting process comprises the steps of carrying out attribute inspection on the existing data in the updated data service library, wherein the attribute inspection is carried out by traversing an edge connecting candidate set, carrying out field coding on two edge connecting lines and surface elements meeting geometric conditions, carrying out attribute field coding one by one on the basis, and judging whether attribute field coding is consistent or not; if all the attributes meet the threshold requirement, two edge face elements are met, field codes are consistent, the attributes are reserved for the same element, the face elements and the edge lines are combined into an edge business library, otherwise, the processing is not performed, and the deleting operation is performed.
Based on the technical scheme, the process of the service library edge connection further comprises automatically hooking the graph and the attribute table by utilizing the attribute to be integrated into an update record table in a temporary library, and determining the line and the surface element needing edge connection according to the data in the range line before the update service library according to the range line before the storage; and updating the number according to the updated record list in the temporary library, and finally, inputting the data into the service library after edge splicing.
Based on the above technical scheme, further, step S3, the edge connection triggering process further includes temporary library edge connection; the temporary library edge is the updated data edge in the temporary library and is written into the adjusted business library, but is not connected with the elements in the adjusted business library.
Based on the above technical solution, further, step S3, the update process is as follows: and deleting elements intersecting with the update frames in the original business library from the original business library, cutting the corresponding elements, writing data outside the update range into the history library, writing the elements within the update range into the adjusted business library, and finally setting the update time of the modified elements as the latest time.
Compared with the prior art, the invention has the following beneficial effects:
(1) The automatic configuration trigger scheme for creating the empty database normalizes, visualizes and processes three steps of trigger configuration, so that a manager of the urban safety information model platform data can realize database link through simple batch processing, and the operations of data table design, data normalization and the like are captured, thereby improving the working efficiency.
(2) The invention generates a picture frame according to the file name by combing the data change service, analyzes the table and the field corresponding to the utilization change of the urban safety information resource data reflected in the service, determines the data required by capturing the reflection change, converts the format data such as CAD, the table and the like into a standard database format, stores the standard database format in a temporary library, verifies whether the conversion can be successfully carried out without loss, can determine the captured triggering condition and capture the geometric characteristics and the field in the configuration file through the step, carries out the format conversion on the CAD, and writes the CAD into the temporary library after adding the attribute field.
(3) The edge splicing process recorded by the invention only needs to select and set corresponding parameters: if the range data is selected, the file format is selected and exported, the attribute required to be exported is selected, the layer required to be exported is selected, the execution can be started by clicking, and the extracted database-out data can be generated according to the standard directory structure under the corresponding directory after the execution is completed, so that the database-out extraction of any range, any format, any layer and any attribute field is realized, and the timeliness, accuracy and integrity of the data are greatly improved.
(4) The invention carries out the face element edge inspection process based on the analysis of the face element edge principle and edge feature, and carries out program development on key links such as the obtained face element edge line, the connected element geometric inspection, the buffer element geometric inspection, the attribute inspection, the invalid edge result filtration, the inspection result output and the like, thereby realizing the lossless generation and restoration of the filling from a GIS library into the filling in the CAD, ensuring the consistency with the characteristics of the layer name, the line type, the filling type, the color and the like before the warehouse entry, and simultaneously, keeping the attribute as the extension data in the CAD for the exported CAD filling.
(5) The invention can automatically connect edges in the process of updating the database, and can automatically assign unique identification codes when the edge connecting elements have a plurality of drawings, and can ensure the consistency of the numbers of all the cross-frame edge connecting elements when the standard frame data is checked or converted and put in storage, thereby realizing automatic line face edge connection processing on frame and partition data and realizing automatic line face edge connection of databases such as SDE and the like in the process of updating.
(6) The invention establishes a core database based on the synchronous operation of the GIS platform and the CAD platform, establishes a unified public service interface based on the independent operation of the GIS database and the CAD database, realizes the integration of database creation and drawing data production and management, effectively solves the resource exchange and sharing of different professions, different hierarchical planning, different positions and project progress among departments and personnel, and finally realizes the interoperation.
Drawings
FIG. 1 is an overall flow chart of the method of the present invention;
FIG. 2 is a flow chart of the present invention for creating a database;
FIG. 3 is a flow chart of the write-in temporary library of the present invention;
FIG. 4 is a flowchart of a business library backup trigger of the present invention;
FIG. 5 is a flow chart of the service library update trigger of the present invention;
FIG. 6 is a flowchart of a temporary library border according to the present invention;
FIG. 7 is a flowchart of the business library border.
Detailed Description
The invention is further illustrated and described below with reference to the drawings and detailed description. The technical features of the embodiments of the invention can be combined correspondingly on the premise of no mutual conflict.
In order that the above objects, features and advantages of the invention will be readily understood, a more particular description of the invention will be rendered by reference to the appended drawings. In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention. The present invention may be embodied in many other forms than described herein and similarly modified by those skilled in the art without departing from the spirit of the invention, whereby the invention is not limited to the specific embodiments disclosed below. The technical features of the embodiments of the invention can be combined correspondingly on the premise of no mutual conflict.
Example 1
In combination with the data integration method of the urban safety information model platform based on the trigger shown in fig. 1, by supporting various formats at home and abroad, the method provides a set of data organization and management schemes based on ArcSDE, oracle, FME and other technical designs and established, can carry out homogeneous organization, management, editing, display and the like on different types of data, and completes the requirements on various aspects of data input and output, updating, format conversion, coordinate conversion and the like, wherein the biggest bright point is a CAD/GIS data change discovery mechanism driven by research service, and the method provides a technical scheme of capturing CAD and GIS utilizing change data based on the database trigger, solves the problems of difficult interaction with GIS and pain caused by complex data and elements, symbol diversity filling, various geometric layers and the like of DWG, and realizes one-key lossless input and output of CAD to a GIS database. The basic idea of the realization is as follows: the change of CAD and GIS data is carried out according to a certain business process, including the business processes of building three-library integrated management (temporary library, business library and history library), data updating and edge connection, abnormal rollback, data export and the like. Because the electronic government system corresponding to the business flow not only records the flow information, but also reflects the use change of related various data, the change can be extracted by monitoring the update of the related business database, and further the on-site investigation and dynamic update are driven; for CAD\GIS data utilization changes which occur outside services such as coordinate system transformation, format conversion, function expansion, batch processing and the like, CAD\GIS utilization changes can be found through the approaches such as toilet sheet inspection, dynamic inspection, attribute updating, filling conversion and the like, so that related services of the mechanisms can timely and automatically find the CAD\GIS utilization changes, and further drive a dynamic updating mechanism for lossless conversion of multi-format and multi-standard data and databases. The detection mechanism of database change mainly comprises a trigger, a time stamp, full table comparison, log file analysis and the like, wherein the trigger is a special type of storage process, when a specific event occurs and a specific condition is met, an active database executes processes, and the automatically executed processes are called trigger processes or triggers for short. The thinking is basically the same as other data capturing modes, and the problems of change monitoring, data caching, data transmission and the like are all related. The automatic configuration goal of the FME trigger is to automatically generate the trigger according to the service change requirement and deploy the trigger in a service library. In combination with the existing city security information resource data utilization change flow, the following steps can be implemented based on trigger configuration.
The method specifically comprises the following steps: step S1: creating a database based on the trigger, wherein the created database is used as an original service library;
In step S1, as shown in fig. 2, the database creation process includes the following steps: step S11: creating a service table and a cache table; taking the cache table as a node, and providing a node change capturing setting condition for the cache table by the service table; step S12: creating a storage table, and transmitting the data in the cache table to the storage table for storage; step S13: summarizing the data in the storage table, and directly writing the summarized data into a source end service library through a database connection function for creation and deployment; and (5) completing database creation. Specifically, the automatic configuration trigger scheme for creating the empty database normalizes, visualizes and processes three steps of trigger configuration, so that a manager of the urban safety information model platform data can realize database link, data table design and data normalization and other operations through simple batch processing. After the service personnel set the service table field and the capturing condition, the service personnel organize the service table field and the capturing condition into complete database operation sentences, and the complete database operation sentences are directly written into a source-end service library through a database connection function for creation and deployment.
Step S2: writing into a temporary library;
In step S2, referring to fig. 3, a service person may generate a frame according to a file name by combing the data change service, analyze a table and a field corresponding to the change of utilization of the city security information resource data reflected in the service, determine data required for capturing the reflection change, convert format data such as CAD and the table into a standard database format, and store the standard database format in a temporary library. And meanwhile, whether successful lossless conversion can be verified, the captured triggering condition and the geometric features and fields in the captured configuration file can be determined through the step, CAD is subjected to format conversion, and the attribute fields are added and then written into a temporary library. Further, when the urban safety information model platform management is performed, various businesses are different in requirements due to different requirements, the naming rules of the table fields in the business library are different, the same data of different units or departments can be named differently in different business systems, and in order to ensure the standardization and unification of the data formats, the method designs a set of data summarizing and submitting mechanisms through corresponding graph geometric filtering and adding attribute fields to ensure smooth communication between the business library and the temporary library, reduces the resource occupation of a trigger, and also reduces the influence on the business library, and specifically comprises the following steps: 1. capturing geometrical characteristics in a configuration file of a trigger, configuring the geometrical characteristics according to the structure of a monitored table and a monitored field through a cache table and a summary table, and automatically generating the geometrical characteristics after the configuration of the trigger is completed; 2. adding an attribute field mapping module in trigger configuration, corresponding the capture field with the data field of the submission table, and automatically adding a summary trigger in a database by a system for automatic submission after field mapping is completed; 3. and opening a data management system, extracting the data which are automatically connected to the cache table of the original business library and are changed into the temporary library, and clearing the cache table.
Step S3: updating an original business library: the method comprises four trigger flows of backup, edge connection, update and writing.
In conjunction with fig. 4, in step S3, the backup process of the original service library is as follows: the trigger copies the graph in the frame to be updated in the original service library to the backup library; if the updating fails, the original business library data is restored by using the data in the backup library, wherein the layer naming in the backup library is consistent with the original business library. The purpose of service library backup is to ensure the robustness of the data in the service library, and avoid the recovery when the system fault or the data is lost caused by unexpected situations (such as power failure and hardware problems) in the updating or writing process.
Furthermore, the purpose of the border connection of the database is to ensure the accuracy of the geographic analysis, the border connection processing is required to be carried out on the space data of the adjacent pictures in the GIS database, and the space data mainly comprises three basic geographic characteristic elements such as points, lines, polygons and the like. With reference to fig. 7, the edge triggering procedure includes a service library edge; and (3) splicing the internally spliced updated data with the existing data in the adjusted business library, and setting the updated time 'GXTIME' of the modified element as the latest time. Specifically, the process of the service library edge connection comprises the steps of carrying out attribute inspection on the existing data in the updated data service library, wherein the attribute inspection is carried out by traversing an edge connection candidate set, carrying out field coding on two edge connection lines and surface elements meeting geometric conditions (x direction, y direction and angle), carrying out attribute field coding comparison one by one on the basis, and judging whether the attribute field coding is consistent or not; if all the attributes meet the threshold requirement, two edge face elements are met, field codes are consistent, the attributes are reserved for the same element, the face elements and the edge lines are combined into an edge business library, otherwise, the processing is not performed, and the deleting operation is performed. Meanwhile, the process of the service library edge connection further comprises the step of automatically hooking and combining the graph and the attribute table into an update record table in a temporary library by utilizing the attribute, and determining the line and the surface element needing edge connection according to the data in the range line before the update in the service library before the storage according to the range line before the storage; and updating the number according to the updated record list in the temporary library, and finally, inputting the data into the service library after edge splicing. Specifically, the edge splicing triggering process also comprises temporary library edge splicing; the temporary library edge is the updated data edge in the temporary library and is written into the adjusted business library, but is not connected with the elements in the adjusted business library. In connection with fig. 6, the specific process is as follows: extracting line segments formed by continuous nodes with geometric figures of which angles of two or more continuous nodes are 0 degree (180 degrees) or 90 degrees (270 degrees) as borderline and surface elements of the elements; after the borderline of the current line element j and the plane element k is obtained, the length L j of the phase connection line, the length k j of the borderline and the angle alpha k are obtained according to the space phase connection relation, the judgment of the length ratio of the phase connection line to the borderline is carried out, if the phase connection line meets the threshold value, the two borderline elements are considered to meet the geometric condition, otherwise, the phase connection line does not meet (line element j=j+1, plane element k=k+1); the attribute inspection is to compare the codes one by one on the basis that the two borderlines and the surface elements meet the geometric conditions, and judge whether the contents of the attribute fields are consistent. If all codes are consistent, the edge connection line and the face element meet the attribute conditions, the same code line and the face are combined, the face element and the edge connection line are added into the edge connection candidate set, and otherwise, no processing is performed. In order to ensure the accuracy of the lines and the faces entering the service library, invalid edges and faces need to be filtered or deleted, firstly, the angle and the coordinate (the y-direction coordinate is taken by a horizontal angle and the x-direction coordinate is taken by a vertical angle) of one edge connecting line are selected from an edge connecting set, and the adjacent relation of the lines and the faces is judged according to the element coordinates of the edge connecting lines, so that the extraction of the adjacent lines and the faces is realized; then traversing other edge connecting lines and angles and coordinates thereof of the edge connecting set, if the angles of the other edge connecting lines are consistent with the angles of the current edge connecting lines, the distance difference value of the y-direction coordinates or the x-direction coordinates meets the requirement of a buffer zone (buffer distance >0.1 mm), considering the current edge connecting lines as effective edge connecting results, otherwise, considering the current edge connecting lines as invalid edge connecting results, and deleting the edge connecting lines and corresponding surface elements thereof from the edge connecting set; and finally, processing all the edge connecting lines in the edge connecting set, filtering invalid edge connecting results, and writing updated data edge connecting into a service library (not connecting with elements in the service library).
Further, referring to fig. 5, in step S3, the update procedure is as follows: and deleting elements intersecting with the update frames in the original business library from the original business library, cutting the corresponding elements, writing data outside the update range into the history library, writing the elements within the update range into the adjusted business library, and finally setting the update time of the modified elements as the latest time. The purpose of updating the data in the two libraries is to ensure the uniqueness of the data in the service library. The business library entering the history library is to write the business library data in the updating range into the history library data, mark the operation and the history node, and compare the history library with the business library for filing (or shifting) work in the future.
Finally, it should be noted that the above description is only for illustrating the technical solution of the present invention, and not for limiting the scope of the present invention, and that the simple modification and equivalent substitution of the technical solution of the present invention can be made by those skilled in the art without departing from the spirit and scope of the technical solution of the present invention.
Claims (7)
1. The urban safety information model platform data integration method based on the trigger is characterized by comprising the following steps of:
step S1: creating a database based on the trigger, wherein the created database is used as an original service library;
wherein, the database creation process comprises the following steps:
step S11: creating a service table and a cache table; taking the cache table as a node, and providing a node change capturing setting condition for the cache table by the service table;
Step S12: creating a storage table, and transmitting the data in the cache table to the storage table for storage;
step S13: summarizing the data in the storage table, and directly writing the summarized data into a source end service library through a database connection function for creation and deployment; completing database creation;
Step S2: writing into a temporary library;
Generating a picture frame according to the file name by combing the data change service, analyzing a table and a field corresponding to the utilization change of the urban safety information resource data reflected in the service, determining data required by capturing the reflection change, converting format data into a standard database format, and storing the standard database format in a temporary library, wherein the step S2 is used for determining the triggering condition of capturing and the geometric characteristics and the field in the capturing configuration file, converting the format data into the format, adding the attribute field, and writing the attribute field into the temporary library;
ensuring communication between the original business library and the temporary library by geometric filtering of graphics in geometric features and adding attribute fields, comprising the following procedures:
1. Capturing geometrical characteristics in a configuration file of a trigger, configuring the geometrical characteristics according to the structure of a monitored table and a monitored field through a cache table and a summary table, and automatically generating the geometrical characteristics after the configuration of the trigger is completed;
2. Adding an attribute field mapping module in trigger configuration, corresponding the capture field with the data field of the submission table, and automatically adding a summary trigger in a database by a system for automatic submission after field mapping is completed;
3. Opening a data management system, extracting the data which are automatically connected to the cache table of the original business library and are changed into a temporary library, and clearing the cache table;
Step S3: updating an original business library: the method comprises four trigger flows of backup, edge connection, update and writing.
2. The method for integrating the urban security information model platform data based on the trigger according to claim 1, wherein in step S3, the backup flow of the original service library is as follows: the trigger copies the graph in the frame to be updated in the original service library to the backup library; if the updating fails, the original business library data is restored by using the data in the backup library, wherein the layer naming in the backup library is consistent with the original business library.
3. The method for integrating the urban safety information model platform data based on the trigger according to claim 1, wherein the step S3, the edge triggering process comprises the service library edge; and performing edge splicing on the internally-spliced updated data and the existing data in the adjusted business library, and setting the updated time of the modified element as the latest time.
4. The method for integrating the urban safety information model platform data based on the trigger according to claim 3, wherein the service library edge connecting process comprises the steps of carrying out attribute check on the existing data in the updated data service library, wherein the attribute check is carried out by traversing edge connecting candidate sets, carrying out field coding on two edge connecting lines and surface elements meeting geometric conditions, carrying out attribute field coding one by one on the basis, and judging whether attribute field coding is consistent or not; if all the attributes meet the threshold requirement, two edge face elements are met, field codes are consistent, the attributes are reserved for the same element, the face elements and the edge lines are combined into an edge business library, otherwise, the processing is not performed, and the deleting operation is performed.
5. The method for integrating the urban safety information model platform data based on the trigger according to claim 3, wherein the service library edge connecting process further comprises automatically hanging and integrating the graphics and the attribute tables into an update record table in a temporary library by utilizing the attribute, and determining the line and the surface element needing edge connecting according to the data in the range line in the service library before the update before the storage according to the range line in the storage; and updating the number according to the updated record list in the temporary library, and finally, inputting the data into the service library after edge splicing.
6. The method for integrating the urban safety information model platform data based on the trigger according to claim 1, wherein the step S3, the edge triggering process further comprises a temporary library edge; the temporary library edge is the updated data edge in the temporary library and is written into the adjusted business library, but is not connected with the elements in the adjusted business library.
7. The method for integrating the urban safety information model platform data based on the trigger according to claim 1, wherein the updating process is as follows: and deleting elements intersecting with the update frames in the original business library from the original business library, cutting the corresponding elements, writing data outside the update range into the history library, writing the elements within the update range into the adjusted business library, and finally setting the update time of the modified elements as the latest time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311255389.XA CN117194384B (en) | 2023-09-26 | 2023-09-26 | Urban safety information model platform data integration method based on trigger |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311255389.XA CN117194384B (en) | 2023-09-26 | 2023-09-26 | Urban safety information model platform data integration method based on trigger |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117194384A CN117194384A (en) | 2023-12-08 |
| CN117194384B true CN117194384B (en) | 2024-06-14 |
Family
ID=88996113
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311255389.XA Active CN117194384B (en) | 2023-09-26 | 2023-09-26 | Urban safety information model platform data integration method based on trigger |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117194384B (en) |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7395258B2 (en) * | 2004-07-30 | 2008-07-01 | International Business Machines Corporation | System and method for adaptive database caching |
| CN109522365B (en) * | 2018-10-18 | 2021-06-22 | 四川大学 | Data table in information management system and field distributed access control method thereof |
| CN116049206B (en) * | 2023-01-09 | 2023-10-03 | 广东省城乡规划设计研究院有限责任公司 | Space planning business library updating method |
-
2023
- 2023-09-26 CN CN202311255389.XA patent/CN117194384B/en active Active
Non-Patent Citations (2)
| Title |
|---|
| 南京市城市规划六线"一张图"管理与动态更新研究;胡祺 等;《现代测绘》;20150331;第38卷(第2期);全文 * |
| 广州市基础地理空间数据建库及动态更新;秦亮军 等;《测绘工程》;20101031;第19卷(第5期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117194384A (en) | 2023-12-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20230274045A1 (en) | Building information modeling (bim)-based intelligent drafting method for prefabricated buildings | |
| CN106951432A (en) | BIM data light weight method and device | |
| CN111931278A (en) | Building method and system of cloud platform based on BIM and GIS cooperative work | |
| CN109933416A (en) | A kind of moving method, device and storage medium using data | |
| CN107894990A (en) | A kind of city general utility functions platform | |
| CN111639114A (en) | Distributed data fusion management system based on Internet of things platform | |
| CN114968984A (en) | Digital twin full life cycle management platform | |
| CN113656493A (en) | Method and system for constructing digital twin city multi-bank fusion | |
| CN111726403B (en) | Cross-cloud-platform big data management method and system | |
| CN113010160B (en) | Smart city scene modeling method based on SysML | |
| CN106648994A (en) | Method, equipment and system for backup operation on log | |
| CN112579563B (en) | Power grid big data-based warehouse visualization modeling system and method | |
| US20240061969A1 (en) | Bim component creating method, digital design resource library application method and device | |
| CN111667576A (en) | Method for detecting non-geometric characteristic information of four-electrical engineering component model | |
| CN112925781A (en) | Data cleaning unified method, device, equipment and medium | |
| CN110737710A (en) | Distributed data automatic structured warehousing method and system | |
| CN110889013B (en) | Data association method, device, server and storage medium based on XML | |
| CN110245037B (en) | Hive user operation behavior restoration method based on logs | |
| CN109800069B (en) | Method and device for realizing data management | |
| CN102868601B (en) | Routing system related to network topology based on graphic configuration database businesses | |
| CN117194384B (en) | Urban safety information model platform data integration method based on trigger | |
| CN115906254A (en) | Shockproof disaster reduction data management system based on digital twins | |
| CN115695458A (en) | Data storage method of BS (base station) terminal under weak network environment | |
| CN114925042A (en) | Method for constructing metadata relation based on graphic database | |
| CN111813555B (en) | Super-fusion infrastructure layered resource management system based on internet technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Country or region after: China Address after: 510290 No. 483, Nanzhou Road, Haizhu District, Guangzhou City, Guangdong Province Applicant after: Guangdong Urban and Rural Planning and Design Institute Technology Group Co.,Ltd. Address before: 510290 No. 483, Nanzhou Road, Haizhu District, Guangzhou City, Guangdong Province Applicant before: Guangdong urban and rural planning and Design Institute Co.,Ltd. Country or region before: China |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |