Packt+ | Advance your knowledge in tech

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

SQL

Concepts

Geospatial Analysis

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

Appendix A. Table Comparing Simple Feature Access/SQL and SQL/MM–Spatial

This appendix provides a comparison of SFA-SQL 1.2 (http://portal.opengeospatial.org/files/?artifact_id=25354) and SQL/MM-Spatial (ISO 13249-3, Information technology - Database languages - SQL Multimedia and Application Packages - Part 3: Spatial) by reproducing Table B 1 from Annex B of SFA-SQL 1.2 Part 2:

	SQL with geometry type	ISO/IEC 13249-3:2003 (SQL/MM-Spatial)	Description
Geometry types	Point	`ST_Point`	The type `ST_PolyhedralSurface` is currently not in SQL/MM, but will be proposed as a result of this document
	Curve	`ST_Curve`
	Linestring	`ST_LinestringST_Circularstring ST_CompoundCurve`
	Surface	`ST_Surface` `ST_CurvePolygon`
	Polygon	`ST_Polygon`
	PolyhedralSurface	`ST_PolyhedralSurface`
	GeomCollection	`ST_Collection`
	Multipoint	`ST_Multipoint`
	Multicurve	`ST_MultiCurve`
	Multilinestring	`ST_Multilinestring`
	Multisurface	`ST_Multisurface`
	Multipolygon	`ST_Multipolygon`
Storage	Binary Type, Text Type, Object Type	Object Type
Operations	Equals	`ST_Equals`
	Disjoint	`ST_Disjoint`
	Touches	`ST_Touches`
	Within	`ST_Within`
	Overlaps	`ST_Overlaps`
	Crosses	`ST_Crosses`
	Intersects	`ST_Intersects`
	Contains	`ST_Contains`
	Relate	`ST_Relate`
Functions	—	—	—
Point	—	`ST_Point()`	It returns the point
	`X()`	`ST_X()`	It returns the X-coordinate of the point
	`Y()`	`ST_Y()`	It returns the Y-coordinate of the point
	`Z()`	`ST_Z()`	It return the Z-coordinate of the point
	`M()`	`ST_M()`	It returns the M-coordinate of the point
	—	`ST_ExplicitPoint()`	—
Curve	`Length()`	`ST_Length()`	It returns the length of the curve
	`StartPoint()`	`ST_StartPoint()`	It returns the first point of the curve
	`EndPoint()`	`ST_EndPoint()`	It returns the last point of the curve
	`IsClosed()`	`ST_IsClosed()`	It checks whether the curve is closed
	`IsRing()`	`ST_ISRing()`	It check if the curve is closed and simple
	—	`ST_CurveToLine`	It transforms a curve to `LineString`
LineString	—	`ST_LineString`	It returns `LineString`
	—	`ST_Points`	It returns a collection of points
	`NumPoints()`	`ST_NumPoints`	It returns the number of points
	`PointN()`	`ST_PointN`	It returns the nth point of `LineString`

The rest of the chapter is locked

You're reading from Applying and Extending Oracle Spatial

Table of Contents (20) Chapters

Appendix A. Table Comparing Simple Feature Access/SQL and SQL/MM–Spatial

Unlock this book and the full library FREE for 7 days

Personalised recommendations for you