The U.S. government is closed. This site will not be updated; however, NOAA websites and social media channels necessary to protect lives and property will be maintained.
To learn more, visit commerce.gov.
For the latest forecasts and critical weather information, visit weather.gov.
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)