公路外业测量获取的点号和三维坐标,转化为公路里程和高程,并导入AutoCAD中得到路线纵断面图和平面图

点号1234567891011121314151617181920212223N坐标（m）2826429.8542826423.5912826419.1472826415.0182826410.8042826406.8322826402.3392826396.7952826391.1742826386.0212826380.5532826375.0612826370.2162826365.9042826360.2892826354.5952826348.8512826342.8942826336.8432826330.7122826325.0032826319.9032826315.753E坐标（m）591905.156591904.816591901.982591898.800591894.898591891.559591887.468591882.162591877.120591872.997591869.212591865.751591862.202591859.356591855.225591851.262591847.599591843.769591839.581591835.429591831.119591826.972591822.735高程（m）2377.4432376.8942376.4992376.2792376.0382376.1182376.1472376.0932375.9672375.7492375.3702375.1702375.4562375.5322375.6342375.6002375.3762375.2592375.1552375.0652374.4492373.6532372.6716.2725.2715.2135.7435.1896.0767.6747.5516.5996.6506.4926.0065.1676.9716.9376.8137.0827.3597.4057.1536.5735.931点间距的距离（m）里程（m）0.0006.27211.54316.75622.49927.68833.76441.43848.98955.58962.23968.73174.73679.90386.87493.811100.624107.706115.065122.469129.622136.196142.127高程（m）2377.4432376.8942376.4992376.2792376.0382376.1182376.1472376.0932375.9672375.7492375.3702375.1702375.4562375.5322375.6342375.6002375.3762375.2592375.1552375.0652374.4492373.6532372.671纵断面数据0,2377.4436.272,2376.89411.543,2376.49916.756,2376.27922.499,2376.03827.688,2376.11833.764,2376.14741.438,2376.09348.989,2375.96755.589,2375.74962.239,2375.3768.731,2375.1774.736,2375.45679.903,2375.53286.874,2375.63493.811,2375.6100.624,2375.376107.706,2375.259115.065,2375.155122.469,2375.065129.622,2374.449136.196,2373.653142.127,2372.671平面数据591905.156,2826429.854,2377.443591904.816,2826423.591,2376.894591901.982,2826419.147,2376.499591898.8,2826415.018,2376.279591894.898,2826410.804,2376.038591891.559,2826406.832,2376.118591887.468,2826402.339,2376.147591882.162,2826396.795,2376.093591877.12,2826391.174,2375.967591872.997,2826386.021,2375.749591869.212,2826380.553,2375.37591865.751,2826375.061,2375.17591862.202,2826370.216,2375.456591859.356,2826365.904,2375.532591855.225,2826360.289,2375.634591851.262,2826354.595,2375.6591847.599,2826348.851,2375.376591843.769,2826342.894,2375.259591839.581,2826336.843,2375.155591835.429,2826330.712,2375.065591831.119,2826325.003,2374.449591826.972,2826319.903,2373.653591822.735,2826315.753,2372.671附注：1、把纵断面数据复制后，打开AutoCAD，选择多段线命令，在命令栏粘贴数据，就可以得到公路的纵断面图。 2、把平面数据复制后，打开AutoCAD，选择三维多段线命令，在命令栏粘贴数据，就可以得到公路的平面图。 3、注意cad中的X坐标对应的是E坐标，Y坐标对应的是N坐标，因此导入cad的时候要调换前后位置。