Preliminary study on the integrated application of county-level land use database based on network in Pingxiang City, Jiangxi Province

(1. Jiangxi Land Survey and Planning Institute, Nanchang, Jiangxi, 330046; 2. Pingxiang Land and Resources Survey and Design Institute, Pingxiang, Jiangxi, 337000)

This paper introduces the technical route and method of establishing network-based land use basic database integration in Pingxiang City, Jiangxi Province, which provides technical basis and working ideas for developing county-level land use database integration application in the future.

Keywords: network type; Database; Integrated application; study

Research background and feasibility analysis of 1

The research background of 1. 1

1999, Jiangxi province started the construction of 1∶ 1 Wanxian (city) level land use status database. Pingxiang is the pioneer of modern industry in China, the birthplace of the workers' movement in China, the main outbreak of the autumn harvest uprising and the holy land of the Red Revolution. Pingxiang City is located in the west of Jiangxi Province, on the border of Hunan and Jiangxi, and now has jurisdiction over Shangli, Luxi and Lianhua counties, Anyuan and Xiangdong districts and a provincial-level economic development zone-Anyuan Economic Development Zone. Since 2000, Pingxiang City has completed the database construction of land use status in four districts and counties except Lianhua County, and passed the pre-acceptance organized by the provincial offices. The results of the project have played an important role in land management in various places. At the same time, the relevant research results show that although the database construction has been carried out in an all-round way and made important progress, there are still some problems in the application of the results, mainly in the following two aspects: ① the phenomenon of "idle databases" and "dead databases" is widespread, and some databases have not played their due roles in practical work; (2) It is difficult to integrate the database results of counties and districts, and the data cannot be circulated and enjoyed, so it is difficult to play a role at or above the prefecture level.

At present, the country's land management system and management functions have undergone major changes, and land resources management has participated in macro-control. The start of the "Golden Land Project" has also put forward new requirements for the management of land use status data. The new situation, new management system and management function require us to re-examine the management and application mode of land use data. For the municipal land and resources management departments, how to integrate and apply these scattered and independent 1∶ 1 county (city) land use databases to serve the management work such as construction land approval, cultivated land protection and land use planning is the key problem to be solved in the pilot study.

Feasibility analysis of 1.2

1.2. 1 With the rapid development of information technology, the key technologies needed for research have matured.

In recent years, information technology has developed rapidly, and mass data storage and data warehouse technology, large-scale database technology, network technology, Web-based applications and communication technology have been continuously improved. The application of "3 S" technology in land and resources investigation is becoming more and more mature; Network information security technology is changing with each passing day, and the rapid development of these key technologies has created good technical conditions for this pilot study.

1.2.2 the construction of land and resources information network and the trial of various related technical standards laid the foundation for this study.

The construction of land and resources information network system makes the transmission, exchange, sharing and comprehensive application of land spatial data become a reality; At the same time, in 20001year, the Ministry of Land and Resources promulgated and tried out the Standards for Land Use Databases at County (City) Level and the Technical Regulations for Land Use Databases at County (City) Level, and in the same year organized the evaluation of the national database building software platform, which enabled the construction of land use databases in Jiangxi Province to be carried out under the unified data format standards and standardized technical routes and the unified MAPGIS platform of the whole province, laying a solid foundation for the development of this pilot study.

1.2.3 The attention of leaders is a strong guarantee for this survey.

The leading group of Pingxiang Municipal Bureau of Land and Resources attaches great importance to the informatization construction of land and resources, and specially set up the "Pingxiang County Land Use Database Integration and Application Pilot Leading Group" composed of the municipal bureau and county directors, which ensured the smooth development of this research work. According to the development idea of "overall design, step-by-step implementation, integration of resources and rolling development", the party group of this bureau has incorporated information construction into the "number one project", with a personal investment of nearly 7 million yuan to carry out aerial photogrammetry and related basic database and information system construction in Anyuan District, where the municipal government is located. In addition, the intelligent office building of Pingxiang Land and Resources Bureau with an investment of more than 38 million yuan was delivered at the end of June 2005, and has been connected with the government network, realizing multi-level data sharing among provinces, cities and counties, and the data exchange system has initially taken shape.

2. The overall goal and main research contents of the pilot project.

2. 1 Overall objective

On the basis of full investigation on the management and application of land use database, this paper deeply analyzes the land use data management mode, data update mechanism and data application requirements of municipal and county land and resources management departments, puts forward the construction scheme of county-level land use database integration application system based on network and conducts pilot demonstration, and carries out research on database integration application methods. It provides a technical basis for solving the * * * sharing and integrated application of database results of1:10000 land use status database construction project.

2.2 Main contents

(1) This paper studies the framework system and operation mode of the integrated application of county-level land use database based on network, focusing on the basic data update system and maintenance update mechanism of the integrated application of county-level land use database based on network, and how to realize distributed multi-level management under various operation modes, so as to realize the synchronous update of data at all levels and ensure the current situation of the database.

(2) Study the implementation mechanism and construction framework of land use status database as the basic data of land and resources system in distributed environment, and effectively serve the land and resources informatization.

(3) Construction and application demonstration of municipal land use database. Based on the acquisition, processing, integration and comprehensive analysis of land use data, the unified management, information exchange, information release, information mining and data appreciation of land use data are realized, which provides a demonstration project for the construction and application of municipal land use database.

3 Comprehensive application demand analysis

3. 1 functional requirements analysis of system construction

3. 1. 1 business application requirements

According to the needs of land and resources management in Pingxiang City, the database integration application system developed this time further emphasizes the storage and management of data in different places, strengthens the management of heterogeneous, pluralistic and multi-scale land use data, supports the county land bureau to extract, process, process, count and analyze the land data stored in different places by Pingxiang Municipal Bureau, and supports the call of land use status database in land and resources management such as cultivated land, protection, planning and utilization.

3. 1.2 data management requirements

It can reasonably store and manage all kinds of land data, including spatial graphic data, attribute data, table data and text data, and can meet the needs of large data volume and real-time data distribution.

3. 1.3 Data update and maintenance requirements

In order to meet the needs of real-time and batch updating of land use data in Pingxiang city. Including multi-level management of synchronous updating of land use database, including synchronous updating of land use database and technical route of updating land use database, including database replication, data synchronization, data provision, data online transmission, etc.

3. 1.4 Security and scalability requirements

Provide a perfect security system to ensure the absolute security of land and resources management data and systems, and meet the absolute security of systems and data when providing services for various needs of all levels, departments and units and land management business.

3. 1.5 institutionalized operation management requirements

Provide standardized operating standards and systems, and establish a long-term and stable operation and maintenance mechanism.

3.2 Analysis of Problems to be Solved in Project Construction

3.2. 1 The construction of this project should follow the "Golden Land Project" and the construction of land and resources e-government.

The pilot application of land use database integration in Pingxiang City is the deepening of land and resources management in this city, the in-depth application of land use database construction in all counties and districts of this city, and the component of "Golden Land Project" in Pingxiang City. The project construction must fully meet the needs of land management application and work in cities and counties, connect with the province's land and resources e-government construction system, and obey the big framework of future e-government construction.

3.2.2 Municipal land use status data is updated step by step.

According to the requirements of the "Golden Land Project" implementation guide and the needs of land and resources information network management, municipal land use data must be updated step by step. These contents have been considered in the system design, and the management concept of distributed database has been fully utilized to realize data synchronization and * * * sharing between Pingxiang Municipal Bureau and county land and resources bureaus.

4 technical route and technical implementation method

4. 1 Overall framework system and operation mode of Pingxiang two-level database integration application

According to the actual distribution of Pingxiang cities and counties, the system adopts the B/S network structure which is mainly composed of fat servers and thin clients, supplemented by the C/S network structure with good interactivity. Based on MAPGIS software, the distributed mass data management and multi-level distributed cooperative working mechanism are realized by making full use of DBMS technologies such as data management, server cluster, directory service, distributed components and distributed transaction management. The organization form of the database is "single logic, multi-physics", and the whole system is a database in logic, that is, the database of land use status is physically composed of the databases of land and resources bureaus of various districts and counties. In this form, each branch office is well isolated, data security is easy to ensure, and each branch office is allowed to have different business logic in business.

A data center was established in Pingxiang Land and Resources Bureau, and an IBM high-performance server was purchased for centralized storage and management of multi-scale comprehensive databases in municipal counties. Under the MAPGIS platform developed in cooperation with Wuhan Zhongdi Information Engineering Co., Ltd., the Municipal Bureau installed the integrated application system software of county-level land use database based on network. All county-level land and resources bureaus can access, call and manage the land use database at the same level only through the local government network line and IE browser, and can easily complete statistics, analysis, drawing, tabulation and summary through remote calling technology. If there is any change, the county land bureau will provide the measured geodetic coordinates and a set of corresponding land use approval materials, and finally the municipal land bureau will update and maintain the database in a unified way.

4.2 Implementation Scheme of Database Integration Application

The pilot project was realized by using the database integration system software based on MAPGIS platform independently developed by Wuhan Zhongdi Information Engineering Co., Ltd., and the implementation plan passed the expert review organized by the Ministry of Land and Resources on February 28, 2005.

Pingxiang land use database construction adopts the unified MAPGIS platform in the whole province, and the whole city is at the same central longitude, so there is no need for data conversion and projection conversion. As soon as possible, arrange the counties and districts that have not completed the investigation of land use status update, and ensure the status quo of land use databases in counties and districts integrated by municipal databases. Check the database of land use status in counties and districts, and correct any mistakes in time. According to the centralized management mode, the county land use status database is integrated to form a separable and combinable municipal land use database.

4.3 Web-based urban and county land use database integrated application function design

4.3. 1 county land use database comprehensive application function design

4.3. 1. 1 data management

(1) data storage organizes and manages all kinds of land use linear data by county, and establishes a separable and combinable municipal database, including spatial graphic data and attribute data.

(2) Obtaining Data Users can obtain the data of counties, townships and villages by clicking with the mouse. If the county data does not exist, a prompt will be given.

(3) Display of data Users can zoom in, zoom out, and pan the graphics with the mouse. They can also click on the layers with the mouse to control whether to display the layers and adjust the overlapping order of the layers.

4.3. 1.2 Information query

Basic query

(1) Attribute information query Users can query various thematic data information of land use by clicking the graphics with the mouse, such as land use status, information of patches and linear elements, basic information of parcels, information of boundary points, information of boundary lines, information of basic geographical elements, etc. Users can also query spatial graphic information by inputting conditions.

(2) Historical information query Users can query the historical change information of a spatial graph.

statistical analysis

(1) Query statistics in any range can query all kinds of thematic data in any given range, and can make statistics on the query results according to given conditions and output charts.

(2) Buffer query statistics For the selected linear and point elements, various thematic data in the buffer can be queried according to the given buffer radius, and the query results can be counted and charts can be output according to the given conditions.

(3) Conditional query statistics can query various thematic data in the region according to given conditions, and can output graphs and tables according to the query results of given conditions.

summarization of data

Support the summary of land use status data with villages, townships (towns), counties (districts) and cities as statistical units, and get various thematic summary data.

4.3. 1.3 Maintenance of data and user role permissions

Include data dictionary maintenance, data download, data reduction, data output, etc.

Provide user role permission maintenance tools, which are used to establish and maintain system accounts (user names and passwords) and user permission settings.

4.3. 1.4 Auxiliary audit management

The ownership, land type and area involved in the examination and approval of construction land and the implementation of the overall land use planning shall be subject to auxiliary audit management.

4.3.2 Comprehensive application function design of municipal land use database

On the basis of the above-mentioned county-level functions, the organization and management functions of change data collection and dynamic update of distributed database are added.

4.4 Web-based municipal land use database integration application framework

Pingxiang municipal land use database is a tree-like basic spatial database. Constructing multi-granularity spatial data set through multi-level classification coding system. The spatial database engine and its unique grid index are used to access the data in the massive database, and the administrative division index formed by the classification and coding between the granular data sets at the city and county levels is used to quickly retrieve the corresponding data. The municipal land database adopts a tree structure to centrally manage the municipal granularity data and the county granularity data. Click on the theme in the municipal node to access the municipal granular data, click on the theme in the county node to access the county granular data, and also access the county granular data where the administrative region is located through the administrative region index.

Through this mechanism, the integrated management of physically separated multi-source, multi-scale and multi-granularity data is finally realized, and the dynamic interaction and automatic switching of graphic data browsing, query and statistics are realized, so that all data are logically integrated and easy to update and use.

4.5 Main technologies adopted in this pilot study

4.5. 1 Multi-dimensional massive spatial data storage management technology

Land use data has the characteristics of mass. Using the integration method of relational database technology and spatial database engine, spatial data is managed through relational database, so that massive spatial databases are stored in relational database. Spatial database engine allows users to realize distributed storage and management of GIS applications among database server, client and application server.

4.5.2 Remote calling technology

Land use data is based on database and network technology, and the technology of network server construction, management, storage and remote call is studied to realize data sharing.

4.5.3 Spatio-temporal analysis technology

The core of spatio-temporal analysis technology is how to effectively express, record and manage the changes of real-world entities over time. This spatio-temporal change is manifested in three forms: ① attribute changes, and its spatial coordinates or positions remain unchanged; (2) The spatial coordinate or position changes, but the attribute remains unchanged; ③ The spatial coordinates and attributes of spatial entities have changed.

4.5.4 Data splicing technology

According to the data storage mode and organization mode of county land use database, the technology of database map boundary and administrative division boundary is studied. For example, the joining of sheets is not limited by the number of sheets, and graphic editing and attribute editing in the joined state are allowed.

4.6 New mechanisms and technologies to be integrated and improved.

Due to the tight time and heavy task of this pilot project, some new technologies will be integrated into Pingxiang county-level land use database comprehensive application system based on network through trial operation in the future.

4.6. 1 New land use data update and maintenance mechanism

According to different regions and data sources, remote sensing data are used to assist county-level land use change and update county-level land use database, forming a variety of operational land use change and land use database update technical processes and corresponding maintenance mechanisms.

4.6.2 Land use data updating technology integration based on "3S" technology.

On the basis of integrating the existing technologies, starting with the data collection and collection technologies, the field data rapid investigation and data collection based on "3S" integration technology, "GPS+PDA" and "star measurement" technologies are integrated to realize the rapid acquisition, processing and updating of county-level land use data, including: fast and efficient processing of orthophoto maps based on aerial remote sensing data; Fast processing of satellite remote sensing data and extraction of land change information, including high-resolution satellite data processing, automatic information discrimination and quantitative extraction technology.

5 Main achievements of the project

(1) Pingxiang land use database integrated application management system based on network;

(2) Data update system and maintenance update mechanism of Pingxiang land use database integration based on network;

(3) Various reports on the framework system, operation mode and key technologies of the integrated application of Pingxiang land use database based on the network.

6 conclusion

As one of the two pilot projects in China, the pilot research project is carefully organized by China Land Survey and Planning Institute, led by Jiangxi Land Survey and Planning Institute, and implemented by Pingxiang Land and Resources Bureau and its counties and districts in accordance with unified planning. After several stages of efforts, such as project evaluation, demand analysis, scheme design, scheme demonstration, organization and implementation, new application requirements are constantly put forward through trial operation, and the application system is still improving.

Fortunately, the high-efficiency networked integrated application system of Pingxiang county-level land use database has been gradually recognized by Pingxiang city and the county land bureau under its jurisdiction, and the application system is also being tested by practical work. At the same time, the land management departments at all levels in Pingxiang City are gradually forming and standardizing the concept and mechanism of database updating. The ultimate goal of this pilot study is to study municipal land management, establish a network-based integrated application system of county-level land use data, form a coordinated, high-speed and unified land use digital information management and sharing mechanism, and make the county-level land use database construction project better serve the informationization of land and resources.