XML and JSON interfaces to satellite database

An area to discuss the design and development of a system to maintain information on satellites and their characteristics

Moderators: pa3weg, g4dpz, admin

XML and JSON interfaces to satellite database

Postby pa3weg » Tue Nov 18, 2014 3:11 pm

Hi all,

please find below a starting point for discussing a generic format for applications to ingest satellite information.
We would envisage having a central server (or servers) to serve XML and JSON data to the world about satellites.
FUNcube technical team member
pa3weg
 
Posts: 50
Joined: Mon Oct 07, 2013 2:46 pm
Location: Voorburg, The Netherlands

Re: XML and JSON interfaces to satellite database

Postby pa3weg » Tue Nov 18, 2014 3:12 pm

g3vzv wrote:Hi all,

During last week’s AMSAT-UK 80 metre net Simon asked us whether we had considered creating an XML based file of satellite frequencies, modes, modulations, status and similar parameters.
I said that yes we had, from memory at the last Colloquium, but that the idea had not gone any further.
Obviously the benefits of having a single source of machine searchable and up to date info would be immense but personally I have no idea how to go about it!
I am certain that AMSAT-UK would be happy to “host” such a service of course.
So – how would we define the specs, organise the build etc etc? Also who would lead the project??

Ideas very welcome!

cheers
FUNcube technical team member
pa3weg
 
Posts: 50
Joined: Mon Oct 07, 2013 2:46 pm
Location: Voorburg, The Netherlands

Re: XML and JSON interfaces to satellite database

Postby pa3weg » Tue Nov 18, 2014 3:13 pm

Hi Graham,

Yes, we had a small chat about it at the colloquium.
The problem is getting a good schema set up. Dave was looking into this for AmsatDroid already, since he can also distribute KEPS.

@Dave: I suppose we could push the keps into XML and serve them with the satellite?

Getting a good schema set-up is the first thing. Serving it to the world is not the problem. I can also offer the hosting or a mirror / pool of servers.
Lets see how we get on.

We would certainly need to define:
- Sat name
- Sat object no
- State (active / non-active / debris / decayed)
- TLE?
- uplink radio frequencies
- downlink radio frequencies
- beacon frequency
- A way to specify multiple transponders / pairs
- maybe website link for more info (info field, does not need to be http site)

The main problem is to come up with a list of requirements to specify the link (transponder, packet, main downlink, modulation, coding, CW beacon...).

Please add, we can think about the structure and extensions later


Wouter PA3WEG
FUNcube technical team member
pa3weg
 
Posts: 50
Joined: Mon Oct 07, 2013 2:46 pm
Location: Voorburg, The Netherlands

Re: XML and JSON interfaces to satellite database

Postby pa3weg » Tue Nov 18, 2014 3:15 pm

g4dpz wrote:Hi,

Already have a design and database schema for such a thing.

Badgersoft.com was planning to roll it out as part of the AmsatDroid project, with a json (or xml) feed.

Happy to head it up as an AMSAT project if you want.

I'll dig out the schema at lunchtime.

- Dave
FUNcube technical team member
pa3weg
 
Posts: 50
Joined: Mon Oct 07, 2013 2:46 pm
Location: Voorburg, The Netherlands

Re: XML and JSON interfaces to satellite database

Postby pa3weg » Tue Nov 18, 2014 3:16 pm

DK3WN wrote:Hi all,

yes, it's a good idea to such one.
- mode (up/downlink)
- contact person ? (e.g. for QSL request)

It should be important to update the xml file easy (also from different moderators) to change TLE, status updates.

73 Mike

DK3WN
FUNcube technical team member
pa3weg
 
Posts: 50
Joined: Mon Oct 07, 2013 2:46 pm
Location: Voorburg, The Netherlands

Re: XML and JSON interfaces to satellite database

Postby pa3weg » Tue Nov 18, 2014 3:17 pm

g4dpz wrote:Hi,

What I had in mind was a relatively simple Bootstrap/jQuery web application that cubesat owners or the IARU team could maintain and would have
the ability to export the file as XML or consume as a json web service.

Something like a Master Data system.

-Dave
FUNcube technical team member
pa3weg
 
Posts: 50
Joined: Mon Oct 07, 2013 2:46 pm
Location: Voorburg, The Netherlands

Re: XML and JSON interfaces to satellite database

Postby pa3weg » Tue Nov 18, 2014 3:17 pm

Hi Mike,

Yes to that and AMEN. The management interface would be the most important thing. Also, I would think something like the OSCAR status page could feed into this XML, but that could be an optional extension that you may or may not choose to show (or even a secondary XML file).

I like QSL contact option.

The trouble I have with the downlink specs is that it can be quite diverse/layered
For instance we would need the following for Delfi-C3 / FUNcube / ISS

Delfi-C3
bitrate 1200
modulation BPSK
coding none
packet format ax.25

FUNcube
bitrate 1200
modulation BPSK
coding AO-40 FEC
packet format FUNcube

ISS
bitrate 1200
modulation AFSK
coding none
packet format ax.25

And may more options may be needed....
But hey, its XML!
FUNcube technical team member
pa3weg
 
Posts: 50
Joined: Mon Oct 07, 2013 2:46 pm
Location: Voorburg, The Netherlands

Re: XML and JSON interfaces to satellite database

Postby pa3weg » Tue Nov 18, 2014 3:18 pm

g4dpz wrote:Hi,

What I had in mind was a relatively simple Bootstrap/jQuery web application that cubesat owners or the IARU team could maintain and would have
the ability to export the file as XML or consume as a json web service.

Something like a Master Data system.

-Dave


Well, having multiple output formats could be benificial. so having both XML and JSON output exported from the master database.
The front-end system for editing could be developed independent from the rest, and multiple types of front-ends can exist.

Having a reporting system in place like dcarr (maybe use his DB?) can feed into the system to also output a status page. I could do the FUNcube mission status page, but showing satellites red green orange etc instead of telemetry.

Lets see what your schema looks like Dave.
FUNcube technical team member
pa3weg
 
Posts: 50
Joined: Mon Oct 07, 2013 2:46 pm
Location: Voorburg, The Netherlands

Re: XML and JSON interfaces to satellite database

Postby pa3weg » Tue Nov 18, 2014 3:19 pm

dk3wn wrote:Hi,

it would be also good to have a sorted list (e.g. by frequency makes much sense) or an filter mechanism.

73 Mike
FUNcube technical team member
pa3weg
 
Posts: 50
Joined: Mon Oct 07, 2013 2:46 pm
Location: Voorburg, The Netherlands

Re: XML and JSON interfaces to satellite database

Postby pa3weg » Tue Nov 18, 2014 3:19 pm

dk3wn wrote:Hi Dave,

you can feed your database with the the content from http://www.dk3wn.info/p/?page_id=29535
Should be up-to-date ;-)

73 Mike
FUNcube technical team member
pa3weg
 
Posts: 50
Joined: Mon Oct 07, 2013 2:46 pm
Location: Voorburg, The Netherlands

Next

Return to General discussion

Who is online

Users browsing this forum: No registered users and 0 guests

cron