根据TIN不规则三角网格法,使用ArcGIS快速准确的计算出土地平整的填挖方量,在此基础上,根据Dijkstra算法结合ArcGIS中拓扑网络关系分析计算功能得到各工地之间的最短路径,应用最小元素法对ArcGIS中取得的填挖方数据进行进一步调配,同时建立ArcGIS与Excel-VBA两个软件之间的动态链接,使得Excel计算所得数据可以直接被ArcGIS查询。实例分析表明,该方法可以方便快速的实现土方调整的最佳方案,弥补了单一软件功能性的不足,有效避免了在人工计算中计算复杂,计算量大,误差较大及效率低等问题。
According to triangulated irregular network(TIN) algorithm,ArcGIS is utilized to figure out the earth volume of cut-fill quickly and accurately.Based on the Dijkstra algorithm and combined with the topological network relation of ArcGIS,the shortest path between each work sites is calculated and acquired.Furthermore,the minimum element method is applied to analyze the cut-fill data taken from ArcGIS,and therefore build a dynamic linking between Excel-VBA and ArcGIS,which makes the analyzed data inquired directly by ArcGIS.The example indicates that this method is simple,precise and efficient in generating the optimum earth transferring route,compensating for the shortage in function of single software and avoiding the problems as large computation, complex calculation,major error,low efficiency and so on.