将经纬度坐标的数据转换成点导入Arcmap以及生成Shp文件

1、将经纬度坐标的数据转换成点导入Arcmap以及导出生成Shp文件1、用Excel表格整理经纬度数据，经纬度以小数格式表示:AB1经度纬度2117.1204=239.14463117.1251539.144234117.1230839.144295117.1326839.144566117.1374839.144937117.1423539.145358117.1507539.145949117.1572B39.1453510117.1628839.1454111117.1655539.1401312117.165S239.1361S13117.1680239.1316514117.168283

2、9.1267915117.LSS7539.1225S16117.1737539.1203917117.1736239.1153S18117.1732B39.1106319117.173i839.1064220117.1731539.101321117.1657539.0993822117.1585239.0909423117.1505239.09SS124117.14=36839.0905425117.1320239.0976126117.1213539.0961427117.1071S39.097342、然后打开access创建“表”，将excel表格导入，如图lS打开吆设计观冒导入IMHU

3、AccessdCEJ冈Excel(X)通过电子删判濮和烫新數揣也SharePoint列表件CD在此组口隐蔺凹XML刘牛陋删除也剪切ODBC琳偉也Outlook刘抉回HTML如(W所有Access对象戸表:T戸Sheetl妙”PID+经度”117.12042纬度”39.14：463表金2117.1251539.14423rSheetl3117.1290B39.144=29固表14：117.1326B39.144565117.1374S39.144936117.14=23539.145357117.1507539.14594S117.1572B39.145359117.1628B39.145411

4、0117.1655539.14Q13复制卫然后导出为dbf格式所有Access对彖T表*rSheet：吕表lS打开回吆设计观冒导入処导已旧戸录珥二EheetlIDJ经度-纬頂1117.1204=239通过的雅Ifc軌萸新数据匸1在此组中隐嚴删除Q萸切复制粘贴（B锢诽晋理器迪转换为本地恚岳W1F?+trRi2117.1251539.3rUT.1Z90B39.4：117.1S2&839.5117.137iB39.6117.1423539.EamelGgSharePoint列表WordRTF文祥PDF或XP&P)Access(A)文*史件CDML文件OJODEC：数摇库HTML站凹严dBA&E觀Wo

5、rd4.在Arcmap中进行添加点然后导出为Shp格式选择添加点FileEditViewEookmarksInsertSelectionToolsWindowHelpQS站电翹Xe-H:#EditoToolbarGraphsReportsGeocodingMacrosCustomiz?.Extensions.AddXYData.兴AddRouteEvents.添加刚才导出的dbf文件选择精度纬度点击edit进行投影的设定SpatialRefersn匚e-PropertiesIbiiTit：:UrLkrLuATL5e1ec七=a.predefined,coor-lirLatesysten.Imp

6、vi-1=aCQix-liiL：=LtHsystemwd:L/YZ：=jLilMdcrri:kitleHpe=Jlsxis+irLgCWllTLSLtE确定IsystEm.sys+hjTi+c应用I然后点击确定。當Undilad-A/cMjp-ArdnfoiHEETlSwntiQ3ft1fileEditifiewBookinarluiinsertSricdtionloalsflindasJjelp5.将数据重新进行导出成为Shp文件XRemove國OpenAttributeTableoinsandRelatesConvertLabelstoAnnotation.您ZoomToLayer盘IZoomToMakeVisibleVisibleScaleRangeSaveAsLayerFile.督Propertie&.Ewport:DstsConvertFeaturestoGraphics.ConvertSymbo-logytoRepresentation.RepairDataSource,Usetiiesameoaordinatesystemas:穴thislayerssour匚亡datath亡d日tafrann亡广thefeaturedatasetyouexportthedatainto(onlyappliesiFyouexport