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.

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.

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.

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.

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.

Land Suitability Assessment and Landuse Planning： A Prerequisite for Food Security and Climate Change Adaptation

Though Ghana＇s crop yield growth rate was at 17%, 5% of every 1.2 million Ghanaians have insufficient and limited access to nutritious food. Climate change and climate variability have enormously affected the state of agricultural productivity and hence could result in food insecurity. As many ongoing projects use Boolean suitability analysis, land use planning, management recommendations sores, it still remains inadequate to support rural resource poor farmers. This then, is affecting livelihood and agricultural productivity. In this paper, a geostatistical quantitative method to support a geographic information system （GIS） based on multi-criteria decision support system （GMCDSS） for an enhanced land suitability assessment （LSA） and landuse planning （LP） was devised. Project findings indicated that, recommended farm inputs could be estimated and applied accordingly at farm plot levels Soil amendment indicators （e.g., 1.0 t/ha lime ＋ 1.0 t/ha gypsum was estimated for liming） was quantified and currently, farmers can save money in soil fertility management. It has shown that, instead of applying 5.0 t/ha poultry manure （PM） or five bags of N-P-K fertilizer （rate of 15： 15： 15 N-P2O5-K2O/ha） ＋ two bags of sulphate of ammonia （SA）, a farmer may apply 2.0 t/ha PM ＋ two bags 15：15：15 N-P2O5-K2O/ha ＋ one bag of SA. GMCDSS assessment has proved to be fundamental in： （1） urban planning; （2） ensuring food security; （3） poverty reduction and interventions to the effects of climate change and climate variability.

Risk-analysis-based research and application of land use planning

The establishments which produce,store and use kinds of inflammable,explosive or toxic materials may induce accident,such as fire,explosion or poisonous gas dispersion,etc. Therefore,there is a need to locate these establishments appropriately and conduct land use planning in the vicinity of these establishments based on risk analysis. Consulting advanced experience which obtained from land-use planning in European countries,this paper studied on locating hazardous establishment based on risk index,land-use planning based on consequence-probability,and land-use planning based on individual risk. Frameworks and procedures of the three approaches above were determined and applied to a proposed LNG station. The results show three methods are feasible when major projects' location and their surrounding buildings or establishments' layout are considered.

Public Participation in Land Use Planning:Values and Case Analysis

Objective:we want to explore values and methods of public participation in land use planning through analysis on values of public participation and case of Ji'an County in Jiangxi Province.Methods:document and data method,case analysis method,qualitative and quantitative combined methods.Results:public participation in land use plays a positive role in improving science and practice of planning.Conclusions:preparation and implementation of land use planning should manifest human-oriented,public participation,wisdom of the masses,scientific demonstration,and democratic decision-making.

Thoughts on the Village Planning in the Context of Land Spatial Planning:A Case Study of Wentang Village,Yichun City,Jiangxi Province

Village planning is an important part of land spatial planning and an important measure to implement rural strategy.At present,the preparation of village planning is not complete,and the establishment of technical guidelines is not systematic.Therefore,the course of the development of domestic village planning and the common problems are analyzed.Taking Wentang Village,Yichun City,Jiangxi Province as an example,this paper considers the contents of land use,industrial development,residential layout,ecological environment renovation and historical and cultural inheritance from the perspective of multi-plan integration.This paper discusses the establishment method of the new round of village planning,and puts forward the safeguard measures for the implementation of the planning,so as to provide reference for the establishment of the new round of village planning.

Analysis on the Application of Quality Classification of Cultivated Land Resources in Municipal Land Space Planning:A Case Study of Chongzuo City

Cultivated land is the most important strategic resource to ensure food security.The newly constructed quality classification system of cultivated land resources considers the cultivated land health index for the first time.How the new classification and grading index system and the quality classification results of cultivated land resources to effectively guide the preparation of municipal land space planning has become a key research direction.This paper expounds the overall design idea for quality classification of cultivated land resources and classification index system.Taking Chongzuo City as an example,through the analysis of the quality classification results of cultivated land resources in the study area,using GIS spatial analysis and factor pairwise comparison method,this paper explores the application ideas and methods of quality classification research results of cultivated land resources in the formulation of cultivated land retention target,the delineation of dominant areas of cultivated land protection,the delineation of three control lines,the comprehensive improvement of land,and ecological restoration zoning in the municipal land space planning.

Planning Strategy of Tourism Service Towns under the Land and Space Planning System:A Case Study of Taiping Town in Nanchang City

In May 2019,the construction of the land and space planning system was officially launched.The Ministry of Natural Resources of the State Council issued the Notice on Comprehensively Implementing Land and Space Planning,which clearly requires all regions to comprehensively launch the land and space planning and puts forward specific work requirements[1].Later,in order to guide the preparation and implementation of land and space planning,various technical standards were successively issued.The dual-assessment technical guidelines,land use classification standards,and the compilation guidelines for provincial,city and county planning were gradually submitted for review and trial implementation.In this context,there have been more and more planning theories and practical studies based on the background of land and space planning.For tourist service towns,how to protect the style and features of the towns under the land and space planning system and preserve the local characteristics is a problem that needs to be solved urgently[2].

Studies on Land Resource Inventory for Agricultural Land Use Planning in Northern Transition Zone of India through Remote Sensing and GIS Techniques

Land suitability analysis is a prerequisite to achieving optimum utilization of available land resources. Hence, a study on land resource inventory for agricultural land use planning was conducted in the Northern Transition Zone of India to determine land capability and develop a suitability map for wheat and sorghum-based on physical and climatic factors of production using remote sensing and GIS techniques. Detailed soil survey information was used for this exercise. Four series (Singhanhalli, Mugli, Bogur and Venkatapur series) were identified and mapped into seventeen mapping units. Land capability classification showed that a greater portion of the study area belonged to class III followed by class IV with limitations of erosion, wetness and varying soil properties. Four land capability classes viz., II, III, IV, and VI, and seven subclasses viz., IIsf, IIItsf, IVs, IVt, IVts, IVtsf and VIt were identified. Major limitations of these subclasses were slope, erosion, depth, texture, coarse fragments, pH, organic carbon and base saturation. Soil suitability assessment revealed that the soils are moderately suitable to permanently not suitable. About 234 ha (31.6%) is moderately suitable, 494 ha (65.0%) marginally suitable and 10.2 ha (1.3%) permanently not suitable for wheat;while 78.5 ha (10.3%) is moderately suitable, 633.4 ha (82.3%) marginally suitable and 32.6 ha (4.3%) permanently not suitable for sorghum respectively. The moderate, marginal and permanent non-suitability was due to moderate, severe and very severe limitations respectively. However, it is possible to achieve potential yield of the crops in the study area if these limitations are addressed.

COCKPIT-PLUS:A proposed method for rapid groundwater vulnerability-driven land use zoning in tropical cockpit karst areas

Karst groundwater is highly vulnerable to contamination,which urges better land use zoning.This paper proposes a new approach,called COCKPIT-PLUS,to minimize groundwater contamination within cockpit karst regions.The method employed four parameters:P(the existence of ponor/swallow hole),L(lineament density),U(sinking stream to an underground river),and S(distance to spring/pumping site).These parameters are essential for identifying contaminant pathways and transport from the surface to the karst groundwater/springs.COCKPIT-PLUS has been developed and validated in the Gunungsewu karst in Java,Indonesia.This research considers a cockpit as a single hydrological unit that uniquely recharges karst groundwater.We analyzed 2,811 cockpits and 81 other closed depressions to develop a land use planning map.The research used the time to first arrival(Ta),time to peak(Tp),and Q_(max/min)ratio parameters of two karst springs and two underground pumping sites for validation.Cockpits with ponors/swallow holes,sinking streams,high lineament density,and short distances to springs are vulnerable to groundwater and thus must be restricted areas for any land uses.The findings show that though the COCKPIT-PLUS uses a limited karst dataset,the proposed method seems reliable enough for a rapid land-use zoning approach in cockpit karst areas.

Study on the Current Situation of Urban Integration of Aboveground Space and Underground Space:Under the Background of China’s Land Spatial Planning

Urban underground public space has a synergistic effect with its surrounding urban aboveground functions or facilities,which reflects the complementarity between underground functions and urban functions.The research analyses the degree of integration through the case study of urban aboveground space and underground space in China.The research method of this paper will give different evaluation criteria to public transport and public space and the influencing factors of space integration.The indicators of public transport include the number of subway lines and underground parking spaces.The evaluation standard of public space is the area of underground space and the number of floors of underground space.The subway entrance and exits are selected as the evaluation index for the aboveground and underground transition space.Through the specific analysis of 7 selected cases,it provides arguments for the research.The average rent in the case is taken as the dependent variable.Through the regression model,the influencing factors of the integration of aboveground and underground space are determined.The purpose of the study is to explore the influencing factors of the integration of aboveground space and underground space,and how to optimize the integration of aboveground and underground space.