app.geofence_shapes
View
Geofence outlines as GeoJSON for maps and on-device checks (Section 13). Visible under the same policy as app.geofences; the server still decides geofence_verified on every punch.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Geofence. |
| venue_id | uuid | Yes | Venue. |
| zone_id | uuid | Yes | Zone the geofence outlines, when it outlines one. |
| name | text | Yes | Geofence name. |
| boundary_geojson | jsonb | Yes | Boundary as a GeoJSON Polygon in WGS 84 (RFC 7946), the documented JSON exception for a geometry exchange format. |
| org_id | uuid | Yes | Organization that owns the geofence, so a device keeps only its own orgs' outlines. |