Supercharge Your Innovation With Domain-Expert AI Agents!

Method for calculating land homogeneity based on open source spatial database PostGIS

A calculation method and homogeneity technology, which is applied in data processing applications, geographic information databases, special data processing applications, etc., can solve problems such as the inability to eliminate three-dimensional information, achieve fast and efficient calculations, increase computing speed, and improve efficiency Effect

Pending Publication Date: 2021-03-12
SOUTHEAST UNIV
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0042] Technical problem: From the research background, it can be seen that ArcGIS cannot eliminate the three-dimensional information carried when the CAD file is transferred to the shp file, and conveniently perform row-to-column conversion in ArcGIS to realize the function of data perspective

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for calculating land homogeneity based on open source spatial database PostGIS
  • Method for calculating land homogeneity based on open source spatial database PostGIS
  • Method for calculating land homogeneity based on open source spatial database PostGIS

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0080] The present invention will be further described below in conjunction with the accompanying drawings.

[0081] As shown in the figure, the technical scheme of the present invention will be described in detail below in conjunction with a certain plot and accompanying drawings.

[0082] like figure 1 As shown, the calculation method of land use homogeneity based on the open source spatial database PostGIS, the specific method is as follows:

[0083] Step 1: Construct the polygonal vector feature layer of current urban current land use

[0084] Step 1.1: Transfer the shp file of the current urban land use to the PostgreSQL database; transfer the shp file of the current land use plots with different types of land use to the PostGIS spatial database by the tool shp2pgsql-gui, and become a table e01_landuse in the spatial database.

[0085] Step 1.2: Use SQL to query the number of plots transferred to the current land use is 917 plots;

[0086] Step 1.3: Since the original ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a method for calculating land homogeneity based on an open source space database PostGIS, and the method comprises the steps: importing a current land into the PostGIS database,and carrying out the two-dimensional processing and effective inspection of the transferred current land; creating a square grid by using the convex polygon externally connected with the land parcel;performing spatial superposition on the grid element layer and the current land to generate a superposed polygon; wherein the superposed polygon has the identification code and area of the grid polygon and the land property of the land parcel; calculating land types with dominant areas in each grid to obtain dominant land types in each grid; and calculating the homogeneity value of each grid to obtain the homogeneity of each grid unit. Compared with the traditional method for calculating the homogeneity of the land parcel based on the combination of a plurality of pieces of software, the calculation process is based on a PostgreSQL and a space expansion module PostGIS single platform thereof, the data calling time between different pieces of software is reduced, the operation efficiency is greatly improved, the operation speed is improved by more than 10 times compared with the conventional operation speed, and the homogeneity of the urban land can be quantitatively calculated efficiently and quickly.

Description

technical field [0001] The invention relates to a method for calculating land use homogeneity based on an open-source spatial database PostGIS, and belongs to the technical field of urban planning. Background technique [0002] The background technology involves two aspects, namely, the homogeneity calculation process and the land use homogeneity calculation method based on the open source spatial database PostGIS. [0003] Homogeneity refers to the characteristics of maintaining equality and exclusion in the functional differentiation of urban areas. Due to the influence of this homogeneity, there will be many homogeneous areas in the urban area, each of which undertakes distinct functions, that is, functional areas. [0004] For a good urban structure, its land differentiation should be between chaos and order: there are functional divisions, but not absolute differentiation, each functional area has a dominant function, and in each functional area can be found Other rel...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/29G06F16/56G06F16/242G06Q50/26
CPCG06F16/29G06F16/56G06F16/2433G06Q50/26
Inventor 胡明星吴晓汪徽
Owner SOUTHEAST UNIV
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More