All Products
Search
Document Center

PolarDB:Overview

Last Updated:Oct 17, 2024

This topic describes the data types used in the GanosBase GeomGrid extension.

GeomGrid

GeomGrid is the data type that is used to represent geographic grids in the GanosBase GeomGrid extension. A geographic grid is a set of polygonal grid cells that reproduce the surface of the earth. It can be used to represent the location information of ground features in geographic space and integrate other types of spatio-temporal data. Each grid cell is encoded to provide one-to-one mappings. In addition to latitudes and longitudes of 3D geographic grids, heights are also considered for the gridding and encoding of 3D geographic grids.

image.png

  • The following data types can be converted into the GeomGrid data type:

    • text

    • bytea

    • geometry

    • meshgeom

    • sfmesh

    • vomesh

  • The GeomGrid data type can be converted into the following data types:

    • text

    • bytea

    • geometry

    • box/box3d

    • meshgeom

    • vomesh

H3Grid

H3Grid is a hexagonal hierarchical geospatial indexing system that is designed based on Uber H3 indexing in the GanosBase GeomGrid extension.

  • You can convert the following data types into the H3Grid data type:

    • text

    • bytea

    • integer

    • Latitude and longitude

  • You can convert the H3Grid data type to the following data types:

    • text

    • bytea

    • geometry