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