Home

Welcome to the MGFieldPy wiki!

To-Do

• Add feature to dis-/enable storing of all exact values from each measurement

• Add sufficient monitoring of SQL Server health like memory and storage usage. (Incident 10.10.24 - VNC, VPN, SQL working on Pi but Grafana was not)

• Rewrite the whole project in C/C++ to make it more efficient - use any of the following C++ libraries:

• github.com/topics/ads1115?l=c%2B%2B
• github.com/hallgrimur1471/Adafruit_ADS1X15_RPi
• github.com/wollewald/ADS1115_WE/tree/master
• github.com/berndporr/rpi_ads1115

• Add OUT-Value calculation to Raspberry Pi Output: SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(time_utc) DIV 30 * 30) AS time_interval, AVG(SQRT( POW(x_value - out_value, 2) + POW(y_value - out_value, 2) + POW(z_value - out_value, 2) )) AS avg_magnetic_field_strength FROM mgfield.buetzfleth2.rawmeasurements GROUP BY time_interval ORDER BY time_interval;

• Add live Data from WNG station, located near the measurement site to compare our data to professional sites by the GFZ.

• Docs: https://intermagnet.org/new_data_download.html, https://imag-data.bgs.ac.uk/GIN_V1/hapi; Data set IDs for the INTERMAGNET HAPI server are composed of 4 parts: /// where:

iaga-code is WNG publication-state is one of: reported for raw data from the sensor adjusted for data with provisional adjustments made quasi-def for data within 5nT of their final values definitive for final published data best-avail for the best available from the above data types cadence is one of pt1m for minute data or pt1s for second data orientation is one of: native for the orientation of the data as supplied by the data provider xyzf for a Cartesian reference frame