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

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

References

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