Urban underground pipeline was an important part of urban public infrastructure, and it was lifeline of cities. Application research of urban underground pipeline management information system also was important to urban underground pipeline manager, and we could manage underground pipeline efficiently when we depended on 3D technology. The paper introduced data model of pipeline network, and introduced how to establish basic 3D objects class of urban underground pipeline management information system. We realized the 3D underground pipeline network and completed the query and network analysis of underground pipeline. Finally the paper provided a preview and conclusion of underground pipeline management information system.

With the development of coal technologies, the previous management mode has been unable to meet the requirements of modern coal mine construction, so it is essential to design a new and effective security management information system. The design of this system is based on B / S structure, which main function is to collect and analysis the basic information of coal mine. In such a management information system, administrators can keep abreast of information in coal mine, detecting the abnormal situation timely and solving the problem effectively. Besides, the information input module in the system is easy to use, and users can also filter the information when using the system to inquiry, the query results can be outputted in tabular form. The system can also sort out all kinds of violation cases and accidents in the form of security information report, showing to the administrators. In another data analysis module of the system, it reveals the contents of the security information table by a bar chart. To ensure the security of the system, login steps are needed. Anyone who entering this system can modify the password, but each person’s permission is different, and they can only operate within their own permission scope.

Abstract. "Sandwich class housing" is an emergent social problem in most cities of China. Where to locate the public housing for sandwich class and what kinds of building layout fit into the needs of sandwich class are two basic questions to local governments. This paper proposed a locating approach of sandwich class housing through analytic hierarchy process method, which considers the influence of income, distance, time total money cost, school, hospital, store, neighborhood on the choosing of housing locations. As result, 9 candidate locations were chosen as the housing location for sandwich class in Wuhan city. Also, this paper presents some building layout design plans for meeting the needs of sandwich class livings. They can be categorized as diverse, changeable and detailed layout designs. The feature and satisfied functions of these categories were discussed in this paper. Both works can provide a suggestion for local government to make decisions of building public housing for sandwich class.