noaa_stations_map (view)
208 rows sorted by geoGroupName
This data as json, CSV (advanced)
rowid | stationId | latitude | longitude | refStationId | stationType | parentGeoGroupId | seq | geoGroupId | geoGroupName ▼ | level | geoGroupType | abbrev | good |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135 | 9415402 | 38.1867 | -121.98 | 9415144 | S | 1454 | 5 | Montezuma Slough Bridge | 2 | 0 | |||
48 | 9413616 | 36.8017 | -121.79 | 9413450 | S | 1676 | 2 | Moss Landing, Ocean Pier | 3 | 0 | |||
103 | 9414519 | 37.4933 | -122.042 | 9414290 | S | 1451 | 41 | Mowry Slough | 2 | 0 | |||
26 | TWC0445 | 34.1 | -119.1 | 9410660 | S | 1448 | 0 | Mugu Lagoon (ocean pier) | 2 | 0 | |||
191 | 9417426 | 39.42577777777778 | -123.8051111111111 | R | 1450 | 12 | NOYO HARBOR | 2 | 1 | ||||
125 | 9415623 | 38.2983 | -122.28 | 9414290 | S | 1453 | 4 | Napa, Napa River | 2 | 0 | |||
8 | 9410152 | 32.665 | -117.118 | 9410170 | S | 1751 | 4 | National City, San Diego Bay | 2 | 0 | |||
151 | 9415478 | 38.2267 | -121.49 | 9415144 | S | 1677 | 2 | New Hope Bridge | 3 | 0 | |||
99 | 9414506 | 37.5133 | -122.08 | 9414290 | S | 1451 | 37 | Newark Slough | 2 | 0 | |||
14 | 9410580 | 33.6033 | -117.883 | R | 1447 | 0 | Newport Bay Entrance, Corona del Mar | 2 | 1 | ||||
77 | 9414711 | 37.7317 | -122.208 | 9414290 | S | 1451 | 15 | Oakland Airport | 2 | 0 | |||
74 | 9414763 | 37.795 | -122.283 | 9414290 | S | 1451 | 12 | Oakland Harbor, Grove Street | 2 | 0 | |||
75 | 9414746 | 37.7717 | -122.235 | R | 1451 | 13 | Oakland Harbor, Park Street Bridge | 2 | 1 | ||||
71 | 9414764 | 37.795 | -122.282 | R | 1451 | 9 | Oakland Inner Harbor | 2 | 1 | ||||
69 | 9414777 | 37.805 | -122.338 | 9414290 | S | 1451 | 7 | Oakland Middle Harbor | 2 | 0 | |||
70 | 9414765 | 37.795 | -122.33 | 9414290 | S | 1451 | 8 | Oakland Pier | 2 | 0 | |||
68 | 9414779 | 37.81 | -122.327 | 9414290 | S | 1451 | 6 | Oakland, Matson Wharf | 2 | 0 | |||
61 | 9414275 | 37.775 | -122.513 | 9414290 | S | 1457 | 10 | Ocean Beach, outer coast | 2 | 0 | |||
32 | 9411406 | 34.46916666666667 | -120.6819444444444 | R | 1448 | 6 | Oil Platform Harvest | 2 | 1 | ||||
156 | 9414868 | 37.9383 | -121.56 | 9415144 | S | 1455 | 12 | Orwood, Old River | 2 | 0 | |||
83 | 9414392 | 37.665 | -122.377 | 9414290 | S | 1451 | 21 | Oyster Point Marina | 2 | 0 | |||
134 | 9415144 | 38.056 | -122.0395 | R | 1454 | 4 | PORT CHICAGO, SUISUN BAY | 2 | 1 | ||||
42 | 9412110 | 35.176700592041016 | -120.76000213623047 | R | 1457 | 1 | PORT SAN LUIS | 2 | 1 | ||||
51 | 9413624 | 36.8133 | -121.758 | 9413450 | S | 1676 | 5 | Pacific Mariculture Dock | 3 | 0 | |||
102 | 9414525 | 37.4583 | -122.105 | 9414290 | S | 1451 | 40 | Palo Alto Yacht Harbor | 2 | 0 | |||
172 | 9415252 | 38.11530555555556 | -122.5056666666667 | 9414290 | S | 1452 | 3 | Petaluma River entrance | 2 | 0 | |||
131 | 9415266 | 38.1267 | -122.1 | 9415144 | S | 1454 | 1 | Pierce Harbor, Goodyear Slough | 2 | 0 | |||
58 | 9414131 | 37.5025 | -122.4821666666667 | R | 1457 | 7 | Pillar Point Harbor, Half Moon Bay | 2 | 1 | ||||
170 | 9415056 | 38.015 | -122.363 | R | 1452 | 1 | Pinole Point | 2 | 1 | ||||
141 | 9415096 | 38.0367 | -121.88 | 9415144 | S | 1454 | 11 | Pittsburg, New York Slough | 2 | 0 | |||
190 | TWC0771 | 38.95 | -123.73333333333005 | 9416841 | S | 1450 | 11 | Point Arena | 2 | 0 | |||
41 | TWC0473 | 34.583333333332995 | -120.65 | 9412110 | S | 1457 | 0 | Point Arguello | 2 | 0 | |||
62 | 9414906 | 37.8183 | -122.528 | 9414290 | S | 1451 | 0 | Point Bonita, Bonita Cove | 2 | 0 | |||
139 | 9415227 | 38.1 | -122.033 | 9415144 | S | 1454 | 9 | Point Buckler | 2 | 0 | |||
113 | 9414837 | 37.8917 | -122.443 | 9414290 | S | 1451 | 51 | Point Chauncey | 2 | 0 | |||
115 | 9414843 | 37.8983 | -122.32 | 9414290 | S | 1451 | 53 | Point Isabel | 2 | 0 | |||
5 | TWC0405 | 32.666666666667005 | -117.23333333333005 | 9410170 | S | 1751 | 1 | Point Loma | 2 | 0 | |||
118 | 9414881 | 37.9583 | -122.425 | 9414290 | S | 1451 | 56 | Point Orient | 2 | 0 | |||
180 | 9415020 | 37.9941667 | -122.9736111 | R | 1450 | 1 | Point Reyes | 2 | 1 | ||||
84 | 9414402 | 37.65 | -122.377 | 9414290 | S | 1451 | 22 | Point San Bruno | 2 | 0 | |||
169 | 9415009 | 37.9933 | -122.447 | 9414290 | S | 1452 | 0 | Point San Pedro | 2 | 0 | |||
120 | 9414873 | 37.945 | -122.475 | 9414290 | S | 1451 | 58 | Point San Quentin | 2 | 0 | |||
27 | 9411065 | 34.1483 | -119.203 | 9410660 | S | 1448 | 1 | Port Hueneme | 2 | 0 | |||
78 | 9414334 | 37.7583 | -122.383 | 9414290 | S | 1451 | 16 | Potrero Point | 2 | 0 | |||
38 | 9410971 | 34.02 | -119.683 | 9410660 | S | 1449 | 5 | Prisoners Harbor, Santa Cruz Island | 2 | 0 | |||
145 | 9415149 | 38.0617 | -121.555 | 9415144 | S | 1455 | 3 | Prisoners Point | 2 | 0 | |||
208 | 9419945 | 41.94525 | -124.2009166666667 | R | 1450 | 21 | Pyramid Point, Smith River | 2 | 1 | ||||
10 | TWC0413 | 32.76666666666701 | -117.23333333333005 | 9410170 | S | 1751 | 6 | Quivira Basin, Mission Bay | 2 | 0 | |||
96 | 9414523 | 37.50681388888889 | -122.2119055555556 | R | 1451 | 34 | Redwood City, Wharf 5 | 2 | 1 | ||||
93 | 9414501 | 37.5333 | -122.193 | 9414290 | S | 1451 | 31 | Redwood Creek Marker 8 | 2 | 0 | |||
184 | 9415320 | 38.1467 | -122.883 | 9414290 | S | 1450 | 5 | Reynolds, Tomales Bay | 2 | 0 | |||
116 | 9414849 | 37.91 | -122.358 | 9414290 | S | 1451 | 54 | Richmond Inner Harbor | 2 | 0 | |||
29 | 9411270 | 34.3483 | -119.443 | 9410660 | S | 1448 | 3 | Rincon Island, Mussel Shoals | 2 | 0 | |||
66 | 9414317 | 37.79 | -122.387 | R | 1451 | 4 | Rincon Point, Pier 22 1/2 | 2 | 1 | ||||
164 | 9415316 | 38.145 | -121.692 | R | 1456 | 2 | Rio Vista | 2 | 1 | ||||
81 | TWC0547 | 37.666666666667005 | -122.2 | 9414290 | S | 1451 | 19 | Roberts Landing, 1.3 miles west of | 2 | 0 | |||
7 | 9410170 | 32.71555555555555 | -117.1766666666667 | R | 1751 | 3 | SAN DIEGO (Broadway) | 2 | 1 | ||||
63 | 9414290 | 37.80630555555555 | -122.4658888888889 | R | 1451 | 1 | SAN FRANCISCO (Golden Gate) | 2 | 1 | ||||
168 | 9416174 | 38.58 | -121.507 | 9415144 | S | 1456 | 6 | Sacramento | 2 | 0 | |||
203 | 9418817 | 40.8267 | -124.18 | R | 1678 | 7 | Samoa | 3 | 1 | ||||
1 | TWC0399 | 24.78333333333299 | -112.11666666666996 | 9410170 | S | 1446 | 0 | San Carlos | 2 | 0 | |||
13 | TWC0419 | 33.416666666667005 | -117.61666666666996 | 9410170 | S | 1751 | 9 | San Clemente | 2 | 0 | |||
6 | 9410166 | 32.7033 | -117.235 | 9410170 | S | 1751 | 2 | San Diego, Quarantine Station | 2 | 0 | |||
60 | TWC0509 | 37.76666666666701 | -122.63333333333004 | 9414290 | S | 1457 | 9 | San Francisco Bar | 2 | 0 | |||
65 | 9414305 | 37.81 | -122.413 | 9414290 | S | 1451 | 3 | San Francisco, North Point, Pier 41 | 2 | 0 | |||
76 | 9414724 | 37.7483 | -122.235 | 9414290 | S | 1451 | 14 | San Leandro Channel, San Leandro Bay | 2 | 0 | |||
80 | 9414688 | 37.695 | -122.192 | R | 1451 | 18 | San Leandro Marina | 2 | 1 | ||||
88 | 9414637 | 37.6083 | -122.182 | 9414290 | S | 1451 | 26 | San Mateo Bridge (east end) | 2 | 0 | |||
87 | 9414458 | 37.58 | -122.253 | R | 1451 | 25 | San Mateo Bridge (west end) | 2 | 1 | ||||
37 | 9410068 | 33.2667 | -119.497 | 9410660 | S | 1449 | 4 | San Nicolas Island | 2 | 0 | |||
43 | 9412553 | 35.6417 | -121.188 | 9412110 | S | 1457 | 2 | San Simeon | 2 | 0 | |||
16 | 9410599 | 33.63 | -117.958 | 9410660 | S | 1447 | 2 | Santa Ana River entrance (inside) | 2 | 0 | |||
30 | 9411340 | 34.40458888888889 | -119.6924944444445 | R | 1448 | 4 | Santa Barbara | 2 | 1 | ||||
36 | TWC0463 | 33.48333333333299 | -119.03333333333005 | 9410660 | S | 1449 | 3 | Santa Barbara Island | 2 | 0 | |||
56 | 9413745 | 36.9583 | -122.017 | 9413450 | S | 1676 | 10 | Santa Cruz, Monterey Bay | 3 | 0 | |||
25 | 9410840 | 34.0083 | -118.5 | R | 1447 | 11 | Santa Monica, Municipal Pier | 2 | 1 | ||||
109 | 9414806 | 37.8467 | -122.477 | 9414290 | S | 1451 | 47 | Sausalito | 2 | 0 | |||
110 | 9414819 | 37.865 | -122.493 | 9414290 | S | 1451 | 48 | Sausalito, Corps of Engineers Dock | 2 | 0 | |||
85 | 9414413 | 37.6367 | -122.383 | 9414290 | S | 1451 | 23 | Seaplane Harbor | 2 | 0 | |||
126 | 9415142 | 38.0583 | -122.243 | 9414290 | S | 1453 | 5 | Selby | 2 | 0 | |||
194 | 9418024 | 40.025001525878906 | -124.05799865722656 | R | 1450 | 16 | Shelter Cove | 2 | 1 | ||||
98 | 9414511 | 37.5017 | -122.223 | 9414290 | S | 1451 | 36 | Smith Slough | 2 | 0 | |||
166 | 9415565 | 38.2767 | -121.495 | 9415144 | S | 1456 | 4 | Snodgrass Slough | 2 | 0 | |||
177 | 9415338 | 38.1567 | -122.407 | R | 1452 | 8 | Sonoma Creek | 2 | 1 | ||||
94 | 9414609 | 37.5517 | -122.162 | 9414290 | S | 1451 | 32 | South Bay Wreck | 2 | 0 | |||
9 | 9410135 | 32.62910079956055 | -117.10780334472656 | R | 1751 | 5 | South San Diego Bay | 2 | 1 | ||||
82 | 9414391 | 37.6667 | -122.39 | 9414290 | S | 1451 | 20 | South San Francisco | 2 | 0 | |||
59 | 9414262 | 37.7 | -123.0 | 9414290 | S | 1457 | 8 | Southeast Farallon Island | 2 | 0 | |||
165 | 9415414 | 38.1833 | -121.655 | 9415144 | S | 1456 | 3 | Steamboat Slough, Snug Harbor Marina | 2 | 0 | |||
148 | 9414883 | 37.9583 | -121.29 | 9415144 | S | 1455 | 6 | Stockton | 2 | 0 | |||
133 | 9415498 | 38.2367 | -122.03 | 9415144 | S | 1454 | 3 | Suisun City, Suisun Slough | 2 | 0 | |||
130 | 9415265 | 38.1283 | -122.073 | R | 1454 | 0 | Suisun Slough entrance | 2 | 1 | ||||
150 | 9415257 | 38.11 | -121.498 | 9415144 | S | 1677 | 1 | Terminous, South Fork | 3 | 0 | |||
163 | 9415236 | 38.1067 | -121.7 | 9415144 | S | 1456 | 1 | Threemile Slough | 2 | 0 | |||
143 | 9415193 | 38.086700439453125 | -121.68499755859375 | R | 1455 | 1 | Threemile Slough entrance | 2 | 0 | ||||
53 | 9413643 | 36.83330154418945 | -121.74500274658203 | R | 1676 | 7 | Tidal Creek, Elkhorn Slough | 3 | 1 | ||||
181 | 9415469 | 38.2283 | -122.977 | 9414290 | S | 1450 | 2 | Tomales Bay entrance | 2 | 0 | |||
206 | 9419059 | 41.0567 | -124.147 | 9419750 | S | 1450 | 19 | Trinidad Harbor | 2 | 0 | |||
105 | 9414549 | 37.435 | -122.007 | 9414290 | S | 1451 | 43 | Upper Guadalupe Slough | 2 | 0 | |||
174 | 9415584 | 38.2283 | -122.613 | 9414290 | S | 1452 | 5 | Upper drawbridge, Petaluma River | 2 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW noaa_stations_map AS select rowid, stationId, lat as latitude, lon as longitude, refStationId, stationType, parentGeoGroupId, seq, geoGroupId, geoGroupName, level, geoGroupType, abbrev, good from noaa_stations;