Spatial functions are a set of functions provided in the OceanBase AI Database system for specifically processing geospatial data. These functions enable users to perform complex spatial queries and analyses at the database level, allowing Geographic Information Systems (GIS) and other applications that rely on spatial data to store, query, and manipulate spatial data efficiently.
The following table describes the types of spatial functions supported by OceanBase AI Database and their uses:
Spatial function types
Spatial Function Types |
Description |
|---|---|
| Create a geometric value function | Generates instances of geometric data types, such as points, lines, and polygons. |
| Spatial operators | Provides functions for basic operations on geometric objects, such as addition, subtraction, and multiplication. |
| Spatial relationship functions | Functions that determine the spatial relationship between two geometric objects, such as intersection, containment, and adjacency. |
| Geometric property functions | Functions for obtaining attributes of geometric objects, such as area, length, and boundary. |
| Geometric format conversion functions | Functions for converting between geometric data formats, such as converting from WKB to WKT. |
| Spatial analysis functions | Functions for performing complex spatial processing and analysis, such as buffer analysis, merging, and clipping. |
| Spatial Constructors | Functions for creating new spatial data types and geometric shapes. |
| Spatial accessor functions | Provides functions for accessing components of spatial data, such as the vertices of a polygon or the start point of a line. |
| Spatial format conversion functions | It is used to convert between different spatial data representation formats, such as converting geometric objects to text or binary formats. |
| Geometric Processing Functions | Performs various operations and transformations on spatial geometric objects, including shape modification, geometric relationship calculation, spatial query, and other types of spatial analysis. |