基于PostGIS的线要素空间聚合方法  

Polyline Spatial Aggregation Method Based on PostGIS

作　　者：梅新[1] 王文荟 钟少波 宋敦江 梅白帆 MEI Xin;WANG Wenhui;ZHONG Shaobo;SONG Dunjiang;MEI Baifan(Faculty of Resources and Environmental Science,Hubei University,Wuhan 430062,China;Beijing Urban System Engineering Research Center,Beijing 100102,China;Institutes of Science and Development,Chinese Academy of Sciences,Beijing 100190,China;Jiangsu Electric Power Information Technology Co.,Ltd.,Nanjing 210000,China)

机构地区：[1]湖北大学资源环境学院,武汉430062 [2]北京城市系统工程研究中心,北京100102 [3]中国科学院科技战略咨询研究院,北京100190 [4]江苏电力信息科技有限公司,南京210000

出　　处：《计算机工程》2021年第5期308-315,共8页Computer Engineering

基　　金：国家自然科学基金(41471338);北京市科技计划课题(Z191100001419002);中国科学院科技战略咨询研究院项目“大数据环境下的可视化宏观决策支持平台”。

摘　　要：针对当前常规方法线空间流量数据聚合效率低的问题,提出基于PostGIS的流空间线要素聚合方法。通过离散化所有的线为点集,建立点集的空间索引,计算点集的唯一点集,对唯一点集上的每个点累加所有与该点重叠的属性值并进行更新,根据点的序列号和上一步更新的属性值,重新连接该条线上所有的点,在属性值变化处进行打断形成新的线要素。在此基础上,去除空间重叠的线要素和图形为空的线要素得到最后的线聚合结果。实验结果表明,该方法以矢量数据形式输出的线聚合结果正确,提取速度显著提升,有效地解决了大量矢量线数据融合时常规方法效率低下的问题。To address the low efficiency of the existing methods for polyline spatial flow data aggregation,this paper proposes a method for polyline aggregation based on PostGIS.All polylines are discretized into a point set,for which a spatial index is established and the unique point set is calculated.For each point on the unique point set,all the attribute values of the points that overlap with the point are accumulated and updated.According to the sequence number of the point and the updated attribute value,all points on the line are reconnected.The line breaks where the attribute value changes to form a new polyline feature.Finally,all the spatially overlapping polyline features and the line features with empty graphics are removed to obtain the ultimate polyline aggregation result.The experimental results show that the polyline aggregation result output by this method in the form of vector data is correct,and the extraction speed is significantly improved,which effectively solves the low efficiency of the conventional methods for massive vector line data fusion.

关 键 词：线要素 空间流量 空间聚合 聚合效率 PostGIS平台 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]