List of Examples

2-1 Simple Example: Inserting, Indexing, and Querying Spatial Data

2-2 SQL Statement to Insert a Rectangle

2-3 SQL Statement to Insert a Polygon with a Hole

2-4 SQL Statement to Insert a Compound Line String

2-5 SQL Statement to Insert a Compound Polygon

2-6 SQL Statement to Insert a Point-Only Geometry

2-7 Query for Point-Only Geometry Based on a Coordinate Value

2-8 SQL Statement to Insert a Geometry with a Type 0 Element

3-1 Control File for Bulk Load of Cola Market Geometries

3-2 Control File for Bulk Load of Polygons

3-3 Control File for a Bulk Load of Point-Only Data

3-4 Procedure to Perform Transactional Insert Operation

3-5 PL/SQL Block Invoking Procedure to Insert a Geometry

4-1 Creating a Fixed Index

4-2 Primary Filter with a Temporary Query Window

4-3 Primary Filter with a Transient Instance of the Query Window

4-4 Primary Filter with a Stored Query Window

4-5 Secondary Filter Using a Temporary Query Window

4-6 Secondary Filter Using a Stored Query Window

5-1 Creating a User-Defined Projected Coordinate System

5-2 Creating a User-Defined Geodetic Coordinate System

5-3 Simplified Example of Coordinate System Transformation

5-4 Output of SELECT Statements in Coordinate System Transformation Example

6-1 Including LRS Measure Dimension in Spatial Metadata

6-2 Simplified Example: Highway

6-3 Simplified Example: Output of SELECT Statements

B-1 Creating a Hybrid Index