A MySQL-Based Software System of Urban Land Planning Database of Shanghai in China

With the development of the digital city,data and data analysis have become more and more important.The database is the foundation of data analysis.In this paper,the software system of the urban land planning database of Shanghai in China is developed based on MySQL.The conceptual model of the urban land planning database is proposed,and the entities,attributes and connections of this model are discussed.Then the E-R conceptual model is transformed into a logical structure,which is supported by the relational databasemanagement system(DBMS).Based on the conceptual and logical structures,by using Spring Boot as the back-end framework and using MySQL and Java API as the development tools,a platformwith datamanagement,information sharing,map assistance and other functions is established.The functionalmodules in this platformare designed.The results of J Meter test show that the DBMS can add,store and retrieve information data stably,and it has the advantages of fast response and low error rate.The software system of the urban land planning database developed in this paper can improve the efficiency of storing and managing land data,eliminating redundant data and sharing data.

Reform of Japan’s Land Planning and Implications to China

This paper first briefly summarized the current state of exploration and construction of China’s land space planning.Then,it analyzed Japan’s land planning reform,studied its spatial planning process and explored relevant reform paths to obtain relevant experience.Through analyzing and summarizing the experience in the exploration of Japan’s land space planning in combination with China’s specific national conditions,it is intended to draw implications for China’s land space planning in the new era,in order to provide references for the future operation of related actual projects of land planning and exploration of related strategic theories.

Integration of Transport and Land Use Planning by Transit-Oriented Development for Economic Sustainability of the Standard Gauge Railway Projects in Tanzania

Tanzania is one of the countries in Africa that has engaged in the projects for construction of the electrified Standard Gauge Railway (SGR). However, lack of integration of transportation and land-use planning threatens economic sustainability of the SGR project. This study was carried out for the purpose of finding-out how transportation can be integrated with land-use planning for economic sustainability of the project. The study was carried-out by using qualitative research approach through demonstration as case study. Findings show that construction of the SGR is not integrated with land-use planning around the stations and along the SGR corridor. It is concluded that economic sustainability of the SGR projects can be achieved by integration of transport and land-use planning. As demonstrated, it is recommended to deliberate for integration of transportation and land-use planning in the SGR projects of which the prime land within Transit Stations can be efficiently used by using Transit Oriented Development and secure more land for production activities around the Transit Stations and along the SGR corridor.

How Land Use Policies Are Transforming Shifting Cultivation to Short Fallow Systems and Permanent Cultivation of Annual Crops in Tanzania

Recent studies show that shifting cultivation in Tanzania has transformed into more intensive farming practices. One of the drivers of this shift is the implementation of policies that favor sedentary farming. However, there is inadequate information on how this transformation operates at the village level. Based on a case study of one village in Central Tanzania, this study demonstrates that the village land use plan is the primary policy tool for the transformation and intensification of shifting cultivation at the village level. Through the land use planning process, land is allocated only for lawful uses such as settlement, permanent cultivation, and the village forest reserve. No land is designated for shifting cultivation. Additionally, the land use plans are accompanied by by-laws that restrict shifting cultivation practices, such as the use of fire during land preparation and leaving the land fallow for more than 3 years. The intensification of shifting cultivation was not associated with an increase in the use of farm inputs such as improved seeds, fertilizer, or irrigation, as is commonly practiced in sustainable intensive agriculture. Instead, it was associated with the adoption of short fallow farming systems and labor-intensive land preparation methods, such as deep plowing to loosen the soil and sub-soiling vegetation.

Effects of "Political Cycle" on Land Use Planning in China

As an explanation to economic cycle, political cycle theory has been widely used, and political factor has been gradual y recognized as an important fac-tor in influencing economy but not simply exteranl factors. However, there is stil a lack of enough research combining political factor and land use. Based on the exist-ing literature, we analyzed the mechnism and performance of howe political cycle with Chinese characteristics influence land use plannning in China, and specific so-lutions were put forward by combining the influences with the airm to promote bet-ter implementation of the planning goals.

Status of and Strategies for the Planning and Design, Maintenance and Management of Chinese Urban Green Land——Application of Ecological Concepts in This Field

The sustainability of the planning and design goals of urban green land and that of its maintenance and management are mutually related and act as an organic whole. For a long time, the independence of the two is more prominent than their organic connection. This research has made preliminary considerations from three aspects. First, it concerns infusing the concept of ecology, contemplating and demonstrating space, as well as reducing the incidence of plant diseases and insect pests of urban green land. Second, the arrangement of flowers and trees for the planning and design of urban green land should comply with the biological attributes of flowers and trees to realize the organic unification of biological and scenic attributes of flowers and trees. Third, the planning and design of urban green land should attach importance to the organic unification of biological and scenic attributes of lawn grass seeds and reduce the difficulty of maintaining lawn. This research attempts to reduce the pressure of maintaining urban green land from the beginning, i.e. the planning and design of urban green land. It also tries to reduce the cost of maintenance and management to the realize planning and design goals of urban green land and the sustainability concerning its maintenance and management and arrive at the mutual unification of the planning and design as well as maintenance and management of urban green land.

Embodiment of "Ecological,Cultural,Landscape,Vigorous" Campus—A Case Study of the Planning of Environmental greening in New Campus of Laiwu Vocational and Technical College

The general situation of new campus of Laiwu Vocational and Technical College was introduced.The guiding ideology was that with the purpose of serving faculties and students as the purpose,the designing will be fully combined with excellent natural environment and campus technology and culture,and with ecological landscape as the major and sustainable development as the aim,striving to highlight the theme and landscape,a comfortable,vigorous,innovative and beautiful outdoor spatial environment would be created.In accordance with the planning principle of "people-orientation,ecology,sustainable development,embodying the characteristics of landscapes,overall planning and varied practices",based on the planning thought of "procession of whole and part,of technology and art,of buildings and environment and of landscaping methods",the overall planning and regional division of constructing "ecological,cultural,landscape,vigorous" campus was proposed,that is,the campus environment would be divided into six functional zones(the entrance door zone,footsteps zone,teaching activities zone,life services zone,athletic activities zone and ecological recreation zone) and ten scenic areas(gate landscape area,scientific and technological culture corridor,ecological recreation area,culture exhibition area,Xiushui Lake scenic area,knowledge park,living landscape area,art exhibition area,mountainous scenic area and sports activities area),and meanwhile landscaping plants were planned.

Geo-Parks Planning Based on Land Coordination Analysis——A Case Study of World Geo-Park of Yuntai Mountain

By taking the World Geo-Park of Yuntai Mountain for example,based on its present land using,interpretation of its remote sensing images,and systematic analysis by MAPGIS,the authors analyzed the coordination between land use and park construction in the study area,proposed suggestions for moderate adjustment of the original land structure to control the scale of construction land,protect and expand ecological land use,geological heritages and landscape land use.All land uses should be comprehensively coordinated,and the role of land use planning of the scenic area as a coordinator should be stressed.Moreover,results of the re-investigation should be properly utilized to optimize the new round of planning,particular land value of the scenic area should be highlighted,so as to form the benign circulation between new human activities and eco-environment,provide a new concept and approach for the sustainable development of the geo-park.

Ecological niche suitability model with an application in Taojiang land use planning

Ecological suitability analysis is an important step in ecological planning. It applies the basis toestablish a sound development planning. In this paper, by applying multi-dimension niche concept, an eco-logical niche suitability (ENS) model was developed. The ENS model, combined with geographical informa-tion system (GIS) and spatial simulation, was used to analyze regional resources and environmental features ,and identify the suitability of regional resource and environment to regional development. An application ofthe ENS model in Taojiang agricultural land use planning is presented.

Mountain Land Use Planning of Metropolitan Suburbs:the Case of the Jinyun Mountain and Its Surrounding area,Chongqing,China

Open space of metropolitan suburbs in mountain region, has been increasingly becoming the coupling mosaic structure of industrial actions and landscape behaviors. However, the local governments, when making land use planning, often aim at economic development, and rarely refer to the coordination of compatibilities and conflicts between industrial actions and landscape behaviors in the mosaic structure. In this study land use in the Jinyun Mountain and its surrounding area, Chongqing is adjusted by gray multi-objective programming approach and local-level decision-making process to cope with conflicts between objectives for human welfare and objectives for landscape conservation. The results indicate that： 1） the compatibilities and conflicts among different behavior characters and different landscape types result in the compatibilities of landscape to human behavior; 2） a land use planning in the study area is produced based on the sustainable land use and social-eco development, which pays more attention to the resources and environment constraints and economic objectives, and follows the distribution law of rare resources; 3） in the study area, cultivated land of 1,207.27 ha can meet the demands for food and byproducts by the residents there, orchard land and forestland of 632.55 ha, 2,276.61 ha, respectively can provide enough spaee for the local people to improve their living structure and meet their demands for reereational activities, and urban residential land, rural residential land, mining land and transportation land of 1107.60 ha, 120.27 ha, 162.48 ha, 100.91 ha, respeetively can satisfy the resident＇s eeonomie development and infrastructures; 4） the equilibrium among industrial actions, landscape accessibility and ecological conservation can be obtained by analyzing the possible impaets of human activities on landscape eeologieal proeess in open spaee of metropolitan suburbs in mountain areas.

SUSTAINABLE LAND USE PLANNING BASED ON ECOLOGICAL HEALTH——Case Study of Beiwenquan Town, Chongqing, China

This paper, taking Beiwenquan Town of Beibei, Chongqing as an example, assessed the impacts of land use on ecological health by comprehensive index method, and discussed methodological system of sustainable land use planning based on ecological health. Results indicated that: 1) From 1992 to 2002, land use changes focused on 12 patterns with the total conversion area of 92.11%, which were related to cultivated land, residential and industrial-mining area, and orchard land. Urbanization and economic reconstruction were the leading driving forces. 2) There was obvious difference of the areas of ecotypes driven by land use change in wide valley and mild slope between 1992 and 2002, while there were little or no difference in steep slope and very steep slope. 3) Both of the conditions of ecological health in 1992 and 2002 were sound, and the ecotypes focused on the types of health and sub-health. But, health ecosystem in 1992, with an area of 764.64ha, accounting for 38.51% of the total evaluation area, was better than that in 2002, with an area of 636.10ha, accounting for 34.19% of the total evaluation area. 4) The ecotypes involved into different ranges have already degenerated, due to humankind’s disturbance, while the conditions of ecological health in the same ranges in 1992, regardless of stability and reconstruction, were better than that in 2002. 5) The planning scenario based on ecological health was accorded with the practice condition of Beiwenquan Town: 388.29ha of cultivated land could meet the Beiwenquan demand of food and byproduct; 1045.26ha of forest land area, the Beiwenquan demand of ecological health; and 1004.73ha of the residential and industrial-mining area, the Beiwenquan building demand. 6) Sustainable land use planning based on ecological health had higher useful value, because it not only stood to ecological theory, but also satisfied the developmental demand of society and economy.

An Uncertain Programming Model for Land Use Structure Optimization to Promote Effectiveness of Land Use Planning

Land use structure optimization(LUSO) is an important issue for land use planning. In order for land use planning to have reasonable flexibility, uncertain optimization should be applied for LUSO. In this paper, the researcher first expounded the uncertainties of LUSO. Based on this, an interval programming model was developed, of which interval variables were to hold land use uncertainties. To solve the model, a heuristics based on Genetic Algorithm was designed according to Pareto Optimum principle with a confidence interval under given significance level to represent LUSO result. Proposed method was applied to a real case of Yangzhou, an eastern city in China. The following conclusions were reached. 1) Different forms of uncertainties ranged from certainty to indeterminacy lay in the five steps of LUSO, indicating necessary need of comprehensive approach to quantify them. 2) With regards to trade-offs of conflicted objectives and preferences to uncertainties, our proposed model displayed good ability of making planning decision process transparent, therefore providing an effective tool for flexible land use planning compiling. 3) Under uncertain conditions, land use planning effectiveness can be primarily enhanced by flexible management with reserved space to percept and hold uncertainties in advance.

Integrated Application of RS and GIS to Agriculture Land Use Planning

This paper gives some guidelines of land use planning firstly.A framework of agriculture land use planning is designed based on land use suitability evaluation using integrated technologies of RS and GIS.Further work expected is also given.

Research Progress in National Land Use Planning and Implementation Guarantee System

Land use plan serves as a leading role in land resource management, necessitating a powerful implementation guarantee system. The research concluded researches on guarantee system for land use plan from law, administration, econo- my, society and technology. Finally, existing problems and suggestions were pro- posed.

Development and Prospect of Zoning Mode in the Three Rounds of Overall Land Use Planning of China

Zoning system is the basic mode of establishment of overall land use planning. In this study,the zoning mode and practice in the three rounds of overall land use planning that have been carried out in China were analyzed and summarized firstly,and then some obvious problems existing in the implementation of the zoning mode were analyzed. Finally,countermeasures and suggestions were put forward to provide necessary reference for further development and improvement of the zoning mode and the development of overall land use planning at all levels in China.

Ecological planning of land use in the central area of Tianjin,China

This paper is attempted to develop a set of suitable principles and methodologies for urban ecological planning of land use,to analyze the ecological suitability of different kinds of land use patterns of Tianjin City, to help local decision makers to work out concrete ecological strategies for promoting a sound development of the city and for improving the life quality of the citizens, and to provide the decision makers with a new approach for solving the environmental problems brought about by the improper mixture of industry and residence.

Change in Ecosystem Service Value Arising from Land Consolidation Planning in Anhui Province

The evaluation of change in ecosystem service value arising from land consolidation planning is an important aspect of environmental impact assessment of land consolidation. By estimating the change in ecosystem service value before and after the implementation of land consolidation planning, it is able to quantitatively describe the change in ecosystem service value arising from land consolidation planning, so as to provide a quantitative basis for the environmental impact assessment of land consolidation. Taking the case of Anhui Province, the authors developed the equivalency factor table of ecosystem service value, to determine the economic value of single equivalency factor of ecological service value in the study area, calculate per unit area of ecological service value of land ecosystem in the study area, and research the change in ecosystem service value before and after the implementation of land consolidation planning in Anhui Province. The results show that after the implementation of a new round of land consolidation planning in Anhui Province, the total ecosystem service value may decrease to some extent, the farmland ecosystem service value substantially increases, while water body ecosystem service value greatly decreases.

Safeguard Measures for Implementation of New Round of Land Consolidation Planning

We conduct a comprehensive analysis of the current situation of security system for implementation of China's land consolidation planning. The prominent problems in the process of implementing safeguard measures for planning are summarized as follows: the guiding ideology for planning formulation is imperfect; the legal basis is weak, and administrative means are not sound; the economic security mechanism is not brought into full play, and the social security measures still need to be further deepened; the technical safeguard measures are short. From laws and regulations, administrative management, economic security, social supervision, technology management and other aspects, we establish the scientific security system for implementation of land consolidation planning; put forth the recommendations for guaranteeing the implementation of planning in China.

Digital Problems and Strategies of Partial Revision in Overall Plan of Land Use

The technical route of partial revision in overall plan of land use is briefly described.It is pointed out that problems of area measuring in the technical route are mainly due to the digital process.The digital problems of partial revision in overall plan of land use are presented as follows:the maps are not proofread before digitalization;the coordinate matching and projection transformation are not conducted on the maps;the information is asymmetrical pre and post the digitalization;the location lacks precision;the result maps are substandard.The causes of these problems are analyzed,which cover the following aspects.The lack of united management regulations;uneven working abilities of the staff in the compilation units;unawareness of the importance of map digilalization;poor basic conclitions of the original plan maps.At last,the relevant suggestions are put forward,for instance,releasing the national united management methods and technical criteria,establishing industrial admittance system and qualification system of complication units,setting up the mechanism of supervising digitalized results and controlling the quality,conducting coordinate matching and projection transformation and unifying the specification and mode of the results of maps so as to provide technical support for the overall plan of land use,play the micro-regulating role of land use and take a leading role in the sustainable development of social economy.

Study on the Programming Standard for Ecological Rescue in General Land Use Planning

This paper aims at establishing the operation idea based on the analysis of the connotation,principles and reference indexes for programming standard for ecological rescue.The paper puts forward that the programming standard should take into account the natural,social and economic reference indexes,and modifies the scale and distribution of the ecological rescue according to the order of ecological safety,social safety and economic development.The paper suggests that the land planning department should strengthen the study and datum accumulation in order to establish the technology regulations of programming standard of the ecological rescue.