Development resources at your finger tips
Build with the coolest Web3 projects
Recurring funding for Open Source
Ethical ads to power Open Source
Learn about Web3 & earn rewards
Show appreciation for each other
Meet fellow developers, designers, futurists and more. Collaborate and BUIDL awesome projects together.
Discover great web3 organizations, work on meaningful projects and build relationships with like minded people. Browse Tribes
Meet the top hunters and contributors from our community.
Aloha, Gitcoiners! How do you feel about Data Dignity, Quadratic Voting, Quadratic Finance and Decentralized Identity?
KERNEL is an 8-week, invite-only program for top tech talent looking to build relationships, products, and companies in blockchain and Web 3. 100 tal…
Type in [[ 2- term.length]] more characters to get results
[[ result.title ]]
[[ result.description | truncate(70) ]]
No matches found
Gitcoin is GDPR complaint. Learn more in
Gitcoin's Terms & Conditions.
Check out the Issue Explorer
Looking to fund some work? You can submit a new Funded Issue here.
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](https://www.celestrak.com/pub/satcat.txt)
- [SATCAT Format Documentation](https://www.celestrak.com/satcat/satcat-format.php)
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](https://github.com/mainnebula/SPACE_TASKS/blob/master/parse_satcat_UCS_for_bounty.py) to parse and insert the data into a SQL table is provided, along with [SQL DUMP](https://github.com/mainnebula/SPACE_TASKS) code for creating the populated tables.
It is assumed that this script will be called daily to update from online sources.
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.