A method, a recording medium and a system for determining permissions for a river-related project based on spatial analysis

Abstract

The present application belongs to the technical field of geographic spatial information, and particularly relates to a method for determining the permission of a river-related project based on spatial analysis. Based on the spatial analysis technology of a geographic information system, the method calculates the spatial information of a target through intersection analysis, buffer zone analysis, spatial information quantity calculation and other methods, extracts judgment rules based on the relevant regulations of the approval of the permission of a construction project in the management range of a river, and realizes the automatic processing of the entire permission confirmation process by calling the functions in PostgreSQL through a program, so as to simplify the working steps of the staff, ensure the accuracy of the results, improve the approval efficiency of the permission, and be particularly suitable for administrative law enforcement agencies with weak computer programming ability and high work efficiency requirement. The present application also provides a non-transient readable recording medium storing the program of the method and a system containing the medium, and the program can be called by a processing circuit to execute the above method.

Description

TECHNICAL FIELD

[0001] The application belongs to the technical field of geographic space information, and discloses a method for determining permission of a river-related project based on spatial analysis, a recording medium and a system. BACKGROUND

[0002] Strengthening the management of construction projects within the river management range is related to flood control safety, river regime stability and ecological safety, and is an important part of implementing the river chief system and lake chief system and strengthening the management and protection of river channels. Defining permission and improving efficiency are important links in standardizing the permission of river-related construction projects.

[0003] Currently, to confirm the permission and approval authority, it is necessary to find the corresponding policy documents and check them one by one according to the river-related level, project size and project location and other indicators, which is prone to errors and omissions. When calculating the spatial position, it is necessary to first apply for surveying and mapping results data, and then use a computer to analyze and calculate through professional GIS software. The operation process is complicated, and the use of the software requires a certain technical threshold, which brings great inconvenience to relevant staff. Each construction project reporting unit and the water administrative department need to confirm the permission according to the policy documents, which is a repetitive process and wastes human resources.

[0004] PostgreSQL is an open source and free relational database management system that provides rich extension support, allowing developers to customize and add functions to meet various needs, and has a powerful query optimizer built-in that can generate the optimal execution plan according to the query complexity and table size, etc., thereby improving the query performance of spatial analysis. In terms of spatial data processing and querying, it provides rich spatial operation functions and indexes, supports complex spatial analysis operations such as spatial relationship querying, spatial buffer analysis, and spatial distance calculation, and can be used as a tool to replace manual auditing. However, this software is a general-purpose software that involves many functions, functions and data, and staff often have no idea when facing specific problems. How to use the function of the software to develop a method that can automatically perform spatial analysis and confirm the permission of river-related projects is a problem that needs to be solved by current technical personnel. SUMMARY

[0005] To solve the above problems, the application provides a method for determining the permission of a river-related project based on spatial analysis, and the specific scheme includes the following steps:

[0006] S1. Obtain the spatial data of the river management range and store it in the PostgreSQL database.

[0007] S2. According to the relevant policies and regulations, classify the river-related projects, and formulate different permission standards for each category.

[0008] S3. Input the river-related project scope spatial data and the basic geographic information of the project, and use the ST_Intersects(geometry, geometry) function of PostgreSQL to obtain the river management scope line data intersecting the river-related project scope surface;

[0009] S4. Determine the river-related project classification according to the number of the river management scope lines;

[0010] S5. Calculate the area of the river-related project influence area and the length of the affected river according to the river management scope line data intersecting the construction project scope surface and the boundary of the river-related project scope surface;

[0011] S6. Substitute the area and length into the discriminant standard expression to obtain the permission of the river-related project to be determined.

[0012] Preferably, if the number in S4 is 1, it is determined as a riverfront project; if the number in S4 is greater than 1, it is determined as a river-crossing project.

[0013] Preferably, in S5, if it is a river-crossing project, the ST_MakePolygon(linestring, [linestring[]]) function of PostgreSQL is used to construct a river management scope surface from the area sandwiched by the river management scope lines; the ST_Intersection(geometry, geometry) function of PostgreSQL is used to obtain the overlapping area of the river management scope surface and the river-related project scope surface as the river-related project influence area; and the ST_Area(geometry) function of PostgreSQL is used to obtain the area of the overlapping area.

[0014] Preferably, in S5, if it is a riverfront project, the ST_Envelope(geometry) function of PostgreSQL is used to obtain the circumscribed rectangle of the river-related project scope surface, the river management scope lines covered by the circumscribed rectangle are translated to the opposite bank by a set buffer distance to form a river buffer line, and the buffer distance must ensure that the river surface area swept by the translation to the opposite bank covers the river surface part of the riverfront project, and the overlapping area of the river surface area and the river-related project scope surface is the river-related project influence area.

[0015] Preferably, the river management range line within the river-related project range surface is obtained by using the ST_Intersection(geometry, geometry) function of PostgreSQL, and the length of the river management range line within the river-related project range surface is calculated as the length of the affected river by using the ST_Length(geometry) function of PostgreSQL.

[0016] Another aspect of the present application provides a non-transitory computer readable recording medium storing one or more programs containing a plurality of instructions which, when executed, cause a processing circuit to perform the above-mentioned method for determining a river-related project permission based on spatial analysis.

[0017] Another aspect of the present application provides a system for determining a river-related project permission based on spatial analysis, comprising a processing circuit and a memory electrically coupled to the processing circuit, wherein the memory is configured to store at least one program containing a plurality of instructions, and the processing circuit is configured to execute the program to perform the above-mentioned method for determining a river-related project permission based on spatial analysis.

[0018] Compared with the prior art, the present application has the following advantages:

[0019] Based on the spatial analysis technology of geographic information system, the present application calculates the spatial information of the target by using intersection analysis, buffer analysis, spatial information calculation and other methods, based on PostgreSQL, extracts the judgment rules in combination with the relevant regulations for the approval of the permission of the construction project in the river management range, and realizes the automatic processing of the entire permission confirmation process by calling the functions in PostgreSQL through the program, thereby simplifying the working steps of the staff, ensuring the accuracy of the results, and improving the approval efficiency of the permission. BRIEF DESCRIPTION OF DRAWINGS

[0020] Figure 1 The figure is a flowchart of the method for determining a river-related project permission based on spatial analysis in the embodiment of the present application.

[0021] Figure 2 The figure is a schematic diagram of the spatial analysis result of the river-crossing project in the embodiment of the present application.

[0022] Figure 3 The figure is a schematic diagram of the spatial analysis result of the river-adjacent project in the embodiment of the present application. DETAILED DESCRIPTION

[0023] In order to make the purposes, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be described below with reference to the drawings in the embodiments of the present application. The described embodiments are part of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative labor fall within the scope of protection of the present application.

[0024] With reference to the accompanying drawings Figures 1-3 The embodiment of the method for determining the permission of a river-related project based on spatial analysis provided by the present application is as follows:

[0025] Step 1: Obtain the river management range data and store it in the PostgreSQL database.

[0026] Step 2: According to relevant policies and regulations, write program code for judging the permission.

[0027] Step 3: Determine the type of the construction project through intersection analysis. The specific implementation steps are as follows:

[0028] Import the spatial data of the construction project range and the basic information of the project.

[0029] Use the ST_Intersects(geometry, geometry) function of PostgreSQL to query the river management range line data intersected with the construction project range surface.

[0030] According to the queried management range line data, determine the type of the construction project. If the construction project only intersects with one management range line, it is a riverfront project. If the construction project simultaneously intersects with the management range lines on the left and right banks of a river, it is a cross-river project.

[0031] Step 4: Calculate the river-related area of the construction project according to the type of the construction project. The specific implementation steps need to be explained in two cases. If it is a cross-river project:

[0032] Use the ST_MakePolygon(linestring, [linestring[]]) function of PostgreSQL to construct a river management range surface from the two queried management range line data.

[0033] Use the ST_Intersection(geometry, geometry) function of PostgreSQL to obtain the intersection part of the input construction project range surface and the output river management range surface.

[0034] Use the ST_Area(geometry) function of PostgreSQL to obtain the area of the output intersection part.

[0035] If it is a riverfront project:

[0036] Get the outer rectangle of the input project range surface using the ST_Envelope(geometry) function of PostgreSQL;

[0037] According to the output of the outer rectangle endpoint coordinate array, respectively, calculate the spatial distance of the long side and the short side, take the maximum value a; The calculation method is as follows:

[0038]

[0039]

[0040] Where: (x1, y1) is the starting point coordinate of the outer rectangle; (x2, y2) is the second point coordinate of the outer rectangle; (x3, y3) is the third point coordinate of the outer rectangle;

[0041] Extract the bank attribute of the queried management range line data, if it is the left bank:

[0042] Use the ST_Buffer(geometry, radius_of_buffer,'side=right') function of PostgreSQL to build a single-side buffer to the right with the output side length a as the buffer distance, to ensure that the buffer can cover the project range in the management range line;

[0043]

[0044] Use the ST_Intersection(geometry, geometry) function of PostgreSQL to get the intersection part of the generated buffer surface and the project range surface;

[0045] Use the ST_Area(geometry) function of PostgreSQL to get the area of the output intersection part;

[0046] If it is the right bank:

[0047] Use the ST_Buffer(geometry, radius_of_buffer,'side=left') function of PostgreSQL to build a single-side buffer to the right with the output side length a as the buffer distance;

[0048]

[0049] Use the ST_Intersection(geometry, geometry) function of PostgreSQL to get the intersection part of the generated buffer surface and the project range surface; ​​

[0050] Get the area of the intersection part of the output by using the ST_Area(geometry) function of PostgreSQL;

[0051] Step five: calculate the river-involved length of the construction project, and the specific implementation steps are as follows:

[0052] Get the river management range line in the construction project range surface by using the ST_Intersection(geometry, geometry) function of PostgreSQL;

[0053] Calculate the length of the river management range line segment of the output by using the ST_Length(geometry) function of PostgreSQL;

[0054] Step six: put the results calculated in steps four and five into the judgment program in step two, and output the approval unit level and related information of the permission.

[0055] Those skilled in the art will understand that embodiments of the present application can be provided as methods, systems, or computer program products. Therefore, the present application can take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Moreover, the present application can take the form of a computer program product implemented on one or more computers containing computer-usable program code.

[0056] The present application is described with reference to flowcharts and / or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the present application. It should be understood that each flow and / or block in the flowcharts and / or block diagrams, as well as combinations of flows 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 apparatus to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing apparatus produce a means for implementing the functions specified in the flowcharts and / or block diagrams. Figure 1 The functions specified in a flow or multiple flows and / or blocks Figure 1 The means for implementing the functions specified in a flow or multiple flows and / or blocks

[0057] These computer program instructions can also be stored in a computer-readable memory that can direct the computer or other programmable data processing apparatus to work in a specific manner, so that the instructions stored in the computer-readable memory produce a means for implementing the functions specified in the flowcharts and / or block diagrams. Figure 1 The functions specified in a flow or multiple flows and / or blocks Figure 1 The means for implementing the functions specified in a flow or multiple flows and / or blocks

[0058] These computer program instructions can also be loaded into a computer or other programmable data processing devices, so that a series of operational steps are performed on the computer or other programmable data processing devices to generate a computer implemented process, so that the instructions executed on the computer or other programmable data processing devices provide a process for implementing the flowchart Figure 1 one flow or multiple flows and / or the functions specified in the block Figure 1 one block or multiple blocks.

[0059] The above method steps are assembled into a program and stored in a hard disk or other non-transient storage medium, which constitutes the "non-transient readable recording medium" technical solution of the present application; and the storage medium is electrically connected with the computer processor, and the data processing can complete the determination of the river-related project permission, which constitutes the "river-related project permission determination system based on spatial analysis" technical solution of the present application.

[0060] Finally, it should be noted that: the above only for the preferred embodiments of the present application, and not for the limitation of the present application, although the foregoing detailed description of the present application is made with reference to the foregoing embodiments, for the skilled in the art, it still can be modified, or the equivalent replacement of part of the technical features recorded in the foregoing embodiments. Any modification, equivalent replacement, improvement, etc. within the spirit and principles of the present application shall be included in the protection scope of the present application.

Claims

1. A method for determining a license authority of a river-related project based on spatial analysis, characterized by The method comprises the following steps: S1. Obtain the spatial data of the river management range and store it in the PostgreSQL database; S2. According to relevant policies and regulations, classify the river-related projects, and formulate different permission standards corresponding to different types of projects; S3. Input the spatial data of the river-related project range and the basic geographic information of the project, and use the ST_Intersects(geometry, geometry) function of PostgreSQL to obtain the river management range line data intersected with the river-related project range surface; S4. Determine the classification of the river-related project according to the number of river management range lines; if the number is 1, it is determined as a riverfront project; if the number is greater than 1, it is determined as a cross-river project; S5. According to the river management range line data intersected with the construction project range surface and the boundary of the river-related project range surface, calculate the area of the river-related project affected area and the length of the affected river; S6. Substitute the area and length into the discriminant standard expression to obtain the permission of the river-related project.

2. The method for determining the permission of a river-related project according to claim 1, wherein, In step S5, if it is a cross-river project, use the ST_MakePolygon(linestring, [linestring[]]) function of PostgreSQL to construct a river management range surface from the area enclosed by the river management range line; use the ST_Intersection(geometry, geometry) function of PostgreSQL to obtain the overlapping area of the river management range surface and the river-related project range surface as the river-related project affected area; use the ST_Area(geometry) function of PostgreSQL to obtain the area of the overlapping area.

3. The method according to claim 2, wherein, In step S5, if it is a riverfront project, use the ST_Envelope(geometry) function of PostgreSQL to obtain the circumscribed rectangle of the river-related project range surface, and translate the river management range line covered by the circumscribed rectangle to the opposite bank to form a river buffer line with a set buffer distance, which must ensure that the river surface area translated to the opposite bank covers the river surface part of the riverfront project. The overlapping area of the river surface area and the river-related project range surface is the river-related project affected area.

4. The method for determining the permission of a river-related project according to claim 3, wherein, Use the ST_Intersection(geometry, geometry) function of PostgreSQL to obtain the river management range line within the river-related project range surface; use the ST_Length(geometry) function of PostgreSQL to calculate the length of the river management range line within the river-related project range surface as the length of the affected river.

5. A non-transitory, readable recording medium storing one or more programs including a plurality of instructions, wherein the plurality of instructions, when executed by a processor, cause the processor to perform the method of any one of claims 1 to 4. When the instructions are executed, the processing circuit will perform the method for determining the permission of the river-related project based on spatial analysis according to any one of claims 1-4. When the instructions are executed, the processing circuit will perform the method for determining the permission of the river-related project based on spatial analysis according to any one of claims 1-4. 6.A system for determining permissions for a river-related project based on spatial analysis, comprising processing circuitry and a memory electrically coupled to the processing circuitry, wherein the system is configured to: The memory is configured to store at least one program including a plurality of instructions, and the processing circuitry executes the program and is capable of performing the method for determining the permission of a river-related project based on spatial analysis according to any one of claims 1-4.

Images