教你如何將三維坐標(biāo)轉(zhuǎn)換為南方CASS的

1、教你如何將三維坐標(biāo)轉(zhuǎn)換為南方CASS的*.DAT格式做測(cè)量的我們也許經(jīng)常會(huì)頭疼如何將手中所測(cè)得的 X、Y、H三維坐標(biāo)（如左圖所示） 轉(zhuǎn)換為南方CASS所能識(shí)別的*.dat數(shù)據(jù)格式，以用于展高程點(diǎn)、計(jì)算土方量等后續(xù) 工作。其實(shí)用我們常用的Office軟件就能完成。ABCD1點(diǎn)名Xyh2199782.222263793.978855.29763299793.430663794.72856.59164399805.798363794689456.7416499826.254863794.900456.3676 -6599837.160563795.617755.94667699857.2527637

2、95.069156.58368799881.354763793.786957.21669899899.892763789 742957.057610999899.702463783.421355.7086111099895.387263788.488157.8936121199886.648663789.324558.6446第一步：確保你的數(shù)據(jù)是縱列的*.csv格式或*.xls格式并在Excel中打開它。在右邊 某列輸入與如下格式相同的公式：點(diǎn)名&",，"&東坐標(biāo)&"，-&北坐標(biāo)&"，-&高程，&

3、","&這樣的非數(shù)字字符請(qǐng)一定要在英文格式輸入。如右圖所示。將公式往下填充到最后 一個(gè)點(diǎn)所在行。請(qǐng)注意 點(diǎn)名”后面是雙逗號(hào)，中間有一個(gè)是點(diǎn)代碼，如果沒有點(diǎn)代 碼則留空即可。如果沒有點(diǎn)名也可以空著。打開一個(gè)空白記事本文檔，在Excel中將生成的數(shù)據(jù)拷貝，粘貼到記事本F2>eA=A3&*J配血 J 蟄E別PD2AEcJE?GH1點(diǎn)容Xyh2199732.222263793 978855.29761.63793 9788.99782 2222,55.29763299793.43065379472856.59162.,63794.728r997S3 4305,

4、56 591S4399805.79S36379469945674163 ,63794 &B94.99e05 7983r55 74l65499825.254063794.90045636764 ,63794 9004 99825.2548,55.36766599837.160563795.617755.94665l|63795.ei77.99fi37,1605,55 946&7699857.252763795.069156.58366 ,63795.0691.99657 2527,55 5836S199631.354763793.736957.2166Al63793.7S69 9

5、9e01.3547l57.2156g399899 892763799.742957 05768.，&3789.749 99899 8927.57.0576999899.702463703.421355.70869 ,63783 4213,99699 7024r55 7086it1099095 337263783.488157.393610, 637Se.4SS1.99895 3872.57 8936121199886643663739.824558.644611 637S& 0245,99885.6406.58 5446131299880.686963790.53445fi.6

6、4S61263790.5344.9&S80.6869r68.5486U1399863855163790.50115B.166613,r63790.50U,9986B.S551.5a.1666151499803.537163733.475755 465614,63783.4757,99853.5371.55.4556IS1599855.3788&3786.653&55.417615,63788.6536,99855.3788,55.4176IT1699849290763798.054955.516616ir637S6.0649 99849 2907.55 51661317

7、99S37 622963790.608355.598617 ,63790 60E3.99S37.6229 55 5936191999813392663735.5Q6255.5B6619.,537e5.6Qt2.99819.3926,55.596620209980S.71763779.098755.35262063779.08S7.9S808.7l7r55 3526212199807 593463785 3343563SS621637S5 S343.998)7 5934.56 3B36222299796.156363773,233155290622,63773.2331,99796.1553.5

8、5.2906232399B0S 199363752.682955.230623. r63752.6329, &9806.199 3,55-23 0 6242499793.63065373905655.25562<,63739.056.9979a6306r55 2556252599807.679863730.374255 647625.63730 3742,99807.6790.55.5476262699796.855363721 710755.09&626, ,63721.71B7,99796,0653,55.098627279S792343863718.930955.1

9、45627, 6371 9309.99792.3438,55.1456232899735.5956637060077547916述店衿衿;胎諾榜弧興丞292999781.1384636747103547366296357 4.7103.99781.1304.54 7366第三步:將記事本保存為*.dat格式。小知識(shí)：“&為Excel中的字符串運(yùn)算符，用于連接兩個(gè)字符串合并成一個(gè)字符串還有第二種方法：1、 只保留點(diǎn)號(hào)、X、Y、H坐標(biāo)四列數(shù)據(jù)，并編輯使數(shù)據(jù)成點(diǎn)號(hào) 空列 東坐標(biāo) 北 坐標(biāo)高程"五列分布。2、將Excel表格另存為*.csv格式（逗號(hào)分隔符）。3、用記事本編輯器打開所

10、保存的*.csv格式文件，將其另存為*.dat格式。擴(kuò)建文本文欄記事本另存為文絢呼第舊掐式Q）童畳（V）$m（H）1., 63793. 9住& 99752. 2222, 55. 29762., 63794,驅(qū)& 99793. 4306, 56. 5916 3八 63794. 6894; 99805, 7983, 56. 74164., 63794. 9004, 99826. 2543, 5& 3676 5八 63795. 6177, 99837.1605, 55. 94666., 63795. 0691, 99857, 2527# 56. 58367., 63793.

11、7869, 99881. 3547,57. 216G 8“ 63789. 7429, 99899. 8927, 57. 05769., 63783, 4213, 99899, 7024, 55, 708610., 6378S. 4381, 99895. 3872, 5匸 393611., 63789. 8245, 99886. 6486, 5艮 644612., 63790. 5344, 99880, 6869, 5& 548613., 63790. 5011, 99368. 8551, 53.166614., 63783. 4757, 99863. 5371, 55. 465615.

12、, 63788. 653® 99855, 3花& 55. 417616., 63783. 0649, 99348. 290兀 55. 516617., 63790. 6083, 99837. 622% 55. 5986 19, 63785. 6062, 99818. 3926, 55. 5邯620., 63779. 0S8L 99308. 717,55 352621., 63785. 8343, 99807. 5934, 56. 3886 22, 63773. 2331, 99796,1563, 55. 2906 23 63752. 6S29, 9980$. 1993, 55. 230624., 63739. 056, 99798. 6306, 55. 255625., 63730. 37