Index

A

• algorithms
  • list / Useful algorithms
• alternate geometry type
  • implementing / Alternate geometry type implementation
• alternate representation
  • in different coordinate system / Alternate representation in a different coordinate system
• analytical applications, GeoRaster
  • about / Analytical applications for GeoRaster
  • DEM data, analyzing / Analyzing DEM data
  • land cover data, analyzing / Analyzing land cover data
  • cell space to model sapce, mapping / Mapping from cell space to model space
  • raster cells, converting to rectangles in model space / Converting raster cells to rectangles in model space
• Application Express (APEX)
  • about / Using SQL, Application Express, and Excel
  • using / Using SQL, Application Express, and Excel
• Application Programming Interfaces (API) / Choosing a geometry type hierarchy implementation
• applications
  • changes, logging automatically / Logging changes independently of applications
• archeological site
  • grid cells, creating over / Case 1 – creating grid cells over an archaeological site
• arc points
  • identifying / Identifying an arc point – ST_inCircularArc
• asynchronous trigger processing / Implementing spatial constraints in the database
• asynchronous triggers
  • about / Constraints with asynchronous triggers
• Automated Database Diagnostic Monitor (ADDM)
  • about / AWR reports
• available sourcing, Java spatial technologies
  • deegree / Sourcing available Java spatial technologies
  • GeoServer / Sourcing available Java spatial technologies
  • GeoTools / Sourcing available Java spatial technologies
  • JUMP / Sourcing available Java spatial technologies
  • uDig / Sourcing available Java spatial technologies
  • Java processing, requirements / Basic requirements for Java processing
• AWR
  • about / AWR reports
• AWR reports
  • about / AWR reports

B

• B-tree index
  • about / Coordinate system transformation techniques
• Binary (EWKB) / Modifying JASPA and JTS
• boundary
  • creating, parallel to existing / Right of carriageway alongside land parcel boundary
• BufferParameters class / Our first Java function – buffering a single geometry

C

• California State Plane Coordinate System / Storage cost for each coordinate
• California State Plane Zone 3 Coordinate System / Creating spatial metadata
  • about / ETL processing with GeoKettle
• centroid
  • calculating, of centroid / Calculating a linestring's centroid – ST_Centroid
• circular arcs
  • detecting / Detecting if circular arcs exist
• clustering
  • spatial autocorrelation, creating via / Creating spatial autocorrelation via clustering
• comma-separated values (CSV) / Using SQL, Application Express, and Excel
• compile_class method / Compilation to native code
• complex triggers
  • implementing / Implementing more complex triggers
• composite partitioning / Partitioning methods
• compound object
  • dimensionality / Dimensionality of compound objects
• compound subelement
  • counting / Counting compound subelements
• conflict resolution / Conflict resolution
• constraints
  • geometry subtype, implementing / Geometry subtype implementation via constraints
• constraints, asynchronous triggers
  • queue, creating / Creating a queue
  • trigger, defining / Defining the trigger
  • rule-based constraints, implementing / Implementing rule-based constraints
  • rules, defining for schema / Defining rules for the schema
  • triggers, for checking spatial relationships / Trigger for checking spatial relationships
  • data, batch processing / Batch processing existing data
• coordinate dimensions
  • adjusting / Adjusting coordinate dimensions
• coordinates
  • inserting / Inserting, modifying, and deleting coordinates
  • modifying / Inserting, modifying, and deleting coordinates
  • deleting / Inserting, modifying, and deleting coordinates
• coordinate system transformations, GeoRaster
  • about / Coordinating system transformations of GeoRaster
• coordinate system transformation techniques
  • about / Coordinate system transformation techniques
• cross-database SQL
  • constructing / Constructing cross-database SQL
• cross-platform representation
  • about / Cross-platform representation
  • SQL/MM ST_GEOMETRY type, outlining / Outlining the SQL/MM ST_GEOMETRY type
  • geometry objects, organizing / How are geometry objects internally organized?
  • storage, executing with singly inherited geometry type / Storage and function execution using a singly inherited geometry type
  • function, executing with singly inherited geometry type / Storage and function execution using a singly inherited geometry type
• CSV files
  • as external tables / CSV files as external tables
• custom object type
  • creating / Creating a custom object type

D

• 2D
  • 3D, reducing to / Reducing 3D to 2D – ST_To2D
• 3D
  • reducing, to 2D / Reducing 3D to 2D – ST_To2D
• data
  • batch processing / Batch processing existing data
  • replicating, with materialized views / Replicating data with materialized views
  • loading, into GeoRaster / Loading data into GeoRaster
• database
  • spatial constraints, implementing in / Implementing spatial constraints in the database
• database, streams based replication
  • setting up / Setting up the database
• Database Administrator (DBA) / Permissions
• database administrator (DBA) / Extract, transform, and load (ETL) tools
• database check constraints
  • using / Using database check constraints
• database independence
  • concepts / Is database independence possible?
• database replay
  • about / Database replay
  • workload processing / Database replay, Workload processing
  • workload replay / Database replay, Workload replay
  • analysis and reporting / Database replay, Analysis and reporting
  • workload capture / Workload capture
• database triggers
  • about / Using row-level and statement-level triggers
  • statement-level triggers / Using row-level and statement-level triggers
  • row-level triggers / Using row-level and statement-level triggers
• data definition language (DDL)
  • about / Streams based replication
• Data Definition Language (DDL) / Geometry type restriction using a subtype
• Data Manipulation Language (DML) / Background
• data manipulation language (DML)
  • about / Streams based replication
• data model
  • defining / Defining the data model
• data verification
  • after loading / Verification of data after the load
• DDL operations
  • on version-enabled tables / DDL operations on version-enabled tables
• default SDO_GEOMETRY function
  • including / Including default SDO_GEOMETRY functions
• DEM data
  • analyzing / Analyzing DEM data
• digital elevation model / Working with GeoRaster
• Digital Elevation Models (DEMs) / Working with GeoRaster
• Digital Terrain Models (DTMs) / Working with GeoRaster
• dimension, SDO_GEOMETRY
  • examining / Examining an SDO_GEOMETRY's dimensionality
  • first principles / First principles
• DML batch size / DML batch size

E

• EDS
  • enabling, for geometry tables / Enabling EDS for geometry tables
• entity-relationship (E-R) diagram / Defining the data model
• ETL processing
  • with GeoKettle / ETL processing with GeoKettle
• ETL tools
  • about / Extract, transform, and load (ETL) tools
  • GeoKettle / ETL processing with GeoKettle
  • Shapefile / Loading Shapefiles
  • Map Builder / Using Map Builder
• Excel
  • using / Using SQL, Application Express, and Excel
• Extended Well Known Text (EWKT) / Modifying JASPA and JTS
• external tables, CSV files / CSV files as external tables

F

• flashback database / Flashback queries
• flashback drop
  • about / Flashback queries, Flashback drop
• flashback queries
  • about / Flashback queries
  • flashback database / Flashback queries
  • flashback transaction / Flashback queries
  • flashback transaction query / Flashback queries
  • flashback table / Flashback queries, Flashback table
  • flashback drop / Flashback queries, Flashback drop
  • flashback versions query / Flashback queries, Flashback versions query
• flashback query
  • about / Flashback queries, Flashback query
• flashback table
  • about / Flashback queries, Flashback table
• flashback transaction / Flashback queries
• flashback transaction query / Flashback queries
• flashback version query
  • about / Flashback queries
• flashback versions query
  • about / Flashback versions query
• formats
  • exporting / Exporting formats – GML, WKT, and GeoJSON
• Frequently Asked Questions (FAQ) / Step 2 – noding linestrings
• functions
  • packaging / Packaging or encapsulation functions
  • calling / Calling the same processing in different ways
  • PL/SQL package, implementing / Implementing a PL/SQL package
  • user object type, implementing / Implementing user object types
  • custom object type, creating / Creating a custom object type
• functions, linear referencing
  • ST_Split / Linear referencing functions to be developed
  • ST_Snap / Linear referencing functions to be developed
  • ST_Find_Measure / Linear referencing functions to be developed
  • ST_Scale_Measures / Linear referencing functions to be developed
  • ST_Add_Measure / Linear referencing functions to be developed
  • ST_Start_Measure / Linear referencing functions to be developed
  • ST_End_Measure / Linear referencing functions to be developed
  • ST_Measure_Range / Linear referencing functions to be developed
  • ST_Is_Measure_Increasing / Linear referencing functions to be developed
  • ST_Is_Measure_Decreasing / Linear referencing functions to be developed
  • ST_Measure_To_Percentage / Linear referencing functions to be developed
  • ST_Percentage_To_Measure / Linear referencing functions to be developed
  • ST_Project_Point / Linear referencing functions to be developed
  • ST_Find_Offset / Linear referencing functions to be developed
  • ST_Locate_Measure / Linear referencing functions to be developed
  • ST_Locate_Point / Linear referencing functions to be developed
  • ST_Locate_Measures (no offset) / Linear referencing functions to be developed
  • ST_Locate_Measures (with offset) / Linear referencing functions to be developed
• functions, packaging
  • methods / Packaging summary
  • summary / Packaging summary

G

• GDAL
  • URL / Extract, transform, and load (ETL) tools
  • about / Extract, transform, and load (ETL) tools, Loading data into GeoRaster
  • used, for loading raster data / Using GDAL to load raster data
• gdalinfo command / Using GDAL to load raster data
• generalized representation
  • using / Using generalized representation
• GeoJSON format
  • generating / Generating a GeoJSON format
• GeoKettle
  • about / Extract, transform, and load (ETL) tools, ETL processing with GeoKettle
  • URL, for downloading / ETL processing with GeoKettle
• geometries
  • extracting, after intersection / Scenario 1 – Extracting geometries after intersection
  • vectorizing, with linestrings / Vectorizing geometries with linestrings
  • sorting / Sorting geometries
• geometries, extracting
  • ST_Extract function, implementing / Implementing the ST_Extract function
• geometries, sorting
  • ordering function, implementing / Implementing an ordering function
• geometries, vectorizing
  • ST_Vectorize function, implementing / Implementing vectorization – ST_Vectorize
• geometry
  • position, shifting / Example one – shifting a geometry's position
• Geometry buffer method / Converting SDO_GEOMETRY TO JTS Geometry
• geometry collection
  • processing / Processing a collection of geometries
  • types / Types of collections
  • lines, intersecting / Intersecting lines – a preliminary discussion
  • land parcel polygons, creating / Creating land parcels
• geometry objects
  • organizing, internally / How are geometry objects internally organized?
• geometry subelements
  • extracting / Scenario 4 – Extracting all geometry subelements as separate geometries
• geometry subelements, extracting
  • ST_ExplodeGeometry function, implementing / Fragmenting a geometry – ST_ExplodeGeometry
• geometry subtype
  • implementing, via constraints / Geometry subtype implementation via constraints
• geometry tables
  • EDS, enabling for / Enabling EDS for geometry tables
• geometry type
  • constraining / Constraining the geometry type
• geometry type hierarchy
  • about / Common geometry type hierarchy
  • diagram / Common geometry type hierarchy
  • implementation, choosing / Choosing a geometry type hierarchy implementation
• geometry type hierarchy implementation
  • JTS Topology Suite, choosing / Candidate 1 – the JTS Topology Suite
  • deegree’s geometry type / Candidate 2 – deegree
  • alternatives / Alternate candidates
  • selecting / Deciding between JTS Topology Suite and deegree
• geometry type implementation matrix
  • about / Geometry type implementation matrix
• geometry type restriction
  • subtype used / Geometry type restriction using a subtype
• geometry validation
  • about / Geometry validation and methods to clean imported data
• GeoRaptor / Creating a point at a known measure – ST_Locate_Measure
• GeoRaster
  • about / Working with GeoRaster
  • physical storage / GeoRaster physical storage
  • data, loading / Loading data into GeoRaster
  • working with / Working with GeoRaster
  • coordinate system transformations / Coordinating system transformations of GeoRaster
  • visualization applications / Visualization applications for GeoRaster
  • analytical applications / Analytical applications for GeoRaster
• georeferencing / Georeferencing
• GeoTools / Converting between SDO_GEOMETRY and Java geometry
• global index / Partitioning of spatial tables
• Global Positioning System (GPS) / Precision and accuracy
• GML / Exporting formats – GML, WKT, and GeoJSON
• GPS / Understanding linear referencing and measures
• graphical user interface (GUI)
  • about / Extract, transform, and load (ETL) tools
• grid cells
  • creating, over archeological site / Case 1 – creating grid cells over an archaeological site
• ground control point (GCP) / Georeferencing

H

• hash partitioning / Partitioning methods
• HatBox / Sourcing available Java spatial technologies
• heterogeneous data
  • managing / Managing homogeneous and heterogeneous data
• high performance loading, of spatial data
  • about / High performance loading
  • with staging table / Loading with a staging table
  • without staging table / Loading without a staging table
• homogeneous data
  • managing / Managing homogeneous and heterogeneous data

I

• imported data
  • cleaning, methods / Geometry validation and methods to clean imported data
• invalid data
  • fixing, triggers used / Fixing invalid data using triggers
• IS OF TYPE comparison operator
  • about / Understanding the IS OF TYPE comparison operator

J

• JASPA / Sourcing available Java spatial technologies, Modifying JASPA and JTS
• Java
  • features / Why Java and Oracle Spatial?
  • stored procedures / Java stored procedures are complementary rather than competitive
• Java based SQL processing performance
  • about / Performance of Java-based SQL processing
  • native code compilation / Compilation to native code
• Java processing, requirements
  • about / Basic requirements for Java processing
  • geometry type hierarchy / Common geometry type hierarchy
  • SDO_GEOMETRY and Java geometry conversion / Converting between SDO_GEOMETRY and Java geometry
  • existing spatial algorithms, sourcing / Sourcing existing spatial algorithms
• Java Shapefile loader / Java Shapefile loader
• Java Stored Procedures
  • about / Creating Java Stored Procedures
  • implementing / Our first Java function – buffering a single geometry
  • SDO_GEOMETRY, converting, to JTS Geometry / Converting SDO_GEOMETRY TO JTS Geometry
  • ST_Buffer, implementing / Implementing ST_Buffer
  • ST_Buffer, executing / Executing ST_Buffer
• Java Topology Suite / Extending a linestring
• Java Virtual Machine (JVM) / Why Java and Oracle Spatial?
• JSON
  • about / Generating a GeoJSON format
• JTS jar file
  • building / Compiling and building a JTS .jar file
  • compiling / Compiling and building a JTS .jar file
  • installing / Installing the JTS .jar file
  • installation checks / Checking the installation, Checking by trying to actually execute something
  • installation checks, by Java metadata tables querying / Checking by querying Oracle's Java metadata tables
• JTS source code
  • downloading / Downloading the JTS source code
  • modifying / Modifying JASPA and JTS
  • JTS jar file, compiling / Compiling and building a JTS .jar file
  • JTS jar file, building / Compiling and building a JTS .jar file
• JTS Topology Suite / Sourcing available Java spatial technologies, Candidate 1 – the JTS Topology Suite
• Just In Time (JIT) compilation / Compilation to native code

L

• lamp post metric
  • deriving / Deriving the lamp post metric
• land cover data
  • analyzing / Analyzing land cover data
• land parcel polygons
  • linestrings, noding / Step 2 – noding linestrings
  • building / Step 3 – build polygons
  • ST_Polygonizer, implementing / Implementing ST_Polygonizer
  • _polygon=Builder, implementing / Implementing _polygon=Builder
  • forming / Putting it all together – forming land parcel polygons
• land parcel polygons, creating
  • linestrings, extending / Step 1 – extending the linestrings
• Large Object (LOB) / Storage cost for Oracle Spatial tables, SecureFiles compression
• LAYER_GTYPE parameter / Layer GTYPE for point data
• licensed overlay functions
  • replacing / Java implementation
  • implementation, testing / Testing the implementation
• line
  • splitting, at point / Splitting a line at a point – ST_Split
  • point, snapping to / Snapping a point to a line – ST_Snap
• line-string geometries
  • querying / Querying ST_LINESTRING geometries
• linear referencing
  • about / Understanding linear referencing and measures
  • functions, developing / Linear referencing functions to be developed
• Linear Referencing System (LRS) / Understanding linear referencing and measures
• lines
  • moving, parallel to original object / Moving/shifting lines parallel to the original object
  • shifting, sideways / Shifting a line sideways – ST_LineShift
• linestring
  • extending / Extending a linestring
  • buffering / Buffering one side of a linestring – ST_OneSidedBuffer
  • measure, modifying / Modifying a linestring's measures
  • centroid, calculating / Calculating a linestring's centroid – ST_Centroid
• linestring directions
  • reversing / Reversing measures and linestring directions – ST_Reverse_Measures and ST_Reverse_Linestring
• linestring geometries
  • splitting / Splitting linestring geometries – ST_Split
• linestrings
  • geometries, vectorizing with / Vectorizing geometries with linestrings
  • PL/SQL functions / PL/SQL implementation
  • _nodeLinestrings, implementing / Implementing _nodeLinestrings
  • implementation, testing / Testing the implementation
• list partitioning / Partitioning methods
• local index / Partitioning of spatial tables
• logical change records (LCRs)
  • about / Streams based replication
• logical standby database
  • about / Physical and logical standby database, Logical standby
  • setting up / Setting up a logical standby database
  • skip rules / Skipping rules
  • working with / Working with logical standby
• LogMiner technology / Logical standby

M

• Map Builder
  • about / Using Map Builder
  • using / Using Map Builder
• materialized views
  • about / Understanding materialized views, Replicating data with materialized views
  • restrictions, with geometry columns / Materialized view restrictions with geometry columns
  • data, replicating with / Replicating data with materialized views
• measure
  • finding, at point / Finding the measure at a point – ST_Find_Measure
• measured linestring
  • properties, examining / Examining properties of a measured linestring
• measures
  • about / Understanding linear referencing and measures
  • reversing / Reversing measures and linestring directions – ST_Reverse_Measures and ST_Reverse_Linestring
• metadata
  • about / How metadata is used
• methods, partitioning
  • about / Partitioning methods
• Morton function / Space-filling curves
• multi-column partition key
  • about / Multi-column partition key
• multiple files
  • loading, into single raster object / Loading multiple files into a single raster object
• multiple representations
  • for same objects / Multiple representations for the same objects
• multiply inherited geometry type
  • storage, executing / Storage and function execution using a multiply inherited geometry type
  • function, executing / Storage and function execution using a multiply inherited geometry type
• mutating table problem
  • avoiding / Avoiding the mutating table problem

N

• non-leaf index table
  • about / Non-leaf index table
• non-spatial partitioning
  • versus spatial partitioning / Spatial partitioning versus non-spatial partitioning

O

• OGC
  • about / OGC-defined metadata views
• OGC defined metadata views
  • about / OGC-defined metadata views
• OLAP database
  • about / OLTP and OLAP databases
• OLTP database
  • about / OLTP and OLAP databases
• Open Geo Spatial Consortium / Inserting, modifying, and deleting coordinates
• OpenGIS
  • about / Inserting, modifying, and deleting coordinates
• optimized rectangle
  • testing / Testing optimized rectangles
• Oracle database version / Why Java and Oracle Spatial?
• Oracle MDSYS ST_GEOMETRY type hierarchy
  • about / Understanding the TREAT operator
• Oracle Spatial
  • tolerance / Tolerance in Oracle Spatial
  • features / Why Java and Oracle Spatial?
• Oracle ST / Oracle ST
• orderBy function / Implementing an ordering function
• ordering function
  • implementing / Implementing an ordering function
• ordinate rounding function
  • implementing / Implementing an ordinate rounding function
• ordinates
  • swapping / Swapping ordinates
• ordinate values
  • rounding / Rounding ordinate values
  • background / Background
  • precision, applying / Situations where applying precision may be necessary
  • suitable precision / What is a suitable precision of an ordinate?
  • ordinate rounding function, implementing / Implementing an ordinate rounding function
• OverlayOp class / Java implementation
• overloading / Calling the same processing in different ways

P

• package
  • about / Implementing a PL/SQL package
  • benefits / Implementing a PL/SQL package
• parallel lines
  • creating / Creating truly parallel lines – ST_Parallel
• parallel query
  • and partitioning / Parallel queries and partitioning
• partitioned spatial indexes
  • about / Partitioning spatial indexes
• partitioning
  • about / Introduction to partitioning
  • methods / Partitioning methods
  • and parallel query / Parallel queries and partitioning
• partition pruning / Introduction to partitioning
• physical, and logical standby database
  • synchronizing / Synchronizing the standby and primary databases
• physical standby database
  • about / Physical and logical standby database, Physical standby
• physical storage, GeoRaster
  • about / GeoRaster physical storage
  • raster data, pyramiding / Pyramiding of raster data
• PL/SQL
  • SDO_ELEM_INFO, unpacking in / Unpacking SDO_ELEM_INFO in SQL and PL/SQL
• PL/SQL package
  • implementing / Implementing a PL/SQL package
• point
  • line, splitting at / Splitting a line at a point – ST_Split
  • snapping, to line / Snapping a point to a line – ST_Snap
  • measure, finding at / Finding the measure at a point – ST_Find_Measure
  • creating, at known measure / Creating a point at a known measure – ST_Locate_Measure
• point representation
  • for polygon objects / Point representation for polygon objects
• polygon rings
  • counting / Counting the rings of a polygon
  • filtering / Scenario 2 – filtering rings of a polygon by area
  • extracting, as separate geometries / Scenario 3 – Extracting rings as separate geometries
• polygon rings, counting
  • ST_NumRings function / Examining the operation of the ST_NumRings function
• polygon rings, extracting
  • ST_ExtractRings function, implementing / Implementing the ST_ExtractRings function
• polygon rings, filtering
  • ST_FilterRings function, implementing / Implementing the ST_FilterRings function
• PostgreSQL / PostgreSQL
• PostgreSQL typmod
  • used, for subtype restriction / Subtype restriction using PostgreSQL typmod
• PrecisionModel / A collection of useful functions
• programming, for cross-database deployment
  • about / Programming for cross-database deployment
  • ST_POINT geometries, querying / Querying ST_POINT geometries
  • ST_LINESTRING geometries, querying / Querying ST_LINESTRING geometries
  • ST_CIRCULARSTRING geometries, querying / Querying ST_CIRCULARSTRING geometries
  • ST_COMPOUNDCURVE geometries, querying / Querying ST_COMPOUNDCURVE geometries
  • ST_CURVEPOLYGON geometries, querying / Querying ST_CURVEPOLYGON geometries
  • ST_POLYGON geometries, querying / Querying ST_POLYGON geometries
  • ST_MULTIPOINT geometries, querying / Querying ST_MULTIPOINT geometries
  • ST_MULTILINESTRING geometries, querying / Querying ST_MULTILINESTRING geometries
  • ST_MULTIPOLYGON geometries, querying / Querying ST_MULTIPOLYGON geometries
• Proj4j / Sourcing available Java spatial technologies

Q

• queue
  • creating / Creating a queue

R

• raster cells
  • converting, to rectangles in model space / Converting raster cells to rectangles in model space
• raster data
  • elements / Working with GeoRaster
  • pyramiding / Pyramiding of raster data
  • loading, GDAL used / Using GDAL to load raster data
• raster object
  • multiple files, loading into / Loading multiple files into a single raster object
• real world example / Real world example
• reflecting
  • about / Translating, rotating, scaling, and reflecting
• reflection
  • used, for dupllicating road centerline / Example two – duplicating a road centerline using reflection
• replication
  • types / Introducing different types of replication
• road
  • measuring / Measuring the road – ST_Add_Measure
• road centerline
  • duplicating, reflection used / Example two – duplicating a road centerline using reflection
• road pavement
  • sampling patches, creating over / Case 2 – creating sampling patches over a road pavement
• road surfaces
  • mapping / Mapping road surfaces
• rotating
  • about / Translating, rotating, scaling, and reflecting
• row-level triggers
  • using / Using row-level and statement-level triggers
• rule-based constraints
  • implementing / Implementing rule-based constraints
• rules
  • defining, for schema / Defining rules for the schema

S

• sample schema
  • defining / Defining a sample schema
• sampling patches
  • creating, over road pavement / Case 2 – creating sampling patches over a road pavement
• scaling
  • about / Translating, rotating, scaling, and reflecting
• schema
  • tables, creating in / Creating tables in the schema
  • rules, defining for / Defining rules for the schema
• SDO_CS.TRANSFORM function
  • about / Coordinate system transformation techniques
• SDO_CS.TRANSFORM_LAYER function
  • about / Coordinate system transformation techniques
• SDO_DML_BATCH_SIZE parameter / DML batch size
• SDO_ELEM_INFO
  • about / Understanding and using SDO_ELEM_INFO
  • using / Understanding and using SDO_ELEM_INFO
  • unpacking, in SQL / Unpacking SDO_ELEM_INFO in SQL and PL/SQL
  • unpacking, in PL/SQL / Unpacking SDO_ELEM_INFO in SQL and PL/SQL
  • compound object, dimensionality / Dimensionality of compound objects
  • circular arcs, detecting / Detecting if circular arcs exist
  • optimized rectangle, testing / Testing optimized rectangles
  • polygon rings, counting / Counting the rings of a polygon
  • compound subelement, counting / Counting compound subelements
• SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT function
  • about / Geometry validation and methods to clean imported data
• SDO_GEOMETRY
  • about / Background to programming SDO_GEOMETRY
  • properties / Exposing additional SDO_GEOMETRY properties
  • permissions / Permissions
  • dimension, examining / Examining an SDO_GEOMETRY's dimensionality
  • ST_GEOMETRY ST_Dimension method, reusing / Reusing the existing ST_GEOMETRY ST_Dimension method
  • converting, to JTS Geometry / Converting SDO_GEOMETRY TO JTS Geometry
• SDO_GEOMETRY elements
  • extracting / Extracting and filtering SDO_GEOMETRY elements
  • filtering / Extracting and filtering SDO_GEOMETRY elements
• SDO_GEOMETRY elements, extracting
  • SDO_UTIL.EXTRACT function / Introducing the Oracle SDO_UTIL.Extract function
• SDO_GEOMETRY elements, filtering
  • SDO_UTIL.EXTRACT function / Introducing the Oracle SDO_UTIL.Extract function
• SDO_GEOMETRY object / Exposing additional SDO_GEOMETRY properties
• SDO_GEOR.INIT() function / Using GDAL to load raster data
• SDO_ORDINATES
  • about / Understanding and using SDO_ORDINATES
  • using / Understanding and using SDO_ORDINATES
  • ordinate values, rounding / Rounding ordinate values
  • ordinates, swapping / Swapping ordinates
• SDO_UTIL.AffineTransforms function / Translating, rotating, scaling, and reflecting
• SDO_UTIL.EXTRACT function
  • about / Introducing the Oracle SDO_UTIL.Extract function
  / Implementing the ST_Extract function, Implementing the ST_ExtractRings function, Fragmenting a geometry – ST_ExplodeGeometry
• SDO_UTIL.GETVERTICES function / Understanding and using SDO_ORDINATES, Vectorizing geometries with linestrings
• SDO_UTIL.RECTIFY function
  • about / Geometry validation and methods to clean imported data
• SDO_UTIL.RECTIFY_GEOMETRY function / Geometry validation and methods to clean imported data
• SDO_UTIL.SIMPLIFY function / Using generalized representation
• SecureFiles compression
  • about / SecureFiles compression
• segment
  • selecting / Selecting and offsetting a segment – ST_Locate_Measures
  • offsetting / Selecting and offsetting a segment – ST_Locate_Measures
• Sexante / Sourcing available Java spatial technologies
• Shapefile
  • about / Loading Shapefiles
  • loading / Loading Shapefiles
• single column partition key
  • about / Single column key
  • spatial partition pruning / Spatial partition pruning
• singly inherited subtype properties
  • accessing / Accessing singly inherited subtype properties
  • method execution style, examining / Examining function or method execution style
• snapping functions
  • PL/SQL functions / PL/SQL implementation
  • Java implementation / Implementing the snapping methods
  • Java implementation, testing / Testing the implementation
• source code
  • versus jar / Packaging – source code versus .jar file, Compiling and loading
• space-filling curve
  • about / Creating spatial autocorrelation via clustering, Space-filling curves
• space curve based partitioning
  • implementing / Space curve based partitioning
• spatial, and non-spatial partitioning
  • combining / Combining spatial and non-spatial partitioning
• spatial autocorrelation
  • creating, via clustering / Creating spatial autocorrelation via clustering
• spatial constraints
  • implementing, in database / Implementing spatial constraints in the database
  • geometry type, constraining / Constraining the geometry type
  • complex triggers, implementing / Implementing more complex triggers
• spatial data
  • about / Extract, transform, and load (ETL) tools
• spatial indexing
  • about / Spatial indexing
  • Layer GTYPE, for point data / Layer GTYPE for point data
  • work tablespace / The Work tablespace
  • DML batch size / DML batch size
  • non-leaf index table / Non-leaf index table
• spatial local indexes
  • creating / Creating spatial local indexes
• spatial metadata
  • about / Understanding spatial metadata
  • creating / Creating spatial metadata
• Spatial OLAP (SOLAP)
  • about / Spatial OLAP (SOLAP)
• spatial partitioning
  • versus non-spatial partitioning / Spatial partitioning versus non-spatial partitioning
• spatial partitioning, of tables
  • about / Spatial partitioning of tables
  • single column key / Single column key
  • multi-column partition key / Multi-column partition key
• spatial partition pruning / Spatial partition pruning
• Spatial Reference System Identifier (SRID) / Modifying JASPA and JTS
• spatial tables
  • partitioning / Partitioning of spatial tables
• SQL
  • using / Using SQL, Application Express, and Excel
  • SDO_ELEM_INFO, unpacking in / Unpacking SDO_ELEM_INFO in SQL and PL/SQL
  • about / Programming for cross-database deployment
• SQL/MM ST_GEOMETRY type
  • outlining / Outlining the SQL/MM ST_GEOMETRY type
• SQL Server 2012 / SQL Server 2012
• square buffer
  • generating / Generating a square buffer – ST_SquareBuffer
• SRID
  • about / Spatial Reference System
• SRS
  • about / Spatial Reference System
• statement-level triggers
  • using / Using row-level and statement-level triggers
• steps
  • removing, in raster / Removing steps in raster to vector data – ST_SmoothTile
• storage resolution
  • versus resolution used by functions / Storage resolution versus resolution used by functions
• storage resolution, versus resolution used by functions
  • precision and accuracy / Precision and accuracy
  • storage cost, for each coordinate / Storage cost for each coordinate
  • storage cost, for Oracle Spatial tables / Storage cost for Oracle Spatial tables
  • effect of tolerance, on performance of Oracle Spatial functions / Effect of tolerance on performance of Oracle Spatial functions
• streams based replication
  • about / Streams based replication
  • database, setting up / Setting up the database
  • enabling / Enabling replication
  • extending, for SDO_GEOMETRY support / Extending streams to support SDO_GEOMETRY
  • EDS, enabling for geometry tables / Enabling EDS for geometry tables
• ST_Add_Measure function / Linear referencing functions to be developed
• ST_AsEWKT function / A collection of useful functions
• ST_Buffer
  • implementing / Implementing ST_Buffer
  • executing / Executing ST_Buffer
• ST_Centroid function / Calculating a linestring's centroid – ST_Centroid, A collection of useful functions
• ST_CIRCULARSTRING geometries
  • querying / Querying ST_CIRCULARSTRING geometries
• ST_COMPOUNDCURVE geometries
  • querying / Querying ST_COMPOUNDCURVE geometries
• ST_CURVEPOLYGON geometries
  • querying / Querying ST_CURVEPOLYGON geometries
• ST_CURVEPOLYGON value
  • about / How are geometry objects internally organized?
• ST_DelaunayTriangles function / A collection of useful functions
• ST_DeleteVertex function
  • about / Inserting, modifying, and deleting coordinates
  • implementing / Implementing ST_DeleteVertex
  • testing / Testing ST_DeleteVertex
  / A collection of useful functions
• ST_Densify function / A collection of useful functions
• ST_Dimension function / Examining an SDO_GEOMETRY's dimensionality, Reusing the existing ST_GEOMETRY ST_Dimension method, Dimensionality of compound objects, Calling the same processing in different ways, Implementing a PL/SQL package
• ST_End_Measure function / Linear referencing functions to be developed
• ST_ExplodeGeometry function
  • implementing / Fragmenting a geometry – ST_ExplodeGeometry
• ST_Extract function
  • implementing / Implementing the ST_Extract function
• ST_ExtractRings function / Implementing the ST_ExtractRings function
  • implementing / Implementing the ST_ExtractRings function
• ST_FilterRings function
  • implementing / Implementing the ST_FilterRings function
  / Implementing the ST_FilterRings function
• ST_Find_Measure function / Linear referencing functions to be developed, Finding the measure at a point – ST_Find_Measure
• ST_Find_Offset function / Linear referencing functions to be developed
• ST_GEOMETRY ST_Dimension method
  • reusing / Reusing the existing ST_GEOMETRY ST_Dimension method
• ST_GeomFromEWKT function / A collection of useful functions
• ST_hasOptimizedRectangles function / Testing optimized rectangles
• ST_inCircularArc function / Identifying an arc point – ST_inCircularArc
• ST_InsertVertex function
  • about / Inserting, modifying, and deleting coordinates, Implementing ST_InsertVertex
  • implementing / Implementing ST_InsertVertex
  • testing / Testing ST_InsertVertex
  / A collection of useful functions
• ST_InterpolateZ function / A collection of useful functions
• ST_Is_Measure_Decreasing function / Linear referencing functions to be developed
• ST_Is_Measure_Increasing function / Linear referencing functions to be developed
• ST_LineMerger function / A collection of useful functions
• ST_LineShift function
  • about / Shifting a line sideways – ST_LineShift
• ST_LINESTRING geometries
  • querying / Querying ST_LINESTRING geometries
• ST_Locate_Measure function / Linear referencing functions to be developed, Creating a point at a known measure – ST_Locate_Measure
• ST_Locate_Measures function / Linear referencing functions to be developed
• ST_Locate_Point function / Linear referencing functions to be developed
• ST_Measure_Range function / Linear referencing functions to be developed
• ST_Measure_To_Percentage function / Linear referencing functions to be developed
• ST_MinimumBoundingCircle function / A collection of useful functions
• ST_MULTILINESTRING geometries
  • querying / Querying ST_MULTILINESTRING geometries
• ST_MULTIPOINT geometries
  • querying / Querying ST_MULTIPOINT geometries
• ST_MULTIPOLYGON geometries
  • querying / Querying ST_MULTIPOLYGON geometries
• ST_NumRings function
  • examining / Examining the operation of the ST_NumRings function
  / Fragmenting a geometry – ST_ExplodeGeometry
• ST_NumSubElems function / Counting compound subelements, Fragmenting a geometry – ST_ExplodeGeometry
• ST_OneSidedBuffer function
  • about / Buffering one side of a linestring – ST_OneSidedBuffer
• ST_Parallel function
  • about / Creating truly parallel lines – ST_Parallel
• ST_Percentage_To_Measure function / Linear referencing functions to be developed
• ST_POINT geometries
  • querying / Querying ST_POINT geometries
• ST_POLYGON geometries
  • querying / Querying ST_POLYGON geometries
• ST_Polygonizer
  • implementing / Implementing ST_Polygonizer
• ST_Project_Point function / Linear referencing functions to be developed
• ST_Relate / Spatially (Topological) comparing two geometries – ST_Relate
• ST_Reverse_Linestring / Reversing measures and linestring directions – ST_Reverse_Measures and ST_Reverse_Linestring
• ST_Reverse_Measures / Reversing measures and linestring directions – ST_Reverse_Measures and ST_Reverse_Linestring
• ST_Scale_Measures function / Linear referencing functions to be developed
• ST_SmoothTile function / Removing steps in raster to vector data – ST_SmoothTile
• ST_Snap function / Linear referencing functions to be developed, Snapping a point to a line – ST_Snap
• ST_Split function / Linear referencing functions to be developed, Splitting a line at a point – ST_Split
• ST_SquareBuffer function
  • about / Generating a square buffer – ST_SquareBuffer
• ST_Start_Measure function / Linear referencing functions to be developed
• ST_Tile function
  • about / Tiling a vector geometry – ST_Tile
• ST_TopologyPreservingSimplify function / A collection of useful functions
• ST_Union / Replicating existing licensed overlay functions – ST_Union
• ST_UpdateVertex function
  • about / Inserting, modifying, and deleting coordinates
  • implementing / Implementing ST_UpdateVertex
  • testing / Testing ST_UpdateVertex
  / A collection of useful functions
• ST_Vectorize function / Implementing vectorization – ST_Vectorize
  • implementing / Implementing vectorization – ST_Vectorize
  • using / Using vectorization
• ST_Voronoi function / A collection of useful functions
• subtype
  • using, for geometry type restriction / Geometry type restriction using a subtype
• subtype inheritance
  • issues / Subtype inheritance issues
• Subtype restriction
  • PostgreSQL typmod used / Subtype restriction using PostgreSQL typmod
• synchronous trigger processing / Implementing spatial constraints in the database
• System Change Number (SCN) / Flashback query

T

• tables
  • creating, in schema / Creating tables in the schema
  • populating / Populating the tables
• tiling
  • applications / Applications of tiling
• tolerance, in Oracle Spatial / Tolerance in Oracle Spatial
• transformation member functions
  • about / Introducing a set of transformation member functions
• translating
  • about / Translating, rotating, scaling, and reflecting
• TREAT operator
  • about / Understanding the TREAT operator
• triggers
  • used, for fixing invalid data / Fixing invalid data using triggers
  • defining / Defining the trigger
  • spatial relationships, checking / Trigger for checking spatial relationships
• two geometries
  • processing, functions / Spatially (Topological) comparing two geometries – ST_Relate, Replicating existing licensed overlay functions – ST_Union, Snapping geometries together
  • comparing / Spatially (Topological) comparing two geometries – ST_Relate
  • Java implementation / Java implementation
  • ST_Relate Java method / Java implementation
  • licensed overlay functions, replicating / Replicating existing licensed overlay functions – ST_Union
  • snapping functions / Snapping geometries together

U

• unit
  • about / Implementing the ST_FilterRings function
• user object type
  • implementing / Implementing user object types

V

• vector geometry
  • tiling / Tiling a vector geometry – ST_Tile
• vector object
  • gridding / Putting it all together – gridding a vector object
• version-enabling tables
  • about / Version-enabling tables
• visualization applications, GeoRaster
  • about / Visualization applications for GeoRaster

W

• Web Mapping Service (WMS)
  • about / Visualization applications for GeoRaster
• well-known text (WKT)
  • about / More on Spatial Reference Systems
• Well Known Text (WKT) / Modifying JASPA and JTS
• WKT / Exporting formats – GML, WKT, and GeoJSON
• Workload capture
  • about / Workload capture
• Workload processing / Database replay
  • about / Workload processing
• Workload Replay / Database replay
• Workload replay
  • about / Workload replay
• Workspace locking / Workspace locking
• Workspace Manager
  • about / Workspace Manager
  • version-enabling tables / Version-enabling tables
  • workspace, creating / Creating and using workspaces
  • workspace, using / Creating and using workspaces
  • conflict resolution / Conflict resolution
  • Workspace locking / Workspace locking
  • DDL operations, on version-enabled tables / DDL operations on version-enabled tables
  • valid-time support / Valid-time support
• workspaces
  • creating / Creating and using workspaces
  • using / Creating and using workspaces
• work tablespace / The Work tablespace

X

• XMLAGG function / Exporting formats – GML, WKT, and GeoJSON
• XMLFOREST function / Exporting formats – GML, WKT, and GeoJSON

Z

• Z ordinate problems
  • fixing / Fixing Z ordinate problems – ST_ FixZ