You are previewing Pro Oracle Spatial for Oracle Database 11g.
O'Reilly logo
Pro Oracle Spatial for Oracle Database 11g

Book Description

Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Database's built-in feature set for working with location-based data. Authors Ravi Kothuri and Albert Godfrind address the special nature of spatial data and its role in professional and consumer applications. They also detail issues in spatial data management, such as modeling, storing, accessing, and analyzing spatial data, as well as the Oracle Spatial solution and the integration of spatial data into enterprise databases. In addition, they cover how spatial information is used to understand business and support decisions, to manage customer relations, and to better serve private and corporate users.

When you read Pro Oracle Spatial for Oracle Database 11g, you're learning from the very best. Ravi Kothuri is a key member of Oracle's Spatial development team. Albert Godfrind consults widely with Oracle clients on the implementation of Oracle Spatial, develops training courses, and presents frequently at conferences. Together they have crafted a technically sound and authoritative fountain of information on working with spatial data in the Oracle database.

Table of Contents

  1. Title Page
  2. Contents at a Glance
  3. Contents
  4. About the Authors
  5. About the Technical Reviewer
  6. Acknowledgments
  7. Introduction
    1. What Does This Book Cover?
    2. Who Should Read This Book?
    3. Copyrights and Disclaimer
  8. Setting Up
    1. Downloads
    2. Setting Up Oracle Spatial and MapViewer
    3. The Example Data
  9. Part 1: Overview
    1. CHAPTER 1: Spatial Information Management
      1. Using Spatial Information in Various Industries
      2. Sources of Spatial Data
      3. Managing and Analyzing Spatial Data
      4. Benefits of Oracle Spatial
      5. Summary
      6. References
    2. CHAPTER 2: Overview of Oracle Spatial
      1. Technology and Architecture Overview
      2. Getting Started with Oracle Spatial
      3. Oracle Spatial Technology Products
      4. What to Expect in an Oracle Spatial Install
      5. Summary
    3. CHAPTER 3: Location-Enabling Your Applications
      1. Adding Location Information to Tables
      2. Metadata for Spatial Tables
      3. Populating Spatial Metadata for Your Application
      4. Summary
  10. Part 2: Basic Spatial
    1. CHAPTER 4: The SDO_GEOMETRY Data Type
      1. Types of Spatial Geometries in Oracle
      2. SDO_GEOMETRY Type, Attributes, and Values
      3. Simple Two-Dimensional Geometry Examples
      4. Complex Two-Dimensional Geometry Examples
      5. Three-Dimensional Examples
      6. Summary
    2. CHAPTER 5: Loading, Transporting, and Validating Spatial Data
      1. Inserting Data into an SDO_GEOMETRY Column
      2. Loading and Converting Spatial Data
      3. Extruding a Two-Dimensional Geometry to Three Dimensions
      4. Validating Spatial Data
      5. Debugging Spatial Data
      6. Summary
    3. CHAPTER 6: Geocoding
      1. What Is Geocoding?
      2. Architecture of the Oracle Geocoder
      3. Setting Up the Reference Data for the Geocoder
      4. Using Geocoder Functions
      5. Geocoding Using Structured Addresses
      6. Reverse Geocoding
      7. Geocoding Business Data
      8. The Geocoding Server
      9. Summary
    4. CHAPTER 7: Manipulating SDO_GEOMETRY in Application Programs
      1. Manipulating Geometries Using PL/SQL
      2. Manipulating Geometries in Java
      3. Summary
  11. Part 3: Spatial and Network Analysis
    1. CHAPTER 8: Spatial Indexes and Operators
      1. Spatial Indexes
      2. Spatial Index Parameters
      3. Spatial Operators
      4. A Closer Look at Spatial Operators
      5. Advanced Spatial Index Features
      6. Summary
    2. CHAPTER 9: Geometry Processing Functions
      1. Buffering Functions
      2. Relationship Analysis Functions
      3. Geometry Combination Functions
      4. Geometric Analysis Functions
      5. Aggregate Functions
      6. Summary
    3. CHAPTER 10: Network Modeling
      1. General Network Modeling Concepts
      2. Data Structures: The Network Tables
      3. Defining Networks
      4. Analyzing and Managing Networks Using the Java API
      5. Debugging Network Structures
      6. Analyzing Networks Using the PL/SQL API
      7. The Network Editor
      8. Summary
    4. CHAPTER 11: The Routing Engine
      1. Architecture
      2. Installation and Configuration
      3. Data Structures
      4. Example Data: The Streets of San Francisco
      5. Partitioning
      6. Using the Router: XML Queries and Responses
      7. Summary
  12. Part 4: Visualization
    1. CHAPTER 12: Defining Maps Using MapViewer
      1. Why Use Maps in Location-Enabled Applications?
      2. Overview of MapViewer and Oracle Maps
      3. Getting Started
      4. Configuring MapViewer
      5. Defining Maps
      6. Defining Map Caches
      7. Summary
    2. CHAPTER 13: Using Maps in Your Applications
      1. Overview of MapViewer's APIs
      2. Anatomy of a Map Request
      3. Interacting with Maps
      4. Oracle Maps: The JavaScript API
      5. Using the Java API
      6. Using the XML API
      7. Using the PL/SQL API
      8. Using the Administrative API
      9. Web Map Service (OGC WMS) Interface
      10. Summary
  13. Part 5: Spatial in Applications
    1. CHAPTER 14: Sample Applications
      1. Data Preparation and Setup
      2. Applications Setup
      3. The JavaScript Application
      4. The Java (JSP) Application
      5. Summary
    2. CHAPTER 15: Case Studies
      1. Overview of the Case Studies
      2. Spatial Information for Managing the London Bus Network
      3. P-Info: A Mobile Application for Police Forces
      4. Risk Repository for Hazardous Substances
      5. USGS National Land Cover Visualization and Analysis Tool
      6. U.S. Department of Defense MilitaryHOMEFRONT LBS
      7. Summary
    3. CHAPTER 16: Tips, Common Mistakes, and Common Errors
      1. Tips
      2. Common Mistakes
      3. Common Errors
      4. Summary
  14. Part 6: Appendixes
    1. APPENDIX A: Additional Spatial Analysis Functions
      1. Tiling-Based Analysis
      2. Neighborhood Analysis
      3. Clustering Analysis
      4. Refining the Candidates for Site Selection
      5. Geometry Simplification for Speeding Up Analysis
      6. Summary
    2. APPENDIX B: Linear Referencing
      1. Concepts and Definitions
      2. Creating Linear Referenced Geometries
      3. Dynamic Segmentation Operations
      4. Summary
    3. APPENDIX C: Topology Data Model in Oracle
      1. Sharing Boundaries
      2. Benefits of the Topology Data Model
      3. Storing a Topology Data Model in Oracle
      4. Operating on a Topology in Oracle
      5. Hierarchical Feature Model
      6. Summary
    4. APPENDIX D: Storing Raster Data in Oracle
      1. The SDO_GEORASTER Data Type
      2. Populating SDO_GEORASTER Columns
      3. Manipulating Raster Objects
      4. Using Compression in GeoRaster
      5. Visualizing Raster Data in Oracle MapViewer
      6. Summary
    5. APPENDIX E: Three-Dimensional Modeling Using Point Clouds and TINs in Oracle
      1. Storing Large Point Sets
      2. Storing Triangulated Irregular Networks
      3. Summary
  15. INDEX