利用arcgis将经纬度转换为坐标

1、1.导入excel数据elptlQ传叵ill,1993也裂彎2右键数据，选择displayXY,选择地理坐标系，加载这些点现育赍料肓况mxd-AmMap-ArcinfoHeEditViewB.ookmarksinsertde-dtionToolsWindowH.&lpSpatialAnalystLaer:口9UTMsoillOOO.Clip.Clip口0E弓已口了口89iZJio口口址Sh.eetl$日E2H-iqS_Features_Projectl1cwdir團!水立站$rrr3口lavmirrpISelection3.右键数据，选择Exportdata,输出为.shp文件，并加载到地图上

2、3目LayersEl严H:站斤有的站点言息谅叩0SheetIfEvents詞Sheetl$辱C:UsersAdminis-tratoi日ZK文站$EventsUD7k丈站$日霏C;Us日r5Adrniniatrmtd日戶鎖站$Events曰费b:hl3areinfo日-JlstreamsSttre-ams.ar匚曰輻b:hll3mnfo=1-Ustrffams4右键shp文件，打开属性表，选择右下角的optionj珊有资料情况阳畑-AreMap-ifUAttributesdFEzportOijtputlli=iijhiFileEditViewoakmsrkESpatialAralysSLaye

3、r:E)qport_Oufput_ll囿Sheetlt日初C:LIIercAdministiratnEl水文站$EventsElTstreamsthhxj-.每Layers0薩C;Us5-sAdmtitrafcBPH:诟有的站庄信息0日tBHSheetl$EventsT谥C:U?&-5Adm：r-iseratcEli.弓鶴茁SEvents日适b:hl3arcinfDstreams曰騙b:hll3rcinfDFIDShape*IDzFeint2107.416733.7333Point盘107.51G7aa.GiG?2Pcinx.3107.2667S3.26673Pnint4107.m了52.SS

4、S7XF-cintc3.07.S3.4B33JFeint6103.316733.CDPointrioa.3S3223.dTFeintaica.333.3SPcintg109.4522.42223Feint101OB.G667332667LQFeint107.965T33.t33311Paint二誥109.0S3S23-2Q55丄2Feint3103.1167S3.4S3312Pcint14103.21C722.414FeintrE1CB.2彌kC.QwL3PclntIt10a.165733.3Paintly103.2A33S3liFeintIE103.3333S2.生15：Pcint1OQ.5

5、fifi了22.4222Feint酸10B.4GG722”2cGi20Feint211OB.333333.316721Paint1OQ.422.122Feint2310B.3333S3.1521P-cint141CS.S21.5524Point2MIDS.a並.1B3322Feint2f1OT.GS3531.7667xVPoi口七豈71CS.91G721.S52TFuint.sa1GB.9531.0567Pcint111.218731.75旳Feint2C1DQ.25i.,iZ-iddJFeint103.316731.933321Pai口七109.5353盟*nBJ一丄anrJT口.4曰曰口R

6、ecord:M*Shew:AllSelectedFLecords(outof200SeiectedOpdons5.点击option,选择Addfield，输入横坐标信息fViFXJlr口hfrclid口耳嵩1厂LlAaM.ErlIrl回1FID且）巳*ID|址1卜cPoint107.li-GT33.7333!Point豆107.51-6722.32-672Poln七31072E-G722.2G72Point4107.2&6722.5GE7一FMntg1O7133333.43335Fuint6Lfr3.31-5733.75EFeintLftB.3B333S.fi7Feint吕33.59ioa.4

7、533.4333劃AttributesofExprt_Output_l1InFoinPoinPonPainP-SITL1FuinFain13FoinFainPainF“nPoinPainPolnPain2.-PoinPoin1Faint.PointAddFieldName:Typ気籲坐标|Float二Cancel0Record:iiLdlPoint108.51-67HaarShow:L3B.53336.同样选择Addfield,输入纵坐标信息OKn|AllSelectedRecords(aoutcf200Selerted)Optionst罔AttributesofExport_Output_l

8、lShape*PaintFeint2Faint3FointFeint533.4B33Feint6108.3167Fs-intFointB33.5OSPointB3AddFieldPoTLPoin-Name:PDin1Fuin-Fain-Pain-Fnin-FieldPropertiesFain-Fain-Poin-Fain-Fozn-Pain-Poin-24Pain1Fdzh-Fain-Foin-CancelPoin-Faint-.FaintPointRecord:I和对Records(0outof200Selected)Shaw:|AllSelectjed1Fazn-f107.4167107

9、.5167107.1&3333.-75狛EPrecisian0ScaJe=aQ0000000C0QC0000000Options7.右键“横坐标”，选择calculategeometry，如图选择相关坐标系和选项2-AA労丈+=t=AT+RHJ山片口X厂STiIziRinTnHifdEthrr-rViofEKpart_OiJtpLt_llF回S3Shpe*ID2TFcjint11OT41S733.7333Q0Foint210T5Kfi733.aifi?G0Point3137.2cc733.IfiST:0三Psintj41OT.266733.56670Pnintu，r丁fnrr-i-dnrrfF

10、uFtFeintCalculateGeometryPointPointPnintPsintFsintNoVouareabouttodoacalculateoutsideofaneditsession.Thismethodisfasterthancalculatirginaneditsession,butthereisnowaytoundojjojrresultsoncethecalculationbegins.Daponwishtocontinue?厂DontwarnmeagainIsPointJhAafaablIhVWPsintlfi108.1GS733.300Fnint17maRFLMRf

11、lnPoint31Q7.41-67107.51-671072g-g733.73331071G71S210821-GCalculateGeometry10810a.wa.410B.Gfi-61Q3.：33108.11-6108.21-6103.SE3103.1-G10ft.5IQBl4S-510BL533LCE.FliE.fl0CoordinateSystem:Usecoordinatessysstemofthedatasour匚已；1GCS:WGS1984I(Usecoordinatesystemafthedata打日巾己：1PCS:WGS垢岡LTTTIZone臥NXCoordinateofP

12、ointProperty:Units:Help21.767|WetersmrCalculateselectedrecordsonlybl58.同理右键“纵坐标”，选择calculategeometry，如图选择相关坐标系和选项107.417107.51107.2&77333397111.23t呻nJn.c戟坐寻V107.132Z103.3.167103-3as-L：B.E1CE.4E103.O&67107.M710S-033；l：E.li?108.IOS.332；103.16?103.3332100-333clOH.M6710B.46710H.533Eiia.4iOS-233；107.2&G7

13、1CE.-ESCalculateGeometryS3IOS.322.1322ani5fi0109.083331.767B8&S100inncb-iT1Onn-Pifi9.ok啦團AttributesofEKpQrt_OutpLt_llFIDShape*jIDs.|r橫坐掾：=Faint11QT.4二石733.7333F23S3B3735101Pointn丘07.5i722.Si盟-25529-3744-5EC2七2107.JZGG722.2GG7F1122B-2GS21523Paint410T.2GG722.5EG771040J71G42C4Faint510T.133333.4S3370235

14、527070005Feintfi1G8.316733.7530725137333EO6Fnintf108.3S3333.6Si39-59-37225407Feint31-5B.333.5臓融57-L-fiOQ3Foiri七910B.4533.4333S2O7773704-6503Fu2n七10ica.弼石733.2&G7?B5GB3535-050LL：氏!inizii107.9ES732.-5S2351B3.372545011Point12IOS.-023222.3S2372179-3G57S9C12Point3103.LIST22.45237S-MDG27ZWZ13Faint14ias.33

15、.47990J7(JOrO14Peint15IOS.2S3333.S530450B372B156SO2SPug七1510E.56C732.4S52盟吃盟Sr-5542C19民:!口七20103.4GS722.1GS7S23214G7512O二Pnfnt21IDS.523322.21G7gassesJG9k97-a21Fsint22LOH.433.18173313S5752O22Feint23IOS.333333L581C92b367287023FeintZ4Lia.6531.册B45052J54072024Fnint251-OB.332.183311156J5n553CFeint靳W?.B33

16、1-76fi752140ZEWrit:27IQS.915731.S5B7OSB3353050027Point閔iOS.35st.aeg?373769-355247C：阴Point2&11.2572L.7ELCS-92i252站究29Paint20IOS.2522.222330=5353話2低邑二Feint21109.516731.9333332504J53S44O31Feint32103533.332S33033354590口ri-Jii+-a3jTiO.1OZ-口叮叮土厂mFleoord;H10kMShaw;|AllSelected|Reoards(0outof200Selected)Opt

17、ions十10.点击option,选择export,选择保存路径，类型选择为db,这是可以在excel里面打开的，Ok啦！回S3S33Lookin3705020IIRecords(Qoutof20QSelected)須AttribatesofExport_Output.OptionsI=-EE-口口=口口FIDShape*ID3.Tf橫生标:FXnt1107-416733.7333723Q933735S-；1P=jLnt2107-516733.E-5773233?3746302P-o-int31(57.2&G733.2SS771112335H31503P-Dint4107.555722-555771*402271-5420一4Psint5107.1S2222.4a3270235537070005PoLntiOS.216722.7510725127352SOPcint/l:e.m珈33.-GE13M92.722940-Eoiux3103.333.510653-83711600i=|DATA工具HJExport_Ou_Ioffice#手动处理IEExport_Ououtput拟）詞Export_OuZJwps._1渕虧器13Export_Ou_1zhaoqin亘严提取中国盎