http://a4.qpic.cn/psb?/V14baA6R0EYa75/fJ7kclUPJ3qPGocqq79aBm5E*ZeNUI5N4rVOJEIeuis!/b/dDrpQHTfKwAA&ek=1&kp=1&pt=0&bo=agGFAAAAAAADAMs!&su=0130188017&sce=0-12-12&rf=2-9

=INT(A2/10000)+INT((A2-INT(A2/10000)*10000)/100)/60+(A2-INT(A2/100)*100)/3600

http://a1.qpic.cn/psb?/V14baA6R0EYa75/wvlkA3qUoLcES4wiODuMDRAX9120XFrKKLiBePxS2M8!/b/dP5u2XQ0KwAA&ek=1&kp=1&pt=0&bo=KgJHAAAAAAADAEo!&su=0204243201&sce=0-12-12&rf=2-9

2.在GIS中导出为xy坐标数据

http://a3.qpic.cn/psb?/V14baA6R0EYa75/LBu.vU3jJVqU4HxzhFvWG0qnZXNDLf3nnISE99hL2*k!/b/dKxWsXPbKwAA&ek=1&kp=1&pt=0&bo=BgI2AQAAAAADABY!&su=015213793&sce=0-12-12&rf=2-9

http://a1.qpic.cn/psb?/V14baA6R0EYa75/7BQL8TLeIDa6vN.emk6UU2u*hFKEK*5UCu4T9Hjm6*Y!/b/dGFH1nQeLAAA&ek=1&kp=1&pt=0&bo=DwIPAQAAAAADACY!&su=0183224017&sce=0-12-12&rf=2-9

http://a3.qpic.cn/psb?/V14baA6R0EYa75/ulaWDk4n67I1pO.uIiW*YpM9UGNsd*zUSPPrIbtWPk4!/b/dCKco3PcKwAA&ek=1&kp=1&pt=0&bo=KgJqAQAAAAADAGY!&su=046034385&sce=0-12-12&rf=2-9

http://a1.qpic.cn/psb?/V14baA6R0EYa75/y6nuZsv6Upj.HZlc2OrxleINcGboUlK.gJcKNG2vw8A!/b/dAaP33TsKwAA&ek=1&kp=1&pt=0&bo=SAG4AAAAAAADANQ!&su=016402833&sce=0-12-12&rf=2-9

http://a1.qpic.cn/psb?/V14baA6R0EYa75/nMEyaXMHIr0P38Byu4iNmDG6r6zzFunsGKkRfcDayJY!/b/dH4g4XTUKwAA&ek=1&kp=1&pt=0&bo=KgIaAQAAAAADABY!&su=0201041889&sce=0-12-12&rf=2-9

重新打开arcmap导入输出的Beijing54投影文件

http://a3.qpic.cn/psb?/V14baA6R0EYa75/gRbQotJmoaqKMeb1LpxeVFRbD9jeZ54DtroBZmiWeqc!/b/dPIcpXPYKwAA&ek=1&kp=1&pt=0&bo=KgIgAQAAAAADACw!&su=011107249&sce=0-12-12&rf=2-9

http://a1.qpic.cn/psb?/V14baA6R0EYa75/9g0Dm5PO4GsW*FScLwf7sQvgzwjfaYy.Qi.svAd4vIY!/b/dCMF23QKLAAA&ek=1&kp=1&pt=0&bo=KgKiAAAAAAADAK8!&su=0107975521&sce=0-12-12&rf=2-9

提取图像上的值

http://a4.qpic.cn/psb?/V14baA6R0EYa75/5ku8kr3hEgzOe1GYsUZQ21.Kdgcv0eAyh01acsWJK1I!/b/dO*zQ3TgKwAA&ek=1&kp=1&pt=0&bo=KgIJAQAAAAADAAU!&su=081770209&sce=0-12-12&rf=2-9

http://a4.qpic.cn/psb?/V14baA6R0EYa75/nRDrIGANEs*Dqt.*GDY75FQWRZrDhuCCt6xo.gukRnc!/b/dEPmQ3TfKwAA&ek=1&kp=1&pt=0&bo=KgJrAAAAAAADAGY!&su=0183588929&sce=0-12-12&rf=2-9

http://a1.qpic.cn/psb?/V14baA6R0EYa75/Mx*45ZYkQTEVjD0cTc9LvH7Z5wR3z8e7b8oZqWi6.nU!/b/dNUa4XQPLAAA&ek=1&kp=1&pt=0&bo=NAE4AQAAAAADACk!&su=045893697&sce=0-12-12&rf=2-9

http://a4.qpic.cn/psb?/V14baA6R0EYa75/i4i6T3QqWaB5iVJijjRDyEpK4z4mNUVBzzhHHHQ6GmY!/b/dGpmQnTcKwAA&ek=1&kp=1&pt=0&bo=6gGVAQAAAAADAFo!&su=031513617&sce=0-12-12&rf=2-9

http://a1.qpic.cn/psb?/V14baA6R0EYa75/HQ1F4vfuTG8T*gU*9Qi*lSX2GKPqxOdIZr4kQMm8Cng!/b/dH9W2XRkKwAA&ek=1&kp=1&pt=0&bo=KgKtAAAAAAADAKA!&su=090299921&sce=0-12-12&rf=2-9

导出文本即可在Excel打开就好了

http://a4.qpic.cn/psb?/V14baA6R0EYa75/HcI8RfpPqwvTXx7Z83LM2rcjzFkgglT0A8pYmqwObLE!/b/dPPXQHTiKwAA&ek=1&kp=1&pt=0&bo=tQGvAQAAAAADAD8!&su=034404945&sce=0-12-12&rf=2-9

http://a1.qpic.cn/psb?/V14baA6R0EYa75/qEkbSGFWoTsIHSZv9qdNjp0Yd5GArToPL7U8pnZtUKc!/b/dMmA3HT3KwAA&ek=1&kp=1&pt=0&bo=9QFQAQAAAAADAIA!&su=0182361121&sce=0-12-12&rf=2-9

http://a3.qpic.cn/psb?/V14baA6R0EYa75/pfluAmWSCJGSi7JaDGT*w3gRJMWQTnKzcElWIpRab5k!/b/dFhxsXPcKwAA&ek=1&kp=1&pt=0&bo=lwFNAQAAAAADAP8!&su=0158526225&sce=0-12-12&rf=2-9

http://a3.qpic.cn/psb?/V14baA6R0EYa75/cUU0EtHE147NItNUcWgSeEvsoQHyxocH4G.Bjp.TJpc!/b/dN9Mq3PdKwAA&ek=1&kp=1&pt=0&bo=KgLCAQAAAAADAM4!&su=02944545&sce=0-12-12&rf=2-9

http://a1.qpic.cn/psb?/V14baA6R0EYa75/3R0Yk5NsCDSI7gi.ye8r3u.2qe*pXI*3LdQscQdyhvs!/b/dD1s3HQLLAAA&ek=1&kp=1&pt=0&bo=KgJcAQAAAAADAFA!&su=0110078721&sce=0-12-12&rf=2-9

http://a4.qpic.cn/psb?/V14baA6R0EYa75/gFBlFsv96KhgjN8DXvKn6ZYD9bT8bomIcUL07wmx4Do!/b/dHb*SXTbKwAA&ek=1&kp=1&pt=0&bo=KgJfAQAAAAADAFM!&su=050951713&sce=0-12-12&rf=2-9

http://a1.qpic.cn/psb?/V14baA6R0EYa75/bNLl2RXUSwY8zzpNOp38n867gn4BxZcKinnHP92gfPQ!/b/dJRi1nT*KwAA&ek=1&kp=1&pt=0&bo=sgELAQAAAAADAJw!&su=061464881&sce=0-12-12&rf=2-9