摘要
目的针对借助Excel、记事本解决Mapsource和GPS无法批量输入地质点坐标的不足,探讨地质点经纬度坐标批量输入GPS eTrex方法。方法通过观察GPS交换文件在记事本条件下的格式,发现具有明显的规律性,而这种规律性通过第三方软件可以进行复制。经过多次模拟试验,发现在Excel环境下可以将大量地质点坐标形成gpx格式文件文本内容,再利用记事本软件将其保存成gpx交换格式文件,形成交换格式,最后利用GPS随机自带的Mapsource软件打开gpx交换格式文件,并利用其数据传输功能,将地质点坐标数据传输至GPS。结果 Excel公式套合可以形成有效的gpx交换格式文件的文本内容,记事本可以方便地将数据保存成gpx交换格式文件,Mapsource能成功地读取和编辑gpx文件,并将数据传输至GPS。结论实践证明,该方法能将地质点经纬度坐标批量输入GPS,具有提高效率、降低劳务强度、技术可靠、经济合理、运行稳定等优势,具有进一步推广的价值。
Objective This paper aims to enable batch input of observation point coordinates with excel and notepad,instead of Mapsource and GPS,and studies the methods of batch inputting GPS eTrex.Methods By observing the format of GPS exchange under the condition of notepad,the study discovered an obvious regularity,which could be replicated through a third software.After many simulation tests,the study found that under the condition of excel,a large quantity of geologic observation point coordinates were formed into gpx text format file,which could be further saved into gpx exchange format file with notepad software.This exchange format file could be opened by the built-in Mapsource software of GPS,and its data transmission function could help to transmit the geologic observation point coordinates to GPS.Results Excel formula sets resulted in effective gpx exchange format file text content,and notepad easily saved data into gpx exchange format file.Mapsource successfully read and edited gpx file,and transmittted data to GPS.Conclusion Practice proves that this method can batch input the latitude and longitude coordinates of geologic observation point into GPS.It has the advantages of high efficiency,lower labor intensity,reliable technology,reasonable price,and operation stability,etc.It is worth being further popularized.
出处
《河北北方学院学报（自然科学版）》
2016年第7期21-24,共4页
Journal of Hebei North University:Natural Science Edition
