Polygon Constructors
POLYGON constructors use geospatial data to create a POLYGON object.
Creates a standardized polygon from an existing one. defines standardized as the exterior being counterclockwise (CCW) and all holes being clockwise (CW) oriented.
Syntax
Parameter | Data Type | Description |
---|---|---|
polygon | POLYGON | A POLYGON to be converted on its exterior counterclockwise, and clockwise for any interior holes. |
Example
Output: POLYGON((0 0,1 0,1 1,0 1,0 0))
Alias for ST_POLYGON.
Creates a POLYGON.
Creates a POLYGON from the specified POINT, POINT array, LINESTRING, or POLYGON geography.
Syntax
Parameter | Data Type | Description |
---|---|---|
geo | POLYGON | A POINT, POINT array, LINESTRING, or POLYGON value to be converted to a POLYGON object. |
Example
Output: POLYGON((1 2,1 3,1 4,1 2))
Alias for ST_MAKEPOLYGON(char).
Creates a POLYGON from the specified CHAR that represents a POLYGON in WKT format.
Syntax
Parameter | Data Type | Description |
---|---|---|
char | CHAR that represents a POLYGON in WKT format. | The CHAR argument must represent a POLYGON in WKT format. |
Example
Output: POLYGON((1 2,1 3,1 4,1 2))
Alias for ST_POLYGONFROMWKB(binary).
Creates a POLYGON from the specified BINARY. The BINARY value must represent a POLYGON in WKB format.
Syntax
Parameter | Data Type | Description |
---|---|---|
binary | BINARY that represents a POLYGON in WKB format. | A BINARY argument to be converted to a POLYGON. The BINARY value must represent a POLYGON in WKB format. |
Example
Output: POLYGON((0 0,0 1,1 1,1 0,0 0))
Alias for ST_MAKEPOLYGON(outerRing, innerRings).
Creates a POLYGON from the specified outer ring (that must be either a POINT, POINT array, or LINESTRING) and the array of interior rings (closed lines).
The interior of the POLYGON is on the left when traveling around the exterior ring. The interior of a hole is on the right when traveling around a hole.
Syntax
Parameter | Data Type | Description |
---|---|---|
outer_ring | POINT, POINT array, or LINESTRING | A POINT, POINT array, or LINESTRING that represents the outer ring of the POLYGON object. |
inner_rings | ARRAY of POINT arrays, or ARRAY of LINESTRING values | An ARRAY of POINT arrays or LINESTRING values that represents the inner rings or holes in the POLYGON object. |
Example
Output: POLYGON((1.000000 2.000000), (1.000000 2.000000))
Alias for ST_POLYGON(binary).
Alias for the ST_POLYGON constructor.
Creates a POLYGON using an EWKT-formatted CHAR as an input argument.
Syntax
Parameter | Data Type | Description |
---|---|---|
char | CHAR | A string that includes an SRID value and an EWKT-formatted value that represents a POLYGON. Separate the values in the string by a semicolon in this format: 'SRID = value; polygon_value' The input string must include the SRID = value; component. However, the database ignores this component as all Ocient geography types are SRID = 4326. |
Example
Output: POLYGON((1 2,1 3,1 4,1 2))
Creates a POLYGON represented by the specified GeoJSON value as an input argument.
Syntax
Parameter | Data Type | Description |
---|---|---|
geo_json | STRING | A string of a GeoJSON. Valid GeoJSON formats follow IETF standards, which you can generate by using the ST_ASGEOJSON function. If you specify an invalid GeoJSON, the behavior of the function is undefined. The function returns NULL if any argument is a NULL value. |
geodesic | BOOLEAN | Optional. If you specify geodesic as TRUE, the function adds points to the resulting POLYGON such that it remains within 10 meters of the original planar polygon. If you do not specify this argument, the value defaults to FALSE. |
Examples
In this example, the function produces an empty POLYGON value from the GeoJSON representation.
Output: POLYGON EMPTY
In this example, the function produces a POLYGON value from the GeoJSON representation.
Output: POLYGON((1 1, 1 5, 5 5, 5 1))
Alias for ST_POLYGON(char).
Returns the database internal representation of the whole earth polygon. The ST_ENVELOPE function returns this POLYGON value, with the envelope set as the entire earth.
GIS specifications do not describe a canonical polygon for the whole earth, but this value serves as the Ocient-canonical polygon. The whole earth polygon is also equivalent to ST_POLYGON('POLYGON((0 0,0 0,0 0,0 0'))), which can have a separate meaning in other GIS implementations.
Syntax
Example
Output: POLYGON((0.0 0.0, 0.0 0.0, 0.0 0.0, 0.0 0.0))