Constructors

ST_GeomCollFromText

Introduction: Constructs a GeometryCollection from the WKT with the given SRID. If SRID is not provided then it defaults to 0. It returns null if the WKT is not a GEOMETRYCOLLECTION. Format: ST_GeomCollFromText (Wkt: String) ST_GeomCollFromText (Wkt: String, srid: Integer) SQL Example:

SELECT ST_GeomCollFromText('GEOMETRYCOLLECTION (POINT (50 50), LINESTRING (20 30, 40 60, 80 90), POLYGON ((30 10, 40 20, 30 20, 30 10), (35 15, 45 15, 40 25, 35 15)))')

Output:

GEOMETRYCOLLECTION (POINT (50 50), LINESTRING (20 30, 40 60, 80 90), POLYGON ((30 10, 40 20, 30 20, 30 10), (35 15, 45 15, 40 25, 35 15)))

ST_GeomFromEWKB

Introduction: Construct a Geometry from EWKB string or Binary. This function is an alias of ST_GeomFromWKB. Format: ST_GeomFromEWKB (Wkb: String) ST_GeomFromEWKB (Wkb: Binary) SQL Example

SELECT ST_GeomFromEWKB([01 02 00 00 00 02 00 00 00 00 00 00 00 84 D6 00 C0 00 00 00 00 80 B5 D6 BF 00 00 00 60 E1 EF F7 BF 00 00 00 80 07 5D E5 BF])

Output:

LINESTRING (-2.1047439575195312 -0.354827880859375, -1.49606454372406 -0.6676061153411865)

SQL Example

SELECT ST_asEWKT(ST_GeomFromEWKB('01010000a0e6100000000000000000f03f000000000000f03f000000000000f03f'))

Output:

SRID=4326;POINT Z(1 1 1)

ST_GeomFromEWKT

Introduction: Construct a Geometry from OGC Extended WKT Format: ST_GeomFromEWKT (EWkt: String) SQL example:

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.

This function only supports GML 1 and GML 2. GML 3 is not supported.

Format: ST_GeomFromGML (gml: String) SQL example:

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 Format: ST_GeomFromGeoHash(geohash: String, precision: Integer) SQL Example

SELECT ST_GeomFromGeoHash('s00twy01mt', 4)

Output:

POLYGON ((0.703125 0.87890625, 0.703125 1.0546875, 1.0546875 1.0546875, 1.0546875 0.87890625, 0.703125 0.87890625))

ST_GeomFromGeoJSON

Introduction: Construct a Geometry from GeoJson Format: ST_GeomFromGeoJSON (GeoJson: String) SQL Example

SELECT ST_GeomFromGeoJSON('{
   "type":"Feature",
   "properties":{
      "STATEFP":"01",
      "COUNTYFP":"077",
      "TRACTCE":"011501",
      "BLKGRPCE":"5",
      "AFFGEOID":"1500000US010770115015",
      "GEOID":"010770115015",
      "NAME":"5",
      "LSAD":"BG",
      "ALAND":6844991,
      "AWATER":32636
   },
   "geometry":{
      "type":"Polygon",
      "coordinates":[
         [
            [-87.621765, 34.873444],
            [-87.617535, 34.873369],
            [-87.62119, 34.85053],
            [-87.62144, 34.865379],
            [-87.621765, 34.873444]
         ]
      ]
   }
}')

Output:

POLYGON ((-87.621765 34.873444, -87.617535 34.873369, -87.62119 34.85053, -87.62144 34.865379, -87.621765 34.873444))

SQL Example

SELECT ST_GeomFromGeoJSON('{
   "type":"Polygon",
   "coordinates":[
	  [
	 	 [-87.621765, 34.873444],
 		 [-87.617535, 34.873369],
		 [-87.62119, 34.85053],
		 [-87.62144, 34.865379],
		 [-87.621765, 34.873444]
	  ]
   ]
}')

Output:

POLYGON ((-87.621765 34.873444, -87.617535 34.873369, -87.62119 34.85053, -87.62144 34.865379, -87.621765 34.873444))

The way that WherobotsDB reads GeoJSON is different from that in SparkSQL

ST_GeomFromKML

Introduction: Construct a Geometry from KML. Format: ST_GeomFromKML (kml: String) SQL example:

SELECT ST_GeomFromKML('
	<LineString>
		<coordinates>
			-71.1663,42.2614
			-71.1667,42.2616
		</coordinates>
	</LineString>
')

Output:

LINESTRING (-71.1663 42.2614, -71.1667 42.2616)

ST_GeomFromText

Introduction: Construct a Geometry from WKT. If SRID is not set, it defaults to 0 (unknown). Alias of ST_GeomFromWKT Format: ST_GeomFromText (Wkt: String) ST_GeomFromText (Wkt: String, srid: Integer) SQL Example

SELECT ST_GeomFromText('POINT(40.7128 -74.0060)')

Output:

POINT(40.7128 -74.006)

ST_GeomFromWKB

Introduction: Construct a Geometry from WKB string or Binary. This function also supports EWKB format. Format: ST_GeomFromWKB (Wkb: String) ST_GeomFromWKB (Wkb: Binary) SQL Example

SELECT ST_GeomFromWKB([01 02 00 00 00 02 00 00 00 00 00 00 00 84 D6 00 C0 00 00 00 00 80 B5 D6 BF 00 00 00 60 E1 EF F7 BF 00 00 00 80 07 5D E5 BF])

Output:

LINESTRING (-2.1047439575195312 -0.354827880859375, -1.49606454372406 -0.6676061153411865)

SQL Example

SELECT ST_asEWKT(ST_GeomFromWKB('01010000a0e6100000000000000000f03f000000000000f03f000000000000f03f'))

Output:

SRID=4326;POINT Z(1 1 1)

ST_GeomFromWKT

Introduction: Construct a Geometry from WKT. If SRID is not set, it defaults to 0 (unknown). Format: ST_GeomFromWKT (Wkt: String) ST_GeomFromWKT (Wkt: String, srid: Integer) The optional srid parameter was added in v1.3.1 SQL Example

SELECT ST_GeomFromWKT('POINT(40.7128 -74.0060)')

Output:

POINT(40.7128 -74.006)

ST_GeometryFromText

Introduction: Construct a Geometry from WKT. If SRID is not set, it defaults to 0 (unknown). Alias of ST_GeomFromWKT Format: ST_GeometryFromText (Wkt: String) ST_GeometryFromText (Wkt: String, srid: Integer) SQL Example

SELECT ST_GeometryFromText('POINT(40.7128 -74.0060)')

Output:

POINT(40.7128 -74.006)

ST_LineFromText

Introduction: Construct a Line from Wkt text Format: ST_LineFromText (Wkt: String) SQL Example

SELECT ST_LineFromText('LINESTRING(1 2,3 4)')

Output:

LINESTRING (1 2, 3 4)

ST_LineFromWKB

Introduction: Construct a LineString geometry from WKB string or Binary and an optional SRID. This function also supports EWKB format.

Returns null if geometry is not of type LineString.

Format: ST_LineFromWKB (Wkb: String) ST_LineFromWKB (Wkb: Binary) ST_LineFromWKB (Wkb: String, srid: Integer) ST_LineFromWKB (Wkb: Binary, srid: Integer) Example:

SELECT ST_LineFromWKB([01 02 00 00 00 02 00 00 00 00 00 00 00 84 D6 00 C0 00 00 00 00 80 B5 D6 BF 00 00 00 60 E1 EF F7 BF 00 00 00 80 07 5D E5 BF])

Output:

LINESTRING (-2.1047439575195312 -0.354827880859375, -1.49606454372406 -0.6676061153411865)

ST_LineStringFromText

Introduction: Construct a LineString from Text, delimited by Delimiter Format: ST_LineStringFromText (Text: String, Delimiter: Char) SQL Example

SELECT ST_LineStringFromText('-74.0428197,40.6867969,-74.0421975,40.6921336,-74.0508020,40.6912794', ',')

Output:

LINESTRING (-74.0428197 40.6867969, -74.0421975 40.6921336, -74.050802 40.6912794)

ST_LinestringFromWKB

Introduction: Construct a LineString geometry from WKB string or Binary and an optional SRID. This function also supports EWKB format and it is an alias of ST_LineFromWKB.

Returns null if geometry is not of type LineString.

Format: ST_LinestringFromWKB (Wkb: String) ST_LinestringFromWKB (Wkb: Binary) ST_LinestringFromWKB (Wkb: String, srid: Integer) ST_LinestringFromWKB (Wkb: Binary, srid: Integer) Example:

SELECT ST_LinestringFromWKB([01 02 00 00 00 02 00 00 00 00 00 00 00 84 D6 00 C0 00 00 00 00 80 B5 D6 BF 00 00 00 60 E1 EF F7 BF 00 00 00 80 07 5D E5 BF])

Output:

LINESTRING (-2.1047439575195312 -0.354827880859375, -1.49606454372406 -0.6676061153411865)

ST_MakeEnvelope

Introduction: Construct a Polygon from MinX, MinY, MaxX, MaxY, and an optional SRID. Format:

ST_MakeEnvelope(MinX: Double, MinY: Double, MaxX: Double, MaxY: Double)

ST_MakeEnvelope(MinX: Double, MinY: Double, MaxX: Double, MaxY: Double, srid: Integer)

SQL Example

SELECT ST_MakeEnvelope(1.234, 2.234, 3.345, 3.345, 4236)

Output:

POLYGON ((1.234 2.234, 1.234 3.345, 3.345 3.345, 3.345 2.234, 1.234 2.234))

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

SELECT ST_MLineFromText('MULTILINESTRING((1 2, 3 4), (4 5, 6 7))')

Output:

MULTILINESTRING ((1 2, 3 4), (4 5, 6 7))

ST_MPointFromText

Introduction: Constructs a MultiPoint from the WKT with the given SRID. If SRID is not provided then it defaults to 0. It returns null if the WKT is not a MULTIPOINT. Format: ST_MPointFromText (Wkt: String) ST_MPointFromText (Wkt: String, srid: Integer) SQL Example:

SELECT ST_MPointFromText('MULTIPOINT ((10 10), (20 20), (30 30))')

Output:

MULTIPOINT ((10 10), (20 20), (30 30))

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

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:

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: Double, Y: Double, Z: Double, M: Double) Example:

SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456));

Output:

POINT (1.2345 2.3456)

Example:

SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567));

Output:

POINT Z (1.2345 2.3456 3.4567)

Example:

SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567, 4));

Output:

POINT ZM (1.2345 2.3456 3.4567 4)

ST_MakePointM

Introduction: Creates a point with X, Y, and M coordinate. Use ST_MakePoint to make points with XY, XYZ, or XYZM coordinates. Format: ST_MakePointM(x: Double, y: Double, m: Double) Example:

SELECT ST_MakePointM(1, 2, 3)

Output:

Point M(1 2 3)

ST_Point

Introduction: Construct a Point from X and Y Format: ST_Point (X: Double, Y: Double) In v1.4.0 an optional Z parameter was removed to be more consistent with other spatial SQL implementations. If you are upgrading from an older version of Sedona - please use ST_PointZ to create 3D points. SQL Example

SELECT ST_Point(double(1.2345), 2.3456)

Output:

POINT (1.2345 2.3456)

ST_PointFromGeoHash

Introduction: Generates a Point geometry representing the center of the GeoHash cell defined by the input string. If precision is not specified, the full GeoHash precision is used. Providing a precision value limits the GeoHash characters used to determine the Point coordinates. Format: ST_PointFromGeoHash(geoHash: String, precision: Integer) SQL Example

SELECT ST_PointFromGeoHash('s00twy01mt', 4)

Output:

POINT (0.87890625 0.966796875)

ST_PointFromText

Introduction: Construct a Point from Text, delimited by Delimiter Format: ST_PointFromText (Text: String, Delimiter: Char) SQL Example

SELECT ST_PointFromText('40.7128,-74.0060', ',')

Output:

POINT (40.7128 -74.006)

ST_PointFromWKB

Introduction: Construct a Point geometry from WKB string or Binary and an optional SRID. This function also supports EWKB format.

Returns null if geometry is not of type Point.

Format: ST_PointFromWKB (Wkb: String) ST_PointFromWKB (Wkb: Binary) ST_PointFromWKB (Wkb: String, srid: Integer) ST_PointFromWKB (Wkb: Binary, srid: Integer) Example:

SELECT ST_PointFromWKB([01 01 00 00 00 00 00 00 00 00 00 24 40 00 00 00 00 00 00 2e 40])

Output:

POINT (10 15)

ST_PointM

Introduction: Construct a Point from X, Y and M and an optional srid. If srid is not set, it defaults to 0 (unknown). Must use ST_AsEWKT function to print the Z and M coordinates. Format: ST_PointM (X: Double, Y: Double, M: Double) ST_PointM (X: Double, Y: Double, M: Double, srid: Integer) Example:

SELECT ST_AsEWKT(ST_PointM(1.2345, 2.3456, 3.4567))

Output:

POINT ZM(1.2345 2.3456 0 3.4567)

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_PointZ (X: Double, Y: Double, Z: Double) ST_PointZ (X: Double, Y: Double, Z: Double, srid: Integer) SQL Example

SELECT ST_AsEWKT(ST_PointZ(1.2345, 2.3456, 3.4567))

Output:

POINT Z(1.2345 2.3456 3.4567)

ST_PointZM

Introduction: Construct a Point from X, Y, Z, M and an optional srid. If srid is not set, it defaults to 0 (unknown). Must use ST_AsEWKT function to print the Z and M coordinates. Format: ST_PointZM (X: Double, Y: Double, Z: Double, M: Double) ST_PointZM (X: Double, Y: Double, Z: Double, M: Double, srid: Integer) SQL Example

SELECT ST_AsEWKT(ST_PointZM(1.2345, 2.3456, 3.4567, 100))

Output:

POINT ZM(1.2345 2.3456 3.4567, 100)

ST_PolygonFromEnvelope

Introduction: Construct a Polygon from MinX, MinY, MaxX, MaxY. Format: ST_PolygonFromEnvelope (MinX: Double, MinY: Double, MaxX: Double, MaxY: Double) SQL Example

SELECT ST_PolygonFromEnvelope(double(1.234),double(2.234),double(3.345),double(3.345))

Output:

POLYGON ((1.234 2.234, 1.234 3.345, 3.345 3.345, 3.345 2.234, 1.234 2.234))

ST_PolygonFromText

Introduction: Construct a Polygon from Text, delimited by Delimiter. Path must be closed Format: ST_PolygonFromText (Text: String, Delimiter: Char) SQL Example

SELECT ST_PolygonFromText('-74.0428197,40.6867969,-74.0421975,40.6921336,-74.0508020,40.6912794,-74.0428197,40.6867969', ',')

Output:

POLYGON ((-74.0428197 40.6867969, -74.0421975 40.6921336, -74.050802 40.6912794, -74.0428197 40.6867969))

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

WherobotsAI

ST_GeomCollFromText

ST_GeomFromEWKB

ST_GeomFromEWKT

ST_GeomFromGML

ST_GeomFromGeoHash

ST_GeomFromGeoJSON

ST_GeomFromKML

ST_GeomFromText

ST_GeomFromWKB

ST_GeomFromWKT

ST_GeometryFromText

ST_LineFromText

ST_LineFromWKB

ST_LineStringFromText

ST_LinestringFromWKB

ST_MakeEnvelope

ST_MLineFromText

ST_MPointFromText

ST_MPolyFromText

ST_MakePoint

ST_MakePointM

ST_Point

ST_PointFromGeoHash

ST_PointFromText

ST_PointFromWKB

ST_PointM

ST_PointZ

ST_PointZM

ST_PolygonFromEnvelope

ST_PolygonFromText

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

WherobotsAI

​ST_GeomCollFromText

​ST_GeomFromEWKB

​ST_GeomFromEWKT

​ST_GeomFromGML

​ST_GeomFromGeoHash

​ST_GeomFromGeoJSON

​ST_GeomFromKML

​ST_GeomFromText

​ST_GeomFromWKB

​ST_GeomFromWKT

​ST_GeometryFromText

​ST_LineFromText

​ST_LineFromWKB

​ST_LineStringFromText

​ST_LinestringFromWKB

​ST_MakeEnvelope

​ST_MLineFromText

​ST_MPointFromText

​ST_MPolyFromText

​ST_MakePoint

​ST_MakePointM

​ST_Point

​ST_PointFromGeoHash

​ST_PointFromText

​ST_PointFromWKB

​ST_PointM

​ST_PointZ

​ST_PointZM

​ST_PolygonFromEnvelope

​ST_PolygonFromText

ST_GeomCollFromText

ST_GeomFromEWKB

ST_GeomFromEWKT

ST_GeomFromGML

ST_GeomFromGeoHash

ST_GeomFromGeoJSON

ST_GeomFromKML

ST_GeomFromText

ST_GeomFromWKB

ST_GeomFromWKT

ST_GeometryFromText

ST_LineFromText

ST_LineFromWKB

ST_LineStringFromText

ST_LinestringFromWKB

ST_MakeEnvelope

ST_MLineFromText

ST_MPointFromText

ST_MPolyFromText

ST_MakePoint

ST_MakePointM

ST_Point

ST_PointFromGeoHash

ST_PointFromText

ST_PointFromWKB

ST_PointM

ST_PointZ

ST_PointZM

ST_PolygonFromEnvelope

ST_PolygonFromText