This is an export of the meteorological data collected by LTAR sites and ingested by the NAL LTAR application. This export consists of an SQL schema definition file for creating database tables and the data itself.

The data is provided in two formats: SQL insert statements (.sql) and CSV files (.csv). Please use the format most convenient for you. Note that the SQL insert statements take much longer to run since each row is an individual insert.

Description of zip files

The ltar_archive_*.zip files contain database exports. The schema is a .sql file; the data is exported as both SQL inserts and CSV for convenience.
There is a README in markdown and PDF in the zips.

Contains the database export of the schema and data for the site, site_station, and met tables as SQL insert statements.

ltar_archive_db_sql_export_20201231.zip --> has data until 2020-12-31
ltar_archive_db_sql_export_20210430.zip --> has data until 2021-04-30

Contains the database export of the schema and data for the site, site_station, and met tables as CSV.

ltar_archive_db_csv_export_20201231.zip --> has data until 2020-12-31
ltar_archive_db_csv_export_20210430.zip --> has data until 2021-04-30

Contains the raw CSV files that were sent to NAL from the LTAR sites/stations.

ltar_rawcsv_archive.zip --> has data until 2021-04-30