Skip Headers
Oracle® Spatial User's Guide and Reference
10g Release 2 (10.2)

Part Number B14255-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

List of Examples

2-1 Simple Example: Inserting, Indexing, and Querying Spatial Data
2-2 SDO_GEOMETRY Methods
2-3 SDO_GEOMETRY Constructors to Create Geometries
2-4 SQL Statement to Insert a Rectangle
2-5 SQL Statement to Insert a Polygon with a Hole
2-6 SQL Statement to Insert a Compound Line String
2-7 SQL Statement to Insert a Compound Polygon
2-8 SQL Statement to Insert a Point-Only Geometry
2-9 Query for Point-Only Geometry Based on a Coordinate Value
2-10 SQL Statement to Insert an Oriented Point Geometry
2-11 SQL Statement to Insert a Geometry with a Type 0 Element
2-12 SQL Statements to Insert Various Geometries
3-1 Control File for a Bulk Load of Cola Market Geometries
3-2 Control File for a Bulk Load of Polygons
3-3 Control File for a Bulk Load of Point-Only Data
3-4 Procedure to Perform a Transactional Insert Operation
3-5 PL/SQL Block Invoking a Procedure to Insert a Geometry
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
5-1 Geocoding, Returning Address Object and Specific Attributes
5-2 Geocoding from a Place Name and Country
5-3 Geocoding from a Place Name, Country, and Other Fields
6-1 Using a Geodetic MBR
6-2 Creating a User-Defined Geodetic Coordinate Reference System
6-3 Inserting a Row into the SDO_COORD_SYS Table
6-4 Creating a User-Defined Projected Coordinate Reference System
6-5 Inserting a Row into the SDO_COORD_OPS Table
6-6 Inserting a Row into the SDO_COORD_OP_PARAM_VALS Table
6-7 Simplified Example of Coordinate System Transformation
6-8 Output of SELECT Statements in Coordinate System Transformation Example
7-1 Including LRS Measure Dimension in Spatial Metadata
7-2 Simplified Example: Highway
7-3 Simplified Example: Output of SELECT Statements
C-1 Route Request with Specified Addresses
C-2 Route Response with Specified Addresses
C-3 Route Request with Specified Longitude/Latitude Points
C-4 Route Response with Specified Longitude/Latitude Points
C-5 Route Request with Previously Geocoded Locations
C-6 Route Response with Previously Geocoded Locations
C-7 Batch Route Request with Specified Addresses
C-8 Batch Route Response with Specified Addresses
C-9 Batch Route Request with Previously Geocoded Locations
C-10 Batch Route Response with Previously Geocoded Locations
D-1 Finding All Cities Within a Distance of a Highway
D-2 Finding All Highways Within a Distance of a City
D-3 Finding the Cities Nearest to a Highway
D-4 Finding the Cities Above a Specified Population Nearest to a Highway
D-5 Performing Aggregate Union of All Counties in Texas