This is an automated email from the ASF dual-hosted git repository.
jiayu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/sedona.git
The following commit(s) were added to refs/heads/master by this push:
new 8c2bc7130 [DOCS] Reorder Constructor page (#1330)
8c2bc7130 is described below
commit 8c2bc71305d135017ef0649eac20892732dd1fff
Author: Furqaan Khan <[email protected]>
AuthorDate: Wed Apr 10 17:08:17 2024 -0400
[DOCS] Reorder Constructor page (#1330)
---
docs/api/flink/Constructor.md | 188 +++++++++++------------
docs/api/snowflake/vector-data/Constructor.md | 182 +++++++++++-----------
docs/api/sql/Constructor.md | 212 +++++++++++++-------------
3 files changed, 291 insertions(+), 291 deletions(-)
diff --git a/docs/api/flink/Constructor.md b/docs/api/flink/Constructor.md
index 49d8e3cd8..1459e19ca 100644
--- a/docs/api/flink/Constructor.md
+++ b/docs/api/flink/Constructor.md
@@ -1,3 +1,52 @@
+## ST_GeomFromEWKT
+
+Introduction: Construct a Geometry from OGC Extended WKT
+
+Format:
+`ST_GeomFromEWKT (EWkt: String)`
+
+Since: `v1.5.0`
+
+Example:
+```sql
+SELECT ST_AsText(ST_GeomFromEWKT('SRID=4269;POINT(40.7128 -74.0060)'))
+```
+
+Output:
+
+```
+POINT(40.7128 -74.006)
+```
+
+## ST_GeomFromGML
+
+Introduction: Construct a Geometry from GML.
+
+Format:
+`ST_GeomFromGML (gml: String)`
+
+Since: `v1.3.0`
+
+Example:
+
+```sql
+SELECT ST_GeomFromGML('
+ <gml:LineString srsName="EPSG:4269">
+ <gml:coordinates>
+ -71.16028,42.258729
+ -71.160837,42.259112
+ -71.161143,42.25932
+ </gml:coordinates>
+ </gml:LineString>
+')
+```
+
+Output:
+
+```
+LINESTRING (-71.16028 42.258729, -71.160837 42.259112, -71.161143 42.25932)
+```
+
## ST_GeomFromGeoHash
Introduction: Create Geometry from geohash string and optional precision
@@ -87,35 +136,6 @@ Output:
POLYGON ((-87.621765 34.873444, -87.617535 34.873369, -87.62119 34.85053,
-87.62144 34.865379, -87.621765 34.873444))
```
-## ST_GeomFromGML
-
-Introduction: Construct a Geometry from GML.
-
-Format:
-`ST_GeomFromGML (gml: String)`
-
-Since: `v1.3.0`
-
-Example:
-
-```sql
-SELECT ST_GeomFromGML('
- <gml:LineString srsName="EPSG:4269">
- <gml:coordinates>
- -71.16028,42.258729
- -71.160837,42.259112
- -71.161143,42.25932
- </gml:coordinates>
- </gml:LineString>
-')
-```
-
-Output:
-
-```
-LINESTRING (-71.16028 42.258729, -71.160837 42.259112, -71.161143 42.25932)
-```
-
## ST_GeomFromKML
Introduction: Construct a Geometry from KML.
@@ -232,26 +252,6 @@ Output:
POINT(40.7128 -74.006)
```
-## ST_GeomFromEWKT
-
-Introduction: Construct a Geometry from OGC Extended WKT
-
-Format:
-`ST_GeomFromEWKT (EWkt: String)`
-
-Since: `v1.5.0`
-
-Example:
-```sql
-SELECT ST_AsText(ST_GeomFromEWKT('SRID=4269;POINT(40.7128 -74.0060)'))
-```
-
-Output:
-
-```
-POINT(40.7128 -74.006)
-```
-
## ST_LineFromText
Introduction: Construct a LineString from Text
@@ -291,88 +291,88 @@ Output:
LINESTRING (-74.0428197 40.6867969, -74.0421975 40.6921336, -74.050802
40.6912794)
```
-## ST_MakePoint
+## ST_MLineFromText
-Introduction: Creates a 2D, 3D Z or 4D ZM Point geometry. Use ST_MakePointM to
make points with XYM coordinates. Z and M values are optional.
+Introduction: Construct a MultiLineString from Text and Optional SRID
-Format: `ST_MakePoint (X: Double, Y: Double, Z: Double, M: Double)`
+Format: `ST_MLineFromText (Text: String, Srid: Integer)`
-Since: `v1.5.0`
+Since: `1.3.1`
Example:
```sql
-SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456));
+SELECT ST_MLineFromText('MULTILINESTRING((1 2, 3 4), (4 5, 6 7))')
```
Output:
```
-POINT (1.2345 2.3456)
+MULTILINESTRING ((1 2, 3 4), (4 5, 6 7))
```
-Example:
+## ST_MPolyFromText
-```sql
-SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567));
-```
+Introduction: Construct a MultiPolygon from Text and Optional SRID
-Output:
+Format: `ST_MPolyFromText (Text: String, Srid: Integer)`
-```
-POINT Z (1.2345 2.3456 3.4567)
-```
+Since: `1.3.1`
Example:
```sql
-SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567, 4));
+SELECT ST_MPolyFromText('MULTIPOLYGON(((0 0 1,20 0 1,20 20 1,0 20 1,0 0 1),(5
5 3,5 7 3,7 7 3,7 5 3,5 5 3)))')
```
Output:
```
-POINT ZM (1.2345 2.3456 3.4567 4)
+MULTIPOLYGON (((0 0, 20 0, 20 20, 0 20, 0 0), (5 5, 5 7, 7 7, 7 5, 5 5)))
```
-## ST_MLineFromText
+## ST_MakePoint
-Introduction: Construct a MultiLineString from Text and Optional SRID
+Introduction: Creates a 2D, 3D Z or 4D ZM Point geometry. Use ST_MakePointM to
make points with XYM coordinates. Z and M values are optional.
-Format: `ST_MLineFromText (Text: String, Srid: Integer)`
+Format: `ST_MakePoint (X: Double, Y: Double, Z: Double, M: Double)`
-Since: `1.3.1`
+Since: `v1.5.0`
Example:
```sql
-SELECT ST_MLineFromText('MULTILINESTRING((1 2, 3 4), (4 5, 6 7))')
+SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456));
```
Output:
```
-MULTILINESTRING ((1 2, 3 4), (4 5, 6 7))
+POINT (1.2345 2.3456)
```
-## ST_MPolyFromText
+Example:
-Introduction: Construct a MultiPolygon from Text and Optional SRID
+```sql
+SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567));
+```
-Format: `ST_MPolyFromText (Text: String, Srid: Integer)`
+Output:
-Since: `1.3.1`
+```
+POINT Z (1.2345 2.3456 3.4567)
+```
Example:
```sql
-SELECT ST_MPolyFromText('MULTIPOLYGON(((0 0 1,20 0 1,20 20 1,0 20 1,0 0 1),(5
5 3,5 7 3,7 7 3,7 5 3,5 5 3)))')
+SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567, 4));
```
Output:
```
-MULTIPOLYGON (((0 0, 20 0, 20 20, 0 20, 0 0), (5 5, 5 7, 7 7, 7 5, 5 5)))
+POINT ZM (1.2345 2.3456 3.4567 4)
```
## ST_Point
@@ -395,49 +395,49 @@ Output:
POINT (1.2345 2.3456)
```
-## ST_PointZ
-
-Introduction: Construct a Point from X, Y and Z and an optional srid. If srid
is not set, it defaults to 0 (unknown).
-Must use ST_AsEWKT function to print the Z coordinate.
-
-Format:
+## ST_PointFromText
-`ST_PointZ (X: Double, Y: Double, Z: Double)`
+Introduction: Construct a Point from Text, delimited by Delimiter
-`ST_PointZ (X: Double, Y: Double, Z: Double, srid: Integer)`
+Format: `ST_PointFromText (Text: String, Delimiter: Char)`
-Since: `v1.5.0`
+Since: `v1.2.0`
Example:
```sql
-SELECT ST_AsEWKT(ST_PointZ(1.2345, 2.3456, 3.4567))
+SELECT ST_PointFromText('40.7128,-74.0060', ',')
```
Output:
```
-POINT Z(1.2345 2.3456 3.4567)
+POINT (40.7128 -74.006)
```
-## ST_PointFromText
+## ST_PointZ
-Introduction: Construct a Point from Text, delimited by Delimiter
+Introduction: Construct a Point from X, Y and Z and an optional srid. If srid
is not set, it defaults to 0 (unknown).
+Must use ST_AsEWKT function to print the Z coordinate.
-Format: `ST_PointFromText (Text: String, Delimiter: Char)`
+Format:
-Since: `v1.2.0`
+`ST_PointZ (X: Double, Y: Double, Z: Double)`
+
+`ST_PointZ (X: Double, Y: Double, Z: Double, srid: Integer)`
+
+Since: `v1.5.0`
Example:
```sql
-SELECT ST_PointFromText('40.7128,-74.0060', ',')
+SELECT ST_AsEWKT(ST_PointZ(1.2345, 2.3456, 3.4567))
```
Output:
```
-POINT (40.7128 -74.006)
+POINT Z(1.2345 2.3456 3.4567)
```
## ST_PolygonFromEnvelope
diff --git a/docs/api/snowflake/vector-data/Constructor.md
b/docs/api/snowflake/vector-data/Constructor.md
index f0cb09b9f..ae18496c6 100644
--- a/docs/api/snowflake/vector-data/Constructor.md
+++ b/docs/api/snowflake/vector-data/Constructor.md
@@ -1,6 +1,51 @@
!!!note
Please always keep the schema name `SEDONA` (e.g.,
`SEDONA.ST_GeomFromWKT`) when you use Sedona functions to avoid conflicting
with Snowflake's built-in functions.
+## ST_GeomFromEWKT
+
+Introduction: Construct a Geometry from OGC Extended WKT
+
+Format:
+`ST_GeomFromEWKT (EWkt:string)`
+
+SQL example:
+```sql
+SELECT ST_AsText(ST_GeomFromEWKT('SRID=4269;POINT(40.7128 -74.0060)'))
+```
+
+Output:
+
+```
+POINT(40.7128 -74.006)
+```
+
+## ST_GeomFromGML
+
+Introduction: Construct a Geometry from GML.
+
+Format:
+`ST_GeomFromGML (gml:string)`
+
+SQL example:
+
+```sql
+SELECT ST_GeomFromGML('
+ <gml:LineString srsName="EPSG:4269">
+ <gml:coordinates>
+ -71.16028,42.258729
+ -71.160837,42.259112
+ -71.161143,42.25932
+ </gml:coordinates>
+ </gml:LineString>
+')
+```
+
+Output:
+
+```
+LINESTRING (-71.16028 42.258729, -71.160837 42.259112, -71.161143 42.25932)
+```
+
## ST_GeomFromGeoHash
Introduction: Create Geometry from geohash string and optional precision
@@ -86,33 +131,6 @@ Output:
POLYGON ((-87.621765 34.873444, -87.617535 34.873369, -87.62119 34.85053,
-87.62144 34.865379, -87.621765 34.873444))
```
-## ST_GeomFromGML
-
-Introduction: Construct a Geometry from GML.
-
-Format:
-`ST_GeomFromGML (gml:string)`
-
-SQL example:
-
-```sql
-SELECT ST_GeomFromGML('
- <gml:LineString srsName="EPSG:4269">
- <gml:coordinates>
- -71.16028,42.258729
- -71.160837,42.259112
- -71.161143,42.25932
- </gml:coordinates>
- </gml:LineString>
-')
-```
-
-Output:
-
-```
-LINESTRING (-71.16028 42.258729, -71.160837 42.259112, -71.161143 42.25932)
-```
-
## ST_GeomFromKML
Introduction: Construct a Geometry from KML.
@@ -213,24 +231,6 @@ Output:
POINT(40.7128 -74.006)
```
-## ST_GeomFromEWKT
-
-Introduction: Construct a Geometry from OGC Extended WKT
-
-Format:
-`ST_GeomFromEWKT (EWkt:string)`
-
-SQL example:
-```sql
-SELECT ST_AsText(ST_GeomFromEWKT('SRID=4269;POINT(40.7128 -74.0060)'))
-```
-
-Output:
-
-```
-POINT(40.7128 -74.006)
-```
-
## ST_LineFromText
Introduction: Construct a Line from Wkt text
@@ -268,86 +268,86 @@ Output:
LINESTRING (-74.0428197 40.6867969, -74.0421975 40.6921336, -74.050802
40.6912794)
```
-## ST_MakePoint
+## ST_MLineFromText
-Introduction: Creates a 2D, 3D Z or 4D ZM Point geometry. Use ST_MakePointM to
make points with XYM coordinates. Z and M values are optional.
+Introduction: Construct a MultiLineString from Wkt. If srid is not set, it
defaults to 0 (unknown).
-Format: `ST_MakePoint (X:decimal, Y:decimal, Z:decimal, M:decimal)`
+Format:
+`ST_MLineFromText (Wkt:string)`
+`ST_MLineFromText (Wkt:string, srid:integer)`
-Example:
+SQL example:
```sql
-SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456));
+SELECT ST_MLineFromText('MULTILINESTRING((1 2, 3 4), (4 5, 6 7))')
```
Output:
```
-POINT (1.2345 2.3456)
+MULTILINESTRING ((1 2, 3 4), (4 5, 6 7))
```
-Example:
+## ST_MPolyFromText
+
+Introduction: Construct a MultiPolygon from Wkt. If srid is not set, it
defaults to 0 (unknown).
+
+Format:
+`ST_MPolyFromText (Wkt:string)`
+`ST_MPolyFromText (Wkt:string, srid:integer)`
+
+SQL example:
```sql
-SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567));
+SELECT ST_MPolyFromText('MULTIPOLYGON(((0 0 1,20 0 1,20 20 1,0 20 1,0 0 1),(5
5 3,5 7 3,7 7 3,7 5 3,5 5 3)))')
```
Output:
```
-POINT Z (1.2345 2.3456 3.4567)
+MULTIPOLYGON (((0 0, 20 0, 20 20, 0 20, 0 0), (5 5, 5 7, 7 7, 7 5, 5 5)))
```
+## ST_MakePoint
+
+Introduction: Creates a 2D, 3D Z or 4D ZM Point geometry. Use ST_MakePointM to
make points with XYM coordinates. Z and M values are optional.
+
+Format: `ST_MakePoint (X:decimal, Y:decimal, Z:decimal, M:decimal)`
+
Example:
```sql
-SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567, 4));
+SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456));
```
Output:
```
-POINT ZM (1.2345 2.3456 3.4567 4)
+POINT (1.2345 2.3456)
```
-## ST_MLineFromText
-
-Introduction: Construct a MultiLineString from Wkt. If srid is not set, it
defaults to 0 (unknown).
-
-Format:
-`ST_MLineFromText (Wkt:string)`
-`ST_MLineFromText (Wkt:string, srid:integer)`
-
-SQL example:
+Example:
```sql
-SELECT ST_MLineFromText('MULTILINESTRING((1 2, 3 4), (4 5, 6 7))')
+SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567));
```
Output:
```
-MULTILINESTRING ((1 2, 3 4), (4 5, 6 7))
+POINT Z (1.2345 2.3456 3.4567)
```
-## ST_MPolyFromText
-
-Introduction: Construct a MultiPolygon from Wkt. If srid is not set, it
defaults to 0 (unknown).
-
-Format:
-`ST_MPolyFromText (Wkt:string)`
-`ST_MPolyFromText (Wkt:string, srid:integer)`
-
-SQL example:
+Example:
```sql
-SELECT ST_MPolyFromText('MULTIPOLYGON(((0 0 1,20 0 1,20 20 1,0 20 1,0 0 1),(5
5 3,5 7 3,7 7 3,7 5 3,5 5 3)))')
+SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567, 4));
```
Output:
```
-MULTIPOLYGON (((0 0, 20 0, 20 20, 0 20, 0 0), (5 5, 5 7, 7 7, 7 5, 5 5)))
+POINT ZM (1.2345 2.3456 3.4567 4)
```
## ST_Point
@@ -371,41 +371,41 @@ Output:
POINT (1.2345 2.3456)
```
-## ST_PointZ
+## ST_PointFromText
-Introduction: Construct a Point from X, Y and Z and an optional srid. If srid
is not set, it defaults to 0 (unknown).
-Must use ST_AsEWKT function to print the Z coordinate.
+Introduction: Construct a Point from Text, delimited by Delimiter
-Format: `ST_PointZ (X:decimal, Y:decimal, Z:decimal)`
+Format: `ST_PointFromText (Text:string, Delimiter:char)`
-Format: `ST_PointZ (X:decimal, Y:decimal, Z:decimal, srid:integer)`
+SQL example:
```sql
-SELECT ST_AsEWKT(ST_PointZ(1.2345, 2.3456, 3.4567))
+SELECT ST_PointFromText('40.7128,-74.0060', ',')
```
Output:
```
-POINT Z(1.2345 2.3456 3.4567)
+POINT (40.7128 -74.006)
```
-## ST_PointFromText
+## ST_PointZ
-Introduction: Construct a Point from Text, delimited by Delimiter
+Introduction: Construct a Point from X, Y and Z and an optional srid. If srid
is not set, it defaults to 0 (unknown).
+Must use ST_AsEWKT function to print the Z coordinate.
-Format: `ST_PointFromText (Text:string, Delimiter:char)`
+Format: `ST_PointZ (X:decimal, Y:decimal, Z:decimal)`
-SQL example:
+Format: `ST_PointZ (X:decimal, Y:decimal, Z:decimal, srid:integer)`
```sql
-SELECT ST_PointFromText('40.7128,-74.0060', ',')
+SELECT ST_AsEWKT(ST_PointZ(1.2345, 2.3456, 3.4567))
```
Output:
```
-POINT (40.7128 -74.006)
+POINT Z(1.2345 2.3456 3.4567)
```
## ST_PolygonFromEnvelope
diff --git a/docs/api/sql/Constructor.md b/docs/api/sql/Constructor.md
index abef2d7bd..f330a0fb0 100644
--- a/docs/api/sql/Constructor.md
+++ b/docs/api/sql/Constructor.md
@@ -44,6 +44,55 @@ Example:
System.setProperty("sedona.global.charset", "utf8")
```
+## ST_GeomFromEWKT
+
+Introduction: Construct a Geometry from OGC Extended WKT
+
+Format:
+`ST_GeomFromEWKT (EWkt: String)`
+
+Since: `v1.5.0`
+
+SQL example:
+```sql
+SELECT ST_AsText(ST_GeomFromEWKT('SRID=4269;POINT(40.7128 -74.0060)'))
+```
+
+Output:
+
+```
+POINT(40.7128 -74.006)
+```
+
+## ST_GeomFromGML
+
+Introduction: Construct a Geometry from GML.
+
+Format:
+`ST_GeomFromGML (gml: String)`
+
+Since: `v1.3.0`
+
+SQL example:
+
+```sql
+SELECT ST_GeomFromGML('
+ <gml:LineString srsName="EPSG:4269">
+ <gml:coordinates>
+ -71.16028,42.258729
+ -71.160837,42.259112
+ -71.161143,42.25932
+ </gml:coordinates>
+ </gml:LineString>
+')
+```
+
+Output:
+
+```
+LINESTRING (-71.16028 42.258729, -71.160837 42.259112, -71.161143 42.25932)
+```
+
## ST_GeomFromGeoHash
Introduction: Create Geometry from geohash string and optional precision
@@ -136,35 +185,6 @@ POLYGON ((-87.621765 34.873444, -87.617535 34.873369,
-87.62119 34.85053, -87.62
!!!warning
The way that SedonaSQL reads GeoJSON is different from that in SparkSQL
-## ST_GeomFromGML
-
-Introduction: Construct a Geometry from GML.
-
-Format:
-`ST_GeomFromGML (gml: String)`
-
-Since: `v1.3.0`
-
-SQL example:
-
-```sql
-SELECT ST_GeomFromGML('
- <gml:LineString srsName="EPSG:4269">
- <gml:coordinates>
- -71.16028,42.258729
- -71.160837,42.259112
- -71.161143,42.25932
- </gml:coordinates>
- </gml:LineString>
-')
-```
-
-Output:
-
-```
-LINESTRING (-71.16028 42.258729, -71.160837 42.259112, -71.161143 42.25932)
-```
-
## ST_GeomFromKML
Introduction: Construct a Geometry from KML.
@@ -281,26 +301,6 @@ Output:
POINT(40.7128 -74.006)
```
-## ST_GeomFromEWKT
-
-Introduction: Construct a Geometry from OGC Extended WKT
-
-Format:
-`ST_GeomFromEWKT (EWkt: String)`
-
-Since: `v1.5.0`
-
-SQL example:
-```sql
-SELECT ST_AsText(ST_GeomFromEWKT('SRID=4269;POINT(40.7128 -74.0060)'))
-```
-
-Output:
-
-```
-POINT(40.7128 -74.006)
-```
-
## ST_LineFromText
Introduction: Construct a Line from Wkt text
@@ -342,96 +342,96 @@ Output:
LINESTRING (-74.0428197 40.6867969, -74.0421975 40.6921336, -74.050802
40.6912794)
```
-## ST_MakePoint
+## ST_MLineFromText
-Introduction: Creates a 2D, 3D Z or 4D ZM Point geometry. Use ST_MakePointM to
make points with XYM coordinates. Z and M values are optional.
+Introduction: Construct a MultiLineString from Wkt. If srid is not set, it
defaults to 0 (unknown).
-Format: `ST_MakePoint (X: Double, Y: Double, Z: Double, M: Double)`
+Format:
-Since: `v1.5.0`
+`ST_MLineFromText (Wkt: String)`
-Example:
+`ST_MLineFromText (Wkt: String, srid: Integer)`
+
+Since: `v1.3.1`
+
+SQL Example
```sql
-SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456));
+SELECT ST_MLineFromText('MULTILINESTRING((1 2, 3 4), (4 5, 6 7))')
```
Output:
```
-POINT (1.2345 2.3456)
+MULTILINESTRING ((1 2, 3 4), (4 5, 6 7))
```
-Example:
+## ST_MPolyFromText
-```sql
-SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567));
-```
+Introduction: Construct a MultiPolygon from Wkt. If srid is not set, it
defaults to 0 (unknown).
-Output:
+Format:
-```
-POINT Z (1.2345 2.3456 3.4567)
-```
+`ST_MPolyFromText (Wkt: String)`
-Example:
+`ST_MPolyFromText (Wkt: String, srid: Integer)`
+
+Since: `v1.3.1`
+
+SQL Example
```sql
-SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567, 4));
+SELECT ST_MPolyFromText('MULTIPOLYGON(((0 0 1,20 0 1,20 20 1,0 20 1,0 0 1),(5
5 3,5 7 3,7 7 3,7 5 3,5 5 3)))')
```
Output:
```
-POINT ZM (1.2345 2.3456 3.4567 4)
+MULTIPOLYGON (((0 0, 20 0, 20 20, 0 20, 0 0), (5 5, 5 7, 7 7, 7 5, 5 5)))
```
-## ST_MLineFromText
-
-Introduction: Construct a MultiLineString from Wkt. If srid is not set, it
defaults to 0 (unknown).
-
-Format:
+## ST_MakePoint
-`ST_MLineFromText (Wkt: String)`
+Introduction: Creates a 2D, 3D Z or 4D ZM Point geometry. Use ST_MakePointM to
make points with XYM coordinates. Z and M values are optional.
-`ST_MLineFromText (Wkt: String, srid: Integer)`
+Format: `ST_MakePoint (X: Double, Y: Double, Z: Double, M: Double)`
-Since: `v1.3.1`
+Since: `v1.5.0`
-SQL Example
+Example:
```sql
-SELECT ST_MLineFromText('MULTILINESTRING((1 2, 3 4), (4 5, 6 7))')
+SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456));
```
Output:
```
-MULTILINESTRING ((1 2, 3 4), (4 5, 6 7))
+POINT (1.2345 2.3456)
```
-## ST_MPolyFromText
-
-Introduction: Construct a MultiPolygon from Wkt. If srid is not set, it
defaults to 0 (unknown).
-
-Format:
+Example:
-`ST_MPolyFromText (Wkt: String)`
+```sql
+SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567));
+```
-`ST_MPolyFromText (Wkt: String, srid: Integer)`
+Output:
-Since: `v1.3.1`
+```
+POINT Z (1.2345 2.3456 3.4567)
+```
-SQL Example
+Example:
```sql
-SELECT ST_MPolyFromText('MULTIPOLYGON(((0 0 1,20 0 1,20 20 1,0 20 1,0 0 1),(5
5 3,5 7 3,7 7 3,7 5 3,5 5 3)))')
+SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567, 4));
```
Output:
```
-MULTIPOLYGON (((0 0, 20 0, 20 20, 0 20, 0 0), (5 5, 5 7, 7 7, 7 5, 5 5)))
+POINT ZM (1.2345 2.3456 3.4567 4)
```
## ST_Point
@@ -457,49 +457,49 @@ Output:
POINT (1.2345 2.3456)
```
-## ST_PointZ
-
-Introduction: Construct a Point from X, Y and Z and an optional srid. If srid
is not set, it defaults to 0 (unknown).
-Must use ST_AsEWKT function to print the Z coordinate.
-
-Format:
+## ST_PointFromText
-`ST_PointZ (X: Double, Y: Double, Z: Double)`
+Introduction: Construct a Point from Text, delimited by Delimiter
-`ST_PointZ (X: Double, Y: Double, Z: Double, srid: Integer)`
+Format: `ST_PointFromText (Text: String, Delimiter: Char)`
-Since: `v1.4.0`
+Since: `v1.0.0`
SQL Example
```sql
-SELECT ST_AsEWKT(ST_PointZ(1.2345, 2.3456, 3.4567))
+SELECT ST_PointFromText('40.7128,-74.0060', ',')
```
Output:
```
-POINT Z(1.2345 2.3456 3.4567)
+POINT (40.7128 -74.006)
```
-## ST_PointFromText
+## ST_PointZ
-Introduction: Construct a Point from Text, delimited by Delimiter
+Introduction: Construct a Point from X, Y and Z and an optional srid. If srid
is not set, it defaults to 0 (unknown).
+Must use ST_AsEWKT function to print the Z coordinate.
-Format: `ST_PointFromText (Text: String, Delimiter: Char)`
+Format:
-Since: `v1.0.0`
+`ST_PointZ (X: Double, Y: Double, Z: Double)`
+
+`ST_PointZ (X: Double, Y: Double, Z: Double, srid: Integer)`
+
+Since: `v1.4.0`
SQL Example
```sql
-SELECT ST_PointFromText('40.7128,-74.0060', ',')
+SELECT ST_AsEWKT(ST_PointZ(1.2345, 2.3456, 3.4567))
```
Output:
```
-POINT (40.7128 -74.006)
+POINT Z(1.2345 2.3456 3.4567)
```
## ST_PolygonFromEnvelope
