Telemetry database not loading

[MasterJ]

Hello everyone,

I have read here in the forum telemetry frames that are successfully decoded are now also uploaded into the database. Is this right? I can’t find the forum thread any longer.

However when I try to access the website https://db.satnogs.org/api/telemetry It takes forever to load. What am I doing wrong?

[kerel]

Hi @MasterJ!

This url points to the API endpoint of the satnogs-db which is probably not what you want.

If you want to see the decoded telemetry data, have a look at https://dashboard.satnogs.org
If you want to download frames from db: log-in to the db, then there will be a download option available on the satellite page (if there are frames available for this satellite).

This may be the thread you referred to:

Announcing SatNOGS Dashboard

This has been a long time coming, and we are happy to share the latest in the SatNOGS suite: the SatNOGS Dashboard and Data Warehouse, at dashboard.satnogs.org [28] This is a time-series database where decoded telemetry and data from captured data frames can be stored and analyzed. In this setup we are using influxdb as the database to hold telemetry, and grafana for the visualization layer. To put this into perspective with the whole ecosystem of data collection in mind, see the bottom gree…

[MasterJ]

Hi @kerel, thanks. Right that was the announcement I was thinking of.

So it is not possible to get .json data of telemetry frames in the database?
I am working on a little python project and was looking for something like an api request to get the latest frame within my application. It already works for observations (db.satnogs.org/api/observations) I know that there is the possibility to download the frames as a .CSV file but that is not really helping me in this case.

[fredy]

Unfortunately for now the only way to download frames from db is the csv file, telemetry API in db is used only for pushing data frames in db.

However there are plans for creating and improving the api of db after moving forward with some more important issues and changes like artifacts and decoders/dashboards.

[KD9KCK]

fredy I can get frames out of the DB using the api. Is that not intended?

[cshields]

the API will in fact produce frames, yes, but only for satellites we have few frames for at the moment (hence the issue that @MasterJ ran into with the page load)

[fredy]

@KD9KCK

fredy I can get frames out of the DB using the api. Is that not intended?

oops…my bad! You are right, indeed you can get frames from this api…
This is what happens when you look code at 3am after a long day

[MasterJ]

Hm. So is it possible to get specific frames using the API?
When I look at the stats page I see that my station has already delivered n frames.
I doubt that someone downloads the .csv table every day and counts the frames to update the stats

[fredy]

@MasterJ

I doubt that someone downloads the .csv table every day and counts the frames to update the stats

Neither api nor csv are used for the stats counters. Queries in db are used instead and they are cashed, this is why show up so fast.

[kerel]

Ok, for fetching frames automatically this API endpoint would be the right choice (in principle). Unfortunately it doesn’t provide advanced filters yet and it’s broken for satellites with too much frames (known issue as @cshields mentioned. nevertheless I created issue satnogs-db#266 to track this).

@MasterJ

So is it possible to get specific frames using the API?

It’s possible to filter for a certain satellite (the only filter available for now):
e.g. https://db-dev.satnogs.org/api/telemetry/?norad_cat_id=25544

@MasterJ In what frames are you interested/what filters would you need?