Organization and Query of Point Clouds Data Based on SQL Server Spatial

被引：1

作者：

Chen, Yijin ^{[1
]}

Zhang, Huixia ^{[1
]}

Fu, Xiaoxue ^{[1
]}

机构：

[1] China Univ Min & Technol, Coll Geosci & Surveying Engn, Beijing, Beijing, Peoples R China

来源：

PROCEEDINGS OF 2010 3RD IEEE INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND INFORMATION TECHNOLOGY (ICCSIT 2010), VOL 7 | 2010年

关键词：

point cloudss data; SQL Server 2008 Spatial; index;

D O I：

10.1109/ICCSIT.2010.5564615

中图分类号：

TP301 [理论、方法];

学科分类号：

081202 ;

摘要：

Three-dimensional laser scanning produces a large number of point clouds data. In order to efficiently retrieve the point clouds data, this paper stores the point clouds data in SQL Server 2008, and create a spatial index. Using C # software and SQL Server 2008 Spatial technology to achieve the storage and inquiry of point clouds data, and the results of the inquiry is carried out visualization in the MapObjects component, preparing for the follow-up feature extraction. The test shows that the method greatly improves the efficiency of point clouds data retrieval.

引用

页码：178 / 181

页数：4

共 50 条

[21] Spatial data query based on natural language spatial relations
Du, SH
Qin, QM
Chen, DZ
Wang, L
IGARSS 2005: IEEE International Geoscience and Remote Sensing Symposium, Vols 1-8, Proceedings, 2005, : 1210 - 1213
[22] An approach for distributed organization and paralleled access of LiDAR point clouds data
Wang, Zongyue
Ma, Hongchao
Xu, Honggen
Wu, Jianwei
Wuhan Daxue Xuebao (Xinxi Kexue Ban)/ Geomatics and Information Science of Wuhan University, 2009, 34 (08): : 936 - 939
[23] Automatic Marking of SQL Server Based on SQL-DMO
Chen, Yaofei
Zheng, Wei
Chen, Huantong
SENSORS, MEASUREMENT AND INTELLIGENT MATERIALS, PTS 1-4, 2013, 303-306 : 2369 - +
[24] EXTENSIONS TO THE SQL QUERY LANGUAGE TO SUPPORT SPATIAL-ANALYSIS IN A TOPOLOGICAL DATA-BASE
HERRING, JR
LARSEN, RC
SHIVAKUMAR, J
GIS/LIS 88 PROCEEDINGS : ACCESSING THE WORLD, VOL 2, 1988, : 741 - 750
[25] Data Agnostic RoBERTa-based Natural Language to SQL Query Generation
Pal, Debaditya
Sharma, Harsh
Chaudhuri, Kaustubh
2021 6TH INTERNATIONAL CONFERENCE FOR CONVERGENCE IN TECHNOLOGY (I2CT), 2021,
[26] Building data warehouse and data mining with SQL Server 2000
Liu, Shuang-Ying
Zhang, Jing
Huabei Gongxueyuan Xuebao/Journal of North China Institute of Technology, 2004, 25 (05):
[27] Multiple Query Point Based Collective Spatial Keyword Querying
Li, Yun
Wang, Ziheng
Chen, Jing
Wang, Fei
Xu, Jiajie
ADVANCED DATA MINING AND APPLICATIONS, ADMA 2019, 2019, 11888 : 63 - 78
[28] Support of temporal data on the MS SQL Server and Azure SQL Database platform
Lachecinski, Sebastian
PRZEGLAD ELEKTROTECHNICZNY, 2020, 96 (12): : 95 - 101
[29] Data Asset by Query Processing In Client and Server
Prasanna, E.
Gunasekaran, G.
2016 INTERNATIONAL CONFERENCE ON INFORMATION COMMUNICATION AND EMBEDDED SYSTEMS (ICICES), 2016,
[30] A Point Clouds Fast Thinning Algorithm Based on Sample Point Spatial Neighborhood
Wei, Jiaxing
Xu, Maolin
Xiu, Hongling
JOURNAL OF INFORMATION PROCESSING SYSTEMS, 2020, 16 (03): : 688 - 698

← 1 2 3 4 5 →