Conversion of NOS data downloaded 2007-12-17 The following non-U.S. stations found in U.S. data were dropped by import: 1732417 Fare Ute Point, 1778000 APIA, W. SAMOA, 1910000 SUVA, SUVA HARBOR, 2695540 Bermuda Esso Pier, 9500966 Madero, Tampico Harbor, Mexico, 9635000 Puerto Quetzal (San Jose), 9640507 La Union, 9650593 Puerto Cortes, 9662957 Puerto Corinto, 9710441 Settlement Point, BA The following U.S. stations had problems and were dropped by import: 9469338 LOST RIVER, SEWARD PENINSULA, AK: no constituents in web page Other warnings from import: ****** Weird meridian on station 9462450 (Nikolski, AK) utcm2=69.300000 lstm2=100.700000 -11.333333 100.813486 0.113486 Stations with no datums: 8510321 8517276 8518903 8518905 8518995 8519024 8530985 8531232 8534883 8536931 8632837 8636653 8670681 8720011 8720012 8721020 8721608 8732828 8761720 8764311 8770597 8771081 9413617 9413624 9413626 9413651 9413745 9414305 9414449 9414501 9451054 9454571 9454721 9458293 9458665 9460150 9465234 9465249 9465261 9465374 9468132 9497649 9497778 9751567 9755679 392 reference stations successfully imported. QA check performed using -b"2008-01-03 00:00" to avoid year-end effects. Key to QA check codes: OK Reference station matches NOS published tide table. slight-OK Reference station shows minor differences with NOS published tide table. sub-OK NOS published tide table is based on a subordinate station rather than the harmonic constants that were downloaded, so a good match can't be expected. In some cases the stations may be near each other but not exactly the same location. The quality of the match varies widely, with the minimum plausible match being that the higher high and lower low tide predictions agree to within 1 hour more often than not. Some stations along the gulf coast only match on the lower low tide; these are flagged as poor matches. Not found Could not easily locate published tide table for this station based on its original name. Often the tide table does exist under a different name, but it is too time-consuming to resolve definitively. dup Station is redundant with another. *** Actionable issue found. !!! Issue found that cannot or should not be acted upon in the data at this end; e.g., if there is a mismatch but it is not obvious which data are more correct. ??? The LST harmonic constants are calibrated to the wrong time zone. The predictions would match except for the time zone disagreement. station_id | name | QA check ------------+----------------------------------------------+---------- 1611347 | PORT ALLEN, HANAPEPE BAY, KAUAI ISLAND, HI | sub-OK 1611400 | Nawiliwili, HI | OK 1612340 | Honolulu, HI | OK 1612480 | Mokuoloe, HI | OK 1615680 | Kahului, HI | OK 1617433 | Kawaihae, HI | sub-OK 1617760 | Hilo, HI | OK 1619000 | Johnston Atoll, | OK 1619910 | Sand Island, Midway Islands, | OK 1630000 | Guam, | OK 1631428 | Pago Bay, Guam, | Not found 1770000 | Pago Pago, | OK 1820000 | Kwajalein, Marshall Islands, | OK 1840000 | CHUUK, MOEN ISLAND, E. CAROLINE ISLANDS, | OK 1890000 | Wake Island, | OK 8410140 | Eastport, ME | OK 8411250 | Cutler Naval Base, ME | sub-OK 8413320 | Bar Harbor, ME | OK 8414612 | Bangor, ME | sub-OK 8415490 | Rockland, ME | sub-OK 8417134 | Gardiner, ME | Not found 8417177 | Hunniwell Point, ME | sub-OK 8417208 | Richmond, ME | Not found 8418150 | Portland, ME | OK 8419317 | Wells, ME | sub-OK 8419870 | Seavey Island, ME | sub-OK 8423898 | Fort Point, NH | sub-OK 8443970 | Boston, MA | OK 8447270 | Buzzards Bay, MA | Not found 8447386 | Fall River, MA | sub-OK 8447930 | Woods Hole, MA | OK 8448558 | Edgartown, MA | sub-OK 8449130 | Nantucket Island, MA | OK 8452660 | Newport, RI | OK 8452944 | Conimicut Light, RI | Not found 8454000 | Providence, RI | sub-OK 8454049 | Quonset Point, RI | Not found 8459681 | Block Island, RI | sub-OK 8461490 | New London, CT | OK 8465705 | New Haven, CT | sub-OK 8467150 | Bridgeport, CT | OK 8510321 | MONTAUK POINT LIGHT, NY | Not found 8510560 | Montauk, NY | OK 8510719 | Silver Eel Pond, NY | sub-OK 8512668 | Mattituck Inlet, NY | sub-OK 8512735 | South Jamesport, NY | sub-OK 8515786 | Eatons Neck, NY | sub-OK 8516945 | Kings Point, NY | OK 8516990 | Willets Point, NY | sub-OK 8517276 | COLLEGE PT, FT. OF 110TH ST, LI, NY | sub-OK 8518668 | Horns Hook, NY | sub-OK 8518750 | The Battery, NY | OK 8518903 | SPUYTEN DUYVIL CK, ENT., HUDSON R,, NY | sub-OK 8518905 | RIVERDALE, HUDSON RIVER, NY | sub-OK 8518995 | ALBANY, HUDSON RIVER, NY | *** ^ Meridian is off by 5 hours so that -z matches tables in LST. Approximated datum disagrees with tables by about 0.2 ft. 8519024 | FORT WADSWORTH, STATEN ISLAND, NY | sub-OK 8519483 | Bergen Point West Reach, NY | Not found 8530882 | PORT ELIZABETH, NEWARK BAY, NJ | sub-OK 8530985 | CONSTABLE HOOK UPPER BAY, NJ | sub-OK 8531232 | SOUTH AMBOY RARITAN RIVER, NJ | sub-OK 8531680 | Sandy Hook, NJ | OK 8534720 | Atlantic City, NJ | OK 8534883 | TUCKAHOE, UCKAHOE RIVER, NJ | sub-OK 8536110 | Cape May, NJ | sub-OK 8536931 | FORTESCUE CREEK, NJ | Not found 8537121 | Ship John Shoal, NJ | Not found 8538886 | Tacony-Palmyra Bridge, NJ | Not found 8539094 | Burlington, Delaware River, NJ | sub-OK 8540433 | Marcus Hook, PA | sub-OK 8545240 | Philadelphia, PA | OK 8545530 | PHILADELPHIA (PIER 11 NORTH), DEL. RIVER, PA | sub-OK 8548989 | Newbold, PA | sub-OK 8551762 | Delaware City, DE | sub-OK 8551910 | Reedy Point, DE | OK 8555889 | Brandywine Shoal Light, DE | sub-OK 8557380 | Lewes, DE | OK 8558690 | INDIAN RIVER INLET, DE | sub-OK 8570280 | OCEAN CITY, FISHING PIER, MD | OK 8570283 | Ocean City Inlet, MD | sub-OK 8571359 | Snow Hill, MD | Not found 8571421 | Bishops Head, MD | sub-OK 8571559 | Mc Creadys Creek, MD | sub-OK 8571702 | Beaverdam Creek, MD | sub-OK 8571773 | Vienna, MD | sub-OK 8571892 | Cambridge, MD | sub-OK 8572669 | Hillsboro, MD | sub-OK 8573349 | Crumpton, MD | sub-OK 8573364 | Tolchester Beach, MD | sub-OK 8573927 | Chesapeake City, MD | sub-OK 8574070 | Havre De Grace, MD | sub-OK 8574680 | Baltimore, MD | OK 8575512 | Annapolis, MD | sub-OK 8577330 | Solomons Island, MD | sub-OK 8579542 | Lower Marlboro, MD | sub-OK 8594900 | Washington, DC | OK 8630308 | CHINCOTEAGUE CHANNEL, SOUTH END, VA | sub-OK 8631044 | Wachapreague, VA | sub-OK 8632200 | Kiptopeke, VA | sub-OK 8632837 | Rappahannock Light, VA | Not found 8633532 | Tangier Island, VA | sub-OK 8635150 | Colonial Beach, VA | sub-OK 8635257 | Rappahannock Bend, VA | Not found 8635750 | Lewisetta, VA | sub-OK 8635985 | Wares Wharf, VA | sub-OK 8636580 | Windmill Point, VA | sub-OK 8636653 | Lester Manor, VA | sub-OK 8637624 | Gloucester Point, VA | sub-OK 8637689 | Yorktown USCG Training Center, VA | sub-OK 8638424 | Kingsmill, VA | sub-OK 8638433 | Scotland, VA | sub-OK 8638489 | Puddledock, VA | sub-OK 8638610 | Sewells Point, VA | OK 8638660 | PORTSMOUTH, NORFOLK NAVAL SHIPYARD, VA | sub-OK 8638863 | Chesapeake Bay Bridge Tunnel, VA | OK 8639207 | Rudee Inlet, VA | sub-OK 8639348 | Money Point, VA | sub-OK 8651370 | Duck, NC | OK 8652587 | Oregon Inlet Marina, NC | OK 8654400 | Cape Hatteras Fishing Pier, NC | OK 8654792 | OCRACOKE ISLAND, NC | sub-OK 8655875 | Sea Level, NC | Not found 8656483 | Beaufort, NC | sub-OK 8658120 | Wilmington, NC | OK 8658163 | Wrightsville Beach, NC | Not found 8659084 | Southport, NC | sub-OK 8659897 | Sunset Beach, NC | sub-OK 8661070 | Springmaid Pier, SC | OK 8662245 | Oyster Landing (North Inlet Estuary), SC | Not found 8664022 | GEN. DYNAMICS PIER, COOPER R., SC | sub-OK 8664941 | South Capers Island, SC | sub-OK 8665530 | Charleston, SC | OK 8668498 | Fripps Inlet, SC | sub-OK 8670681 | BULL STREET, SAVANNAH RIVER, GA | Not found 8670870 | Fort Pulaski, GA | OK 8677344 | St.Simons Island, GA | sub-OK 8679511 | KINGS BAY, GA | sub-OK 8720011 | CUT 1N FRONT RANGE, ST MARYS RIVER ENTR, FL | Not found 8720012 | CUT 2N FRONT RANGE, ST MARYS RIVER ENTR, FL | Not found 8720030 | Fernandina Beach, FL | OK 8720211 | Mayport Naval Sta., St Johns River, FL | sub-OK 8720218 | Mayport (Bar Pilots Dock), FL | OK 8720219 | Dame Point, FL | sub-OK 8720220 | Mayport, FL | Not found 8720226 | Main Street Bridge, St Johns River, FL | sub-OK 8720242 | Longbranch, FL | Not found 8720357 | I-295 Bridge, St Johns River, FL | sub-OK 8720503 | Red Bay Point, St Johns River, FL | Not found 8720554 | Vilano Beach ICWW, FL | sub-OK 8720582 | State Road 312, Matanzas River, FL | sub-OK 8720587 | St. Augustine Beach, FL | sub-OK 8720625 | Racy Point, St Johns River, FL | Not found 8720651 | Crescent Beach, Matanzas River, FL | sub-OK 8720757 | Bings Landing, Matanzas River, FL | Not found 8720767 | Buffalo Bluff, St Johns River, FL | sub-OK 8720774 | Palatka, St Johns River, FL | sub-OK 8720832 | Welaka, FL | sub-OK 8721020 | DAYTONA BEACH (OCEAN), FL | sub-OK 8721147 | Ponce De Leon Inlet South, FL | sub-OK 8721604 | Trident Pier, FL | OK 8721608 | CANAVERAL HARBOR ENTRANCE, FL | sub-OK 8722670 | Lake Worth Pier, FL | sub-OK 8723080 | HAULOVER PIER, N. MIAMI BEACH, FL | sub-OK 8723170 | Miami Beach, FL | sub-OK 8723178 | MIAMI BEACH, GOVERNMENT CUT, FL | OK 8723214 | Virginia Key, FL | sub-OK 8723962 | Key Colony Beach, FL | sub-OK 8723970 | Vaca Key, FL | OK 8724580 | Key West, FL | OK 8724698 | Loggerhead Key, FL | Not found 8725110 | Naples, FL | OK 8725520 | Fort Myers, FL | sub-OK 8726384 | Port Manatee, FL | sub-OK 8726520 | St. Petersburg, FL | OK 8726607 | Old Port Tampa, FL | sub-OK 8726667 | Mckay Bay Entrance, FL | sub-OK 8726724 | Clearwater Beach, FL | sub-OK 8727235 | JOHNS ISLAND, CHASSAHOWITZKA BAY, FL | sub-OK 8727246 | CHASSAHOWITZKA RIVER, FL | !!! sub poor match 8727274 | MASON CREEK, HOMOSASSA BAY, FL | sub-OK 8727277 | TUCKERS ISLAND, HOMOSASSA RIVER, FL | sub-OK 8727293 | HALLS RIVER BRIDGE, HALLS RIVER, FL | sub-OK 8727306 | OZELLO, FL | sub-OK 8727328 | OZELLO NORTH, FL | sub-OK 8727333 | Mangrove Point, FL | sub-OK 8727336 | DIXIE BAY, FL | sub-OK 8727343 | CRYSTAL RIVER, KINGS BAY, FL | sub-OK 8727348 | Twin Rivers Marina, FL | sub-OK 8727359 | SHELL ISLAND, CRYSTAL RIVER, FL | sub-OK 8727520 | Cedar Key, FL | OK 8728130 | ST. MARKS LHTSE., APALACHEE BAY, FL | OK 8728229 | SHELL POINT, WALKER CREEK, FL | sub-OK 8728360 | TURKEY POINT, FL | sub-OK 8728690 | Apalachicola, FL | OK 8729108 | Panama City, FL | sub-OK 8729210 | Panama City Beach, FL | sub-OK 8729678 | NAVARRE BEACH, FL | sub-OK 8729840 | Pensacola, FL | OK 8732828 | Weeks Bay, AL | Not found 8735180 | Dauphin Island, AL | OK 8735181 | Dauphin Island Hydro, AL | dup 8735180 8736897 | Coast Guard Sector Mobile, AL | Not found 8737048 | Mobile State Docks, AL | Not found 8737373 | Lower Bryant Landing, AL | Not found 8741196 | Pascagoula Point, MS | sub-OK 8741533 | Pascagoula NOAA Lab, MS | Not found 8742221 | Horn Island, MS | sub-OK 8743281 | Ocean Springs, MS | Not found 8744117 | Biloxi, MS | sub-OK 8745557 | Gulfport Harbor, MS | sub-OK 8747437 | Bay Waveland Yacht Club, MS | Not found 8747766 | Waveland, MS | sub-OK 8760551 | South Pass, LA | OK 8760922 | Pilots Station East, SW Pass, LA | Not found 8760943 | SW Pass, LA | sub-OK 8761720 | GRAND ISLE, LA | Not found 8761724 | Grand Isle, LA | OK 8761819 | TEXACO DOCK, HACKBERRY BAY, LA | Not found 8761927 | New Canal Station, LA | !!! sub poor match 8762075 | Port Fourchon, LA | Not found 8762372 | East Bank 1, Norco, B. LaBranche, LA | Not found 8762482 | West Bank 1, Bayou Gauche, LA | Not found 8764025 | Stouts Pass at Six Mile Lake, LA | Not found 8764044 | Tesoro Marine Terminal, LA | Not found 8764227 | LAWMA, Amerada Pass, LA | Not found 8764311 | Eugene Island, LA | !!! sub poor match 8765251 | Cypremort Point, LA | Not found 8766072 | Freshwater Canal Locks, LA | Not found 8767816 | Lake Charles, LA | Not found 8768094 | Calcasieu Pass, LA | sub-OK 8770475 | Port Arthur, TX | Not found 8770520 | Rainbow Bridge, TX | Not found 8770539 | Mesquite Point, TX | sub-OK 8770559 | Round Point, TX | !!! sub poor match 8770570 | Sabine Pass North, TX | sub-OK 8770597 | Orange, TX | Not found 8770613 | Morgans Point, TX | sub-OK 8770733 | Lynchburg Landing, TX | !!! sub poor match 8770743 | Battleship Texas State Park, TX | Not found 8770777 | Manchester, TX | !!! sub poor match 8770933 | Clear Lake, TX | !!! sub poor match 8770971 | Rollover Pass, TX | Not found 8771013 | Eagle Point, TX | sub-OK 8771081 | Sabine Offshore, TX | Not found 8771328 | Port Bolivar, TX | !!! sub poor match 8771341 | Galveston Bay Entrance, North Jetty, TX | Not found 8771450 | Galveston Pier 21, TX | Not found 8771510 | Galveston Pleasure Pier, TX | sub-OK 8772440 | Freeport, TX | sub-OK 8772447 | USCG Freeport, TX | sub-OK 8773037 | Seadrift, TX | Not found 8773259 | Port Lavaca, TX | Not found 8773701 | Port OConnor, TX | !!! poor match 8774513 | Copano Bay, TX | Not found 8774770 | Rockport, TX | Not found 8775188 | White Point, TX | Not found 8775237 | Port Aransas, TX | Not found 8775270 | PORT ARANSAS, H. CALDWELL PIER, TX | sub-OK 8775283 | Port Ingleside, Corpus Christi Bay, TX | Not found 8775296 | Texas State Aquarium, TX | Not found 8775421 | Naval Air Station, TX | Not found 8775792 | Packery Channel, TX | Not found 8775870 | Corpus Christi, TX | Not found 8779748 | South Padre Island C.G Station, TX | Not found 8779750 | PADRE ISLAND, BRAZOS SANTIAGO PASS, TX | OK 8779770 | Port Isabel, TX | sub-OK 9410170 | San Diego, CA | OK 9410230 | La Jolla, CA | sub-OK 9410580 | NEWPORT BEACH, NEWPORT BAY ENTRANCE, CA | sub-OK 9410660 | Los Angeles, CA | OK 9410680 | LONG BEACH, TERMINAL ISLAND, CA | sub-OK 9410840 | Santa Monica, CA | sub-OK 9411340 | Santa Barbara, CA | sub-OK 9411406 | Oil Platform Harvest, CA | Not found 9412110 | Port San Luis, CA | OK 9413450 | Monterey, CA | OK 9413616 | Moss Landing, CA | sub-OK 9413617 | Moss Landing Gen Fish Pier, CA | sub-OK 9413624 | ELKHORN SL., ACIFIC MARICULTURE DOCK, CA | sub-OK 9413626 | ELKHORN YACHT CLUB, ELKHORN SLOUGH, CA | sub-OK 9413631 | Elkhorn Slough at Elkhorn, CA | sub-OK 9413651 | Kirby Park, Elkhorn Slough, CA | sub-OK 9413663 | Elkhorn Slough Railroad Bridge, CA | sub-OK 9413745 | SANTA CRUZ, ONTEREY BAY, CA | sub-OK 9414290 | San Francisco, CA | OK 9414305 | NORTH POINT [PIER 41] S.F.BAY, CA | sub-OK 9414317 | PIER 22 1/2, SAN FRANCISCO, CA | sub-OK 9414358 | HUNTERS POINT, S.F. BAY, CA | sub-OK 9414392 | OYSTER POINT MARINA, SAN FRANCISCO BAY, CA | sub-OK 9414449 | COYOTE POINT MARINA, .F.BAY, CA | *** ^ Meridian is off by 8 hours so that -z matches tables in LST. 9414458 | San Mateo Bridge, CA | sub-OK 9414501 | REDWOOD CREEK, .M. NO. 8, .F.BAY, CA | sub-OK 9414509 | Dumbarton Bridge, CA | sub-OK 9414523 | Redwood City, CA | sub-OK 9414575 | Coyote Creek, CA | sub-OK 9414688 | San Leandro Marina, CA | sub-OK 9414750 | Alameda, CA | sub-OK 9414811 | Bradmoor Island, CA | sub-OK 9414863 | Richmond, CA | sub-OK 9415020 | Point Reyes, CA | sub-OK 9415144 | Port Chicago, CA | OK 9415218 | Mare Island, CA | sub-OK 9416841 | Arena Cove, CA | slight-OK 9418767 | North Spit, CA | OK 9419750 | Crescent City, CA | OK 9431647 | Port Orford, OR | sub-OK 9432780 | Charleston, OR | OK 9435380 | South Beach, OR | Not found 9435827 | DEPOE BAY, OR | sub-OK 9437540 | Garibaldi, OR | sub-OK 9439040 | Astoria, OR | slight-OK 9439099 | Wauna, OR | sub-OK 9439189 | Rocky Point, OR | Not found 9439201 | Saint Helens, OR | sub-OK 9439221 | Portland Morrison Street Bridge, OR | Not found 9440083 | Vancouver, WA | !!! sub poor match 9440422 | Longview, WA | sub-OK 9440569 | Skamokawa, WA | sub-OK 9440747 | NAHCOTTA, WILLAPA BAY, WA | sub-OK 9440875 | SOUTH BEND, WA | sub-OK 9440910 | Toke Point, WA | OK 9441102 | Westport, WA | sub-OK 9441187 | Aberdeen, WA | OK 9442396 | La Push, WA | sub-OK 9443090 | Neah Bay, WA | OK 9444090 | Port Angeles, WA | sub-OK 9444900 | Port Townsend, WA | OK 9445133 | Bangor, WA | sub-OK 9446484 | Tacoma, WA | sub-OK 9447130 | Seattle, WA | OK 9449424 | Cherry Point, WA | OK 9449880 | Friday Harbor, WA | sub-OK 9450460 | Ketchikan, AK | OK 9450970 | Thoms Point, AK | sub-OK 9451054 | Port Alexander, AK | sub-OK 9451434 | Turn Point, AK | Not found 9451438 | Entrance Island, AK | sub-OK 9451600 | Sitka, AK | OK 9452210 | Juneau, AK | OK 9452400 | Skagway, AK | sub-OK 9452634 | Elfin Cove, AK | Not found 9453220 | Yakutat, AK | sub-OK 9454050 | Cordova, AK | OK 9454240 | Valdez, AK | OK 9454562 | Wooded Island, AK | sub-OK 9454571 | STOREY ISLAND NORTH SIDE, AK | Not found 9454721 | PERRY ISLAND (SOUTH BAY), AK | Not found 9455090 | Seward, AK | sub-OK 9455500 | Seldovia, AK | OK 9455760 | Nikiski, AK | OK 9455920 | Anchorage, AK | !!! ^ Different from published tables but still plausible (within tolerances for sub) 9457292 | Kodiak Island, AK | OK 9457804 | Alitak, AK | sub-OK 9458293 | Chirikof Island, AK | Not found 9458665 | WEST END, SUTWIK ISLAND, AK | Not found 9459016 | Mitrofania Island, AK | Not found 9459450 | Sand Point, AK | OK 9459758 | Dolgoi Harbor, Dolgoi Island, AK | sub-OK 9459881 | King Cove, AK | sub-OK 9460150 | ATTU, MASSACRE BAY, AK | ??? ^ NOS uses UTC+12 for LST; HAST (since 1983) is UTC-10. 9461380 | Adak Island, AK | OK 9461710 | Atka, AK | Not found 9462450 | Nikolski, AK | Not found 9462620 | Unalaska, AK | OK 9463502 | Port Moller, AK | sub-OK 9464212 | Village Cove, St. Paul Island, AK | sub-OK 9465234 | NORTH END, HAGEMEISTER ISLAND, AK | Not found 9465249 | ESTUS POINT, HAGEMEISTER STRAIT, AK | Not found 9465261 | CLARKS POINT, NUSHAGAK BAY, AK | ??? ^ NOS uses UTC-11 for LST; AKST (since 1983) is UTC-9. 9465374 | Snag Point, Dillingham, AK | sub-OK 9468132 | ST. MICHAEL, NORTON SOUND, AK | ??? ^ NOS uses UTC-11 for LST; AKST (since 1983) is UTC-9. 9468756 | Nome, Norton Sound, AK | OK 9469439 | Tin City, Bering Sea, AK | Not found 9469854 | Shishmaref Inlet 2, AK | Not found 9490424 | Kotzebue, AK | Not found 9491094 | Red Dog Dock, AK | Not found 9491253 | Kivalina, AK | Not found 9497645 | Prudhoe Bay, AK | slight-OK 9497649 | PRUDHOE BAY 2, AK | Not found 9497778 | CROSS ISLAND, (DINKUM SANDS), AK | Not found 9751364 | Christiansted Harbor, St Croix, VI | !!! sub poor match 9751381 | Lameshur Bay, St. Johns, VI | Not found 9751401 | Lime Tree Bay, VI | OK 9751567 | BENNER BAY, | Not found 9751639 | Charlotte Amalie, VI | OK 9752235 | Culebra, PR | Not found 9752695 | Vieques Island, PR | Not found 9755371 | San Juan, PR | OK 9755679 | Las Mareas, PR | Not found 9758053 | Punta Guayanilla, PR | Not found 9759110 | Magueyes Island, PR | OK 9759412 | Aguadilla, PR | Not found 9759938 | Mona Island, PR | Not found Errata from previous year: update data_sets set meridian = '-08:00', comments = comments || E'Corrected meridian (data claimed UTC, was UTC-8)\n' where original_name = 'Coyote Point Marina, .F.bay, CA'; update data_sets set meridian = '-05:00', comments = comments || E'Corrected meridian (data claimed UTC, was UTC-5)\n' where original_name = 'Albany, Hudson River, NY'; update data_sets set lng = -80.0217, comments = comments || E'Corrected longitude (was -79.0217)\n' where original_name = 'Ashley River, I-526 bridge'; The last one is no longer needed; the coordinates have been corrected upstream. The other two original_names have been case-smashed. Footnotes in active use, with examples: ec7 tab2ec2a.html Essex ec8 tab2ec2a.html Spuyten Duyvil Creek ent., N.Y. wc4 tab2wc1a.html New Hope Bridge wc5 tab2wc1b.html Skamokawa, Steamboat Slough, Wash. wc7 tab2wc1b.html Stanwood, Stillaguamish River wc8 tab2wc1b.html La Conner, Swinomish Channel wc9 tab2wc2a.html Haystack Island, B.C. wc11 tab2wc2b.html Sunrise, Turnagain Arm wc13 tab2wc2c.html [Naknek River] Entrance wc18 tab2wc1a.html Elk River Railroad Bridge Footnotes are unchanged from last year. Command sequence: import -C1 -sd 2007-12-17 NOS station_list.html > importRefLog.txt psql harmbase2 < errata.sql (Verify errata fixed) fixup_datums cd tab2 import -C1 -sd 2007-12-17 NOSS tab2*.html > ../importSubLog.txt cd .. rename < renamings-USA.txt