Oracle Spatial 10g Release 2用户手册与开发指南

需积分: 25 17 浏览量更新于2024-07-23 收藏 7.86MB PDF 举报

Oracle Spatial 用户指南和参考是针对GIS专业人员的必备学习资料，它专注于10g Release 2 (10.2)版本，即B14255-01，发布于2005年6月。该文档详尽介绍了如何在Oracle Spatial和Oracle Locator平台上管理和索引空间数据，以及如何开发相关的空间应用。Oracle Spatial是Oracle数据库系统的一部分，它提供了强大的地理信息系统功能，支持地理数据的存储、分析和操作。该指南的主要作者是Chuck Murray，其内容由多位贡献者共同编撰，包括Dan Abugov、Nicole Alexander等，如Bruce Blackwell、Janet Blowney等人也参与了编写工作。这些文档不仅包含了软件本身，还包括相应的技术文档，它们都受到严格的版权保护，根据许可证协议提供，限制了使用和披露，并受专利法、知识产权法等法律保护。文档中的信息着重于以下几点： 1. **空间数据管理**：介绍如何有效地创建、维护和优化空间索引，以便提高查询性能，尤其是在大规模地理数据集上。 2. **空间数据存储**：探讨了如何在Oracle数据库中存储不同类型的地理坐标数据（如点、线、面），以及如何处理空间数据的几何类型和精度。 3. **GIS函数和操作**：提供了对诸如ST_Equals、ST_Contains、ST_Intersects等空间关系运算符的深入讲解，以及如何使用SQL和PL/SQL语法进行空间查询和分析。 4. **Oracle Locator**：阐述了如何利用Oracle Locator服务进行地理位置编码（Geocoding）和反编码（Reverse Geocoding），以及地理编码服务的使用方法。 5. **空间应用程序开发**：涵盖了如何设计和实现基于Oracle Spatial的应用程序，包括Web应用程序和桌面应用，以及如何与其他非Oracle系统集成。 6. **许可和法律注意事项**：强调了使用Oracle Spatial软件时必须遵守的条款，包括禁止未经许可的逆向工程、拆解或反编译程序的行为，除非法律另有规定。 Oracle Spatial 用户指南和参考是GIS开发者和数据库管理员的重要参考资料，它不仅指导用户了解空间数据的处理和管理，还帮助他们开发出高效且符合法规要求的空间应用程序。通过深入学习和实践，读者可以充分利用Oracle Spatial的功能，提升地理信息系统的性能和价值。

xvi

List of Figures

1–1 Geometric Types ......................................................................................................................... 1-4

1–2 Query Model................................................................................................................................ 1-8

1–3 MBR Enclosing a Geometry....................................................................................................... 1-9

1–4 R-Tree Hierarchical Index on MBRs...................................................................................... 1-10

1–5 The Nine-Intersection Model ................................................................................................. 1-11

1–6 Topological Relationships....................................................................................................... 1-12

1–7 Distance Buffers for Points, Lines, and Polygons................................................................ 1-13

1–8 Tolerance in an Aggregate Union Operation....................................................................... 1-15

2–1 Areas of Interest for the Simple Example................................................................................ 2-2

2–2 Rectangle ................................................................................................................................... 2-15

2–3 Polygon with a Hole................................................................................................................ 2-16

2–4 Compound Line String............................................................................................................ 2-18

2–5 Compound Polygon ................................................................................................................ 2-19

2–6 Point-Only Geometry .............................................................................................................. 2-20

2–7 Oriented Point Geometry........................................................................................................ 2-22

2–8 Geometry with Type 0 (Zero) Element................................................................................. 2-24

4–1 Geometries with MBRs .............................................................................................................. 4-7

4–2 Layer with a Query Window .................................................................................................... 4-7

7–1 Geometric Segment..................................................................................................................... 7-2

7–2 Describing a Point Along a Segment with a Measure and an Offset .................................. 7-3

7–3 Measures, Distances, and Their Mapping Relationship........................................................ 7-4

7–4 Measure Populating of a Geometric Segment ........................................................................ 7-4

7–5 Measure Populating with Disproportional Assigned Measures ......................................... 7-4

7–6 Linear Feature, Geometric Segments, and LRS Points.......................................................... 7-5

7–7 Creating a Geometric Segment ................................................................................................. 7-6

7–8 Defining a Geometric Segment ................................................................................................. 7-8

7–9 Redefining a Geometric Segment ............................................................................................. 7-9

7–10 Clipping, Splitting, and Concatenating Geometric Segments.............................................. 7-9

7–11 Measure Assignment in Geometric Segment Operations.................................................. 7-10

7–12 Segment Direction with Concatenation................................................................................ 7-11

7–13 Scaling a Geometric Segment................................................................................................. 7-11

7–14 Offsetting a Geometric Segment............................................................................................ 7-12

7–15 Locating a Point Along a Segment with a Measure and an Offset................................... 7-12

7–16 Ambiguity in Location Referencing with Offsets................................................................ 7-13

7–17 Multiple Projection Points ...................................................................................................... 7-13

7–18 Conversion from Standard to LRS Line String.................................................................... 7-14

7–19 Segment for Clip Operation Affected by Tolerance............................................................ 7-15

7–20 Simplified LRS Example: Highway....................................................................................... 7-16

8–1 Spatial Mining and Oracle Data Mining.................................................................................. 8-2

15–1 Arc Tolerance............................................................................................................................ 15-7

15–2 SDO_GEOM.SDO_DIFFERENCE ....................................................................................... 15-18

15–3 SDO_GEOM.SDO_INTERSECTION .................................................................................. 15-22

15–4 SDO_GEOM.SDO_UNION.................................................................................................. 15-34

15–5 SDO_GEOM.SDO_XOR........................................................................................................ 15-36

16–1 Translating a Geometric Segment ....................................................................................... 16-76

20–1 Simplification of a Geometry ............................................................................................... 20-32

C–1 Basic Flow of Action with the Spatial Routing Engine......................................................... C-1

xvii

List of Tables

2–1 Valid SDO_GTYPE Values ....................................................................................................... 2-6

2–2 Values and Semantics in SDO_ELEM_INFO......................................................................... 2-9

2–3 SDO_GEOMETRY Methods.................................................................................................. 2-11

2–4 Columns in the xxx_SDO_INDEX_INFO Views................................................................ 2-31

2–5 Columns in the xxx_SDO_INDEX_METADATA Views .................................................. 2-32

2–6 Columns in an R-Tree Spatial Index Data Table ................................................................ 2-34

2–7 Columns in the SDO_DIST_UNITS Table........................................................................... 2-35

2–8 Columns in the SDO_AREA_UNITS Table......................................................................... 2-35

5–1 Attributes for Formal Address Representation..................................................................... 5-1

5–2 Match Modes for Geocoding Operations ............................................................................... 5-2

5–3 Match Codes for Geocoding Operations ................................................................................ 5-3

5–4 Geocoded Address Error Message Interpretation ................................................................ 5-4

5–5 SDO_GEO_ADDR Type Attributes......................................................................................... 5-5

5–6 GC_AREA_<suffix> Table..................................................................................................... 5-10

5–7 GC_COUNTRY_PROFILE Table.......................................................................................... 5-11

5–8 GC_INTERSECTION_<suffix> Table .................................................................................. 5-13

5–9 GC_POI_<suffix> Table......................................................................................................... 5-14

5–10 GC_POSTAL_CODE_<suffix> Table................................................................................... 5-15

5–11 GC_ROAD_<suffix> Table.................................................................................................... 5-16

5–12 GC_ROAD_SEGMENT_<suffix> Table .............................................................................. 5-18

6–1 SDO_COORD_AXES Table ...................................................................................................... 6-9

6–2 SDO_COORD_AXIS_NAMES Table ...................................................................................... 6-9

6–3 SDO_COORD_OP_METHODS Table..................................................................................... 6-9

6–4 SDO_COORD_OP_PARAM_USE Table............................................................................. 6-10

6–5 SDO_COORD_OP_PARAM_VALS Table .......................................................................... 6-10

6–6 SDO_COORD_OP_PARAMS Table..................................................................................... 6-11

6–7 SDO_COORD_OP_PATHS Table......................................................................................... 6-11

6–8 SDO_COORD_OPS Table...................................................................................................... 6-12

6–9 SDO_COORD_REF_SYS Table ............................................................................................. 6-13

6–10 SDO_COORD_SYS Table....................................................................................................... 6-15

6–11 SDO_CRS_COMPOUND View ............................................................................................ 6-15

6–12 SDO_CRS_ENGINEERING View ........................................................................................ 6-16

6–13 SDO_CRS_GEOCENTRIC View........................................................................................... 6-16

6–14 SDO_CRS_GEOGRAPHIC2D View..................................................................................... 6-17

6–15 SDO_CRS_GEOGRAPHIC3D View..................................................................................... 6-17

6–16 SDO_CRS_PROJECTED View .............................................................................................. 6-18

6–17 SDO_CRS_VERTICAL View................................................................................................. 6-19

6–18 SDO_DATUM_ENGINEERING View ................................................................................ 6-19

6–19 SDO_DATUM_GEODETIC View ........................................................................................ 6-20

6–20 SDO_DATUM_VERTICAL View......................................................................................... 6-20

6–21 SDO_DATUMS Table............................................................................................................. 6-21

6–22 SDO_ELLIPSOIDS Table ....................................................................................................... 6-22

6–23 SDO_PREFERRED_OPS_SYSTEM Table............................................................................ 6-23

6–24 SDO_PREFERRED_OPS_USER Table ................................................................................. 6-24

6–25 SDO_PRIME_MERIDIANS Table ........................................................................................ 6-24

6–26 SDO_UNITS_OF_MEASURE Table..................................................................................... 6-24

6–27 MDSYS.CS_SRS Table ............................................................................................................ 6-26

6–28 MDSYS.SDO_ANGLE_UNITS Table................................................................................... 6-29

6–29 MDSYS.SDO_DATUMS_OLD_FORMAT and SDO_DATUMS_OLD_SNAPSHOT Tables..

6-30

6–30 MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT and SDO_ELLIPSOIDS_OLD_SNAPSHOT

Tables 6-32

6–31 MDSYS.SDO_PROJECTIONS_OLD_FORMAT and SDO_PROJECTIONS_OLD_

xviii

SNAPSHOT Tables 6-33

7–1 Highway Features and LRS Counterparts .......................................................................... 7-16

10–1 Spatial Index Creation and Usage Statements.................................................................... 10-1

11–1 Main Spatial Operators .......................................................................................................... 11-1

11–2 Convenience Operators for SDO_RELATE Operations.................................................... 11-1

11–3 params Keywords for the SDO_JOIN Operator............................................................... 11-14

11–4 Keywords for the SDO_NN Param Parameter................................................................. 11-16

12–1 Spatial Aggregate Functions ................................................................................................. 12-1

13–1 Subprograms for Coordinate System Transformation ...................................................... 13-1

13–2 Table to Hold Transformed Layer...................................................................................... 13-39

14–1 Subprograms for Geocoding Address Data........................................................................ 14-1

15–1 Geometry Subprograms......................................................................................................... 15-1

16–1 Subprograms for Creating and Editing Geometric Segments.......................................... 16-1

16–2 Subprograms for Querying and Validating Geometric Segments................................... 16-2

16–3 Subprograms for Converting Geometric Segments........................................................... 16-3

18–1 Subprograms for Spatial Analysis and Mining .................................................................. 18-1

19–1 Tuning Subprograms.............................................................................................................. 19-1

20–1 Spatial Utility Subprograms.................................................................................................. 20-1

B–1 Spatial Features Supported for Locator................................................................................. B-2

B–2 Spatial Features Not Supported for Locator ......................................................................... B-2

B–3 Feature Availability with Standard and Enterprise Editions............................................. B-3

C–1 EDGE Table.............................................................................................................................. C-18

C–2 NODE Table............................................................................................................................. C-19

C–3 PARTITION Table .................................................................................................................. C-19

C–4 SIGN_POST Table................................................................................................................... C-19

剩余591页未读，继续阅读

lh789741753

粉丝: 3
资源: 17

Oracle Spatial 10g Release 2用户手册与开发指南

ORACLE SPATIAL 用户指南和参考.pdf

Oracle Spatial用户指南

oracle spatial 用户指南

Oracle Spatial用户指南与参考文献

Oracle Spatial用户指南与参考手册

Oracle Spatial 9.2 用户指南与参考手册

Oracle Spatial 8.1.7 用户指南与参考手册

oracle spatial的官方指南

Oracle Spatial9i用户手册

Oracle Spatial 9.2用户指南与参考：地理信息处理关键技术

最新资源