Skip to main content
U.S. FlagAn official website of the United States government
icon dot gov
Official websites use .gov

A .gov website belongs to an official government organization in the United States.

icon https
Secure .gov websites use HTTPS

A lock () or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Information

Aerosol Home Overview Stations Software Instruments Instrument Maintenance Publications Documents and Resources Presentations Photo Gallery

Data

Data Download Search for Aerosol Data

data.aggregate.sqldb

data.aggregate.sqldb updates data in a SQL database. The tables for the station must first have been initialized by data.newstation.sqldb. The data inserted is controlled by sqldb.conf.

It is intended to be called as part one of the aggregators invoked by data.aggregate.station.

Command Line Usage

data.aggregate.sqldb dbid station start end

Arguments

start and end

The time specifiers for the data to be retrieved. Start is inclusive while end is exclusive, so all data contained within the half open interval [start,end) will be returned. Any convertible time format is accepted.

station

The station identifier code. For example 'brw'. Case insensitive.

dbid

Identifier into the configuration file that specifies the database and table structure.

Example Usage

data.aggregate.sqldb 1h bnd 2008 2009