Excel在不同椭球地理坐标到大地坐标转换中的应用  

Application of Excel in Transformation Between Different Ellipsoidal Geographic Coordinates and Geodetic Coordinates

在线阅读下载全文

作  者:杨勇军[1] 侯青青[1] 

机构地区:[1]江西有色地质勘查二队,江西赣州341000

出  处:《地矿测绘》2016年第1期46-49,共4页Surveying and Mapping of Geology and Mineral Resources

摘  要:文章给出了高斯—克吕格投影正算及参数间相互关系转换公式,利用其转换公式,对中国现有3种地理坐标系(1954北京坐标系、1980西安坐标系和2000国家大地坐标系)坐标在Excel单元格中编制相应的语句进行换算,并给出具体的换算公式和与之对应的Excel语句及已编制好的换算表格。实践证明,这种方式表格能实现地理坐标系到大地坐标系坐标的自动转换,大地坐标3°和6°的互换带,使烦琐换算变得程序化、自动化。The formulas of Gauss-Kruger projection directly-calculation and the transformation relationships of all theparameters are presented in this paper. The transformation formulas are used to convert the coordinates between threekinds of geographic coordinates in China (1954 Beijing coordinate system, 1980 Xi'an coordinate system and 2000 na-tional geodetic coordinate system) through the preparation of the corresponding statement in Excel cell address. The spe-cific transformation formulas and corresponding Excel statements, and transfommtion table are given. All the facts provesthat the method can achieve the automatic transformation of coordinates from the geographic coordinates system to the geo-detic coordinates system, and realize the exchange between 3° belt and 6° belt, and making the cumbersome transforma-tion process become automatic.

关 键 词:高斯一克吕格投影 大地坐标 地理坐标 坐标转换 换带 

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

 

参考文献:

正在载入数据...

 

二级参考文献:

正在载入数据...

 

耦合文献:

正在载入数据...

 

引证文献:

正在载入数据...

 

二级引证文献:

正在载入数据...

 

同被引文献:

正在载入数据...

 

相关期刊文献:

正在载入数据...

相关的主题
相关的作者对象
相关的机构对象