3-2-1 Launch
3-2-1 Launch is an augmented reality experience built around rocket launches in Florida. It is managed by the staff of Florida Today.
The app is powered by this spreadsheet, using the Storytelling Studio's Google Sheets publishing pipeline.
The main sheet is launches. Other sheets -- locations, trajectories -- store common data used for validation. (Any sheet not mentioned in this documentation can be ignored.)
There are a lot of fields (16 at present). Where possible, the spreadsheet uses data validation to provide choices and limit human error.
| field | description | required |
|---|---|---|
id |
Unique ID. Anything unique will work here. | yes |
mission_name |
Example: "24th Starlink: SpaceX Falcon 9 launch from Cape Canaveral" | yes |
article_link |
Link to an article if we have one. | no |
location |
Launch location. The spreadsheet provides a choice of four locations. | yes |
launch_time_utc |
Must be formatted as UTC. Example:2021-04-07T16:34:30Z. |
yes |
mission_description |
Describe the mission. | yes |
scribble_event_id |
Scribble Live event ID. | no |
payload |
One of four available payloads. | yes |
video_link |
Link to launch video | no |
createdAt |
Date/time created, as UTC. | no |
updatedAt |
Date/time updated, as UTC. | yes |
fairing_length |
Choices: short, medium, or long |
no |
maneuver |
Choices: landing, expendable, boostback |
no |
stream_status |
Choices: active, inactive, no_ar |
no |
num_boosters |
Number of boosters | no |
trajectory |
Flight trajectory, used for AR | yes |
Publishing
We use spreadsheet publishing, which will update a data file used by the app. Make sure to follow the steps required to avoid being locked out.
