noaa_stations_map (view)
208 rows sorted by longitude
This data as json, CSV (advanced)
rowid | stationId | latitude | longitude ▼ | refStationId | stationType | parentGeoGroupId | seq | geoGroupId | geoGroupName | level | geoGroupType | abbrev | good |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
89 | 9414632 | 37.595 | -122.145 | 9414290 | S | 1451 | 27 | Alameda Creek | 2 | 0 | |||
128 | 9415111 | 38.0433 | -122.13 | 9415144 | S | 1453 | 7 | Benicia | 2 | 0 | |||
90 | 9414621 | 37.5633 | -122.128 | 9414290 | S | 1451 | 28 | Coyote Hills Slough entrance | 2 | 0 | |||
129 | 9415102 | 38.03463888888889 | -122.1251944444445 | R | 1453 | 8 | Martinez-Amorco Pier | 2 | 1 | ||||
100 | 9414509 | 37.5067 | -122.115 | R | 1451 | 38 | Dumbarton Highway Bridge | 2 | 1 | ||||
102 | 9414525 | 37.4583 | -122.105 | 9414290 | S | 1451 | 40 | Palo Alto Yacht Harbor | 2 | 0 | |||
131 | 9415266 | 38.1267 | -122.1 | 9415144 | S | 1454 | 1 | Pierce Harbor, Goodyear Slough | 2 | 0 | |||
99 | 9414506 | 37.5133 | -122.08 | 9414290 | S | 1451 | 37 | Newark Slough | 2 | 0 | |||
130 | 9415265 | 38.1283 | -122.073 | R | 1454 | 0 | Suisun Slough entrance | 2 | 1 | ||||
104 | 9414539 | 37.4667 | -122.067 | 9414290 | S | 1451 | 42 | Calaveras Point, west of | 2 | 0 | |||
132 | 9415379 | 38.18 | -122.045 | 9415144 | S | 1454 | 2 | Joice Island, Suisun Slough | 2 | 0 | |||
103 | 9414519 | 37.4933 | -122.042 | 9414290 | S | 1451 | 41 | Mowry Slough | 2 | 0 | |||
134 | 9415144 | 38.056 | -122.0395 | R | 1454 | 4 | PORT CHICAGO, SUISUN BAY | 2 | 1 | ||||
139 | 9415227 | 38.1 | -122.033 | 9415144 | S | 1454 | 9 | Point Buckler | 2 | 0 | |||
133 | 9415498 | 38.2367 | -122.03 | 9415144 | S | 1454 | 3 | Suisun City, Suisun Slough | 2 | 0 | |||
106 | 9414575 | 37.465 | -122.023 | R | 1451 | 44 | Coyote Creek, Alviso Slough | 2 | 1 | ||||
56 | 9413745 | 36.9583 | -122.017 | 9413450 | S | 1676 | 10 | Santa Cruz, Monterey Bay | 3 | 0 | |||
105 | 9414549 | 37.435 | -122.007 | 9414290 | S | 1451 | 43 | Upper Guadalupe Slough | 2 | 0 | |||
135 | 9415402 | 38.1867 | -121.98 | 9415144 | S | 1454 | 5 | Montezuma Slough Bridge | 2 | 0 | |||
107 | 9414551 | 37.4233 | -121.975 | 9414290 | S | 1451 | 45 | Gold Street Bridge, Alviso Slough | 2 | 0 | |||
108 | 9414561 | 37.4467 | -121.963 | 9414290 | S | 1451 | 46 | Coyote Creek, Tributary no.1 | 2 | 0 | |||
45 | 9413375 | 36.52 | -121.94 | 9413450 | S | 1457 | 4 | Carmel Cove, Carmel Bay | 2 | 0 | |||
136 | 9414811 | 38.1833 | -121.923 | R | 1454 | 6 | Bradmoor Island, Nurse Slough | 2 | 1 | ||||
140 | 9415112 | 38.0433 | -121.918 | R | 1454 | 10 | Mallard Island Ferry Wharf | 2 | 1 | ||||
137 | 9415307 | 38.1367 | -121.907 | 9415144 | S | 1454 | 7 | Meins Landing, Montezuma Slough | 2 | 0 | |||
46 | 9413450 | 36.6088889 | -121.8913889 | R | 1676 | 0 | MONTEREY, MONTEREY BAY | 3 | 1 | ||||
138 | 9415205 | 38.0767 | -121.885 | 9415144 | S | 1454 | 8 | Montezuma Slough | 2 | 0 | |||
141 | 9415096 | 38.0367 | -121.88 | 9415144 | S | 1454 | 11 | Pittsburg, New York Slough | 2 | 0 | |||
162 | 9415176 | 38.0733 | -121.848 | 9415144 | S | 1456 | 0 | Collinsville | 2 | 0 | |||
142 | 9415064 | 38.02 | -121.815 | R | 1455 | 0 | Antioch | 2 | 1 | ||||
48 | 9413616 | 36.8017 | -121.79 | 9413450 | S | 1676 | 2 | Moss Landing, Ocean Pier | 3 | 0 | |||
47 | 9413617 | 36.8017 | -121.787 | 9413450 | S | 1676 | 1 | General Fish Company Pier | 3 | 0 | |||
49 | 9413626 | 36.8133 | -121.787 | 9413450 | S | 1676 | 3 | Elkhorn Yacht Club | 3 | 0 | |||
50 | 9413623 | 36.81 | -121.785 | 9413450 | S | 1676 | 4 | Elkhorn Slough, Highway 1 Bridge | 3 | 0 | |||
51 | 9413624 | 36.8133 | -121.758 | 9413450 | S | 1676 | 5 | Pacific Mariculture Dock | 3 | 0 | |||
55 | 9413663 | 36.85667 | -121.755 | R | 1676 | 9 | Elkhorn Slough railroad bridge | 3 | 1 | ||||
52 | 9413631 | 36.81829833984375 | -121.74700164794922 | R | 1676 | 6 | Elkhorn, Elkhorn Slough | 3 | 1 | ||||
54 | 9413651 | 36.84130096435547 | -121.74530029296875 | R | 1676 | 8 | Kirby Park, Elkhorn Slough | 3 | 1 | ||||
53 | 9413643 | 36.83330154418945 | -121.74500274658203 | R | 1676 | 7 | Tidal Creek, Elkhorn Slough | 3 | 1 | ||||
163 | 9415236 | 38.1067 | -121.7 | 9415144 | S | 1456 | 1 | Threemile Slough | 2 | 0 | |||
164 | 9415316 | 38.145 | -121.692 | R | 1456 | 2 | Rio Vista | 2 | 1 | ||||
143 | 9415193 | 38.086700439453125 | -121.68499755859375 | R | 1455 | 1 | Threemile Slough entrance | 2 | 0 | ||||
153 | 9415145 | 38.055 | -121.657 | 9415144 | S | 1455 | 9 | False River | 2 | 0 | |||
165 | 9415414 | 38.1833 | -121.655 | 9415144 | S | 1456 | 3 | Steamboat Slough, Snug Harbor Marina | 2 | 0 | |||
154 | 9415053 | 38.0117 | -121.638 | 9415144 | S | 1455 | 10 | Dutch Slough | 2 | 0 | |||
155 | 9415095 | 38.0333 | -121.583 | 9415144 | S | 1455 | 11 | Irish Landing, Sand Mound Slough | 2 | 0 | |||
149 | 9415287 | 38.125 | -121.578 | 9415144 | S | 1677 | 0 | Georgiana Slough entrance | 3 | 0 | |||
158 | 9414836 | 37.8833 | -121.577 | 9415144 | S | 1455 | 14 | Borden Highway Bridge, Old River | 2 | 0 | |||
144 | 9415229 | 38.097599029541016 | -121.56839752197266 | R | 1455 | 2 | Korths Harbor, San Joaquin River | 2 | 0 | ||||
156 | 9414868 | 37.9383 | -121.56 | 9415144 | S | 1455 | 12 | Orwood, Old River | 2 | 0 | |||
145 | 9415149 | 38.0617 | -121.555 | 9415144 | S | 1455 | 3 | Prisoners Point | 2 | 0 | |||
167 | 9415846 | 38.4167 | -121.523 | 9415144 | S | 1456 | 5 | Clarksburg | 2 | 0 | |||
168 | 9416174 | 38.58 | -121.507 | 9415144 | S | 1456 | 6 | Sacramento | 2 | 0 | |||
150 | 9415257 | 38.11 | -121.498 | 9415144 | S | 1677 | 1 | Terminous, South Fork | 3 | 0 | |||
146 | 9415105 | 38.04999923706055 | -121.49700164794922 | R | 1455 | 4 | Wards Island, Little Connection Slough | 2 | 0 | ||||
166 | 9415565 | 38.2767 | -121.495 | 9415144 | S | 1456 | 4 | Snodgrass Slough | 2 | 0 | |||
151 | 9415478 | 38.2267 | -121.49 | 9415144 | S | 1677 | 2 | New Hope Bridge | 3 | 0 | |||
159 | 9414835 | 37.8917 | -121.488 | 9415144 | S | 1455 | 15 | Borden Highway Bridge, Middle River | 2 | 0 | |||
44 | 9412802 | 35.94952777777777 | -121.4819444444445 | R | 1457 | 3 | Mansfield Cone | 2 | 1 | ||||
161 | 9414785 | 37.82 | -121.447 | 9415144 | S | 1455 | 17 | Grant Line Canal (drawbridge) | 2 | 0 | |||
157 | 9414866 | 37.935 | -121.435 | 9415144 | S | 1455 | 13 | Holt, Whiskey Slough | 2 | 0 | |||
152 | 9415117 | 38.045 | -121.42 | 9415144 | S | 1455 | 8 | Bishop Cut, Disappointment Slough | 2 | 0 | |||
147 | 9415021 | 37.994998931884766 | -121.41999816894531 | R | 1455 | 5 | Blackslough Landing | 2 | 0 | ||||
160 | 9414367 | 37.93666666666701 | -121.33333333333005 | 9415144 | S | 1455 | 16 | Borden Highway Bridge, San Joaquin River | 2 | 0 | |||
148 | 9414883 | 37.9583 | -121.29 | 9415144 | S | 1455 | 6 | Stockton | 2 | 0 | |||
43 | 9412553 | 35.6417 | -121.188 | 9412110 | S | 1457 | 2 | San Simeon | 2 | 0 | |||
42 | 9412110 | 35.176700592041016 | -120.76000213623047 | R | 1457 | 1 | PORT SAN LUIS | 2 | 1 | ||||
32 | 9411406 | 34.46916666666667 | -120.6819444444444 | R | 1448 | 6 | Oil Platform Harvest | 2 | 1 | ||||
41 | TWC0473 | 34.583333333332995 | -120.65 | 9412110 | S | 1457 | 0 | Point Arguello | 2 | 0 | |||
40 | 9410988 | 34.0567 | -120.355 | 9410660 | S | 1449 | 7 | Cuyler Harbor, San Miguel Island | 2 | 0 | |||
31 | 9411399 | 34.46938888888889 | -120.2283055555556 | R | 1448 | 5 | Gaviota State Park, Pacific Ocean | 2 | 1 | ||||
39 | 9410962 | 34.0083 | -120.047 | 9410660 | S | 1449 | 6 | Bechers Bay, Santa Rosa Island | 2 | 0 | |||
30 | 9411340 | 34.40458888888889 | -119.6924944444445 | R | 1448 | 4 | Santa Barbara | 2 | 1 | ||||
38 | 9410971 | 34.02 | -119.683 | 9410660 | S | 1449 | 5 | Prisoners Harbor, Santa Cruz Island | 2 | 0 | |||
37 | 9410068 | 33.2667 | -119.497 | 9410660 | S | 1449 | 4 | San Nicolas Island | 2 | 0 | |||
29 | 9411270 | 34.3483 | -119.443 | 9410660 | S | 1448 | 3 | Rincon Island, Mussel Shoals | 2 | 0 | |||
28 | 9411189 | 34.2667 | -119.283 | 9410660 | S | 1448 | 2 | Ventura | 2 | 0 | |||
27 | 9411065 | 34.1483 | -119.203 | 9410660 | S | 1448 | 1 | Port Hueneme | 2 | 0 | |||
26 | TWC0445 | 34.1 | -119.1 | 9410660 | S | 1448 | 0 | Mugu Lagoon (ocean pier) | 2 | 0 | |||
36 | TWC0463 | 33.48333333333299 | -119.03333333333005 | 9410660 | S | 1449 | 3 | Santa Barbara Island | 2 | 0 | |||
33 | 9410032 | 33.005001068115234 | -118.55699920654297 | R | 1449 | 0 | Wilson Cove, San Clemente Island | 2 | 1 | ||||
34 | 9410092 | 33.4317 | -118.503 | 9410660 | S | 1449 | 1 | Catalina Harbor, Santa Catalina Island | 2 | 0 | |||
25 | 9410840 | 34.0083 | -118.5 | R | 1447 | 11 | Santa Monica, Municipal Pier | 2 | 1 | ||||
24 | 9410777 | 33.9083 | -118.433 | 9410660 | S | 1447 | 10 | El Segundo, Santa Monica Bay | 2 | 0 | |||
23 | 9410738 | 33.8467 | -118.398 | 9410660 | S | 1447 | 9 | King Harbor, Santa Monica Bay | 2 | 0 | |||
35 | 9410079 | 33.345001220703125 | -118.32499694824219 | R | 1449 | 2 | Avalon, Santa Catalina Island | 2 | 1 | ||||
20 | 9410650 | 33.7067 | -118.273 | 9410660 | S | 1447 | 6 | Cabrillo Beach | 2 | 0 | |||
21 | 9410660 | 33.72 | -118.272 | R | 1447 | 7 | LOS ANGELES (Outer Harbor) | 2 | 1 | ||||
22 | TWC0439 | 33.75 | -118.26666666666995 | 9410660 | S | 1447 | 8 | Los Angeles Harbor, Mormon Island | 2 | 0 | |||
18 | 9410680 | 33.7517 | -118.227 | R | 1447 | 4 | Long Beach, Terminal Island | 2 | 1 | ||||
19 | 9410686 | 33.7717 | -118.21 | 9410660 | S | 1447 | 5 | Long Beach, Inner Harbor | 2 | 0 | |||
17 | TWC0427 | 33.71666666666701 | -118.05 | 9410660 | S | 1447 | 3 | Los Patos (highway bridge) | 2 | 0 | |||
16 | 9410599 | 33.63 | -117.958 | 9410660 | S | 1447 | 2 | Santa Ana River entrance (inside) | 2 | 0 | |||
15 | 9410583 | 33.6 | -117.9 | 9410660 | S | 1447 | 1 | Balboa Pier, Newport Beach | 2 | 0 | |||
14 | 9410580 | 33.6033 | -117.883 | R | 1447 | 0 | Newport Bay Entrance, Corona del Mar | 2 | 1 | ||||
13 | TWC0419 | 33.416666666667005 | -117.61666666666996 | 9410170 | S | 1751 | 9 | San Clemente | 2 | 0 | |||
12 | 9410230 | 32.86688888888889 | -117.2571388888889 | R | 1751 | 8 | La Jolla (Scripps Institution Wharf) | 2 | 1 | ||||
6 | 9410166 | 32.7033 | -117.235 | 9410170 | S | 1751 | 2 | San Diego, Quarantine Station | 2 | 0 | |||
5 | TWC0405 | 32.666666666667005 | -117.23333333333005 | 9410170 | S | 1751 | 1 | Point Loma | 2 | 0 | |||
10 | TWC0413 | 32.76666666666701 | -117.23333333333005 | 9410170 | S | 1751 | 6 | Quivira Basin, Mission Bay | 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;