noaa_stations
208 rows sorted by good
This data as json, CSV (advanced)
Suggested facets: refStationId, stationType, parentGeoGroupId, level, good
stationId | lat | lon | refStationId | stationType | parentGeoGroupId | seq | geoGroupId | geoGroupName | level | geoGroupType | abbrev | good ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
TWC0399 | 24.78333333333299 | -112.11666666666996 | 9410170 | S | 1446 | 0 | San Carlos | 2 | 0 | |||
TWC0401 | 28.883333333332992 | -116.3 | 9410170 | S | 1446 | 1 | Isla Guadalupe | 2 | 0 | |||
TWC0403 | 31.85 | -116.63333333333004 | 9410170 | S | 1446 | 2 | Ensenada, Todos Santos Bay | 2 | 0 | |||
9410120 | 32.5783 | -117.135 | 9410170 | S | 1751 | 0 | Imperial Beach | 2 | 0 | |||
TWC0405 | 32.666666666667005 | -117.23333333333005 | 9410170 | S | 1751 | 1 | Point Loma | 2 | 0 | |||
9410166 | 32.7033 | -117.235 | 9410170 | S | 1751 | 2 | San Diego, Quarantine Station | 2 | 0 | |||
9410152 | 32.665 | -117.118 | 9410170 | S | 1751 | 4 | National City, San Diego Bay | 2 | 0 | |||
TWC0413 | 32.76666666666701 | -117.23333333333005 | 9410170 | S | 1751 | 6 | Quivira Basin, Mission Bay | 2 | 0 | |||
TWC0419 | 33.416666666667005 | -117.61666666666996 | 9410170 | S | 1751 | 9 | San Clemente | 2 | 0 | |||
9410583 | 33.6 | -117.9 | 9410660 | S | 1447 | 1 | Balboa Pier, Newport Beach | 2 | 0 | |||
9410599 | 33.63 | -117.958 | 9410660 | S | 1447 | 2 | Santa Ana River entrance (inside) | 2 | 0 | |||
TWC0427 | 33.71666666666701 | -118.05 | 9410660 | S | 1447 | 3 | Los Patos (highway bridge) | 2 | 0 | |||
9410686 | 33.7717 | -118.21 | 9410660 | S | 1447 | 5 | Long Beach, Inner Harbor | 2 | 0 | |||
9410650 | 33.7067 | -118.273 | 9410660 | S | 1447 | 6 | Cabrillo Beach | 2 | 0 | |||
TWC0439 | 33.75 | -118.26666666666995 | 9410660 | S | 1447 | 8 | Los Angeles Harbor, Mormon Island | 2 | 0 | |||
9410738 | 33.8467 | -118.398 | 9410660 | S | 1447 | 9 | King Harbor, Santa Monica Bay | 2 | 0 | |||
9410777 | 33.9083 | -118.433 | 9410660 | S | 1447 | 10 | El Segundo, Santa Monica Bay | 2 | 0 | |||
TWC0445 | 34.1 | -119.1 | 9410660 | S | 1448 | 0 | Mugu Lagoon (ocean pier) | 2 | 0 | |||
9411065 | 34.1483 | -119.203 | 9410660 | S | 1448 | 1 | Port Hueneme | 2 | 0 | |||
9411189 | 34.2667 | -119.283 | 9410660 | S | 1448 | 2 | Ventura | 2 | 0 | |||
9411270 | 34.3483 | -119.443 | 9410660 | S | 1448 | 3 | Rincon Island, Mussel Shoals | 2 | 0 | |||
9410092 | 33.4317 | -118.503 | 9410660 | S | 1449 | 1 | Catalina Harbor, Santa Catalina Island | 2 | 0 | |||
TWC0463 | 33.48333333333299 | -119.03333333333005 | 9410660 | S | 1449 | 3 | Santa Barbara Island | 2 | 0 | |||
9410068 | 33.2667 | -119.497 | 9410660 | S | 1449 | 4 | San Nicolas Island | 2 | 0 | |||
9410971 | 34.02 | -119.683 | 9410660 | S | 1449 | 5 | Prisoners Harbor, Santa Cruz Island | 2 | 0 | |||
9410962 | 34.0083 | -120.047 | 9410660 | S | 1449 | 6 | Bechers Bay, Santa Rosa Island | 2 | 0 | |||
9410988 | 34.0567 | -120.355 | 9410660 | S | 1449 | 7 | Cuyler Harbor, San Miguel Island | 2 | 0 | |||
TWC0473 | 34.583333333332995 | -120.65 | 9412110 | S | 1457 | 0 | Point Arguello | 2 | 0 | |||
9412553 | 35.6417 | -121.188 | 9412110 | S | 1457 | 2 | San Simeon | 2 | 0 | |||
9413375 | 36.52 | -121.94 | 9413450 | S | 1457 | 4 | Carmel Cove, Carmel Bay | 2 | 0 | |||
9413617 | 36.8017 | -121.787 | 9413450 | S | 1676 | 1 | General Fish Company Pier | 3 | 0 | |||
9413616 | 36.8017 | -121.79 | 9413450 | S | 1676 | 2 | Moss Landing, Ocean Pier | 3 | 0 | |||
9413626 | 36.8133 | -121.787 | 9413450 | S | 1676 | 3 | Elkhorn Yacht Club | 3 | 0 | |||
9413623 | 36.81 | -121.785 | 9413450 | S | 1676 | 4 | Elkhorn Slough, Highway 1 Bridge | 3 | 0 | |||
9413624 | 36.8133 | -121.758 | 9413450 | S | 1676 | 5 | Pacific Mariculture Dock | 3 | 0 | |||
9413745 | 36.9583 | -122.017 | 9413450 | S | 1676 | 10 | Santa Cruz, Monterey Bay | 3 | 0 | |||
9413878 | 37.1083 | -122.338 | 9414290 | S | 1457 | 6 | Ano Nuevo Island | 2 | 0 | |||
9414262 | 37.7 | -123.0 | 9414290 | S | 1457 | 8 | Southeast Farallon Island | 2 | 0 | |||
TWC0509 | 37.76666666666701 | -122.63333333333004 | 9414290 | S | 1457 | 9 | San Francisco Bar | 2 | 0 | |||
9414275 | 37.775 | -122.513 | 9414290 | S | 1457 | 10 | Ocean Beach, outer coast | 2 | 0 | |||
9414906 | 37.8183 | -122.528 | 9414290 | S | 1451 | 0 | Point Bonita, Bonita Cove | 2 | 0 | |||
9414792 | 37.8267 | -122.417 | 9414290 | S | 1451 | 2 | Alcatraz Island | 2 | 0 | |||
9414305 | 37.81 | -122.413 | 9414290 | S | 1451 | 3 | San Francisco, North Point, Pier 41 | 2 | 0 | |||
9414782 | 37.81 | -122.36 | 9414290 | S | 1451 | 5 | Yerba Buena Island | 2 | 0 | |||
9414779 | 37.81 | -122.327 | 9414290 | S | 1451 | 6 | Oakland, Matson Wharf | 2 | 0 | |||
9414777 | 37.805 | -122.338 | 9414290 | S | 1451 | 7 | Oakland Middle Harbor | 2 | 0 | |||
9414765 | 37.795 | -122.33 | 9414290 | S | 1451 | 8 | Oakland Pier | 2 | 0 | |||
9414767 | 37.7933 | -122.315 | 9414290 | S | 1451 | 10 | Alameda Naval Air Station | 2 | 0 | |||
9414763 | 37.795 | -122.283 | 9414290 | S | 1451 | 12 | Oakland Harbor, Grove Street | 2 | 0 | |||
9414724 | 37.7483 | -122.235 | 9414290 | S | 1451 | 14 | San Leandro Channel, San Leandro Bay | 2 | 0 | |||
9414711 | 37.7317 | -122.208 | 9414290 | S | 1451 | 15 | Oakland Airport | 2 | 0 | |||
9414334 | 37.7583 | -122.383 | 9414290 | S | 1451 | 16 | Potrero Point | 2 | 0 | |||
TWC0547 | 37.666666666667005 | -122.2 | 9414290 | S | 1451 | 19 | Roberts Landing, 1.3 miles west of | 2 | 0 | |||
9414391 | 37.6667 | -122.39 | 9414290 | S | 1451 | 20 | South San Francisco | 2 | 0 | |||
9414392 | 37.665 | -122.377 | 9414290 | S | 1451 | 21 | Oyster Point Marina | 2 | 0 | |||
9414402 | 37.65 | -122.377 | 9414290 | S | 1451 | 22 | Point San Bruno | 2 | 0 | |||
9414413 | 37.6367 | -122.383 | 9414290 | S | 1451 | 23 | Seaplane Harbor | 2 | 0 | |||
9414449 | 37.5917 | -122.313 | 9414290 | S | 1451 | 24 | Coyote Point Marina | 2 | 0 | |||
9414637 | 37.6083 | -122.182 | 9414290 | S | 1451 | 26 | San Mateo Bridge (east end) | 2 | 0 | |||
9414632 | 37.595 | -122.145 | 9414290 | S | 1451 | 27 | Alameda Creek | 2 | 0 | |||
9414621 | 37.5633 | -122.128 | 9414290 | S | 1451 | 28 | Coyote Hills Slough entrance | 2 | 0 | |||
9414483 | 37.5517 | -122.243 | 9414290 | S | 1451 | 29 | Bay Slough, west end | 2 | 0 | |||
9414486 | 37.545 | -122.222 | 9414290 | S | 1451 | 30 | Bay Slough, east end | 2 | 0 | |||
9414501 | 37.5333 | -122.193 | 9414290 | S | 1451 | 31 | Redwood Creek Marker 8 | 2 | 0 | |||
9414609 | 37.5517 | -122.162 | 9414290 | S | 1451 | 32 | South Bay Wreck | 2 | 0 | |||
9414505 | 37.5083 | -122.21 | 9414290 | S | 1451 | 33 | Corkscrew Slough | 2 | 0 | |||
9414507 | 37.505 | -122.192 | 9414290 | S | 1451 | 35 | West Point Slough | 2 | 0 | |||
9414511 | 37.5017 | -122.223 | 9414290 | S | 1451 | 36 | Smith Slough | 2 | 0 | |||
9414506 | 37.5133 | -122.08 | 9414290 | S | 1451 | 37 | Newark Slough | 2 | 0 | |||
9414513 | 37.495 | -122.213 | 9414290 | S | 1451 | 39 | Granite Rock, Redwood Creek | 2 | 0 | |||
9414525 | 37.4583 | -122.105 | 9414290 | S | 1451 | 40 | Palo Alto Yacht Harbor | 2 | 0 | |||
9414519 | 37.4933 | -122.042 | 9414290 | S | 1451 | 41 | Mowry Slough | 2 | 0 | |||
9414539 | 37.4667 | -122.067 | 9414290 | S | 1451 | 42 | Calaveras Point, west of | 2 | 0 | |||
9414549 | 37.435 | -122.007 | 9414290 | S | 1451 | 43 | Upper Guadalupe Slough | 2 | 0 | |||
9414551 | 37.4233 | -121.975 | 9414290 | S | 1451 | 45 | Gold Street Bridge, Alviso Slough | 2 | 0 | |||
9414561 | 37.4467 | -121.963 | 9414290 | S | 1451 | 46 | Coyote Creek, Tributary no.1 | 2 | 0 | |||
9414806 | 37.8467 | -122.477 | 9414290 | S | 1451 | 47 | Sausalito | 2 | 0 | |||
9414819 | 37.865 | -122.493 | 9414290 | S | 1451 | 48 | Sausalito, Corps of Engineers Dock | 2 | 0 | |||
9414817 | 37.86 | -122.443 | 9414290 | S | 1451 | 49 | Angel Island (west side) | 2 | 0 | |||
9414818 | 37.8633 | -122.42 | 9414290 | S | 1451 | 50 | Angel Island, East Garrison | 2 | 0 | |||
9414837 | 37.8917 | -122.443 | 9414290 | S | 1451 | 51 | Point Chauncey | 2 | 0 | |||
9414843 | 37.8983 | -122.32 | 9414290 | S | 1451 | 53 | Point Isabel | 2 | 0 | |||
9414849 | 37.91 | -122.358 | 9414290 | S | 1451 | 54 | Richmond Inner Harbor | 2 | 0 | |||
9414881 | 37.9583 | -122.425 | 9414290 | S | 1451 | 56 | Point Orient | 2 | 0 | |||
9414874 | 37.94329833984375 | -122.51300048828125 | R | 1451 | 57 | Corte Madera Creek | 2 | 0 | ||||
9414873 | 37.945 | -122.475 | 9414290 | S | 1451 | 58 | Point San Quentin | 2 | 0 | |||
9415165 | 38.1117 | -122.273 | 9414290 | S | 1453 | 1 | Vallejo, Mare Island Strait | 2 | 0 | |||
9415415 | 38.1917 | -122.312 | 9414290 | S | 1453 | 2 | Edgerley Island, Napa River | 2 | 0 | |||
9415446 | 38.21 | -122.307 | 9414290 | S | 1453 | 3 | Brazos Drawbridge, Napa River | 2 | 0 | |||
9415623 | 38.2983 | -122.28 | 9414290 | S | 1453 | 4 | Napa, Napa River | 2 | 0 | |||
9415142 | 38.0583 | -122.243 | 9414290 | S | 1453 | 5 | Selby | 2 | 0 | |||
9415111 | 38.0433 | -122.13 | 9415144 | S | 1453 | 7 | Benicia | 2 | 0 | |||
9415266 | 38.1267 | -122.1 | 9415144 | S | 1454 | 1 | Pierce Harbor, Goodyear Slough | 2 | 0 | |||
9415379 | 38.18 | -122.045 | 9415144 | S | 1454 | 2 | Joice Island, Suisun Slough | 2 | 0 | |||
9415498 | 38.2367 | -122.03 | 9415144 | S | 1454 | 3 | Suisun City, Suisun Slough | 2 | 0 | |||
9415402 | 38.1867 | -121.98 | 9415144 | S | 1454 | 5 | Montezuma Slough Bridge | 2 | 0 | |||
9415307 | 38.1367 | -121.907 | 9415144 | S | 1454 | 7 | Meins Landing, Montezuma Slough | 2 | 0 | |||
9415205 | 38.0767 | -121.885 | 9415144 | S | 1454 | 8 | Montezuma Slough | 2 | 0 | |||
9415227 | 38.1 | -122.033 | 9415144 | S | 1454 | 9 | Point Buckler | 2 | 0 | |||
9415096 | 38.0367 | -121.88 | 9415144 | S | 1454 | 11 | Pittsburg, New York Slough | 2 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [noaa_stations] ( [stationId] TEXT PRIMARY KEY, [lat] FLOAT, [lon] FLOAT, [refStationId] TEXT, [stationType] TEXT, [parentGeoGroupId] TEXT, [seq] TEXT, [geoGroupId] TEXT, [geoGroupName] TEXT, [level] TEXT, [geoGroupType] TEXT, [abbrev] TEXT , [good] INTEGER);