noaa_stations_map (view)
208 rows sorted by seq
This data as json, CSV (advanced)
Suggested facets: refStationId, stationType, parentGeoGroupId, level, good
rowid | stationId | latitude | longitude | refStationId | stationType | parentGeoGroupId | seq ▼ | geoGroupId | geoGroupName | level | geoGroupType | abbrev | good |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | TWC0399 | 24.78333333333299 | -112.11666666666996 | 9410170 | S | 1446 | 0 | San Carlos | 2 | 0 | |||
4 | 9410120 | 32.5783 | -117.135 | 9410170 | S | 1751 | 0 | Imperial Beach | 2 | 0 | |||
14 | 9410580 | 33.6033 | -117.883 | R | 1447 | 0 | Newport Bay Entrance, Corona del Mar | 2 | 1 | ||||
26 | TWC0445 | 34.1 | -119.1 | 9410660 | S | 1448 | 0 | Mugu Lagoon (ocean pier) | 2 | 0 | |||
33 | 9410032 | 33.005001068115234 | -118.55699920654297 | R | 1449 | 0 | Wilson Cove, San Clemente Island | 2 | 1 | ||||
41 | TWC0473 | 34.583333333332995 | -120.65 | 9412110 | S | 1457 | 0 | Point Arguello | 2 | 0 | |||
46 | 9413450 | 36.6088889 | -121.8913889 | R | 1676 | 0 | MONTEREY, MONTEREY BAY | 3 | 1 | ||||
62 | 9414906 | 37.8183 | -122.528 | 9414290 | S | 1451 | 0 | Point Bonita, Bonita Cove | 2 | 0 | |||
121 | 9415218 | 38.07 | -122.25 | R | 1453 | 0 | Mare Island | 2 | 1 | ||||
130 | 9415265 | 38.1283 | -122.073 | R | 1454 | 0 | Suisun Slough entrance | 2 | 1 | ||||
142 | 9415064 | 38.02 | -121.815 | R | 1455 | 0 | Antioch | 2 | 1 | ||||
149 | 9415287 | 38.125 | -121.578 | 9415144 | S | 1677 | 0 | Georgiana Slough entrance | 3 | 0 | |||
162 | 9415176 | 38.0733 | -121.848 | 9415144 | S | 1456 | 0 | Collinsville | 2 | 0 | |||
169 | 9415009 | 37.9933 | -122.447 | 9414290 | S | 1452 | 0 | Point San Pedro | 2 | 0 | |||
179 | 9414958 | 37.90800094604492 | -122.67849731445312 | R | 1450 | 0 | Bolinas Lagoon | 2 | 1 | ||||
196 | 9418767 | 40.76690555555555 | -124.2173444444445 | R | 1678 | 0 | HUMBOLDT BAY (North Spit) | 3 | 1 | ||||
2 | TWC0401 | 28.883333333332992 | -116.3 | 9410170 | S | 1446 | 1 | Isla Guadalupe | 2 | 0 | |||
5 | TWC0405 | 32.666666666667005 | -117.23333333333005 | 9410170 | S | 1751 | 1 | Point Loma | 2 | 0 | |||
15 | 9410583 | 33.6 | -117.9 | 9410660 | S | 1447 | 1 | Balboa Pier, Newport Beach | 2 | 0 | |||
27 | 9411065 | 34.1483 | -119.203 | 9410660 | S | 1448 | 1 | Port Hueneme | 2 | 0 | |||
34 | 9410092 | 33.4317 | -118.503 | 9410660 | S | 1449 | 1 | Catalina Harbor, Santa Catalina Island | 2 | 0 | |||
42 | 9412110 | 35.176700592041016 | -120.76000213623047 | R | 1457 | 1 | PORT SAN LUIS | 2 | 1 | ||||
47 | 9413617 | 36.8017 | -121.787 | 9413450 | S | 1676 | 1 | General Fish Company Pier | 3 | 0 | |||
63 | 9414290 | 37.80630555555555 | -122.4658888888889 | R | 1451 | 1 | SAN FRANCISCO (Golden Gate) | 2 | 1 | ||||
122 | 9415165 | 38.1117 | -122.273 | 9414290 | S | 1453 | 1 | Vallejo, Mare Island Strait | 2 | 0 | |||
131 | 9415266 | 38.1267 | -122.1 | 9415144 | S | 1454 | 1 | Pierce Harbor, Goodyear Slough | 2 | 0 | |||
143 | 9415193 | 38.086700439453125 | -121.68499755859375 | R | 1455 | 1 | Threemile Slough entrance | 2 | 0 | ||||
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 | |||
170 | 9415056 | 38.015 | -122.363 | R | 1452 | 1 | Pinole Point | 2 | 1 | ||||
180 | 9415020 | 37.9941667 | -122.9736111 | R | 1450 | 1 | Point Reyes | 2 | 1 | ||||
197 | 9418723 | 40.7233 | -124.222 | R | 1678 | 1 | Fields Landing | 3 | 1 | ||||
24 | 9410777 | 33.9083 | -118.433 | 9410660 | S | 1447 | 10 | El Segundo, Santa Monica Bay | 2 | 0 | |||
56 | 9413745 | 36.9583 | -122.017 | 9413450 | S | 1676 | 10 | Santa Cruz, Monterey Bay | 3 | 0 | |||
61 | 9414275 | 37.775 | -122.513 | 9414290 | S | 1457 | 10 | Ocean Beach, outer coast | 2 | 0 | |||
72 | 9414767 | 37.7933 | -122.315 | 9414290 | S | 1451 | 10 | Alameda Naval Air Station | 2 | 0 | |||
140 | 9415112 | 38.0433 | -121.918 | R | 1454 | 10 | Mallard Island Ferry Wharf | 2 | 1 | ||||
154 | 9415053 | 38.0117 | -121.638 | 9415144 | S | 1455 | 10 | Dutch Slough | 2 | 0 | |||
189 | 9416841 | 38.91455555555556 | -123.7110833333333 | R | 1450 | 10 | ARENA COVE | 2 | 1 | ||||
25 | 9410840 | 34.0083 | -118.5 | R | 1447 | 11 | Santa Monica, Municipal Pier | 2 | 1 | ||||
73 | 9414750 | 37.77195277777778 | -122.3002611111111 | R | 1451 | 11 | Alameda | 2 | 1 | ||||
141 | 9415096 | 38.0367 | -121.88 | 9415144 | S | 1454 | 11 | Pittsburg, New York Slough | 2 | 0 | |||
155 | 9415095 | 38.0333 | -121.583 | 9415144 | S | 1455 | 11 | Irish Landing, Sand Mound Slough | 2 | 0 | |||
190 | TWC0771 | 38.95 | -123.73333333333005 | 9416841 | S | 1450 | 11 | Point Arena | 2 | 0 | |||
74 | 9414763 | 37.795 | -122.283 | 9414290 | S | 1451 | 12 | Oakland Harbor, Grove Street | 2 | 0 | |||
156 | 9414868 | 37.9383 | -121.56 | 9415144 | S | 1455 | 12 | Orwood, Old River | 2 | 0 | |||
191 | 9417426 | 39.42577777777778 | -123.8051111111111 | R | 1450 | 12 | NOYO HARBOR | 2 | 1 | ||||
75 | 9414746 | 37.7717 | -122.235 | R | 1451 | 13 | Oakland Harbor, Park Street Bridge | 2 | 1 | ||||
157 | 9414866 | 37.935 | -121.435 | 9415144 | S | 1455 | 13 | Holt, Whiskey Slough | 2 | 0 | |||
192 | TWC0777 | 39.3 | -123.8 | 9416841 | S | 1450 | 13 | Mendocino, Mendocino Bay | 2 | 0 | |||
76 | 9414724 | 37.7483 | -122.235 | 9414290 | S | 1451 | 14 | San Leandro Channel, San Leandro Bay | 2 | 0 | |||
158 | 9414836 | 37.8833 | -121.577 | 9415144 | S | 1455 | 14 | Borden Highway Bridge, Old River | 2 | 0 | |||
77 | 9414711 | 37.7317 | -122.208 | 9414290 | S | 1451 | 15 | Oakland Airport | 2 | 0 | |||
159 | 9414835 | 37.8917 | -121.488 | 9415144 | S | 1455 | 15 | Borden Highway Bridge, Middle River | 2 | 0 | |||
193 | 9417624 | 39.6333 | -123.783 | 9416841 | S | 1450 | 15 | Westport | 2 | 0 | |||
78 | 9414334 | 37.7583 | -122.383 | 9414290 | S | 1451 | 16 | Potrero Point | 2 | 0 | |||
160 | 9414367 | 37.93666666666701 | -121.33333333333005 | 9415144 | S | 1455 | 16 | Borden Highway Bridge, San Joaquin River | 2 | 0 | |||
194 | 9418024 | 40.025001525878906 | -124.05799865722656 | R | 1450 | 16 | Shelter Cove | 2 | 1 | ||||
79 | 9414358 | 37.73 | -122.357 | R | 1451 | 17 | Hunters Point | 2 | 1 | ||||
161 | 9414785 | 37.82 | -121.447 | 9415144 | S | 1455 | 17 | Grant Line Canal (drawbridge) | 2 | 0 | |||
195 | 9418637 | 40.63719940185547 | -124.2822036743164 | R | 1450 | 17 | Cockrobin Island Bridge, Eel River | 2 | 1 | ||||
80 | 9414688 | 37.695 | -122.192 | R | 1451 | 18 | San Leandro Marina | 2 | 1 | ||||
81 | TWC0547 | 37.666666666667005 | -122.2 | 9414290 | S | 1451 | 19 | Roberts Landing, 1.3 miles west of | 2 | 0 | |||
206 | 9419059 | 41.0567 | -124.147 | 9419750 | S | 1450 | 19 | Trinidad Harbor | 2 | 0 | |||
3 | TWC0403 | 31.85 | -116.63333333333004 | 9410170 | S | 1446 | 2 | Ensenada, Todos Santos Bay | 2 | 0 | |||
6 | 9410166 | 32.7033 | -117.235 | 9410170 | S | 1751 | 2 | San Diego, Quarantine Station | 2 | 0 | |||
16 | 9410599 | 33.63 | -117.958 | 9410660 | S | 1447 | 2 | Santa Ana River entrance (inside) | 2 | 0 | |||
28 | 9411189 | 34.2667 | -119.283 | 9410660 | S | 1448 | 2 | Ventura | 2 | 0 | |||
35 | 9410079 | 33.345001220703125 | -118.32499694824219 | R | 1449 | 2 | Avalon, Santa Catalina Island | 2 | 1 | ||||
43 | 9412553 | 35.6417 | -121.188 | 9412110 | S | 1457 | 2 | San Simeon | 2 | 0 | |||
48 | 9413616 | 36.8017 | -121.79 | 9413450 | S | 1676 | 2 | Moss Landing, Ocean Pier | 3 | 0 | |||
64 | 9414792 | 37.8267 | -122.417 | 9414290 | S | 1451 | 2 | Alcatraz Island | 2 | 0 | |||
123 | 9415415 | 38.1917 | -122.312 | 9414290 | S | 1453 | 2 | Edgerley Island, Napa River | 2 | 0 | |||
132 | 9415379 | 38.18 | -122.045 | 9415144 | S | 1454 | 2 | Joice Island, Suisun Slough | 2 | 0 | |||
144 | 9415229 | 38.097599029541016 | -121.56839752197266 | R | 1455 | 2 | Korths Harbor, San Joaquin River | 2 | 0 | ||||
151 | 9415478 | 38.2267 | -121.49 | 9415144 | S | 1677 | 2 | New Hope Bridge | 3 | 0 | |||
164 | 9415316 | 38.145 | -121.692 | R | 1456 | 2 | Rio Vista | 2 | 1 | ||||
171 | 9415074 | 38.0233 | -122.292 | 9414290 | S | 1452 | 2 | Hercules, Refugio Landing | 2 | 0 | |||
181 | 9415469 | 38.2283 | -122.977 | 9414290 | S | 1450 | 2 | Tomales Bay entrance | 2 | 0 | |||
198 | 9418686 | 40.6867 | -124.222 | 9418767 | S | 1678 | 2 | Hookton Slough | 3 | 0 | |||
82 | 9414391 | 37.6667 | -122.39 | 9414290 | S | 1451 | 20 | South San Francisco | 2 | 0 | |||
207 | 9419750 | 41.74561111111111 | -124.1843888888889 | R | 1450 | 20 | CRESCENT CITY | 2 | 1 | ||||
83 | 9414392 | 37.665 | -122.377 | 9414290 | S | 1451 | 21 | Oyster Point Marina | 2 | 0 | |||
208 | 9419945 | 41.94525 | -124.2009166666667 | R | 1450 | 21 | Pyramid Point, Smith River | 2 | 1 | ||||
84 | 9414402 | 37.65 | -122.377 | 9414290 | S | 1451 | 22 | Point San Bruno | 2 | 0 | |||
85 | 9414413 | 37.6367 | -122.383 | 9414290 | S | 1451 | 23 | Seaplane Harbor | 2 | 0 | |||
86 | 9414449 | 37.5917 | -122.313 | 9414290 | S | 1451 | 24 | Coyote Point Marina | 2 | 0 | |||
87 | 9414458 | 37.58 | -122.253 | R | 1451 | 25 | San Mateo Bridge (west end) | 2 | 1 | ||||
88 | 9414637 | 37.6083 | -122.182 | 9414290 | S | 1451 | 26 | San Mateo Bridge (east end) | 2 | 0 | |||
89 | 9414632 | 37.595 | -122.145 | 9414290 | S | 1451 | 27 | Alameda Creek | 2 | 0 | |||
90 | 9414621 | 37.5633 | -122.128 | 9414290 | S | 1451 | 28 | Coyote Hills Slough entrance | 2 | 0 | |||
91 | 9414483 | 37.5517 | -122.243 | 9414290 | S | 1451 | 29 | Bay Slough, west end | 2 | 0 | |||
7 | 9410170 | 32.71555555555555 | -117.1766666666667 | R | 1751 | 3 | SAN DIEGO (Broadway) | 2 | 1 | ||||
17 | TWC0427 | 33.71666666666701 | -118.05 | 9410660 | S | 1447 | 3 | Los Patos (highway bridge) | 2 | 0 | |||
29 | 9411270 | 34.3483 | -119.443 | 9410660 | S | 1448 | 3 | Rincon Island, Mussel Shoals | 2 | 0 | |||
36 | TWC0463 | 33.48333333333299 | -119.03333333333005 | 9410660 | S | 1449 | 3 | Santa Barbara Island | 2 | 0 | |||
44 | 9412802 | 35.94952777777777 | -121.4819444444445 | R | 1457 | 3 | Mansfield Cone | 2 | 1 | ||||
49 | 9413626 | 36.8133 | -121.787 | 9413450 | S | 1676 | 3 | Elkhorn Yacht Club | 3 | 0 | |||
65 | 9414305 | 37.81 | -122.413 | 9414290 | S | 1451 | 3 | San Francisco, North Point, Pier 41 | 2 | 0 | |||
124 | 9415446 | 38.21 | -122.307 | 9414290 | S | 1453 | 3 | Brazos Drawbridge, Napa 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;