以全球地质图信息元数据为例实现Excel数据集到ArcGIS空间数据的转换

The Transformation of Excel Data Set into ArcGIS Spatial Information Based on the Global Geological Map Information Metadata

本文是对包含15915行地质图信息元数据(每行元数据包含四个角点坐标)的EXCEL做处理,形成包含X、Y坐标序列数据,添加到ArcGIS中形成15915×4个点要素,通过点转闭合线和线转面的工具处理,将其能在ArcGIS平台下展示这些全球地质图件的形状、位置和属性信息,使之与Excel表格数据完全一致。实践证明该方法简单、有效,数据损失率低。

This paper is on the mineral contains15915rows(each row metadata information metadata contains four corner coordinates)Excel treatment,including X,Y coordinates the formation of sequence data,added to the ArcGIS form15915×4elements,turn the closed line through the point and line to the surface processing tool,can show the shape,the location and attribute information of the global mineral maps in the ArcGIS platform,which is consistent with the Excel table data.The practice shows that the method is simple and effective,and the data loss rate is low.