What is stored
The Live Parking Monitoring slice stores lot information and timestamped occupancy history. This page reads data/demo-db.json, exported from data/damn-parking.sqlite. Every occupancy row is marked is_sample = 1 and sourced from sample_camera_feed.
Lots
-
Cameras
-
Observations
-
Latest open stalls
-
Loading sample records.
Lot information
Latest sample snapshot for each lot. Open stalls are capacity minus occupied stalls.
| Lot | Kind | Permit | Capacity | Occupied | Open | Fullness |
|---|---|---|---|---|---|---|
| Loading lots. | ||||||
Occupancy history
Half-hour sample observations from October 20 through October 24, 2026, 7:00 to 19:00 MDT. Pick a lot and a day.
| Observed | Occupied | Open | Confidence | Source |
|---|---|---|---|---|
| Loading history. | ||||
Tables
| Table | Role | Columns |
|---|---|---|
lots |
Lot information | lot_id, name, kind, address, latitude, longitude, stall_capacity, permit_type, rate_note, walk_minutes |
cameras |
Sample camera coverage per lot | camera_id, lot_id, label, covers, status |
occupancy_observations |
Timestamped occupancy history | observation_id, lot_id, observed_at, occupied_stalls, open_stalls, source, confidence, is_sample |
dataset_meta |
Dataset label and window | key, value |
latest_occupancy |
View of the newest row per lot | lot_id, name, kind, stall_capacity, observed_at, occupied_stalls, open_stalls, confidence, source |
Rebuild the file with python3 scripts/seed_demo_db.py. The home-page 3D lot is a separate visualization and does not read this database.