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.

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.

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.

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.

Trade-offs/Synergies in Land-use Function Changes in Central China from 2000 to 2015

To solve the problems caused by irrational land-use, studying the functions of land-use, its changing characteristics, and the relationship between each land-use function will be beneficial for achieving sustainable land development. In this research, we constructed an evaluation framework of multiple land-use functions(LUFs) based on sustainable land-use theory. Specifically,, we classified the multiple LUFs into three types: agricultural production function(APF), living function(LVF), and ecological service function(ESF).We then spatialized the economic and social data, and implemented the InVEST(Integrated Valuation of Ecosystem Services and Tradeoffs) model and RUSLE(Revised Universal Soil Loss Equation) model to evaluate each sub-LUF(crop production, aquatic production, woodlands production, livestock production, living space, life quality, water supply, soil conservation, climate regulation, biological conservation) in central China in 2000 and again in 2015. Moreover, by analyzing the changes to LUFs and the relationships between each LUF change, we were able to discern patterns of LUF change in central China. The results show that: (1)42.12% of total territory in the study area increased their APF from 2000 to 2015, while 43.41% of the lands increased their ESF yet only 8.98% of the lands increased their LVF;(2) in Hubei and Hunan, there was more land with an increase of APF than in Anhui or Jiangxi. The APF in Jiangxi exhibited the greatest decline over time period, the LVF increased more in the provincial capital cities than in other regions, and the ESF expanded more in Jiangxi than in the other provinces;and (3) the changes in APF were significantly and positively correlated with changes in LVF. Additionally, changes in ESF were negatively but non-significantly correlated with changes in APF and LVF.

Underground space planning in Helsinki

This paper gives insight into the use of underground space in Helsinki,Finland.The city has an underground master plan(UMP) for its whole municipal area,not only for certain parts of the city.Further,the decision-making history of the UMP is described step-by-step.Some examples of underground space use in other cities are also given.The focus of this paper is on the sustainability issues related to urban underground space use,including its contribution to an environmentally sustainable and aesthetically acceptable landscape,anticipated structural longevity and maintaining the opportunity for urban development by future generations.Underground planning enhances overall safety and economy efficiency.The need for underground space use in city areas has grown rapidly since the 21 st century;at the same time,the necessity to control construction work has also increased.The UMP of Helsinki reserves designated space for public and private utilities in various underground areas of bedrock over the long term.The plan also provides the framework for managing and controlling the city’s underground construction work and allows suitable locations to be allocated for underground facilities.Tampere,the third most populated city in Finland and the biggest inland city in the Nordic countries,is also a good example of a city that is taking steps to utilise underground resources.Oulu,the capital city of northern Finland,has also started to ‘go underground’.An example of the possibility to combine two cities by an 80-km subsea tunnel is also discussed.A new fixed link would generate huge potential for the capital areas of Finland and Estonia to become a real Helsinki-Tallinn twin city.

Novel algorithm of gait planning of hydraulic quadruped robot to avoid foot slidingand reduce impingement

In order to solve kinematic redundancy problems of a hydraulic quadruped walking robot,which include leg dragging,sliding,impingement against the ground,an improved gait planning algorithm for this robot is proposed in this paper.First,the foot trajectory is designated as the improved composite cycloid foot trajectory.Second,the landing angle of each leg of the robot is controlled to satisfy friction cone to improve the stability performance of the robot.Then with the controllable landing angle of quadruped robot and a geometry method,the kinematic equation is derived in this paper.Finally,agait planning method of quadruped robot is proposed,a dynamic co-simulation is done with ADAMS and MATLAB,and practical experiments are conducted.The validity of the proposed algorithm is confirmed through the co-simulation and experimentation.The results show that the robot can avoid sliding,reduce impingement,and trot stably in trot gait.

Study on the Layout of Urban Planning in Rapid Urbanization Areas under the Background of Air Pollution

China＇s urbanization has been over the medium-term process,which has made great achievements,but also triggered a huge problem of air pollution. Air pollution has become a big problem after the water pollution in China,and a serious threat to people＇s life and health. Under the background of ＂ the construction of beautiful China＂ and rapid urbanization,how to build a beautiful home has become the focus of attention. Taking Shenyang as an example,the author contrastively analyses the spatial distribution of the main air pollutants（ PM10,PM2. 5,and SO2） and the present situation of land use,and thus finds out the rules between pollutants distribution and land use. Then combining the urban planning scheme and the rules obtained above,reasonable suggestions are proposed for the scheme to improve the air quality,and reduce or avoid air pollution,and providing the basis for the construction of a piece of blue sky. The conclusions are as follows： 1 air pollutants concentration above Light Oil Gas Making Factory in south vice city of Shenyang reaches the peak value,and industrial point source is the main air pollutants emission source; 2 pollutants concentration above greenbelt is the lowest; 3 the overall spatial structure of urban planning can insulate the industrial agglomeration areas to some extent; greenbelt planning covers 40%- 50% of the area with high concentration of air pollutants,and it is suggested to achieve full coverage; traffic planning can achieve shunt most of the pollutants in many regions,but it can also expand the scope of pollutants in some certain regions,in such regions,it should reduce the road density.

THE APPLICATION OF GIS IN URBAN PLANNING:ENVIRONMENTAL ZONING STUDY IN THE OLD CITY OF WENZHOU,CHINA

Due to rapid growth of population, urbanization and industrialization, in many cites of the developing world, there is severe contradiction between urban land supply and land demand which resulted in many urban land use conflicting situations and urban environment degrading. This paper is mainly focused on this problem, demonstrating the feasibility and efficiency of environmental study by integrating GIS and environmetal zoning method. Two neighbourhoods of the old city of Wenzhou were chosen as the study area. With the aid of GIS software PC Arc/info as dBate IV, an urhan environmental impact assessment study was carried out based on the data available such as land use map and detailed attribute data of each land planning unit. The main factors taken into consideration include: the type of activity causing environmental stress, the type and strength of environmental impact and the type of receptive area that could be affected.

Soil Health and Sustainable Land Resource Management Practices at Municipal Level: A Case from Bheri Nagarpalika (Municipality), Jajorkot District, Nepal

The increasing challenges of pressure and ever-growing demands on limited resources in Nepal by diverse actors,land degradation,biodiversity loss and climate change require the rational use of land resources to sustain and enhance productivity and maintain resilient ecosystems for achieving the sustainable and efficient use of resources,taking into account biophysical and socioeconomic dimensions.Regarding this,Nepal Government has realized and taken initiation of scientific and sustainable land use zoning following the National Land Use Act 2019(2076 B.S.)to use land resources in practicable and sustainable manner.Using spatial information techniques such asZ-3 satellite image,remote sensing(RS),global positioning system(GPS)and geographic information system(GIS).Multicriteria decision making(MCDM)methods for acquiring spatial/temporal data,through expert judgment techniques based on field observation as well as laboratory analysis result,it was found that the soil nutrient status of,the municipality varied spatially and has pH with very high acidic to slightly alkaline but most of the soils are slightly acidic(39.58%).Majority of the soil are loam and sandy loam type with very low to high level of organic matter.Most of the municipal area is under medium range of organic matter.Nitrogen content ranges from very low to very high level as to same ranges of phosphorous(37.69%).Potassium level is also in very high to low as 37 percent land area has high level of potassium.Reclamation of acidic soil mainly in leachable soil is recommended with the proper management of Nitrogen with addition of organic matter is needed to manage for improving crop production.

Land Use Capability and the Sustainable Scale: An Overview of Agriculture in São Paulo State, Brazil

Establishing a sustainable scale in natural resources management enables effective economic and ecological policies and guarantees the long-term sustainability of economic production. In agriculture, land evaluations determine the land use sustainable scales, that is, those that avoid land degradation and allow the provision of food, wood, energy, and ecosystem services over time. The paper assessed São Paulo State’s agricultural sustainability by analyzing the current land use adequacy to the land use capability map that follows FAO 1976 “guide for land evaluation” and was applied to São Paulo by the State Agricultural Secretariat. Results indicate inefficiencies in land use at the state level, where more than one-third of agricultural lands do not satisfy technical land capability indications. According to technical land use capability, more than 4.5 million hectares are being underused (economic inefficiency) and another 2.2 million hectares are being overused (environmental inefficiency). Pasturelands represent the most unsustainable land use, where 3.7 million hectares are allocated in high quality lands with high agricultural production potential, and another 0.7 million hectares are allocated in lands with very low quality for agriculture, most of than area degraded. To achieve sustainability, lands with high agricultural production potential should be used to improve agriculture and food production and, on the other hand, lands with very low agricultural production potential should be used for wood production, agroforestry, ecotourism and natural ecosystems conservation. Our results provide a framework for improving land use policies in São Paulo State and highlight an opportunity to achieve land use sustainability.

The Evolution and Trend Analysis of Rural Planning Research Hotspots under the Background of Territorial and Spatial Planning

Under the background of the new round of land and space planning,the research on rural planning in China is undergoing positive changes.Based on the past emphasis on engineering thinking and planning technology,it has entered the field of planning strategy and planning guidance.The extended development trend shows a research trend of intensified integration with public management disciplines and government governance theories.The intervention of government regulation research will provide a solid theoretical guarantee for the rural revitalization strategy that focuses on planning and planning first.In order to study the rural planning hotspots and trends in the context of territorial and spatial planning,using CiteSpace software to map rural areas from the perspectives of the number of articles,authors,publishing organizations,keyword co-occurrence networks,keyword clustering analysis,hotspot evolution,prominent word analysis,etc.The knowledge map was planned and visualized comparative analysis was carried out.

Rapid Urbanization and Environment Management in Nkafu Municipality, Eastern DR Congo

Rapid and uncontrolled urbanization as well as urban land management are major constraints to land planning in the Democratic Republic of Congo. A household data collection and analysis was carried out in 283 random households in the Nkafu municipality, eastern DR Congo, to assess the local community’s perception of rapid urbanization and its impact on land policy and management of the built landscape. Data of socio-demographics characteristics, rapid urbanization, and environment management data were collected and analyzed using XLStat version 2019. In addition, the study area location map, land use and cover change maps were generated using ArcMap 10.8. Results indicate that landowners are dominant and, build simple houses with unsustainable building materials (i.e. wooden plank) obtained locally. In addition, land management is not appreciated by local communities, due to anarchic construction due to lack of financial resources generating thus an increasing amount of urban waste, which is poorly managed. The study suggests, urban roads renew, building in conformity with urban planning and building regulations, potable water supply and health services availability to improve the study area. Geographic Information Systems (GIS) use, would provide spatial information on land planning in the study area.