OracleSpatial空间信息管理（英文原版）_oraclespatial空间信息管理

5星 · 超过95%的资源需积分: 15 47 浏览量更新于2023-03-16 评论 1 收藏 17.06MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

this print for content only—size & color not accurate

7" x 9-1/4" / CASEBOUND / MALLOY

(1.625 INCH BULK -- 824 pages -- 50# Thor)

The eXPeRT’s VOIce

In ORacle

Ravi Kothuri, Albert Godfrind,

and Euro Beinat

Pro

Oracle Spatial

for Oracle Database 11g

The essential guide to developing spatially

enabled business applications using Oracle

BOOks fOR PROfessIOnals By PROfessIOnals

Pro Oracle Spatial for Oracle Database 11g

Dear Reader,

This book will provide you with the conceptual knowledge and practical skills

to become a professional in spatial information management. It contains all

you need to master one of the most powerful tools available for this purpose:

Oracle Spatial. The power of Oracle Spatial—the set of spatial technologies for

the Oracle database—stems from the fact that you can store, retrieve, analyze,

and visualize spatial data just like any other type of data and integrate it into

any business application. You can do so by using the same tools and languages

with which you are familiar, such as SQL, Java, and XML.

Spatial information is utilized in a variety of applications. Think about how

you get travel directions from your GPS, how cables and pipes are maintained,

how distribution chains choose the location of their outlets, or how we predict

storms and weather. Almost every organization now stores spatial information

assets. Pro Oracle Spatial for Oracle Database 11g shows you how to manage

and make the most effective use of that information.

The book introduces the concepts of spatial data, the architecture of Oracle

Spatial, and the vast set of functions and procedures for managing spatial data.

It shows how to create spatial applications, how to integrate the technology into

existing applications, and how organizations have already successfully imple-

mented spatial solutions. The book provides sample data, examples, and tips

so that you can learn, experiment, and find guidance in becoming an expert

Oracle Spatial developer. It will allow you to develop exciting applications, be

part of large and inspiring projects, and explore the rich world of spatial data. It is

our hope that you will find this world as interesting and challenging as we do.

Enjoy!

Ravi Kothuri, Ph.D.; Albert Godfrind; and Euro Beinat, Ph.D.

THE APRESS ROADMAP

Beginning

Oracle Programming

Beginning

PL/SQL

Mastering Oracle

SQL & SQL*Plus

Mastering

Oracle PL/SQL

Pro Oracle Spatial

for Oracle Database 11g

Kothuri,

Godfrind,

Beinat

cyan

MaGenTa

yellOW

Black

PanTOne 123 c

Ravi Kothuri

ISBN-13: 978-1-59059-899-3

ISBN-10: 1-59059-899-7

9 781590 598993

9 0 0 0 0

Shelve in

Databases/Oracle

User level:

Intermediate–Advanced

www.apress.com

SOURCE CODE ONLINE

Companion eBook

See last page for details

on $10 eBook version

Companion eBook Available

Updated for

Oracle

Database 11g

Updated for

Oracle

Database 11g

Albert Godfrind

Euro Beinat

Kothuri, Godfrind,

and Beinat coauthored

Pro Oracle Spatial

(first edition)

Pro

Oracle Spatial

for Oracle Database 11g

www.it-ebooks.info

Pro Oracle Spatial for Oracle Database 11

electronic or mechanical, including photocopying, recording, or by any information storage or retrieval

system, without the prior written permission of the copyright owner and the publisher.

ISBN-13: 978-1-59059-899-3

ISBN-10: 1-59059-899-7

Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1

Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence

of a trademarked name, we use the names only in an editorial fashion and to the benefit of the trademark

owner, with no intention of infringement of the trademark.

Lead Editor: Jonathan Gennick

Technical Reviewer: Carel-Jan Engel

Editorial Board: Steve Anglin, Ewan Buckingham, Tony Campbell, Gary Cornell, Jonathan Gennick, Jason

Gilmore, Kevin Goff, Jonathan Hassell, Matthew Moodie, Joseph Ottinger, Jeffrey Pepper, Ben Renow-

Clarke, Dominic Shakeshaft, Matt Wade, Tom Welsh

Project Manager: Kylie Johnston

Copy Editor: Kim Wimpsett

Assistant Production Director: Kari Brooks-Copony

Production Editor: Ellie Fountain

Compositor: Kinetic Publishing Services, LLC

Proofreader: Linda Seifert

Indexer: Broccoli Information Management

Artist: Kinetic Publishing Services, LLC

Cover Designer: Kurt Krames

Manufacturing Director: Tom Debolski

Distributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6th Floor,

New York, NY 10013. Phone 1-800-SPRINGER, fax 201-348-4505, e-mail orders-ny@springer-sbm.com, or

visit http://www.springeronline.com.

For information on translations, please contact Apress directly at 2855 Telegraph Avenue, Suite 600, Berkeley,

CA 94705. Phone 510-549-5930, fax 510-549-5939, e-mail info@apress.com, or visit http://www.apress.com.

The information in this book is distributed on an “as is” basis, without warranty. Although every precau-

tion has been taken in the preparation of this work, neither the author(s) nor Apress shall have any

liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly

or indirectly by the information contained in this work.

The source code for this book is available to readers at http://www.apress.com in the Source Code/Download

section.

8997ch00FM.qxt 9/28/07 9:52 AM Page ii

www.it-ebooks.info

Contents at a Glance

About the Authors. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix

About the Technical Reviewer. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi

Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiii

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxv

Setting Up . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxxi

PART 1

■ ■ ■

Overview

■CHAPTER 1 Spatial Information Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

■CHAPTER 2 Overview of Oracle Spatial . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

■CHAPTER 3 Location-Enabling Your Applications. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37

PART 2

■ ■ ■

Basic Spatial

■CHAPTER 4 The SDO_GEOMETRY Data Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55

■CHAPTER 5 Loading, Transporting, and Validating Spatial Data. . . . . . . . . . . . . . . . . . . 115

■CHAPTER 6 Geocoding. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151