PostGIS Spatial

Geographic query patterns for place and region filtering.

Announce: "I'm using postgis-spatial to implement geographic queries correctly."

Geometry Storage

Places store their geometry as PostGIS geometry:

CREATE TABLE places (
  id uuid PRIMARY KEY,
  name text NOT NULL,
  geom geometry(Geometry, 4326),  -- Can be Point, Polygon, or MultiPolygon
  -- SRID 4326 = WGS84 (standard lat/lng)
);