(1. School of Surveying and Mapping, China People's Liberation Army Information Engineering University, Zhengzhou, 450052; 2. Unit 73603 of Nanjing Military Region, Nanjing, 2 10049)

Abstract: As one of the application fields of land information system, the informatization development of land information system has brought great development opportunities for the development and construction of urban information system. Among them, urban construction multimedia materials and urban electronic maps, as important achievements of urban construction source investigation, have the characteristics of large quantity, wide distribution and rich information. Centralized management of urban construction census data by computer is of great significance to the statistics, evaluation, analysis and planning and utilization of urban construction comprehensive information. This paper introduces the system demand analysis, system architecture, system database and function design of urban construction integrated information system, discusses in detail the key technologies of system implementation, and summarizes the characteristics of the system.

Key words: space utensils; ; SQL Server basic class library; Comprehensive information of urban construction

Land information system is an important part of national information resources, and it is developing in the direction of informationization. It has gradually become an important part of information industry and a pillar industry facing 2 1 century. This information revolution is fundamentally changing the way people produce, live and interact with each other. As one of the application fields of land information system, the field of municipal engineering construction has been greatly impacted, and the development and construction of urban information system has also gained great development opportunities. With urban surveying and mapping, multi-scale electronic maps of 1: 1000, 1: 5000, 1: 10000 have been formed, as well as various planning maps, utility maps, road network maps, red line maps and various maps reflecting urban planning and construction. In addition, land planning and land-related information also need to be preserved and summarized for a long time; At the same time, all kinds of planning drawings need to be covered up and reported for evaluation to provide a basis for leadership decision-making. Traditional storage management methods can't meet the demand well. The centralized management of urban construction comprehensive information by computer can realize the scientific management and efficient utilization of information collation and summary, which is of great significance to the statistics, evaluation, analysis and planning and utilization of urban construction comprehensive information.

1 system requirements analysis

1. 1 construction goal of urban construction integrated information system

This system is mainly used for urban construction planning, meeting the growing business needs, providing various auxiliary tools and comprehensive information browsing and querying functions, and processing all kinds of documents (including relevant laws and regulations, historical archives information, pictures, electronic maps, audio-visual files, etc.). ).

1.2 system to achieve the goal

(1) Centralized management of multi-scale electronic maps, documents in various formats, drawings and archives, and audio and video information mapped by the Planning Institute.

(2) Mass electronic maps of cities or regions are stored by physical framing and managed by logical dynamic splicing, so as to realize hierarchical and fast focused roaming of electronic maps from macro to micro, and provide quick query and positioning functions according to place names, roads and map sheets.

(3) Provide the collection, maintenance, management and query functions of urban road library and place name library.

(4) The system provides a batch information collection tool, which can quickly collect documents, pictures, videos, audio files and other information in various formats scattered in the computer into the database for classification, organization and centralized management, and can quickly browse and query.

(5) Query of land use map.

(6) The system has perfect functions, strong practicability, beautiful interface and strong authority management function.

2 system design

2. 1 system framework structure

Urban construction comprehensive information system mainly manages four kinds of information through database management system: electronic map, drawing file information, document information and video information. The frame structure of this system is shown in figure 1, which shows the whole process of the system from data acquisition to data management, data processing and data output application.

Figure 1 Flowchart of Integrated Information Management

The comprehensive information investigation of urban construction is carried out in the form of investigation team. Through the input and summary of comprehensive information, the database file recording comprehensive information is reported to realize the reporting and receiving of comprehensive information data.

(1) The system uses SQL Sever database to manage the attribute information of multimedia data and the attribute information and spatial information of each element in the electronic map, which ensures the security and enjoyment of all kinds of information. The system should be able to manage and query comprehensive information, maintain the database and other daily work of urban construction comprehensive information management.

(2) The application of the system is embodied in query statistics, report and map output, quick retrieval of map elements and decision support.

2.2 data management strategy

Map data includes two parts: spatial data and attribute data. This system adopts the data management mode of full database management, which ensures the security and appreciation of data.

2.2. 1 database design

According to the characteristics of urban construction information, the system covers four types of information: map information, picture information, document information and video information.

The system uses a dictionary table to record the category information of each comprehensive information. A dictionary is like a template, and the information selected from this template will change according to the change of the template. The design of dictionary ensures the consistency of system information. In addition, the system also uses dictionaries to record detailed information and professional information.

Aiming at all levels of video information in each planning room, the system designs a video table to record the storage path of video in the computer.

The system uses the database design tool Power Designer of Sybase Company to design the database. The advantage of this modeling tool is that it can realize the bidirectional transformation between conceptual data model and physical data model. After the table structure of the system is designed by Power Designer, the logical structure of the database is imported into SQL Sever database to establish a physical database.

2.2.2 Map spatial information management

For the management of map spatial information, the system uses MapInfo's spatial data engine SpatialWare as middleware, and uses database management system SQL Server to manage spatial data.

2.3 system function design

As a powerful tool for urban construction, the system should have the management functions of geospatial data, urban factor attribute data and multimedia data, which are divided into the following aspects according to the subsystem functions.

2.3. 1 system maintenance subsystem

System management should set up and maintain the most basic information of the system, including user settings, password modification, system initialization, dictionary maintenance and so on.

2.3.2 Information browsing query subsystem

The subsystem mainly includes two functions: multimedia data browsing and query; Electronic map browsing query.

Multimedia data mainly includes documents, drawings and audio-visual files. The function of browsing and querying the attribute information of multimedia data directly stores the attribute data of documents, graphic files and audio and video files in the form of tables in SQL Server, and adopts the "adaptive" software startup technology, so that users can automatically start the corresponding software to browse multi-format documents according to the file format when browsing, which solves the technical problem of quickly browsing different kinds of information materials with different formats in a system.

The browsing and querying function of spatial information and attribute information of electronic map uses SQL Server to store the location information and attribute information of map objects. Map objects have attribute information, such as ID and name. By connecting the ID number, that is, the code of the map object, with the attribute database, you can select any area on the map and display the query results in the form of a report.

2.3.3 Editing tool subsystem

The subsystem realizes the functions of adding, deleting, saving, printing and browsing the comprehensive information of urban construction.

3 system implementation technology

3. 1 Basic class library is used for system development.

Using the idea of "inheritance", the system development based on basic class library is carried out in PowerBuilder. PB child window and data window objects in the system are both ancestor window and data window objects inherited from the basic class library, so that the new objects created will inherit all the characteristics of the ancestor objects, including attributes, events, functions and so on. You can also modify the inherited objects appropriately to meet specific needs.

There are other inheritable objects in the basic class library, such as windows, buttons and global functions. The design and implementation of the basic class library improves the maintainability of the system and realizes the scientific consistency of programming. Its main characteristics can be summarized as: refining * * *, independent of application.

3.2 Achieve full database management of data

3.2. 1 database management of multimedia files

Use image and text data types in SQL Server and corresponding blob types in PowerBuilder to save large text and images.

The following functions are usually used to store large text and images in a database and display them in the system by using PowerBuilder development tools:

(1) stores data in the database Updateblob table name set blob type field name =: BLOB type variable where clause.

(2) Extract data from the database, display commonly used fields through the data window, and call Retrieve. However, due to the huge amount of data of Blob type, the client's main cache is not suitable for opening too much space. PowerBuilder's solution is not to allow the placement of Blob-type fields in the data window, but to provide special statements for extracting Blob-type data. The syntax is as follows:

Column name of SelectBlob blob into: a variable of type blob in the table name where clause.

3.2.2 Database management of spatial data

Using MapInfo's spatial data engine as the database management system of middleware, using SQL Server to manage spatial data and using SQL Server to directly manage attribute data, the database management of spatial data is realized.

SpatialWare can store complex MapInfo map objects in a large database, and establish spatial data index for them, so as to realize the unified management of attribute data and spatial graphic object data on the database server. Front-end users can access these graphic object fields just like ordinary database fields, and develop a complete MapInfo application in client/server mode. If users adopt SpatialWare technology, it can completely replace the previous network application based on file server mode to enjoy MapInfo map files.

3.3 the secondary development of MapX-based controls using PB.

MapX is a programmable control based on ActiveX technology introduced by MapInfo Company. It uses the map data format consistent with MapInfo Professional, or the spatial data managed by the database management system using SpatialWare as middleware, which can realize most functions of MapInfo Professional. In the visual development environment of PowerBuilder, we only need to put MapX controls into the form at the design stage, and through programming to set properties, calling methods or response time, we can realize rich GIS functions such as data visualization, thematic analysis, geographic query and geocoding. The application of MapX component in PB environment is to use OLE container to be responsible for the interactive communication between PB and MapX. First, insert the control of OLE container into the window, and select MapX control to load it into OLE container. Buttons containing MapX property pages are automatically merged into the property pages of OLE containers, and various required settings can be made by opening MapX.

4 system characteristics

The characteristics of urban construction integrated information system developed by using GIS and MIS integration technology are as follows.

4. 1 User-friendly interface

The design of the system interface pays attention to the combination of consistency and personalization, and provides a menu similar to a browser and a large icon toolbar for command operation. In addition, the system adopts a tree-like information browsing window, which makes browsing more intuitive and convenient to use.

4.2 clear user management authority

The design of user management authority enables users with different permissions to perform different operations on data, which can ensure the security and confidentiality of data.

4.3 Multi-conditional query and statistics of multimedia information and electronic map information

The system provides multi-condition query and statistics of multimedia information, especially the addition and query of map information, as shown in Figure 2 and Figure 3.

Fig. 2 Coordinate collection of road intersection

Figure 3 Map query

4.4 Multimedia information and electronic map browsing

The system provides various forms of browsing for multimedia information and electronic map information, which is helpful to the smooth development of urban construction. As shown in figure 4.

Figure 4 Drawing browsing

The comprehensive information system for urban construction is a practical software system that uses electronic maps as the carrier and databases as the storage medium to manage the massive information of cities such as documents, pictures and videos. It realizes the automation of multimedia database construction, the networking of management and the visualization of query, statistics and analysis. The system can meet the needs of urban construction and is a powerful tool for sorting, summarizing, managing and efficiently utilizing the results of urban construction census. Of course, there are still some problems that need to be improved in the system, such as the function of basic class library needs to be further strengthened and the flexibility of custom printing table needs to be further expanded.

refer to

Guo Baoli, Kang Haitao, Li Dongdong. Practical analysis of PowerBuilder9.0 [M]. Beijing: Electronic Industry Press, 2004,406 406 ~ 4 10/0.

MapInfo Space Software Version 4.8 User Guide [M/CD]

Humboldt for men. The application of component technology in the integration of MIS and GIS [C]. Proceedings of China Geographic Information System Association 200 1, 200 1.

Ricky, Qu Shaolin, etc. Developing geographic information system with MapX [M]. Beijing: Tsinghua University Publishing House, 2003, 173 ~ 200.