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

Re: XML and JSON interfaces to satellite database

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

g4dpz wrote:Hi,

Yes, I could parse the HTML.
I might have to ask you to add a few more tags to find the table in the mark-up.

- 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:20 pm

g3wgm wrote:Hi Folks,

You all prob are aware of the IARU databse at http://www.amsat.org.uk/iaru/. It contains some, but by now means all of the info required. If the new database is to take over the role of the IARU pages, please note the (simple) functionality

The app was written by me years ago, originally in asp/MS Access databse, and translated (again by me) into php/My SQL. The only person who updates its is Graham, G3VZV, who specified the functionality, so should have an input into the new pages.

Also dont forget that we would not wish to display command uplinks to the unwashed!

73s Jim G3WGM
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:21 pm

dk3wn wrote:Hi Jim,

I think we should not touch the ITU list.

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:22 pm

g4dpz wrote:Hi,

OK, just use IARU as a source.

Mike,
It would help to add an ID to the <table> definition in the html:

Code: Select all
<h2>Status of active Satellites on Amateur Radio Frequencies</h2>
<p>&nbsp;</p>
<table id="satellite-data" width="100%" border="1" cellspacing="0" cellpadding="5">
<tbody>
<tr style="background-color:#C0C0C0">


- 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:23 pm

g4eli wrote:Hi,

FWIW I also thought about TLE which can obviously be just a sample. As TLE has a timestamp the software would use the most recent data. The advantage of XML is obvious I hope, especially when added to XSLT.
FWIW here’s an example of a dynamically changing XML data file displayed via XSLT: http://v2.sdrspace.com/ .

Simon Brown G4ELI
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:25 pm

g4eli wrote:David,

Please throw an example into the pit – I have fields I want to see and fields I would like to see. Will probably get my satellite antennas up in a week or two…

Simon Brown G4ELI
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:26 pm

Hi Simon,

I do not think you need to explain nor defend XML, as it was already the topic of discussion at the colloquium.
Its getting the schema sorted. as soon as its available somewhere for ingestion by applications / websites, users can do whatever they like with it.

The status flags would also need *not launched yet* or *scheduled for launch* apart from active, decayed etc...

And regarding the management interface, lets see how we would see adding satellites.
Maybe another nice thing would be to have two flags:
- Coordinated by IARU
- Notified with ITU


This may alert people that launch CubeSats that they have some work to do....
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:30 pm

the post above have been transcribed to the forum from E-mail.
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 g4dpz » Tue Nov 18, 2014 3:37 pm

Hi,

This is an example XML that Christophe Mercier od AMSAT-F sent me early last year.

AmateurSatellite.xml
(3.18 KiB) Downloaded 123 times


and the corresponding xsd:

AmsatSatelliteList.xsd
(5.08 KiB) Downloaded 120 times


It might be a starting point.

- Dave
g4dpz
 
Posts: 143
Joined: Sun Oct 06, 2013 9:07 pm

Re: XML and JSON interfaces to satellite database

Postby dk3wn » Tue Nov 18, 2014 3:44 pm

pa3weg wrote:
DK3WN wrote:Hi all,

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

And generally for the record: last updated (date / by)

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

@Dave: Is it possible to update the TLE daily (e.g. by a crone job) ?

73 Mike

DK3WN
dk3wn
 
Posts: 1
Joined: Tue Oct 08, 2013 7:23 am

PreviousNext

Return to General discussion

Who is online

Users browsing this forum: No registered users and 2 guests

cron