Comment on page
parsers
CORE
This module contains functions that create different geometry types from an external format like WKT.
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(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(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(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(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(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(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(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(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(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(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(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(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(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(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]...
Last modified 8mo ago