SQL Reference
Geospatial Functions

Linestring Constructors

 LINESTRING constructors use geospatial data to create a LINESTRING object.

ST_LINEFROMTEXT

Alias for ST_LINESTRING(CHAR).

Creates a LINESTRING from a specified CHAR. The CHAR must be a LINESTRING value in WKT format.

Syntax

SQL


Argument

Data Type

Description

char

CHAR

A character value in WKT format to be used to create a LINESTRING.

Example

SQL


Output: LINESTRING(1.000000 2.000000)

ST_LINEFROMWKB

Alias for ST_LINESTRING(BINARY).

Creates a LINESTRING from the specified BINARY. The BINARY value must be a LINESTRING in WKB format.

Syntax

SQL


Argument

Data Type

Description

binary

BINARY

A binary value in WKB format to be used to create a LINESTRING.

Example

SQL


Output: LINESTRING(1 2,3 4)

ST_LINEFROMEWKT

Creates a LINESTRING from the specified CHAR.

The CHAR value must be a LINESTRING in EWKT format.

ST_LINEFROMEWKT is functionally the same as ST_LINESTRING(CHAR).

The input string must include an SRID=…​; value. However, the database ignores this component as all geography types are SRID 4326.

Syntax

SQL


Argument

Data Type

Description

char

CHAR

A LINESTRING value in WKT format to be used to create a LINESTRING.



To function properly, you must prefix this argument with an SRID value in the same string.

value

INTEGER

Any integer value. This is required, however the database ignores this component and defaults to SRID 4326.

Example

SQL


OutputLINESTRING(1.000000 2.000000)

ST_LINEFROMGEOJSON

Creates a LINESTRING represented by the specified GeoJSON. The specified GeoJSON can represent a GeoJSON POINT or LINESTRING type.

Valid GeoJSON formats follow IETF standards, and you can generate them by using ST_ASGEOJSON. If you specify an invalid GeoJSON, the behavior of the function is undefined.

Syntax

SQL


Argument

Data Type

Description

geojson

CHAR

A GeoJSON value that represents a POINT or LINESTRING type that is used to create a LINESTRING.



If geojson is NULL, the function returns NULL.

geodesic

BOOLEAN

Optional. A BOOLEAN value that determines if the specified geojson should be converted from a planar to a geodesic representation.

If you specify geodesic as TRUE, the function adds points to the resulting LINESTRING such that it remains within 10 meters of the original planar line.

If unspecified, geodesic defaults to FALSE.

If geodesic is NULL, the function returns NULL.

Examples

In this example, the function converts an empty GeoJSON value of a LINESTRING.

SQL


Output: LINESTRING EMPTY

In this example, the function converts a GeoJSON value of a LINESTRING.

SQL


Output: LINESTRING(1 1, 1 5, 5 5, 5 1)

ST_LINESTRING

Alias for ST_MAKELINE.

Creates a LINESTRING based on the specified inputs.

ST_LINESTRING(geoArray)

Creates a LINESTRING from the specified array of either LINESTRING or POINT values.

Syntax

SQL


Argument

Data Type

Description

geo_array

ARRAY of geographies, either LINESTRING or POINT values.

An array of LINESTRING or POINT values to be used to create a unified LINESTRING.

Example

SQL


Output: LINESTRING(1.000000 2.000000, 3.000000 4.000000)

ST_LINESTRING(binary)

Creates a LINESTRING from the specified BINARY. The BINARY value must be a LINESTRING in WKB format.

Syntax

SQL


Argument

Data Type

Description

binary

BINARY

A BINARY value to be used to create a LINESTRING. The BINARY value must be a LINESTRING in WKB format.

Example

SQL


OutputLINESTRING(1 2,3 4)

ST_LINESTRING(char)

Creates a LINESTRING from the specified CHAR. The CHAR value must be a LINESTRING in WKT format.

Syntax

SQL


Argument

Data Type

Description

char

CHAR

A CHAR value to be used to create a LINESTRING. The argument must be a LINESTRING in WKT format.

Example

SQL


OutputLINESTRING(1.000000 2.000000)

ST_LINESTRING(geo1, geo2)

Creates a LINESTRING consisting of two separate geographic arguments, both of which must be either a POINT or LINESTRING. You can mix geographic types, meaning one argument can be a POINT while the other is a LINESTRING.

Syntax

SQL


Argument

Data Type

Description

geo1, geo2

POINT or LINESTRING

Two separate geographic arguments to be consolidated into a single LINESTRING.



Inputs can be the same type or one of each.

Example

SQL


OutputLINESTRING(1.000000 2.000000, 1.000000 3.000000)

ST_MAKELINE

Alias for ST_LINESTRING.

ST_MAKELINE(geo1, geo2)

ST_MAKELINE(CHAR)

Alias for ST_LINESTRING(char).

ST_MAKELINE(geoArray)

Related Links