Skip to content

Geospatial

Geospatial types use latitude/longitude coordinates and spatial predicates.

See Type construction and operations for coordinate validation, Haversine distance, 0.25-degree grid candidate selection, exact post-filtering, result ordering, and polygon/antimeridian limitations.

TypeConstructionPrincipal operations
geo_pointSETDISTANCE
geo_spatial_indexCREATEADD, REMOVE, RADIUS, BOX, POLYGON
bounding_boxSETCONTAINS
polygonSETCONTAINS