Supported Spatial Objects

Vertica uses two spatial data types. These data types store two- and three-dimensional spatial objects in a table column:

Note: Other spatial programs may use an ellipsoid to model the earth, resulting in slightly different data.

The maximum size of a GEOMETRY or GEOGRAPHY data type is 10,000,000 bytes (10 MB). You cannot use a GEOMETRY or GEOGRAPHY type as the primary key for a table in a Vertica database.