CN-122019914-A - Calculation method for overlapping area and overlapping rate of adjacent land parcels

CN122019914ACN 122019914 ACN122019914 ACN 122019914ACN-122019914-A

Abstract

The invention discloses a calculation method of overlapping Area and overlapping rate of adjacent plots, which comprises the following steps of S1 data preprocessing, S2 boundary recognition, S3 overlapping detection, S4 overlapping Area calculation, S5 overlapping rate calculation, calculation of the Area of two original plots polygonal geometric objects through ST_area functions, and ratio calculation of the overlapping Area and the two original plots areas to obtain the overlapping rate of the corresponding plots, and 6) result output, wherein the vectorization technology is used for converting the plots tracks into polygonal digital boundaries to obtain polygonal geometric objects corresponding to each plot, and the overlapping Area calculation, the overlapping rate of each plot and the spatial position information of the overlapping Area are output in a visual or data report form. The invention has high-efficiency calculation performance, high data processing integrity and strong system integration and expansibility.

Inventors

YU YUNFEI
YANG SHIQING

Assignees

广西泛糖科技有限公司
广西泛糖数字农业科技有限公司

Dates

Publication Date: 20260512
Application Date: 20251225

Claims (4)

1. The method for calculating the overlapping area and the overlapping rate of the adjacent land parcels is characterized by comprising the following steps of: S1, preprocessing data, namely cleaning and standardizing the obtained land parcel track data, including removing invalid data, processing missing values, denoising, unifying a coordinate system, a format and units, ensuring the consistency and the accuracy of the data, and importing the data into a MySQL database; s2, boundary identification, namely converting the land parcel track into a polygonal digital boundary by using a vectorization technology to obtain a polygonal geometric object corresponding to each land parcel; S3, overlap detection, namely calculating the shortest linear Distance between two adjacent land parcel polygonal geometric objects through an ST_distance function based on a space analysis function of a MySQL database, calculating the linear Distance between the two geometric objects by using a Euclidean Distance formula, judging that overlapping possibility exists if the Distance is 0, detecting the overlap region of the two adjacent land parcel polygonal geometric objects by adopting Boolean intersection operation and a scanning line algorithm, and generating an intersection geometric object representing the overlap region if the overlap region exists; s4, calculating the overlapping Area, namely extracting the intersection geometric object generated in the step 3), and calculating the Area of the intersection geometric object by using an ST_area function in a MySQL database, namely, the overlapping Area of the adjacent land parcels; s5, calculating the overlapping rate, namely calculating the areas of the polygonal geometric objects of the two original plots through ST_area functions, and performing ratio operation on the overlapping areas and the areas of the two original plots respectively to obtain the overlapping rate of the corresponding plots; 6) And outputting the result, namely outputting the overlapping area, the overlapping rate of each land block and the space position information of the overlapping area in the form of a visual or data report.
2. The calculation method of claim 1, wherein the data preprocessing of the step S1 specifically comprises removing repeated and abnormal invalid block data, supplementing block missing values by adopting an interpolation method, removing track acquisition noise by Gaussian filtering, uniformly converting all block data into a WGS84 geographic coordinate system, uniformly converting data formats into GeoJSON formats, and uniformly converting length units into meters and area units into square meters.
3. The method of claim 1, wherein the vectorization technique of step S2 includes the key steps of cleaning outliers of the original track of the land parcel, performing boundary fitting on the cleaned track by a least square method, converting the coordinates of the fitted track into a uniform coordinate system in step S1, and finally generating a closed land parcel polygon geometric object.
4. The method of claim 1, wherein in step S3, the scan line algorithm is used to traverse boundary vertices of two polygonal geometric objects, calculate intersection coordinates of boundary lines and sort, and construct intersection geometric objects of overlapping regions in combination with Boolean intersection operation, and simultaneously verify whether sampling points in the intersection geometric objects are located inside two original land parcel polygons simultaneously through ST_Contains functions in the MySQL database, thereby ensuring accuracy of the overlapping regions.

Description

Calculation method for overlapping area and overlapping rate of adjacent land parcels Technical Field The invention relates to the technical field of geographic information processing, in particular to a method for calculating the overlapping area and the overlapping rate of adjacent plots. Background At present, with the continuous development of technology, the measurement work of land parcels is mainly performed through satellite positioning, unmanned aerial vehicle aerial survey and the like, but the measurement performed by the means has the defect of poor accuracy, and particularly for land parcels with complex shapes and irregular boundaries, the adjacent land parcels of the type have certain overlapping areas during measurement, and certain correction is required to be performed so as to improve the measurement accuracy, and the problems of low efficiency and insufficient accuracy exist depending on manual measurement or simple geometric operation. Disclosure of Invention The invention aims to provide a calculation method for the overlapping area and the overlapping rate of adjacent plots, which aims to solve the problems in the background technology. In order to achieve the purpose, the invention provides the following technical scheme that the method for calculating the overlapping area and the overlapping rate of adjacent plots comprises the following steps: S1, preprocessing data, namely cleaning and standardizing the obtained land parcel track data, removing invalid data, processing missing values, denoising, unifying a coordinate system, a format and units, ensuring the consistency and the accuracy of the data, and importing the data into a MySQL database; s2, boundary identification, namely converting the land parcel track into a polygonal digital boundary by using a vectorization technology to obtain a polygonal geometric object corresponding to each land parcel; S3, overlap detection, namely calculating the shortest linear Distance between two adjacent land parcel polygonal geometric objects through an ST_distance function based on a space analysis function of a MySQL database, calculating the linear Distance between the two geometric objects by using a Euclidean Distance formula, judging that overlapping possibility exists if the Distance is 0, detecting the overlap region of the two adjacent land parcel polygonal geometric objects by adopting Boolean intersection operation and a scanning line algorithm, and generating an intersection geometric object representing the overlap region if the overlap region exists; s4, calculating the overlapping Area, namely extracting the intersection geometric object generated in the step 3), and calculating the Area of the intersection geometric object by using an ST_area function in a MySQL database, namely, the overlapping Area of the adjacent land parcels; s5, calculating the overlapping rate, namely calculating the areas of the polygonal geometric objects of the two original plots through ST_area functions, and performing ratio operation on the overlapping areas and the areas of the two original plots respectively to obtain the overlapping rate of the corresponding plots; 6) And outputting the result, namely outputting the overlapping area, the overlapping rate of each land block and the space position information of the overlapping area in the form of a visual or data report. The data preprocessing in the step S1 specifically includes removing repeated and abnormal invalid block data, supplementing block missing values by adopting an interpolation method, removing track acquisition noise by gaussian filtering, uniformly converting all block data into a WGS84 geographic coordinate system, uniformly converting data formats into GeoJSON formats, and uniformly converting length units into meters and area units into square meters. The vectorization technology of the step S2 comprises the key steps of cleaning abnormal points of an original track of a land block, performing boundary fitting on the cleaned track through a least square method, converting the fitted track coordinates into a unified coordinate system in the step S1, and finally generating a closed land block polygonal geometric object. In the step S3, the scan line algorithm is used to traverse boundary vertices of two polygonal geometric objects, calculate intersection coordinates of boundary lines and sequence, and construct intersection geometric objects of overlapping areas in combination with boolean intersection operation, and simultaneously verify whether sampling points in the intersection geometric objects are located inside two original land parcel polygons simultaneously through st_areas function in MySQL database, thereby ensuring accuracy of the overlapping areas. Compared with the prior art, the invention has the beneficial effects that: 1. efficient computational performance The built-in space function of the database accelerates calculation, is 30-50% faster than a self-writing