ISO/IEC 13249-3:2011
(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
ISO/IEC 13249-3:2011 defines spatial user-defined types, routines and schemas for generic spatial data handling. It addresses the need to store, manage and retrieve information based on aspects of spatial data such as geometry, location and topology. Implementations of ISO/IEC 13249-3:2011 may exist in environments that also support geographic information, decision support, data mining, and data warehousing systems. Application areas addressed by implementations of ISO/IEC 13249-3:2011 include, but are not restricted to, automated mapping, desktop mapping, facilities management, geoengineering, graphics, location-based services, terrain modelling, multimedia, and resource management applications.
Technologies de l'information — Langages de bases de données — Multimédia SQL et paquetages d'application — Partie 3: Spatial
General Information
Relations
Buy Standard
Standards Content (Sample)
INTERNATIONAL ISO/IEC
STANDARD 13249-3
Fourth edition
2011-04-15
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 FDIS 13249-3:2011(E)
©
ISO/IEC 2011
---------------------- Page: 1 ----------------------
ISO/IEC FDIS 13249-3:2011(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.
COPYRIGHT PROTECTED DOCUMENT
© ISO/IEC 2011
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 749 09 47
E-mail copyright@iso.org
Web www.iso.org
Published in Switzerland
ii © ISO/IEC 2011 – All rights reserved
---------------------- Page: 2 ----------------------
ISO/IEC 13249-3:2011(E)
Contents Page
Foreword .xii
Introduction.xiii
1 Scope.1
2 Normative references.1
3 Terms and definitions, notations, and conventions .1
3.1 Terms and definitions .1
3.1.1 Terms and definitions provided in ISO/IEC 13249-1.1
3.1.2 Terms and definitions provided in this part of ISO/IEC 13249 .1
3.1.3 Terms and definitions taken from ISO 19107 .7
3.1.4 Terms and definitions taken from ISO 19111 .8
3.2 Notations .8
3.2.1 Notations provided in ISO/IEC 13249-1.8
3.2.2 Notations provided in this part of ISO/IEC 13249 .8
3.3 Conventions.9
4 Concepts .10
4.1 Concepts provided in Part 1.10
4.2 Geometry Types .10
4.2.1 ST_Geometry .10
4.2.2 Spatial Relationships using ST_Geometry.17
4.2.3 ST_Point .22
4.2.4 ST_Curve.22
4.2.5 ST_LineString .23
4.2.6 ST_CircularString.23
4.2.7 ST_CompoundCurve.24
4.2.8 ST_Surface.25
4.2.9 ST_CurvePolygon.25
4.2.10 ST_Polygon.26
4.2.11 ST_Triangle .27
4.2.12 ST_PolyhdrlSurface .27
4.2.13 ST_TIN .28
4.2.14 ST_GeomCollection .28
4.2.15 ST_MultiPoint.29
4.2.16 ST_MultiCurve .29
4.2.17 ST_MultiLineString.30
4.2.18 ST_MultiSurface .30
4.2.19 ST_MultiPolygon .31
4.3 Topology-Geometry .32
4.3.1 .ST_NODE .32
4.3.2 .ST_EDGE.33
4.3.3 .ST_FACE .35
4.4 Topology-Network.38
4.4.1 .ST_NODE.38
4.4.2 .ST_LINK.38
4.5 General Routines.41
4.5.1 ST_ShortestUndPath Function .41
4.5.2 ST_ShortestDirPath Function .41
4.6 Spatial Reference System Type .42
4.6.1 ST_SpatialRefSys.42
4.7 Angle and Direction Types .42
4.7.1 ST_Angle .42
© ISO/IEC 2011 – All rights reserved iii
---------------------- Page: 3 ----------------------
ISO/IEC 13249-3:2011(E)
4.7.2 ST_Direction. 43
4.8 Support Types. 44
4.8.1 ST_TINElement. 44
4.9 Support Routines. 45
4.9.1 ST_Geometry ARRAY Support Routines . 45
4.10 Tables with columns using geometry types . 46
4.11 The Spatial Information Schema. 46
5 Geometry Types. 47
5.1 ST_Geometry Type and Routines . 47
5.1.1 ST_Geometry Type . 47
5.1.2 ST_Dimension Method . 59
5.1.3 ST_CoordDim Method . 60
5.1.4 ST_GeometryType Method . 61
5.1.5 ST_SRID Methods. 63
5.1.6 ST_Transform Method. 64
5.1.7 ST_IsEmpty Method. 65
5.1.8 ST_IsSimple Method. 66
5.1.9 ST_3DIsSimple Method . 67
5.1.10 ST_IsValid Method. 68
5.1.11 ST_Is3D Method. 69
5.1.12 ST_IsMeasured Method. 70
5.1.13 ST_LocateAlong Method. 71
5.1.14 ST_3DLocateAlong Method. 72
5.1.15 ST_LocateBetween Method. 73
5.1.16 ST_3DLocateBetween Method . 75
5.1.17 ST_Boundary Method. 77
5.1.18 ST_3DBoundary Method . 78
5.1.19 ST_Envelope Method . 79
5.1.20 ST_ConvexHull Method. 80
5.1.21 ST_Buffer Methods. 81
5.1.22 ST_Intersection Method . 83
5.1.23 ST_3DIntersection Method . 84
5.1.24 ST_Union Method . 85
5.1.25 ST_3DUnion Method. 86
5.1.26 ST_Difference Method. 87
5.1.27 ST_3DDifference Method . 88
5.1.28 ST_SymDifference Method . 89
5.1.29 ST_3DSymDifference Method. 90
5.1.30 Return Types from ST_Intersection, ST_Union, ST_Difference, and ST_SymDifference. 91
5.1.31 Return Types from ST_3DIntersection, ST_3DUnion, ST_3DDifference, and
ST_3DSymDifference. 94
5.1.32 ST_Distance Methods . 95
5.1.33 ST_3DDistance Methods. 97
5.1.34 ST_Equals Method. 99
5.1.35 ST_3DEquals Method . 100
5.1.36 ST_Relate Method. 101
5.1.37 ST_Disjoint Method . 105
5.1.38 ST_3DDisjoint Method. 106
5.1.39 ST_Intersects Method . 107
5.1.40 ST_3DIntersects Method. 108
5.1.41 ST_Touches Method. 109
5.1.42 ST_Crosses Method . 110
5.1.43 ST_Within Method. 111
5.1.44 ST_Contains Method . 112
5.1.45 ST_Overlaps Method . 113
5.1.46 Cast . 114
5.1.47 ST_WKTToSQL Method . 126
5.1.48 ST_AsText Method. 127
5.1.49 ST_WKBToSQL Method . 128
iv © ISO/IEC 2011 – All rights reserved
---------------------- Page: 4 ----------------------
ISO/IEC 13249-3:2011(E)
5.1.50 ST_AsBinary Method .129
5.1.51 ST_GMLToSQL Method .130
5.1.52 ST_AsGML Method.132
5.1.53 ST_GeomFromText Functions .133
5.1.54 ST_GeomFromWKB Functions.134
5.1.55 ST_GeomFromGML Functions .135
5.1.56 ST_Geometry Ordering Definition .137
5.1.57 SQL Transform Functions .138
5.1.58 .139
5.1.59 .151
6 Point Types .182
6.1 ST_Point Type and Routines.182
6.1.1 ST_Point Type.182
6.1.2 ST_Point Methods .187
6.1.3 ST_X Methods.194
6.1.4 ST_Y Methods.195
6.1.5 ST_Z Methods .196
6.1.6 ST_M Methods .197
6.1.7 ST_ExplicitPoint Method .198
6.1.8 ST_PointFromText Functions .199
6.1.9 ST_PointFromWKB Functions .200
6.1.10 ST_PointFromGML Functions.201
7 Curve Types .202
7.1 ST_Curve Type and Routines .202
7.1.1 ST_Curve Type .202
7.1.2 ST_Length Methods .205
7.1.3 ST_3DLength Methods.207
7.1.4 ST_StartPoint Method.209
7.1.5 ST_EndPoint Method .210
7.1.6 ST_IsClosed Method .211
7.1.7 ST_3DIsClosed Method.212
7.1.8 ST_IsRing Method .213
7.1.9 ST_3DIsRing Method.214
7.1.10 ST_CurveToLine Method .215
7.2 ST_LineString Type and Routines.216
7.2.1 ST_LineString Type.216
7.2.2 ST_LineString Methods .219
7.2.3 ST_Points Methods .221
7.2.4 ST_NumPoints Method .223
7.2.5 ST_PointN Method.224
7.2.6 ST_StartPoint Method.225
7.2.7 ST_EndPoint Method .226
7.2.8 ST_LineFromText Functions.227
7.2.9 ST_LineFromWKB Functions.228
7.2.10 ST_LineFromGML Functions .229
7.3 ST_CircularString Type and Routines.230
7.3.1 ST_CircularString Type .230
7.3.2 ST_CircularString Methods .234
7.3.3 ST_Points Methods .236
7.3.4 ST_NumPoints Method .238
7.3.5 ST_PointN Method.239
7.3.6 ST_MidPointRep Method .240
7.3.7 ST_StartPoint Method.241
7.3.8 ST_EndPoint Method .242
7.3.9 ST_CircularFromTxt Functions.243
7.3.10 ST_CircularFromWKB Functions .244
7.3.11 ST_CircularFromGML Functions.245
7.4 ST_CompoundCurve Type and Routines .246
7.4.1 ST_CompoundCurve Type .246
© ISO/IEC 2011 – All rights reserved v
---------------------- Page: 5 ----------------------
ISO/IEC 13249-3:2011(E)
7.4.2 ST_CompoundCurve Methods . 250
7.4.3 ST_Curves Methods . 253
7.4.4 ST_NumCurves Method . 255
7.4.5 ST_CurveN Method. 256
7.4.6 ST_StartPoint Method . 257
7.4.7 ST_EndPoint Method. 258
7.4.8 ST_CompoundFromTxt Functions. 259
7.4.9 ST_CompoundFromWKB Functions . 260
7.4.10 ST_CompoundFromGML Functions. 261
8 Surface Types . 262
8.1 ST_Surface Type and Routines. 262
8.1.1 ST_Surface Type. 262
8.1.2 ST_Area Methods. 265
8.1.3 ST_3DArea Methods. 267
8.1.4 ST_Perimeter Methods. 269
8.1.5 ST_3DPerimeter Methods . 271
8.1.6 ST_Centroid Method. 273
8.1.7 ST_3DCentroid Method .
...
INTERNATIONAL ISO/IEC
STANDARD 13249-3
Fourth edition
2011-04-15
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:2011(E)
©
ISO/IEC 2011
---------------------- Page: 1 ----------------------
ISO/IEC 13249-3:2011(E)
PDF disclaimer
PDF files may contain embedded typefaces. In accordance with Adobe's licensing policy, such files 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 a PDF 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 the PDF file(s) constituting this document can be found in the General Info relative to
the file(s); the PDF-creation parameters were optimized for printing. Every care has been taken to ensure that the files are suitable for
use by ISO member bodies. In the unlikely event that a problem relating to them is found, please inform the Central Secretariat at the
address given below.
This CD-ROM contains the publication ISO/IEC 13249-3:2011 in portable document format (PDF), which can
be viewed using Adobe® Acrobat® Reader.
Adobe and Acrobat are trademarks of Adobe Systems Incorporated.
This fourth edition cancels and replaces the third edition (ISO/IEC 13249-3:2006), which has been technically
revised.
© ISO/IEC 2011
All rights reserved. Unless otherwise specified, no part of this CD-ROM may be reproduced, stored in a retrieval system or transmitted in
any form or by any means without prior permission from ISO. Requests for permission to reproduce this product should be addressed to
ISO copyright office • C
...
Questions, Comments and Discussion
Ask us and Technical Secretary will try to provide an answer. You can facilitate discussion about the standard in here.