CarbonTracker Lagrange Documentation
MySql Database¶
Information about the individual footprint files is contained in a MySQL database. The structure of the database is:
mysql> describe info_v11;
+--------------+-------------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------------+------+-----+------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| filename | varchar(255) | NO | MUL | NULL | |
| directory | varchar(256) | NO | | NULL | |
| version | varchar(30) | NO | | NULL | |
| type | varchar(20) | NO | | NULL | |
| subtype | varchar(25) | NO | | NULL | |
| model | varchar(20) | NO | | NULL | |
| lat | float | NO | | NULL | |
| lon | float | NO | | NULL | |
| surface_elev | float | NO | | 0 | |
| agl | float | NO | | -999 | |
| asl | float | NO | | -999 | |
| alt_type | enum('agl','asl') | NO | | NULL | |
| alt_index | tinyint(4) | NO | | 0 | |
| date | date | NO | | NULL | |
| time | time | NO | | NULL | |
| obsdate | date | NO | | 0000-00-00 | |
| obstime | time | NO | | 00:00:00 | |
| solardate | date | NO | | NULL | |
| solartime | time | NO | | NULL | |
| site_num | int(11) | NO | | NULL | |
| event_num | int(11) | NO | | 0 | |
| group_num | int(11) | NO | | 0 | |
| operator | varchar(20) | NO | | NULL | |
+--------------+-------------------+------+-----+------------+----------------+
24 rows in set (0.00 sec)