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

Project Title:  View help for Project Title Long-Term Agricultural Research (LTAR) network - Meteorological Collection

Summary:  View help for Summary 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

Resource Title: Meteorological data.

File Name: ltar_archive_DB.zip

Resource 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

Original Distribution URL:  View help for Original Distribution URL https://agdatacommons.nal.usda.gov/articles/dataset/Long-Term_Agricultural_Research_LTAR_network_-_Meteorological_Collection/24665466

Subject Terms:  View help for Subject Terms weather data; meteorological data; LTAR meteorological stations; data.gov; ARS

Geographic Coverage:  View help for Geographic Coverage United States

Time Period(s):  View help for Time Period(s) 7/24/2013 – 4/30/2021

Data Type(s):  View help for Data Type(s) observational data

Collection Notes:  View help for Collection Notes DOI: 10.15482/USDA.ADC/1503868 Citation: USDA ARS LTAR Network (2021). Long-Term Agricultural Research (LTAR) network - Meteorological Collection. USDA Agricultural Research Service. https://doi.org/10.15482/USDA.ADC/1503868 (Downloaded 2026-06-26)