Description

I want a script that creates a “Category” list for a satellite object, by examining all the TLE file links available at: https://celestrak.com/NORAD/elements/

The category short name is described by the filename of the link. The category description should correspond to the LINK text.

For example, the object with the NORAD Catalog Number 25544 would have category labels:

• stations

(https://celestrak.com/NORAD/elements/stations.txt)

• visual

(https://celestrak.com/NORAD/elements/visual.txt)

Requirements

• The module must be written in Python 3.x.

• The script should initialize a SQL table containing NORAD Object Number / Category pairs for each association.

• The script should update these associations on subsequent calls.

• The association should support nested categories

For example, the category “Scientific Satellites” includes the satellites in the files

-https://celestrak.com/NORAD/elements/science.txt

-https://celestrak.com/NORAD/elements/geodetic.txt

-https://celestrak.com/NORAD/elements/engineering.txt

-https://celestrak.com/NORAD/elements/education.txt

The script should work with these URL contents in-memory, and not require file storage or file operations.

Description

I want a username generator written in python that when called, prints a unique outer-space themed username.

The python module should source username keywords using this .txt file and combine two of them to create a unique name.

This username generator is for the 'create-profile' page of our React-based web app.

Requirements

The module must be written in python.

Definition of Done

The module code should be posted to the linked Github issue.

Example Username outputs:

1. DarkPhobos
2. LightspeedHati
3. OrbitalAtlas

Description

I want a script written that adds and updates objects to two SQL tables, based on data available from Celestrak.org SATCAT and the Union of Concerned Satellite Database. The datasets are available at the following URLs:

Celestrak Satellite Catalog

• Raw SATCAT Data

• SATCAT Format Documentation

https://www.ucsusa.org/nuclear-weapons/space-weapons/satellite-database

Following population / update of the celestrak_SATCAT and ucs_SATDB tables, the script should access and parse the updates available from celestrak.com to update the errors in the ucs_SATDB data described in UCS-SD-Discrepancies.txt

The NORAD Catalog Number should be used to relate to the two datasets to each other.

Draft code to parse and insert the data into a SQL table is provided, along with SQL DUMP code for creating the populated tables.

It is assumed that this script will be called daily to update from online sources.

Requirements

The module must be written in Python >= 3.6
SQL should be compatible with MariaDB >= 10.4
The script should provide console feedback when data source changes are discovered/implemented
Hands-off, automated process - preferably working with the source file data in memory.

Definition of Done

The module code should be posted to the linked Github issue along with the source data.

Description
I want a python script written that takes a database of satellite objects from this Celestrak Catalog and scrapes a list of the web-sources for description data of objects that match that end-point’s NORAD Catalog Number or International Designator.

The script will populate, and upon subsequent calls will update a SQL database table of URLs, keyed by NORAD Catalog Number, corresponding to valid links for additional object information.

Requirements

• The module must be written in Python 3.x

• The module should allow a rate-limit of URL crawl rate, in order to limit any unintended impact on server-load

Other Info

The URL validation should target these sources in order and populate based on availability:

1. NSSDC
   Example: https://nssdc.gsfc.nasa.gov/nmc/spacecraft/display.action?id=2019-025A

2. Celestrak.com
   Example: https://celestrak.com/satcat/1968/1968-110.php#A

3. Wikipedia
   Example: https://en.wikipedia.org/wiki/Explorer_1

4. Gunters Satellite Page (ordered scraping may not be possible)
   Example: https://space.skyrocket.de/doc_sdat/westpac.htm

The intent is to build a list of “verified links” where the user can be referred to an external URL with more information about a specific catalog object.