Comment on page
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
1
WITH t AS (
2
  SELECT carto.ST_ASGEOHASH(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)'), 8) AS geohash
3
)
4
SELECT carto.ST_ASTEXT(carto.ST_BOX2DFROMGEOHASH(geohash, 5)) FROM t;
5
-- 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
1
WITH t AS (
2
  SELECT carto.ST_ASGEOHASH(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)'), 8) AS geohash
3
)
4
SELECT carto.ST_ASTEXT(carto.ST_GEOMFROMGEOHASH(geohash, 8)) FROM t;
5
-- 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
1
SELECT carto.ST_ASTEXT(
2
  carto.ST_GEOMFROMGEOJSON('{"type":"Point","coordinates":[-76.0913,18.4275,0.0]}')
3
);
4
-- POINT (-76.0913 18.4275)
ST_GEOMFROMTEXT
ST_GEOMFROMTEXT(wkt)
Description
Alias of st_geomFromWKT.
wkt: String WKT text.
Return type
Geometry
Example
1
SELECT carto.ST_ASGEOJSON(carto.ST_GEOMFROMTEXT('POINT(-76.09130 18.42750)'));
2
-- {"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
1
WITH t AS (
2
  SELECT carto.ST_ASTWKB(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)')) AS twkb
3
)
4
SELECT carto.ST_GEOMFROMTWKB(twkb) FROM t;
5
-- 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
1
WITH t AS (
2
  SELECT carto.ST_ASBINARY(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)')) AS wkb
3
)
4
SELECT carto.ST_GEOMFROMWKB(wkb) FROM t;
5
-- 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
1
SELECT carto.ST_ASGEOJSON(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)'));
2
-- {"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
1
SELECT carto.ST_ASGEOJSON(carto.ST_LINEFROMTEXT('LINESTRING(0 0, 0 3, 5 3)'));
2
-- {"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
1
SELECT carto.ST_ASGEOJSON(carto.ST_MLINEFROMTEXT('MULTILINESTRING((1 1, 3 5), (-5 3, -8 -2))'));
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
1
SELECT carto.ST_ASGEOJSON(carto.ST_MPOINTFROMTEXT('MULTIPOINT (10 40, 40 30, 20 20, 30 10)'));
2
-- {"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
1
SELECT carto.ST_ASGEOJSON(
2
  carto.ST_MPOLYFROMTEXT(
3
    'MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)),((15 5, 40 10, 10 20, 5 10, 15 5)))'
4
  )
5
);
6
-- {"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
1
WITH t AS (
2
  SELECT carto.ST_ASGEOHASH(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)'), 8) AS geohash
3
)
4
SELECT carto.ST_ASTEXT(carto.ST_POINTFROMGEOHASH(geohash, 5)) FROM t;
5
-- 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
1
SELECT carto.ST_ASGEOJSON(carto.ST_POINTFROMTEXT('POINT(-76.09130 18.42750)'));
2
-- {"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
1
WITH t AS (
2
  SELECT carto.ST_ASBINARY(carto.ST_GEOMFROMWKT('POINT(-76.09130 18.42750)')) AS wkb
3
)
4
SELECT carto.ST_POINTFROMWKB(wkb) FROM t;
5
-- 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
1
SELECT carto.ST_ASGEOJSON(
2
  carto.ST_POLYGONFROMTEXT(
3
    'POLYGON((-73.98955 40.71278, -73.98958 40.71299, -73.98955 40.71278))'
4
  )
5
);
6
-- {"type":"Polygon","coordinates":[[[-73.98955,40.71278,0.0],[-73.98958,40.71299,0.0],[-73.98955,40.71278,0.0]...
measurements
predicates
Last modified 8mo ago