Page 2 of 3

Re: XML and JSON interfaces to satellite database

PostPosted: Tue Nov 18, 2014 3:20 pm
by pa3weg
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

Re: XML and JSON interfaces to satellite database

PostPosted: Tue Nov 18, 2014 3:20 pm
by pa3weg
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

Re: XML and JSON interfaces to satellite database

PostPosted: Tue Nov 18, 2014 3:21 pm
by pa3weg
dk3wn wrote:Hi Jim,

I think we should not touch the ITU list.

73 Mike

Re: XML and JSON interfaces to satellite database

PostPosted: Tue Nov 18, 2014 3:22 pm
by pa3weg
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

Re: XML and JSON interfaces to satellite database

PostPosted: Tue Nov 18, 2014 3:23 pm
by pa3weg
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

Re: XML and JSON interfaces to satellite database

PostPosted: Tue Nov 18, 2014 3:25 pm
by pa3weg
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

Re: XML and JSON interfaces to satellite database

PostPosted: Tue Nov 18, 2014 3:26 pm
by pa3weg
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....

Re: XML and JSON interfaces to satellite database

PostPosted: Tue Nov 18, 2014 3:30 pm
by pa3weg
the post above have been transcribed to the forum from E-mail.

Re: XML and JSON interfaces to satellite database

PostPosted: Tue Nov 18, 2014 3:37 pm
by g4dpz
Hi,

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

AmateurSatellite.xml
(3.18 KiB) Downloaded 157 times


and the corresponding xsd:

AmsatSatelliteList.xsd
(5.08 KiB) Downloaded 151 times


It might be a starting point.

- Dave

Re: XML and JSON interfaces to satellite database

PostPosted: Tue Nov 18, 2014 3:44 pm
by dk3wn
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