Construction land supply data arrangement and analysis method, medium and electronic equipment
Through distributed data synchronization system and geographic information technology, the problem of inconsistent data management of state-owned construction land has been solved, efficient integration and visualization of data has been achieved, scientific decision-making support has been provided, and the efficiency of land resource management and urban planning has been improved. Supportive.
Patent Information
- Application Number
- CN202411091714.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-09
- Publication Date
- 2024-11-08
AI Technical Summary
In the process of supplying state-owned construction land use rights, there are problems such as inconsistent data management, unclear data, and lack of correlation between agreement data and change data in the existing technology, resulting in unscientific land use management and inability to effectively supervise illegal land occupation and changes in use.
Using a distributed data synchronization system, through the methods of data integration and spatialization, building spatial analysis models, multi-source data fusion analysis, visualization and interactive exploration, and decision support systems, establish electronic ledgers and geographic information space ledgers to carry out data Clean, predictive analysis and visual presentation.
It has achieved comprehensive integration and efficient management of data supply for state-owned construction land, improved the sharing and visualization of data, provided scientific decision-making support for urban planning and supervision, and improved the efficiency and efficiency of land resource management.
Smart Images

Figure CN118917879A_ABST
Abstract
Description
Technical Field
[0001] The present invention belongs to the technical field of urban planning and geographic information system, and specifically relates to a method, medium and electronic equipment for collating and analyzing construction land supply data. Background Art
[0002] Land supply is the most critical link in the rational allocation of land resources. With the rapid development of Beijing's urban construction, a large number of agreement contracts and corresponding contract modification archives have been generated in the supply of state-owned construction land use rights in the past three decades. Due to the particularity of the supply of state-owned construction land use rights, there will be repeated changes. These massive data archives lack unified management, and there are problems such as unclear data, disconnection of agreement data at various stages, and lack of connection between agreement contracts and modification contracts. In addition, the traditional paper archive preservation method cannot complete archiving in a timely and accurate manner, and subsequent information review and retrieval are extremely cumbersome, and it is impossible to screen the conditions of archival materials. This has caused a huge waste of manpower, material and financial resources. In the process of review management and supervision management, land supply data cannot be used scientifically and effectively.
[0005] At the same time, the survey also found that the current state-owned land use rights supply archives and materials are mainly in the form of paper contracts and agreements, which are not implemented in specific spatial locations and have no visual spatial scope. It is impossible to extract, screen and analyze archival materials in terms of geographical location. The difficulty in supervising illegal land occupation and unauthorized change of use has caused land users to privately increase the scale of construction, change the use of land and illegally occupy land. For this reason, it is urgent to spatialize the existing archived materials, produce vector spatial data, and combine and associate charts to provide data support for the next step of urban planning and market supervision. Summary of the invention
[0006] In view of the above problems, the present invention is proposed to provide a distributed data synchronization system that overcomes the above problems or at least partially solves the above problems.
[0007] To achieve the above object, the present invention adopts the following technical solutions:
[0008] In a first aspect of the present application, a method for collating and analyzing construction land supply data is provided, the method comprising the following steps:
[0009] S1, data integration and spatialization;
[0010] S2, build a spatial analysis model;
[0011] S3, multi-source data fusion analysis;
[0012] S4, visualization and interactive exploration;
[0013] S5. Decision support system construction and optimization strategy are proposed.
[0014] Optionally, step S1 includes the following steps:
[0015] S101. Collect basic data on construction land;
[0016] S102, cleaning and verifying the collected data;
[0017] S103. Use electronic spreadsheet or database software to establish an electronic ledger of construction land supply;
[0018] S104, integrating the planning data with the land supply implementation data to form a comprehensive data set containing planning information and implementation information;
[0019] S105. Use geographic information system software to associate comprehensive data sets with geographic spatial locations and establish a geographic information spatial ledger.
[0020] Optionally, step S2 includes the following steps:
[0021] S201. Design the database architecture according to the characteristics and requirements of construction land supply data;
[0022] S202, the data is cleaned, converted and formatted and then imported into the database;
[0023] S203, performing coordinate conversion and projection transformation on the data to establish a topological relationship between spatial objects;
[0024] S204. Based on the multidimensional data, construct a multidimensional spatial analysis model.
[0025] Optionally, the multidimensional data includes circle, land price level, land price collection status, transfer period, transfer time, transfer cost and change of use.
[0026] Optionally, step S3 includes the following steps:
[0027] S301. Conduct land price forecast analysis, land price level analysis, land supply history evolution and land transfer special data analysis based on multi-source data and models;
[0028] S302. Use a region-based regression analysis method to predict land prices in future quarters;
[0029] S303. Calculate the average, highest and lowest land prices for various types of land, and analyze the overall distribution and fluctuation range of land price levels.
[0030] Optionally, step S4 includes the following steps:
[0031] S401, collect historical images and remote sensing images, and perform pre-processing and standardization;
[0032] S402, superimposing the processed thematic data with the analysis data in step S3 to form a state-owned construction land supply map containing multi-source information;
[0033] S403. Use map visualization technology to render and display the state-owned construction land supply map to improve the visualization of data.
[0034] Optionally, step S5 further includes the following steps:
[0035] S501, statistically analyzing the construction land supply data, and constructing a construction land decision support module, which is used to generate land use optimization plans and policy recommendations according to user needs;
[0036] S502. Obtain the total supply, supply structure and supply trend of construction land according to the rules and development trends of construction land supply data.
[0037] In a second aspect of the present application, a computer-readable storage medium is provided, in which a computer program is stored. When the computer program is loaded and executed by a processor, the method described in any one of the first aspects is adopted.
[0038] In a third aspect of the present application, an electronic device is provided, comprising a memory, a processor, and a computer program stored in the memory and capable of running on the processor, wherein when the processor loads and executes the computer program, the method described in any one of the first aspects is adopted.
[0039] In summary, due to the adoption of the above technical solution, the beneficial effects of the present invention are:
[0040] 1. The present invention provides a comprehensive, efficient and accurate method for collating and comprehensively analyzing the supply data of state-owned construction land, which solves various problems existing in traditional data management methods and brings great convenience and efficiency improvement to land resource management.
[0041] 2. The present invention realizes the comprehensive integration and efficient management of state-owned construction land supply data by constructing electronic ledgers, geographic information space ledgers and geographic information space databases; improves the sharing and visualization of data through platform docking mechanism and visual display; and provides strong support for urban planning and development through statistical analysis and data utilization. BRIEF DESCRIPTION OF THE DRAWINGS
[0042] Figure 1 It is a flow chart of a method for collating and analyzing construction land supply data provided in an embodiment of the present application;
[0043] Figure 2 This is a flowchart of building a database for the embodiment of the present application;
[0044] Figure 3 This is the technical roadmap of the platform docking mechanism for the embodiment of this application;
[0045] Figure 4 This is a technical flow chart of an embodiment of the present application. DETAILED DESCRIPTION
[0046] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments in the present invention, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention.
[0047] See also Figure 1-4 This embodiment provides a method for collating and analyzing construction land supply data, which is mainly used for digitizing state-owned construction land in Beijing. The method includes the following steps:
[0048] S1. Data integration and spatialization.
[0049] Step S1 includes the following steps:
[0050] S101. Collect basic data on construction land; including but not limited to approval for transfer of state-owned construction land use rights agreement (new construction), approval for transfer of state-owned construction land use rights agreement (social investment project), approval for transfer of state-owned construction land use rights agreement (reissue), approval for transfer of state-owned construction land use rights agreement (current status), land transfer area, change of land transfer scope, change of transferee name, change of measured area, change of land price level, change of planned building area and use, change of original transferee according to the court's enforcement notice, change of completion measured area, change of planned building area, change of use, land transfer area, change of land transfer scope, change of transferee name, approval for transfer of state-owned construction land use rights after transfer, approval for allocation of state-owned construction land use rights, approval for leasing of state-owned construction land use rights, etc.
[0051] S102. Clean and verify the collected data to ensure the accuracy and completeness of the data. Based on the existing initial ledger, add corresponding fields according to the different contents of the land supply documents and the needs of use to form the state-owned construction land supply contract approval ledger to prepare for the subsequent ledger vectorization. Check the content of each ledger according to the supply contract and supplement the content of the newly added fields.
[0052] S103. Use electronic spreadsheets or database software to establish an electronic ledger for construction land supply and realize electronic management of data.
[0053] S104. Integrate the planning data with the land supply implementation data to form a comprehensive data set containing planning information and implementation information.
[0054] S105. Use geographic information system (GIS) software to associate comprehensive data sets with geographic spatial locations and establish a geographic information spatial ledger.
[0055] S2. Construct a spatial analysis model.
[0056] Step S2 includes the following steps:
[0057] S201. Design the database architecture, including data tables, fields, indexes, etc., based on the characteristics and requirements of construction land supply data to meet the storage requirements of the geographic information space ledger.
[0058] S202. After the data is cleaned, converted and formatted, it is imported into the database for unified storage and management.
[0059] S203: Perform coordinate conversion and projection transformation on the data to establish a topological relationship between spatial objects.
[0060] S204: construct a multidimensional spatial analysis model based on the multidimensional data, which includes land circles, land price levels, land price collection, transfer years, transfer time, transfer costs, and changes in use.
[0061] Overlay historical images, topographic maps, land use planning, ground nail piles, land parcels, real estate registration and other thematic data, combined with the boundary change information in the change contract, and draw the vector spatial data of Beijing's state-owned construction land transfer line by line in the order from new to old, with the transfer contract number as the unit. And add the last change time field to enter the time of the last change.
[0062] The spatial database is divided into two large databases: the state-owned construction land supply database and the thematic database. In each large database, corresponding sub-databases are established according to the data type, and a corresponding directory and metadata database are established to provide guarantee for efficient data retrieval.
[0063] S3. Multi-source data fusion analysis.
[0064] Step S3 includes the following steps:
[0065] S301. Conduct land price forecast analysis, land price level analysis, land supply history evolution and land transfer special data analysis based on multi-source data and models.
[0066] S302. Use region-based regression analysis to predict land prices in future quarters.
[0067] Regarding the land price of state-owned construction land in Beijing, the land price transaction data collected in the previous steps, including the total amount of land price payable, the land revenue payable to the government, the amount of land compensation payable, the actual amount of land price paid, the stamp duty, the actual land transfer fee paid, the transaction time, etc., are analyzed.
[0068] The data of state-owned construction land in Beijing is predicted and analyzed using a linear regression model. The linear regression model can be expressed as:
[0069] Y=β1X1+β2X2+β3X3+...+β n X n +σ (1)
[0070] In Formula 1, (Y) represents the dependent variable (the future land price in this method), (X1, X2, ..., X n ) represents the independent variable, and the calculation formula of X is as shown in Formula 2, (β1, β2, ..., β n ) is the regression coefficient, which needs to be determined through data fitting, and (σ) represents the error term.
[0071] X=(α1+α2+...+α n ) (2)
[0072] In Formula 2, (X) represents the amount of land price, (α1, α2, ..., α n ) represents the total amount of land price payable, land revenue payable to the government, and the amount of land compensation payable.
[0073] In the regression model of state-owned construction land, the amount of land price and the time of land price payment are key independent variables. In the calculation, the time of land price payment needs to be converted into the relative time difference with the prediction time point, so that the model can better capture the impact of time factors on land prices. For example, if you want to predict the land price in a certain quarter in the future, the transaction data of the latest quarter will be given a smaller time difference weight, while the earlier transaction data will be given a larger time difference weight.
[0074] In order to calculate the regression coefficient, the least square method was used to estimate the regression coefficient by minimizing the square difference between the predicted value and the actual observed value. After the model was established, the model was trained and verified using the real-time updated land price amount and land price payment time.
[0075] S303. Calculate the average, highest and lowest land prices for various types of land, and analyze the overall distribution and fluctuation range of land price levels.
[0076] Take Beijing’s state-owned construction land as an example:
[0077] The land price forecast analysis is based on the land price of state-owned construction land in Beijing. The land price transaction data of Tongzhou District, Beijing is calculated by formula (2) on a quarterly basis as shown in Table 1:
[0078]
[0079]
[0080] Table 1 Transaction amount of state-owned construction land in Beijing
[0081] Here, x represents the year. In the data, 2000.00 represents the first quarter of 2000, 2000.25 represents the second quarter of 2000, 2000.50 represents the third quarter of 2000, 2000.75 represents the fourth quarter of 2000, and so on.
[0082] According to the above table, the linear regression function in Python is used through formula (1), and the time difference weight rule is attached to perform regression fitting. The results are as follows:
[0083] x 2023.00 2023.25 2023.50 2023.75 2024.00 2024.25 2024.50 y 484755.85 978562.40 624257.62 315812.45 231492.60 1355614.13 192328.23 x 2024.75 2025.00 2025.25 2025.50 2025.75 2026.00 y 156342.74 1416807.01 1478000.00 1508596.44 1539192.88 1569789.32
[0084] Land price level analysis: In the land price level analysis module, five land price layers, namely office benchmark land price, industrial benchmark land price, residential benchmark land price, commercial benchmark land price and block benchmark land price, are combined to overlay the spatial data of state-owned construction land to show the situation of the land in the land price level. The overall situation analysis is as follows:
[0085] ① Combine the benchmark land price data in the plan with the input state-owned construction land data. Calculate the average land price, highest land price and lowest land price of each type of land, and reveal the overall distribution and fluctuation range of land price levels.
[0086] ② By comparing the planned use with the actual land use, the land use efficiency of state-owned construction land in Beijing was evaluated, and possible improper land use or waste was studied.
[0087] ③ View land price levels and analyze land use from a comprehensive perspective. Calculate the average, highest, and lowest land prices for each type of land use, and analyze the overall distribution and fluctuation range of land price levels.
[0088] ④ Explore the relationship between land price, land use and land use efficiency, in order to provide decision-making support for optimizing state-owned construction land in Beijing.
[0089] The historical evolution of land supply, the data of Beijing's state-owned construction land provided by the above steps, is calculated according to year and growth rate as follows:
[0090] 1. Analysis of land supply by year
[0091] Within the statistical range (1991 to present), the supply of state-owned construction land in Beijing has shown certain fluctuations. Specifically, 2004 was the year with the most active land supply, and the land supply area of all levels of state-owned construction land in Beijing reached its peak in 2004. In contrast, the land supply from 1991 to 2000 was relatively tight, with less land supply in all levels and for all purposes.
[0092] Further subdividing, there are also significant differences in the land supply of different circles of state-owned construction land in Beijing. For example, in 2004, the central urban area had the largest number of land supply, 3,832 lots. The central urban area mainly supplies commercial and residential land. The multi-point and ecological conservation areas have a larger supply area and cover a variety of uses.
[0093] 2. Analysis of land supply area growth rate
[0094] After calculating the growth rate of land supply area in each land supply year, each circle and use, the supply of state-owned construction land in Beijing showed obvious phased characteristics. In 2004 and 2017, the growth rate of land supply area increased significantly, which reflected the rapid economic development and accelerated urban construction in Beijing during that period.
[0095] Special data analysis on land transfer: We conduct in-depth analysis on land transfer from multiple dimensions, and analyze the data of state-owned construction land in two different situations: agreement-bidding and auction, and new construction-status. The comparative analysis dimensions include data dimension, land use nature dimension, and circle dimension. The specific analysis includes the following 9 parts:
[0096] 1.Display of agreement and bidding and auctioning dimensions.
[0097] ①Display of agreement and bidding and auction data.
[0098] ②Agreements and bidding and auctioning are displayed according to the nature of land use.
[0099] ③The agreement and bidding and auction are displayed in overlapping circles.
[0100] 2. Display of new construction and current status dimensions.
[0101] ①Display of new construction and current status data.
[0102] ② New construction and current status are displayed according to the nature of land use.
[0103] ③Display of newly built and existing circles superimposed.
[0104] 3. Create new data display.
[0105] ①Create new data display (agreement and bidding and auction).
[0106] ② New construction data is displayed according to the nature of land use (agreement and bidding).
[0107] ③New data overlay circle display (agreement and bidding and auction).
[0108] The system will remind you of the expiration of the transfer period of the state-owned construction land use rights. The system will display the transfer period of the state-owned construction land use rights in Beijing and the relevant fields that are about to expire, including the location, period, price and other fields. An expiration reminder task will be established to remind system staff within half a year of the expiration of the land use rights and renew it immediately.
[0109] By analyzing the above content, we can obtain a variety of data, for example: the number of agreement types accounts for a large proportion, but the amount of land price in bidding and auction is higher, and the building area for residential use is the largest.
[0110] S4. Visualization and interactive exploration.
[0111] With the help of advanced GIS platform and visualization technology, the analysis results are intuitively displayed in various forms such as 3D maps and dynamic charts. At the same time, through interactive exploration tools, the land economic status under different scenarios can be viewed in real time to assist leadership decision-making.
[0112] Step S4 specifically includes the following steps:
[0113] S401. Collect historical images and remote sensing images, and perform preprocessing and standardization.
[0114] S402: Overlay the processed thematic data with the analysis data in step S3 to form a state-owned construction land supply map containing multi-source information.
[0115] S403. Use map visualization technology to render and display the state-owned construction land supply map to improve the visualization of data.
[0116] S5. Decision support system construction and optimization strategy are proposed.
[0117] Step S5 also includes the following steps:
[0118] S501. Conduct statistical analysis on construction land supply data and build a construction land decision support module. The construction land decision support module is used to generate land use optimization plans and policy recommendations based on user needs.
[0119] S502. Obtain the total supply, supply structure and supply trend of construction land according to the rules and development trends of construction land supply data.
[0120] Based on the above analysis and research results, a decision support module for state-owned construction land is constructed. Through information entry, key information including land parcel spatial connection, business history feedback, big data analysis and statistical reports are integrated. The construction land supply data sorting tool extracts data from the shared intermediate library and sorts it professionally. The sorted data is classified into multiple parts such as the supply land parcel spatial library, the supply land parcel history library, and the business history library. The overall decision support system consists of the following two parts:
[0121] First, the dynamic optimization of the land structure of state-owned construction land, using big data technology, combined with state-owned construction land information, spatial location information and other multi-source information for integration, dynamic analysis of the relationship between urban land use structure, industrial land structure change rules and residential land. Based on the land use policy design ideas of the national land space planning system, the coupling status of land use structure is analyzed to assist leadership decision-making.
[0122] Second, the development layout of state-owned construction land is analyzed to promote the optimization of Beijing's land space layout. With the help of big data analysis and the existing land space planning system, the path of land layout development is determined according to the land capacity planning of each district. Combined with the relevant indicators of Beijing's 2035 urban master plan, the land use situation of each district is analyzed to reasonably plan the direction and demand for reduction in future development.
[0123] During the entire process, operators, auditors, committee leaders, center leaders, and staff members access the Beijing State-owned Construction Land Management Platform through their respective permissions to perform business operations and management to ensure the smooth operation of the entire system.
[0124] This embodiment realizes the comprehensive integration and efficient management of state-owned construction land supply data by constructing electronic ledgers, geographic information space ledgers and geographic information space databases; improves the sharing and visualization of data through platform docking mechanism and visual display; and provides strong support for urban planning and development through statistical analysis and data utilization.
[0125] In practical applications, each step can be refined and adjusted according to specific needs. For example, in step S1, planning-related data can be obtained through cooperation with external departments for matching; in step S4, advanced AI technology and intelligent analysis technology can be used to improve the effect of data superposition and visualization.
[0126] In addition, it should be noted that: an embodiment of the present application also provides a computer-readable storage medium, in which a computer program is stored. When the computer program is loaded and executed by a processor, the method described in the above embodiment is executed.
[0127] In addition, it should be noted that an embodiment of the present application also provides an electronic device, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor. When the processor loads and executes the computer program, the method described in the above embodiment is executed.
[0128] The above contents are further detailed descriptions of the present invention in combination with specific preferred embodiments, and it cannot be determined that the specific implementation of the present invention is limited to these descriptions. For ordinary technicians in the technical field to which the present invention belongs, several simple deductions or substitutions can be made without departing from the concept of the present invention, which should be regarded as falling within the protection scope of the present invention.
Claims
1. A method for collating and analyzing construction land supply data, characterized in that: The method comprises the following steps: S1, data integration and spatialization; S2, build a spatial analysis model; S3, multi-source data fusion analysis; S4, visualization and interactive exploration; S5. Decision support system construction and optimization strategy are proposed.
2. A method for collating and analyzing construction land supply data as claimed in claim 1, characterized in that: Step S1 includes the following steps: S101. Collect basic data on construction land; S102, cleaning and verifying the collected data; S103. Use electronic spreadsheet or database software to establish an electronic ledger of construction land supply; S104, integrating the planning data with the land supply implementation data to form a comprehensive data set containing planning information and implementation information; S105. Use geographic information system software to associate comprehensive data sets with geographic spatial locations and establish a geographic information spatial ledger.
3. A method for collating and analyzing construction land supply data as claimed in claim 1, characterized in that: Step S2 includes the following steps: S201. Design the database architecture according to the characteristics and requirements of construction land supply data; S202, the data is cleaned, converted and formatted and then imported into the database; S203, performing coordinate conversion and projection transformation on the data to establish a topological relationship between spatial objects; S204. Based on the multidimensional data, a multidimensional spatial analysis model is constructed.
4. A method for collating and analyzing construction land supply data as claimed in claim 3, characterized in that: The multi-dimensional data include circle, land price level, land price collection status, transfer period, transfer time, transfer cost and change of use.
5. The method for collating and analyzing construction land supply data according to claim 1, characterized in that: Step S3 includes the following steps: S301. Based on multi-source data and models, conduct land price forecast analysis, land price level analysis, land supply history evolution and land transfer special data analysis; S302. Use a region-based regression analysis method to predict land prices in future quarters; S303. Calculate the average, highest and lowest land prices for various types of land, and analyze the overall distribution and fluctuation range of land price levels.
6. A method for collating and analyzing construction land supply data as claimed in claim 1, characterized in that: Step S4 includes the following steps: S401, collect historical images and remote sensing images, and perform pre-processing and standardization; S402, superimposing the processed thematic data with the analysis data in step S3 to form a state-owned construction land supply map containing multi-source information; S403. Use map visualization technology to render and display the state-owned construction land supply map to improve the visualization of data.
7. A method for collating and analyzing construction land supply data as claimed in claim 1, characterized in that: Step S5 also includes the following steps: S501, statistically analyzing the construction land supply data, and constructing a construction land decision support module, which is used to generate land use optimization plans and policy recommendations based on user needs; S502. Obtain the total supply, supply structure and supply trend of construction land according to the rules and development trends of construction land supply data.
8. A computer-readable storage medium having a computer program stored therein, characterized in that: When the computer program is loaded and executed by a processor, the method according to any one of claims 1 to 7 is adopted.
9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and capable of running on the processor, characterized in that: When the processor loads and executes the computer program, the method according to any one of claims 1 to 7 is adopted.
Citation Information
Patent Citations
Land resource information management system
CN108765239A
Grid land price evaluation method
CN110648160A
Land price monitoring system
CN117035831A
Land reserve monitoring and supervising system and method
CN117522310A
Method and system for acquiring land utilization change information based on resource data
CN118152501A
