| 数据处理方法在雨量中的应用及面雨量形成 |
| |
| 引用本文： | 周后福,吴文玉,江双五,李涛,翟菁,王海.数据处理方法在雨量中的应用及面雨量形成[J].南京气象学院学报,2014,6(5):443-448. |
| |
| 作者姓名： | 周后福 吴文玉 江双五 李涛 翟菁 王海 |
| |
| 作者单位： | 安徽省气象科学研究所, 合肥, 230031;南京信息工程大学 大气科学学院, 南京, 210044;安徽省大气科学与卫星遥感重点实验室, 合肥, 230031;安徽省气象科学研究所, 合肥, 230031;安徽省大气科学与卫星遥感重点实验室, 合肥, 230031;安徽省气象信息中心, 合肥, 230031;南京信息工程大学 电子与信息工程学院, 南京, 210044;安徽省气象科学研究所, 合肥, 230031;安徽省大气科学与卫星遥感重点实验室, 合肥, 230031;安徽省气象信息中心, 合肥, 230031 |
| |
| 基金项目： | 国家自然科学基金(41140036);淮河流域气象开放基金(HRM200907) |
| |
| 摘 要： | 基于中尺度雨量站资料,将SQL Select语句、bcp数据处理方法应用到实时雨量的计算中,利用GIS技术得到精细的子流域的栅格点雨量,形成子流域的面雨量值.结果表明:1)采用SQL Server的数据查询技术与bcp数据处理技术可以获取每天实时雨量;2)利用GIS的拼接、转换和抽样处理技术,可以形成5km空间分辨率的坡度和高程数据;3)根据雨量与高度和坡度的关系得到雨量的计算公式,获得精细化的雨量资料,通过算术平均法的求算形成更准确的面雨量值.
|
| 关 键 词： | SQL Server bcp命令 数据处理 GIS技术 面雨量 拼接转换和抽样 |
| 收稿时间： | 2013/1/11 0:00:00 |
Application of data processing method in precipitation and area rainfall formation |
| |
| ZHOU Houfu,WU Wenyu,JIANG Shuangwu,LI Tao,ZHAI Jing and WANG Haibo.Application of data processing method in precipitation and area rainfall formation[J].Journal of Nanjing Institute of Meteorology,2014,6(5):443-448. |
| |
| Authors: | ZHOU Houfu WU Wenyu JIANG Shuangwu LI Tao ZHAI Jing and WANG Haibo |
| |
| Institution: | Anhui Institute of Meteorological Sciences, Hefei 230031;School of Atmospheric Science, Nanjing University of Information Science & Technology, Nanjing 210044;Anhui Key Lab of Atmospheric Science and Satellite Remote Sensing, Hefei 230031;Anhui Institute of Meteorological Sciences, Hefei 230031;Anhui Key Lab of Atmospheric Science and Satellite Remote Sensing, Hefei 230031;Anhui Meteorological Information Center, Hefei 230031;School of Electronic & Information Engineering, Nanjing University of Information Science & Technology, Nanjing 210044;Anhui Institute of Meteorological Sciences, Hefei 230031;Anhui Key Lab of Atmospheric Science and Satellite Remote Sensing, Hefei 230031;Anhui Meteorological Information Center, Hefei 230031 |
| |
| Abstract: | Using select statement of SQL Server and bcp data processing method,the real-time precipitation is calculated based on meso-scale precipitation data.Grid point precipitation of subbasins was obtained by GIS technology,hence the area precipitation of subbasins was formed.The computation results show that,daily real-time precipitation can be acquired through employment of SQL Server data inquiring technology and bcp data processing technology,and the slope and elevation data with spatial resolution of 5km can be obtained by GIS splicing,conversion and sampling process.Then the area rainfall computation equation is established with real-time precipitation and related slope and elevation,and the area rainfall is further accurate through calculation with Arithmetic Mean Method (AMM). |
| |
| Keywords: | SQL Server bcp command data processing geography information system area precipitation splicing and conversion and sampling |
|
| 点击此处可从《南京气象学院学报》浏览原始摘要信息 |
| 点击此处可从《南京气象学院学报》下载免费的PDF全文 |
|
