Pro Oracle Spatial for Oracle Database 11g (eBook)

Ravi Kothuri holds a Ph.D. in computer science from the University of California, Santa Barbara, and has been an active researcher and developer in the spatial and multimedia areas for the past 12 years. He serves as the project lead and software architect for various projects in Oracle Spatial. He has around 15 patents (some pending) on specific Oracle technology and has authored numerous articles for database conferences and journals. Other activities include teaching database courses for undergrads and reviewing of research articles for spatial and database conferences. Ravi enjoys music, movies, and playing with children.

Contents at a Glance 3
Contents 5
About the Authors 18
About the Technical Reviewer 19
Acknowledgments 20
Introduction 22
What Does This Book Cover? 23
Who Should Read This Book? 26
Copyrights and Disclaimer 27
Setting Up 28
Downloads 28
Setting Up Oracle Spatial and MapViewer 28
The Example Data 29
Overview 32
Spatial Information Management 33
Using Spatial Information in Various Industries 35
Sources of Spatial Data 37
Managing and Analyzing Spatial Data 37
Benefits of Oracle Spatial 45
Summary 48
References 48
Overview of Oracle Spatial 49
Technology and Architecture Overview 49
Getting Started with Oracle Spatial 52
Oracle Spatial Technology Products 60
What to Expect in an Oracle Spatial Install 63
Summary 66
Location-Enabling Your Applications 67
Adding Location Information to Tables 68
Metadata for Spatial Tables 75
Populating Spatial Metadata for Your Application 79
Summary 81
Basic Spatial 82
The SDO_GEOMETRY Data Type 83
Types of Spatial Geometries in Oracle 84
SDO_ GEOMETRY Type, Attributes, and Values 88
Simple Two- Dimensional Geometry Examples 104
Complex Two- Dimensional Geometry Examples 112
Three- Dimensional Examples 123
Summary 142
Loading, Transporting, and Validating Spatial Data 143
Inserting Data into an SDO_ GEOMETRY Column 144
Loading and Converting Spatial Data 145
Extruding a Two- Dimensional Geometry to Three Dimensions 157
Validating Spatial Data 160
Debugging Spatial Data 170
Summary 177
Geocoding 178
What Is Geocoding? 178
Architecture of the Oracle Geocoder 180
Setting Up the Reference Data for the Geocoder 183
Using Geocoder Functions 185
Geocoding Using Structured Addresses 209
Reverse Geocoding 211
Geocoding Business Data 213
The Geocoding Server 223
Summary 233
Manipulating SDO_GEOMETRY in Application Programs 234
Manipulating Geometries Using PL/ SQL 236
Manipulating Geometries in Java 250
Summary 267
Spatial and Network Analysis 268
Spatial Indexes and Operators 269
Spatial Indexes 271
Spatial Index Parameters 275
Spatial Operators 279
A Closer Look at Spatial Operators 282
Advanced Spatial Index Features 313
Summary 329
Geometry Processing Functions 330
Buffering Functions 332
Relationship Analysis Functions 335
Geometry Combination Functions 345
Geometric Analysis Functions 351
Aggregate Functions 362
Summary 368
Network Modeling 369
General Network Modeling Concepts 371
Data Structures: The Network Tables 375
Defining Networks 379
Analyzing and Managing Networks Using the Java API 394
Debugging Network Structures 420
Analyzing Networks Using the PL/ SQL API 421
The Network Editor 436
Summary 440
The Routing Engine 441
Architecture 442
Installation and Configuration 444
Data Structures 446
Example Data: The Streets of San Francisco 448
Partitioning 449
Using the Router: XML Queries and Responses 451
Summary 458
Visualization 459
Defining Maps Using MapViewer 460
Why Use Maps in Location- Enabled Applications? 460
Overview of MapViewer and Oracle Maps 463
Getting Started 466
Configuring MapViewer 471
Defining Maps 480
Defining Map Caches 514
Summary 525
Using Maps in Your Applications 526
Overview of MapViewer’s APIs 526
Anatomy of a Map Request 530
Interacting with Maps 532
Oracle Maps: The JavaScript API 533
Using the Java API 553
Using the XML API 575
Using the PL/ SQL API 589
Using the Administrative API 591
Web Map Service ( OGC WMS) Interface 596
Summary 601
Spatial in Applications 602
Sample Applications 603
Data Preparation and Setup 604
Applications Setup 605
The JavaScript Application 606
The Java ( JSP) Application 625
Summary 644
Case Studies 645
Overview of the Case Studies 645
Spatial Information for Managing the London Bus Network 646
P- Info: A Mobile Application for Police Forces 653
Risk Repository for Hazardous Substances 660
USGS National Land Cover Visualization and Analysis Tool 666
U.S. Department of Defense MilitaryHOMEFRONT LBS 674
Summary 684
Tips, Common Mistakes, and Common Errors 685
Tips 685
Common Mistakes 700
Common Errors 703
Summary 707
Appendixes 708
Additional Spatial Analysis Functions 709
Tiling- Based Analysis 709
Neighborhood Analysis 714
Clustering Analysis 716
Refining the Candidates for Site Selection 717
Geometry Simplification for Speeding Up Analysis 718
Summary 719
Linear Referencing 720
Concepts and Definitions 721
Creating Linear Referenced Geometries 724
Dynamic Segmentation Operations 726
Summary 731
Topology Data Model in Oracle 732
Sharing Boundaries 733
Benefits of the Topology Data Model 734
Storing a Topology Data Model in Oracle 734
Operating on a Topology in Oracle 737
Hierarchical Feature Model 742
Summary 743
Storing Raster Data in Oracle 744
The SDO_ GEORASTER Data Type 745
Populating SDO_ GEORASTER Columns 750
Manipulating Raster Objects 751
Using Compression in GeoRaster 757
Visualizing Raster Data in Oracle MapViewer 758
Summary 760
Three-Dimensional Modeling Using Point Clouds and TINs in Oracle 761
Storing Large Point Sets 762
Storing Triangulated Irregular Networks 767
Summary 773
INDEX 775