List of Examples

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

3-1 Control File for a Bulk Load

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

3-3 Procedure to Perform Transactional Insert Operation

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

3-5 Creating a Fixed Index

3-6 Creating a Hybrid Index

4-1 Primary Filter with a Temporary Query Window

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

4-3 Primary Filter with a Stored Query Window

4-4 Secondary Filter Using a Temporary Query Window

4-5 Secondary Filter Using a Stored Query Window

13-1 Raw Data Format

13-2 Control File to Load Data into the Geometry Table

13-3 Raw Data Format

13-4 Control File to Load from a Single Flat File

13-5 Transactional Insert

13-6 Transactional Insert for a Large Geometry

15-1 Populate an Index

15-2 Populate an Index with Fixed-Size Tiles

15-3 Populate an Index with Fixed-Size Tiles Based on Point Data

15-4 Update an Index

15-5 Update an Index with Fixed-Size Tiles

15-6 Verify a Layer

16-1 Recommended Tile Level for One-Degree Latitude/Longitude Cells

16-2 Recommended Tile Level Based on the GIDs of All Geometries

16-3 Recommended Tile Level Based on Average Extent of All Geometries

A-1 View Fixed-Size Tiles for All Geometries

A-2 View Variable-Sized Tiles for All Geometries

A-3 View Fixed-Size Tiles for One Geometry

A-4 View Variable-Sized Tiles for One Geometry

A-5 View Fixed-Sized Tiles for All Geometries Using the Relational Model

A-6 View Fixed-Size Tiles for a Specific Geometry Using the Relational Model

B-1 Insert Trigger for Metadata Consistency

D-1 Simplified Example of Coordinate Systems

D-2 Output of SELECT Statements in Coordinate Systems Example

E-1 Including LRS Measure Dimension in Spatial Metadata

E-2 Simplified Example: Highway

E-3 Simplified Example: Output of SELECT Statements