Geography fields

Geography types are used for storing geospatial data on the surface of the Earth. They are stored as PostGIS geography columns in PostgreSQL using the WGS 84 coordinate system (SRID 4326), which is the standard used by GPS.

All geography types support spatial filter operations such as proximity search, intersection, containment, and distance-based ordering. See the Geography operators section for details.

To ensure optimal performance with spatial queries, consider creating a GIST index on your geography fields. See the Geography indexes section for more details.

info

The usage of Geography fields requires the PostGIS PostgreSQL extension to be installed. To set up PostGIS in a new or existing project, see the Upgrading to PostGIS support guide.

GeographyPoint

The GeographyPoint type stores a single geographic location defined by longitude and latitude.

class: Store
table: store
fields:
  name: String
  location: GeographyPoint
  address: String?

GeographyLineString

The GeographyLineString type stores an ordered sequence of points forming a path or route.

class: DeliveryRoute
table: delivery_route
fields:
  name: String
  path: GeographyLineString
  description: String?

GeographyPolygon

The GeographyPolygon type stores a closed region defined by an exterior ring and optional interior holes.

class: DeliveryZone
table: delivery_zone
fields:
  name: String
  boundary: GeographyPolygon
  description: String?

GeographyGeometryCollection

The GeographyGeometryCollection type stores a collection of mixed geography types (points, lines, and polygons) as a single field.

class: Region
table: region
fields:
  name: String
  features: GeographyGeometryCollection