ISO/IEC 13249-3:2016

FINAL
INTERNATIONAL ISO/IEC
DRAFT
STANDARD FDIS
13249-3
ISO/IEC JTC 1/SC 32
Information technology — Database
Secretariat: ANSI
languages — SQL multimedia and
Voting begins
on: 2015-09-30 application packages —
Voting terminates
Part 3:
on: 2015-11-30
Spatial
Technologies de l’information — Langages de bases de données —
Multimédia SQL et paquetages d’application —
Partie 3: Spatial
RECIPIENTS OF THIS DRAFT ARE INVITED TO
SUBMIT, WITH THEIR COMMENTS, NOTIFICATION
OF ANY RELEVANT PATENT RIGHTS OF WHICH
THEY ARE AWARE AND TO PROVIDE SUPPOR TING
DOCUMENTATION.
IN ADDITION TO THEIR EVALUATION AS
Reference number
BEING ACCEPTABLE FOR INDUSTRIAL, TECHNO-
ISO/IEC FDIS 13249-3:2015(E)
LOGICAL, COMMERCIAL AND USER PURPOSES,
DRAFT INTERNATIONAL STANDARDS MAY ON
OCCASION HAVE TO BE CONSIDERED IN THE
LIGHT OF THEIR POTENTIAL TO BECOME STAN-
DARDS TO WHICH REFERENCE MAY BE MADE IN
©
NATIONAL REGULATIONS. ISO/IEC 2015

ISO/IEC FDIS 13249-3:2015(E)
© ISO/IEC 2015, Published in Switzerland
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized otherwise in any form
or by any means, electronic or mechanical, including photocopying, or posting on the internet or an intranet, without prior
written permission. Permission can be requested from either ISO at the address below or ISO’s member body in the country of
the requester.
ISO copyright office
Ch. de Blandonnet 8 • CP 401
CH-1214 Vernier, Geneva, Switzerland
Tel. +41 22 749 01 11
Fax +41 22 749 09 47
copyright@iso.org
www.iso.org
ii © ISO/IEC 2015 – All rights reserved

ISO/IEC 13249-3:2015(E)
Contents Page
Foreword . xviii
Introduction . xix
1 Scope. 1
2 Normative references . 1
3 Terms and definitions, notations, and conventions . 2
3.1 Terms and definitions . 2
3.1.1 Terms and definitions provided in Part 1 . 2
3.1.2 Terms and definitions provided in Part 3 . 2
3.1.3 Terms and definitions taken from ISO 19107 . 7
3.1.4 Terms and definitions taken from ISO 19111 . 8
3.1.5 Terms and definitions taken from ISO 19148 . 8
3.2 Notations . 9
3.2.1 Notations provided in Part 1 . 9
3.2.2 Notations provided in Part 3 . 9
3.3 Conventions . 10
3.4 Extended BNF notation for WKT and WKB . 10
4 Concepts . 11
4.1 Concepts provided in Part 1 . 11
4.2 Geometry Types . 11
4.2.1 ST_Geometry . 11
4.2.2 Spatial Relationships using ST_Geometry. 19
4.2.3 ST_Point . 24
4.2.4 ST_Curve . 24
4.2.5 ST_LineString . 26
4.2.6 ST_CircularString . 26
4.2.7 ST_Circle . 28
4.2.8 ST_GeodesicString . 28
4.2.9 ST_EllipticalCurve . 29
4.2.10 ST_NURBSCurve . 30
4.2.11 ST_Clothoid . 31
4.2.12 ST_SpiralCurve . 32
4.2.13 ST_CompoundCurve . 33
4.2.14 ST_Surface . 33
4.2.15 ST_CurvePolygon . 34
4.2.16 ST_Polygon . 35
4.2.17 ST_Triangle . 35
4.2.18 ST_PolyhdrlSurface . 36
4.2.19 ST_TIN . 36
4.2.20 ST_CompoundSurface . 37
4.2.21 ST_Solid . 38
4.2.22 ST_BRepSolid . 38
4.2.23 ST_GeomCollection . 38
4.2.24 ST_MultiPoint . 39
4.2.25 ST_MultiCurve . 39
4.2.26 ST_MultiLineString . 40
4.2.27 ST_MultiSurface . 41
4.2.28 ST_MultiPolygon . 42
4.3 Topology-Geometry . 42
4.3.1 .ST_NODE . 43
4.3.2 .ST_EDGE . 43
4.3.3 .ST_FACE . 46
© ISO/IEC 2015 - All rights reserved iii

ISO/IEC 13249-3:2015(E)
4.4 Topology-Network . 49
4.4.1 .ST_NODE . 49
4.4.2 .ST_LINK . 49
4.5 General Routines . 52
4.5.1 ST_ShortestUndPath Function . 52
4.5.2 ST_ShortestDirPath Function . 53
4.6 Spatial Reference System Type . 53
4.6.1 ST_SpatialRefSys . 53
4.7 Linear Referencing Types . 53
4.7.1 ST_PositionExp . 53
4.7.2 ST_LinearElement . 54
4.7.3 ST_LRFeature . 55
4.7.4 ST_LRCurve . 55
4.7.5 ST_LRDirectedEdge . 56
4.7.6 ST_StartValue . 56
4.7.7 ST_LRM . 56
4.7.8 ST_DistanceExp . 57
4.7.9 ST_LRMeasure . 58
4.7.10 ST_Referent . 59
4.7.11 ST_LatOffsetExp . 59
4.7.12 ST_VerOffsetExp . 59
4.7.13 ST_VectorOffsetExp . 60
4.8 Angle and Direction Types . 60
4.8.1 ST_Angle . 60
4.8.2 ST_Direction . 61
4.9 Support Types . 63
4.9.1 ST_TINElement . 63
4.9.2 ST_Vector . 63
4.9.3 ST_AffinePlacement . 64
4.9.4 ST_NURBSPoint . 65
4.9.5 ST_Knot . 65
4.10 Support Routines . 65
4.10.1 ST_Geometry ARRAY and ST_Vector ARRAY Support Routines . 65
4.11 Tables with columns using geometry types . 67
4.12 The Spatial Information Schema . 67
5 Geometry Types . 68
5.1 ST_Geometry Type and Routines . 68
5.1.1 ST_Geometry Type . 68
5.1.2 ST_Dimension Method .
...