SingleStore Managed Service

Geospatial Types

Geospatial types contain information about points, paths, and polygons on the surface of the Earth. For more information, see Working with Geospatial Features.

Data Type

Size

Size (Not Null)

GEOGRAPHYPOINT

8 bytes

8 bytes

GEOGRAPHY

See note

Important

The space consumed by the path and polygon data in Geography columns is dependent on the complexity of the objects. Very roughly, a Geography value consumes 24 bytes per vertex, plus a 64 byte overhead, plus some minor overhead for each “ring” in a multipolygon.

Indexing a Geography object may also consume more space than indexes over other datatypes. The rule of thumb is 40 bytes * the value of the RESOLUTION parameter of the index, per row.