==========
= README =
==========

Data:
=====
https://vlbisysmon.evlbi.wettzell.de/monitoring_archive/ttw2_temp/


Information:
============
Recorded data of a each single temperature sensor of the TTW-2 are 
stored to a corresponding database (SQLite)

Sensor  Database          Location
T1E     TempTtw2F1E.db    Telescope tower ground floor (East)
T1W     TempTtw2F1W.db    Telescope tower ground floor (West)
T2E     TempTtw2F2E.db    Telescope tower first floor (East)
T2W     TempTtw2F2W.db    Telescope tower first floor (West)
T3E     TempTtw2F3E.db    Telescope tower ceiling steel beam (East)
T3W     TempTtw2F3W.db    Telescope tower ceiling steel beam (West)


Reference:
==========
Maehler, S.; Kluegel, T.; Loesler, M. & Schueler, T. (2018): Permanentes Referenzpunkt-Monitoring 
der TWIN Radioteleskope am Geodaetischen Observatorium Wettzell. avn, 2018, 125, 210-219


Sample to read the data using Python:
=====================================
import sqlite3
con = sqlite.connect('TempTtw2F1E.db')
cursor = con.cursor()
cursor.execute("SELECT name FROM sqlite_master WHERE type='table';")
print(cursor.fetchall())
===> Prints all available tables
cur=con.cursor()
for row in cur.execute('SELECT * FROM Sensordata'):
    print(row)
===> Prints all values
data = cursor.execute("SELECT * FROM Sensordata;")
print(data.description)
===> Prints all column names
(('Time', None, None, None, None, None, None), ('Data', None, None, None, None, None, None), ('Status', None, None, None, None, None, None), ('Year', None, None, None, None, None, None), ('Month', None, None, None, None, None, None), ('Day', None, None, None, None, None, None), ('Hour', None, None, None, None, None, None), ('Minute', None, None, None, None, None, None), ('Second', None, None, None, None, None, None))