北京54和西安80坐标系下的坐标转换及精度分析在Excel中的实现  

Coordinates Transformation and Accuracy Analysis between Beijing 54 and Xi′an 80 Coordinates Systems in Excel

作　　者：刘科利[1] 

机构地区：[1]山东理工大学建筑工程学院,山东淄博255049

出　　处：《勘察科学技术》2008年第5期24-27,共4页Site Investigation Science and Technology

摘　　要：北京54和西安80坐标换算是工程建设中经常遇到的问题,可使不同坐标系统下的测绘成果得到充分利用,因此快速准确地进行坐标转换及评定转换的精度是非常必要的。Excel电子表格有强大的数据处理功能,处理结果直观性好和操作简单,因此得到广泛的应用。该文利用Excel的优点,并采用重心化坐标使计算更加简单,实现了北京54和西安80坐标转换参数求解、精度评定和坐标之间的相互转换表格输出。The coordinates transformation between Beijing 54 and Xi′an 80 geodetic coordinates systems is the question which in engineering construction meets frequently.To make full use of surveying results in different geodetic coordinates systems,it is necessary to transform coordinates and evaluate transform precision from one coordinate system to another.There are more characteristics in Excel such as powerful data processing function,good intuitiveness in processing results,simple operation and so on,so it gets extensive application.Based on advantages of Excel,adopting gravity-centralized coordinates in this paper,the coordinates transformation,parameter solution,precision evaluation and chart processing in mutual system coordinates and printing between Beijing 54 and Xi′an 80 coordinates system are realized.

关 键 词：平面坐标转换 重心化 转换参数 精度评定 

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