Overview of spatial data types

OceanBase Database supports the following spatial data types in its geographic information system (GIS) feature:

• GEOMETRY

• POINT

• LINESTRING

• POLYGON

• MULTIPOINT

• MULTILINESTRING

• MULTIPOLYGON

• GEOMETRYCOLLECTION

The POINT, LINESTRING, and POLYGON data types are the most basic spatial data types. They are used to store single spatial data. The MULTIPOINT, MULTILINESTRING, and MULTIPOLYGON data types are used to store collections of spatial data. However, they can only represent collections of their respective base types. The GEOMETRY data type is a virtual type that can represent any base type. The GEOMETRYCOLLECTION data type is a collection of any GEOMETRY type.

References

• Spatial reference systems
• Create spatial columns
• Create spatial indexes