parsers

CORE

This module contains functions that create different geometry types from an external format like WKT.

ST_BOX2DFROMGEOHASH

ST_BOX2DFROMGEOHASH(geomHash, prec)

Description

Alias of st_geomFromGeoHash.

• geomHash: String Geohash code.

• prec: Geometry precison.

Return type

Geometry

Example

WITH t AS (
  SELECT carto.ST_ASGEOHASH(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)'), 8) AS geohash
)
SELECT carto.ST_ASTEXT(carto.ST_BOX2DFROMGEOHASH(geohash, 5)) FROM t;
-- POLYGON ((-90 11.25, -90 22.5, -67.5 22.5, -67.5 11.25, -90 11.25))

ST_GEOMFROMGEOHASH

ST_GEOMFROMGEOHASH(geomHash, prec)

Description

Returns the Geometry of the bounding box corresponding to the Geohash string geohash (base-32 encoded) with a precision of prec bits. See Geohash for more information on GeoHashes.

• geomHash: String Geohash code.

• prec: Geometry precison.

Return type

Geometry

Example

WITH t AS (
  SELECT carto.ST_ASGEOHASH(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)'), 8) AS geohash
)
SELECT carto.ST_ASTEXT(carto.ST_GEOMFROMGEOHASH(geohash, 8)) FROM t;
-- POLYGON ((-90 11.25, -90 22.5, -67.5 22.5, -67.5 11.25, -90 11.25))

ST_GEOMFROMGEOJSON

ST_GEOMFROMGEOJSON(geojson)

Description

Creates a Geometry from the given GeoJSON.

• geojson: String geojson text.

Return type

Geometry

Example

SELECT carto.ST_ASTEXT(
  carto.ST_GEOMFROMGEOJSON('{"type":"Point","coordinates":[-76.0913,18.4275,0.0]}')
);
-- POINT (-76.0913 18.4275)

ST_GEOMFROMTEXT

ST_GEOMFROMTEXT(wkt)

Description

Alias of st_geomFromWKT.

• wkt: String WKT text.

Return type

Geometry

Example

SELECT carto.ST_ASGEOJSON(carto.ST_GEOMFROMTEXT('POINT(-76.09130 18.42750)'));
-- {"type":"Point","coordinates":[-76.0913,18.4275,0.0]}

ST_GEOMFROMTWKB

ST_GEOMFROMTWKB(wkb)

Description

Creates a Geometry from the given Well-Known Binary representation (TWKB).

• wkb: Array[Byte] geom in TWKB format.

Return type

Geometry

Example

WITH t AS (
  SELECT carto.ST_ASTWKB(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)')) AS twkb
)
SELECT carto.ST_GEOMFROMTWKB(twkb) FROM t;
-- 4QgBz/HU1QXwwN6vAQA=

ST_GEOMFROMWKB

ST_GEOMFROMWKB(wkb)

Description

Creates a Geometry from the given Well-Known Binary representation (WKB).

• wkb: Array[Byte] geom in WKB format.

Return type

Geometry

Example

WITH t AS (
  SELECT carto.ST_ASBINARY(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)')) AS wkb
)
SELECT carto.ST_GEOMFROMWKB(wkb) FROM t;
-- 4QgBz/HU1QXwwN6vAQA=

ST_GEOMFROMWKT

ST_GEOMFROMWKT(wkt)

Description

Creates a Geometry from the given Well-Known Text representation (WKT).

• wkt: String WKT text.

Return type

Geometry

Example

SELECT carto.ST_ASGEOJSON(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)'));
-- {"type":"Point","coordinates":[-76.0913,18.4275,0.0]}

ST_LINEFROMTEXT

ST_LINEFROMTEXT(wkt)

Description

Creates a LineString from the given WKT representation.

• wkt: String geom in WKT format.

Return type

LineString

Example

SELECT carto.ST_ASGEOJSON(carto.ST_LINEFROMTEXT('LINESTRING(0 0, 0 3, 5 3)'));
-- {"type":"LineString","coordinates":[[0.0,0.0,0.0],[0.0,3,0.0],[5,3,0.0]]}

ST_MLINEFROMTEXT

ST_MLINEFROMTEXT(wkt)

Description

Creates a MultiLineString corresponding to the given WKT representation.

• wkt: String geom in WKT format.

Return type

MultiLineString

Example

SELECT carto.ST_ASGEOJSON(carto.ST_MLINEFROMTEXT('MULTILINESTRING((1 1, 3 5), (-5 3, -8 -2))'));
-- {"type":"MultiLineString","coordinates":[[[1,1,0.0],[3,5,0.0]],[[-5,3,0.0],[-8,-2,0.0]]]}

ST_MPOINTFROMTEXT

ST_MPOINTFROMTEXT(wkt)

Description

Creates a MultiPoint corresponding to the given WKT representation.

• wkt: String geom in WKT format.

Return type

MultiPoint

Example

SELECT carto.ST_ASGEOJSON(carto.ST_MPOINTFROMTEXT('MULTIPOINT (10 40, 40 30, 20 20, 30 10)'));
-- {"type":"MultiPoint","coordinates":[[10,40,0.0],[40,30,0.0],[20,20,0.0],[30,10,0.0]]}

ST_MPOLYFROMTEXT

ST_MPOLYFROMTEXT(wkt)

Description

Creates a MultiPolygon corresponding to the given WKT representation.

• wkt: String geom in WKT format.

Return type

MultiPolygon

Example

SELECT carto.ST_ASGEOJSON(
  carto.ST_MPOLYFROMTEXT(
    'MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)),((15 5, 40 10, 10 20, 5 10, 15 5)))'
  )
);
-- {"type":"MultiPolygon","coordinates":[[[[30,20,0.0],[45,40,0.0],[10,40,0.0],[30,20,0.0]]]...

ST_POINTFROMGEOHASH

ST_POINTFROMGEOHASH(geohash, prec)

Description

Return the Point at the geometric center of the bounding box defined by the Geohash string geohash (base-32 encoded) with a precision of prec bits. See Geohash for more information on Geohashes.

• geomHash: String Geohash code.

• prec: Geometry precison.

Return type

Point

Example

WITH t AS (
  SELECT carto.ST_ASGEOHASH(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)'), 8) AS geohash
)
SELECT carto.ST_ASTEXT(carto.ST_POINTFROMGEOHASH(geohash, 5)) FROM t;
-- POINT (-67.5 22.5)

ST_POINTFROMTEXT

ST_POINTFROMTEXT(wkt)

Description

Creates a Point corresponding to the given WKT representation.

• wkt: String geom in WKT format.

Return type

Point

Example

SELECT carto.ST_ASGEOJSON(carto.ST_POINTFROMTEXT('POINT(-76.09130 18.42750)'));
-- {"type":"Point","coordinates":[-76.0913,18.4275,0.0]}

ST_POINTFROMWKB

ST_POINTFROMWKB(wkb)

Description

Creates a Point corresponding to the given WKB representation.

• wkb: Array[Byte] geom in WKB format.

Return type

Point

Example

WITH t AS (
  SELECT carto.ST_ASBINARY(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)')) AS wkb
)
SELECT carto.ST_POINTFROMWKB(wkb) FROM t;
-- 4QgBz/HU1QXwwN6vAQA=

ST_POLYGONFROMTEXT

ST_POLYGONFROMTEXT(wkt)

Description

Creates a Polygon corresponding to the given WKT representation.

• wkt: String geom in WKT format.

Return type

Polygon

Example

SELECT carto.ST_ASGEOJSON(
  carto.ST_POLYGONFROMTEXT(
    'POLYGON((-73.98955 40.71278, -73.98958 40.71299, -73.98955 40.71278))'
  )
);
-- {"type":"Polygon","coordinates":[[[-73.98955,40.71278,0.0],[-73.98958,40.71299,0.0],[-73.98955,40.71278,0.0]...