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.

Experience of the UK in Urban and Rural Planning System and Rural Planning Management and Recommendations for China

Based on the field survey,training and related literature review of urban and rural planning system and rural planning management and protection in the UK,this paper summarized the development history,basic experience and main characteristics of the UK's urban and rural planning system and rural planning management.It is intended to analyze its reference significance to China's current efforts to strengthen agricultural and rural planning management,promote urban and rural development,and promote the construction of new urbanization.It was found that the establishment of the UK's urban and rural planning system can be contributed to the problem of "urban diseases" arising from the process of urbanization development.Its development has undergone many revisions and adjustments,and has now formed a two-level planning structure,namely "regional spatial strategies" and "local development framework";the UK's urban and rural planning system stresses the planning management and protection of rural areas and small towns,and has formed a series of important rules and systems.In the process of urbanization development,the UK has completely preserved the historical buildings,local culture and landscape environment of traditional villages,which is worthy of our learning.With reference to the experience of the UK,in the process of coordinating urban and rural development and promoting new urbanization construction,it is recommended to give full play to the guiding role of planning and the participation of the public,attach great importance to the protection and planning management of agriculture and rural areas,and also emphasize the re-innovation based on China's national conditions.

Balance Between Jobs and Housing from Perspectives of Real Estate Development and Management and Urban Planning

Jobs-housing balance is the balance between employment and housing. Its philosophy has a long history and development process in urban planning. The concept of jobs-housing balance generally refers to that the number of employed people is roughly equal to the number of occupants within a certain range. This kind of balance is conducive to reducing the commuting time and the change of transportation mode on the way that the employed people spend at work. The realization of jobs-housing balance not only helps to optimize the structure between residence and employment in the region but also is conducive to improving the work enthusiasm and work efficiency of the employed in the region and reducing the commuting costs of workers in the region. In addition, the relegalization of jobs-housing balance also has a certain impact and effect on alleviating the traffic congestion and improving the environment of the region. In summary, the realization of jobs-housing balance has a multi-faceted impact on the development of a city, and promoting the balance between occupation and housing is conducive to promoting the development of the city. The realization of jobshousing balance involves many areas. In this article, In this article, the development history of jobshousing balance is sorted out from perspectives of real estate development and management and urban planning, and its development enlightenment is discussed.

Planning,Protection and Construction of Ancient Villages in Jiangxi under the Background of New Urbanization: Taking the Water Management System of Mingkou Village in Leping City,Jiangxi Province as an Example

Urbanization is an inevitable trend of economic development. It is an important indicator that reflects the industrialization and modernization of a country. In the long-term urbanization process in China, due to the excessive emphasis on the status of the city and one-sided emphasis on urban development, a serious of urban diseases such as population congestion and environmental damage have been caused. Meanwhile, neglected rural areas have exposed social problems such as aging and hollowing out, making the urban-rural dual structure more prominent. Currently, China s economic and social development has reached a new stage, and the realization of urban-rural integration is a major measure to comprehensively develop the national economy and social undertakings. Vigorously developing the rural areas and revitalizing the countryside has become a national policy. Traditional ancient villages are treasures in the vast rural areas. They should be more protected and developed to eliminate the urban-rural gap, thereby passing down and carrying forward the essence of traditional culture and enhancing China s national confidence and cultural confidence. Focusing on the protection and planning of ancient villages, combined with the current policy background of new urbanization, based on field research on Mingkou Village, Leping City, Jiangxi Province, protective development strategies are put forward for ancient villages and their water management from the perspective of water management in ancient villages to arouse people s attention to the protection of ancient villages.

Research on the Mode Transformation and Innovation of Urban Planning Management

As an important part of today's social development,cities are also an important guarantee for the improvement of people's living standards.As an important model of urban spatial layout,urban planning and management plays an important role in the development of urban economy,politics and culture.Based on this,this paper takes"urban planning and management"as the research theme,analyzes the existing planning model,and starts from the aspects of content and form,improves the pertinence and directivity of the existing planning system,so as to provide valuable reference for experts in the field.

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.

Urban and river flooding:Comparison of flood risk management approaches in the UK and China and an assessment of future knowledge needs

Increased urbanisation,economic growth,and long-term climate variability have made both the UK and China more susceptible to urban and river flooding,putting people and property at increased risk.This paper presents a review of the current flooding challenges that are affecting the UK and China and the actions that each country is undertaking to tackle these problems.Particular emphases in this paper are laid on(1)learning from previous flooding events in the UK and China,and(2)which management methodologies are commonly used to reduce flood risk.The paper concludes with a strategic research plan suggested by the authors,together with proposed ways to overcome identified knowledge gaps in flood management.Recommendations briefly comprise the engagement of all stakeholders to ensure a proactive approach to land use planning,early warning systems,and water-sensitive urban design or redesign through more effective policy,multi-level flood models,and data driven models of water quantity and quality.

The Cultural Ecology Protection and Management of Urban Forests in China

Forests have economic,ecological,social and cultural functions.Forests Cultural ecology,the counterpart of forest ecology,is the integration of human spirit formed on the basis of natural forest and living systems.In recent years,China's urbanization rate has increased from 28%in 1993 to 45.68%in 2008,and ecological protection of urban forest has made great progress,but insufficient attention was paid to the forest cultural ecology protection and the relevant regulatory was not well performed.In order to strengthen the protection of forest cultural ecology and the management,the study showed that the social economic development of China has become mature and entered the consumption phase,besides,cultural ecology protection of forest will be the essence of urban forestry development in the future,so more and more attention will be paid to the protection of urban forest cultural ecology,especially with the enhancement of urbanization in China.The study suggests that protection of urban forest cultural ecology should be included into the forest legislation and management.The development planning of urban forest development should be strengthened to highlight the organic combination of material wealth production and spiritual wealth production,and finally promote protection of urban forest culture and the development of green culture.

Planning of Waste Management Systems in Urban Area Using Multi-Criteria Analysis

Planning of waste management system in urban area should take into consideration many legal, technological, financial, economic, technical, ecological, social and spatial aspects. The aim of the paper is to propose the method, which can be helpful in planning procedure of waste management system in European cities or regions, which comprise with following steps: identification of produced volume and municipal solid waste characteristics in the region for providing grounds to design a technological system, identification of other financial, economic, legal, social aspects for creation of waste management scenarios, definition of the criteria allowing evaluate designed waste management scenarios based on plan requirements, make an the multi-criteria analysis for choosing the best scenario in the region. Such analyses were conducted to evaluate the proposed different waste management systems in city of Cracow in 2000, 2004 and 2007. This comparison of theses systems shows that evaluating criteria were tightened as a result of toughening regulations of both Polish and the EU laws.

Urbanization, environmental consequences and management in China

Ｕｒｂａｎｉｚａｔｉｏｎ，ｅｎｖｉｒｏｎｍｅｎｔａｌｃｏｎｓｅｑｕｅｎｃｅｓａｎｄｍａｎａｇｅｍｅｎｔｉｎＣｈｉｎａＬｕＹｏｎｇｌｏｎｇ（ＲｅｓｅａｒｃｈＣｅｎｔｅｒｆｏｒＥｃｏ－ＥｎｖｉｒｏｎｍｅｎｔａｌＳｃｉｅｎｃｅｓ），ＣｈｉｎｅｓｅＡｃａｄｅ...

A Preliminary Study on the Inducements of Urban Public Landscape Fragmentation and Its Countermeasures

This study focused on the urban public landscape fragmentation in the process of rapid urbanization in China. By sorting out the management and control indicators and methods of urban planning management departments for residential land and comparing the actual practices and internal design principles of the mainstream developers in land development and construction based on this method, it is believed that the phenomenon of landscape space fragmentation from the city itself in the residential quarter in the city is caused by the mismatch between the design strategy of the developer and the overall demand of the urban space. Lack of government departments’ planning for the integration of urban public resources is the inducement. In view of these problems, several solutions were put forward.

Urban Growth Management through Travel Demand Modeling in Washington and Oregon

Among the fast growing states in the USA,the States of Washington and Oregon have enacted legislative land use and transportation concurrency/balancing planning policies for orderly urban growth management since 1990 and 1991,respectively.Regional or urban travel demand forecasting models play an instrumental role in implementing the Washington GMA(Growth Management Act)and the Oregon TPR(Transportation Planning Rule).Both program-and project-level modeling approaches to urban land use/transportation system management are evaluated through the selected cities in Washington and Oregon.

Land-Use Planning Guidelines for Optimal Coastal Environmental Management

The objective of this study is to weigh and recommend environmentally-optimal regional land-use planning guidelines for coastal regions. The present malaise is assessed, as regards inefficiencies, non-suitability, non-sustainability, enhancing factors of environmental degradation, and potentially destructive consequences of current land-use alteration. Desired situations and goals are considered, and means are proposed for bridging the gap between the present malaise and a desired situation, based on five key approaches developed by the authors. Specific examples of regional approaches are presented. Guidelines and operational measures for sound regional planning the authors have employed in similar circumstances are recommended.

On the Practices of Regulatory Urban Design

On the basis of reviewing urban design and management practices of Honggutan New District in Nanchang City, Jiangxi Province, regulatory urban design was proposed and its major feature was summarized as "the local government or urban management agency responsible for the organization and compiling". After defining regulatory urban design, its compiling and technical means were studied.

The Impact of Life Sciences Developments on the UK Urban Environment

Life sciences urban developments are a relatively recent phenomenon, and follow the emergence of knowledge based urban developments as a potential driver of urban regeneration and local economic growth. The role of these new centres in transforming the inner cities of some of the UK＇s larger conurbations is examined and the key planning issues are discussed. The article concludes that the key principles of urban planning and control must still apply in shaping the role these new developments have in the UK＇s evolving urban landscape.

Examining the Level of Service in the Context of Recreational Carrying Capacity in the Erzurum Urban Forest,Turkey

Urban forests are confronted with high using pressure because of the increasing demand for recreation and accessibility of these settings. For that purpose, defining and managing recreational carrying capacity is considered as significant in ensuring ecological value’s and recreational satisfaction’s continuity. The purpose of this paper is to investigate the carrying capacity of Erzurum Urban Forest with respect to Level of Service (LOS) as a new management technique that focuses on service quality and visitor satisfaction. The data were obtained by self-administered questionnaire conducted with 166 visitors on weekends and holidays during summer season of the year 2014. Data were analyzed by dimensions/indicators of recreational satisfaction and socio-demographic characteristics with intent to identify tolerance range of visitors. The contribution and relative importance of each of the indicators to the overall satisfaction were analyzed by using Ordinal Logistic Model (OLM). The results indicated that the four indicators were at the greatest degree;“distance from picnic spot to toilets” and “quantity of children’s playground facilities” were decease of overall satisfaction while “distance from picnic spot to parking” and “level of shade at picnic spot” had a positive contribution to the overall satisfaction. The outputs from these analyses were used to calculate LOS. It was revealed that the level of service (0.40) in Erzurum Urban Forest was below the moderate level. Planning and managing strategies for optimizing the LOS were developed and discussed by considering these results.

面向流域治理与城镇发展统筹的城市水系统规划协同机制探讨 ——广东东莞生态园实证研究

统筹流域治理与城镇发展是系统解决当前城市发展过程中遇到的水资源短缺、水生态破坏、洪涝灾害频发的关键路径。本文在辨析流域治理与城镇发展统筹面临的主要问题及其辩证关系的基础上,以东莞市中部地区的生态园及其所在的寒溪河流域为研究对象,系统探讨了城市水系统规划在流域治理与城镇发展统筹中的协同作用机制。结果表明,以城镇-流域水系统耦合模型为支撑,城市水系统规划及其协同机制可通过空间、设施等要素的协同,实现保障城市及流域防洪排涝安全、保护水环境和节约水资源的目标,促进流域安全与城镇发展的良性互动。

作为城市基础设施的新能源汽车充电桩——服务新特性与规划新思维

研究聚焦作为新兴城市基础设施的新能源汽车充电桩,结合对长三角领先城市发展状况的实地考察,提炼其较之传统设施体系的异同点,进一步从理论视角出发剖析其内涵特性,并探讨适配的规划干预新思维。研究认为新能源汽车充电桩是一项以充电和停车为核心功能的从旧体系中生长出的新设施,因较之传统基础设施有更久的历时体验和更多的技术赋能,从而能支持各类新型使用场景。基于交通与能源两方面时空需求的叠合,充电桩的布局和使用涉及多主体多部门的差异化诉求,协同治理面临挑战。城市规划作为统筹公共资源空间分配的政策平台,理应将充电桩纳入公用设施体系的考量之中,在“投融建管营”一体化新思维下探索新的规划模式。这一模式既要与既有设施体系充分兼容,保持基础设施的稳定特性,又要能充分拥抱市场,通过技术迭代不断提升用户体验。

人民城市理念下高品质营城规划与实施路径——以沈抚改革创新示范区为例

高品质营城是践行人民城市理念、满足人民美好生活向往的必然要求,是推动城市高质量发展、提升城市竞争力的重要手段。总结新中国成立以来我国城市品质提升实践经验和启示,提出新时期高品质营城的价值导向应在城市价值、服务、支撑、治理等4个方面进行升维,在实施层面形成一套“融合评估—顶层设计—场景营造—行动计划”的技术方法,并以沈抚改革创新示范区为例,探索高品质营城规划实践,为高品质城市建设提供可复制、可推广的经验。

The Modern Management of Urban Planning and the Controlling Planning

Since 1980s,with the further reform of political and economic systems,the urban construc-tion in our country has undergone great changes,greater than ever.Such changes pose a series ofnew problems to urban planning:How should planning be suitable for the development of moderncities?How should planning management coordinate with urban planning?How to carry out ur-ban planning under new situations? etc.The answers to these problems lie in one point:urbanplanning and plann ing management must be restructured.Only when the former is well com-bined with the latter can the above problems be solved satisfactorily.This article provides someviews in this respect.