svc-location-services¶
NovaTrek Location Services API | Support | v1.2.0 | NovaTrek Platform Engineering
Manages physical locations across the NovaTrek network including base camps,
Swagger UI Download OpenAPI Spec
Integration Context¶
Data Store¶
Overview¶
| Property | Detail |
|---|---|
| Engine | PostGIS (PostgreSQL 15) |
| Schema | locations |
| Tables | locations, capacity_records, operating_hours |
| Estimated Volume | ~100 updates/day, ~2K reads/day |
| Connection Pool | min 3 / max 10 / idle timeout 10min |
| Backup Strategy | Daily pg_dump, 14-day retention |
Key Features¶
- PostGIS geometry for geofencing and proximity queries
- Real-time capacity tracking with threshold alerts
- Timezone-aware operating hours management
Table Reference¶
locations¶
Adventure locations and facilities with geospatial boundaries
| Column | Type | Constraints |
|---|---|---|
location_id | UUID | PK |
name | VARCHAR(200) | NOT NULL |
location_type | VARCHAR(30) | NOT NULL |
boundary | GEOMETRY(Polygon, 4326) | NOT NULL |
center_point | GEOMETRY(Point, 4326) | NOT NULL |
max_capacity | INTEGER | NOT NULL |
timezone | VARCHAR(50) | NOT NULL |
active | BOOLEAN | NOT NULL, DEFAULT TRUE |
Indexes:
idx_loc_boundaryonboundary(GiST spatial)idx_loc_centeroncenter_point(GiST spatial)idx_loc_typeonlocation_type
capacity_records¶
Real-time occupancy tracking for locations
| Column | Type | Constraints |
|---|---|---|
record_id | UUID | PK |
location_id | UUID | NOT NULL, FK -> locations |
current_count | INTEGER | NOT NULL |
recorded_at | TIMESTAMPTZ | NOT NULL |
Indexes:
idx_cap_loc_timeonlocation_id, recorded_at DESC
Endpoints (6 total)¶
GET /locations -- List all locations¶
Returns a paginated list of NovaTrek locations with optional filtering by type, region, or status.
POST /locations -- Create a new location¶
GET /locations/{location_id} -- Get location details¶
PATCH /locations/{location_id} -- Update location details¶
GET /locations/{location_id}/capacity -- Get current capacity utilization¶
GET /locations/{location_id}/operating-hours -- Get operating hours for a location¶
Consuming Applications¶
| Application | Screens Using This Service |
|---|---|
| Operations Dashboard | Daily Schedule Board, Transport Dispatch |
| Adventure App | Live Trip Map |