List of Examples
- 1-1 Inserting Texture Coordinate Definitions
- 1-2 Creating Tables for Texture Coordinates, Textures, and Surfaces
- 1-3 JSON Support in Spatial and Graph
- 1-4 GeoJSON Support in Spatial and Graph
- 1-5 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
- 8-1 Location Tracking Server Workflow
- 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
- 14-21 Speed Limit Request (Single Location)
- 14-22 Speed Limit Request (Multiple Locatons)
- 14-23 Traffic Speed Request (Single Location)
- 14-24 Traffic Speed Request (Multiple Locatons)
- 14-25 Request Parsing Error
- 14-26 Missing Location ID
- 14-27 Other Location Input Errors
- 14-28 Missing Edge
- 14-29 Multiple Errors in Batch Response
- 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
- 18-14 GetCapabilities Request
- 18-15 DescribeRecord Request
- 18-16 DescribeRecord Response
- 18-17 GetRecords Request with PropertyIsEqualTo and PropertyIsLike
- 18-18 GetRecords Response with PropertyIsEqualTo and PropertyIsLike
- 18-19 GetRecords Request with PropertyIsLike
- 18-20 GetRecords Response with PropertyIsLike
- 18-21 GetRecords Request with PropertyIsGreaterThan
- 18-22 GetRecords Response with PropertyIsGreaterThan
- 18-23 GetRecords Request with BoundingBox (BBOX)
- 18-24 GetRecords Response with BoundingBox (BBOX)
- B-1 Finding All Cities Within a Distance of a Highway
- B-2 Finding All Highways Within a Distance of a City
- B-3 Finding the Cities Nearest to a Highway
- B-4 Finding the Cities Above a Specified Population Nearest to a Highway
- D-1 Partitioning a Small Data Set
- D-2 Partitioning a Full Data Set
- D-3 Dumping the Contents of a Partition (VERBOSE = FALSE)
- D-4 Dumping the Contents of a Partition (VERBOSE = TRUE)
- D-5 Validating the Contents of Partitions (VERBOSE = FALSE)
- D-6 Validating the Contents of Partitions (VERBOSE = TRUE)
- D-7 Querying the Routing Data Version
- D-8 Rebuilding the Turn Restriction User Data
- D-9 Dumping All Hard Turn Restriction User Data BLOBs
- D-10 Rebuilding the Trucking User Data
- D-11 Dumping the Trucking User Data Restrictions
- D-12 Rebuilding the Time Zone User Data
- D-13 Dumping All Time Zone User Data BLOBs
- E-1 GetCapabilities Request
- E-2 GetCapabilities Response
- E-3 DescribeRecord Request
- E-4 DescribeRecord Response
- E-5 GetRecords Request
- E-6 GetRecords Response
- E-7 GetDomain Request
- E-8 GetDomain Response
- E-9 GetRecordById Request
- E-10 GetRecordById Response
- E-11 Insert Request
- E-12 Insert Response
- E-13 Update Request
- E-14 Update Response
- E-15 Delete Request
- E-16 Delete Response