International Open Access Journal Platform

深圳市3套平面直角坐标系的相互转换——基于Excel多元回归分析的正形变换

Mutual Transformation of Three Plane Rectangular Coordinate Systems in Shenzhen —Orthomorphic Transformation Based on Excel Multiple Regression Analysis

Geomatics Observation / 2022,4(4): 1-9 / 2022-11-24 630 1412

View Download PDF

• Authors: 刘大海¹²      陈永红²      张萧²      曾庆桂²     
• Information:

  1．深圳市地质局，深圳； 
  2．深圳地质建设工程公司，深圳

• Keywords: Shenzhen independent coordinate; CGCS2000 coordinate; BJ54 coordinate; Regression analysis; Excel 深圳独立坐标；CGCS2000 坐标；BJ54 坐标；回归分析；Excel
• Abstract: After the CGCS2000 coordinate system is fully used, it is often necessary to convert Shenzhen independent coordinates, BJ54 coordinates and CGCS2000 coordinates to each other in engineering. Coordinate transformation includes indirect method and direct method. Conformal transformation is one of the direct methods. It has the advantages of isometric transformation and can be used in the transformation of Gaussian projection plane rectangular coordinates of the same sphere and different spheres. In this paper, 67 second order GPS coincidence points in Shenzhen are selected, and a simple Excel multiple linear regression method is used to solve the parameters of orthomorphic transformation. The method is simple and practical, with fast calculation and high conversion accuracy. 在全面启用CGCS2000坐标系后，工程上常常需要对深圳市独立坐标、BJ54坐标、CGCS2000坐标进行相互转换。坐标变换分间接法及直接法。正形变换是直接法之一，它具有等角变换的优点，可通用于同球及异球的高斯投影平面直角坐标变换。本文选用了深圳市67个二等GPS重合点，对正形变换的参数求解采用了简易的Excel多元线性回归方法。方法简单实用，计算快捷，转换精度高。
• DOI: https://doi.org/10.35534/go.0404001
• Cite: 刘大海．深圳市3套平面直角坐标系的相互转换——基于Excel多元回归分析的正形变换［J］．测绘观察，2022，4（4）：1-9．