Skip Headers
Oracle® Spatial User's Guide and Reference
10
g
Release 2 (10.2)
Part Number B14255-01
Home
Book List
Contents
Index
Master Index
Feedback
Previous
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