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.

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.

Urban Densification Strategy and Land Value in Tijuana,Baja California-The Opinion of Specialists

Specialists can provide opinions regarding the city and land value based on their specialized field.Professionals in these fields are identified as urban planners and valuators,who play a crucial role in the current dynamics of cities.They have a qualified opinion on city issues based on their professional practice in various areas of expertise.This opinion was obtained through the formulation and application of a questionnaire to specialists.Subsequently,the results were analyzed and graphically represented.In the discussion,several findings were found related to the relationship between land value and the urban densification policy established in the urban planning that governs the city of Tijuana,Baja California.The study investigated the behavior of the real estate market in the region and the establishment of a solid strategy toward densification.

Land use planning, sustainable food production and rural development: A literature analysis

In many countries agricultural land is a scarce resource, either due to natural conditions or because of competition over land. An increased need for food globally, changing environmental conditions and increased demand for environmentally sound agriculture and food systems, all require better integration of planning for rural land use and food production. A literature analysis was conducted including coding of 76 papers, to answer the question on how and to what extent, literature addresses the integration of land use policy and planning, and food system planning, in the context of sustainable rural development and agri-food production. The results indicate that land use and food system planning co-occur in literature, yet lacking the perspective of sustainable rural development, suggesting that integrated planning for sustainable rural land use and food systems needs to be strengthened. Food system research has largely focused on availability and access, or what can be associated with consumers, rather than rural land use. Likewise, the inclusion of food systems is neither common in rural land use planning nor in agricultural policies. Holistic planning for a sustainable food system may be suffering from a disjointed approach, e.g., planning for farmland may not have any links to planning for accessibility, consumer preferences or food marketing. Increased cooperation between stakeholders is necessary to break down the silos in the food system. Policies and plans for rural land use and agri-food production should be coordinated for the common goal of sustainability.

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.

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.

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.

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.

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.

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.

Ecological planning for land use and ruraldevelopment of Taojiang County

ＥｃｏｌｏｇｉｃａｌｐｌａｎｎｉｎｇｆｏｒｌａｎｄｕｓｅａｎｄｒｕｒａｌｄｅｖｅｌｏｐｍｅｎｔｏｆＴａｏｊｉａｎｇＣｏｕｎｔｙＯｕｙａｎｇＺｈｉｙｕｎ；ＷａｎｇＲｕｓｏｎｇ；ＪａｓｏｎＷｅｉｓｍａｎ（ＲｅｓｅａｒｃｈＣｅｎｔｅｒｆｏｒＥｃｏ－Ｅｎｖｉ...

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.

An iterative approach to an integrated land use and transportation planning tool for small urban areas

There has been increasing interests in developing land use models for small urban areas for various planning applications such as air quality conformity analysis. The output of a land use model can serve as a major input to a transportation model; conversely, transportation model output can provide a critical input to a land use model. The connection between the two models can be achieved by an accessibility measure. This paper presents an iterative approach to solving a regression-based land use model and a transportation model with combined trip distribution- assignment. A case study using data from a small urban area is presented to illustrate the application of the proposed modeling framework. Tests show that the procedures can converge, and the modeling framework can be a valuable tool for planners and decision-makers in evaluating land use policies and transportation investment strategies.

The Application of Scenario Analysis in the Overall Planning of Land Use:A Case Study of Shangluo City in Shaanxi Province

The overall planning of land use is a complex process of joint action of social system, natural and economic conditions. On the basis of summarizing the existing researches, we select Shaanxi's Shangluo City, located in the Qinba mountainous area as the study object, to expound the concept and steps of scenario analysis based on land use change data, under the guidance of ecological safety and sustainable development theory. We design four different scenarios of land use planning program in Shangluo City during the period 2006-2020, and use grey linear programming model to analyze each scenario. The results show that the scenario analysis is feasible in the adjustment of land use structure in Shangluo City; operable in the determining of land use planning program on a macro-municipal scale.

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.

Testing of Decision Making Tools for Village Land Use Planning and Natural Resources Management in Kilimanjaro Region

This paper focuses on participatory testing of decision making tools (DMTs) at village level to assist in development of land use plans (LUPs) for sustainable land management (SLM) in Kilimanjaro Region, Tanzania. Data were collected using conditional surveys through key informant interviews with the project’s district stakeholders in each district, focused group discussions with selected villagers and participatory mapping of natural resources. Soil health, land degradation, carbon stock, and hydrological conditions were assessed in the seven pilot villages in all seven districts using DMTs as part of testing and validation. Results indicated soils of poor to medium health, and land degradation as portrayed by gullies and wind erosion in lowlands and better in uplands. Carbon and forest disturbance status could not be assessed using one-year data but hydrological analysis revealed that water resources were relatively good in uplands and poor in the lowlands. Challenges with regard to land use include increased gully erosion, decreased stream flow, reduced vegetation cover due to shifting from coffee with tree sheds to annual crops farming, cultivation near water sources, and overgrazing. Empowering the community with decision making tools at village level is essential to ensure that village land uses are planned in a participatory manner for sustainable land and natural resources management in Kilimanjaro and other regions in Tanzania.

A Study on the Theory and Approach of Environmental Impact Assessment in General Land Use Planning

In this paper,the theory and approach of environmental impact assessment in general land use planning are studied from different aspects.First,starting from the content and concept of general land use planning,the necessity of environmental impact assessment in general land use planning is illustrated.On the basis of its evaluation theories and methodologies,it attempts to establish index system of environmental impact assessment in general land use planning,and point outs that current general land use planning requires public participation.

Study on Population Forecast Model in Planning of Land Use

On the basis of describing characteristics and condition of application of natural growth model of population,weighted average growth model,regression forecast model and GM(1,1) forecast model,taking Gushi County in Henan Province as an example,according to the statistics of population in Gushi County Statistical Yearbook from 1991 to 2007,we establish four models to conduct fitting on population change respectively,and meanwhile,we predict population size from 2008 to 2009 and conduct preciseness test on the population size.The test results show that the preciseness of forecast results of natural growth model is not high,and the preciseness of forecast results of weighted average growth model is not scientific when the total size of population is unstable.The results of GM(1,1) forecast model and regression forecast model largely conform to the actual data,so we can take the mean of the two as the final forecast result.