基于ArcSDE的南流江流域社会生态系统数据库设计及应用

发布时间：2018-01-06 10:41

本文关键词：基于ArcSDE的南流江流域社会生态系统数据库设计及应用　出处：《广西师范学院》2016年硕士论文　论文类型：学位论文

【摘要】：自然的运转与人类活动引起的环境快速变化,引发了各种环境变化的同时也导致各种灾害的频繁发生。除了自然资源面临的严峻考验,公共资源也面临的“公地悲剧”的境遇,新的理论社会生态系统制度分析与框架提出是学者们开辟的一个新路径,为流域研究提供了跟传统生态研究不一样的新视角。在学术研究上作为一个新的理论分析视角,根据框架综合考虑自然因素和人文社会因素的影响,着重强调二者之间的交互作用及其对环境变化的共同驱动,从这种分析方法出发去研究流域,帮助人们在政治、社会、经济背景下挖掘社会及生态中的微观变量进行分析,去寻找可以让自然资源长久发展的因素,不要让悲剧现在未来发展中。南流江位于广西南部,源于大容山并独自流入北部湾中,它的河流流程长、支流多且涉及流域面积比较广、水资源量比较丰富。流域的丰富资源使得人类活动频繁,经济快速发展,同时经济的发展带来的环境牺牲使得南流江流域环境污染日益严重,为了避免“公地悲剧”的发生由此引入社会生态系统可持续框架,对南流江的环境治理与经济进一步发展进行起指导作用。本文结合南流江综合管理实际,在社会生态系统框架指导下,建立南流江流域社会生态系统数据库。结合GIS技术、空间数据库技术、SQL Server等相关技术,制定可行性设计路线。主要研究内容包括:(1)理论基础:通过研究分析核心的概念——流域社会生态系统,建立数据库的数据分类体系;另一方面研究相关的数据库关键技术,包括数据库的发展、空间数据库的发展与模型、数据库引擎ArcSDE以及关系数据库系统。(2)从社会生态系统视角展开数据库的设计,包括四个阶段:需求分析、概念设计、逻辑设计、物理设计,围绕着服务对象展开数据库的需求分析,对不同的服务对象所需数据不同进行数据分析,采用E-R概念模型进行概念设计,基于概念设计进行逻辑分析与设计,在此基础上采用Geodatabase模型进行物理设计。(3)通过ArcGIS平台以及空间数据库引擎ArcSDE来实现空间数据在关系数据库SQL Server2008中的存储和管理:数据通过处理之后按照流程进行分类入库,矢量及栅格数据通过ArcCatalog实现入库,其他非空间属性数据通过SQL Server2008的导入功能进行数据的入库,数据库的建立为后续共享平台的建设提供有力的基础。(4)调用南流江流域社会生态系统数据库中的数据进行一个简单的应用研究,对流域2005年、2010年、2014年三个时间结点进行水资源脆弱性评价应用研究,得出一个相对的评价结果,除了合浦县,大部分地区脆弱性不存在明显的变化趋势,绝大部分处在中脆弱状态,综合看来南流江流域正处于中间过度的重要阶段。
[Abstract]:The operation of nature and the rapid changes in the environment caused by human activities have led to various environmental changes, but also to the frequent occurrence of various disasters, in addition to the severe test of natural resources. Public resources also face the "tragedy of the Commons" situation, the new theory of social ecosystem system analysis and framework is a new path opened up by scholars. It provides a new angle of view for watershed research, which is different from the traditional ecological research. As a new theoretical analysis perspective in academic research, according to the framework of comprehensive consideration of natural factors and the impact of human and social factors. Emphasis is placed on the interaction between the two and their common drivers of environmental change. From the perspective of this analytical method, the basin is studied to help people in politics and society. Under the economic background excavate the microcosmic variable in the society and the ecology carries on the analysis to look for the factor which can let the natural resources develop for a long time does not let the tragedy present future development. The Nanliu River is located in the south of Guangxi. Originated from Dalong Mountain and flowing into the Beibu Gulf alone, it has a long river flow, many tributaries and a wide range of watershed area, the amount of water resources is relatively rich. The abundant resources in the basin make human activities frequent and economic development fast. At the same time, the environmental sacrifice brought by the economic development makes the environmental pollution of the Nanliu River basin more and more serious. In order to avoid the "tragedy of the common land", the sustainable framework of social ecosystem is introduced in order to avoid the "tragedy of the common land". It plays a guiding role in the environmental management and economic development of Nanliu River. This paper combines the reality of integrated management of Nanliujiang River under the guidance of social ecosystem framework. To establish the database of social ecosystem in Nanliujiang river basin, combining with GIS technology, spatial database technology, SQL Server and other related technologies. Make the feasible design route. The main research content includes the theory foundation of "1"): through the research and analysis of the core concept-basin social ecosystem, the database data classification system is established; On the other hand, it studies the key technologies of database, including the development of database, the development and model of spatial database. Database engine ArcSDE and relational database system. 2) from the perspective of social ecosystem, the database design includes four stages: requirement analysis, conceptual design, logical design and physical design. The database requirement analysis is carried out around the service object, the different data needed by different service object is analyzed, and the concept design is carried out by using E-R conceptual model. Logic analysis and design based on conceptual design. On the basis of this, Geodatabase model is used for physical design. The storage and management of spatial data in relational database SQL Server2008 are realized through ArcGIS platform and spatial database engine ArcSDE. After processing, the data is classified into the database according to the process. Vector and raster data are stored through ArcCatalog, and other non-spatial attribute data are imported into the database through the input function of SQL Server2008. The establishment of the database provides a powerful foundation for the subsequent construction of the shared platform. 4) calling the data in the database of social ecosystem of the Nanliujiang River basin for a simple application study on the basin in 2005. In 2010, 2014, three time points carried out the water resources vulnerability assessment application research, obtained a relative evaluation result, except Hepu County, most areas vulnerability does not have the obvious change tendency. Most of them are in the middle fragile state, and the Nanliujiang river basin is in the important stage of intermediate transition.
【学位授予单位】：广西师范学院
【学位级别】：硕士
【学位授予年份】：2016
【分类号】：P208

【参考文献】