PostGIS

wikipedia:PostGIS PostgreSQL extension to adds support for geographic objects.

• https://postgis.net/

brew install postgis
CREATE EXTENSION postgis;

SELECT postgis_extensions_upgrade();
SELECT postgis_full_version();

• GiST (Generalized Search Tree)
• BRIN (Block Range Index)
• SP-GiST (Space-Partitioned Generalized Search Tree)
• pgSTAC

See also

• postgis
• GIS, QGIS, OpenGIS, Spatial database, Spatial SQL, PostGIS PostgreSQL extension, pgSTAC
• TIFF, GeoTIFF, STAC, PostGIS