Geographical data types

This data type isn't supported at ingest. It is only supported at query time and to create Copy Data Sources or Materialized View Data Sources.

Supports data types for representing geographical objects: locations, lands, etc.

Point

Point is represented by its X and Y coordinates, stored as a Tuple(Float64, Float64).

Ring

Ring is a simple polygon without holes stored as an array of points: Array(Point).

LineString

LineString is a line stored as an array of points: Array(Point).

MultiLineString

MultiLineString is multiple lines stored as an array of LineString: Array(LineString).

Polygon

Polygon is a polygon with holes stored as an array of rings: Array(Ring). First element of outer array is the outer shape of polygon and all the following elements are holes.

MultiPolygon

MultiPolygon consists of multiple polygons and is stored as an array of polygons: Array(Polygon).

Updated