Oracle Spatial的资料

博客首页 » Oracle Spatial的资料

发布于 08 Jun 2014 03:35
标签 blog
关于Oracle Spatial相关完整的资料,找到下面这几个。
Oracle 用户指南和参考手册
Oracle Spatial空间信息管理

Oracle 用户指南和参考手册

http://docs.oracle.com/cd/B19306_01/appdev.102/b14255.pdf
http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/toc.htm

章节列表如下:
Part I Conceptual and Usage Information

1 Spatial Concepts

1.1 What Is Oracle Spatial?
1.2 Object-Relational Model
1.3 Introduction to Spatial Data
1.4 Geometry Types
1.5 Data Model
1.5.1 Element
1.5.2 Geometry
1.5.3 Layer
1.5.4 Coordinate System
1.5.5 Tolerance
1.5.5.1 Tolerance in the Geometry Metadata for a Layer
1.5.5.2 Tolerance as an Input Parameter
1.6 Query Model
1.7 Indexing of Spatial Data
1.7.1 R-Tree Indexing
1.7.2 R-Tree Quality
1.8 Spatial Relationships and Filtering
1.9 Spatial Operators, Procedures, and Functions
1.10 Spatial Aggregate Functions
1.10.1 SDOAGGRTYPE Object Type
1.11 Geocoding
1.12 Spatial Java Application Programming Interface
1.13 MDDATA Schema
1.14 Performance and Tuning Information
1.15 Open Geospatial Consortium (OGC) Conformance
1.16 Spatial Release (Version) Number
1.17 Spatial Application Hardware Requirement Considerations
1.18 Spatial Error Messages
1.19 Spatial Examples
1.20 README File for Spatial and Related Features
2 Spatial Data Types and Metadata

2.1 Simple Example: Inserting, Indexing, and Querying Spatial Data
2.2 SDO_GEOMETRY Object Type
2.2.1 SDO_GTYPE
2.2.2 SDO_SRID
2.2.3 SDO_POINT
2.2.4 SDO_ELEM_INFO
2.2.5 SDO_ORDINATES
2.2.6 Usage Considerations
2.3 SDO_GEOMETRY Methods
2.4 SDO_GEOMETRY Constructors
2.5 Geometry Examples
2.5.1 Rectangle
2.5.2 Polygon with a Hole
2.5.3 Compound Line String
2.5.4 Compound Polygon
2.5.5 Point
2.5.6 Oriented Point
2.5.7 Type 0 (Zero) Element
2.5.8 Several Geometry Types
2.6 Geometry Metadata Views
2.6.1 TABLE_NAME
2.6.2 COLUMN_NAME
2.6.3 DIMINFO
2.6.4 SRID
2.7 Spatial Index-Related Structures
2.7.1 Spatial Index Views
2.7.1.1 xxx_SDO_INDEX_INFO Views
2.7.1.2 xxx_SDO_INDEX_METADATA Views
2.7.2 Spatial Index Table Definition
2.7.3 R-Tree Index Sequence Object
2.8 Unit of Measurement Support
3 Loading Spatial Data

3.1 Bulk Loading
3.1.1 Bulk Loading SDO_GEOMETRY Objects
3.1.2 Bulk Loading Point-Only Data in SDO_GEOMETRY Objects
3.2 Transactional Insert Operations Using SQL
4 Indexing and Querying Spatial Data

4.1 Creating a Spatial Index
4.1.1 Indexing Geodetic Data
4.1.2 Constraining Data to a Geometry Type
4.1.3 Creating a Cross-Schema Index
4.1.4 Using Partitioned Spatial Indexes
4.1.5 Exchanging Partitions Including Indexes
4.1.6 Export and Import Considerations with Spatial Indexes and Data
4.1.7 Distributed Transactions and Spatial Index Consistency
4.2 Querying Spatial Data
4.2.1 Spatial Query
4.2.1.1 Primary Filter Operator
4.2.1.2 Primary and Secondary Filter Operator
4.2.1.3 Within-Distance Operator
4.2.1.4 Nearest Neighbor Operator
4.2.1.5 Spatial Functions
4.2.2 Spatial Join
4.2.3 Cross-Schema Operator Invocation
5 Geocoding Address Data

5.1 Concepts for Geocoding
5.1.1 Address Representation
5.1.2 Match Modes
5.1.3 Match Codes
5.1.4 Error Messages for Output Geocoded Addresses
5.2 Data Types for Geocoding
5.2.1 SDO_GEO_ADDR Type
5.2.2 SDO_ADDR_ARRAY Type
5.2.3 SDO_KEYWORDARRAY Type
5.3 Using the Geocoding Capabilities
5.4 Geocoding from a Place Name
5.5 Data Structures for Geocoding
5.5.1 GC_AREA_<suffix> Table
5.5.2 GC_COUNTRY_PROFILE Table
5.5.3 GC_INTERSECTION_<suffix> Table
5.5.4 GC_POI_<suffix> Table
5.5.5 GC_POSTAL_CODE_<suffix> Table
5.5.6 GC_ROAD_<suffix> Table
5.5.7 GC_ROAD_SEGMENT_<suffix> Table
6 Coordinate Systems (Spatial Reference Systems)

6.1 Terms and Concepts
6.1.1 Coordinate System (Spatial Reference System)
6.1.2 Cartesian Coordinates
6.1.3 Geodetic Coordinates (Geographic Coordinates)
6.1.4 Projected Coordinates
6.1.5 Local Coordinates
6.1.6 Geodetic Datum
6.1.7 Transformation
6.2 Geodetic Coordinate Support
6.2.1 Geodesy and Two-Dimensional Geometry
6.2.2 Choosing a Geodetic or Projected Coordinate System
6.2.3 Geodetic MBRs
6.2.4 Other Considerations and Requirements with Geodetic Data
6.3 Local Coordinate Support
6.4 EPSG Model and Spatial
6.5 TFM_PLAN Object Type
6.6 Coordinate Systems Data Structures
6.6.1 SDO_COORD_AXES Table
6.6.2 SDO_COORD_AXIS_NAMES Table
6.6.3 SDO_COORD_OP_METHODS Table
6.6.4 SDO_COORD_OP_PARAM_USE Table
6.6.5 SDO_COORD_OP_PARAM_VALS Table
6.6.6 SDO_COORD_OP_PARAMS Table
6.6.7 SDO_COORD_OP_PATHS Table
6.6.8 SDO_COORD_OPS Table
6.6.9 SDO_COORD_REF_SYS Table
6.6.10 SDO_COORD_REF_SYSTEM View
6.6.11 SDO_COORD_SYS Table
6.6.12 SDO_CRS_COMPOUND View
6.6.13 SDO_CRS_ENGINEERING View
6.6.14 SDO_CRS_GEOCENTRIC View
6.6.15 SDO_CRS_GEOGRAPHIC2D View
6.6.16 SDO_CRS_GEOGRAPHIC3D View
6.6.17 SDO_CRS_PROJECTED View
6.6.18 SDO_CRS_VERTICAL View
6.6.19 SDO_DATUM_ENGINEERING View
6.6.20 SDO_DATUM_GEODETIC View
6.6.21 SDO_DATUM_VERTICAL View
6.6.22 SDO_DATUMS Table
6.6.23 SDO_ELLIPSOIDS Table
6.6.24 SDO_PREFERRED_OPS_SYSTEM Table
6.6.25 SDO_PREFERRED_OPS_USER Table
6.6.26 SDO_PRIME_MERIDIANS Table
6.6.27 SDO_UNITS_OF_MEASURE Table
6.7 Legacy Tables and Views
6.7.1 MDSYS.CS_SRS Table
6.7.1.1 Well-Known Text (WKT)
6.7.1.2 Procedures for Updating the Well-Known Text
6.7.2 MDSYS.SDO_ANGLE_UNITS View
6.7.3 MDSYS.SDO_AREA_UNITS View
6.7.4 MDSYS.SDO_DATUMS_OLD_FORMAT and SDO_DATUMS_OLD_SNAPSHOT Tables
6.7.5 MDSYS.SDO_DIST_UNITS View
6.7.6 MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT and SDO_ELLIPSOIDS_OLD_SNAPSHOT Tables
6.7.7 MDSYS.SDO_PROJECTIONS_OLD_FORMAT and SDO_PROJECTIONS_OLD_SNAPSHOT Tables
6.8 Creating a User-Defined Coordinate Reference System
6.8.1 Creating a Geodetic CRS
6.8.2 Creating a Projected CRS
6.9 Notes and Restrictions with Coordinate Systems Support
6.9.1 Different Coordinate Systems for Geometries with Operators and Functions
6.9.2 3D LRS Functions Not Supported with Geodetic Data
6.9.3 Functions Supported by Approximations with Geodetic Data
6.9.4 Unknown CRS and NaC Coordinate Reference Systems
6.10 U.S. National Grid Support
6.11 Example of Coordinate System Transformation
7 Linear Referencing System

7.1 Terms and Concepts
7.1.1 Geometric Segments (LRS Segments)
7.1.2 Shape Points
7.1.3 Direction of a Geometric Segment
7.1.4 Measure (Linear Measure)
7.1.5 Offset
7.1.6 Measure Populating
7.1.7 Measure Range of a Geometric Segment
7.1.8 Projection
7.1.9 LRS Point
7.1.10 Linear Features
7.1.11 Measures with Multiline Strings and Polygons with Holes
7.2 LRS Data Model
7.3 Indexing of LRS Data
7.4 3D Formats of LRS Functions
7.5 LRS Operations
7.5.1 Defining a Geometric Segment
7.5.2 Redefining a Geometric Segment
7.5.3 Clipping a Geometric Segment
7.5.4 Splitting a Geometric Segment
7.5.5 Concatenating Geometric Segments
7.5.6 Scaling a Geometric Segment
7.5.7 Offsetting a Geometric Segment
7.5.8 Locating a Point on a Geometric Segment
7.5.9 Projecting a Point onto a Geometric Segment
7.5.10 Converting LRS Geometries
7.6 Tolerance Values with LRS Functions
7.7 Example of LRS Functions
8 Spatial Analysis and Mining

8.1 Spatial Information and Data Mining Applications
8.2 Spatial Binning for Detection of Regional Patterns
8.3 Materializing Spatial Correlation
8.4 Colocation Mining
8.5 Spatial Clustering
8.6 Location Prospecting
9 Extending Spatial Indexing Capabilities

9.1 SDO_GEOMETRY Objects in User-Defined Type Definitions
9.2 SDO_GEOMETRY Objects in Function-Based Indexes
9.2.1 Example: Function with Standard Types
9.2.2 Example: Function with a User-Defined Object Type
Part II Reference Information

10 SQL Statements for Indexing Spatial Data

ALTER INDEX
ALTER INDEX REBUILD
ALTER INDEX RENAME TO
CREATE INDEX
DROP INDEX
11 Spatial Operators

SDO_ANYINTERACT
SDO_CONTAINS
SDO_COVEREDBY
SDO_COVERS
SDO_EQUAL
SDO_FILTER
SDO_INSIDE
SDO_JOIN
SDO_NN
SDO_NN_DISTANCE
SDO_ON
SDO_OVERLAPBDYDISJOINT
SDO_OVERLAPBDYINTERSECT
SDO_OVERLAPS
SDO_RELATE
SDO_TOUCH
SDO_WITHIN_DISTANCE
12 Spatial Aggregate Functions

SDO_AGGR_CENTROID
SDO_AGGR_CONCAT_LINES
SDO_AGGR_CONVEXHULL
SDO_AGGR_LRS_CONCAT
SDO_AGGR_MBR
SDO_AGGR_UNION
13 SDO_CS Package (Coordinate System Transformation)

SDO_CS.ADD_PREFERENCE_FOR_OP
SDO_CS.CONVERT_NADCON_TO_XML
SDO_CS.CONVERT_NTV2_TO_XML
SDO_CS.CONVERT_XML_TO_NADCON
SDO_CS.CONVERT_XML_TO_NTV2
SDO_CS.CREATE_CONCATENATED_OP
SDO_CS.CREATE_OBVIOUS_EPSG_RULES
SDO_CS.CREATE_PREF_CONCATENATED_OP
SDO_CS.DELETE_ALL_EPSG_RULES
SDO_CS.DELETE_OP
SDO_CS.DETERMINE_CHAIN
SDO_CS.DETERMINE_DEFAULT_CHAIN
SDO_CS.FIND_GEOG_CRS
SDO_CS.FIND_PROJ_CRS
SDO_CS.FROM_OGC_SIMPLEFEATURE_SRS
SDO_CS.FROM_USNG
SDO_CS.MAP_EPSG_SRID_TO_ORACLE
SDO_CS.MAP_ORACLE_SRID_TO_EPSG
SDO_CS.REVOKE_PREFERENCE_FOR_OP
SDO_CS.TO_OGC_SIMPLEFEATURE_SRS
SDO_CS.TO_USNG
SDO_CS.TRANSFORM
SDO_CS.TRANSFORM_LAYER
SDO_CS.UPDATE_WKTS_FOR_ALL_EPSG_CRS
SDO_CS.UPDATE_WKTS_FOR_EPSG_CRS
SDO_CS.UPDATE_WKTS_FOR_EPSG_DATUM
SDO_CS.UPDATE_WKTS_FOR_EPSG_ELLIPS
SDO_CS.UPDATE_WKTS_FOR_EPSG_OP
SDO_CS.UPDATE_WKTS_FOR_EPSG_PARAM
SDO_CS.UPDATE_WKTS_FOR_EPSG_PM
SDO_CS.VALIDATE_WKT
SDO_CS.VIEWPORT_TRANSFORM
14 SDO_GCDR Package (Geocoding)

SDO_GCDR.GEOCODE
SDO_GCDR.GEOCODE_ADDR
SDO_GCDR.GEOCODE_ADDR_ALL
SDO_GCDR.GEOCODE_ALL
SDO_GCDR.GEOCODE_AS_GEOMETRY
SDO_GCDR.REVERSE_GEOCODE
15 SDO_GEOM Package (Geometry)

SDO_GEOM.RELATE
SDO_GEOM.SDO_ARC_DENSIFY
SDO_GEOM.SDO_AREA
SDO_GEOM.SDO_BUFFER
SDO_GEOM.SDO_CENTROID
SDO_GEOM.SDO_CONVEXHULL
SDO_GEOM.SDO_DIFFERENCE
SDO_GEOM.SDO_DISTANCE
SDO_GEOM.SDO_INTERSECTION
SDO_GEOM.SDO_LENGTH
SDO_GEOM.SDO_MAX_MBR_ORDINATE
SDO_GEOM.SDO_MBR
SDO_GEOM.SDO_MIN_MBR_ORDINATE
SDO_GEOM.SDO_POINTONSURFACE
SDO_GEOM.SDO_UNION
SDO_GEOM.SDO_XOR
SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT
SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT
SDO_GEOM.WITHIN_DISTANCE
16 SDO_LRS Package (Linear Referencing System)

SDO_LRS.CLIP_GEOM_SEGMENT
SDO_LRS.CONCATENATE_GEOM_SEGMENTS
SDO_LRS.CONNECTED_GEOM_SEGMENTS
SDO_LRS.CONVERT_TO_LRS_DIM_ARRAY
SDO_LRS.CONVERT_TO_LRS_GEOM
SDO_LRS.CONVERT_TO_LRS_LAYER
SDO_LRS.CONVERT_TO_STD_DIM_ARRAY
SDO_LRS.CONVERT_TO_STD_GEOM
SDO_LRS.CONVERT_TO_STD_LAYER
SDO_LRS.DEFINE_GEOM_SEGMENT
SDO_LRS.DYNAMIC_SEGMENT
SDO_LRS.FIND_LRS_DIM_POS
SDO_LRS.FIND_MEASURE
SDO_LRS.FIND_OFFSET
SDO_LRS.GEOM_SEGMENT_END_MEASURE
SDO_LRS.GEOM_SEGMENT_END_PT
SDO_LRS.GEOM_SEGMENT_LENGTH
SDO_LRS.GEOM_SEGMENT_START_MEASURE
SDO_LRS.GEOM_SEGMENT_START_PT
SDO_LRS.GET_MEASURE
SDO_LRS.GET_NEXT_SHAPE_PT
SDO_LRS.GET_NEXT_SHAPE_PT_MEASURE
SDO_LRS.GET_PREV_SHAPE_PT
SDO_LRS.GET_PREV_SHAPE_PT_MEASURE
SDO_LRS.IS_GEOM_SEGMENT_DEFINED
SDO_LRS.IS_MEASURE_DECREASING
SDO_LRS.IS_MEASURE_INCREASING
SDO_LRS.IS_SHAPE_PT_MEASURE
SDO_LRS.LOCATE_PT
SDO_LRS.LRS_INTERSECTION
SDO_LRS.MEASURE_RANGE
SDO_LRS.MEASURE_TO_PERCENTAGE
SDO_LRS.OFFSET_GEOM_SEGMENT
SDO_LRS.PERCENTAGE_TO_MEASURE
SDO_LRS.PROJECT_PT
SDO_LRS.REDEFINE_GEOM_SEGMENT
SDO_LRS.RESET_MEASURE
SDO_LRS.REVERSE_GEOMETRY
SDO_LRS.REVERSE_MEASURE
SDO_LRS.SET_PT_MEASURE
SDO_LRS.SPLIT_GEOM_SEGMENT
SDO_LRS.TRANSLATE_MEASURE
SDO_LRS.VALID_GEOM_SEGMENT
SDO_LRS.VALID_LRS_PT
SDO_LRS.VALID_MEASURE
SDO_LRS.VALIDATE_LRS_GEOMETRY
17 SDO_MIGRATE Package (Upgrading)

SDO_MIGRATE.TO_CURRENT
18 SDO_SAM Package (Spatial Analysis and Mining)

SDO_SAM.AGGREGATES_FOR_GEOMETRY
SDO_SAM.AGGREGATES_FOR_LAYER
SDO_SAM.BIN_GEOMETRY
SDO_SAM.BIN_LAYER
SDO_SAM.COLOCATED_REFERENCE_FEATURES
SDO_SAM.SIMPLIFY_GEOMETRY
SDO_SAM.SIMPLIFY_LAYER
SDO_SAM.SPATIAL_CLUSTERS
SDO_SAM.TILED_AGGREGATES
SDO_SAM.TILED_BINS
19 SDO_TUNE Package (Tuning)

SDO_TUNE.AVERAGE_MBR
SDO_TUNE.ESTIMATE_RTREE_INDEX_SIZE
SDO_TUNE.EXTENT_OF
SDO_TUNE.MIX_INFO
SDO_TUNE.QUALITY_DEGRADATION
20 SDO_UTIL Package (Utility)

SDO_UTIL.APPEND
SDO_UTIL.CIRCLE_POLYGON
SDO_UTIL.CONCAT_LINES
SDO_UTIL.CONVERT_UNIT
SDO_UTIL.ELLIPSE_POLYGON
SDO_UTIL.EXTRACT
SDO_UTIL.FROM_WKBGEOMETRY
SDO_UTIL.FROM_WKTGEOMETRY
SDO_UTIL.GETNUMELEM
SDO_UTIL.GETNUMVERTICES
SDO_UTIL.GETVERTICES
SDO_UTIL.INITIALIZE_INDEXES_FOR_TTS
SDO_UTIL.POINT_AT_BEARING
SDO_UTIL.POLYGONTOLINE
SDO_UTIL.PREPARE_FOR_TTS
SDO_UTIL.RECTIFY_GEOMETRY
SDO_UTIL.REMOVE_DUPLICATE_VERTICES
SDO_UTIL.REVERSE_LINESTRING
SDO_UTIL.SIMPLIFY
SDO_UTIL.TO_GMLGEOMETRY
SDO_UTIL.TO_WKBGEOMETRY
SDO_UTIL.TO_WKTGEOMETRY
SDO_UTIL.VALIDATE_WKBGEOMETRY
SDO_UTIL.VALIDATE_WKTGEOMETRY
Part III Supplementary Information

A Installation, Compatibility, and Upgrade

A.1 Upgrading LRS Data
A.2 Ensuring That GeoRaster Works Properly After an Upgrade
B Oracle Locator

C Routing Engine

C.1 Deploying and Configuring the Routing Engine
C.2 Routing Engine XML API
C.2.1 Route Request and Response Examples
C.2.2 Route Request DTD
C.2.2.1 route_request Element
C.2.2.2 route_request Attributes
C.2.2.3 input_location Element
C.2.2.4 pre_geocoded_location Element
C.2.2.5 longitude_latitude_location Element
C.2.3 Route Response DTD
C.2.4 Batch Route Request and Response Examples
C.2.5 Batch Route Request DTD
C.2.5.1 batch_route_request Element
C.2.5.2 batch_route_request Attributes
C.2.6 Batch Route Response DTD
C.2.7 Geocoding Request and Response DTDs
C.2.7.1 Geocoding Request DTD
C.2.7.2 Geocoding Response DTD
C.3 Data Structures Used by the Routing Engine
C.3.1 EDGE Table
C.3.2 NODE Table
C.3.3 PARTITION Table
C.3.4 SIGN_POST Table
D Complex Spatial Queries: Examples

D.1 Tables Used in the Examples
D.2 SDO_WITHIN_DISTANCE Examples
D.3 SDO_NN Examples
D.4 SDO_AGGR_UNION Example

Oracle Spatial空间信息管理

管会生 刘刚 安宁 樊红译

本书是世界级Oracle Spatial专家Ravi Kothuri、Albert Godfrind和Euro Beinat的力作,旨在向您提供空间信息管理方面的概念知识和实用技能,帮助您成为该领域的专家。书中涵盖了Oracle数据库中空间信息管理的所有内容。主要阐述了空间信息管理的主要概念,Oracle Spatial的架构,以及大量用于管理空间数据的函数和操作。详细描述了Oracle Spatial所提供的用于存储、检索、分析和可视化空间信息的工具。本书还提供了丰富的样本数据、例子和提示,以帮助读者方便地将上述概念和工具结合到实际应用中。全书结构合理清晰,内容全面丰富,示例贴近实际,适用于所有DBA和应用系统开发人员。

在 51CTO上可阅读章节如下:
http://book.51cto.com/art/200910/157414.htm

前言与目录
Oracle Spatial空间信息管理 前言
Oracle Spatial空间信息管理 目录
译者序
Oracle Spatial空间信息管理 译者序
第4章 SDO_GEOMETRY数据类型
4.1.1 点
4.1.2 线串
4.1.3 多边形和面
4.1.4 立方体
4.1.5 集合
4.1.6 SDO_GEOMETRY的逻辑实现
4.1.7 SQL/MM 和OGC上的空间数据
4.2 SDO_GEOMETRY类型、属性和值
4.2.1 SDO_GTYPE属性
4.2.2 SDO_SRID属性(1)
4.2.2 SDO_SRID属性(2)
4.2.2 SDO_SRID属性(3)
4.2.2 SDO_SRID属性(4)
4.2.3 SDO_POINT属性
4.2.4 SDO_ELEM_INFO和SDO_ORDINATES
4.3.1 点
4.3.2 通过直线连接的线串
4.3.3 通过弧连接的线串
4.3.4 多边形:边界通过直线连接的环
4.3.5 多边形:边界通过弧连接的环
4.3.6 矩形
4.3.7 圆
4.4.1 构建复杂几何体
4.4.2 复合元素的SDO_ELEM_INFO
4.4.3 带void多边形元素的SDO_ELEM_IN
4.4.4 复合线串的例子
4.4.5 复合多边形的例子
4.4.6 带void的多边形
4.4.7 集合(1)
4.4.7 集合(2)
4.5 三维几何体的例子
4.5.1 三维的点、线串和多边形(1)
4.5.1 三维的点、线串和多边形(2)
4.5.2 复合面
4.5.3 简单立方体(1)
4.5.3 简单立方体(2)
4.5.4 复合立方体
4.5.5 集合
4.6 本章小结
第7章 在应用程序中操作SDO_GEOMETRY
7.1 用PL/SQL操作几何体
7.1.1 VARRAY操作入门(1)
7.1.1 VARRAY操作入门(2)
7.1.2 SDO_GEOMETRY对象的读写
7.1.3 创建新的几何体
7.1.4 从几何体中提取信息
7.1.5 修改已有的几何体
7.2 在Java中操作几何体
7.2.1 使用JGeometry类(1)
7.2.1 使用JGeometry类(2)
7.2.2 使用3D几何体:J3D_Geometry类
7.2.3 从3D几何体中提取元素:Element
7.2.3 从3D几何体中提取元素:Element
7.2.4 使用标准的格式:WKT、WKB和GML
7.2.4 使用标准的格式:WKT、WKB和GML
7.2.5 使用ESRI shapefile(1)
7.2.5 使用ESRI shapefile(2)
7.3 本章小结
第9章 几何处理函数
第9章 几何处理函数
9.1 缓冲函数
9.2.1 SDO_DISTANCE
9.2.2 SDO_CLOSEST_POINTS
9.2.3 RELATE(1)
9.2.3 RELATE(2)
9.3 几何组合函数
9.3.1 SDO_INTERSECTION
9.3.2 SDO_UNION
9.3.3 SDO_DIFFERENCE
9.3.4 SDO_XOR
9.4.1 面积、长度和体积函数(1)
9.4.1 面积、长度和体积函数(2)
9.4.2 MBR 函数
9.4.3 各种几何分析函数(1)
9.4.3 各种几何分析函数(2)
9.5.1 聚合MBR函数
9.5.2 其他聚合函数(1)
9.5.2 其他聚合函数(2)
9.6 本章小结
第13章
13.1 MapViewer的APIs概述
13.1.1 XML、Java、JSPs和PL/SQL
13.1.2 JavaScript和Ajax:Oracle地图
13.1.3 选择API
13.2.1 什么(what):应当展示在地图上
13.2.2 哪里(where):地图覆盖的地理
13.2.3 怎样做(how):生成地图的格式
13.3.1 控制的详细程度:放大和缩小
13.3.2 控制地图上显示的区域:平移和
13.3.3 特性的选择:识别
13.3.4 选择要在地图上显示的信息:层
13.4 Oracle地图:JavaScript API
13.4.1 显示地图
13.4.2 与地图交互:缩放和平移
13.4.3 添加地图修饰
13.4.4 添加通用修饰
13.4.5 创建概况地图
13.4.6 矩形(选取框)缩放
13.4.7 添加动态信息:基于主题的FOI
13.4.7 添加动态信息:基于主题的FOI
13.4.8 添加个体FOI
13.4.9 控制样式
13.4.10 捕获用户输入:工具和选择器
13.4.11 事件响应
13.5 使用Java API
13.5.1 地图请求(1)
13.5.1 地图请求(2)
13.5.2 缩放和平移
13.5.3 主题控制(1)
13.5.3 主题控制(2)
13.5.4 样式控制
13.5.5 识别和查询
13.5.6 动态特性
13.5.7 图例
13.5.8 地图修饰
13.5.9 使用地图缓存
13.5.10 发现数据源、地图、主题
13.5.11 使用JSP标签(1)
13.5.11 使用JSP标签(2)
13.6 使用XML API
13.6.1 简单的地图请求
13.6.2 为底图添加主题
13.6.3 使用多个数据源
13.6.4 从主题构建地图
13.6.5 动态主题
13.6.6 动态特性
13.6.7 图例
13.6.8 XML地图响应
13.7.1 安装API
13.7.2 一个简单的示例
13.8.1 浏览地图定义
13.8.2 管理MapViewer服务器
13.8.3 重启MapViewer
13.9.1 GetCapabilities请求
13.9.2 GetMap请求
13.9.3 GetFeatureInfo请求
13.9.4 空间参照系统(SRS)映射
13.10 本章小结
第16章
16.1 提示
16.1.1 数据建模和数据装载
16.1.2 空间查询操作符的性能(1)
16.1.2 空间查询操作符的性能(2)
16.1.3 其他空间处理函数的性能
16.1.4 插入、删除、更新的性能
16.1.5 关于空间索引扩展性和可操纵性
16.1.5 关于空间索引扩展性和可操纵性
16.1.5 关于空间索引扩展性和可操纵性
16.2.1 测量数据的范围、经纬度和容差
16.2.2 SDO_GEOMETRY的NULL值
16.2.3 使用GEOCODE或GEOCODE_ALL
16.2.4 在CREATE INDEX中指定"INDEXTY
16.2.5 始终在WHERE子句中使用空间操
16.2.6 没有有效的空间索引时请使用空
16.2.7 不要移动、导入或者复制MDRT表
6.2.8 网络元数据
16.2.9 地图元数据
16.3.1 ORA-13226: 没有空间索引接口
16.3.2 ORA-13203:读取USER_SDO_GEOM
16.3.3 ORA-13365: 层的SRID与几何体
16.3.4 ORA-13223:SDO_GEOM_METADATA
16.3.5 ORA-13249,ORA-02289:不能撤
16.3.6 ORA-13249:sdo_index_metadata
16.3.7 ORA-13207: 不正确地使用
16.3.8 ORA-13000: 维数超出范围
16.3.9 ORA-00904:…无效的标识符
16.3.10 ORA-00939: 函数参数过多
16.3.11 层维数与几何体维数不符
16.4 本章小结


本页面的文字允许在知识共享 署名-相同方式共享 3.0协议和GNU自由文档许可证下修改和再使用,仅有一个特殊要求,请用链接方式注明文章引用出处及作者。请协助维护作者合法权益。


系列文章

文章列表

  • Oracle Spatial的资料

这篇文章对你有帮助吗,投个票吧?

rating: 0+x

留下你的评论

Add a New Comment
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License