-- MonishaKanoth - 03 Sep 2025

Table of contents

Populating Xenia Support Tables

Populating Platform Tables

insert_2_platform_tbl.pl - This script selects platform parameters from the observation tables (based on the earlier seacoos table schema such as wind_map, sst_map etc) and creates inserts to the platform table. Since the platform table is uniquely indexed on the platform_handle, this script can be executed on several tables to obtain the maximum number of unique platform handles.

Populating Sensor Tables

insert_2_sensor_tbl.pl - This script selects IDs from xenia tables such as organization, platform, type_id and creates inserts to populate the sensor table.

---

Populate Xenia multi_obs table

Based on the support table Ids, new data is inserted to the multi_obs table from the fixed point netcdf files.

xenia_insert_sql.pl & SeacoosXenia^?.pm - Downloads and parses netcdf files based on parameters specified in environment.xml and creates inserts to the multi_obs table including qc parameters from a cross indexing between the support table hash and data hash. The sql file created is then used to insert new data to the multi_obs table. Unique indexing on the multi_obs table prevents multiple inserts for the same sensor, platform, lat and lon.

---

Xenia Table Outputs

• CSV Data Files - xenia_2_csv.pl - Queries multi_obs table based on input parameters such as platform, start_date and end_date and creates csv data files.
• WMS Queries - Alter layer properties in xenia.map file to generate map images.
• Shapefiles

to top