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 an Oriented Multipoint Geometry
• 2-12 SQL Statement to Insert a Geometry with a Type 0 Element
• 2-13 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