• CSCD核心中文核心科技核心
  • RCCSE(A+)公路运输高质量期刊T1
  • Ei CompendexScopusWJCI
  • EBSCOPж(AJ)JST
二维码

隧道建设(中英文) ›› 2008, Vol. 28 ›› Issue (3): 302-304,308.DOI: B

• 规划与设计 • 上一篇    下一篇

利用EXCEL进行道路中边线逐桩坐标计算

张宝利1,薛志勤2   

  1. 1.西北农林科技大学资源与环境学院2.华南农业大学信息与软件学院
  • 收稿日期:2008-01-16 修回日期:2008-02-26 出版日期:2008-06-20 发布日期:2009-11-19
  • 作者简介:张宝利 (1974—)|男|2006年毕业长安大学大地测量学与测量工程专业|硕士|讲师|现在西北农林科技大学资环学院从事地理信息系统专业的教学工作。

Calculation of Coordinates of Stakes on Centerline and Sideline Using Excel

HANG Baoli1,XUE Zhiqin2   

  1. 1. College of Resources and Environment, Northwest A&F University2. College of Information and Software, South China Agricultural University
  • Received:2008-01-16 Revised:2008-02-26 Online:2008-06-20 Published:2009-11-19

摘要:

 利用坐标增量的基本思想,将道路曲线坐标的计算归结为3种最基本的形式——直线段、圆曲线段、缓和曲线段,直接计算出中、边线的测量坐标,省去了切线支距法坐标向测量坐标的转换过程,简化了计算思路,节约了计算量。并利用办公软件Excel的强大计算功能进行实例计算。

Abstract:

The coordinate calculation of the highway curves is divided into three basic types, i.e., straight section, circular curve and transition curve, on basis of the coordinate increment principle. Without coordinate transformation, the survey coordinates of the stakes on the alignment of the centerline and sideline are directly worked out, which simplifies the calculation principle and reduces the calculation quantity. Furthermore, coordinate calculation is made for project cases by using the strong calculation functions of Excel.

Key words:  , Excelhighway sidelinehighway centerlinecoordinates of stakescircular curvetransition curve

中图分类号: