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. |
| Monthly Statistics,
including the minimum, maximum, mean and standard deviation, are presented as html and plain text
tables for sea level, barometric pressure, water temperature and air temperature.
Timeseries of the monthly mean, minimum and maximum are also presented as graphs.
|
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 |
| IDO70015 |
Niue |
Niue |
Alofi |
13.6665 |
19° 03' 10" S |
169° 55' 15" W |
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
including levelling connection to nearby geodetic stations providing
Ellipsoid Heights of SSBM. 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 |
The hourly data is in a format that can
be easily viewed using spreadsheet software such as MS
Excel.
Firstly click (or double click) on the
link in the table of hourly
data.
If you have MS Office 2000 or later the
Comma Separated Variable (.csv) file will be opened in
your browser window.
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.
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.
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.
The first row of the 10th
column is the site name.
- 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 |
- 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.
- Either click on the chart wizard icon in
the toolbar (picture of a bar graph) or select
"chart" in the "insert" drop down
menu.
- In the Chart Type window select XY(scatter).
- Select the Sub-Type of graph and click on next.
- You are then presented with a window with
2 tab like menu options (1) series and (2) data range.
click on the series tab.
- 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.
- 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.
- 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.
- 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.
- 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.
- This value is -9999 and should be removed
before generating a chart.
- 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.
- 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
|
