斜坡地质灾害气象预报预警空间数据库的设计与建立(谈树成-金艳珠-虎雄岗等-《地球学报》2012.5)

20129Sep.2012335:812-818ActaGeoscienticaSinicaVol.33No.5:812-818(:XT412003)(:Z2008-1-65001)(:U0933603)(:41262004):2012-07-22;:2012-08-10::,,1970,:650091,2:0871-5033736E-mail:[e-mail],,,,,650091摘要:,,ArcSDEGeodatabaseSQLServer;,,关键词:;;;;ArcSDEGeodatabase;SQLServer中图分类号:P694;P628.4文献标志码:Adoi:10.3975/cagsb.2012.05.13TheDesignandEstablishmentofMeteorologicalForecastingandWarningSpatialDatabaseofSlopeGeologicalHazardsTANShu-cheng,JINYan-zhu,HUXiong-gang,JIANGShun-de,FENGLongGeologicalInstituteofYunnanUniversity,Kunming,Yunnan650091Abstract:Frequentslopegeologicalhazardsoftenbringgreateconomiclosses,andespeciallythehazardscausedbyrainfallarebecomingmoreandmoreserious.Inviewofthefactthattraditionaldatabasefailstomanagethespatialdataeffectively,theauthorsholdthattheadoptionoftheArcSDEGeodatabaseandSQLServerspacedatabasetechnologyisinfavorofmanagingthemeteorologicalforecastingandwarningspatialdataofslopegeologicalhazardsefficiently,scientificallyandinaunifiedway.Thispaperdescribesthedesignandestablishmentofmeteorologicalforecastingandwarningspatialdatabaseofslopegeologicalhazardsinthreeaspects,i.e.,thedatapreparation,thespatialdatabasedesignandthedatabaseestablishment.WithNujiangprefectureinYunnanProvinceasanexample,theauthorsverifiedthedatabase,andtheresultfullydemonstratesthatthedatabasehascertainfeasibility.Theresearchresultscanprovidescientificbasisformeteorologicalforecastingandwarningandpreventionoftheslopegeologicalhazards.Keywords:slopegeologicalhazards;meteorologicalforecastingandwarning;databasedesignandestablishment;ArcSDEGeodatabase;SQLServer,(,2010;,2007;,2006;,2003),,CAGS:813,,,,ArcSDEGeodatabase,,,,ArcSDEGeodatabase,,,,,1数据准备1.1,,,12419612010,,,,,,:;,,,,,,,(,2003),,1.2,,,(,2005;,2007)()(,2010),1,;(),,++533325010029,533325,01,00291.3ArcSDEGeodatabaseSQLServer,,DEM,,,,,,;,,(,2005;Guzzettietal.,2004;,2003),,图1编码结构Fig.1CodingstructureCAGS814ArcGIS,,2空间数据库的设计3:2()2.1(,2010),,——,E-R,,E-R32.2E-RSQLServer图2斜坡地质灾害气象预报预警空间数据库设计流程图Fig.2Thedesignofmeteorologicalforecastingandwarningspatialdatabaseforslopegeologicalhazards图3E-R模型图Fig.3E-Rmodel2.2.1GeoDatabase,,:(1):,;(2):;(3):2.2.2(,2003;,2004),SQLServer,3,(1):;(2):;(3):,,;,2.3CAGS:815,(,2011;,2011),(1):GIS,,(1)(2):;,,(2)表1斜坡地质灾害图形数据图层表Table1Layertableofslopegeologicalhazardsgraphicsdata表2斜坡地质灾害属性表Table2Attributestableofslopegeologicalhazards,:C20;,,:H1;,:1C10:C10()C50,,:35410319,3060108N15C100/,,:;,,:N80/,,;,,:C100C100,C50,C100CAGS8163斜坡地质灾害气象预报预警空间数据库的建立SQLServerGeodatabaseArcSDE3.1MapGIS,MapGISArcGISShape,ArcGISArcCatalogShapeGeodatabase,;,GIS,GIS,3.2SQLServer,,,,,1(Link)ArcCatalog,ArcMap,,ArcGISArcGIS(,2011),3.3ArcSDEGeodatabaseSQLServer,,OLEDBADO,(4)4应用实例(),-,GIS,图4空间数据库的建立Fig.4TheestablishmentofspatialdatabaseCAGS:817(5),5,;;,,:3();4();5(),,5:,;(),;,2010818,,1315,,,图5斜坡地质灾害气象预报预警图Fig.5Meteorologicalforecastingandwarningdiagramofslopegeologicalhazards,5结论与讨论,ArcSDEGeodatabaseSQLServer,;,,,;,,:,;;,参考文献:,,.2003.WebGIS[J].,(2):20-24.,.2003.[J].,24(5):483-486..2007.[D].:.,,,.2007.[J].,18(1):115-119.,,,,.2011.GIS[J].,34(3):157-161.,.2006.[J].,15(10):47-50.,,.2004.[J].,25(3):379-384.,,,.2010.[J].,31(1):109-116.,.2005.WebGISCAGS818[J].,16(3):114-117..2003.[J].(),9(3):79-81.,,,.2010.Geodatabase[J].,10(34):8503-8506.,.2011.[J].,(6):9-12..2005.[J].,19(3):231-234.References:CHENZhi-hua,GUANXue-feng,HU-cheng.2003.DevelopmentofDBMSforenvironmentalgeologichazardsonWebGIS[J].HydrogeologyandEngineeringGeology,(2):20-24(inChinesewithEnglishabstract).GUOJian-qiang,ZHUQing-jun.2003.NewGeophysicalTech-niquesforExplorationofGeologicalHazards[J].ActaGeo-scienticaSinica,24(5):483-486(inChinesewithEnglishab-stract).GUZZETTIF,REICHENBACHP,GHIGIS.2004.RockfallhazardandriskassessmentalongatransportationcorridorintheNeraValley,centralItaly[J].EnvironmentalManagement,34(2):191-208.KONGZhi-gang.2007.PotentialSlopeGeologicalHazardRe-search[D].Kunming:KunmingUniversityofScienceandTechnology(inChinese).LIYue-chen,ZHAOChun-yong,LIUChun-xia,YANGHua.2007.DesignandConstructionofGeologicalHazardDatabaseinChongqingCity[J].TheChineseJournalofGeologicalHazardandControl,18(1):115-119(inChinesewithEnglishabstract).PENGYing-xia,HEZhen-ming,ZHANLiao-fang,LIAOYe-xiang,LIRuo-yao.2011.DesignandImplementationofProvincialGeologicalHazardDatabaseBasedonGIS[J].GeomaticsandSpatialInformationTechnology,34(3):157-161(inChinesewithEnglishabstract).WANGZhe,YIFa-cheng.2006.GeologicalHazardsRegionaliza-tionandResearchStatusQuoinCHINA[J].ChinaMiningMagazine,15(10):47-50(inChinesewithEnglishabstract).YANJia-yong,LÜQing-tian,ZHAOJin-hua.2004.TheDesignandDevelopmentoftheEarlyWarningSystemforSoilPollu-tioninBeijing[J].ActaGeoscienticaSinica,25(3):379-384(inChinesewithEnglishabstract).YAOYu-zeng,LIRen-feng,WENShou-qin,ZHAOYu-shan.2010.ProbabilityAssessmentofMountainousHazardsinLingyuanCity,LiaoningProvince[J].ActaGeoscienticaSinica,31(1):109-116(inChinesewithEnglishabstract).ZHANGGui-rong,YINKun-long.2005.WebDatabaseConstructionofGeo-hazardInformationSysteminZhejiangProvinceBasedonW