目录
第一章 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
评论0