This is an automated email from the ASF dual-hosted git repository. jiayu pushed a commit to branch fix/issue-2678-accessor-visuals in repository https://gitbox.apache.org/repos/asf/sedona.git
commit c510be68397ac032f9cdb59e781bf989694db608 Author: Jia Yu <[email protected]> AuthorDate: Wed Mar 4 15:33:43 2026 -0800 [GH-2678] Add SVG visuals for geometry accessor functions --- docs/api/flink/Geometry-Accessors/GeometryType.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_Boundary.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_CoordDim.md | 2 ++ .../api/flink/Geometry-Accessors/ST_CrossesDateLine.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_Dimension.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_Dump.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_DumpPoints.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_EndPoint.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_ExteriorRing.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_GeometryN.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_GeometryType.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_HasM.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_HasZ.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_InteriorRingN.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_IsClosed.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_IsCollection.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_IsEmpty.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_IsPolygonCCW.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_IsPolygonCW.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_IsRing.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_IsSimple.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_M.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_NDims.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_NPoints.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_NRings.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_NumGeometries.md | 2 ++ .../api/flink/Geometry-Accessors/ST_NumInteriorRing.md | 2 ++ .../flink/Geometry-Accessors/ST_NumInteriorRings.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_NumPoints.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_PointN.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_Points.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_StartPoint.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_X.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_Y.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_Z.md | 2 ++ docs/api/flink/Geometry-Accessors/ST_Zmflag.md | 2 ++ .../vector-data/Geometry-Accessors/GeometryType.md | 2 ++ .../vector-data/Geometry-Accessors/ST_Boundary.md | 2 ++ .../vector-data/Geometry-Accessors/ST_CoordDim.md | 2 ++ .../Geometry-Accessors/ST_CrossesDateLine.md | 2 ++ .../vector-data/Geometry-Accessors/ST_Dimension.md | 2 ++ .../vector-data/Geometry-Accessors/ST_Dump.md | 2 ++ .../vector-data/Geometry-Accessors/ST_DumpPoints.md | 2 ++ .../vector-data/Geometry-Accessors/ST_EndPoint.md | 2 ++ .../vector-data/Geometry-Accessors/ST_ExteriorRing.md | 2 ++ .../vector-data/Geometry-Accessors/ST_GeometryN.md | 2 ++ .../vector-data/Geometry-Accessors/ST_GeometryType.md | 2 ++ .../vector-data/Geometry-Accessors/ST_HasZ.md | 2 ++ .../vector-data/Geometry-Accessors/ST_InteriorRingN.md | 2 ++ .../vector-data/Geometry-Accessors/ST_IsClosed.md | 2 ++ .../vector-data/Geometry-Accessors/ST_IsCollection.md | 2 ++ .../vector-data/Geometry-Accessors/ST_IsEmpty.md | 2 ++ .../vector-data/Geometry-Accessors/ST_IsPolygonCCW.md | 2 ++ .../vector-data/Geometry-Accessors/ST_IsPolygonCW.md | 2 ++ .../vector-data/Geometry-Accessors/ST_IsRing.md | 2 ++ .../vector-data/Geometry-Accessors/ST_IsSimple.md | 2 ++ .../vector-data/Geometry-Accessors/ST_NDims.md | 2 ++ .../vector-data/Geometry-Accessors/ST_NPoints.md | 2 ++ .../vector-data/Geometry-Accessors/ST_NRings.md | 2 ++ .../vector-data/Geometry-Accessors/ST_NumGeometries.md | 2 ++ .../Geometry-Accessors/ST_NumInteriorRing.md | 2 ++ .../Geometry-Accessors/ST_NumInteriorRings.md | 2 ++ .../vector-data/Geometry-Accessors/ST_NumPoints.md | 2 ++ .../vector-data/Geometry-Accessors/ST_PointN.md | 2 ++ .../vector-data/Geometry-Accessors/ST_Points.md | 2 ++ .../vector-data/Geometry-Accessors/ST_StartPoint.md | 2 ++ .../snowflake/vector-data/Geometry-Accessors/ST_X.md | 2 ++ .../snowflake/vector-data/Geometry-Accessors/ST_Y.md | 2 ++ .../snowflake/vector-data/Geometry-Accessors/ST_Z.md | 2 ++ docs/api/sql/Geometry-Accessors/GeometryType.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_Boundary.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_CoordDim.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_CrossesDateLine.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_Dimension.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_Dump.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_DumpPoints.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_EndPoint.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_ExteriorRing.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_GeometryN.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_GeometryType.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_HasM.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_HasZ.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_InteriorRingN.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_IsClosed.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_IsCollection.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_IsEmpty.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_IsPolygonCCW.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_IsPolygonCW.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_IsRing.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_IsSimple.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_M.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_NDims.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_NPoints.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_NRings.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_NumGeometries.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_NumInteriorRing.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_NumInteriorRings.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_NumPoints.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_PointN.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_Points.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_StartPoint.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_X.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_Y.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_Z.md | 2 ++ docs/api/sql/Geometry-Accessors/ST_Zmflag.md | 2 ++ docs/image/GeometryType/GeometryType.svg | 12 ++++++++++++ docs/image/ST_Boundary/ST_Boundary.svg | 11 +++++++++++ docs/image/ST_CoordDim/ST_CoordDim.svg | 12 ++++++++++++ docs/image/ST_CrossesDateLine/ST_CrossesDateLine.svg | 18 ++++++++++++++++++ docs/image/ST_Dimension/ST_Dimension.svg | 12 ++++++++++++ docs/image/ST_Dump/ST_Dump.svg | 13 +++++++++++++ docs/image/ST_DumpPoints/ST_DumpPoints.svg | 18 ++++++++++++++++++ docs/image/ST_EndPoint/ST_EndPoint.svg | 12 ++++++++++++ docs/image/ST_ExteriorRing/ST_ExteriorRing.svg | 12 ++++++++++++ docs/image/ST_GeometryN/ST_GeometryN.svg | 15 +++++++++++++++ docs/image/ST_GeometryType/ST_GeometryType.svg | 12 ++++++++++++ docs/image/ST_HasM/ST_HasM.svg | 12 ++++++++++++ docs/image/ST_HasZ/ST_HasZ.svg | 12 ++++++++++++ docs/image/ST_InteriorRingN/ST_InteriorRingN.svg | 14 ++++++++++++++ docs/image/ST_IsClosed/ST_IsClosed.svg | 16 ++++++++++++++++ docs/image/ST_IsCollection/ST_IsCollection.svg | 15 +++++++++++++++ docs/image/ST_IsEmpty/ST_IsEmpty.svg | 13 +++++++++++++ docs/image/ST_IsPolygonCCW/ST_IsPolygonCCW.svg | 16 ++++++++++++++++ docs/image/ST_IsPolygonCW/ST_IsPolygonCW.svg | 16 ++++++++++++++++ docs/image/ST_IsRing/ST_IsRing.svg | 16 ++++++++++++++++ docs/image/ST_IsSimple/ST_IsSimple.svg | 16 ++++++++++++++++ docs/image/ST_M/ST_M.svg | 12 ++++++++++++ docs/image/ST_NDims/ST_NDims.svg | 12 ++++++++++++ docs/image/ST_NPoints/ST_NPoints.svg | 16 ++++++++++++++++ docs/image/ST_NRings/ST_NRings.svg | 13 +++++++++++++ docs/image/ST_NumGeometries/ST_NumGeometries.svg | 14 ++++++++++++++ docs/image/ST_NumInteriorRing/ST_NumInteriorRing.svg | 14 ++++++++++++++ docs/image/ST_NumInteriorRings/ST_NumInteriorRings.svg | 14 ++++++++++++++ docs/image/ST_NumPoints/ST_NumPoints.svg | 16 ++++++++++++++++ docs/image/ST_PointN/ST_PointN.svg | 13 +++++++++++++ docs/image/ST_Points/ST_Points.svg | 15 +++++++++++++++ docs/image/ST_StartPoint/ST_StartPoint.svg | 12 ++++++++++++ docs/image/ST_X/ST_X.svg | 12 ++++++++++++ docs/image/ST_Y/ST_Y.svg | 12 ++++++++++++ docs/image/ST_Z/ST_Z.svg | 12 ++++++++++++ docs/image/ST_Zmflag/ST_Zmflag.svg | 13 +++++++++++++ 141 files changed, 703 insertions(+) diff --git a/docs/api/flink/Geometry-Accessors/GeometryType.md b/docs/api/flink/Geometry-Accessors/GeometryType.md index 761df83c53..da9ec492e7 100644 --- a/docs/api/flink/Geometry-Accessors/GeometryType.md +++ b/docs/api/flink/Geometry-Accessors/GeometryType.md @@ -21,6 +21,8 @@ Introduction: Returns the type of the geometry as a string. Eg: 'LINESTRING', 'POLYGON', 'MULTIPOINT', etc. This function also indicates if the geometry is measured, by returning a string of the form 'POINTM'. + + Format: `GeometryType (A: Geometry)` Return type: `String` diff --git a/docs/api/flink/Geometry-Accessors/ST_Boundary.md b/docs/api/flink/Geometry-Accessors/ST_Boundary.md index 1a18533d84..4a33f5a667 100644 --- a/docs/api/flink/Geometry-Accessors/ST_Boundary.md +++ b/docs/api/flink/Geometry-Accessors/ST_Boundary.md @@ -21,6 +21,8 @@ Introduction: Returns the closure of the combinatorial boundary of this Geometry. + + Format: `ST_Boundary(geom: Geometry)` Return type: `Geometry` diff --git a/docs/api/flink/Geometry-Accessors/ST_CoordDim.md b/docs/api/flink/Geometry-Accessors/ST_CoordDim.md index 80f29136a7..4b765cb093 100644 --- a/docs/api/flink/Geometry-Accessors/ST_CoordDim.md +++ b/docs/api/flink/Geometry-Accessors/ST_CoordDim.md @@ -21,6 +21,8 @@ Introduction: Returns the coordinate dimensions of the geometry. It is an alias of `ST_NDims`. + + Format: `ST_CoordDim(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/flink/Geometry-Accessors/ST_CrossesDateLine.md b/docs/api/flink/Geometry-Accessors/ST_CrossesDateLine.md index 0678887548..8e20e9f284 100644 --- a/docs/api/flink/Geometry-Accessors/ST_CrossesDateLine.md +++ b/docs/api/flink/Geometry-Accessors/ST_CrossesDateLine.md @@ -27,6 +27,8 @@ Introduction: This function determines if a given geometry crosses the Internati !!!note For multi-geometries (e.g., MultiPolygon, MultiLineString), this function will return true if any one of the geometries within the multi-geometry crosses the International Date Line. + + Format: `ST_CrossesDateLine(geometry: Geometry)` Return type: `Boolean` diff --git a/docs/api/flink/Geometry-Accessors/ST_Dimension.md b/docs/api/flink/Geometry-Accessors/ST_Dimension.md index 50199fce8b..5f77d90c4f 100644 --- a/docs/api/flink/Geometry-Accessors/ST_Dimension.md +++ b/docs/api/flink/Geometry-Accessors/ST_Dimension.md @@ -21,6 +21,8 @@ Introduction: Return the topological dimension of this Geometry object, which must be less than or equal to the coordinate dimension. OGC SPEC s2.1.1.1 - returns 0 for POINT, 1 for LINESTRING, 2 for POLYGON, and the largest dimension of the components of a GEOMETRYCOLLECTION. If the dimension is unknown (e.g. for an empty GEOMETRYCOLLECTION) 0 is returned. + + Format: `ST_Dimension (A: Geometry) | ST_Dimension (C: Geometrycollection)` Return type: `Integer` diff --git a/docs/api/flink/Geometry-Accessors/ST_Dump.md b/docs/api/flink/Geometry-Accessors/ST_Dump.md index 63a3eae19b..78b72832d4 100644 --- a/docs/api/flink/Geometry-Accessors/ST_Dump.md +++ b/docs/api/flink/Geometry-Accessors/ST_Dump.md @@ -22,6 +22,8 @@ Introduction: It expands the geometries. If the geometry is simple (Point, Polygon Linestring etc.) it returns the geometry itself, if the geometry is collection or multi it returns record for each of collection components. + + Format: `ST_Dump(geom: Geometry)` Return type: `Array<Geometry>` diff --git a/docs/api/flink/Geometry-Accessors/ST_DumpPoints.md b/docs/api/flink/Geometry-Accessors/ST_DumpPoints.md index 1535e1d821..06819746a0 100644 --- a/docs/api/flink/Geometry-Accessors/ST_DumpPoints.md +++ b/docs/api/flink/Geometry-Accessors/ST_DumpPoints.md @@ -21,6 +21,8 @@ Introduction: Returns list of Points which geometry consists of. + + Format: `ST_DumpPoints(geom: Geometry)` Return type: `Array<Geometry>` diff --git a/docs/api/flink/Geometry-Accessors/ST_EndPoint.md b/docs/api/flink/Geometry-Accessors/ST_EndPoint.md index e38b91d8fd..4c26e4eee0 100644 --- a/docs/api/flink/Geometry-Accessors/ST_EndPoint.md +++ b/docs/api/flink/Geometry-Accessors/ST_EndPoint.md @@ -21,6 +21,8 @@ Introduction: Returns last point of given linestring. + + Format: `ST_EndPoint(geom: Geometry)` Return type: `Geometry` diff --git a/docs/api/flink/Geometry-Accessors/ST_ExteriorRing.md b/docs/api/flink/Geometry-Accessors/ST_ExteriorRing.md index e960b76829..fdea25203f 100644 --- a/docs/api/flink/Geometry-Accessors/ST_ExteriorRing.md +++ b/docs/api/flink/Geometry-Accessors/ST_ExteriorRing.md @@ -21,6 +21,8 @@ Introduction: Returns a LINESTRING representing the exterior ring (shell) of a POLYGON. Returns NULL if the geometry is not a polygon. + + Format: `ST_ExteriorRing(A: Geometry)` Return type: `Geometry` diff --git a/docs/api/flink/Geometry-Accessors/ST_GeometryN.md b/docs/api/flink/Geometry-Accessors/ST_GeometryN.md index b1c4c3f2b1..c1b0afd79b 100644 --- a/docs/api/flink/Geometry-Accessors/ST_GeometryN.md +++ b/docs/api/flink/Geometry-Accessors/ST_GeometryN.md @@ -21,6 +21,8 @@ Introduction: Return the 0-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, (MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON. Otherwise, return null + + Format: `ST_GeometryN(geom: Geometry, n: Integer)` Return type: `Geometry` diff --git a/docs/api/flink/Geometry-Accessors/ST_GeometryType.md b/docs/api/flink/Geometry-Accessors/ST_GeometryType.md index 2f7bcd159f..2c2beb6584 100644 --- a/docs/api/flink/Geometry-Accessors/ST_GeometryType.md +++ b/docs/api/flink/Geometry-Accessors/ST_GeometryType.md @@ -21,6 +21,8 @@ Introduction: Returns the type of the geometry as a string. EG: 'ST_Linestring', 'ST_Polygon' etc. + + Format: `ST_GeometryType (A: Geometry)` Return type: `String` diff --git a/docs/api/flink/Geometry-Accessors/ST_HasM.md b/docs/api/flink/Geometry-Accessors/ST_HasM.md index b5ff25386e..7050a913a2 100644 --- a/docs/api/flink/Geometry-Accessors/ST_HasM.md +++ b/docs/api/flink/Geometry-Accessors/ST_HasM.md @@ -21,6 +21,8 @@ Introduction: Checks for the presence of M coordinate values representing measures or linear references. Returns true if the input geometry includes an M coordinate, false otherwise. + + Format: `ST_HasM(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/flink/Geometry-Accessors/ST_HasZ.md b/docs/api/flink/Geometry-Accessors/ST_HasZ.md index db31da11c9..f888698acd 100644 --- a/docs/api/flink/Geometry-Accessors/ST_HasZ.md +++ b/docs/api/flink/Geometry-Accessors/ST_HasZ.md @@ -21,6 +21,8 @@ Introduction: Checks for the presence of Z coordinate values representing measures or linear references. Returns true if the input geometry includes an Z coordinate, false otherwise. + + Format: `ST_HasZ(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/flink/Geometry-Accessors/ST_InteriorRingN.md b/docs/api/flink/Geometry-Accessors/ST_InteriorRingN.md index 442e3d88ec..3a08e5b38c 100644 --- a/docs/api/flink/Geometry-Accessors/ST_InteriorRingN.md +++ b/docs/api/flink/Geometry-Accessors/ST_InteriorRingN.md @@ -21,6 +21,8 @@ Introduction: Returns the Nth interior linestring ring of the polygon geometry. Returns NULL if the geometry is not a polygon or the given N is out of range + + Format: `ST_InteriorRingN(geom: Geometry, n: Integer)` Return type: `Geometry` diff --git a/docs/api/flink/Geometry-Accessors/ST_IsClosed.md b/docs/api/flink/Geometry-Accessors/ST_IsClosed.md index bece814e2a..28643eb70e 100644 --- a/docs/api/flink/Geometry-Accessors/ST_IsClosed.md +++ b/docs/api/flink/Geometry-Accessors/ST_IsClosed.md @@ -21,6 +21,8 @@ Introduction: RETURNS true if the LINESTRING start and end point are the same. + + Format: `ST_IsClosed(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/flink/Geometry-Accessors/ST_IsCollection.md b/docs/api/flink/Geometry-Accessors/ST_IsCollection.md index 688a2f4872..a5c524eecc 100644 --- a/docs/api/flink/Geometry-Accessors/ST_IsCollection.md +++ b/docs/api/flink/Geometry-Accessors/ST_IsCollection.md @@ -25,6 +25,8 @@ Collection types are the following: - GEOMETRYCOLLECTION - MULTI{POINT, POLYGON, LINESTRING} + + Format: `ST_IsCollection(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/flink/Geometry-Accessors/ST_IsEmpty.md b/docs/api/flink/Geometry-Accessors/ST_IsEmpty.md index db251d8f62..754e1ba065 100644 --- a/docs/api/flink/Geometry-Accessors/ST_IsEmpty.md +++ b/docs/api/flink/Geometry-Accessors/ST_IsEmpty.md @@ -21,6 +21,8 @@ Introduction: Test if a geometry is empty geometry + + Format: `ST_IsEmpty (A: Geometry)` Return type: `Boolean` diff --git a/docs/api/flink/Geometry-Accessors/ST_IsPolygonCCW.md b/docs/api/flink/Geometry-Accessors/ST_IsPolygonCCW.md index 39d8545254..e9343face7 100644 --- a/docs/api/flink/Geometry-Accessors/ST_IsPolygonCCW.md +++ b/docs/api/flink/Geometry-Accessors/ST_IsPolygonCCW.md @@ -21,6 +21,8 @@ Introduction: Returns true if all polygonal components in the input geometry have their exterior rings oriented counter-clockwise and interior rings oriented clockwise. + + Format: `ST_IsPolygonCCW(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/flink/Geometry-Accessors/ST_IsPolygonCW.md b/docs/api/flink/Geometry-Accessors/ST_IsPolygonCW.md index cb067f138e..cb32bc5bee 100644 --- a/docs/api/flink/Geometry-Accessors/ST_IsPolygonCW.md +++ b/docs/api/flink/Geometry-Accessors/ST_IsPolygonCW.md @@ -21,6 +21,8 @@ Introduction: Returns true if all polygonal components in the input geometry have their exterior rings oriented counter-clockwise and interior rings oriented clockwise. + + Format: `ST_IsPolygonCW(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/flink/Geometry-Accessors/ST_IsRing.md b/docs/api/flink/Geometry-Accessors/ST_IsRing.md index 28b64b56b8..4e9b381dd9 100644 --- a/docs/api/flink/Geometry-Accessors/ST_IsRing.md +++ b/docs/api/flink/Geometry-Accessors/ST_IsRing.md @@ -21,6 +21,8 @@ Introduction: RETURN true if LINESTRING is ST_IsClosed and ST_IsSimple. + + Format: `ST_IsRing(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/flink/Geometry-Accessors/ST_IsSimple.md b/docs/api/flink/Geometry-Accessors/ST_IsSimple.md index 3d9b15c2e8..3bc64ce194 100644 --- a/docs/api/flink/Geometry-Accessors/ST_IsSimple.md +++ b/docs/api/flink/Geometry-Accessors/ST_IsSimple.md @@ -21,6 +21,8 @@ Introduction: Test if geometry's only self-intersections are at boundary points. + + Format: `ST_IsSimple (A: Geometry)` Return type: `Boolean` diff --git a/docs/api/flink/Geometry-Accessors/ST_M.md b/docs/api/flink/Geometry-Accessors/ST_M.md index a63d0668a9..0d3383357d 100644 --- a/docs/api/flink/Geometry-Accessors/ST_M.md +++ b/docs/api/flink/Geometry-Accessors/ST_M.md @@ -21,6 +21,8 @@ Introduction: Returns M Coordinate of given Point, null otherwise. + + Format: `ST_M(geom: Geometry)` Return type: `Double` diff --git a/docs/api/flink/Geometry-Accessors/ST_NDims.md b/docs/api/flink/Geometry-Accessors/ST_NDims.md index c079208028..c198547562 100644 --- a/docs/api/flink/Geometry-Accessors/ST_NDims.md +++ b/docs/api/flink/Geometry-Accessors/ST_NDims.md @@ -21,6 +21,8 @@ Introduction: Returns the coordinate dimension of the geometry. + + Format: `ST_NDims(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/flink/Geometry-Accessors/ST_NPoints.md b/docs/api/flink/Geometry-Accessors/ST_NPoints.md index b0648e3b42..fbb4cb3381 100644 --- a/docs/api/flink/Geometry-Accessors/ST_NPoints.md +++ b/docs/api/flink/Geometry-Accessors/ST_NPoints.md @@ -21,6 +21,8 @@ Introduction: Returns the number of points of the geometry + + Format: `ST_NPoints (A: Geometry)` Return type: `Integer` diff --git a/docs/api/flink/Geometry-Accessors/ST_NRings.md b/docs/api/flink/Geometry-Accessors/ST_NRings.md index 77c0835640..f98ba2a68f 100644 --- a/docs/api/flink/Geometry-Accessors/ST_NRings.md +++ b/docs/api/flink/Geometry-Accessors/ST_NRings.md @@ -25,6 +25,8 @@ this function also takes into account the number of exterior rings. This function returns 0 for an empty Polygon or MultiPolygon. If the geometry is not a Polygon or MultiPolygon, an IllegalArgument Exception is thrown. + + Format: `ST_NRings(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/flink/Geometry-Accessors/ST_NumGeometries.md b/docs/api/flink/Geometry-Accessors/ST_NumGeometries.md index 5651c94c1c..0cbb739d9a 100644 --- a/docs/api/flink/Geometry-Accessors/ST_NumGeometries.md +++ b/docs/api/flink/Geometry-Accessors/ST_NumGeometries.md @@ -21,6 +21,8 @@ Introduction: Returns the number of Geometries. If geometry is a GEOMETRYCOLLECTION (or MULTI*) return the number of geometries, for single geometries will return 1. + + Format: `ST_NumGeometries (A: Geometry)` Return type: `Integer` diff --git a/docs/api/flink/Geometry-Accessors/ST_NumInteriorRing.md b/docs/api/flink/Geometry-Accessors/ST_NumInteriorRing.md index 9d7269ef05..7e83cafada 100644 --- a/docs/api/flink/Geometry-Accessors/ST_NumInteriorRing.md +++ b/docs/api/flink/Geometry-Accessors/ST_NumInteriorRing.md @@ -21,6 +21,8 @@ Introduction: Returns number of interior rings of polygon geometries. It is an alias of [ST_NumInteriorRings](ST_NumInteriorRings.md). + + Format: `ST_NumInteriorRing(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/flink/Geometry-Accessors/ST_NumInteriorRings.md b/docs/api/flink/Geometry-Accessors/ST_NumInteriorRings.md index b61a9d0ee8..722a549bf1 100644 --- a/docs/api/flink/Geometry-Accessors/ST_NumInteriorRings.md +++ b/docs/api/flink/Geometry-Accessors/ST_NumInteriorRings.md @@ -21,6 +21,8 @@ Introduction: Returns number of interior rings of polygon geometries. + + Format: `ST_NumInteriorRings(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/flink/Geometry-Accessors/ST_NumPoints.md b/docs/api/flink/Geometry-Accessors/ST_NumPoints.md index f5a253a372..dbf9ef31f8 100644 --- a/docs/api/flink/Geometry-Accessors/ST_NumPoints.md +++ b/docs/api/flink/Geometry-Accessors/ST_NumPoints.md @@ -28,6 +28,8 @@ Introduction: Returns number of points in a LineString. Output: `IllegalArgumentException: Unsupported geometry type: MultiPoint, only LineString geometry is supported.` + + Format: `ST_NumPoints(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/flink/Geometry-Accessors/ST_PointN.md b/docs/api/flink/Geometry-Accessors/ST_PointN.md index e7feb4314b..250ea768c1 100644 --- a/docs/api/flink/Geometry-Accessors/ST_PointN.md +++ b/docs/api/flink/Geometry-Accessors/ST_PointN.md @@ -21,6 +21,8 @@ Introduction: Return the Nth point in a single linestring or circular linestring in the geometry. Negative values are counted backwards from the end of the LineString, so that -1 is the last point. Returns NULL if there is no linestring in the geometry. + + Format: `ST_PointN(A: Geometry, B: Integer)` Return type: `Geometry` diff --git a/docs/api/flink/Geometry-Accessors/ST_Points.md b/docs/api/flink/Geometry-Accessors/ST_Points.md index 1462e15f2a..96b5362ff6 100644 --- a/docs/api/flink/Geometry-Accessors/ST_Points.md +++ b/docs/api/flink/Geometry-Accessors/ST_Points.md @@ -21,6 +21,8 @@ Introduction: Returns a MultiPoint geometry consisting of all the coordinates of the input geometry. It preserves duplicate points as well as M and Z coordinates. + + Format: `ST_Points(geom: Geometry)` Return type: `Geometry` diff --git a/docs/api/flink/Geometry-Accessors/ST_StartPoint.md b/docs/api/flink/Geometry-Accessors/ST_StartPoint.md index 4aa45f41e5..33bcf42c4b 100644 --- a/docs/api/flink/Geometry-Accessors/ST_StartPoint.md +++ b/docs/api/flink/Geometry-Accessors/ST_StartPoint.md @@ -21,6 +21,8 @@ Introduction: Returns first point of given linestring. + + Format: `ST_StartPoint(geom: Geometry)` Return type: `Geometry` diff --git a/docs/api/flink/Geometry-Accessors/ST_X.md b/docs/api/flink/Geometry-Accessors/ST_X.md index 086c41aabf..dd7c01b081 100644 --- a/docs/api/flink/Geometry-Accessors/ST_X.md +++ b/docs/api/flink/Geometry-Accessors/ST_X.md @@ -21,6 +21,8 @@ Introduction: Returns X Coordinate of given Point, null otherwise. + + Format: `ST_X(pointA: Point)` Return type: `Double` diff --git a/docs/api/flink/Geometry-Accessors/ST_Y.md b/docs/api/flink/Geometry-Accessors/ST_Y.md index b7734a35b1..7f7966e406 100644 --- a/docs/api/flink/Geometry-Accessors/ST_Y.md +++ b/docs/api/flink/Geometry-Accessors/ST_Y.md @@ -21,6 +21,8 @@ Introduction: Returns Y Coordinate of given Point, null otherwise. + + Format: `ST_Y(pointA: Point)` Return type: `Double` diff --git a/docs/api/flink/Geometry-Accessors/ST_Z.md b/docs/api/flink/Geometry-Accessors/ST_Z.md index d449ea0aec..4caa512436 100644 --- a/docs/api/flink/Geometry-Accessors/ST_Z.md +++ b/docs/api/flink/Geometry-Accessors/ST_Z.md @@ -21,6 +21,8 @@ Introduction: Returns Z Coordinate of given Point, null otherwise. + + Format: `ST_Z(pointA: Point)` Return type: `Double` diff --git a/docs/api/flink/Geometry-Accessors/ST_Zmflag.md b/docs/api/flink/Geometry-Accessors/ST_Zmflag.md index 6798c006c0..91474c1b94 100644 --- a/docs/api/flink/Geometry-Accessors/ST_Zmflag.md +++ b/docs/api/flink/Geometry-Accessors/ST_Zmflag.md @@ -23,6 +23,8 @@ Introduction: Returns a code indicating the Z and M coordinate dimensions presen Values are: 0 = 2D, 1 = 3D-M, 2 = 3D-Z, 3 = 4D. + + Format: `ST_Zmflag(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/GeometryType.md b/docs/api/snowflake/vector-data/Geometry-Accessors/GeometryType.md index b80aa8a60f..1743d48eb6 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/GeometryType.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/GeometryType.md @@ -21,6 +21,8 @@ Introduction: Returns the type of the geometry as a string. Eg: 'LINESTRING', 'POLYGON', 'MULTIPOINT', etc. This function also indicates if the geometry is measured, by returning a string of the form 'POINTM'. + + Format: `GeometryType (A: Geometry)` Return type: `String` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Boundary.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Boundary.md index b23220f825..822b285cad 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Boundary.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Boundary.md @@ -21,6 +21,8 @@ Introduction: Returns the closure of the combinatorial boundary of this Geometry. + + Format: `ST_Boundary(geom: geometry)` Return type: `Geometry` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_CoordDim.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_CoordDim.md index f667b05901..82a99d6d97 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_CoordDim.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_CoordDim.md @@ -21,6 +21,8 @@ Introduction: Returns the coordinate dimensions of the geometry. It is an alias of `ST_NDims`. + + Format: `ST_CoordDim(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_CrossesDateLine.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_CrossesDateLine.md index 405cbf1fa2..68130abbdc 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_CrossesDateLine.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_CrossesDateLine.md @@ -27,6 +27,8 @@ Introduction: This function determines if a given geometry crosses the Internati !!!note For multi-geometries (e.g., MultiPolygon, MultiLineString), this function will return true if any one of the geometries within the multi-geometry crosses the International Date Line. + + Format: `ST_CrossesDateLine(geometry: Geometry)` Return type: `Boolean` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Dimension.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Dimension.md index 013ab619a6..49171e575f 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Dimension.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Dimension.md @@ -21,6 +21,8 @@ Introduction: Return the topological dimension of this Geometry object, which must be less than or equal to the coordinate dimension. OGC SPEC s2.1.1.1 - returns 0 for POINT, 1 for LINESTRING, 2 for POLYGON, and the largest dimension of the components of a GEOMETRYCOLLECTION. If the dimension is unknown (e.g. for an empty GEOMETRYCOLLECTION) 0 is returned. + + Format: `ST_Dimension (A: Geometry) | ST_Dimension (C: Geometrycollection)` Return type: `Integer` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Dump.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Dump.md index 9bcc2462f1..1d81574667 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Dump.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Dump.md @@ -21,6 +21,8 @@ Introduction: This function takes a GeometryCollection/Multi Geometry object and returns a set of geometries containing the individual geometries that make up the input geometry. The function is useful for breaking down a GeometryCollection/Multi Geometry into its constituent geometries. + + Format: `ST_Dump(geom: geometry)` Return type: `Array<Geometry>` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_DumpPoints.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_DumpPoints.md index d5a27156e2..bcc280ac8a 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_DumpPoints.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_DumpPoints.md @@ -21,6 +21,8 @@ Introduction: Returns a MultiPoint geometry which consists of individual points that compose the input line string. + + Format: `ST_DumpPoints(geom: geometry)` Return type: `Array<Geometry>` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_EndPoint.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_EndPoint.md index a411898b3e..f35106e68a 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_EndPoint.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_EndPoint.md @@ -21,6 +21,8 @@ Introduction: Returns last point of given linestring. + + Format: `ST_EndPoint(geom: geometry)` Return type: `Geometry` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_ExteriorRing.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_ExteriorRing.md index d127c7971c..b1e6044684 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_ExteriorRing.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_ExteriorRing.md @@ -21,6 +21,8 @@ Introduction: Returns a line string representing the exterior ring of the POLYGON geometry. Return NULL if the geometry is not a polygon. + + Format: `ST_ExteriorRing(geom: geometry)` Return type: `Geometry` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_GeometryN.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_GeometryN.md index 1322447cad..640a034567 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_GeometryN.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_GeometryN.md @@ -21,6 +21,8 @@ Introduction: Return the 0-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, (MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON. Otherwise, return null + + Format: `ST_GeometryN(geom: geometry, n: Int)` Return type: `Geometry` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_GeometryType.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_GeometryType.md index e1542dbafc..7efaf32ba2 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_GeometryType.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_GeometryType.md @@ -21,6 +21,8 @@ Introduction: Returns the type of the geometry as a string. EG: 'ST_Linestring', 'ST_Polygon' etc. + + Format: `ST_GeometryType (A:geometry)` Return type: `String` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_HasZ.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_HasZ.md index 3a9654a704..6ab5154228 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_HasZ.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_HasZ.md @@ -21,6 +21,8 @@ Introduction: Checks for the presence of Z coordinate values representing measures or linear references. Returns true if the input geometry includes an Z coordinate, false otherwise. + + Format: `ST_HasZ(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_InteriorRingN.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_InteriorRingN.md index e587c3b57a..ef79ca382d 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_InteriorRingN.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_InteriorRingN.md @@ -21,6 +21,8 @@ Introduction: Returns the Nth interior linestring ring of the polygon geometry. Returns NULL if the geometry is not a polygon or the given N is out of range + + Format: `ST_InteriorRingN(geom: geometry, n: Int)` Return type: `Geometry` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsClosed.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsClosed.md index 42632a5a66..8de8cd9f13 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsClosed.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsClosed.md @@ -21,6 +21,8 @@ Introduction: RETURNS true if the LINESTRING start and end point are the same. + + Format: `ST_IsClosed(geom: geometry)` Return type: `Boolean` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsCollection.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsCollection.md index bd927bd5c2..76a93f48bd 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsCollection.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsCollection.md @@ -25,6 +25,8 @@ Collection types are the following: - GEOMETRYCOLLECTION - MULTI{POINT, POLYGON, LINESTRING} + + Format: `ST_IsCollection(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsEmpty.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsEmpty.md index 49f5f0f809..04f4546cd3 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsEmpty.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsEmpty.md @@ -21,6 +21,8 @@ Introduction: Test if a geometry is empty geometry + + Format: `ST_IsEmpty (A:geometry)` Return type: `Boolean` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsPolygonCCW.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsPolygonCCW.md index af0a2b383a..4495b21840 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsPolygonCCW.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsPolygonCCW.md @@ -21,6 +21,8 @@ Introduction: Returns true if all polygonal components in the input geometry have their exterior rings oriented counter-clockwise and interior rings oriented clockwise. + + Format: `ST_IsPolygonCCW(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsPolygonCW.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsPolygonCW.md index ab3776e34f..c50532bf68 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsPolygonCW.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsPolygonCW.md @@ -21,6 +21,8 @@ Introduction: Returns true if all polygonal components in the input geometry have their exterior rings oriented counter-clockwise and interior rings oriented clockwise. + + Format: `ST_IsPolygonCW(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsRing.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsRing.md index 428fcbe8f0..3e6469b88d 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsRing.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsRing.md @@ -21,6 +21,8 @@ Introduction: RETURN true if LINESTRING is ST_IsClosed and ST_IsSimple. + + Format: `ST_IsRing(geom: geometry)` Return type: `Boolean` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsSimple.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsSimple.md index ff4665f370..d3699c5cee 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsSimple.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_IsSimple.md @@ -21,6 +21,8 @@ Introduction: Test if geometry's only self-intersections are at boundary points. + + Format: `ST_IsSimple (A:geometry)` Return type: `Boolean` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NDims.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NDims.md index b6b8fe2bcf..cc0a529409 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NDims.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NDims.md @@ -21,6 +21,8 @@ Introduction: Returns the coordinate dimension of the geometry. + + Format: `ST_NDims(geom: geometry)` Return type: `Integer` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NPoints.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NPoints.md index 9d79060504..ca402404fe 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NPoints.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NPoints.md @@ -21,6 +21,8 @@ Introduction: Return points of the geometry + + Format: `ST_NPoints (A:geometry)` Return type: `Integer` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NRings.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NRings.md index 460183da1e..9e45de5ab4 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NRings.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NRings.md @@ -25,6 +25,8 @@ this function also takes into account the number of exterior rings. This function returns 0 for an empty Polygon or MultiPolygon. If the geometry is not a Polygon or MultiPolygon, an IllegalArgument Exception is thrown. + + Format: `ST_NRings(geom: geometry)` Return type: `Integer` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumGeometries.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumGeometries.md index 9e2e3b1583..696558f376 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumGeometries.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumGeometries.md @@ -21,6 +21,8 @@ Introduction: Returns the number of Geometries. If geometry is a GEOMETRYCOLLECTION (or MULTI*) return the number of geometries, for single geometries will return 1. + + Format: `ST_NumGeometries (A:geometry)` Return type: `Integer` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumInteriorRing.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumInteriorRing.md index 009979e305..6b66b0371a 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumInteriorRing.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumInteriorRing.md @@ -21,6 +21,8 @@ Introduction: Returns number of interior rings of polygon geometries. It is an alias of [ST_NumInteriorRings](ST_NumInteriorRings.md). + + Format: `ST_NumInteriorRing(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumInteriorRings.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumInteriorRings.md index 28d81e21bf..a9804eae39 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumInteriorRings.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumInteriorRings.md @@ -21,6 +21,8 @@ Introduction: RETURNS number of interior rings of polygon geometries. + + Format: `ST_NumInteriorRings(geom: geometry)` Return type: `Integer` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumPoints.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumPoints.md index 3fc6490f93..b588c2080d 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumPoints.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_NumPoints.md @@ -21,6 +21,8 @@ Introduction: Returns number of points in a LineString + + Format: `ST_NumPoints(geom: geometry)` Return type: `Integer` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_PointN.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_PointN.md index e90486a5b1..79959bbeca 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_PointN.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_PointN.md @@ -21,6 +21,8 @@ Introduction: Return the Nth point in a single linestring or circular linestring in the geometry. Negative values are counted backwards from the end of the LineString, so that -1 is the last point. Returns NULL if there is no linestring in the geometry. + + Format: `ST_PointN(geom: geometry, n: integer)` Return type: `Geometry` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Points.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Points.md index a8030d0644..6558a97972 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Points.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Points.md @@ -21,6 +21,8 @@ Introduction: Returns a MultiPoint geometry consisting of all the coordinates of the input geometry. It preserves duplicate points as well as M and Z coordinates. + + Format: `ST_Points(geom: Geometry)` Return type: `Geometry` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_StartPoint.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_StartPoint.md index 2327d1843c..a5a9276924 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_StartPoint.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_StartPoint.md @@ -21,6 +21,8 @@ Introduction: Returns first point of given linestring. + + Format: `ST_StartPoint(geom: geometry)` Return type: `Geometry` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_X.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_X.md index 484d8fbad0..87dae3f66a 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_X.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_X.md @@ -21,6 +21,8 @@ Introduction: Returns X Coordinate of given Point null otherwise. + + Format: `ST_X(pointA: Point)` Return type: `Double` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Y.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Y.md index 4bbc9e5328..40b28193c4 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Y.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Y.md @@ -21,6 +21,8 @@ Introduction: Returns Y Coordinate of given Point, null otherwise. + + Format: `ST_Y(pointA: Point)` Return type: `Double` diff --git a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Z.md b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Z.md index a251ad8928..20a931658c 100644 --- a/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Z.md +++ b/docs/api/snowflake/vector-data/Geometry-Accessors/ST_Z.md @@ -21,6 +21,8 @@ Introduction: Returns Z Coordinate of given Point, null otherwise. + + Format: `ST_Z(pointA: Point)` Return type: `Double` diff --git a/docs/api/sql/Geometry-Accessors/GeometryType.md b/docs/api/sql/Geometry-Accessors/GeometryType.md index d4f37e407d..2c4e1ee409 100644 --- a/docs/api/sql/Geometry-Accessors/GeometryType.md +++ b/docs/api/sql/Geometry-Accessors/GeometryType.md @@ -21,6 +21,8 @@ Introduction: Returns the type of the geometry as a string. Eg: 'LINESTRING', 'POLYGON', 'MULTIPOINT', etc. This function also indicates if the geometry is measured, by returning a string of the form 'POINTM'. + + Format: `GeometryType (A: Geometry)` Return type: `String` diff --git a/docs/api/sql/Geometry-Accessors/ST_Boundary.md b/docs/api/sql/Geometry-Accessors/ST_Boundary.md index d0e069c5f4..19c52b379a 100644 --- a/docs/api/sql/Geometry-Accessors/ST_Boundary.md +++ b/docs/api/sql/Geometry-Accessors/ST_Boundary.md @@ -21,6 +21,8 @@ Introduction: Returns the closure of the combinatorial boundary of this Geometry. + + Format: `ST_Boundary(geom: Geometry)` Return type: `Geometry` diff --git a/docs/api/sql/Geometry-Accessors/ST_CoordDim.md b/docs/api/sql/Geometry-Accessors/ST_CoordDim.md index cb2786fba4..64e6bc61af 100644 --- a/docs/api/sql/Geometry-Accessors/ST_CoordDim.md +++ b/docs/api/sql/Geometry-Accessors/ST_CoordDim.md @@ -21,6 +21,8 @@ Introduction: Returns the coordinate dimensions of the geometry. It is an alias of `ST_NDims`. + + Format: `ST_CoordDim(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/sql/Geometry-Accessors/ST_CrossesDateLine.md b/docs/api/sql/Geometry-Accessors/ST_CrossesDateLine.md index 0678887548..8e20e9f284 100644 --- a/docs/api/sql/Geometry-Accessors/ST_CrossesDateLine.md +++ b/docs/api/sql/Geometry-Accessors/ST_CrossesDateLine.md @@ -27,6 +27,8 @@ Introduction: This function determines if a given geometry crosses the Internati !!!note For multi-geometries (e.g., MultiPolygon, MultiLineString), this function will return true if any one of the geometries within the multi-geometry crosses the International Date Line. + + Format: `ST_CrossesDateLine(geometry: Geometry)` Return type: `Boolean` diff --git a/docs/api/sql/Geometry-Accessors/ST_Dimension.md b/docs/api/sql/Geometry-Accessors/ST_Dimension.md index cda6d67279..3b12955316 100644 --- a/docs/api/sql/Geometry-Accessors/ST_Dimension.md +++ b/docs/api/sql/Geometry-Accessors/ST_Dimension.md @@ -21,6 +21,8 @@ Introduction: Return the topological dimension of this Geometry object, which must be less than or equal to the coordinate dimension. OGC SPEC s2.1.1.1 - returns 0 for POINT, 1 for LINESTRING, 2 for POLYGON, and the largest dimension of the components of a GEOMETRYCOLLECTION. If the dimension is unknown (e.g. for an empty GEOMETRYCOLLECTION) 0 is returned. + + Format: `ST_Dimension (A: Geometry) | ST_Dimension (C: Geometrycollection)` Return type: `Integer` diff --git a/docs/api/sql/Geometry-Accessors/ST_Dump.md b/docs/api/sql/Geometry-Accessors/ST_Dump.md index 2d2a0f8159..2b3c350c88 100644 --- a/docs/api/sql/Geometry-Accessors/ST_Dump.md +++ b/docs/api/sql/Geometry-Accessors/ST_Dump.md @@ -22,6 +22,8 @@ Introduction: It expands the geometries. If the geometry is simple (Point, Polygon Linestring etc.) it returns the geometry itself, if the geometry is collection or multi it returns record for each of collection components. + + Format: `ST_Dump(geom: Geometry)` Return type: `Array<Geometry>` diff --git a/docs/api/sql/Geometry-Accessors/ST_DumpPoints.md b/docs/api/sql/Geometry-Accessors/ST_DumpPoints.md index cdc85d66ec..50b40f9f4f 100644 --- a/docs/api/sql/Geometry-Accessors/ST_DumpPoints.md +++ b/docs/api/sql/Geometry-Accessors/ST_DumpPoints.md @@ -21,6 +21,8 @@ Introduction: Returns list of Points which geometry consists of. + + Format: `ST_DumpPoints(geom: Geometry)` Return type: `Array<Geometry>` diff --git a/docs/api/sql/Geometry-Accessors/ST_EndPoint.md b/docs/api/sql/Geometry-Accessors/ST_EndPoint.md index 24fc49f354..68c9f2d580 100644 --- a/docs/api/sql/Geometry-Accessors/ST_EndPoint.md +++ b/docs/api/sql/Geometry-Accessors/ST_EndPoint.md @@ -21,6 +21,8 @@ Introduction: Returns last point of given linestring. + + Format: `ST_EndPoint(geom: Geometry)` Return type: `Geometry` diff --git a/docs/api/sql/Geometry-Accessors/ST_ExteriorRing.md b/docs/api/sql/Geometry-Accessors/ST_ExteriorRing.md index e5a2244791..48d46fa999 100644 --- a/docs/api/sql/Geometry-Accessors/ST_ExteriorRing.md +++ b/docs/api/sql/Geometry-Accessors/ST_ExteriorRing.md @@ -21,6 +21,8 @@ Introduction: Returns a line string representing the exterior ring of the POLYGON geometry. Return NULL if the geometry is not a polygon. + + Format: `ST_ExteriorRing(geom: Geometry)` Return type: `Geometry` diff --git a/docs/api/sql/Geometry-Accessors/ST_GeometryN.md b/docs/api/sql/Geometry-Accessors/ST_GeometryN.md index b6a6deeaf1..bb4bb784fb 100644 --- a/docs/api/sql/Geometry-Accessors/ST_GeometryN.md +++ b/docs/api/sql/Geometry-Accessors/ST_GeometryN.md @@ -21,6 +21,8 @@ Introduction: Return the 0-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, (MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON. Otherwise, return null + + Format: `ST_GeometryN(geom: Geometry, n: Integer)` Return type: `Geometry` diff --git a/docs/api/sql/Geometry-Accessors/ST_GeometryType.md b/docs/api/sql/Geometry-Accessors/ST_GeometryType.md index 67f774eb83..9f6e57c819 100644 --- a/docs/api/sql/Geometry-Accessors/ST_GeometryType.md +++ b/docs/api/sql/Geometry-Accessors/ST_GeometryType.md @@ -21,6 +21,8 @@ Introduction: Returns the type of the geometry as a string. EG: 'ST_Linestring', 'ST_Polygon' etc. + + Format: `ST_GeometryType (A: Geometry)` Return type: `String` diff --git a/docs/api/sql/Geometry-Accessors/ST_HasM.md b/docs/api/sql/Geometry-Accessors/ST_HasM.md index b5ff25386e..7050a913a2 100644 --- a/docs/api/sql/Geometry-Accessors/ST_HasM.md +++ b/docs/api/sql/Geometry-Accessors/ST_HasM.md @@ -21,6 +21,8 @@ Introduction: Checks for the presence of M coordinate values representing measures or linear references. Returns true if the input geometry includes an M coordinate, false otherwise. + + Format: `ST_HasM(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/sql/Geometry-Accessors/ST_HasZ.md b/docs/api/sql/Geometry-Accessors/ST_HasZ.md index db31da11c9..f888698acd 100644 --- a/docs/api/sql/Geometry-Accessors/ST_HasZ.md +++ b/docs/api/sql/Geometry-Accessors/ST_HasZ.md @@ -21,6 +21,8 @@ Introduction: Checks for the presence of Z coordinate values representing measures or linear references. Returns true if the input geometry includes an Z coordinate, false otherwise. + + Format: `ST_HasZ(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/sql/Geometry-Accessors/ST_InteriorRingN.md b/docs/api/sql/Geometry-Accessors/ST_InteriorRingN.md index c6e75c1a2d..09595fa89e 100644 --- a/docs/api/sql/Geometry-Accessors/ST_InteriorRingN.md +++ b/docs/api/sql/Geometry-Accessors/ST_InteriorRingN.md @@ -21,6 +21,8 @@ Introduction: Returns the Nth interior linestring ring of the polygon geometry. Returns NULL if the geometry is not a polygon or the given N is out of range + + Format: `ST_InteriorRingN(geom: Geometry, n: Integer)` Return type: `Geometry` diff --git a/docs/api/sql/Geometry-Accessors/ST_IsClosed.md b/docs/api/sql/Geometry-Accessors/ST_IsClosed.md index eb3c530ee1..66b2e24ce3 100644 --- a/docs/api/sql/Geometry-Accessors/ST_IsClosed.md +++ b/docs/api/sql/Geometry-Accessors/ST_IsClosed.md @@ -21,6 +21,8 @@ Introduction: RETURNS true if the LINESTRING start and end point are the same. + + Format: `ST_IsClosed(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/sql/Geometry-Accessors/ST_IsCollection.md b/docs/api/sql/Geometry-Accessors/ST_IsCollection.md index f1501793ec..c2e97c5ef2 100644 --- a/docs/api/sql/Geometry-Accessors/ST_IsCollection.md +++ b/docs/api/sql/Geometry-Accessors/ST_IsCollection.md @@ -25,6 +25,8 @@ Collection types are the following: - GEOMETRYCOLLECTION - MULTI{POINT, POLYGON, LINESTRING} + + Format: `ST_IsCollection(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/sql/Geometry-Accessors/ST_IsEmpty.md b/docs/api/sql/Geometry-Accessors/ST_IsEmpty.md index 522a7e004f..16489f416c 100644 --- a/docs/api/sql/Geometry-Accessors/ST_IsEmpty.md +++ b/docs/api/sql/Geometry-Accessors/ST_IsEmpty.md @@ -21,6 +21,8 @@ Introduction: Test if a geometry is empty geometry + + Format: `ST_IsEmpty (A: Geometry)` Return type: `Boolean` diff --git a/docs/api/sql/Geometry-Accessors/ST_IsPolygonCCW.md b/docs/api/sql/Geometry-Accessors/ST_IsPolygonCCW.md index 39d8545254..e9343face7 100644 --- a/docs/api/sql/Geometry-Accessors/ST_IsPolygonCCW.md +++ b/docs/api/sql/Geometry-Accessors/ST_IsPolygonCCW.md @@ -21,6 +21,8 @@ Introduction: Returns true if all polygonal components in the input geometry have their exterior rings oriented counter-clockwise and interior rings oriented clockwise. + + Format: `ST_IsPolygonCCW(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/sql/Geometry-Accessors/ST_IsPolygonCW.md b/docs/api/sql/Geometry-Accessors/ST_IsPolygonCW.md index cb067f138e..cb32bc5bee 100644 --- a/docs/api/sql/Geometry-Accessors/ST_IsPolygonCW.md +++ b/docs/api/sql/Geometry-Accessors/ST_IsPolygonCW.md @@ -21,6 +21,8 @@ Introduction: Returns true if all polygonal components in the input geometry have their exterior rings oriented counter-clockwise and interior rings oriented clockwise. + + Format: `ST_IsPolygonCW(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/sql/Geometry-Accessors/ST_IsRing.md b/docs/api/sql/Geometry-Accessors/ST_IsRing.md index 13f03e7f23..8369068398 100644 --- a/docs/api/sql/Geometry-Accessors/ST_IsRing.md +++ b/docs/api/sql/Geometry-Accessors/ST_IsRing.md @@ -21,6 +21,8 @@ Introduction: RETURN true if LINESTRING is ST_IsClosed and ST_IsSimple. + + Format: `ST_IsRing(geom: Geometry)` Return type: `Boolean` diff --git a/docs/api/sql/Geometry-Accessors/ST_IsSimple.md b/docs/api/sql/Geometry-Accessors/ST_IsSimple.md index b6bc35e5ad..5b3ec5ab36 100644 --- a/docs/api/sql/Geometry-Accessors/ST_IsSimple.md +++ b/docs/api/sql/Geometry-Accessors/ST_IsSimple.md @@ -21,6 +21,8 @@ Introduction: Test if geometry's only self-intersections are at boundary points. + + Format: `ST_IsSimple (A: Geometry)` Return type: `Boolean` diff --git a/docs/api/sql/Geometry-Accessors/ST_M.md b/docs/api/sql/Geometry-Accessors/ST_M.md index a63d0668a9..0d3383357d 100644 --- a/docs/api/sql/Geometry-Accessors/ST_M.md +++ b/docs/api/sql/Geometry-Accessors/ST_M.md @@ -21,6 +21,8 @@ Introduction: Returns M Coordinate of given Point, null otherwise. + + Format: `ST_M(geom: Geometry)` Return type: `Double` diff --git a/docs/api/sql/Geometry-Accessors/ST_NDims.md b/docs/api/sql/Geometry-Accessors/ST_NDims.md index 4037ecad6c..8a678c79fa 100644 --- a/docs/api/sql/Geometry-Accessors/ST_NDims.md +++ b/docs/api/sql/Geometry-Accessors/ST_NDims.md @@ -21,6 +21,8 @@ Introduction: Returns the coordinate dimension of the geometry. + + Format: `ST_NDims(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/sql/Geometry-Accessors/ST_NPoints.md b/docs/api/sql/Geometry-Accessors/ST_NPoints.md index 27bd62ce78..c43a9e605e 100644 --- a/docs/api/sql/Geometry-Accessors/ST_NPoints.md +++ b/docs/api/sql/Geometry-Accessors/ST_NPoints.md @@ -21,6 +21,8 @@ Introduction: Return points of the geometry + + Format: `ST_NPoints (A: Geometry)` Return type: `Integer` diff --git a/docs/api/sql/Geometry-Accessors/ST_NRings.md b/docs/api/sql/Geometry-Accessors/ST_NRings.md index 77c0835640..f98ba2a68f 100644 --- a/docs/api/sql/Geometry-Accessors/ST_NRings.md +++ b/docs/api/sql/Geometry-Accessors/ST_NRings.md @@ -25,6 +25,8 @@ this function also takes into account the number of exterior rings. This function returns 0 for an empty Polygon or MultiPolygon. If the geometry is not a Polygon or MultiPolygon, an IllegalArgument Exception is thrown. + + Format: `ST_NRings(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/sql/Geometry-Accessors/ST_NumGeometries.md b/docs/api/sql/Geometry-Accessors/ST_NumGeometries.md index 05d2a701b0..cbd6d6dad9 100644 --- a/docs/api/sql/Geometry-Accessors/ST_NumGeometries.md +++ b/docs/api/sql/Geometry-Accessors/ST_NumGeometries.md @@ -21,6 +21,8 @@ Introduction: Returns the number of Geometries. If geometry is a GEOMETRYCOLLECTION (or MULTI*) return the number of geometries, for single geometries will return 1. + + Format: `ST_NumGeometries (A: Geometry)` Return type: `Integer` diff --git a/docs/api/sql/Geometry-Accessors/ST_NumInteriorRing.md b/docs/api/sql/Geometry-Accessors/ST_NumInteriorRing.md index 9d7269ef05..7e83cafada 100644 --- a/docs/api/sql/Geometry-Accessors/ST_NumInteriorRing.md +++ b/docs/api/sql/Geometry-Accessors/ST_NumInteriorRing.md @@ -21,6 +21,8 @@ Introduction: Returns number of interior rings of polygon geometries. It is an alias of [ST_NumInteriorRings](ST_NumInteriorRings.md). + + Format: `ST_NumInteriorRing(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/sql/Geometry-Accessors/ST_NumInteriorRings.md b/docs/api/sql/Geometry-Accessors/ST_NumInteriorRings.md index 35a87afed5..eef21cab4c 100644 --- a/docs/api/sql/Geometry-Accessors/ST_NumInteriorRings.md +++ b/docs/api/sql/Geometry-Accessors/ST_NumInteriorRings.md @@ -21,6 +21,8 @@ Introduction: RETURNS number of interior rings of polygon geometries. + + Format: `ST_NumInteriorRings(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/sql/Geometry-Accessors/ST_NumPoints.md b/docs/api/sql/Geometry-Accessors/ST_NumPoints.md index 05aac36d9b..aeda8124c5 100644 --- a/docs/api/sql/Geometry-Accessors/ST_NumPoints.md +++ b/docs/api/sql/Geometry-Accessors/ST_NumPoints.md @@ -28,6 +28,8 @@ Introduction: Returns number of points in a LineString Output: `IllegalArgumentException: Unsupported geometry type: MultiPoint, only LineString geometry is supported.` + + Format: `ST_NumPoints(geom: Geometry)` Return type: `Integer` diff --git a/docs/api/sql/Geometry-Accessors/ST_PointN.md b/docs/api/sql/Geometry-Accessors/ST_PointN.md index a591deb09a..b9f276dcc8 100644 --- a/docs/api/sql/Geometry-Accessors/ST_PointN.md +++ b/docs/api/sql/Geometry-Accessors/ST_PointN.md @@ -21,6 +21,8 @@ Introduction: Return the Nth point in a single linestring or circular linestring in the geometry. Negative values are counted backwards from the end of the LineString, so that -1 is the last point. Returns NULL if there is no linestring in the geometry. + + Format: `ST_PointN(geom: Geometry, n: Integer)` Return type: `Geometry` diff --git a/docs/api/sql/Geometry-Accessors/ST_Points.md b/docs/api/sql/Geometry-Accessors/ST_Points.md index 1462e15f2a..96b5362ff6 100644 --- a/docs/api/sql/Geometry-Accessors/ST_Points.md +++ b/docs/api/sql/Geometry-Accessors/ST_Points.md @@ -21,6 +21,8 @@ Introduction: Returns a MultiPoint geometry consisting of all the coordinates of the input geometry. It preserves duplicate points as well as M and Z coordinates. + + Format: `ST_Points(geom: Geometry)` Return type: `Geometry` diff --git a/docs/api/sql/Geometry-Accessors/ST_StartPoint.md b/docs/api/sql/Geometry-Accessors/ST_StartPoint.md index bbd09d0c16..255cd99384 100644 --- a/docs/api/sql/Geometry-Accessors/ST_StartPoint.md +++ b/docs/api/sql/Geometry-Accessors/ST_StartPoint.md @@ -21,6 +21,8 @@ Introduction: Returns first point of given linestring. + + Format: `ST_StartPoint(geom: Geometry)` Return type: `Geometry` diff --git a/docs/api/sql/Geometry-Accessors/ST_X.md b/docs/api/sql/Geometry-Accessors/ST_X.md index 02f2de1f7f..aaae94e6c7 100644 --- a/docs/api/sql/Geometry-Accessors/ST_X.md +++ b/docs/api/sql/Geometry-Accessors/ST_X.md @@ -21,6 +21,8 @@ Introduction: Returns X Coordinate of given Point null otherwise. + + Format: `ST_X(pointA: Point)` Return type: `Double` diff --git a/docs/api/sql/Geometry-Accessors/ST_Y.md b/docs/api/sql/Geometry-Accessors/ST_Y.md index f4784ce7c2..b0f3123f1f 100644 --- a/docs/api/sql/Geometry-Accessors/ST_Y.md +++ b/docs/api/sql/Geometry-Accessors/ST_Y.md @@ -21,6 +21,8 @@ Introduction: Returns Y Coordinate of given Point, null otherwise. + + Format: `ST_Y(pointA: Point)` Return type: `Double` diff --git a/docs/api/sql/Geometry-Accessors/ST_Z.md b/docs/api/sql/Geometry-Accessors/ST_Z.md index bff768d1f5..bf7649be12 100644 --- a/docs/api/sql/Geometry-Accessors/ST_Z.md +++ b/docs/api/sql/Geometry-Accessors/ST_Z.md @@ -21,6 +21,8 @@ Introduction: Returns Z Coordinate of given Point, null otherwise. + + Format: `ST_Z(pointA: Point)` Return type: `Double` diff --git a/docs/api/sql/Geometry-Accessors/ST_Zmflag.md b/docs/api/sql/Geometry-Accessors/ST_Zmflag.md index 6798c006c0..91474c1b94 100644 --- a/docs/api/sql/Geometry-Accessors/ST_Zmflag.md +++ b/docs/api/sql/Geometry-Accessors/ST_Zmflag.md @@ -23,6 +23,8 @@ Introduction: Returns a code indicating the Z and M coordinate dimensions presen Values are: 0 = 2D, 1 = 3D-M, 2 = 3D-Z, 3 = 4D. + + Format: `ST_Zmflag(geom: Geometry)` Return type: `Integer` diff --git a/docs/image/GeometryType/GeometryType.svg b/docs/image/GeometryType/GeometryType.svg new file mode 100644 index 0000000000..624ce92d0d --- /dev/null +++ b/docs/image/GeometryType/GeometryType.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polygon points="103.33,260.0 396.67,260.0 396.67,40.0 103.33,40.0 103.33,260.0" fill="#4a90d9" fill-opacity="0.12" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <rect x="190" y="8" width="120" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="14" font-weight="bold">"POLYGON"</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">GeometryType</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_Boundary/ST_Boundary.svg b/docs/image/ST_Boundary/ST_Boundary.svg new file mode 100644 index 0000000000..43771be923 --- /dev/null +++ b/docs/image/ST_Boundary/ST_Boundary.svg @@ -0,0 +1,11 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polygon points="140.0,260.0 360.0,260.0 360.0,40.0 140.0,40.0 140.0,260.0" fill="#4a90d9" fill-opacity="0.08" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0" stroke-dasharray="6,3"/> + <polyline points="140.0,260.0 360.0,260.0 360.0,40.0 140.0,40.0 140.0,260.0" fill="none" stroke="#2ecc71" stroke-width="3" stroke-opacity="1.0"/> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_Boundary</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_CoordDim/ST_CoordDim.svg b/docs/image/ST_CoordDim/ST_CoordDim.svg new file mode 100644 index 0000000000..35d7a0065e --- /dev/null +++ b/docs/image/ST_CoordDim/ST_CoordDim.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="140.0" cy="260.0" r="6" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="15" font-weight="bold">CoordDim = 2</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_CoordDim</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_CrossesDateLine/ST_CrossesDateLine.svg b/docs/image/ST_CrossesDateLine/ST_CrossesDateLine.svg new file mode 100644 index 0000000000..2fd0de2e6a --- /dev/null +++ b/docs/image/ST_CrossesDateLine/ST_CrossesDateLine.svg @@ -0,0 +1,18 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <line x1="250" y1="50" x2="250" y2="260" stroke="#999" stroke-width="1.5" stroke-dasharray="5,4"/> + <text x="250" y="42" text-anchor="middle" fill="#999" font-size="11">180° / -180°</text> + <text x="170" y="275" text-anchor="middle" fill="#777" font-size="11">170°E</text> + <text x="330" y="275" text-anchor="middle" fill="#777" font-size="11">170°W</text> + <line x1="170" y1="150" x2="330" y2="150" stroke="#4a90d9" stroke-width="3"/> + <circle cx="170" cy="150" r="6" fill="#4a90d9"/> + <circle cx="330" cy="150" r="6" fill="#4a90d9"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="14" font-weight="bold">→ true</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_CrossesDateLine</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_Dimension/ST_Dimension.svg b/docs/image/ST_Dimension/ST_Dimension.svg new file mode 100644 index 0000000000..5cca88acda --- /dev/null +++ b/docs/image/ST_Dimension/ST_Dimension.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polygon points="103.33,260.0 396.67,260.0 396.67,40.0 103.33,40.0 103.33,260.0" fill="#4a90d9" fill-opacity="0.12" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="15" font-weight="bold">Dimension = 2</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_Dimension</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_Dump/ST_Dump.svg b/docs/image/ST_Dump/ST_Dump.svg new file mode 100644 index 0000000000..180685da13 --- /dev/null +++ b/docs/image/ST_Dump/ST_Dump.svg @@ -0,0 +1,13 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polygon points="66.67,260.0 213.33,260.0 213.33,113.33 66.67,113.33 66.67,260.0" fill="#e74c3c" fill-opacity="0.2" stroke="#e74c3c" stroke-width="2.5" stroke-opacity="1.0"/> + <text x="125.33" y="199.33" text-anchor="middle" fill="#e74c3c" font-size="14" font-weight="bold">[0]</text> + <polygon points="286.67,186.67 433.33,186.67 433.33,40.0 286.67,40.0 286.67,186.67" fill="#3498db" fill-opacity="0.2" stroke="#3498db" stroke-width="2.5" stroke-opacity="1.0"/> + <text x="345.33" y="126.0" text-anchor="middle" fill="#3498db" font-size="14" font-weight="bold">[1]</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_Dump</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_DumpPoints/ST_DumpPoints.svg b/docs/image/ST_DumpPoints/ST_DumpPoints.svg new file mode 100644 index 0000000000..69d57b32ee --- /dev/null +++ b/docs/image/ST_DumpPoints/ST_DumpPoints.svg @@ -0,0 +1,18 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polyline points="103.33,260.0 176.67,40.0 323.33,113.33 396.67,260.0" fill="none" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0" stroke-dasharray="6,3"/> + <circle cx="103.33" cy="260.0" r="8" fill="#2ecc71" fill-opacity="0.8" stroke="white" stroke-width="1.5"/> + <text x="103.33" y="248.0" text-anchor="middle" fill="#2ecc71" font-size="11" font-weight="bold">0</text> + <circle cx="176.67" cy="40.0" r="8" fill="#2ecc71" fill-opacity="0.8" stroke="white" stroke-width="1.5"/> + <text x="176.67" y="28.0" text-anchor="middle" fill="#2ecc71" font-size="11" font-weight="bold">1</text> + <circle cx="323.33" cy="113.33" r="8" fill="#2ecc71" fill-opacity="0.8" stroke="white" stroke-width="1.5"/> + <text x="323.33" y="101.33" text-anchor="middle" fill="#2ecc71" font-size="11" font-weight="bold">2</text> + <circle cx="396.67" cy="260.0" r="8" fill="#2ecc71" fill-opacity="0.8" stroke="white" stroke-width="1.5"/> + <text x="396.67" y="248.0" text-anchor="middle" fill="#2ecc71" font-size="11" font-weight="bold">3</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_DumpPoints</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_EndPoint/ST_EndPoint.svg b/docs/image/ST_EndPoint/ST_EndPoint.svg new file mode 100644 index 0000000000..5a6098df2b --- /dev/null +++ b/docs/image/ST_EndPoint/ST_EndPoint.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polyline points="103.33,260.0 176.67,113.33 323.33,186.67 396.67,40.0 396.67,40.0" fill="none" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0" stroke-dasharray="6,3"/> + <circle cx="396.67" cy="40.0" r="11" fill="#2ecc71" fill-opacity="0.25" stroke="#2ecc71" stroke-width="2"/> + <circle cx="396.67" cy="40.0" r="8" fill="#2ecc71" fill-opacity="0.9" stroke="white" stroke-width="1.5"/> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_EndPoint</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_ExteriorRing/ST_ExteriorRing.svg b/docs/image/ST_ExteriorRing/ST_ExteriorRing.svg new file mode 100644 index 0000000000..7b5dfe2c71 --- /dev/null +++ b/docs/image/ST_ExteriorRing/ST_ExteriorRing.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polygon points="140.0,260.0 360.0,260.0 360.0,40.0 140.0,40.0 140.0,260.0" fill="#4a90d9" fill-opacity="0.08" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0" stroke-dasharray="6,3"/> + <polygon points="184.0,216.0 228.0,216.0 228.0,172.0 184.0,172.0 184.0,216.0" fill="#4a90d9" fill-opacity="0" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0" stroke-dasharray="6,3"/> + <polyline points="140.0,260.0 360.0,260.0 360.0,40.0 140.0,40.0 140.0,260.0" fill="none" stroke="#2ecc71" stroke-width="3" stroke-opacity="1.0"/> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_ExteriorRing</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_GeometryN/ST_GeometryN.svg b/docs/image/ST_GeometryN/ST_GeometryN.svg new file mode 100644 index 0000000000..a6795b3098 --- /dev/null +++ b/docs/image/ST_GeometryN/ST_GeometryN.svg @@ -0,0 +1,15 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="103.33" cy="186.67" r="6" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <circle cx="250.0" cy="40.0" r="6" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <circle cx="396.67" cy="260.0" r="6" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <circle cx="250.0" cy="40.0" r="6" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <circle cx="250.0" cy="40.0" r="7" fill="#2ecc71" fill-opacity="1.0" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250.0" y="22" text-anchor="middle" fill="#333" font-size="13" font-weight="bold">N = 1</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_GeometryN</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_GeometryType/ST_GeometryType.svg b/docs/image/ST_GeometryType/ST_GeometryType.svg new file mode 100644 index 0000000000..9a4d0142a6 --- /dev/null +++ b/docs/image/ST_GeometryType/ST_GeometryType.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polyline points="103.33,260.0 250.0,40.0 396.67,186.67" fill="none" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <rect x="173" y="8" width="154" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="14" font-weight="bold">"ST_LineString"</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_GeometryType</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_HasM/ST_HasM.svg b/docs/image/ST_HasM/ST_HasM.svg new file mode 100644 index 0000000000..a8233f3dc2 --- /dev/null +++ b/docs/image/ST_HasM/ST_HasM.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="250.0" cy="150.0" r="12" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <text x="250.0" y="180.0" text-anchor="middle" fill="#e74c3c" font-size="14" font-weight="bold">HasM → false</text> + <text x="250.0" y="198.0" text-anchor="middle" fill="#777" font-size="11">POINT (1 2) — no M coordinate</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_HasM</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_HasZ/ST_HasZ.svg b/docs/image/ST_HasZ/ST_HasZ.svg new file mode 100644 index 0000000000..566cc31b60 --- /dev/null +++ b/docs/image/ST_HasZ/ST_HasZ.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="250.0" cy="150.0" r="12" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <text x="250.0" y="180.0" text-anchor="middle" fill="#e74c3c" font-size="14" font-weight="bold">HasZ → false</text> + <text x="250.0" y="198.0" text-anchor="middle" fill="#777" font-size="11">POINT (1 2) — no Z coordinate</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_HasZ</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_InteriorRingN/ST_InteriorRingN.svg b/docs/image/ST_InteriorRingN/ST_InteriorRingN.svg new file mode 100644 index 0000000000..7a7edbc110 --- /dev/null +++ b/docs/image/ST_InteriorRingN/ST_InteriorRingN.svg @@ -0,0 +1,14 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polygon points="140.0,260.0 360.0,260.0 360.0,40.0 140.0,40.0 140.0,260.0" fill="#4a90d9" fill-opacity="0.08" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0" stroke-dasharray="6,3"/> + <polygon points="176.67,223.33 213.33,223.33 213.33,186.67 176.67,186.67 176.67,223.33" fill="#4a90d9" fill-opacity="0" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0" stroke-dasharray="6,3"/> + <polygon points="250.0,150.0 323.33,150.0 323.33,76.67 250.0,76.67 250.0,150.0" fill="#4a90d9" fill-opacity="0" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0" stroke-dasharray="6,3"/> + <polyline points="176.67,223.33 213.33,223.33 213.33,186.67 176.67,186.67 176.67,223.33" fill="none" stroke="#2ecc71" stroke-width="3" stroke-opacity="1.0"/> + <text x="250.0" y="22" text-anchor="middle" fill="#333" font-size="13" font-weight="bold">N = 0</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_InteriorRingN</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_IsClosed/ST_IsClosed.svg b/docs/image/ST_IsClosed/ST_IsClosed.svg new file mode 100644 index 0000000000..bfbe362eb4 --- /dev/null +++ b/docs/image/ST_IsClosed/ST_IsClosed.svg @@ -0,0 +1,16 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polyline points="103.33,260.0 396.67,260.0 396.67,40.0 103.33,40.0 103.33,260.0" fill="none" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <circle cx="103.33" cy="260.0" r="9" fill="#2ecc71" fill-opacity="0.25" stroke="#2ecc71" stroke-width="2"/> + <circle cx="103.33" cy="260.0" r="6" fill="#2ecc71" fill-opacity="0.9" stroke="white" stroke-width="1.5"/> + <text x="103.33" y="282.0" text-anchor="middle" fill="#2ecc71" font-size="10">Start = End</text> + <rect x="168" y="8" width="164" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="14" font-weight="bold">→ true</text> + <text x="250" y="275" text-anchor="middle" fill="#777" font-size="11">Start = End</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_IsClosed</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_IsCollection/ST_IsCollection.svg b/docs/image/ST_IsCollection/ST_IsCollection.svg new file mode 100644 index 0000000000..872c4a6b63 --- /dev/null +++ b/docs/image/ST_IsCollection/ST_IsCollection.svg @@ -0,0 +1,15 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="40.0" cy="255.0" r="6" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <circle cx="250.0" cy="45.0" r="6" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <circle cx="460.0" cy="150.0" r="6" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <rect x="152" y="8" width="196" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="14" font-weight="bold">→ true</text> + <text x="250" y="275" text-anchor="middle" fill="#777" font-size="11">MULTI* type</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_IsCollection</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_IsEmpty/ST_IsEmpty.svg b/docs/image/ST_IsEmpty/ST_IsEmpty.svg new file mode 100644 index 0000000000..5dcc151a0d --- /dev/null +++ b/docs/image/ST_IsEmpty/ST_IsEmpty.svg @@ -0,0 +1,13 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="250.0" cy="150.0" r="10" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#e74c3c" fill-opacity="0.15" stroke="#e74c3c" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#e74c3c" font-size="14" font-weight="bold">→ false</text> + <text x="250" y="275" text-anchor="middle" fill="#777" font-size="11">Non-empty geometry</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_IsEmpty</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_IsPolygonCCW/ST_IsPolygonCCW.svg b/docs/image/ST_IsPolygonCCW/ST_IsPolygonCCW.svg new file mode 100644 index 0000000000..11378cb95f --- /dev/null +++ b/docs/image/ST_IsPolygonCCW/ST_IsPolygonCCW.svg @@ -0,0 +1,16 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polygon points="140.0,260.0 140.0,40.0 360.0,40.0 360.0,260.0 140.0,260.0" fill="#4a90d9" fill-opacity="0.12" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <polygon points="140.0,150.0 136.0,158.0 144.0,158.0" fill="#4a90d9" fill-opacity="0.8"/> + <polygon points="250.0,40.0 242.0,36.0 242.0,44.0" fill="#4a90d9" fill-opacity="0.8"/> + <polygon points="360.0,150.0 364.0,142.0 356.0,142.0" fill="#4a90d9" fill-opacity="0.8"/> + <polygon points="250.0,260.0 258.0,264.0 258.0,256.0" fill="#4a90d9" fill-opacity="0.8"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="14" font-weight="bold">CCW → true</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_IsPolygonCCW</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_IsPolygonCW/ST_IsPolygonCW.svg b/docs/image/ST_IsPolygonCW/ST_IsPolygonCW.svg new file mode 100644 index 0000000000..4922f1f61e --- /dev/null +++ b/docs/image/ST_IsPolygonCW/ST_IsPolygonCW.svg @@ -0,0 +1,16 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polygon points="140.0,260.0 360.0,260.0 360.0,40.0 140.0,40.0 140.0,260.0" fill="#4a90d9" fill-opacity="0.12" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <polygon points="250.0,260.0 242.0,256.0 242.0,264.0" fill="#4a90d9" fill-opacity="0.8"/> + <polygon points="360.0,150.0 356.0,158.0 364.0,158.0" fill="#4a90d9" fill-opacity="0.8"/> + <polygon points="250.0,40.0 258.0,44.0 258.0,36.0" fill="#4a90d9" fill-opacity="0.8"/> + <polygon points="140.0,150.0 144.0,142.0 136.0,142.0" fill="#4a90d9" fill-opacity="0.8"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="14" font-weight="bold">CW → true</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_IsPolygonCW</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_IsRing/ST_IsRing.svg b/docs/image/ST_IsRing/ST_IsRing.svg new file mode 100644 index 0000000000..dc7a8edaff --- /dev/null +++ b/docs/image/ST_IsRing/ST_IsRing.svg @@ -0,0 +1,16 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polyline points="103.33,260.0 396.67,260.0 396.67,40.0 103.33,40.0 103.33,260.0" fill="none" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <circle cx="103.33" cy="260.0" r="9" fill="#2ecc71" fill-opacity="0.25" stroke="#2ecc71" stroke-width="2"/> + <circle cx="103.33" cy="260.0" r="6" fill="#2ecc71" fill-opacity="0.9" stroke="white" stroke-width="1.5"/> + <text x="103.33" y="282.0" text-anchor="middle" fill="#2ecc71" font-size="10">Start = End</text> + <rect x="176" y="8" width="148" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="14" font-weight="bold">→ true</text> + <text x="250" y="275" text-anchor="middle" fill="#777" font-size="11">Closed + Simple</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_IsRing</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_IsSimple/ST_IsSimple.svg b/docs/image/ST_IsSimple/ST_IsSimple.svg new file mode 100644 index 0000000000..025b8841f7 --- /dev/null +++ b/docs/image/ST_IsSimple/ST_IsSimple.svg @@ -0,0 +1,16 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polyline points="140.0,260.0 360.0,40.0 360.0,260.0 140.0,40.0" fill="none" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <circle cx="250.0" cy="150.0" r="8" fill="#e74c3c" fill-opacity="0.3" stroke="#e74c3c" stroke-width="2"/> + <line x1="245.0" y1="145.0" x2="255.0" y2="155.0" stroke="#e74c3c" stroke-width="2"/> + <line x1="255.0" y1="145.0" x2="245.0" y2="155.0" stroke="#e74c3c" stroke-width="2"/> + <rect x="164" y="8" width="172" height="28" rx="14" fill="#e74c3c" fill-opacity="0.15" stroke="#e74c3c" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#e74c3c" font-size="14" font-weight="bold">→ false</text> + <text x="250" y="275" text-anchor="middle" fill="#777" font-size="11">Self-intersecting</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_IsSimple</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_M/ST_M.svg b/docs/image/ST_M/ST_M.svg new file mode 100644 index 0000000000..9bfbff3802 --- /dev/null +++ b/docs/image/ST_M/ST_M.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="250.0" cy="150.0" r="10" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <rect x="265.0" y="135.0" width="151" height="28" rx="6" fill="#2ecc71" fill-opacity="0.12" stroke="#2ecc71" stroke-width="1.5"/> + <text x="273.0" y="154.0" text-anchor="start" fill="#2ecc71" font-size="14" font-weight="bold">M = null (no M)</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_M</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_NDims/ST_NDims.svg b/docs/image/ST_NDims/ST_NDims.svg new file mode 100644 index 0000000000..70b07747c9 --- /dev/null +++ b/docs/image/ST_NDims/ST_NDims.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="140.0" cy="260.0" r="6" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="15" font-weight="bold">NDims = 2</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_NDims</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_NPoints/ST_NPoints.svg b/docs/image/ST_NPoints/ST_NPoints.svg new file mode 100644 index 0000000000..80944209fb --- /dev/null +++ b/docs/image/ST_NPoints/ST_NPoints.svg @@ -0,0 +1,16 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polyline points="112.5,260.0 167.5,95.0 277.5,150.0 387.5,40.0" fill="none" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <circle cx="112.5" cy="260.0" r="5" fill="#2ecc71" stroke="white" stroke-width="1"/> + <circle cx="167.5" cy="95.0" r="5" fill="#2ecc71" stroke="white" stroke-width="1"/> + <circle cx="277.5" cy="150.0" r="5" fill="#2ecc71" stroke="white" stroke-width="1"/> + <circle cx="387.5" cy="40.0" r="5" fill="#2ecc71" stroke="white" stroke-width="1"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="15" font-weight="bold">NPoints = 4</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_NPoints</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_NRings/ST_NRings.svg b/docs/image/ST_NRings/ST_NRings.svg new file mode 100644 index 0000000000..33554dbcad --- /dev/null +++ b/docs/image/ST_NRings/ST_NRings.svg @@ -0,0 +1,13 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polygon points="140.0,260.0 360.0,260.0 360.0,40.0 140.0,40.0 140.0,260.0" fill="#4a90d9" fill-opacity="0.12" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <polygon points="213.33,186.67 286.67,186.67 286.67,113.33 213.33,113.33 213.33,186.67" fill="#4a90d9" fill-opacity="0" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="15" font-weight="bold">NRings = 2</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_NRings</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_NumGeometries/ST_NumGeometries.svg b/docs/image/ST_NumGeometries/ST_NumGeometries.svg new file mode 100644 index 0000000000..3ba4ba58f7 --- /dev/null +++ b/docs/image/ST_NumGeometries/ST_NumGeometries.svg @@ -0,0 +1,14 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="85.0" cy="205.0" r="6" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <polyline points="140.0,150.0 250.0,40.0" fill="none" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <polygon points="305.0,260.0 415.0,260.0 415.0,150.0 305.0,150.0 305.0,260.0" fill="#4a90d9" fill-opacity="0.12" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="15" font-weight="bold">NumGeometries = 3</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_NumGeometries</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_NumInteriorRing/ST_NumInteriorRing.svg b/docs/image/ST_NumInteriorRing/ST_NumInteriorRing.svg new file mode 100644 index 0000000000..590d700806 --- /dev/null +++ b/docs/image/ST_NumInteriorRing/ST_NumInteriorRing.svg @@ -0,0 +1,14 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polygon points="140.0,260.0 360.0,260.0 360.0,40.0 140.0,40.0 140.0,260.0" fill="#4a90d9" fill-opacity="0.12" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <polygon points="176.67,223.33 213.33,223.33 213.33,186.67 176.67,186.67 176.67,223.33" fill="#4a90d9" fill-opacity="0" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <polygon points="250.0,150.0 323.33,150.0 323.33,76.67 250.0,76.67 250.0,150.0" fill="#4a90d9" fill-opacity="0" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="15" font-weight="bold">InteriorRings = 2</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_NumInteriorRing</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_NumInteriorRings/ST_NumInteriorRings.svg b/docs/image/ST_NumInteriorRings/ST_NumInteriorRings.svg new file mode 100644 index 0000000000..366056f85a --- /dev/null +++ b/docs/image/ST_NumInteriorRings/ST_NumInteriorRings.svg @@ -0,0 +1,14 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polygon points="140.0,260.0 360.0,260.0 360.0,40.0 140.0,40.0 140.0,260.0" fill="#4a90d9" fill-opacity="0.12" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <polygon points="176.67,223.33 213.33,223.33 213.33,186.67 176.67,186.67 176.67,223.33" fill="#4a90d9" fill-opacity="0" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <polygon points="250.0,150.0 323.33,150.0 323.33,76.67 250.0,76.67 250.0,150.0" fill="#4a90d9" fill-opacity="0" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="15" font-weight="bold">InteriorRings = 2</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_NumInteriorRings</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_NumPoints/ST_NumPoints.svg b/docs/image/ST_NumPoints/ST_NumPoints.svg new file mode 100644 index 0000000000..832549c0d9 --- /dev/null +++ b/docs/image/ST_NumPoints/ST_NumPoints.svg @@ -0,0 +1,16 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polyline points="112.5,260.0 167.5,95.0 277.5,150.0 387.5,40.0" fill="none" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0"/> + <circle cx="112.5" cy="260.0" r="5" fill="#2ecc71" stroke="white" stroke-width="1"/> + <circle cx="167.5" cy="95.0" r="5" fill="#2ecc71" stroke="white" stroke-width="1"/> + <circle cx="277.5" cy="150.0" r="5" fill="#2ecc71" stroke="white" stroke-width="1"/> + <circle cx="387.5" cy="40.0" r="5" fill="#2ecc71" stroke="white" stroke-width="1"/> + <rect x="180" y="8" width="140" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="15" font-weight="bold">NumPoints = 4</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_NumPoints</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_PointN/ST_PointN.svg b/docs/image/ST_PointN/ST_PointN.svg new file mode 100644 index 0000000000..e3a0db88ec --- /dev/null +++ b/docs/image/ST_PointN/ST_PointN.svg @@ -0,0 +1,13 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polyline points="103.33,260.0 176.67,40.0 250.0,186.67 323.33,113.33 396.67,260.0 176.67,40.0" fill="none" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0" stroke-dasharray="6,3"/> + <circle cx="176.67" cy="40.0" r="11" fill="#2ecc71" fill-opacity="0.25" stroke="#2ecc71" stroke-width="2"/> + <circle cx="176.67" cy="40.0" r="8" fill="#2ecc71" fill-opacity="0.9" stroke="white" stroke-width="1.5"/> + <text x="250.0" y="22" text-anchor="middle" fill="#333" font-size="13" font-weight="bold">N = 1</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_PointN</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_Points/ST_Points.svg b/docs/image/ST_Points/ST_Points.svg new file mode 100644 index 0000000000..81d078ee92 --- /dev/null +++ b/docs/image/ST_Points/ST_Points.svg @@ -0,0 +1,15 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polygon points="103.33,260.0 396.67,260.0 396.67,40.0 103.33,40.0 103.33,260.0" fill="#4a90d9" fill-opacity="0.08" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0" stroke-dasharray="6,3"/> + <circle cx="103.33" cy="260.0" r="7" fill="#2ecc71" fill-opacity="1.0" stroke="#2ecc71" stroke-width="1.5"/> + <circle cx="396.67" cy="260.0" r="7" fill="#2ecc71" fill-opacity="1.0" stroke="#2ecc71" stroke-width="1.5"/> + <circle cx="396.67" cy="40.0" r="7" fill="#2ecc71" fill-opacity="1.0" stroke="#2ecc71" stroke-width="1.5"/> + <circle cx="103.33" cy="40.0" r="7" fill="#2ecc71" fill-opacity="1.0" stroke="#2ecc71" stroke-width="1.5"/> + <circle cx="103.33" cy="260.0" r="7" fill="#2ecc71" fill-opacity="1.0" stroke="#2ecc71" stroke-width="1.5"/> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_Points</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_StartPoint/ST_StartPoint.svg b/docs/image/ST_StartPoint/ST_StartPoint.svg new file mode 100644 index 0000000000..027b85a1f1 --- /dev/null +++ b/docs/image/ST_StartPoint/ST_StartPoint.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <polyline points="103.33,260.0 176.67,113.33 323.33,186.67 396.67,40.0 103.33,260.0" fill="none" stroke="#4a90d9" stroke-width="2.5" stroke-opacity="1.0" stroke-dasharray="6,3"/> + <circle cx="103.33" cy="260.0" r="11" fill="#2ecc71" fill-opacity="0.25" stroke="#2ecc71" stroke-width="2"/> + <circle cx="103.33" cy="260.0" r="8" fill="#2ecc71" fill-opacity="0.9" stroke="white" stroke-width="1.5"/> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_StartPoint</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_X/ST_X.svg b/docs/image/ST_X/ST_X.svg new file mode 100644 index 0000000000..e51b6bdb7c --- /dev/null +++ b/docs/image/ST_X/ST_X.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="250.0" cy="150.0" r="10" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <rect x="265.0" y="135.0" width="79" height="28" rx="6" fill="#2ecc71" fill-opacity="0.12" stroke="#2ecc71" stroke-width="1.5"/> + <text x="273.0" y="154.0" text-anchor="start" fill="#2ecc71" font-size="14" font-weight="bold">X = 3.0</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_X</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_Y/ST_Y.svg b/docs/image/ST_Y/ST_Y.svg new file mode 100644 index 0000000000..dfc2731c8d --- /dev/null +++ b/docs/image/ST_Y/ST_Y.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="250.0" cy="150.0" r="10" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <rect x="265.0" y="135.0" width="79" height="28" rx="6" fill="#2ecc71" fill-opacity="0.12" stroke="#2ecc71" stroke-width="1.5"/> + <text x="273.0" y="154.0" text-anchor="start" fill="#2ecc71" font-size="14" font-weight="bold">Y = 2.0</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_Y</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_Z/ST_Z.svg b/docs/image/ST_Z/ST_Z.svg new file mode 100644 index 0000000000..fb5d8f8ef9 --- /dev/null +++ b/docs/image/ST_Z/ST_Z.svg @@ -0,0 +1,12 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="250.0" cy="150.0" r="10" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <rect x="265.0" y="135.0" width="187" height="28" rx="6" fill="#2ecc71" fill-opacity="0.12" stroke="#2ecc71" stroke-width="1.5"/> + <text x="273.0" y="154.0" text-anchor="start" fill="#2ecc71" font-size="14" font-weight="bold">Z = null (2D point)</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_Z</text> +</svg> \ No newline at end of file diff --git a/docs/image/ST_Zmflag/ST_Zmflag.svg b/docs/image/ST_Zmflag/ST_Zmflag.svg new file mode 100644 index 0000000000..19705ca6e1 --- /dev/null +++ b/docs/image/ST_Zmflag/ST_Zmflag.svg @@ -0,0 +1,13 @@ +<svg xmlns="http://www.w3.org/2000/svg"; width="500" height="300" viewBox="0 0 500 300"> + <defs> + <style> + text { font-family: Arial, Helvetica, sans-serif; } + </style> + </defs> + <rect width="500" height="300" fill="white" rx="8"/> + <circle cx="250.0" cy="150.0" r="12" fill="#4a90d9" fill-opacity="1.0" stroke="#4a90d9" stroke-width="1.5"/> + <rect x="190" y="8" width="120" height="28" rx="14" fill="#2ecc71" fill-opacity="0.15" stroke="#2ecc71" stroke-width="1.5"/> + <text x="250" y="27" text-anchor="middle" fill="#2ecc71" font-size="15" font-weight="bold">Zmflag = 0</text> + <text x="250" y="50" text-anchor="middle" fill="#777" font-size="12">(2D)</text> + <text x="490" y="290" text-anchor="end" fill="#999" font-size="11">ST_Zmflag</text> +</svg> \ No newline at end of file
