EXCEL VBA与SELECT-SQL在水准网数据处理质检中的应用  

Application of VBA and SELECT-SQL in levelling network data processing and quality inspection

作　　者：刘璐 丁黎 谢方 LIU Lu;DING Li;XIE Fang(Geodetic Data Processing Centre of the Ministry of Natural Resources,Xi′an,Shaanxi 710054,China)

机构地区：[1]自然资源部大地测量数据处理中心,陕西西安710054

出　　处：《测绘技术装备》2023年第1期101-105,共5页Geomatics Technology and Equipment

摘　　要：在区域高程控制测量与工程测量中,水准测量工作必不可少,因此,实现水准测量观测成果的自动化、高质量质检十分重要。目前,水准观测成果有标准格式数据,便于数据处理的输入,但有些仅有电子观测手簿,格式较为复杂。本文在对水准测量观测成果要素进行分析的同时,基于EXCEL VBA对电子观测手簿中的起点点名、终点点名、观测开始时间、观测结束时间、概略坐标、后尺号、前尺号、首测往测高差值、首测往测距离、测站数等关键要素实现了快速批量提取,并利用SELECT-SQL语句的查询功能,逐一对要素进行快速比对,检测出提取数据与原始观测数据之间的差异,大大提高了水准网数据处理质检工作的效率。Levelling is indispensable in regional vertical control survey and engineering survey,so it is very important to automate levelling results and provide a high quality inspection.At present,the standardized format of the levelling result is convenient for the input of the data processing.However,there are still some results are kept in the electronic observation manual books and featured with complicated formats.In this paper,by analyzing the key elements of levelling results,key elements in the observation manual books such as starting point roll call,end point roll call,starting observation time,ending observation time,outline coordinates,back ruler size,front ruler size,height difference between the first observation and direct observation,distance between the first observation and direct observation,number of the observation stations are quickly extracted in bulk based on EXCEL VBA.Then,with query function of SELECT-SQL statement,the difference between the key elements is detected quickly,which greatly improves the efficiency of data processing quality inspection in the levelling network.

关 键 词：VBA SELECT-SQL语句 数据查询 水准网数据处理 

分 类 号：P228[天文地球—大地测量学与测量工程]