List of Examples

• 1-1 Inserting Texture Coordinate Definitions
• 1-2 Creating Tables for Texture Coordinates, Textures, and Surfaces
• 1-3 GeoJSON Support in Spatial and Graph
• 1-4 Spatially Enabling a Table
• 2-1 Example: Inserting, Indexing, and Querying Spatial Data
• 2-2 SDO_GEOMETRY Methods
• 2-3 SDO_GEOMETRY Constructors to Create Geometries
• 2-4 SDO_TIN Attribute in a Query
• 2-5 SDO_PC Attribute in a Query
• 2-6 SQL Statement to Insert a Rectangle
• 2-7 SQL Statement to Insert a Polygon with a Hole
• 2-8 SQL Statement to Insert a Compound Line String
• 2-9 SQL Statement to Insert a Compound Polygon
• 2-10 SQL Statement to Insert a Point-Only Geometry
• 2-11 Query for Point-Only Geometry Based on a Coordinate Value
• 2-12 SQL Statement to Insert an Oriented Point Geometry
• 2-13 SQL Statement to Insert an Oriented Multipoint Geometry
• 2-14 SQL Statement to Insert a Geometry with a Type 0 Element
• 2-15 SQL Statement to Insert a NURBS Curve Geometry
• 2-16 SQL Statement to Insert a NURBS Compound Curve Geometry
• 2-17 SQL Statements to Insert Various Two-Dimensional Geometries
• 2-18 SQL Statements to Insert Three-Dimensional Geometries
• 2-19 Updating Metadata and Creating Indexes for 3-Dimensional Geometries
• 2-20 Creating and Using a User-Defined Unit of Measurement
• 3-1 Using the ST_GEOMETRY Type for a Spatial Column
• 3-2 Creating, Indexing, Storing, and Querying ST_GEOMETRY Data
• 3-3 Using the ST_ANNOTATION_TEXT Constructor
• 4-1 Control File for a Bulk Load of Cola Market Geometries
• 4-2 Control File for a Bulk Load of Polygons
• 4-3 Control File for a Bulk Load of Point-Only Data
• 4-4 Procedure to Perform a Transactional Insert Operation
• 4-5 PL/SQL Block Invoking a Procedure to Insert a Geometry
• 5-1 SDO_NN Query with Partitioned Spatial Index
• 5-2 Primary Filter with a Temporary Query Window
• 5-3 Primary Filter with a Transient Instance of the Query Window
• 5-4 Primary Filter with a Stored Query Window
• 5-5 Secondary Filter Using a Temporary Query Window
• 5-6 Secondary Filter Using a Stored Query Window
• 6-1 Using a Geodetic MBR
• 6-2 Three-Dimensional Datum Transformation
• 6-3 Transformation Between Geoidal And Ellipsoidal Height
• 6-4 Cross-Dimensionality Transformation
• 6-5 Creating a User-Defined Geodetic Coordinate Reference System
• 6-6 Inserting a Row into the SDO_COORD_SYS Table
• 6-7 Creating a User-Defined Projected Coordinate Reference System
• 6-8 Inserting a Row into the SDO_COORD_OPS Table
• 6-9 Inserting a Row into the SDO_COORD_OP_PARAM_VALS Table
• 6-10 Creating a User-Defined Projected CRS: Extended Example
• 6-11 Creating a Vertical Coordinate Reference System
• 6-12 Creating a Compound Coordinate Reference System
• 6-13 Creating a Geographic 3D Coordinate Reference System
• 6-14 Creating a Transformation Operation
• 6-15 Loading Offset Matrixes
• 6-16 Using British Grid Transformation OSTN02/OSGM02 (EPSG Method 9633)
• 6-17 Simplified Example of Coordinate System Transformation
• 6-18 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
• 12-1 Geocoding, Returning Address Object and Specific Attributes
• 12-2 Geocoding from a Place Name and Country
• 12-3 Geocoding from a Place Name, Country, and Other Fields
• 12-4 XML Definition for the US Address Format
• 12-5 Required Indexes on Tables for Geocoding
• 12-6 <database> Element Definition
• 12-7 Geocoding Request (XML API)
• 12-8 Geocoding Response (XML API)
• 14-1 Route Request with Specified Addresses
• 14-2 Response for Route Request with Specified Addresses
• 14-3 Route Request with Locations Specified as Longitude/Latitude Points
• 14-4 Response for Route Request with Locations Specified as Longitude/Latitude Points
• 14-5 Batched Route Request with Locations Specified as Addresses, Pre-geocoded Locations, and Longitude/Latitude Points
• 14-6 Response for Batched Route Request with Locations Specified as Addresses, Pre-geocoded Locations, and Longitude/Latitude Points
• 14-7 Route Request with Route Preference as Traffic
• 14-8 Response for Route Request with Route Preference as Traffic
• 14-9 Route Request with Route Preference as Traffic and with Specified Start Date and Time
• 14-10 Response for Route Request with Route Preference as Traffic and with Specified Start Date and Time
• 14-11 Route Request with Route Preference as Traffic and with Specified Start Date and Time (Non-Default Format)
• 14-12 Response for Route Request with Route Preference as Traffic and with Specified Start Date and Time (Non-Default Format)
• 14-13 Route Request with Route Preference for Shortest Path and Incorporating Time (return_route_time as true)
• 14-14 Response for Route Request with Route Preference for Shortest Path and Incorporating Time (return_route_time as true)
• 14-15 Multistop Route Request with Traffic Preference, Default Date and Time Formats, and Specified Time Format
• 14-16 Response for Multistop Route Request with Traffic Preference, Default Date and Time Formats, and Specified Time Format
• 14-17 Batch Route Request with Specified Addresses
• 14-18 Batch Route Response with Specified Addresses
• 14-19 Batch Route Request with Previously Geocoded Locations
• 14-20 Batch Route Response with Previously Geocoded Locations
• 15-1 OpenLS Geocoding Request
• 15-2 OpenLS Geocoding Response
• 15-3 OpenLS Mapping Request
• 15-4 OpenLS Mapping Response
• 15-5 OpenLS Routing Request
• 15-6 OpenLS Routing Response
• 15-7 OpenLS Directory Service (YP) Request
• 15-8 OpenLS Directory Service (YP) Response
• 16-1 GetCapabilities Request (WFS)
• 16-2 GetCapabilities Response (WFS)
• 16-3 DescribeFeatureType Request (WFS)
• 16-4 DescribeFeatureType Response (WFS)
• 16-5 GetFeature Request (WFS)
• 16-6 GetFeature Response (WFS)
• 16-7 GetFeatureWithLock Request (WFS)
• 16-8 GetFeatureWithLock Response (WFS)
• 16-9 LockFeature Request (WFS)
• 16-10 LockFeature Response (WFS)
• 16-11 Insert Request (WFS)
• 16-12 Insert Response (WFS)
• 16-13 Update Request (WFS)
• 16-14 Update Response (WFS)
• 16-15 Delete Request (WFS)
• 16-16 Delete Response (WFS)
• 18-1 GetCapabilities Request
• 18-2 DescribeRecord Request
• 18-3 DescribeRecord Response
• 18-4 GetRecords Request with PropertyIsEqualTo and PropertyIsLike
• 18-5 GetRecords Response with PropertyIsEqualTo and PropertyIsLike
• 18-6 GetRecords Request with PropertyIsLike
• 18-7 GetRecords Response with PropertyIsLike
• 18-8 GetRecords Request with PropertyIsGreaterThan
• 18-9 GetRecords Response with PropertyIsGreaterThan
• 18-10 GetRecords Request with BoundingBox (BBOX)
• 18-11 GetRecords Response with BoundingBox (BBOX)
• 18-12 GetRecordById Request
• 18-13 GetRecordById Response
• C-1 Finding All Cities Within a Distance of a Highway
• C-2 Finding All Highways Within a Distance of a City
• C-3 Finding the Cities Nearest to a Highway
• C-4 Finding the Cities Above a Specified Population Nearest to a Highway
• E-1 Partitioning a Small Data Set
• E-2 Partitioning a Full Data Set
• E-3 Dumping the Contents of a Partition (VERBOSE = FALSE)
• E-4 Dumping the Contents of a Partition (VERBOSE = TRUE)
• E-5 Validating the Contents of Partitions (VERBOSE = FALSE)
• E-6 Validating the Contents of Partitions (VERBOSE = TRUE)
• E-7 Querying the Routing Data Version
• E-8 Rebuilding the Turn Restriction User Data
• E-9 Dumping All Hard Turn Restriction User Data BLOBs
• E-10 Rebuilding the Trucking User Data
• E-11 Dumping the Trucking User Data Restrictions
• E-12 Rebuilding the Time Zone User Data
• E-13 Dumping All Time Zone User Data BLOBs
• F-1 GetCapabilities Request
• F-2 GetCapabilities Response
• F-3 DescribeRecord Request
• F-4 DescribeRecord Response
• F-5 GetRecords Request
• F-6 GetRecords Response
• F-7 GetDomain Request
• F-8 GetDomain Response
• F-9 GetRecordById Request
• F-10 GetRecordById Response
• F-11 Insert Request
• F-12 Insert Response
• F-13 Update Request
• F-14 Update Response
• F-15 Delete Request
• F-16 Delete Response