Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Applying and Extending Oracle Spatial

You're reading from  Applying and Extending Oracle Spatial

Product type Book
Published in Sep 2013
Publisher Packt
ISBN-13 9781849686365
Pages 568 pages
Edition 1st Edition
Languages

Table of Contents (20) Chapters

Applying and Extending Oracle Spatial
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
1. Defining a Data Model for Spatial Data Storage 2. Importing and Exporting Spatial Data 3. Using Database Features in Spatial Applications 4. Replicating Geometries 5. Partitioning of Data Using Spatial Keys 6. Implementing New Functions 7. Editing, Transforming, and Constructing Geometries 8. Using and Imitating Linear Referencing Functions 9. Raster Analysis with GeoRaster 10. Integrating Java Technologies with Oracle Spatial 11. SQL/MM – A Basis for Cross-platform, Inter-operable, and Reusable SQL Table Comparing Simple Feature Access/SQL and SQL/MM–Spatial
Use of TREAT and IS OF TYPE with ST_GEOMETRY Index

Understanding linear referencing and measures


All geographic representations stored in the SDO_GEOMETRY object are just that: representations. The linestring describing a pipe is not the pipe; the linestring describing a road in a GPS in-car navigation unit is not the road: they are scale-dependent representations of the middle of the pipe (an imaginary line drawn down the center of the pipe) or the middle of a marked lane for traffic on a road.

By scale-dependent is meant that the position of each vertex in the linestring has a locational "vagueness". The amount of location vagueness depends on the source of its measurement. A position measured by a surveyor using a modern electronic theodolite may be accurate to +/- 5mm; a GPS observation +/- 10cm; an old 1:1000 map from a roads department, +/- 2m.

Regardless as to capture method, each linestring's representation has an implicit length (measured by SDO_GEOM.Sdo_Length or the T_GEOMETRY.ST_Length method) property, but this length is also...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}