Long-Term Agricultural Research (LTAR) network - Meteorological Collection

The LTAR network maintains stations for standard meteorological measurements including, generally, air temperature and humidity, shortwave (solar) irradiance, longwave (thermal) radiation, wind speed and direction, barometric pressure, and precipitation. Many sites also have extensive comparable legacy datasets. The LTAR scientific community decided that these needed to be made available to the public using a single web source in a consistent manner. To that purpose, each site sent data on a regular schedule, as frequently as hourly, to the National Agricultural Library, which has developed a web service to provide the data to the public in tabular or graphical form.
This archive of the LTAR legacy database exports contains meteorological data through April 30, 2021. For current meteorological data, visit the GeoEvent Meteorology Resources page, which provides tools and dashboards to view and access data from the 18 LTAR sites across the United States. Resources in this dataset:Resource Title: Meteorological data. File Name: ltar_archive_DB.zipResource Description: 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 ltararchive*.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

LTAR网络维护着用于标准气象观测的站点，通常包括空气温度和湿度、短波（太阳）辐射、长波（热）辐射、风速和风向、气压以及降水量等数据。众多站点还拥有广泛的、可比对的旧有数据集。LTAR科学界决定，这些数据有必要以统一的方式，通过单一的网络平台向公众开放。为此，每个站点均按照固定的时间表，最频繁时甚至每小时一次，将数据发送至国家农业图书馆。国家农业图书馆已开发出一种网络服务，以便以表格或图形形式向公众提供这些数据。
此LTAR旧有数据库存档的档案包含了截至2021年4月30日的气象数据。如需获取最新的气象数据，请访问“GeoEvent气象资源”页面，该页面提供了工具和仪表板，用于查看和访问美国18个LTAR站点所提供的数据。
本数据集中的资源：
资源标题：气象数据。
文件名：ltar_archive_DB.zip
资源描述：这是LTAR站点收集并由NAL LTAR应用程序摄入的气象数据的导出。此导出包括用于创建数据库表的SQL模式定义文件以及数据本身。
数据以两种格式提供：SQL插入语句（.sql）和CSV文件（.csv）。请使用对您最方便的格式。请注意，SQL插入语句的执行时间较长，因为每一行都是一个单独的插入。
压缩文件描述
ltararchive*.zip文件包含数据库导出。模式为.sql文件；数据以SQL插入和CSV格式导出，以便于使用。
压缩文件中包含README（Markdown格式）和PDF格式的说明文档。
包含站点、站点-站点和气象表的模式和数据导出的数据库。
ltar_archive_db_sql_export_20201231.zip --> 包含至2020年12月31日的数据
ltar_archive_db_sql_export_20210430.zip --> 包含至2021年4月30日的数据
包含站点、站点-站点和气象表的模式和数据导出的CSV。
ltar_archive_db_csv_export_20201231.zip --> 包含至2020年12月31日的数据
ltar_archive_db_csv_export_20210430.zip --> 包含至2021年4月30日的数据
包含从LTAR站点/站点发送至NAL的原始CSV文件。
ltar_rawcsv_archive.zip --> 包含至2021-04-30的数据