ISO/IEC 13249-3:1999
(Main)Information technology — Database languages — SQL Multimedia and Application Packages — Part 3: Spatial
Information technology — Database languages — SQL Multimedia and Application Packages — Part 3: Spatial
Technologies de l'information — Langages de bases de données — Multimédia SQL et paquetages d'application — Partie 3: Spatial
General Information
Relations
Standards Content (Sample)
INTERNATIONAL ISO/IEC
STANDARD 13249-3
First edition
1999-12-01
Information technology — Database
languages — SQL Multimedia and
Application Packages —
Part 3:
Spatial
Technologies de l'information — Langages de bases de données —
Multimédia SQL et paquetages d'application —
Partie 3: Spatial
Reference number
ISO/IEC 13249-3:1999(E)
©
ISO/IEC 1999
---------------------- Page: 1 ----------------------
ISO/IEC 13249-3:1999(E)
PDF disclaimer
This PDF file may contain embedded typefaces. In accordance with Adobe's licensing policy, this file may be printed or viewed but shall not
be edited unless the typefaces which are embedded are licensed to and installed on the computer performing the editing. In downloading this
file, parties accept therein the responsibility of not infringing Adobe's licensing policy. The ISO Central Secretariat accepts no liability in this
area.
Adobe is a trademark of Adobe Systems Incorporated.
Details of the software products used to create this PDF file can be found in the General Info relative to the file; the PDF-creation parameters
were optimized for printing. Every care has been taken to ensure that the file is suitable for use by ISO member bodies. In the unlikely event
that a problem relating to it is found, please inform the Central Secretariat at the address given below.
© ISO/IEC 1999
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any form or by any means, electronic
or mechanical, including photocopying and microfilm, without permission in writing from either ISO at the address below or ISO's member body
in the country of the requester.
ISO copyright office
Case postale 56 � CH-1211 Geneva 20
Tel. + 41 22 749 01 11
Fax + 41 22 734 10 79
E-mail copyright@iso.ch
Web www.iso.ch
Printed in Switzerland
ii © ISO/IEC 1999 – All rights reserved
---------------------- Page: 2 ----------------------
ãã ISO/IEC 13249-3:1999 (E)
Page
Foreword
Introductionx
11
2Normative references3
3Definitions, notations, and conventions5
Definitions5
Definitions provided in Part 15
Definitions provided in Part 35
Definitions taken from ISO/IEC 90756
Definitions taken from ISO 15046-77
Definitions taken from ISO 15046-119
Notations
Notations provided in Part 1
Notations provided in Part 3
Conventions
4Concepts
Geometry Types
ST_Geometry
Spatial Relationships using ST_Geometry
Columns of type ST_Geometry
ST_Point
ST_Curve
ST_LineString
ST_CircularString
ST_CompoundCurve
ST_Surface
4.1.10 ST_CurvePolygon
4.1.11 ST_Polygon
4.1.12 ST_GeomCollection
4.1.13 ST_MultiPoint
4.1.14 ST_MultiCurve
4.1.15 ST_MultiLineString
4.1.16 ST_MultiSurface
4.1.17 ST_MultiPolygon
Spatial Reference System Type
ST_SpatialRefSys
Support Routines
ST_Geometry ARRAY Support Routines
5Geometry Types
ST_Geometry Type and Routines
ST_Geometry Type
ST_Dimension Method
ST_CoordDim Method
ST_GeometryType Method
ST_SRID Methods
ST_Transform Method
ST_IsEmpty Method
ST_IsSimple Method
ST_IsValid Method
5.1.10 ST_Boundary Method
Contents
iii
45 . . . .
44 . . . . 5.1.9
43 . . . . 5.1.8
42 . . . . 5.1.7
41 . . . . 5.1.6
40 . . . . 5.1.5
38 . . . . 5.1.4
37 . . . . 5.1.3
36 . . . . 5.1.2
29 . . . . 5.1.1
29 . . . 5.1
29 . . . .
27 . . . 4.3.1
27 . . . . 4.3
26 . . . . 4.2.1
26 . . . . 4.2
25 . . . .
25 . . . .
24 . . . .
24 . . . .
23 . . . .
23 . . . .
23 . . . . .
22 . . . .
22 . . . . . 4.1.9
21 . . . . 4.1.8
20 . . . . 4.1.7
20 . . . . 4.1.6
19 . . . . . 4.1.5
19 . . . . . 4.1.4
18 . . . . 4.1.3
13 . . . 4.1.2
11 . . . . 4.1.1
11 . . . . 4.1
11 . . . . .
10 . . . . . 3.3
10 . . . . 3.2.2
10 . . . . 3.2.1
10 . . . . . 3.2
............................ ................................ ................................ 3.1.5
.............................. ................................ ................................ 3.1.4
............................ ................................ ................................ 3.1.3
....... ................................ ................................ ................................ 3.1.2
....... ................................ ................................ ................................ 3.1.1
....... ................................ ................................ ................................ ................................ 3.1
...................... ................................ ................................
..................... ................................ ................................ ................................
............... ................................ ................................ ................................ ................................ Scope
................. ................................ ................................ ................................ ................................
ix . . . . .
Contents
ISO/IEC
---------------------- Page: 3 ----------------------
ISO/IEC 13249-3:1999 (E) ãã
5.1.11 ST_Envelope Method
5.1.12 ST_ConvexHull Method
5.1.13 ST_B uffer Method
5.1.14 ST_Intersection Method
5.1.15 ST_Union Method
5.1.16 ST_Difference Method
5.1.17 ST_SymDifference Method
5.1.18 Return Types from ST_Intersection, ST_Union, ST_Difference, and ST_SymDifference
5.1.19 ST_Distance Method
5.1.20 ST_Equals Method
5.1.21 ST_Relate Method
5.1.22 ST_Disjoint Method
5.1.23 ST_Intersects Method
5.1.24 ST_Touches Method
5.1.25 ST_Crosses Method
5.1.26 ST_Within Method
5.1.27 ST_Contains Method
5.1.28 ST_Overlaps Method
5.1.29 ST_WKTToSQL Method
5.1.30 ST_AsText Method
5.1.31 ST_WKBToSQL Method
5.1.32 ST_AsBinary Method
5.1.33 ST_GeomFromText Functions
5.1.34 ST_GeomFromWKB Functions
5.1.35 ST_OrderingEquals Function
5.1.36 SQL Transform Functions
6Point Types
ST_Point Type and Routines
ST_Point Type
ST_Point Methods
ST_X Methods
ST_Y Methods
ST_ExplicitPoint Method
ST_PointFromText Functions
ST_PointFromWKB Functions
7Curve Types
ST_Curve Type and Routines
ST_Curve Type
ST_Length M ethod
ST_StartPoint Method
ST_EndPoint Method
ST_IsClosed Method
ST_IsRing Method
ST_CurveToLine Method
ST_LineString Type and Routines
ST_LineString Type
ST_LineString Methods
ST_Points Methods
ST_NumPoints Method
ST_PointN Method
ST_StartPoint Method
ST_EndPoint Method
ST_LineF romText Functions
ST_LineFromWKB Functions
ST_CircularString Type and Routines
ST_CircularString Type
ST_CircularString Methods
ST_Points Methods
ST_NumPoints Method
iv
136 . . . . 7.3.4
134 . . . . 7.3.3
133 . . . . 7.3.2
129 . . . . 7.3.1
129 . . . 7.3
127 . . . . 7.2.9
125 . . . . 7.2.8
124 . . . . 7.2.7
123 . . . . 7.2.6
122 . . . . 7.2.5
121 . . . . 7.2.4
119 . . . . 7.2.3
118 . . . . 7.2.2
115 . . . . 7.2.1
115 . . . 7.2
114 . . . . 7.1.7
113 . . . . 7.1.6
112 . . . . 7.1.5
111 . . . . 7.1.4
110 . . . . 7.1.3
109 . . . . 7.1.2
107 . . . . 7.1.1
107 . . . . 7.1
107 . . . .
105 . . . . 6.1.7
103 . . . . 6.1.6
102 . . . . 6.1.5
101 . . . . 6.1.4
100 . . . . 6.1.3
98 . . . . 6.1.2
95 . . . . 6.1.1
95 . . . . 6.1
95 . . . . .
93 . . . .
92 . . . .
90 . . . .
88 . . . .
87 . . . .
80 . . . .
79 . . . .
69 . . . .
68 . . . .
67 . . . .
66 . . . .
64 . . . .
63 . . . .
62 . . . .
61 . . . .
58 . . . .
57 . . . .
56 . . . .
53 .
52 . . . .
51 . . . .
50 . . . .
49 . . . .
48 . . . .
47 . . . .
46 . . . .
ISO/IEC
---------------------- Page: 4 ----------------------
ãã ISO/IEC 13249-3:1999 (E)
ST_PointN Method
ST_MidPointRep Method
ST_StartPoint Method
ST_EndPoint Method
ST_CircularFromText Functions
7.3.10 ST_CircularFromWKB Functions
ST_CompoundCurve Type and Routines
ST_CompoundCurve Type
ST_CompoundCurve Methods
ST_Curves Methods
ST_NumCurve s Method
ST_CurveN Method
ST_StartPoint Method
ST_EndPoint Method
ST_CompoundFromText Functions
ST_CompoundFromWKB Functions
8Surface Types
ST_Surface Type and Routines
ST_Surface Type
ST_Area Method
ST_Perimeter Method
ST_Centroid Method
ST_PointOnSurface Method
ST_CurvePolygon Type and Routines
ST_CurvePolygon Type
ST_CurvePolygon Methods
ST_ExteriorRing Methods
ST_InteriorRings Methods
ST_NumI nteriorRing Method
ST_InteriorRingN Method
ST_CurvePolyToPoly Method
ST_CPolyFromText Functions
ST_CPolyFromWKB Functions.
ST_Polygon Type and Routines
ST_Polygon Type
ST_Polygon Methods
ST_ExteriorRing Methods
ST_InteriorRings Methods
ST_InteriorRingN Method
ST_PolyFromText Functions
ST_PolyFromWKB Functions
ST_BdPolyFromText Functions
ST_BdPolyFromWKB Functions
9Geometry Collection Types
ST_GeomCollection Type and Routines
ST_GeomCollection Type
ST_GeomCollection Methods
ST_Geometries Methods
ST_NumGeometries Method
ST_Geometr yN Method
ST_GeomCollFromTxt Functions
ST_GeomCollFromWKB Functions
ST_MultiPoint Type and Routines
ST_MultiPoint Type
ST_MultiPoint Methods
ST_Geometries Methods
ST_MPointFromText Functions
ST_MPointFromWKB Functions
ST_MultiCurve Type and Routines
Contents v
225 . . . 9.3
223 . . . 9.2.5
221 . . . 9.2.4
219 . . . . 9.2.3
218 . . . . 9.2.2
216 . . . . 9.2.1
216 . . . 9.2
214 . . . 9.1.7
212 . . . 9.1.6
211 . . . . 9.1.5
210 . . . . 9.1.4
208 . . . . 9.1.3
206 . . . . 9.1.2
203 . . . . 9.1.1
203 . . . 9.1
203 . . . .
201 . . . 8.3.9
199 . . . 8.3.8
197 . . . . 8.3.7
195 . . . . 8.3.6
194 . . . . 8.3.5
192 . . . . 8.3.4
191 . . . . 8.3.3
188 . . . . 8.3.2
185 . . . . 8.3.1
185 . . . 8.3
183 . . . 8.2.9
181 . . . . 8.2.8
180 . . . . 8.2.7
179 . . . . 8.2.6
178 . . . . 8.2.5
175 . . . . 8.2.4
173 . . . . 8.2.3
171 . . . . 8.2.2
167 . . . . 8.2.1
167 . . . 8.2
166 . . . . 8.1.5
165 . . . . 8.1.4
164 . . . . 8.1.3
163 . . . . 8.1.2
161 . . . . 8.1.1
161 . . . 8.1
161 . . . .
158 . . . 7.4.9
156 . . . 7.4.8
155 . . . . 7.4.7
154 . . . . 7.4.6
153 . . . . 7.4.5
152 . . . . 7.4.4
150 . . . . 7.4.3
148 . . . . 7.4.2
145 . . . . 7.4.1
145 . . . 7.4
143 . . .
141 . . . 7.3.9
140 . . . . 7.3.8
139 . . . . 7.3.7
138 . . . . 7.3.6
137 . . . . 7.3.5
ISO/IEC
---------------------- Page: 5 ----------------------
ISO/IEC 13249-3:1999 (E) ãã
ST_MultiCurve Type
ST_MultiCurve Methods
ST_IsClosed Method
ST_Length Method
ST_Geometries Methods
ST_MCurveFromText Functions
ST_MCurveFromWKB Functions
ST_MultiLineString Type and Routines
ST_MultiLineString Type
ST_MultiLineString Methods
ST_Geometries Methods
ST_MLineFromText Functions
ST_MLineFromWKB Functions
ST_MultiSurface Type and Routines
ST_MultiSurface Type
ST_MultiSurface Methods
ST_Area Method
ST_Perimeter Method
ST_Centroid Method
ST_PointOnSurface Method
ST_Geometries Methods
ST_MSurfaceFromTxt Functions
ST_MSurfaceFromWKB Functions
ST_MultiPolygon Type and Routines
ST_MultiPolygon Type
ST_MultiPolygon Methods
ST_Geometries Methods
ST_MPolyFromText Functions.
ST_MPolyFromWKB Funct ions
ST_BdMPolyFromText Functions
ST_BdMPolyFromWKB Functions
Spatial Reference System Type
ST_SpatialRefSys Type and Ro utines
10.1.1 ST_SpatialRefSys Type
10.1.2 ST_SpatialRefSys Methods
10.1.3 ST_AsWKTSRS Method
10.1.4 ST_WKTSRSToSQL Method
10.1.5 ST_SRID Method
10.1.6 ST_Equals Method
10.1.7 ST_OrderingEquals Function
10.1.8 ST_WellKnownText SQL Transform Group
Support Routines
ST_Geometry ARRAY Support Routines
11.1.1 ST_MinDimension Function
11.1.2 ST_MaxDimension Function
11.1.3 ST_IsMixedDim Function
11.1.4 ST_CheckSRID Function
11.1.5 ST_CheckNulls Procedure
11.1.6 ST_CheckConsecDups Procedure
11.1.7 ST_ToPointAry Cast Function
11.1.8 ST_ToCurveAry Cast Function.
11.1.9 ST_ToLineStringAry Cast Function
11.1.10 ST_ToCircularAry Cast Function
11.1.11 ST_ToCompoundAry Cast Function
11.1.12 ST_ToSurfaceAry Cast Function
11.1.13 ST_ToCurvePolyAry Cast Function
11.1.14 ST_ToPolygonAry Cast Function
Conformance
Requirements for conformance
vi
311 . . . 12.1
311 . . . . 12
308 . . .
306 . . .
304 . . .
302 . . .
300 . . .
298 . . .
296 . . .
294 . . . .
293 . . .
292 . . . .
290 . . . .
289 . . . .
287 . . . .
285 . . . .
285 . . .
...
Questions, Comments and Discussion
Ask us and Technical Secretary will try to provide an answer. You can facilitate discussion about the standard in here.