A method for real-time synchronization and database entry of survey data for integrated field and office work.

Abstract

This invention relates to the field of data processing technology, specifically to a method for real-time synchronization and database entry of survey data for integrated field and office work. On the mobile terminal side, this invention generates a change record containing new spatial coordinates, change operation type, and a unique identifier when field personnel are editing graphics. It also instantly verifies whether the new spatial coordinates are self-intersecting and consistent with the change operation type. The change record is only uploaded after both verifications pass. This avoids invalid or logically conflicting geometric data from entering the server, solving data quality problems caused by the lack of real-time verification during editing.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, specifically to a method for real-time synchronization and storage of survey data for integrated field and office work. Background Technology

[0002] Geographic surveys are widely used in complex field scenarios such as natural resource management, urban renewal, and pipeline surveys. The quality of the data results depends on the coordination and consistency of three major stages: field data collection, office editing, and database updates.

[0003] In existing technologies, such as Chinese invention patent publication number CN117094672B, an integrated cloud platform solution for pipeline network detection is disclosed. This method utilizes a data acquisition terminal integrated into a specific pipeline detector to simultaneously collect spatial information of pipeline points and attribute information of the pipeline, and uploads the data to the cloud with a single click. Internal staff then use a management terminal to organize, check, analyze, and repair the entered data.

[0004] However, in the aforementioned existing technologies, data inspection and modification are centrally processed by office staff after all field data has been uploaded, failing to perform real-time topology verification of the changed data during the initial editing phase by field staff. In other words, the lack of real-time collaborative verification between field editing changes and the existing database makes it impossible to prevent data quality issues such as spatial topology inconsistencies and network connectivity disruptions at the initial editing stage. This necessitates secondary processing by office staff after fieldwork is completed, resulting in low efficiency and susceptibility to human error. Furthermore, the lack of on-site evidence correlation and real-time verification in change records leads to insufficient data quality and traceability, making it difficult to meet the requirement that change operations in field investigations must correspond one-to-one with on-site evidence. Summary of the Invention

[0005] The purpose of this invention is to overcome the shortcomings of the prior art and solve the problems that, due to the lack of real-time collaborative verification with the existing database, data quality issues such as spatial topology contradictions and network connectivity damage cannot be prevented in the initial editing stage, and the lack of on-site evidence and real-time verification of change records leads to insufficient data quality and traceability.

[0006] The technical solution adopted by this invention to solve its technical problem is: a method for real-time synchronization and database entry of survey data for integrated field and office work, including the following steps: based on the spatial coordinates and unique identifier of the target geographic element, the mobile terminal responds to the graphic editing of the target geographic element and generates a change record containing the new spatial coordinates, change operation type and unique identifier.

[0007] The mobile terminal verifies whether the new spatial coordinates are self-intersecting and whether they are consistent with the change operation type. When both of these conditions are met, the change record is marked as transmittable and encapsulated with the associated field verification evidence data into a transaction unit for uploading.

[0008] After receiving the transaction unit, the server retrieves all existing elements spatially adjacent to the target geographic element based on the unique identifier, forms a change association set, calculates the spatial relationship between the new spatial coordinates and the elements in the change association set, and determines whether the area has no topological overlap and the network topology remains connected.

[0009] If so, the server performs data writing that matches the change operation type in the database transaction and synchronously updates the spatial adjacency relationships between elements within the change association set; after the database transaction is committed, the server generates confirmation information and sends it back to the mobile terminal.

[0010] Compared with the prior art, the present invention has the following beneficial effects: 1. On the mobile terminal side, the present invention generates a change record containing new spatial coordinates, change operation type and unique identifier when field personnel are editing graphics, and verifies in real time whether the new spatial coordinates are self-intersecting and whether they are consistent with the change operation type. The change record is only uploaded when both verifications pass; this avoids invalid or logically conflicting geometric data from entering the server and solves the data quality problem caused by the lack of real-time verification during editing.

[0011] 2. This invention encapsulates the verified change records and field verification evidence data into transaction units and uploads them synchronously. After the database transaction is successfully submitted, confirmation information is sent to the mobile terminal, thus realizing the association between change operations and on-site evidence and meeting the requirement that change operations in field investigations must correspond one-to-one with on-site evidence.

[0012] 3. After receiving the transaction unit on the server side, the present invention dynamically constructs a change association set based on the unique identifier of the target geographic element, calculates the spatial relationship between the new spatial coordinates and each element in the change association set, and determines whether the area has no topological overlap and the network topology remains connected. This realizes real-time collaborative topology verification between field changes and the existing database, preventing data quality problems such as global spatial topology contradictions or network connectivity damage caused by local editing. Attached Figure Description

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

[0014] Figure 1 This is a schematic diagram of the synchronous data entry method of the present invention.

[0015] Figure 2 This is a schematic diagram of the process for generating change records according to the present invention.

[0016] Figure 3 This is a schematic diagram of the process for verifying whether new spatial coordinates are self-intersecting in this invention.

[0017] Figure 4 This is a flowchart illustrating the process of verifying whether the new spatial coordinates are consistent with the change operation type in this invention. Detailed Implementation

[0018] Various exemplary embodiments of the present invention will now be described in detail with reference to the accompanying drawings. It should be noted that, unless otherwise specifically stated, the relative arrangement, numerical expressions, and values ​​of the components and steps set forth in these embodiments do not limit the scope of the invention. Furthermore, it should be understood that, for ease of description, the dimensions of the various parts shown in the drawings are not drawn to actual scale.

[0019] The following description of at least one exemplary embodiment is merely illustrative and is in no way intended to limit the invention or its application or use. Techniques, methods, and apparatus known to those skilled in the art may not be discussed in detail, but where appropriate, such techniques, methods, and apparatus should be considered part of the specification.

[0020] In all examples shown and discussed herein, any specific values ​​should be interpreted as merely exemplary and not as limitations. Therefore, other examples of exemplary embodiments may have different values.

[0021] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention pertains.

[0022] The following description, in conjunction with the accompanying drawings, details a specific scheme for a method of real-time synchronous data entry into the database for integrated field and office work provided by the present invention.

[0023] Please see Figure 1 The diagram illustrates a flowchart of a method for real-time synchronization and database entry of survey data for integrated field and office work, provided by the present invention. The method specifically includes the following steps: Please refer to... Figure 2 Step S1: Based on the spatial coordinates and unique identifier of the target geographic feature, the mobile terminal responds to the graphic editing of the target geographic feature and generates a change record.

[0024] The mobile terminal mentioned here refers to a portable computing device with touch input, positioning module, network communication and local storage capabilities, which runs field survey applications to load geographic features, collect on-site data and perform graphic editing operations.

[0025] When field personnel make graphic modifications to a certain element, they must accurately identify the element based on its unique identifier and obtain its original spatial coordinates as the editing reference, so that the changed content corresponds to the correct object in the database and avoids data misalignment due to element confusion.

[0026] The change record contains the new spatial coordinates, the change operation type, and a unique identifier. Its generation process mainly includes the following three steps.

[0027] Step S10: Generate new spatial coordinates. Specifically, when field personnel edit the graphic area of ​​the target geographic feature on the mobile terminal screen, the movement of the touch point is continuously tracked to form an editing touch path; the editing touch path directly reflects the field personnel's intention to adjust the geometry of the feature, and it is expressed as a sequence of screen pixel coordinates.

[0028] Among them, the graphic region refers to the two-dimensional planar area enclosed by closed boundary lines that the target geographic feature is displayed on the mobile terminal map interface. It is used to represent geographic entities with area attributes and is stored in the form of an ordered vertex coordinate sequence in this invention.

[0029] To convert the edited touch path into geographically meaningful coordinates, it is necessary to directly obtain the coordinate reference system and display scale of the current map from the metadata of the electronic map loaded on the mobile terminal. The coordinate reference system defines the spatial coordinate system used by the map, while the display scale defines the conversion relationship between the current screen pixels and the actual ground distance.

[0030] Next, based on the coordinate reference system and the display scale, the screen pixel coordinate sequence is converted into a geodetic coordinate sequence. This coordinate conversion process is existing technology and will not be described in detail here.

[0031] Then, for each coordinate point in the geodetic coordinate sequence, find the two consecutive original vertices that are closest to that coordinate point in the original region boundary coordinate sequence and associate them.

[0032] If the original region degenerates into points or lines, making it impossible to find the two consecutive original vertices with the closest Euclidean distance, then the corresponding coordinate point is associated with the single original vertex with the closest Euclidean distance on the boundary of the original region, and the adjacent vertices of the single original vertex form a virtual continuous pair; if the number of vertices in the original region is less than two, then the association step is skipped and the subsequent judgment is directly entered.

[0033] Subsequently, two consecutive original vertices are connected in order of their coordinate sequence in the original region boundary to form an original boundary line segment. A buffer is then constructed using the original boundary line segment as the central axis and its width as a preset tolerance value.

[0034] If the current coordinate point falls within the buffer zone, it indicates that its position has not exceeded the original region boundary. Its movement may be due to touch jitter or fine-tuning, and has not substantially changed the shape of the target geographic feature. In this case, to avoid generating redundant and meaningless coordinate points, the coordinate point is discarded.

[0035] If the current coordinate point does not fall within the buffer, it indicates that its position has deviated from the original region boundary, representing valid shape editing, and therefore it is preserved.

[0036] After traversing the geodetic coordinate sequence, all the retained coordinate points are combined according to their order in the geodetic coordinate sequence to obtain a new set of spatial coordinates that constitute the boundary of the new region.

[0037] When the number of retained coordinate points is less than the minimum number of vertices required to form a valid polygon, a new spatial coordinate system is generated by interpolating the retained coordinate points from the original region boundary coordinate sequence and the geodetic coordinate sequence. A valid polygon is defined as a closed simple figure with a non-zero area formed by sequentially connecting at least three non-collinear vertices.

[0038] In this invention, the preset tolerance value can be twice the real-time positioning accuracy of the mobile terminal. The real-time positioning accuracy of the mobile terminal can be obtained from the technical specifications of the mobile terminal's built-in positioning module; for example, sub-meter accuracy can be set to 0.5 meters. If the current environment is severely obstructed by satellite signals (such as indoors or in dense forest), the positioning accuracy will decrease. In this case, the preset tolerance value can be increased to three times the real-time positioning accuracy of the mobile terminal.

[0039] Step S11: Determine the change operation type. Specifically, based on the original region boundary coordinate sequence, calculate the original region area using the Gaussian area formula. Then, calculate the sum of the Euclidean distances between adjacent vertices in the original region boundary coordinate sequence to obtain the total length of the original boundary.

[0040] The specific form of the Gaussian area formula is as follows: .

[0041] Where S is the area of ​​the original region; n is the total number of vertices in the coordinate sequence of the original region boundary, n≥3, and by convention... = and = To achieve a closed loop; i is the vertex index, with a value range of 1, 2, ..., n; , Represents the x-coordinate and y-coordinate of the i-th vertex.

[0042] Based on the above calculation process of the original area and the total length of the original boundary, the new area and the total length of the new boundary are calculated similarly based on a set of new spatial coordinate sequences.

[0043] Next, the absolute value of the difference between the new region area and the original region area is divided by the original region area to obtain the area change rate. The area change rate characterizes the degree of relative change in the feature area caused by the editing operation.

[0044] Simultaneously, the shape coefficient of the original region boundary is obtained by dividing the area of ​​the original region by the square of the total length of the original boundary; similarly, the shape coefficient of the new region boundary is obtained based on the area of ​​the new region and the total length of the new boundary. The shape coefficient is a dimensionless number used to characterize the compactness or shape complexity of the region.

[0045] Then, the difference in shape coefficients between the new region boundary and the original region boundary is divided by the shape coefficient of the original region boundary to obtain the relative rate of change. The relative rate of change characterizes the degree of relative change in shape compactness caused by the editing operation.

[0046] Next, calculate the Euclidean norm of the area change rate and the relative change rate, which is to calculate the sum of the squares of the area change rate and the relative change rate, and then take the square root; the result is taken as the deformation amplitude. The deformation amplitude comprehensively measures the overall degree of change in area and shape.

[0047] Subsequently, all vertices of the original region are traversed. For any three non-collinear vertices, the radius of their circumcircle is calculated; for any two vertices, half their Euclidean distance is calculated to obtain the half-distance. The minimum positive value among all circumcircle radii and half-distances is taken as the minimum circumcircle radius of the original region of the target geographic feature. The minimum circumcircle radius is compared with the preset coordinate acquisition accuracy value to obtain the deformation limit.

[0048] If the deformation amplitude is less than or equal to the deformation limit, it indicates that the geometric change caused by this editing operation may be a minor adjustment or a correction within the error range; at this time, a change operation type is generated.

[0049] One type of change operation refers to the operation type code that represents fine-tuning or small-scale correction, such as boundary smoothing or local correction operations.

[0050] If the deformation exceeds the deformation limit, it indicates that the geometric changes caused by this editing operation may constitute a substantial modification or re-delineation of the target geographic feature; in this case, a second type of change operation is generated.

[0051] Type II change operation refers to operation type codes that represent re-delineation or substantial modification, such as region merging, splitting, or overall redrawing operations.

[0052] In this invention, the coordinate acquisition accuracy can be 0.3 meters. If the survey category field in the current task configuration file read by the mobile terminal is real estate surveying, the coordinate acquisition accuracy can be set to 0.1 meters; if the survey category field is resource census, the coordinate acquisition accuracy can be set to 0.5 meters; for other categories, the coordinate acquisition accuracy remains at 0.3 meters.

[0053] Step S12: Obtain the unique identifier of the target geographic feature from the data set containing all geographic feature attributes (such as feature ID, name, category, etc.) stored locally on the mobile terminal. The unique identifier is the corresponding field.

[0054] Step S2: Verify whether the new spatial coordinates are self-intersecting and consistent with the change operation type. Based on the verification results, and using the change record and associated field verification evidence data, form a transaction unit for uploading.

[0055] Please see Figure 3 In step S20, the new spatial coordinates are checked for self-intersection. This ensures that the newly generated geometry is a topologically valid simple polygon.

[0056] The specific process is as follows: First, connect a set of the new spatial coordinates in order to form a closed polygonal loop.

[0057] Since edges that are adjacent or share vertices intersect at the vertices of a polygon are considered normal connections and do not constitute self-intersections, we traverse all edges in the closed polygonal ring and check if any two edges that are neither adjacent nor share vertices intersect internally. Intersection points can be detected using a line segment intersection detection algorithm.

[0058] If the coordinates exist, it indicates that the newly generated geometry is invalid, and the new spatial coordinates are determined to be self-intersecting, resulting in a failed validation. If the coordinates do not exist, the new spatial coordinates are determined to be non-self-intersecting, and the validation passes.

[0059] Please see Figure 4 Step S21: Verify whether the new spatial coordinates are consistent with the change operation type. This ensures that the change operation type in the change record semantically matches the geometric changes calculated from the coordinates.

[0060] The specific process is as follows: If the change record contains a type of change operation, it is necessary to further determine the relationship between the deformation amplitude and zero. This is because a type of change operation corresponds to fine-tuning or small-range correction, which should theoretically produce a non-zero geometric change.

[0061] When the deformation amplitude is greater than zero, it indicates that a small but effective geometric adjustment has indeed occurred. Therefore, the new spatial coordinates are determined to be consistent with the change operation type, and the verification passes.

[0062] When the deformation amplitude is zero, it indicates that the new spatial coordinates have not actually changed, which contradicts the principle of fine-tuning or small-scale correction. Therefore, the new spatial coordinates are determined to be inconsistent with the change operation type, and the verification fails.

[0063] If the change record contains a type II change operation, it is necessary to further determine whether the new spatial coordinates are the same as the original region boundary coordinate sequence. This is because type II change operations correspond to re-delineation or substantial modification.

[0064] If they are the same, it indicates that the new spatial coordinates have not actually changed. Therefore, the new spatial coordinates are determined to be inconsistent with the change operation type, and the verification fails.

[0065] If they are different, it indicates that the new spatial coordinates have changed. Therefore, the new spatial coordinates are determined to be consistent with the change operation type, and the verification passes.

[0066] Step S22: When both checks on whether the new spatial coordinates are self-intersecting and whether they are consistent with the change operation type pass, the mobile terminal marks the change record as transmittable.

[0067] Next, based on the requirement that changes made during field investigations must correspond one-to-one with on-site evidence, the transmittable change records and associated field verification evidence data are encapsulated into transaction units to facilitate data auditing and backtracking. The encapsulated transaction units are then uploaded to the server via a wireless network.

[0068] Among them, field verification evidence data refers to supporting materials that support this graphic editing, such as photos, videos, audio recordings, or completed attribute forms taken on-site. This data is acquired through sensing devices such as mobile terminal cameras and microphones and is linked to change records using unique element identifiers.

[0069] If both checks for self-intersection of the new spatial coordinates and consistency with the change operation type fail, the change record will be marked as failed. The mobile terminal will then notify the field personnel that the edit is invalid and provide options to re-edit or abandon the edit.

[0070] Step S3: After receiving the transaction unit, the server forms a change association set, calculates the spatial relationship between the new spatial coordinates and the elements in the change association set, and determines whether the surface region has no topological overlap and the network topology remains connected.

[0071] Considering that editing a single target geographic feature may affect its topological relationships with surrounding features, such as adjacency, contiguousness, and overlap, updating only the target geographic feature itself without considering its spatial adjacency may result in geometric overlaps, gaps, or disruption of the original connectivity network in the updated dataset.

[0072] Step S30: Based on the unique identifier, retrieve all existing elements spatially adjacent to the target geographic element to form a change association set.

[0073] The specific process is as follows: A circular region is generated with each coordinate point in the original region boundary coordinate sequence as the center and a preset adjacency distance as the radius. All circular regions are treated as geometric objects, and a Union operation is performed to calculate their union, resulting in a composite polygon region that may contain multiple connected components, which serves as the query range.

[0074] Then, in the local database containing the spatial coordinates and attributes of all geographic features stored on the server, using the query range as the query window, all existing features that are in the same layer as the target geographic feature and spatially intersect with it are retrieved.

[0075] Spatial intersection refers to the non-empty intersection between the geometric boundaries or internal regions of existing elements and the query range, that is, the two overlap or contact each other in space.

[0076] Subsequently, based on the original area boundary coordinate sequence of the target geographic feature, the boundary distance and overlap relationship between it and the spatial coordinates of each existing feature are calculated.

[0077] Specifically, the minimum Euclidean distance between the original region boundary and the region formed by the spatial coordinates of the existing features is calculated separately. Simultaneously, the Weiler-Atherton clipping algorithm, commonly used in computational geometry, is employed to calculate the intersection area of ​​their geometries; the calculation process is existing technology and will not be elaborated further.

[0078] If both the minimum Euclidean distance and the intersection area are zero, it indicates that the boundary of the existing feature is in contact with or shares a boundary segment with the original area boundary of the target geographic feature, and their internal regions do not overlap. Therefore, the existing feature is determined to be spatially adjacent to the target geographic feature.

[0079] If the minimum Euclidean distance is greater than zero (indicating that there is a separation of regions), or the intersection area is greater than zero (indicating that there is an internal overlap), then it is not determined to be spatially adjacent.

[0080] Finally, the unique identifiers and spatial coordinates of all existing elements that are determined to be spatially adjacent are combined to form a change association set.

[0081] In this invention, the preset adjacency distance can be 10 meters. If the density level field in the metadata of the layer to which the target geographic feature belongs, read by the server, is high, then the preset adjacency distance is set to 5 meters; if the density level field is low, then the preset adjacency distance can be set to 20 meters; otherwise, the preset adjacency distance remains at 10 meters.

[0082] Step S31: Calculate the spatial relationship between the new spatial coordinates and each element in the change association set.

[0083] The specific process is as follows: A set of new spatial coordinates is used as a vertex list. The first and last vertices are connected sequentially, and a polygonal geometric object is constructed in the server's runtime memory as a new graphical region. Similarly, based on the spatial coordinates of each element in the modified association set, the corresponding adjacent graphical regions are constructed.

[0084] Then, perform pairwise intersection calculations on all boundary segments of each adjacent graphic region and all boundary segments of the new graphic region.

[0085] The intersection calculation can be performed using a line segment intersection judgment algorithm. Specifically, for two boundary line segments, the intersection point is solved by parametric equations. If an intersection point exists and all intersection point parameters are within the interval [0, 1], then the coordinates of the intersection point are recorded; otherwise, the coordinates of the intersection point are not recorded.

[0086] If two boundary segments have one and only one intersection point, and that intersection point is not a common endpoint of the two segments, then that intersection point is recorded as the contact point. If two boundary segments partially or completely overlap, then the overlapping portion is recorded as a shared boundary segment.

[0087] All contact points and shared boundary segments are gathered to form a set of geometric intersections between the new graphic region and its corresponding adjacent graphic regions.

[0088] Step S32: Determine whether the surface region has no topological overlap; this ensures data uniqueness.

[0089] The specific process is as follows: For a set of geometric intersections between the new graphic region and each adjacent graphic region, when the geometric intersection is empty, it indicates that the new graphic region is completely separated from the corresponding adjacent graphic region, with no boundary contact or internal overlap. Therefore, it is determined that the region has no topological overlap.

[0090] When the geometric intersection is not empty, it is necessary to further determine whether the geometric intersection consists only of the boundary segments or contact points shared by the new graphic region and the corresponding adjacent graphic regions, and whether their internal regions do not overlap. This is because, in the topology rules, shared boundaries or contact only at boundary points between regions are allowed adjacency relationships and are not considered violations of the non-overlapping rule; only when the internal regions overlap will it be considered a topology error.

[0091] If yes, then the surface region is determined to have no topological overlap; otherwise, it is determined to have no topological overlap.

[0092] Step S33: Determine whether the network topology remains connected. This ensures the integrity of the spatial network functions.

[0093] The network topology here refers to a topological graph consisting of a target geographic feature and all its spatially adjacent features as nodes, and shared boundaries or contact relationships between features as edges.

[0094] The specific process is as follows: on the basis of ensuring that the surface regions have no topological overlap, the new graphic surface region and each adjacent graphic surface region are used as network nodes.

[0095] If any two network nodes represent graph regions that are in contact with each other or share boundary segments, but their internal regions do not overlap, then a connecting edge is constructed between them. This means creating a graph data structure in the server's runtime memory and adding an undirected edge record for these two network nodes.

[0096] Otherwise, no connection edge is built between the two; thereafter, the remaining network nodes are processed until all network nodes have completed their judgments.

[0097] Then, all network nodes are treated as a vertex set, and all connecting edges are treated as an edge set, ultimately forming an undirected graph. Subsequently, a graph traversal algorithm is used to check whether the undirected graph is a connected graph.

[0098] Specifically, starting from any network node, perform a depth-first search or a breadth-first search to mark all reachable network nodes. After the traversal, if all network nodes have been marked, the undirected graph is a connected graph; otherwise, the undirected graph is a disconnected graph.

[0099] If the undirected graph is connected, it means that the editing did not disrupt the connectivity of the network topology, therefore the network topology is considered to remain connected. Otherwise, the network topology is considered not to remain connected.

[0100] Step S4: When it is determined that the area has no topological overlap and the network topology remains connected, the server performs data writing in the database transaction that matches the change operation type.

[0101] Specifically, the data writing includes: 1) For a type of change operation, the server executes an UPDATE statement in the database transaction to update the spatial coordinate field of the target geographic feature to the new spatial coordinate, and inserts a record containing the old coordinate, new coordinate, deformation magnitude and timestamp into the feature version table.

[0102] 2) For the second type of change operation, in addition to updating the spatial coordinate field, the server also needs to insert a record in the feature operation log table with the type identifier as re-delineation or substantial modification.

[0103] Simultaneously, the spatial adjacency relationships between elements within the association set are updated and changed. For example, based on the geometric intersection results between the new graphic region obtained in step S31 and each adjacent graphic region, the Euclidean distance between the first and last vertices of the recorded overlapping boundary parts is calculated and accumulated to obtain the total length of the shared boundary, and the coordinates of all contact points are extracted to form a coordinate string.

[0104] Subsequently, in the spatial adjacency table maintained on the server, the shared boundary length and contact point coordinate string fields are updated or inserted using the unique identifier of each element in the target geographic feature and the change association set as the key.

[0105] Step S5: After the database transaction is committed, the server generates confirmation information and sends it back to the mobile terminal.

[0106] Confirmation messages are digital messages that include the processing result status (e.g., success), the unique identifier of the target geographic feature, the editing operation result status (e.g., updated), timestamp, and transaction ID. Confirmation messages are generated by constructing JSON format messages.

[0107] The server sends the confirmation information back to the mobile terminal that initiated the edit via the network to maintain the consistency of data status between the office and field, and to enable the mobile terminal to update its local cache or interface status accordingly.

[0108] If the database transaction is successfully committed, the confirmation message generated by the server will show a successful processing status. After receiving the confirmation message, the mobile terminal will clear the corresponding local records to be transmitted.

[0109] If a database transaction fails to commit, the server-generated confirmation message will indicate a failure status and include an error code; the server will also log the failed database transaction in the system log. The mobile application, based on its pre-configured failure handling strategy (such as always waiting for user instructions), will display the operation failure message to the field personnel on the interface and provide options to resubmit or abandon the current edit.

[0110] The above embodiments can be implemented, in whole or in part, by software, hardware, firmware, or any other combination thereof. When implemented in software, the above embodiments can be implemented, in whole or in part, as a computer program product.

[0111] Those skilled in the art will recognize that the modules and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementations should not be considered beyond the scope of this invention.

[0112] In addition, the functional modules in the various embodiments of the present invention can be integrated into one processing module, or each module can exist physically separately, or two or more modules can be integrated into one module.

[0113] The above description is merely a specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the technical scope disclosed in the present invention should be included within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.

[0114] Finally, the above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the protection scope of the present invention.

Claims

1. A method for real-time synchronization and database entry of survey data for integrated field and office work, characterized in that, Includes the following steps: Based on the spatial coordinates and unique identifier of the target geographic feature, the mobile terminal responds to the graphic editing of the target geographic feature and generates a change record containing the new spatial coordinates, change operation type and unique identifier. The mobile terminal verifies whether the new spatial coordinates are self-intersecting and whether they are consistent with the change operation type. When both of them pass, the change record is marked as transmittable and encapsulated with the associated field verification evidence data into a transaction unit for uploading. After receiving the transaction unit, the server retrieves all existing elements that are spatially adjacent to the target geographic element based on the unique identifier, forms a change association set, calculates the spatial relationship between the new spatial coordinates and each element in the change association set, and determines whether the area has no topological overlap and the network topology remains connected. If so, the server performs data writing that matches the change operation type in the database transaction and synchronously updates the spatial adjacency relationships between elements within the change association set; After the database transaction is committed, the server generates a confirmation message and sends it to the mobile terminal. The process for generating change records is as follows: A new set of spatial coordinates is generated based on the touch path of the graphic area of ​​the target geographic feature; Based on a set of new spatial coordinates and the original area boundary coordinate sequence of the target geographic elements, the area change rate, as well as the shape coefficients of the new area boundary and the original area boundary, are calculated. The relative rate of change is obtained by dividing the difference in shape coefficients between the new region boundary and the original region boundary by the shape coefficient of the original region boundary. Calculate the Euclidean norm of the rate of change of area and the rate of change of relative change as the deformation amplitude; The deformation limit is obtained by comparing the minimum circumscribed circle radius of the original area of ​​the target geographic feature with the preset coordinate acquisition accuracy value. If the deformation range is less than or equal to the deformation limit, a type 1 change operation is generated; otherwise, a type 2 change operation is generated. Obtain the unique identifier of the target geographic feature from the attribute data source; A change record is formed by combining a set of new spatial coordinates, a unique identifier, and either a type I or a type II change operation.

2. The method for real-time synchronization and database entry of survey data for integrated field and office work, as described in claim 1, is characterized in that... The specific process of generating new spatial coordinates is as follows: When editing the graphical area of ​​a target geographic feature, the system continuously tracks the movement of touch points to form an editing touch path; Based on the current map's coordinate reference system and display scale, the screen pixel coordinate sequence for editing the touch path is converted into a geodetic coordinate sequence; Associate each coordinate point in the geodetic coordinate sequence with the two closest consecutive original vertices in the original area boundary coordinate sequence of the target geographic feature; Construct a buffer zone with the original boundary line segment defined by two consecutive original vertices as the central axis and the width as the preset tolerance value; If the current coordinates fall within the buffer, they are discarded; otherwise, they are retained. After traversing the geodetic coordinate sequence, all the retained coordinate points are combined in chronological order to obtain a new set of spatial coordinates.

3. The method for real-time synchronization and database entry of survey data for integrated field and office work, as described in claim 1, is characterized in that... The calculation process for the area change rate and shape factor is as follows: Based on the original region boundary coordinate sequence, calculate the original region area and the original boundary total length; based on a new set of spatial coordinate sequences, calculate the new region area and the new boundary total length. The area change rate is obtained by dividing the absolute value of the difference between the new area and the original area by the original area. Divide the original region area by the square of the original boundary length to obtain the shape coefficient of the original region boundary; similarly, obtain the shape coefficient of the new region boundary based on the new region area and the new boundary length.

4. The method for real-time synchronization and database entry of survey data for integrated field and office work, as described in claim 1, is characterized in that... The process of verifying whether the new spatial coordinates are self-intersecting is as follows: Connect the set of the new spatial coordinates in their order to form a closed polygonal loop; Check if there are any two edges in a closed polygonal ring that are neither adjacent nor share vertices and intersect internally; If they exist, the new spatial coordinates are determined to be self-intersecting, and the verification fails; if they do not exist, the new spatial coordinates are determined to be non-self-intersecting, and the verification passes.

5. The method for real-time synchronization and database entry of survey data for integrated field and office work according to claim 1, characterized in that, The process of verifying whether the new spatial coordinates are consistent with the change operation type is as follows: If the change record contains a type of change operation, then when the deformation amplitude is greater than zero, the new spatial coordinates are determined to be consistent with the change operation type, and the verification passes; when the deformation amplitude is equal to zero, the new spatial coordinates are determined to be inconsistent with the change operation type, and the verification fails. If the change record contains a type II change operation, then it is determined whether the new spatial coordinates are the same as the original region boundary coordinate sequence; if so, it is determined that the new spatial coordinates are inconsistent with the change operation type, and the verification fails; otherwise, it is determined that the new spatial coordinates are consistent with the change operation type, and the verification passes.

6. The method for real-time synchronization and database entry of survey data for integrated field and office work according to claim 1, characterized in that, The process of forming a modified association set is as follows: Using each coordinate point in the original region boundary coordinate sequence as the center, a circular region is generated with a preset adjacency distance as the radius. Then, all circular regions are geometrically merged to form the query range. In the local storage on the server containing the spatial coordinates and attributes of all geographic features, the query scope is used as the query window to retrieve all existing features that are in the same layer as the target geographic feature and spatially intersect with it. Based on the original area boundary coordinate sequence of the target geographic feature, calculate the boundary distance and overlap relationship between it and the spatial coordinates of each existing feature. If the calculation results show that the boundary of the existing feature is in contact with or shares the boundary segment with the original area boundary of the target geographic feature, and the internal areas of the two do not overlap, then it is determined to be spatially adjacent. Otherwise, it is not considered spatially adjacent; The unique identifiers and spatial coordinates of all existing elements that are determined to be spatially adjacent are combined to form a change association set.

7. The method for real-time synchronization and database entry of survey data for integrated field and office work according to claim 1, characterized in that, Calculate the spatial relationship between the new spatial coordinates and each element in the change association set, specifically as follows: A new graphical region is established using the new set of spatial coordinates as boundaries; a corresponding adjacent graphical region is established using the spatial coordinates of each element in the change association set as boundaries. Perform pairwise intersection calculations on all boundary segments of each adjacent graphic region and all boundary segments of the new graphic region, and generate the corresponding geometric intersection based on the intersection results.

8. A method for real-time synchronization and database entry of survey data for integrated field and office work, as described in claim 7, is characterized in that... The process of determining whether a region satisfies the condition of no topological overlap is as follows: For a set of geometric intersections between a new graphic region and each adjacent graphic region, if the geometric intersection is empty, it is determined that the regions have no topological overlap. When the geometric intersection is not empty, determine whether the geometric intersection is only the boundary line segment or contact point shared by the new graphic region and the corresponding adjacent graphic region, and whether the internal regions of the two do not overlap. If yes, then the surface region is determined to have no topological overlap; otherwise, it is determined to have no topological overlap.

9. A method for real-time synchronization and database entry of survey data for integrated field and office work, as described in claim 1 or 7, characterized in that: The process of determining whether the network topology remains connected is as follows: Based on the premise that there is no topological overlap between the regions, the new graphic region and each adjacent graphic region are used as network nodes; If any two network nodes represent graphical regions that are in contact with each other or share a boundary line segment, but their internal regions do not overlap, then a connecting edge is constructed between them; otherwise, no connecting edge is constructed between them. Construct an undirected graph based on all network nodes and connecting edges; check whether the undirected graph is a connected graph using a graph traversal algorithm. If yes, then the network topology is determined to remain connected; otherwise, the network topology is determined to remain disconnected.

Images