SeaLevel.info

 

 

 

 

Sea-level data analysis and visualization

 

Search for a tide gauge's sea-level measurement record

Enter any of the following:


Enter tide gauge:

E.g., these examples all find the San Diego, CA, USA tide gauge:

 

 

<% import sys import re def V(txt): '''convert "<" to "<" etc.''' txt = re.sub(r'<', '<', txt) txt = re.sub(r'>', '>', txt) return txt def P(txt): req.write(txt) def introspect(x): callability = '' if (callable(x)): callability = ' (Callable)' result = V(repr(x)) if len(result) > 0: result += ", " result += "type=" + V(repr(type(x))) + callability return result P("\n") P("\n") P("\n") # Get parameters passed in with URL ("get") or via "post" into a dictionary, # like PHP's $_REQUEST dictionary: REQUEST = {} if form.list and len(form.list): for fld in form.list: REQUEST[fld.name] = fld.value reloaded = 'gosubmit' in REQUEST # $reloaded = isset($_REQUEST['gosubmit']); // True or False if 'stationlist' in REQUEST: # if (isset($_REQUEST['stationlist'])) { stationlist = REQUEST['stationlist'] # $stationlist = $_REQUEST['stationlist']; else: # } else { stationlist = 'NOAA2016' # $stationlist = 'NOAA2016'; # # } # $NOAA2016_checked = $MITROVICA23_checked = $HOLGATE9_checked = $ALLSTATIONS_checked = $NOAA2013_checked = $NOAA2013_50yr_checked = $NOAA2013_60yr_checked = $NOAA2012_checked = $NOAA2010_checked = $PSMSL255_checked = $GLOSS1997_checked = $NOAA45_checked = $NOAA42_checked = $NOAA31_checked = $NOAA2012dropped_checked = ''; NOAA2016_checked = MITROVICA23_checked = HOLGATE9_checked = ALLSTATIONS_checked = NOAA2013_checked = NOAA2013_50yr_checked = NOAA2013_60yr_checked = NOAA2012_checked = NOAA2010_checked = PSMSL255_checked = GLOSS1997_checked = NOAA45_checked = NOAA42_checked = NOAA31_checked = NOAA2012dropped_checked = '' if 'NOAA2010' == stationlist: # if ('NOAA2010' == $stationlist) { spreadsheet = 'MSL_NOAA2010.html' # $spreadsheet = 'MSL_NOAA2010.html'; NOAA2010_checked = 'checked' # $NOAA2010_checked = 'checked'; elif 'NOAA2012' == stationlist: # } elseif ('NOAA2012' == $stationlist) { spreadsheet = 'MSL_NOAA2012.html' # $spreadsheet = 'MSL_NOAA2012.html'; NOAA2012_checked = 'checked' # $NOAA2012_checked = 'checked'; elif 'GLOSS1997' == stationlist: # } elseif ('GLOSS1997' == $stationlist) { spreadsheet = 'MSL_GLOSS1997.html' # $spreadsheet = 'MSL_GLOSS1997.html'; GLOSS1997_checked = 'checked' # $GLOSS1997_checked = 'checked'; elif 'NOAA2012dropped' == stationlist: # } elseif ('NOAA2012dropped' == $stationlist) { spreadsheet = 'MSL_NOAA2012dropped.html' # $spreadsheet = 'MSL_NOAA2012dropped.html'; NOAA2012dropped_checked = 'checked' # $NOAA2012dropped_checked = 'checked'; elif 'NOAA45' == stationlist: # } elseif ('NOAA45' == $stationlist) { spreadsheet = 'MSL_NOAA2010_45.html' # $spreadsheet = 'MSL_NOAA2010_45.html'; NOAA45_checked = 'checked' # $NOAA45_checked = 'checked'; elif 'NOAA42' == stationlist: # } elseif ('NOAA42' == $stationlist) { spreadsheet = 'MSL_NOAA2010_42.html' # $spreadsheet = 'MSL_NOAA2010_42.html'; NOAA42_checked = 'checked' # $NOAA42_checked = 'checked'; elif 'NOAA31' == stationlist: # } elseif ('NOAA31' == $stationlist) { spreadsheet = 'MSL_NOAA2010_31.html' # $spreadsheet = 'MSL_NOAA2010_31.html'; NOAA31_checked = 'checked' # $NOAA31_checked = 'checked'; elif 'PSMSL255' == stationlist: # } elseif ('PSMSL255' == $stationlist) { spreadsheet = 'MSL_PSMSL2010-2012_255.html' # $spreadsheet = 'MSL_PSMSL2010-2012_255.html'; PSMSL255_checked = 'checked' # $PSMSL255_checked = 'checked'; elif 'NOAA2013_50yr' == stationlist: # } elseif ('NOAA2013_50yr' == $stationlist) { spreadsheet = 'MSL_NOAA2013_50yr.html' # $spreadsheet = 'MSL_NOAA2013_50yr.html'; NOAA2013_50yr_checked = 'checked' # $NOAA2013_50yr_checked = 'checked'; elif 'NOAA2013_60yr' == stationlist: # } elseif ('NOAA2013_60yr' == $stationlist) { spreadsheet = 'MSL_NOAA2013_60yr.html' # $spreadsheet = 'MSL_NOAA2013_60yr.html'; NOAA2013_60yr_checked = 'checked' # $NOAA2013_60yr_checked = 'checked'; elif 'NOAA2013' == stationlist: # } elseif ('NOAA2013' == $stationlist) { spreadsheet = 'MSL_NOAA2013.html' # $spreadsheet = 'MSL_NOAA2013.html'; NOAA2013_checked = 'checked' # $NOAA2013_checked = 'checked'; elif 'MITROVICA23' == stationlist: # } elseif ('MITROVICA23' == $stationlist) { spreadsheet = 'MSL_mitrovica23_trendtable.html' # $spreadsheet = 'MSL_mitrovica23_trendtable.html'; MITROVICA23_checked = 'checked' # $MITROVICA23_checked = 'checked'; elif 'HOLGATE9' == stationlist: # } elseif ('HOLGATE9' == $stationlist) { spreadsheet = 'MSL_holgate9.html' # $spreadsheet = 'MSL_holgate9.html'; HOLGATE9_checked = 'checked' # $HOLGATE9_checked = 'checked'; elif 'ALLSTATIONS' == stationlist: # } elseif ('ALLSTATIONS' == $stationlist) { spreadsheet = 'all_stations_trendtable.html' # $spreadsheet = 'all_stations_trendtable.html'; ALLSTATIONS_checked = 'checked' # $ALLSTATIONS_checked = 'checked'; else: # } else { spreadsheet = 'MSL_global_trendtable5.html' # $spreadsheet = 'MSL_global_trendtable5.html'; NOAA2016_checked = 'checked' # $NOAA2016_checked = 'checked'; # # } %>

Spreadsheets & thumbnails...

You may click on any of the spreadsheet links below to open the specified spreadsheet in a web page by itself. (These spreadsheets can also be loaded directly into Microsoft Excel or Kingsoft WPS Office Spreadsheets.)

Or:

<% # echo "
\n"; P("\n") %>

    1. Select a station list:

    2. Then click

    3. Scroll down to view the data.

    4. Click on the column headers to sort by columns, or click on the table caption to view the spreadsheet on a page by itself.

 

 

Notes & credits

The tide gauge data on this site are collected from multiple sources, including the NOAA Center for Operational Oceanographic Products and Services, and PSMSL [Holgate et al., 2013; PSMSL, 2016].
 

These spreadsheets are in Microsoft Excel HTML format. They can be viewed as web pages, but they can also be loaded directly by Microsoft Excel 2003 or later.

They can also be loaded by Kingsoft Spreadsheets, which is part of "KingsSoft WPS Office," a free "Office Suite" similar to Microsoft Office.
Note #1: The best version of Kingsoft Office Free Edition for U.S. users is probably either version 9.1.0.4550 or perhaps this newer version. (Unfortunately, the newest version adds obnoxious "watermarks" when printing or creating pdf files.)
Note #2: if you use Kingsoft Spreadsheets, you might find that formatting of the sea-level data spreadsheets is improved by opening, saving, closing, and reopening them. I don't know why.
Note #3: when you install some versions of Kingsoft WPS Office under Windows, there might be an option to also install "Kingsoft Antivirus," or perhaps some other unwanted software. If so, I recommend that you un-check the checkbox. Or, if you forget to uncheck the checkbox, look under All Programs to find the "Kingsoft Antivirus" folder, which contains a link to uninstall it.

Although these spreadsheets can also be loaded by LibreOffice or OpenOffice Calc, those programs apparently do not support formulas in html format, so the formulas will be lost.

ZoHo and Calligra do not support .html spreadsheet files at all. (There are also some other Office Suites that I've not tested.)
 

The “Holgate-9” list is from SJ Holgate, 2007.
 

<% # # echo '

PSP -- Python Server Pages:
<% P("Python " + sys.version) %>

Copyright © 2012-2019, David A. Burton.