658717

BandG WTP3 Manual

72
Zoom out
Zoom in
Previous page
1/102
Next page
70
SQLite Database Structure
The database used in WTP3 consists of the following tables
Logs
The logs table contains data that identies the individual data logging sessions:
ID unique identier for each logging session
Start start date and time of the session
Stop stop data and time of the session if stopped via duration or manual control. “Power o” stop
times are not recorded
Notes Records assistance text, identifying how the log session was started e.g. “Power On”
Datalog
The datalog table contains the variable data congured by the user in datalog.d
LogID unique identier for each logging session, from Logs table
Var variable number of the data, from bg_vars.d
Calibrated calibrated value of the variable at the time of logging
Raw raw, pre-calibrated, value of the variable at the time of logging
Time date and time of the sample
PositionID unique identier for each position log, from Tracks table
Tracks
The tracks table contains a record of positions recorded at 1Hz. Each data log record contains a positionID eld
to allow cross reference of each data log with a position.
PositionID unique identier for each position log
Latitude latitude value in seconds (Degrees * 360000)
Longitude current longitude value in seconds (Degrees * 360000)
Variables
The variables table contains a lookup of the name of each logged variable from bg_vars.d
Var variable number from bg_vars.d
Name name of variable from bg_vars.d (e.g. “TW_speed”)
Alarms
The alarms table contains a history of alarms raised.
AlarmID unique identier for each alarm raised
Var variable number from bg_vars.d
Raised DATETIME
Value real
… 72 …


Need help? Post your question in this forum.

Forumrules


Report abuse

Libble takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Product:

For example, Anti-Semitic content, racist content, or material that could result in a violent physical act.

For example, a credit card number, a personal identification number, or an unlisted home address. Note that email addresses and full names are not considered private information.

Forumrules

To achieve meaningful questions, we apply the following rules:

Register

Register getting emails for BandG WTP3 at:


You will receive an email to register for one or both of the options.


Get your user manual by e-mail

Enter your email address to receive the manual of BandG WTP3 in the language / languages: English as an attachment in your email.

The manual is 7,24 mb in size.

 

You will receive the manual in your email within minutes. If you have not received an email, then probably have entered the wrong email address or your mailbox is too full. In addition, it may be that your ISP may have a maximum size for emails to receive.

The manual is sent by email. Check your email

If you have not received an email with the manual within fifteen minutes, it may be that you have a entered a wrong email address or that your ISP has set a maximum size to receive email that is smaller than the size of the manual.

The email address you have provided is not correct.

Please check the email address and correct it.

Your question is posted on this page

Would you like to receive an email when new answers and questions are posted? Please enter your email address.



Info