noaa_stations_map (view)
208 rows sorted by geoGroupName
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189 | 9416841 | 38.91455555555556 | -123.7110833333333 | R | 1450 | 10 | ARENA COVE | 2 | 1 | ||||
73 | 9414750 | 37.77195277777778 | -122.3002611111111 | R | 1451 | 11 | Alameda | 2 | 1 | ||||
89 | 9414632 | 37.595 | -122.145 | 9414290 | S | 1451 | 27 | Alameda Creek | 2 | 0 | |||
72 | 9414767 | 37.7933 | -122.315 | 9414290 | S | 1451 | 10 | Alameda Naval Air Station | 2 | 0 | |||
64 | 9414792 | 37.8267 | -122.417 | 9414290 | S | 1451 | 2 | Alcatraz Island | 2 | 0 | |||
111 | 9414817 | 37.86 | -122.443 | 9414290 | S | 1451 | 49 | Angel Island (west side) | 2 | 0 | |||
112 | 9414818 | 37.8633 | -122.42 | 9414290 | S | 1451 | 50 | Angel Island, East Garrison | 2 | 0 | |||
57 | 9413878 | 37.1083 | -122.338 | 9414290 | S | 1457 | 6 | Ano Nuevo Island | 2 | 0 | |||
142 | 9415064 | 38.02 | -121.815 | R | 1455 | 0 | Antioch | 2 | 1 | ||||
204 | 9418851 | 40.85 | -124.117 | 9418767 | S | 1678 | 8 | Arcata Wharf | 3 | 0 | |||
35 | 9410079 | 33.345001220703125 | -118.32499694824219 | R | 1449 | 2 | Avalon, Santa Catalina Island | 2 | 1 | ||||
15 | 9410583 | 33.6 | -117.9 | 9410660 | S | 1447 | 1 | Balboa Pier, Newport Beach | 2 | 0 | |||
92 | 9414486 | 37.545 | -122.222 | 9414290 | S | 1451 | 30 | Bay Slough, east end | 2 | 0 | |||
91 | 9414483 | 37.5517 | -122.243 | 9414290 | S | 1451 | 29 | Bay Slough, west end | 2 | 0 | |||
39 | 9410962 | 34.0083 | -120.047 | 9410660 | S | 1449 | 6 | Bechers Bay, Santa Rosa Island | 2 | 0 | |||
128 | 9415111 | 38.0433 | -122.13 | 9415144 | S | 1453 | 7 | Benicia | 2 | 0 | |||
114 | 9414816 | 37.8650016784668 | -122.30699920654297 | R | 1451 | 52 | Berkeley | 2 | 1 | ||||
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 | ||||
182 | 9415396 | 38.19 | -122.917 | 9414290 | S | 1450 | 3 | Blakes Landing, Tomales Bay | 2 | 0 | |||
186 | 9415625 | 38.3083 | -123.055 | 9414290 | S | 1450 | 7 | Bodega Harbor entrance | 2 | 0 | |||
179 | 9414958 | 37.90800094604492 | -122.67849731445312 | R | 1450 | 0 | Bolinas Lagoon | 2 | 1 | ||||
159 | 9414835 | 37.8917 | -121.488 | 9415144 | S | 1455 | 15 | Borden Highway Bridge, Middle River | 2 | 0 | |||
158 | 9414836 | 37.8833 | -121.577 | 9415144 | S | 1455 | 14 | Borden Highway Bridge, Old River | 2 | 0 | |||
160 | 9414367 | 37.93666666666701 | -121.33333333333005 | 9415144 | S | 1455 | 16 | Borden Highway Bridge, San Joaquin River | 2 | 0 | |||
136 | 9414811 | 38.1833 | -121.923 | R | 1454 | 6 | Bradmoor Island, Nurse Slough | 2 | 1 | ||||
124 | 9415446 | 38.21 | -122.307 | 9414290 | S | 1453 | 3 | Brazos Drawbridge, Napa River | 2 | 0 | |||
200 | 9418778 | 40.7783 | -124.197 | 9418767 | S | 1678 | 4 | Bucksport | 3 | 0 | |||
207 | 9419750 | 41.74561111111111 | -124.1843888888889 | R | 1450 | 20 | CRESCENT CITY | 2 | 1 | ||||
20 | 9410650 | 33.7067 | -118.273 | 9410660 | S | 1447 | 6 | Cabrillo Beach | 2 | 0 | |||
104 | 9414539 | 37.4667 | -122.067 | 9414290 | S | 1451 | 42 | Calaveras Point, west of | 2 | 0 | |||
45 | 9413375 | 36.52 | -121.94 | 9413450 | S | 1457 | 4 | Carmel Cove, Carmel Bay | 2 | 0 | |||
34 | 9410092 | 33.4317 | -118.503 | 9410660 | S | 1449 | 1 | Catalina Harbor, Santa Catalina Island | 2 | 0 | |||
117 | 9414863 | 37.92829895019531 | -122.4000015258789 | R | 1451 | 55 | Chevron Oil Company Pier, Richmond | 2 | 1 | ||||
167 | 9415846 | 38.4167 | -121.523 | 9415144 | S | 1456 | 5 | Clarksburg | 2 | 0 | |||
195 | 9418637 | 40.63719940185547 | -124.2822036743164 | R | 1450 | 17 | Cockrobin Island Bridge, Eel River | 2 | 1 | ||||
162 | 9415176 | 38.0733 | -121.848 | 9415144 | S | 1456 | 0 | Collinsville | 2 | 0 | |||
95 | 9414505 | 37.5083 | -122.21 | 9414290 | S | 1451 | 33 | Corkscrew Slough | 2 | 0 | |||
119 | 9414874 | 37.94329833984375 | -122.51300048828125 | R | 1451 | 57 | Corte Madera Creek | 2 | 0 | ||||
106 | 9414575 | 37.465 | -122.023 | R | 1451 | 44 | Coyote Creek, Alviso Slough | 2 | 1 | ||||
108 | 9414561 | 37.4467 | -121.963 | 9414290 | S | 1451 | 46 | Coyote Creek, Tributary no.1 | 2 | 0 | |||
90 | 9414621 | 37.5633 | -122.128 | 9414290 | S | 1451 | 28 | Coyote Hills Slough entrance | 2 | 0 | |||
86 | 9414449 | 37.5917 | -122.313 | 9414290 | S | 1451 | 24 | Coyote Point Marina | 2 | 0 | |||
127 | 9415143 | 38.0583 | -122.223 | R | 1453 | 6 | Crockett | 2 | 1 | ||||
40 | 9410988 | 34.0567 | -120.355 | 9410660 | S | 1449 | 7 | Cuyler Harbor, San Miguel Island | 2 | 0 | |||
100 | 9414509 | 37.5067 | -122.115 | R | 1451 | 38 | Dumbarton Highway Bridge | 2 | 1 | ||||
154 | 9415053 | 38.0117 | -121.638 | 9415144 | S | 1455 | 10 | Dutch Slough | 2 | 0 | |||
123 | 9415415 | 38.1917 | -122.312 | 9414290 | S | 1453 | 2 | Edgerley Island, Napa River | 2 | 0 | |||
24 | 9410777 | 33.9083 | -118.433 | 9410660 | S | 1447 | 10 | El Segundo, Santa Monica Bay | 2 | 0 | |||
199 | 9418757 | 40.7567 | -124.193 | 9418767 | S | 1678 | 3 | Elk River Railroad Bridge | 3 | 0 | |||
55 | 9413663 | 36.85667 | -121.755 | R | 1676 | 9 | Elkhorn Slough railroad bridge | 3 | 1 | ||||
50 | 9413623 | 36.81 | -121.785 | 9413450 | S | 1676 | 4 | Elkhorn Slough, Highway 1 Bridge | 3 | 0 | |||
49 | 9413626 | 36.8133 | -121.787 | 9413450 | S | 1676 | 3 | Elkhorn Yacht Club | 3 | 0 | |||
52 | 9413631 | 36.81829833984375 | -121.74700164794922 | R | 1676 | 6 | Elkhorn, Elkhorn Slough | 3 | 1 | ||||
3 | TWC0403 | 31.85 | -116.63333333333004 | 9410170 | S | 1446 | 2 | Ensenada, Todos Santos Bay | 2 | 0 | |||
201 | 9418801 | 40.8067 | -124.167 | 9418767 | S | 1678 | 5 | Eureka | 3 | 0 | |||
202 | 9418802 | 40.8067 | -124.142 | 9418767 | S | 1678 | 6 | Eureka Slough Bridge | 3 | 0 | |||
153 | 9415145 | 38.055 | -121.657 | 9415144 | S | 1455 | 9 | False River | 2 | 0 | |||
197 | 9418723 | 40.7233 | -124.222 | R | 1678 | 1 | Fields Landing | 3 | 1 | ||||
187 | 9416024 | 38.5133 | -123.245 | 9414290 | S | 1450 | 8 | Fort Ross | 2 | 0 | |||
175 | 9415052 | 38.015 | -122.503 | 9414290 | S | 1452 | 6 | Gallinas, Gallinas Creek | 2 | 0 | |||
31 | 9411399 | 34.46938888888889 | -120.2283055555556 | R | 1448 | 5 | Gaviota State Park, Pacific Ocean | 2 | 1 | ||||
47 | 9413617 | 36.8017 | -121.787 | 9413450 | S | 1676 | 1 | General Fish Company Pier | 3 | 0 | |||
149 | 9415287 | 38.125 | -121.578 | 9415144 | S | 1677 | 0 | Georgiana Slough entrance | 3 | 0 | |||
107 | 9414551 | 37.4233 | -121.975 | 9414290 | S | 1451 | 45 | Gold Street Bridge, Alviso Slough | 2 | 0 | |||
101 | 9414513 | 37.495 | -122.213 | 9414290 | S | 1451 | 39 | Granite Rock, Redwood Creek | 2 | 0 | |||
161 | 9414785 | 37.82 | -121.447 | 9415144 | S | 1455 | 17 | Grant Line Canal (drawbridge) | 2 | 0 | |||
188 | 9416409 | 38.70433333333333 | -123.4493888888889 | R | 1450 | 9 | Green Cove | 2 | 1 | ||||
196 | 9418767 | 40.76690555555555 | -124.2173444444445 | R | 1678 | 0 | HUMBOLDT BAY (North Spit) | 3 | 1 | ||||
171 | 9415074 | 38.0233 | -122.292 | 9414290 | S | 1452 | 2 | Hercules, Refugio Landing | 2 | 0 | |||
176 | 9415344 | 38.1617 | -122.55 | 9414290 | S | 1452 | 7 | Hog Island, San Antonio Creek | 2 | 0 | |||
157 | 9414866 | 37.935 | -121.435 | 9415144 | S | 1455 | 13 | Holt, Whiskey Slough | 2 | 0 | |||
198 | 9418686 | 40.6867 | -124.222 | 9418767 | S | 1678 | 2 | Hookton Slough | 3 | 0 | |||
79 | 9414358 | 37.73 | -122.357 | R | 1451 | 17 | Hunters Point | 2 | 1 | ||||
4 | 9410120 | 32.5783 | -117.135 | 9410170 | S | 1751 | 0 | Imperial Beach | 2 | 0 | |||
185 | 9415228 | 38.1133 | -122.868 | 9414290 | S | 1450 | 6 | Inverness, Tomales Bay | 2 | 0 | |||
155 | 9415095 | 38.0333 | -121.583 | 9415144 | S | 1455 | 11 | Irish Landing, Sand Mound Slough | 2 | 0 | |||
2 | TWC0401 | 28.883333333332992 | -116.3 | 9410170 | S | 1446 | 1 | Isla Guadalupe | 2 | 0 | |||
132 | 9415379 | 38.18 | -122.045 | 9415144 | S | 1454 | 2 | Joice Island, Suisun Slough | 2 | 0 | |||
23 | 9410738 | 33.8467 | -118.398 | 9410660 | S | 1447 | 9 | King Harbor, Santa Monica Bay | 2 | 0 | |||
54 | 9413651 | 36.84130096435547 | -121.74530029296875 | R | 1676 | 8 | Kirby Park, Elkhorn Slough | 3 | 1 | ||||
144 | 9415229 | 38.097599029541016 | -121.56839752197266 | R | 1455 | 2 | Korths Harbor, San Joaquin River | 2 | 0 | ||||
21 | 9410660 | 33.72 | -118.272 | R | 1447 | 7 | LOS ANGELES (Outer Harbor) | 2 | 1 | ||||
12 | 9410230 | 32.86688888888889 | -117.2571388888889 | R | 1751 | 8 | La Jolla (Scripps Institution Wharf) | 2 | 1 | ||||
173 | TWC0649 | 38.2 | -122.56666666666995 | 9414290 | S | 1452 | 4 | Lakeville, Petaluma River | 2 | 0 | |||
19 | 9410686 | 33.7717 | -118.21 | 9410660 | S | 1447 | 5 | Long Beach, Inner Harbor | 2 | 0 | |||
18 | 9410680 | 33.7517 | -118.227 | R | 1447 | 4 | Long Beach, Terminal Island | 2 | 1 | ||||
22 | TWC0439 | 33.75 | -118.26666666666995 | 9410660 | S | 1447 | 8 | Los Angeles Harbor, Mormon Island | 2 | 0 | |||
17 | TWC0427 | 33.71666666666701 | -118.05 | 9410660 | S | 1447 | 3 | Los Patos (highway bridge) | 2 | 0 | |||
46 | 9413450 | 36.6088889 | -121.8913889 | R | 1676 | 0 | MONTEREY, MONTEREY BAY | 3 | 1 | ||||
205 | 9418865 | 40.865 | -124.148 | 9418767 | S | 1678 | 9 | Mad River Slough, Arcata Bay | 3 | 0 | |||
140 | 9415112 | 38.0433 | -121.918 | R | 1454 | 10 | Mallard Island Ferry Wharf | 2 | 1 | ||||
44 | 9412802 | 35.94952777777777 | -121.4819444444445 | R | 1457 | 3 | Mansfield Cone | 2 | 1 | ||||
121 | 9415218 | 38.07 | -122.25 | R | 1453 | 0 | Mare Island | 2 | 1 | ||||
183 | 9415339 | 38.1617 | -122.893 | 9414290 | S | 1450 | 4 | Marshall, Tomales Bay | 2 | 0 | |||
129 | 9415102 | 38.03463888888889 | -122.1251944444445 | R | 1453 | 8 | Martinez-Amorco Pier | 2 | 1 | ||||
137 | 9415307 | 38.1367 | -121.907 | 9415144 | S | 1454 | 7 | Meins Landing, Montezuma Slough | 2 | 0 | |||
192 | TWC0777 | 39.3 | -123.8 | 9416841 | S | 1450 | 13 | Mendocino, Mendocino Bay | 2 | 0 | |||
11 | 9410196 | 32.793701171875 | -117.22380065917969 | R | 1751 | 7 | Mission Bay, Campland | 2 | 1 | ||||
138 | 9415205 | 38.0767 | -121.885 | 9415144 | S | 1454 | 8 | Montezuma Slough | 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;