The SatDbPosition data record contains the antenna pointing information for one satellite and one antenna in the satellite_positions database table. The fields in the SatDbPosition data record are 1:1 replicas of the SQL database record. Please refer to the database model description at section Satellite Database how relations between tables are maintained using IDs.
The Satellite-Positions table typically contains number-of-satellites x number-of-antennas records, as each satellite requires different antenna pointing angles for each particular antenna.
Data Model
| Key | Type | Value |
|---|---|---|
| positionId | Number | unique, primary key, auto generated |
| satelliteId | Number | the ID of the satellite this SatDbPointing record refers to (relates to the satellites table). |
| azimuth | Number | antenna azimuth pointing angle in degrees (floting point) |
| elevation | Number | antenna elevation pointing angle in degrees (floting point) |
| polarization | Number | antenna polarization pointing angle in degrees (floting point) |
| satelliteColocation | Array of Number | contains the list of satellites (referenced by their satelliteId) which are seen at the same pointing angles by this particular antenna. See remark below |
| targetNumber | Number | a target number to be set at some antenna controllers (integer) |
| antennaId | Number | the ID of the antenna this SatDbPointing record refers to (relates to the antennas table). |
| defaultPosition | Boolean | true means "this is the default position for this antenna" |
| comment | String | a free text describing the purpose of this database entry |
| modified | String | timestamp, generated by database at creation / modification time |
Remark: Depending on the dish size of an antenna, the antenna "sees" not only the satellite it is pointed to but also other satellites which are at positions in the orbit very near to the first satellite. The satelliteColocation list contains the satelliteIds for these satellites.
Actually this list is not maintined by the the backend, the satelliteColocation will always read as an empty array.