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...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.展开更多
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...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.展开更多
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...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.展开更多
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 h...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.展开更多
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 ...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.展开更多
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 th...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.展开更多
Urban underlying surface has been greatly changed with rapid urbanization, considered to be one of the major causes for the destruction of urban natural hydrological processes. This has imposed a huge challenge for st...Urban underlying surface has been greatly changed with rapid urbanization, considered to be one of the major causes for the destruction of urban natural hydrological processes. This has imposed a huge challenge for stormwater management in cities. There has been a shift from gray water management to green stormwater management thinking. The green stormwater infrastructure （GSI） is regarded as an effective and cost-efficient stormwater management eco-landscape approach. China＇s GSI practice and the development of its theoretical framework are still in the initial stage. This paper presents an innovative framework for stormwater management, integrating green stormwater infrastructure and landscape security patterns on a regional scale based on an urban master plan. The core concept of green stormwater infrastructure eco-planning is to form an interconnected GSI network （i.e., stormwater management landscape security pattern） which consists of the location, portion, size, layout, and structure of GSI so as to efficiently safeguard natural hydrological processes. Shanghai Lin- gang New City, a satellite new town of Shanghai, China was selected as a case study for GSI studies. Simulation analyses of hydrological processes were carried out to identify the critical significant landscape nodes in the high- priority watersheds for stormwater management. GSI should be planned and implemented in these identified landscape nodes. The comprehensive stormwater manage- ment landscape security pattern of Shanghai Lingang New City is designed with consideration of flood control, stormwater control, runoff reduction, water quality protec- tion, and rainwater utilization objectives which couldprovide guidelines for smart growth and sustainable development of this city.展开更多
基金funded by Start-Up Funds for Scientific Research of Shenzhen University,Grant No.000002112313.
文摘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.
文摘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.
基金supported by the National Key Research and Development Program of China(Grant No.2016YFE0122500)the Researcher Links Fund,British Council(Grant No.227109770)+1 种基金the National Natural Science Foundation of China(Grants No.5151101425 and 51579166)the Open Research Fund from the State Key Laboratory of Hydraulics and Mountain River Engineering,Sichuan University(Grants No.SKHL1601 and SKHL1602)
文摘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.
文摘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.
文摘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.
文摘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.
文摘Urban underlying surface has been greatly changed with rapid urbanization, considered to be one of the major causes for the destruction of urban natural hydrological processes. This has imposed a huge challenge for stormwater management in cities. There has been a shift from gray water management to green stormwater management thinking. The green stormwater infrastructure （GSI） is regarded as an effective and cost-efficient stormwater management eco-landscape approach. China＇s GSI practice and the development of its theoretical framework are still in the initial stage. This paper presents an innovative framework for stormwater management, integrating green stormwater infrastructure and landscape security patterns on a regional scale based on an urban master plan. The core concept of green stormwater infrastructure eco-planning is to form an interconnected GSI network （i.e., stormwater management landscape security pattern） which consists of the location, portion, size, layout, and structure of GSI so as to efficiently safeguard natural hydrological processes. Shanghai Lin- gang New City, a satellite new town of Shanghai, China was selected as a case study for GSI studies. Simulation analyses of hydrological processes were carried out to identify the critical significant landscape nodes in the high- priority watersheds for stormwater management. GSI should be planned and implemented in these identified landscape nodes. The comprehensive stormwater manage- ment landscape security pattern of Shanghai Lingang New City is designed with consideration of flood control, stormwater control, runoff reduction, water quality protec- tion, and rainwater utilization objectives which couldprovide guidelines for smart growth and sustainable development of this city.
