Spatial topological relation join methods based on ArcSDE

doi:10.3778/j.issn.1002-8331.2010.05.035

Computer Engineering and Applications ›› 2010, Vol. 46 ›› Issue (5): 117-119.DOI: 10.3778/j.issn.1002-8331.2010.05.035

• 数据库、信号与信息处理 • Previous Articles Next Articles

Spatial topological relation join methods based on ArcSDE

WEN Yuan-qiao¹，ZHOU Chun-hui²

1.Navigation College，Wuhan University of Technology，Wuhan 430063，China
2.State Key Lab of Information Engineering in Surveying，Mapping and Remote Sensing，Wuhan University，Wuhan 430079，China

Received:2009-09-16 Revised:2009-12-08 Online:2010-02-11 Published:2010-02-11
Contact: WEN Yuan-qiao

基于ArcSDE的空间拓扑关系连接方法研究

文元桥¹，周春辉²

1.武汉理工大学航运学院，武汉 430063
2.武汉大学测绘遥感信息工程国家重点实验室，武汉 430079

通讯作者: 文元桥

Abstract

Abstract: This paper introduces the standard topological relation model，and analyses the characteristics of the spatial topological relation join.According to the spatial query technique and the topological predicates supported by ArcSDE，three methods are proposed for implementing topological join with ArcSDE，including Spatial Constraints Query Topological Join（SCQTJ），Predicates Nested Loop Topological Join（PNLTJ），and Filter-Refining 2 Phases Topological Join（FR2PTJ）.Finally the three methods are tested by experiments，and the PNLTJ method shows the best performance.

Key words: topological relation, spatial join, ArcSDE, optimal method

摘要： 简要介绍了标准的拓扑关系模型，分析了空间拓扑关系连接的特点。根据ArcSDE提供的空间查询技术和拓扑关系谓词，提出了在ArcSDE平台下实现拓扑连接的三种方法，包括基于空间约束查询的拓扑连接方法（SCQTJ）、基于谓词的嵌套循环拓扑连接方法（PNLTJ）和过滤精化两阶段拓扑连接方法（FR2PTJ）。最后通过试验对三种方法进行检验，试验结果表明PNLTJ方法具有最优的性能。

关键词: 拓扑关系, 空间连接, ArcSDE, 优化方法

CLC Number:

P208

WEN Yuan-qiao¹，ZHOU Chun-hui². Spatial topological relation join methods based on ArcSDE[J]. Computer Engineering and Applications, 2010, 46(5): 117-119.

文元桥¹，周春辉². 基于ArcSDE的空间拓扑关系连接方法研究[J]. 计算机工程与应用, 2010, 46(5): 117-119.

[1]	YAN Penggao, JIA Tao. Compact 2D Image Representation Method for Urban Road Networks [J]. Computer Engineering and Applications, 2021, 57(14): 194-200.
[2]	WU Liangran, LIN Jian, LIU Yizhi, LIU Min. Regional Cooperative Distribution Method Based on Vehicle Distribution Line [J]. Computer Engineering and Applications, 2020, 56(1): 244-250.
[3]	ZHANG Quangui, LI Fan, WANG Bingchao, WANG Xing. Method of three dimensional model retrieval based on Fuzzy topology and CRSC [J]. Computer Engineering and Applications, 2017, 53(7): 192-196.
[4]	HONG Yang1, QIAO Xiaojun2, BAI Xiaodong3. Stroke recognition of Chinese characters handwriting on mobile devices based on template matching [J]. Computer Engineering and Applications, 2017, 53(20): 105-110.
[5]	XIAO Qiuyong, LI Guangqiang. Comparative experimental analysis for capacities of spatial database [J]. Computer Engineering and Applications, 2014, 50(21): 139-142.
[6]	KONG Yueping1，2, YI Wei1, ZHANG Yuepeng2. Extracting saddle point fast based on topological relationship [J]. Computer Engineering and Applications, 2013, 49(16): 165-167.
[7]	KOU Weili1，2, GAN Shu1, WANG Dandan1. Title design and implementation of model for agricultural land grading based on ArcGIS Engine/ArcSDE [J]. Computer Engineering and Applications, 2012, 48(6): 238-242.
[8]	FENG Wenzhao, PENG Liqin, LI Wei, ZHANG Sumei. New approach for line（s） object buffer construction in GIS [J]. Computer Engineering and Applications, 2012, 48(17): 80-87.
[9]	ZOU Yonggui，XU Haibo，LIANG Xinfa，YANG Fuping. Optimal spatial join algorithm [J]. Computer Engineering and Applications, 2011, 47(12): 117-121.
[10]	DENG Min,XU Rui,LI Guang-qiang,ZHAO Wei. Integrated representation of region-region spatial relations in GIS [J]. Computer Engineering and Applications, 2009, 45(2): 39-43.
[11]	LI Song¹,HAO Zhong-xiao^1,2. Research methods about spatial relation reasoning [J]. Computer Engineering and Applications, 2009, 45(19): 17-21.
[12]	DU Li-ya,QIN An,FENG Qian-jin,CHEN Wu-fan. Elastic registration of medical images using Levenberg-Marquardt optimal method and B-splines function [J]. Computer Engineering and Applications, 2009, 45(14): 188-190.
[13]	HOU Rui. Constraint satisfaction reasoning with combining cardinal direction and topology relation [J]. Computer Engineering and Applications, 2008, 44(16): 63-65.
[14]	. Research on spatial data version management based on ArcSDE [J]. Computer Engineering and Applications, 2007, 43(14): 14-16.
[15]	. Quick Matching of Spatial Objects in Constructing [J]. Computer Engineering and Applications, 2007, 43(11): 43-44.

Spatial topological relation join methods based on ArcSDE

基于ArcSDE的空间拓扑关系连接方法研究

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics