MSFS clean-slate import + real GPS overlay #46

New Issue

2026-05-29T03:01:05Z

shawn commented

2026-05-29 03:01:05 +00:00

Summary

Reset the DB to MSFS-only data then overlaid real field GPS on top.

Steps

Exported 28 GPS records from current DB to /tmp/gps_restore.sql
Ran import_msfs.py — fresh DB from merged-assets.json (9,636 assets)
Cleared all MSFS-derived GPS (address-geocoded data, not real machine locations)
Re-imported the 28 real GPS records by machine_id match
Restarted server on port 8901

Result

9,636 assets total (MSFS data = base)
28 assets with real field GPS
Zero address-derived geocoded GPS
GPS backup saved at /tmp/gps_backup.csv and /tmp/gps_restore.sql
DB pre-import backup at assets.db.20260528_225934.pre-msfs-import

## Summary Reset the DB to MSFS-only data then overlaid real field GPS on top. ### Steps 1. Exported 28 GPS records from current DB to `/tmp/gps_restore.sql` 2. Ran `import_msfs.py` — fresh DB from `merged-assets.json` (9,636 assets) 3. Cleared all MSFS-derived GPS (address-geocoded data, not real machine locations) 4. Re-imported the 28 real GPS records by machine_id match 5. Restarted server on port 8901 ### Result - 9,636 assets total (MSFS data = base) - 28 assets with real field GPS - Zero address-derived geocoded GPS - GPS backup saved at `/tmp/gps_backup.csv` and `/tmp/gps_restore.sql` - DB pre-import backup at `assets.db.20260528_225934.pre-msfs-import`

shawn closed this issue

2026-05-29 03:01:05 +00:00

shawn referenced this issue from a commit

2026-05-29 03:01:19 +00:00

docs: update msfs-data-import.md after clean-slate reset

shawn referenced this issue

2026-05-29 03:28:03 +00:00

Import Seed (mycantaloupe.com) data — 50+ new fields + detail enrichment #47

Sign in to join this conversation.