基于ACCESS VBA的坐标转换程序设计
|
摘要
随着空间定位技术的普及,不同空间直角坐标系间的转换过程中经常遇到问题不易被解决。本文首先介绍了不同空间直角坐标系间转换时广泛使用的布尔沙转换模型并阐述了七参数求解的过程,然后结合ACCESS中的表、窗体和宏,利用VBA实现了基于布尔沙转换模型的七参数计算程序,并结合实例对所编写的程序加以验证,保证其结果的可靠性。
With the popularity of the spatial positioning technology,the conversion between different spatial rectangular coordinate systems is often encountered and problems are difficult to be solved. This paper firstly introduces Bursa seven- parameter conversion model which is widely used in the conversion between the different spatial rectangular coordinate system and describes the seven- parameter for solving process,and then combine the tables,forms,and macros in the Access,Meanwhile,achieve the seven- parameter calculation program based on Bursa conversion model through VBA and associate some illustrations to verify written procedures in order to ensure the reliability of the results finally.
With the popularity of the spatial positioning technology,the conversion between different spatial rectangular coordinate systems is often encountered and problems are difficult to be solved. This paper firstly introduces Bursa seven- parameter conversion model which is widely used in the conversion between the different spatial rectangular coordinate system and describes the seven- parameter for solving process,and then combine the tables,forms,and macros in the Access,Meanwhile,achieve the seven- parameter calculation program based on Bursa conversion model through VBA and associate some illustrations to verify written procedures in order to ensure the reliability of the results finally.
引文
[1]郭英起,唐彬,张秋江,等.基于空间直角坐标系的高精度坐标转换方法研究[J].大地测量与地球动力学,2012,32(3):125-128.
[2]施一民.现代大地控制测量[M].北京:测绘出版社,2008.
[3]姚吉利.三维坐标转换参数直接计算的严密公式[J].测绘通报,2006(5):7-10.
[4]胡川,陈义,朱卫东.局部区域三维坐标变换的两步解法[J].同济大学学报:自然科学版,2015,43(8):1 254-1 258,1 283.
[5]李正航,黄劲松.GPS测量与数据处理[M].北京:测绘出版社,2005.
[6]姚宜斌,黄书华,张良,等.求解三维坐标转换参数的整体最小二乘新方法[J].武汉大学学报:信息科学版,2015,40(7):853-857.
[7]陈豪,李剑,杨华先,等.CORS服务中在线坐标转换系统的设计与实现[J].测绘通报,2012(10):48-50,54.
[8]吴吉贤,杜海燕,张耀文,等.WGS-84与ITRF2000参考框架坐标转换的研究及应用[J].测绘科学,2008,33(5):73-74,64.
[9]刘亚静,毛善君,郭达志,等.基于VC++的坐标系统转换程序设计与实现[J].湖南科技大学学报:自然科学版,2006,21(3):61-64.
[10]张爽,宫雨生,许青山,等.基于Access VBA的高斯投影程序设计[J].测绘与空间地理信息,2015,38(1):81-83.
[11]武汉大学测绘学院测量平差组.误差理论与测量平差基础[M].武汉:武汉大学出版社,2011.
[2]施一民.现代大地控制测量[M].北京:测绘出版社,2008.
[3]姚吉利.三维坐标转换参数直接计算的严密公式[J].测绘通报,2006(5):7-10.
[4]胡川,陈义,朱卫东.局部区域三维坐标变换的两步解法[J].同济大学学报:自然科学版,2015,43(8):1 254-1 258,1 283.
[5]李正航,黄劲松.GPS测量与数据处理[M].北京:测绘出版社,2005.
[6]姚宜斌,黄书华,张良,等.求解三维坐标转换参数的整体最小二乘新方法[J].武汉大学学报:信息科学版,2015,40(7):853-857.
[7]陈豪,李剑,杨华先,等.CORS服务中在线坐标转换系统的设计与实现[J].测绘通报,2012(10):48-50,54.
[8]吴吉贤,杜海燕,张耀文,等.WGS-84与ITRF2000参考框架坐标转换的研究及应用[J].测绘科学,2008,33(5):73-74,64.
[9]刘亚静,毛善君,郭达志,等.基于VC++的坐标系统转换程序设计与实现[J].湖南科技大学学报:自然科学版,2006,21(3):61-64.
[10]张爽,宫雨生,许青山,等.基于Access VBA的高斯投影程序设计[J].测绘与空间地理信息,2015,38(1):81-83.
[11]武汉大学测绘学院测量平差组.误差理论与测量平差基础[M].武汉:武汉大学出版社,2011.