A collection of scripts which populates the observations table(multi_obs) of the Xenia table schema.

Discussion

Earlier discussions have focused on fixing the format and terms within intermediate files like the Seacoos netCDF convention or XML. While these standards and formats might be leveraged, the Xenia schema itself functions as the format and the observation terms are defined within the 'Observations Data Dictionary' section of the Xenia table schema.

NWS

The following perl scripts were originally provided by Sara Haines to screen scrape observation data from National Weather Service (NWS) meteorological stations. The have been adapted to create INSERT statements for a table similar to the Xenia mult_obs table. Note: Still need to change a few table column references to get this working properly with the Xenia schema, but the changes should be minor.

This script grabs the http observation line feed for a station from a station list and creates a temporary data file which this script then uses to create the corresponding SQL.

Buoy data

This script grabs an input buoy data file (.dat) and does a lot of additional processing, but at the end creates an insert SQL statement and file for populating the database.

-- JeremyCothran - 26 May 2006
to top