路线平面计算案例——某机耕道路线交点要素的解算.docx

上个月，我发了一篇“某低等级公路交点坐标的解算”的日志，今天又接到一位网友类似的案例，大致看了一下，应该可以解算出来，先发在此处，有兴趣的网友可以先试试手。王老师：你好！我叫*，现在贵州遵义思遵高速七标，所处标段其中有条机耕道路线只有逐桩坐标（无任何相关线路要素资料，对边坡等放样极为不便，望老师给予解答，能怎样算出线路各相关曲线要素吗？或者有怎么样更简便方法。渴盼解决！谢谢！桩号 X坐标 Y坐标0,3107157.179,466931.00195,3107162.156,466930.532310,3107167.134,466930.062614.596,3107171.71,466929.630915,3107172.112,466929.59220,3107177.069,466928.942125,3107181.975,466927.983926.818,3107183.743,466927.559730,3107186.812,466926.721235,3107191.561,466925.158739.04,3107195.321,466923.681540,3107196.205,466923.30845,3107200.811,466921.362750,3107205.417,466919.417455,3107210.024,466917.472160,3107214.63,466915.526765,3107219.236,466913.581470,3107223.842,466911.636175,3107228.448,466909.690880,3107233.054,466907.745580.864,3107233.849,466907.409485,3107237.614,466905.695990,3107242.029,466903.351690.058,3107242.079,466903.322595,3107246.278,466900.718499.253,3107249.748,466898.2599100,3107250.345,466897.8109105,3107254.341,466894.8057110,3107258.337,466891.8004115,3107262.333,466888.7952120,3107266.329,466885.79125,3107270.325,466882.7848130,3107274.321,466879.7796135,3107278.317,466876.7744140,3107282.314,466873.7692145,3107286.31,466870.7639150,3107290.306,466867.7587155,3107294.302,466864.7535160,3107298.298,466861.7483165,3107302.294,466858.7431170,3107306.29,466855.7379175,3107310.286,466852.7327180,3107314.282,466849.7274185,3107318.278,466846.7222190,3107322.274,466843.717195,3107326.27,466840.7118200,3107330.267,466837.7066205,3107334.263,466834.7014208.599,3107337.139,466832.5381210,3107338.263,466831.7014215,3107342.335,466828.8012219.684,3107346.236,466826.2091220,3107346.502,466826.0384225,3107350.759,466823.416230,3107355.101,466820.9369230.768,3107355.775,466820.5691235,3107359.495,466818.5512240,3107363.89,466816.1672245,3107368.285,466813.7832248.292,3107371.179,466812.2135250,3107372.663,466811.3674255,3107376.78,466808.5369257.511,3107378.706,466806.9273260,3107380.513,466805.2151265,3107383.802,466801.4538266.729,3107384.827,466800.0612270,3107386.709,466797.3857275,3107389.585,466793.2956280,3107392.461,466789.2056280.779,3107392.909,466788.5684现在我来阐述一下我的方法，仅供参考：首先将桩号、坐标导入到EXCEL中，并生成绘图数据（D列）：在AUTOCAD中绘制中线图，如下：以上有关EXCEL、AUTOCAD的有关操作，如果有网友还不会的话，请先参看一下我的这篇日志：AUTOCAD参数查询及绘图技巧EXCEL辅助篇。通过分析桩号、坐标，我推断出几条信息：1该路线曲线未设缓和曲线，只有圆曲线，这个很正常，机耕道嘛，没必要整那么复杂；2桩号表中，圆曲线三大主点桩号（ZY, QZ, YZ）及相应的坐标均给出。看来设计师还是很人道的。为了在AUTOCAD中绘图更加方便，我不用前面生成的线型图，而是把起终点、曲线主点的坐标剔出来：然后用绘制点的方法，将这些特征点绘制出来：连上直线段：将直线段延长，形成交点（AUTOCAD操作方法，大家应该都懂的）：将连接而成的直线段生成多段线（利用PEDIT命令的连接功能）：再用LIST命令，可以得到各交点和路线起终点的坐标了，经过适当编辑，可复制到EXCEL中，这里就不细表了。现在只剩下圆曲线半径的问题了，这个不难，有了圆曲线上的三个点，利用画圆弧的命令绘制圆弧：在属性窗口中查询圆弧的半径，第一个半径是80.0077，根据设计习惯，我们一般不会设这么一个半径值，