Asteroid Intercept Planner / mcranny/neo-updater

JPL close approaches, SQLite storage, Lambert transfer plans.

The desktop project ingests JPL CAD close approaches and SBDB orbital elements, writes them into SQLite, searches Earth-to-asteroid transfer windows, and rejects Lambert solutions that fail endpoint propagation checks. This web port serves a static export from that database.

Mission Viewer

Epoch + 0 d

Mission time

Object inspector

Target

Asteroids 27 SQLite asteroids table

Close approaches 31 JPL CAD rows

Transfer plans 31 Lambert universal solver

Export mode Static JSON from data/asteroids.db

Implementation notes

github.com/mcranny/neo-updater

The Qt/OpenGL desktop viewer remains the full application: mission cards, timeline scrubbing, repeat playback, speed control, mission/inner/full camera presets, object inspection, and map-style pan/orbit/zoom. This browser version ports the stored mission data, search, comparison, time scrub, rotation, zoom, and transfer-path display. It does not run SPICE/Skyfield or SQLite in the browser.

Database source	`app/schema.sql -> data/asteroids.db -> assets/neo-missions.json`
Ingestion	JPL CAD discovers close approaches; JPL SBDB provides osculating orbital elements; imports use idempotent SQLite upserts with foreign keys and uniqueness constraints.
Transfer planning	Universal-variable Lambert solver over configurable departure/arrival grids, with endpoint propagation checks before accepting a plan.
Browser boundary	Positions and transfer paths shown here are precomputed from the local project database. The desktop app handles live update, SQLite explorer, read-only SQL workspace, and full OpenGL object inspection.