South Pacific Sea Level and Climate Monitoring Project
File information and Instructions

Data Formats File Names Data Units Viewing Data Plotting Data Data Errors

The format and naming of the files is as follows:-

DATA FORMAT
TOP
Hourly Data are presented in Comma Separated Variable (.csv) format which is compatable with use in a spreadsheet such as MS Excel. These files can also be plotted with MS Excel. To save a file in text format, you will need to right-click on the file link to use "Save Target As ..." in the popup menu.

FILE NAMES
TOP
Hourly data files have the following names: nnnnnnnn_yyyy.csv, where nnnnnnnn is the ID Code as given in the following table.
For metadata, please click on the country name in the table below.

ID CODE COUNTRY ISLAND / ATOLL TOWN / DISTRICT SSBM LATITUDE LONGITUDE
IDO70001 Cook Islands Rarotonga Avatiu 3.3084 21 11' 58" S 159 47' 10" W
IDO70007 Federated States
of Micronesia
Pohnpei Dekehtik 4.0257 06 58' 42" N 158 11' 50" E
IDO70004 Fiji Viti Levu Lautoka 4.4326 17 36' 19" S 177 26' 17" E
IDO70010 Kiribati Tarawa Betio 4.6301 01 21' 45" N 172 55' 48" E
IDO70002 Marshall Islands Majuro Uliga 3.8486 07 06' 27" N 171 22' 15" E
IDO70005 Nauru Nauru Aiwo 6.0043 00 31' 55" S 166 54' 33" E
IDO70008 Papua New Guinea Manus Lombrum 4.5813 02 02' 10" S 147 22' 31" E
IDO70012 Samoa Upolu Apia 4.8706 13 49'09" S 171 45' 21" W
IDO70011 Solomon Islands Guadalcanal Honiara 4.266 09 25' 18" S 159 57' 19" E
IDO70003 Tonga Tongatapu Nuku'alofa 4.8464 21 08' 25" S 175 10' 45" W
IDO70006 Tuvalu Funafuti Fongafale 5.2468 08 30' 10" S 179 12' 33" E
IDO70009 Vanuatu Efate Port Vila 4.8993 17 45' 41" S 168 17' 35" E

DATA UNITS
TOP
Dates and times are given in Universal Time Coordinated (UTC). 00:00 is midnight, 06:00 is 6am, 12:00 is noon and 18:00 is 6pm.

Sea Level Observed sea levels are in metres above Tide Gauge Zero (e.g. 1.205 metres)
SSBM Height of Seaframe Sensor Bench Mark above Tide Gauge Zero. Geoscience Australia has Survey Information for the benchmarks near the tide gauges. SSBM is NOT changed to agree with this survey information, unless there is a known shift in SSBM
Water Temperature Water Temperatures are in degrees Celsius (e.g. 20.5 deg C)
Air Temperature Air Temperatures are in degrees Celsius (e.g. 20.5 deg C)
Barometric Pressure Barometric Pressures are in hPa (mb) (e.g.. 1010.1 hPa)
Residuals Residual sea levels are in metres (e.g. -0.014m indicates that the observed sea level is 0.014m below predicted sea level)
Adjusted Residuals Sea level anomalies are in metres (e.g. -0.077m indicates that the observed sea level is 0.077m below predicted sea level, adjusted for the static barometric pressure effect)
Wind Direction Wind Directions in Degrees True (e.g. 205 degrees True)
Wind Gust Wind Gusts are in m/sec (e.g. 8.5 m/sec)
Wind Speed Wind Speeds are in m/sec (e.g. 6.5 m/sec)

Missing or erroneous data points are set to a value of -9999 (you need to remove these to plot the data).
 
How to view the Hourly data.
TOP
  1. The hourly data is in a format that can be easily viewed using spreadsheet software such as MS Excel.

  2. Firstly click (or double click) on the link in the table of hourly data.

  3. If you have MS Office 2000 or later the Comma Separated Variable (.csv) file will be opened in your browser window.

  4. Older versions of MS Office may ask you if you want to open the file or to save it to your computer.

  • It is easier to save the file to your computer in a place that you are familiar with (eg desktop or My Documents) and then open the file from there. This also means that you can save any changes that you make to the file.

  • If you choose to open the file from the table, it will open in your browser window. You then need to click on view in the menu bar at the top then select "toolbars" and "standard". This should put all the icons in the toolbar for plotting etc.

  • For MS Office 2000+ you can also save the file to your computer or use the above method to present the "standard Toolbar" in the browser. MS Office 2000+ also has a tools icon, which when selected will place all the "standard Toolbar" icons on the top toolbar.

  1. The hourly data files consist of eleven columns of data and information. The first column is the date and time stamp in the format of dd/mm/yyyy mm:ss. If the values are shown as "########", select "Column"/"AutoFit Selection" from the "Format" menu.

  2. The following nine columns are hourly data of the following parameters: Sea Level, Water Temperature, Air Temperature, Barometric Pressure, Sea Level Residuals, Sea Level Anomilies, Wind Gust, Wind Direction and Wind Speed.

  3. The first row of the 10th column is the site name.

  4. When you have this data in a spreadsheet, you can then proceed with plotting any of the nine types of data in the hourly files.
How to Graph (plot) Hourly data
TOP
  1. Firstly select the date and time column by clicking on the top cell (the "A" column cell). This should highlight the first column. This column becomes the X axis data for a time series chart. If the values are shown as "########", select "Column"/"AutoFit Selection" from the "Format" menu.
  2. Either click on the chart wizard icon in the toolbar (picture of a bar graph) or select "chart" in the "insert" drop down menu.
  3. In the Chart Type window select XY(scatter).
  4. Select the Sub-Type of graph and click on next.
  5. You are then presented with a window with 2 tab like menu options (1) series and (2) data range. click on the series tab.
  6. In this window you must select the positions (in the spreadsheet) of the X and Y data and of the site name for the Chart.
  7. To select the X (date and time) data click the add button then the red arrow on the right side of the X values window, then click on the "A" cell at the top of the first column. You should then click on the red arrow on the right side of the small window. This should then list the reference for the X data in the X values window.
  8. Then follow the previous step to select the Y values and Name. So to chart the Barometric Pressure data select the "E" column (BP) for the Y values and the K1 cell for the name. Click on next.
  9. Then you should have a window with a small image of the graph and windows with the chart title and X and Y axis values. The Site name should be in the chart title window and the axis titles blank. Here you should enter the axis titles and units, eg. Time(Hours) for the X axis and Barometric Pressure(hPa) for the Y axis. Then select "next" and finish in the next window. You should then have a plot of Barometric Pressure against time from the site and year that you first selected.
  10. Note that you may need to hide to top row (the first row with the column headings eg Date and time HL etc.) to get MS Excel to show the date and time in the X axis. To do this select the first row click on "format", select "rows" then "hide"
Errors in the data
TOP

The data has an error value asigned to values that are either missing or erroneous.

  1. This value is -9999 and should be removed before generating a chart.
  2. To do this, once you have opened the .csv file select the whole of the spreadsheet by clicking on the top left cell. You may also just select the column of data that you want to chart.
  3. You must then find and replace all error values (-9999), to do this click on edit in the toolbar and select replace. In the "find what" box type "-9999" and leave the "replace with" box blank. Click on "replace all" to replace all error values with a blank cell or on "replace" to replace one cell at a time.

*Note that if you have opened the file from the table and not saved it to your computer then you will be prompted to save the changes. You will need to specify where to save the file. If you wish to save formating changes and Charts, you will need to specify "Microsoft Excel Workbook (*.xls) in the "Save as type:" box.

Return to the Data Table