Oracle Spatial空间信息管理(英文原版)

所需积分/C币:23 2014-11-25 20:11:01 17.06MB PDF
收藏 收藏

本书是世界级Oracle Spatial专家Ravi Kothuri、Albert Godfrind和Euro Beinat的力作,旨在向您提供空间信息管理方面的概念知识和实用技能,帮助您成为该领域的专家。书中涵盖了Oracle数据库中空间信息管理的所有内容。主要阐述了空间信息管理的主要概念,Oracle Spatial的架构,以及大量用于管理空间数据的函数和操作。详细描述了Oracle Spatial所提供的用于存储、检索、分析和可视化空间信息的工具。本书还提供了丰富的样本数据、例子和提示,以帮助读者方便地将上述概念和工具结合到实际应用中。全书结构合理清晰,内容全面丰富,示例贴近实际,适用于所有DBA和应用系统开发人员。
8997ch0OFM qxt 9/28/079: 52 AM Page i Pro Oracle Spatial for Oracle Database 119 Ravi Kothuri. albert godfrind and euro beinat apress 8997ch0OFM qxt 9/28/079: 52 AM Page Pro Oracle spatial for Oracle Database 11g Copyright o 2007 by Ravi Kothuri, Albert Godfrind, Euro Beinat All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieva 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 987654321 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 ndexer: 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, NewYork,Ny10013.Phone1-800-springer,fax201-348-4505,,or visit For information on translations, please contact Apress directly at 2855 Telegraph Avenue, Suite 600, Berkeley, Ca94705.Phone510-549-5930,fax510-549-5939,e-mailinfo@apress.comorvisit 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 Thesourcecodeforthisbookisavailabletoreadersathttp://www.apress.comintheSourceCode/download section 8997ch0OFM qxt 9/28707 9: 52 AM Page iii Contents at a glance About the authors ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,ⅪⅨX about the technical reviewer, Acknowledgments XXIII Introduction XXV Setting Up PART1■0 verview CHAPTER 1 Spatial Information Management CHAPTER 2 Overview of oracle Spatial CHAPTER 3 Location-Enabling your applications PART2■■ Basic Spatial CHAPTER4 The sp0GE〔 OMETRY Data Type 55 CHAPTER 5 Loading Transporting, and validating spatial Data 115 CHAPTER 6 Geocoding 151 CHAPTER 7 Manipulating SDO GEOMETRY in Application Programs....... 207 PART3■■ Spatial and Network analysis CHAPTER 8 Spatial Indexes and operators 243 CHAPTER 9 Geometry Processing Functions 305 CHAPTER 10 Network Modeling 345 CHAPTER 11 The Routing Engine ....,,,,,,,,,,,,,,,,,,,..,417 PaRT 4 Visualization CHAPTER 12 Defining Maps Using MapViewer CHAPTER 13 Using Maps in Your Applications.................503 8997ch0OFM axt 9/28707 9: 52 AM Page iv PaRT 5 Spatial in Applications CHAPTER 14 Sample applications ..581 CHAPTER 15 Case studies ,,,,,,,,,,,,,,,,,,,,,,,,,.623 CHAPTER 16 Tips, Common Mistakes, and common Errors.......,...663 PART6■■■ Appendixes APPENDIX A Additional Spatial Analysis Functions...............689 APPENDIX B Linear Referencing 701 APPENDIX C Topology data Model in Oracle 713 APPENDIX D Storing Raster Data in Oracle .725 APPENDIX E Three-Dimensional Modeling using point clouds and tins in oracle 743 NDEX.,,757 8997ch0OFM qxt 9/28/079: 52 AM Page v Contents About the authors ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,ⅪⅨX about the technical reviewer Acknowledgments XXIII Introduction XXV Setting Up PART 1 Overview CHAPTER 1 Spatial Information Management Using Spatial Information in various Industries Sources of Spatial Data 7 Managing and analyzing Spatial Data 7 Storing Spatial Data in a Database Spatial Analysis Benefits of Oracle Spatial 15 Summar References CHAPTER 2 Overview of Oracle Spatial Technology and architecture Overview................. 19 Getting Started with Oracle Spatial 22 Data Model: Storing spatial data 22 Location -Enabling 22 Query and analysis 24 Visualizing Spatial Data Advanced spatial Engine Oracle Spatial Technology products Locator Spatial opti What to Expect in an Oracle Spatial Install................. 33 Installing Oracle Spatial in the Database Upgrade Understanding a spatial Install Checking the Version of a Spatial Install 36 Summary 8997ch0OFM qxt 9/28/079: 52 AM Page vi CONTENTS CHAPTER 3 Location-Enabling Your Applications Adding Location Information to Tables Application-Specific Data 3382 Geographic data Metadata for Spatial Tables Dictionary view for Spatial Metadata Populating Spatial Metadata for Your Application 49 Additional Information for visualization and Network analysis Summary PART2■ Basic Spatial CHAPTEr 4 The Sdo_geOMEtrY Data Type Types of Spatial Geometries in Oracle Points Line strings Polygons and Surfaces 57 Solid ..57 Collections Logical Implementation of SDO_ GEOMETRY Spatial Data in SQL/MM and oGC................59 SDO GEOMETRY Type, Attributes, and values SDO GTYPE Attribute SDO SRID Attribute SDO POINT Attribute SDO ELEM INFO and sdo ordinates attributes Simple TWo-Dimensional Geometry Examples Point Line String: Connected by Straight Lines Line String: Connected by Arcs Polygon: Ring( Boundary) Connected by Straight Lines ........ 80 Polygon: Ring(Boundary) Connected by Arcs 82 Rectangle Polygon 82 Circle Polyge Complex Two-Dimensional Geometry Examples....,........ 84 Constructing Complex Geometries SDO ELEM INFO for Compound Elements 86 SDO_ELEM_INFO for Voided polygon Element Compound Line string example Compound Polygon Example Polygon with a Void Collections 8997ch0OFM qxt 9/28707 9: 52 AM Page vii contents Three-Di Three-Dimensional Points, Lines, and polygons Composite Surfaces Simple Solid Composite Solid 10 Collections Summary CHAPTER 5 Loading Transporting and validating Spatial Data .115 Inserting Data into an SDO_ GEOMETRY Column Loading and converting Spatial Data 117 Loading from Text Files Using SQL Loader 117 Transporting Spatial Data Between Oracle Databases Loading from EXternal Formats Converting Between SDO_ GEOMETRY and WKT/KB 124 Converting SDO_ GEOMETRY Data in GML 124 Extruding a Two-Dimensional geometry to Three Dimensions Validating Spatial Data Validation functions 132 Validation crit Composite Solids 140 Collections Debugging Spatial Data REMOVE DUPLICATE VERTICES EXTRACT 143 APPEND GETNUMELEM. GETNUMVERTICES, and GETVERTICES 147 EXTRACT3D 147 Miscellaneous functions 149 Summary 149 CHAPTER 6 Geocoding 151 What is geocoding? Architecture of the oracle geocoder Parsing the Input Address 153 Searching for the Address .................... 154 Computing the Spatial Coordinates Setting Up the reference Data for the Geocoder 156 Parameter tables 156 Data tables 157 8997ch0OFM qxt 9/28707 9: 52 AM Page vii CONTENTS Using Geocoder Functions 158 GEOCODE AS GEOMETRY 158 GEOCODE 16 GEOCODE ALL 176 Geocoding Using Structured Addresses GEOCODE ADDR GEOCODE ADDR ALL Reverse Geocoding REVERSE GEOCODE Geocoding business data Adding the Spatial Column Geocoding the Addresses:The“ Naive” Approach .187 Address verification and Correction Automatic Geocoding The Geocoding server Architecture 196 Installation and Configuration Using the Geocoder: XML Queries and Responses 200 Summary 206 CHAPTER 7 Manipulating SDO GEOMETRY in Application Programs Manipulating Geometries Using PL/SQL 209 VARRAY Manipulation primer 211 Reading and Writing SDO_GEOMETRY Objects 215 Creating New geometries 215 Extracting Information from Geometries 217 Modifying Existing Geometries 219 Manipulating geometries in Java Using the GEometry clas 223 Using 3D Geometries: the J3D Geometry class.......... 229 Extracting Elements from 3D Geometries: the ElementExtractor Using Standard Notations: WKT, WKB, GML 232 Using ESRI Shapefil Summar 240

试读 127P Oracle Spatial空间信息管理(英文原版)
立即下载 身份认证VIP会员低至7折
superant2008 英文版原版,字迹清晰,值得阅读或收藏。
续汉冕 英文版的很清晰,要是有中文就好了
zhouwenxiamg 书非常清晰 谢谢楼主
sunmemon 书十分清晰,非常有参考价值,是学校oracle spatial的必选参考书籍!
-AsZhao- 首先感谢楼主分享,辛苦了。但是您的资源出现了点问题,反复下载了三次,全部显示是文件损坏不能修复。希望能及时处理。
victory_nj 好书,就是英文捉急
  • 签到新秀

关注 私信
Oracle Spatial空间信息管理(英文原版) 23积分/C币 立即下载
Oracle Spatial空间信息管理(英文原版)第1页
Oracle Spatial空间信息管理(英文原版)第2页
Oracle Spatial空间信息管理(英文原版)第3页
Oracle Spatial空间信息管理(英文原版)第4页
Oracle Spatial空间信息管理(英文原版)第5页
Oracle Spatial空间信息管理(英文原版)第6页
Oracle Spatial空间信息管理(英文原版)第7页
Oracle Spatial空间信息管理(英文原版)第8页
Oracle Spatial空间信息管理(英文原版)第9页
Oracle Spatial空间信息管理(英文原版)第10页
Oracle Spatial空间信息管理(英文原版)第11页
Oracle Spatial空间信息管理(英文原版)第12页
Oracle Spatial空间信息管理(英文原版)第13页
Oracle Spatial空间信息管理(英文原版)第14页
Oracle Spatial空间信息管理(英文原版)第15页
Oracle Spatial空间信息管理(英文原版)第16页
Oracle Spatial空间信息管理(英文原版)第17页
Oracle Spatial空间信息管理(英文原版)第18页
Oracle Spatial空间信息管理(英文原版)第19页
Oracle Spatial空间信息管理(英文原版)第20页

试读结束, 可继续阅读

23积分/C币 立即下载