目录
第一章 ST_Geometry 与配置 .......................................................................................................... 4
1.1 简介 ........................................................................................................................... 4
1.2 基于 Oracle 的 ST_Geometry 的配置 ..................................................................... 5
1.2.1 Oracle 监听配置 .............................................................................................. 5
1.2.1.1 Windows 环境的配置............................................................................... 5
1.2.1.2 Linux 环境的配置 .................................................................................... 6
1.2.1.3 Unix 环境的配置 ...................................................................................... 7
1.2.2 OracleTNS 配置 ................................................................................................ 9
1.3 Oracle 的 ST_Geometry 权限及数据库 .................................................................. 9
1.3.1 检查 ST 定义 ..................................................................................................... 9
1.3.2 检查 st_shapelib 对象定义 ......................................................................... 10
第二章 ST_Geometry 存储结构 .................................................................................................... 11
2.1 存储结构 ................................................................................................................. 11
2.2 操作函数 ................................................................................................................. 12
2.3 构造 ST_Geometry 对象 ........................................................................................ 12
2.4 用户权限限制 ......................................................................................................... 13
第三章 创建 ST_Geometry 要素类 ............................................................................................... 14
3.1 使用 SDE 创建要素类 ........................................................................................... 14
3.2 直接使用 SQL 语句创建要素类。 ....................................................................... 14
3.2.1 连接权限设置 ................................................................................................. 14
首先使用 ......................................................................................................................... 14
3.2.2 SQL 语句创建 ST_Geometry ........................................................................... 14
3.2.3 使用 sdelayer 命令 ....................................................................................... 15
3.2.4 SQL 直接操纵 FeatureClass ......................................................................... 17
3.2.4.1 数据的插入，删除，更新 ............................................................. 17
3.2.4.2 查询 ................................................................................................. 18
3.2.4.3 创建索引 ......................................................................................... 19
3.2.4.4 创建空间参考系 ............................................................................. 19
3.2.4.5 Wkt 和 Wkb ............................................................................................ 20
第四章 SQL 函数介绍 .................................................................................................................... 28
4.1 执行空间判断 ......................................................................................................... 28
4.1.1 ST_Contains ................................................................................................... 28
4.1.2 ST_Crosses ..................................................................................................... 29
4.1.3 ST_Disjoint ................................................................................................... 30
4.1.4 ST_Equals ....................................................................................................... 31
4.1.5 ST_Intersects ............................................................................................... 31
4.1.6 ST_Overlaps ................................................................................................... 32
4.1.7 ST_Touches ..................................................................................................... 33
4.1.8 ST_Within ....................................................................................................... 34
4.2 空间分析函数： ..................................................................................................... 35
4.2.1 ST_Buffer 缓冲区分析 .................................................................................. 35
4.2.2 ConvexHull ..................................................................................................... 35
4.2.3 ST_Difference ............................................................................................... 36
5星 · 超过95%的资源 需积分: 49 46 浏览量
2019-10-03
23:16:30
上传
评论 1
收藏 1.43MB PDF 举报 
马克love2023-07-29文件的排版简洁明了，让人阅读起来很舒服，值得推荐给对ST_Geometry感兴趣的人阅读。
zh2223332023-07-29对于那些对GIS有一定了解的人来说，这份文件提供了进一步深入学习ST_Geometry的详细指导。
柏傅美2023-07-29它清晰地解释了ST_Geometry的基本概念和应用场景，对于初学者来说很有帮助。
XiZi2023-07-29这个文件提供了大量的示例代码，让读者能够更好地理解和应用ST_Geometry。
优游的鱼2023-07-29这份文件系统地介绍了ST_Geometry的各个方面，对于初学者来说非常友好。
