A database-based spatial conflict management method, device and medium

Abstract

The application discloses a kind of space conflict governance methods, equipment and medium based on database, it is related to electric digital data processing technical field.The method includes: according to the geometric relation between the space graph spot corresponding to planning land in spatial database, by the space analysis function of preestablished, determine the conflict spot of each space graph spot existing conflict;The space relationship and right ownership planning relationship corresponding to conflict spot are analyzed to determine the conflict intensity corresponding to each conflict spot;Based on spatial relationship network, according to conflict intensity, determine the hotspot conflict area existing spatial clustering;According to the descending order of conflict intensity, determine the governance priority of conflict spot corresponding, and according to the conflict linkage path between each conflict spot in hotspot conflict area, adjust the governance priority of conflict spot;Through adjusted governance priority, generate spatial governance path in hotspot conflict area, to realize the spatial conflict governance of planning land through spatial governance path.

Description

Technical Field

[0001] The present invention relates to the technical field of electronic digital data processing, and in particular to a database-based spatial conflict management method, device and medium. Background Art

[0002] With the widespread application of GIS technology in urban planning and land management, spatial conflict identification technology has become relatively mature. This technology primarily uses spatial analysis to identify overlaps and contradictions between patches, combining both spatial and non-spatial attributes to aid management. However, existing technologies often rely on single indicators such as area and location, or manual experience, to statically rank conflict patches. This fails to fully reflect the urgency and importance of conflict patch management and struggles to dynamically adapt to changes in conflict status, resulting in inefficient governance and ineffective decision-making. Summary of the Invention

[0003] In order to solve the above problems, the present invention proposes a database-based spatial conflict management method, comprising:

[0004] Determining conflicting patches among the spatial patches according to the geometric relationship between the spatial patches corresponding to the planned land in the spatial database by using a preset spatial analysis function;

[0005] Analyze the spatial relationship and ownership planning relationship corresponding to the conflict patches to determine the conflict intensity corresponding to each conflict patch;

[0006] Constructing a spatial relationship network based on the spatial distribution of the plurality of conflict patches, and determining, based on the spatial relationship network and according to the conflict intensity, hotspot conflict areas with spatial agglomeration;

[0007] Determine the governance priority corresponding to the conflict patches according to the descending order of the conflict intensity, and adjust the governance priority of the conflict patches according to the conflict linkage paths between the conflict patches in the hotspot conflict area;

[0008] Through the adjusted governance priority, a spatial governance path within the hotspot conflict area is generated, so as to achieve spatial conflict governance of the planned land through the spatial governance path.

[0009] In one implementation of the present invention, determining conflicting patches among the spatial patches according to the geometric relationship between the spatial patches corresponding to the planned land in the spatial database specifically includes:

[0010] Determine whether there is a potential conflict between the spatial patches according to whether there is geometric overlap between the spatial patches corresponding to the planned land in the spatial database and whether the safety distances corresponding to the spatial patches meet a preset distance threshold;

[0011] If so, the spatial patch is determined to be a potential conflict patch, and whether the potential conflict patch is a conflict patch with a real conflict is determined based on the spatial overlap information and patch attributes corresponding to the potential conflict patch.

[0012] In one implementation of the present invention, determining whether the potential conflict patch is a conflict patch with a real conflict based on the spatial overlap information and patch attributes corresponding to the potential conflict patch specifically includes:

[0013] Determining spatial overlap information corresponding to the potential conflicting patches; wherein the spatial overlap information includes a spatial overlap position and a spatial overlap area;

[0014] Determine whether the spatial overlap position is located at an edge position of the potential conflict patch and whether the spatial overlap area is smaller than a preset area;

[0015] If not, judging whether the potential conflicting patch has attribute conflict according to the patch attribute corresponding to the potential conflicting patch;

[0016] If so, the potential conflict patch is determined to be a conflict patch.

[0017] In one implementation of the present invention, the spatial relationship and ownership planning relationship corresponding to the conflict patches are analyzed to determine the conflict intensity corresponding to each conflict patch, specifically including:

[0018] Determining a spatial sensitivity factor value according to the distance between the conflicting patch and the sensitive boundary;

[0019] Determine the ownership units and planned land use types corresponding to the conflicting patches, and determine the governance complexity factor value based on the number of ownership units and the number of overlapping planning types;

[0020] Determine the responsibility attribution clarity factor value based on the level of the responsible unit to which the conflict patch belongs and the supervision intensity corresponding to the level of the responsible unit; wherein the supervision intensity is used to represent the annual law enforcement frequency of the responsible unit;

[0021] Determining a planning adaptation conflict factor value based on the degree of adaptation between the conflicting pattern and the upper-level planning of the spatial area in which it is located;

[0022] Determining a timeliness trend factor value according to the rectification response time of the conflicting pattern;

[0023] The conflict intensity corresponding to each conflict patch is determined based on the spatial sensitivity factor value, the governance complexity factor value, the responsibility clarity factor value, the planning adaptation conflict factor value, and the timeliness trend factor value.

[0024] In one implementation of the present invention, based on the spatial relationship network, determining the hotspot conflict areas with spatial agglomeration according to the conflict intensity specifically includes:

[0025] Calculating the mean of the conflict intensities corresponding to the conflict patches in the spatial relationship network;

[0026] For each conflicting patch, based on the adjacency relationship between the conflicting patch and its corresponding adjacent conflicting patches and the mean, calculate the conflict intensity corresponding to the patch area formed by the conflicting patch and its adjacent conflicting patches, and the degree of collaborative deviation from the mean; wherein the degree of collaborative deviation reflects the deviation relationship between the conflict intensity of the patch area and the mean;

[0027] According to the degree of collaborative deviation, a hot spot conflict area with spatial agglomeration in the spatial relationship network is determined.

[0028] In one implementation of the present invention, determining, based on the degree of collaborative deviation, hotspot conflict areas with spatial agglomeration in the spatial relationship network specifically includes:

[0029] Determining whether the degree of collaborative deviation is greater than 0;

[0030] If so, the conflict spot and the adjacent conflict spots have conflict intensities greater than a preset intensity, and the conflict spot area is regarded as a hot spot conflict area;

[0031] The degree of cooperative deviation between each conflicting patch and its adjacent conflicting patches is repeatedly calculated until all hotspot conflict areas in the spatial relationship network are screened out.

[0032] In one implementation of the present invention, the governance priority of the conflict patches is adjusted according to the conflict linkage paths between the conflict patches in the hotspot conflict area, specifically including:

[0033] Determining a governance scenario corresponding to each conflict patch in the hotspot conflict area, and determining a conflict linkage path between the conflict patches based on the governance scenario;

[0034] Determining, according to the conflict linkage path, the node type corresponding to the conflict patch and the linkage impact factor corresponding to the node type;

[0035] For each conflicting spot, the priority corresponding to the associated conflicting spots associated with the conflicting spot is adjusted according to the linkage impact factor.

[0036] In one implementation of the present invention, before adjusting the priorities corresponding to the associated conflict patches associated with the conflict patches according to the linkage impact factor, the method further includes:

[0037] Determining the spatial topological relationship between the conflict patches in the hotspot conflict area, and determining the governance logic between the conflict patches based on the spatial topological relationship;

[0038] When the priorities corresponding to the associated conflict patches are adjusted, the order of the governance priorities corresponding to the conflict patches is determined to remain unchanged according to the governance logic.

[0039] An embodiment of the present invention provides a database-based spatial conflict management device, the device comprising:

[0040] at least one processor;

[0041] and, a memory communicatively coupled to the at least one processor;

[0042] The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute a database-based spatial conflict management method as described in any one of the above items.

[0043] An embodiment of the present invention provides a non-volatile computer storage medium storing computer-executable instructions, wherein the computer-executable instructions are configured to:

[0044] A database-based spatial conflict management method as described in any of the above items.

[0045] The database-based spatial conflict management method proposed by the present invention can bring the following beneficial effects:

[0046] Determining conflict intensity by analyzing the spatial relationships between conflict patches and ownership planning eliminates the need to rely on single indicators such as area and location, enabling a more comprehensive reflection of the urgency and importance of conflict governance. By constructing a spatial relationship network to identify conflict hotspots and taking into account the spatial clustering characteristics of conflict, this approach helps prioritize governance in these areas, improving the relevance and efficiency of governance efforts. Dynamically adjusting governance priorities based on descending order of conflict intensity and incorporating conflict linkage paths adapts to changing conflict states, ensuring a scientific and rational governance sequence. This overcomes the limitations of static sorting in existing technologies and enhances the dynamic adaptability of governance. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of the present invention. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings:

[0048] Figure 1A schematic diagram of a flow chart of a database-based spatial conflict management method provided by an embodiment of the present invention;

[0049] Figure 2 A schematic structural diagram of a database-based spatial conflict management device provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0050] To make the objectives, technical solutions, and advantages of the present invention more clear, the technical solutions of the present invention will be clearly and completely described below in conjunction with specific embodiments of the present invention and corresponding drawings. Obviously, the embodiments described are only some embodiments of the present invention, not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0051] The technical solutions provided by various embodiments of the present invention are described in detail below with reference to the accompanying drawings.

[0052] like Figure 1 As shown, an embodiment of the present invention provides a database-based spatial conflict management method, including:

[0053] S101: Using a preset spatial analysis function, according to the geometric relationship between the spatial patches corresponding to the planned land in the spatial database, conflicting patches are determined among the spatial patches.

[0054] Urban planning, land management, and resource development and utilization involve a vast amount of spatial data, stored in spatial databases. A spatial database is a database used to store spatially specific data. It can store the location, shape, size, and related attribute information of geographic entities, and serves as the data foundation for geographic information systems. Common spatial databases include PostGIS and Oracle Spatial. Due to the influence of various factors, planning by different departments and over different periods, various conflicts may arise between these spatial data. To effectively manage spatial conflicts, it is first necessary to accurately identify the conflicting spatial patches so that targeted governance strategies and prioritization can be formulated.

[0055] In multi-source spatial planning, different data sources or hierarchical spatial information of plans may be stored in different spatial databases. By using preset spatial analysis functions to identify the spatial patches corresponding to planned land in the spatial database, it is possible to determine whether there are spatial conflicts between spatial patches. Conflicting patches refer to patches that are spatially contradictory or inconsistent. There are two main situations. One is that patches have geometric relationships such as overlap or proximity in spatial location, but their planned uses and attributes conflict with each other. For example, one patch is planned as an ecological protection area, while another patch that overlaps with it is planned as industrial land. The other is that the attributes of the patch itself conflict with the surrounding environment or other relevant regulations. For example, the land use of a particular patch is inconsistent with the ecological protection requirements of the region. Based on this, by analyzing the geometric relationships between spatial patches, it is possible to identify conflicting patches with spatial conflicts.

[0056] In one embodiment, the ST_Intersects spatial function in the spatial database is used to determine whether there is geometric overlap between spatial patches. For example, it is determined whether construction patches and farmland protection patches at different levels of space overlap. If there is overlap, it indicates that there is a conflict in the patch land use planning. At this time, the two spatial patches may be identified as potentially conflicting. At the same time, the ST_Distance function is used to determine whether the safety distance corresponding to the spatial patch meets the preset distance threshold. The safety distance here refers to the distance between the spatial patch and the sensitive boundary. Assuming that the distance between the mining patch and the ecological protection line boundary is less than the preset distance threshold, it indicates that the land use planning of this patch may constitute a potential spatial conflict.

[0057] After screening out potential conflict patches that may constitute a spatial conflict, it is necessary to determine the spatial overlap information and patch attributes corresponding to the potential conflict patches. Spatial overlap information describes the specific geometric overlap between spatial patches, including the size of the overlapping area, the shape of the overlapping area, and the proportion of the overlapping part to the total area of ​​each patch. The shape of the overlapping area can be determined using the ST_Intersection function, and the size of the overlapping area can be calculated using the ST_Area function. Patch attributes represent the various attribute characteristics of spatial patches, such as planned use (residential, commercial, industrial, ecological, etc.), ownership information, development intensity, and planning level. Based on the spatial overlap information and patch attributes corresponding to the potential conflict patches, determine whether the potential conflict patches are conflict patches with real conflicts.

[0058] Specifically, the spatial analysis tool provided in the spatial database is used to calculate the overlapping areas between potential conflicting patches, determine the specific location of the overlapping areas in each patch, and calculate the area size of the overlapping areas using the area calculation tool.

[0059] Determine whether the spatial overlapping position is located at the edge of the potential conflict patch, and at the same time, determine whether the overlapping area is smaller than the preset area. Since the overlapping position has little impact on the actual land use planning of the patch, and the smaller conflict area will not have much impact on the use of the patch, if the spatial overlapping position is located at the edge and the overlapping area is small, then this type of potential conflict patch is identified as a normal patch. Otherwise, it is necessary to further compare the patch attributes of the conflict patch to determine whether there is an attribute conflict in the potential conflict patch. For example, if the land use of one patch is residential land and the land use of another overlapping patch is industrial land, then there is a conflict in use between the two. If the patch attributes of the potential conflict patch are still conflicting when the above-mentioned position and area conditions are met, then the potential conflict patch is finally determined to be a conflict patch with a real conflict.

[0060] In addition, in addition to the above-mentioned method of identifying conflicting patches by overlapping patches, if a spatial patch conflicts with the surrounding environment or other relevant regulations, for example, the land use of a certain patch is contrary to the ecological protection requirements of the area, then this spatial patch can also be directly identified as a conflicting patch.

[0061] S102: Analyze the spatial relationship and ownership planning relationship corresponding to the conflict patches to determine the conflict intensity corresponding to each conflict patch.

[0062] After identifying conflict patches, these patches need to be managed sequentially. However, due to differences in planning purposes and conflict types, conflict management requires analyzing the spatial relationships and ownership planning relationships corresponding to the conflict patches to determine the conflict intensity corresponding to each conflict patch. This allows for a reasonable management order based on conflict intensity, prioritizing patches with high conflict intensity and strong governance urgency, improving the overall efficiency and effectiveness of spatial conflict management, and rationally allocating governance resources. Conflict intensity is used to measure the urgency of conflict patch management; the greater the conflict intensity, the greater the urgency of conflict patch management.

[0063] In one embodiment, the spatial relationship refers to the spatial position relationship of the conflict patches, and the ownership planning relationship involves the ownership units, planned uses, etc. of different patches. The embodiment of the present application comprehensively evaluates the conflict intensity of each conflict patch from two aspects: the spatial characteristics of the conflict patch itself and the difficulty of governance.

[0064] Specifically, based on relevant ecological and environmental protection plans and land use planning, the location and extent of sensitive boundaries, such as the boundaries of cultivated land red lines, ecological red lines, and water source protection zones, are clearly defined. The straight-line distance from each conflicting patch to the nearest sensitive boundary is calculated. Based on this straight-line distance, a spatial sensitivity factor value is determined according to pre-defined rules. For example, distance is divided into multiple intervals, with each interval corresponding to a corresponding factor value. The closer the distance, the higher the spatial sensitivity factor value.

[0065] Each conflicting patch has patch attributes, which can be used to determine the corresponding ownership unit name and planned land use type. The number of ownership units involved in the conflicting patch is counted, as is whether it falls within an overlapping area of ​​multiple plans. The number of overlapping planning types (i.e., the number of planned uses for the conflicting patch) is determined. The governance complexity factor is then weighted and summed based on the number of ownership units and the number of overlapping planning types, using pre-set weights.

[0066] Obtain the level of the responsible unit for each conflict patch (e.g., national, provincial, municipal, district, or county level) and the corresponding annual law enforcement frequency. Assign weights to each level based on its importance, and determine a regulatory intensity coefficient based on the annual law enforcement frequency. Multiply the responsible unit's level weight by the regulatory intensity coefficient to obtain the responsibility clarity factor. For example, if the responsible unit for a conflict patch is provincial, with a level weight of 0.7 and 30 annual law enforcements, the basic regulatory intensity coefficient is 0.1. For every 10 additional annual law enforcements, the regulatory intensity coefficient increases by 0.1. Therefore, the final responsibility clarity factor is 0.7 × 0.4 = 0.28.

[0067] Obtain the superior planning documents for the spatial area where the conflicting patch is located, clarifying the area's planned land use layout, land use control requirements, and development and construction intensity. Compare and analyze the conflicting patch's planned land use type, development intensity, and other attributes with the superior planning requirements to determine their compatibility with the superior plan. For example, if the superior plan requires an area to be ecological, while the conflicting patch is planned for industrial use, then the two are in complete conflict. If the superior plan allows for a certain proportion of mixed land use, and the land use type of the conflicting patch falls within the permitted range, then the conflict is low. Based on the comparative analysis results, the planning compatibility conflict is quantified into a factor value according to specific criteria. For example, the conflict level can be categorized into five levels: complete conflict, severe conflict, moderate conflict, mild conflict, and no conflict, corresponding to factor values ​​of 0.9, 0.7, 0.5, 0.3, and 0.1, respectively. Each level has a corresponding conflict classification standard. Based on this conflict classification standard, the compatibility between the conflicting patch and the superior plan for the spatial area in which it resides can be determined.

[0068] From historical rectification data, we extract the start time and actual start time of each rectification for each conflicting patch, and calculate the time difference between the two to obtain the rectification response time. Based on the length of the rectification response time, we determine the timeliness trend factor value according to pre-set rules.

[0069] The above factors are assigned corresponding weights based on their importance to conflict intensity. Weights can be determined through expert consultation and data analysis. Each factor value is multiplied by its corresponding weight, and then the sum is added to obtain the conflict intensity for each conflict patch. The higher the conflict intensity, the higher the priority that conflict patch should be addressed.

[0070] A single factor or qualitative analysis alone cannot accurately measure the urgency and importance of conflict patch governance. By comprehensively considering multiple factors, such as spatial sensitivity, governance complexity, clarity of responsibility, planning adaptability, and timeliness, and quantifying them into factor values, we can comprehensively and objectively assess the intensity of conflict patches, providing a more scientific and reliable basis for governance decision-making and avoiding irrational governance sequencing or inappropriate resource allocation due to one-sided consideration of any one factor.

[0071] S103: constructing a spatial relationship network according to the spatial distribution of the plurality of conflict patches, and determining, based on the spatial relationship network, hotspot conflict areas with spatial agglomeration according to conflict intensity.

[0072] Based on the spatial distribution of multiple conflict patches, a spatial relationship network is constructed. The nodes in the spatial relationship network represent conflict patches, and the spatial correlations between conflict patches are edges. After determining the conflict intensity corresponding to each conflict patch, it is necessary to further analyze the spatial distribution characteristics of the conflict patches to determine which areas are prone to conflict and where conflicts are concentrated, that is, hotspot conflict areas, thereby providing clearer direction and key areas for subsequent governance work. Hotspot conflict areas refer to areas where there are many conflict patches clustered together and the conflict intensity is high. These areas generally require priority governance and focus.

[0073] In one embodiment, the mean of the conflict intensities corresponding to each conflict patch in the spatial relationship network is calculated. For each conflict patch, the degree of collaborative deviation from the mean of the conflict intensities corresponding to the patch region formed by the conflict patch and its adjacent conflict patches is calculated. The degree of collaborative deviation reflects the deviation between the conflict intensity of the patch region and the overall mean, as well as the spatial consistency and correlation of this deviation. This is used to determine whether the conflict intensity of the patch region is significantly higher or lower than the average level, thereby identifying areas of potential spatial agglomeration.

[0074] The degree of cooperative deviation can be calculated by the adjacency relationship and mean between the conflict patch and its corresponding adjacent conflict patch, which can be expressed as the following formula:

[0075]

[0076] in, Indicates the adjacency relationship between conflict patch i and conflict patch j, where adjacency is 1 and non-adjacency is 0. and Respectively represent the conflict intensity corresponding to conflict patch i and conflict patch j, Represents the mean value of conflict intensity.

[0077] After calculating the degree of coordinated deviation between each conflict patch and its adjacent conflict patches, we screened out hotspot conflict areas with spatial clustering within the spatial relationship network. According to the above formula, if the conflict intensity of adjacent conflict patches is simultaneously higher or lower than the mean, that is, if conflict patches with high or low conflict intensity cluster, the degree of coordinated deviation is positive, indicating a positive spatial correlation. Conversely, when high and low conflict areas are interlaced, a negative spatial correlation is observed.

[0078] Therefore, when screening hotspot conflict areas, first determine whether there is significant clustering of the conflict intensity of the conflict patches based on whether the degree of coordinated deviation is greater than 0. If it is greater than 0, it means that there is clustering between the conflict patch and its adjacent conflict patches. However, when conducting spatial conflict management, the greater the conflict intensity, the more serious the potential harm and the higher the risk of diffusion. These patch areas with greater conflict intensity need to be managed first. Therefore, patch areas where the conflict intensity corresponding to the conflict patch and its adjacent conflict patches is greater than the preset intensity need to be treated as hotspot conflict areas. Repeat the calculation of the degree of coordinated deviation between each conflict patch and its adjacent conflict patch until all hotspot conflict areas in the spatial relationship network are screened out.

[0079] S104: Determine the governance priority corresponding to the conflict patches according to the descending order of conflict intensity, and adjust the governance priority of the conflict patches according to the conflict linkage paths between the conflict patches in the hotspot conflict area.

[0080] For conflict spots, the intensity of their conflict reflects the urgency of their governance, so the governance priority of each conflict spot can be determined in descending order of conflict intensity. However, considering that different conflict spots are geographically close and influence each other, if such spatially clustered spot areas are governed one by one, it will not only be inefficient, but may also affect the governance effect due to the mutual influence between the conflict spots. The embodiment of the present invention chooses to give priority to the governance of hotspot conflict areas with spatial agglomeration. At the same time, according to the mutual influence between different conflict spots, the governance order corresponding to different conflict spots needs to be determined within the hotspot conflict area. The conflict intensity can reflect the governance priority of the conflict spot, but it is also necessary to determine the conflict linkage path between the conflict spots in the hotspot conflict area, so as to adjust the priority of the affected conflict spots in the hotspot conflict area according to the conflict linkage path. In this way, spots with high conflict intensity can be dealt with first, and spots that have an important impact on the alleviation of conflicts in other spots can also be governed first, thereby more effectively solving the overall conflict problem in the hotspot conflict area.

[0081] In one embodiment, the governance scenario corresponding to each conflict patch in the hotspot conflict area is determined, and based on the governance scenario, the conflict linkage path between the conflict patches is determined. The conflict linkage path refers to how the governance behavior of conflict patch A will affect the state change of conflict patch B. For example, in the case of a functional replacement governance scenario, the expansion of the river protection area patch boundary will encroach on the cultivated land patch. Then, the river protection area patch will affect the cultivated land patch and force it to migrate. Correspondingly, the governance priority of the cultivated land patch will be increased. Therefore, after determining the conflict linkage path, the in-degree of the conflict patch is analyzed according to the conflict linkage path. The in-degree indicates the number of times the conflict patch affects other patches or is affected by other patches. Based on the in-degree, it can be determined whether the node type corresponding to the conflict patch is a conflict source node, a conflict sink node, or an ordinary node. If the out-degree corresponding to the conflict patch is greater than the in-degree, then it is a conflict source node; otherwise, it is a conflict sink node. If the difference in in-degree is small, the node where the conflict patch is located is considered to be a conflict source node and a conflict sink node. If both in-degree and out-degree are lower than the preset number, then the conflict patch is considered to be an ordinary node.

[0082] Different node types have corresponding linkage impact factors. The linkage impact factor is a preset value that can reflect the degree of linkage impact caused by different types of nodes on other nodes. When setting the linkage impact factor, each node type corresponds to a different evaluation index. After normalizing the evaluation index value corresponding to the conflict pattern, the weighted average value between the evaluation index values ​​is calculated to obtain the node's influence strength. Each node type has a corresponding basic impact factor. Generally, the basic impact factor corresponding to the conflict source node is greater than 1, the basic impact factor corresponding to the ordinary node is 1, and the basic impact factor corresponding to the conflict sink node is less than 1. According to the formula , calculate the linkage impact factor corresponding to each node type, where BIF represents the basic impact factor and NS represents the impact strength.

[0083] According to the linkage influence factor, the priority of the associated conflict patch associated with the conflict patch can be adjusted. When adjusting the priority, the adjusted priority can be obtained by multiplying the linkage influence factor and the original priority.

[0084] It should be noted that the governance order for some conflict patches within hotspot conflict zones is fixed. This is due to the spatial topological relationships between different conflict patches, which define their governance logic. Spatial topological relationships refer to the relative positional relationships between conflict patches, including adjacency, spanning, and inclusion. Adjacency means that the boundaries of two patches touch but do not overlap. Spanning means that the spatial extent of one patch spans another. Containment means that one patch is completely within another.

[0085] Based on the spatial topological relationships described above, the governance logic between conflicting patches is determined. For adjacent conflicting patches, priority is given to those that may have a greater negative impact on adjacent patches. For example, if industrial land is adjacent to residential land, priority should be given to the industrial land to reduce pollution to the residential environment. For patches that span, priority is given to the patch that spans. For patches that contain, priority is given to the outer patch that contains other patches.

[0086] Starting from the first conflict patch in the hotspot conflict area, the priority of the associated conflict group of each conflict patch is adjusted one by one. When adjusting the priority, if the adjusted governance priority does not match the governance logic, it is necessary to continue to adjust the governance priority so that the order of the adjusted governance priority matches the governance logic. In other words, no matter how the governance priority is adjusted, the governance priority of the associated conflict patch needs to meet the governance order required by the governance logic. By considering the spatial topological relationship, the governance order can be determined more accurately, key patches can be prioritized, and conflicts and duplication of work in subsequent governance work can be reduced. At the same time, following the governance logic of the spatial topological relationship can more effectively resolve conflicts and avoid the invalidation or weakening of the governance of some patches due to improper order.

[0087] S105: Generate a spatial governance path within the hotspot conflict area through the adjusted governance priority, so as to achieve spatial conflict governance of the planned land through the spatial governance path.

[0088] Based on the adjusted priority levels, the spatial governance path within the hotspot conflict area is clarified. By sequentially governing the conflict patches according to the spatial governance path, spatial conflicts within the planned land within the hotspot conflict area can be managed. It should be noted that for non-hotspot conflict areas, after completing governance of the hotspot conflict area, governance can be completed sequentially in descending order of conflict intensity.

[0089] The above are embodiments of the method proposed by the present invention. Based on the same idea, some embodiments of the present invention also provide devices and non-volatile computer storage media corresponding to the above methods.

[0090] Figure 2 The schematic diagram of the structure of a database-based spatial conflict management device provided by an embodiment of the present invention. Figure 2 Shown, including:

[0091] at least one processor; and,

[0092] at least one processor communicatively connected to a memory; wherein,

[0093] The memory stores instructions that can be executed by at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to execute a database-based spatial conflict management method as described in any one of the above items.

[0094] An embodiment of the present invention provides a non-volatile computer storage medium storing computer-executable instructions, wherein the computer-executable instructions are configured as follows:

[0095] A database-based spatial conflict management method as described in any of the above items.

[0096] The various embodiments of the present invention are described in a progressive manner. Similar portions between the various embodiments can be referred to in conjunction with each other. Each embodiment focuses on the differences between the other embodiments. In particular, the device and medium embodiments are generally similar to the method embodiments, so their descriptions are relatively simplified. For relevant portions, refer to the descriptions of the method embodiments.

[0097] The devices and media provided in the embodiments of the present invention correspond one-to-one to the methods. Therefore, the devices and media also have similar beneficial technical effects to their corresponding methods. Since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media will not be repeated here.

[0098] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Thus, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to magnetic disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0099] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowcharts and / or block diagrams, as well as combinations of processes and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowcharts and / or block diagrams. Figure 1 a process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0100] These computer program instructions may also be stored in a computer readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 a process or multiple processes and / or boxes Figure 1 The function specified in one or more boxes.

[0101] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing the instructions executed on the computer or other programmable device for implementing the process. Figure 1 a process or multiple processes and / or boxes Figure 1 The steps for the function specified in one or more boxes.

[0102] In a typical configuration, a computing device includes one or more processors (CPUs), input / output interfaces, network interfaces, and memory.

[0103] Memory may include non-permanent storage in a computer-readable medium, in the form of random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash RAM. Memory is an example of a computer-readable medium.

[0104] Computer-readable media includes both permanent and non-permanent, removable and non-removable media that can be implemented using any method or technology to store information. Information can be computer-readable instructions, data structures, program modules, or other data. Examples of computer storage media include, but are not limited to, phase-change RAM (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer-readable media does not include transitory computer-readable media such as modulated data signals and carrier waves.

[0105] It should also be noted that the terms "comprises," "includes," or any other variations thereof are intended to encompass non-exclusive inclusion, such that a process, method, commodity, or apparatus that includes a series of elements includes not only those elements but also other elements not explicitly listed, or includes elements inherent to such process, method, commodity, or apparatus. In the absence of further limitations, an element defined by the phrase "comprises a ..." does not exclude the presence of other identical elements in the process, method, commodity, or apparatus that includes the element.

[0106] The foregoing is merely an embodiment of the present invention and is not intended to limit the present invention. It will be apparent to those skilled in the art that various modifications and variations of the present invention are possible. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention are intended to be included within the scope of the claims of the present invention.

Claims

1. A spatial conflict management method based on a database, characterized in that: The method comprises: Determining conflicting patches among the spatial patches according to the geometric relationship between the spatial patches corresponding to the planned land in the spatial database by using a preset spatial analysis function; Analyze the spatial relationship and ownership planning relationship corresponding to the conflict patches to determine the conflict intensity corresponding to each conflict patch; Constructing a spatial relationship network based on the spatial distribution of the plurality of conflict patches, and determining, based on the spatial relationship network and according to the conflict intensity, hotspot conflict areas with spatial agglomeration; Determine the governance priority corresponding to the conflict patches according to the descending order of the conflict intensity, and adjust the governance priority of the conflict patches according to the conflict linkage paths between the conflict patches in the hotspot conflict area; Generate a spatial governance path within the hotspot conflict area through the adjusted governance priority, so as to achieve spatial conflict governance of the planned land through the spatial governance path; Analyze the spatial relationship and ownership planning relationship corresponding to the conflict patches to determine the conflict intensity corresponding to each conflict patch, specifically including: Determining a spatial sensitivity factor value according to the distance between the conflicting patch and the sensitive boundary; Determine the ownership units and planned land use types corresponding to the conflicting patches, and determine the governance complexity factor value based on the number of ownership units and the number of overlapping planning types; Determine the responsibility attribution clarity factor value based on the level of the responsible unit to which the conflict patch belongs and the supervision intensity corresponding to the level of the responsible unit; wherein the supervision intensity is used to represent the annual law enforcement frequency of the responsible unit; Determining a planning adaptation conflict factor value based on the degree of adaptation between the conflicting pattern and the upper-level planning of the spatial area in which it is located; Determining a timeliness trend factor value according to the rectification response time of the conflicting pattern; Determining the conflict intensity corresponding to each conflict patch according to the spatial sensitivity factor value, the governance complexity factor value, the responsibility attribution clarity factor value, the planning adaptation conflict factor value, and the timeliness trend factor value; Based on the spatial relationship network, determining hotspot conflict areas with spatial agglomeration according to the conflict intensity specifically includes: Calculating the mean of the conflict intensities corresponding to the conflict patches in the spatial relationship network; For each conflicting patch, based on the adjacency relationship between the conflicting patch and its corresponding adjacent conflicting patches and the mean, calculate the conflict intensity corresponding to the patch area formed by the conflicting patch and its adjacent conflicting patches, and the degree of collaborative deviation from the mean; wherein the degree of collaborative deviation reflects the deviation relationship between the conflict intensity of the patch area and the mean; According to the degree of collaborative deviation, a hot spot conflict area with spatial agglomeration in the spatial relationship network is determined.

2. The database-based spatial conflict management method according to claim 1, characterized in that: Determining conflicting patches in the spatial patches according to the geometric relationship between the spatial patches corresponding to the planned land in the spatial database, specifically including: Determine whether there is a potential conflict between the spatial patches according to whether there is geometric overlap between the spatial patches corresponding to the planned land in the spatial database and whether the safety distances corresponding to the spatial patches meet a preset distance threshold; If so, the spatial patch is determined to be a potential conflict patch, and whether the potential conflict patch is a conflict patch with a real conflict is determined based on the spatial overlap information and patch attributes corresponding to the potential conflict patch.

3. The database-based spatial conflict management method according to claim 2, characterized in that: Determining whether the potential conflict patch is a conflict patch with a real conflict based on the spatial overlap information and patch attributes corresponding to the potential conflict patch specifically includes: Determining spatial overlap information corresponding to the potential conflicting patches; wherein the spatial overlap information includes a spatial overlap position and a spatial overlap area; Determine whether the spatial overlap position is located at an edge position of the potential conflict patch and whether the spatial overlap area is smaller than a preset area; If not, judging whether the potential conflicting patch has attribute conflict according to the patch attribute corresponding to the potential conflicting patch; If so, the potential conflict patch is determined to be a conflict patch.

4. The database-based spatial conflict management method according to claim 1, characterized in that: Determining, based on the degree of collaborative deviation, hotspot conflict areas with spatial agglomeration in the spatial relationship network, specifically including: Determining whether the degree of collaborative deviation is greater than 0; If so, the conflict spot and the adjacent conflict spots have conflict intensities greater than a preset intensity, and the conflict spot area is regarded as a hot spot conflict area; The degree of cooperative deviation between each conflicting patch and its adjacent conflicting patches is repeatedly calculated until all hotspot conflict areas in the spatial relationship network are screened out.

5. The database-based spatial conflict management method according to claim 1, characterized in that: According to the conflict linkage paths between the conflict patches in the hotspot conflict area, the governance priority of the conflict patches is adjusted, specifically including: Determining a governance scenario corresponding to each conflict patch in the hotspot conflict area, and determining a conflict linkage path between the conflict patches based on the governance scenario; Determining, according to the conflict linkage path, the node type corresponding to the conflict patch and the linkage impact factor corresponding to the node type; For each conflicting spot, the priority corresponding to the associated conflicting spots associated with the conflicting spot is adjusted according to the linkage impact factor.

6. The database-based spatial conflict management method according to claim 5, characterized in that: Before adjusting the priorities of the associated conflict patches associated with the conflict patches according to the linkage impact factors, the method further includes: Determining the spatial topological relationship between the conflict patches in the hotspot conflict area, and determining the governance logic between the conflict patches based on the spatial topological relationship; When the priorities corresponding to the associated conflict patches are adjusted, the order of the governance priorities corresponding to the conflict patches is determined to remain unchanged according to the governance logic.

7. A database-based spatial conflict management device, characterized in that: The device comprises: at least one processor; and, a memory communicatively coupled to the at least one processor; The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the database-based spatial conflict management method as described in any one of claims 1-6.

8. A non-volatile computer storage medium storing computer-executable instructions, characterized in that: The computer executable instructions are configured to: A database-based spatial conflict management method as described in any one of claims 1 to 6.

Images