noaa_stations_map (view)
69 rows where refStationId = 9414290
This data as json, CSV (advanced)
Suggested facets: parentGeoGroupId
rowid | stationId | latitude | longitude | refStationId | stationType | parentGeoGroupId | seq | geoGroupId | geoGroupName | level | geoGroupType | abbrev | good |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
57 | 9413878 | 37.1083 | -122.338 | 9414290 | S | 1457 | 6 | Ano Nuevo Island | 2 | 0 | |||
59 | 9414262 | 37.7 | -123.0 | 9414290 | S | 1457 | 8 | Southeast Farallon Island | 2 | 0 | |||
60 | TWC0509 | 37.76666666666701 | -122.63333333333004 | 9414290 | S | 1457 | 9 | San Francisco Bar | 2 | 0 | |||
61 | 9414275 | 37.775 | -122.513 | 9414290 | S | 1457 | 10 | Ocean Beach, outer coast | 2 | 0 | |||
62 | 9414906 | 37.8183 | -122.528 | 9414290 | S | 1451 | 0 | Point Bonita, Bonita Cove | 2 | 0 | |||
64 | 9414792 | 37.8267 | -122.417 | 9414290 | S | 1451 | 2 | Alcatraz Island | 2 | 0 | |||
65 | 9414305 | 37.81 | -122.413 | 9414290 | S | 1451 | 3 | San Francisco, North Point, Pier 41 | 2 | 0 | |||
67 | 9414782 | 37.81 | -122.36 | 9414290 | S | 1451 | 5 | Yerba Buena Island | 2 | 0 | |||
68 | 9414779 | 37.81 | -122.327 | 9414290 | S | 1451 | 6 | Oakland, Matson Wharf | 2 | 0 | |||
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 | |||
72 | 9414767 | 37.7933 | -122.315 | 9414290 | S | 1451 | 10 | Alameda Naval Air Station | 2 | 0 | |||
74 | 9414763 | 37.795 | -122.283 | 9414290 | S | 1451 | 12 | Oakland Harbor, Grove Street | 2 | 0 | |||
76 | 9414724 | 37.7483 | -122.235 | 9414290 | S | 1451 | 14 | San Leandro Channel, San Leandro Bay | 2 | 0 | |||
77 | 9414711 | 37.7317 | -122.208 | 9414290 | S | 1451 | 15 | Oakland Airport | 2 | 0 | |||
78 | 9414334 | 37.7583 | -122.383 | 9414290 | S | 1451 | 16 | Potrero Point | 2 | 0 | |||
81 | TWC0547 | 37.666666666667005 | -122.2 | 9414290 | S | 1451 | 19 | Roberts Landing, 1.3 miles west of | 2 | 0 | |||
82 | 9414391 | 37.6667 | -122.39 | 9414290 | S | 1451 | 20 | South San Francisco | 2 | 0 | |||
83 | 9414392 | 37.665 | -122.377 | 9414290 | S | 1451 | 21 | Oyster Point Marina | 2 | 0 | |||
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 | |||
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 | |||
92 | 9414486 | 37.545 | -122.222 | 9414290 | S | 1451 | 30 | Bay Slough, east end | 2 | 0 | |||
93 | 9414501 | 37.5333 | -122.193 | 9414290 | S | 1451 | 31 | Redwood Creek Marker 8 | 2 | 0 | |||
94 | 9414609 | 37.5517 | -122.162 | 9414290 | S | 1451 | 32 | South Bay Wreck | 2 | 0 | |||
95 | 9414505 | 37.5083 | -122.21 | 9414290 | S | 1451 | 33 | Corkscrew Slough | 2 | 0 | |||
97 | 9414507 | 37.505 | -122.192 | 9414290 | S | 1451 | 35 | West Point Slough | 2 | 0 | |||
98 | 9414511 | 37.5017 | -122.223 | 9414290 | S | 1451 | 36 | Smith Slough | 2 | 0 | |||
99 | 9414506 | 37.5133 | -122.08 | 9414290 | S | 1451 | 37 | Newark Slough | 2 | 0 | |||
101 | 9414513 | 37.495 | -122.213 | 9414290 | S | 1451 | 39 | Granite Rock, Redwood Creek | 2 | 0 | |||
102 | 9414525 | 37.4583 | -122.105 | 9414290 | S | 1451 | 40 | Palo Alto Yacht Harbor | 2 | 0 | |||
103 | 9414519 | 37.4933 | -122.042 | 9414290 | S | 1451 | 41 | Mowry Slough | 2 | 0 | |||
104 | 9414539 | 37.4667 | -122.067 | 9414290 | S | 1451 | 42 | Calaveras Point, west of | 2 | 0 | |||
105 | 9414549 | 37.435 | -122.007 | 9414290 | S | 1451 | 43 | Upper Guadalupe Slough | 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 | |||
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 | |||
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 | |||
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 | |||
116 | 9414849 | 37.91 | -122.358 | 9414290 | S | 1451 | 54 | Richmond Inner Harbor | 2 | 0 | |||
118 | 9414881 | 37.9583 | -122.425 | 9414290 | S | 1451 | 56 | Point Orient | 2 | 0 | |||
120 | 9414873 | 37.945 | -122.475 | 9414290 | S | 1451 | 58 | Point San Quentin | 2 | 0 | |||
122 | 9415165 | 38.1117 | -122.273 | 9414290 | S | 1453 | 1 | Vallejo, Mare Island Strait | 2 | 0 | |||
123 | 9415415 | 38.1917 | -122.312 | 9414290 | S | 1453 | 2 | Edgerley Island, Napa River | 2 | 0 | |||
124 | 9415446 | 38.21 | -122.307 | 9414290 | S | 1453 | 3 | Brazos Drawbridge, Napa River | 2 | 0 | |||
125 | 9415623 | 38.2983 | -122.28 | 9414290 | S | 1453 | 4 | Napa, Napa River | 2 | 0 | |||
126 | 9415142 | 38.0583 | -122.243 | 9414290 | S | 1453 | 5 | Selby | 2 | 0 | |||
169 | 9415009 | 37.9933 | -122.447 | 9414290 | S | 1452 | 0 | Point San Pedro | 2 | 0 | |||
171 | 9415074 | 38.0233 | -122.292 | 9414290 | S | 1452 | 2 | Hercules, Refugio Landing | 2 | 0 | |||
172 | 9415252 | 38.11530555555556 | -122.5056666666667 | 9414290 | S | 1452 | 3 | Petaluma River entrance | 2 | 0 | |||
173 | TWC0649 | 38.2 | -122.56666666666995 | 9414290 | S | 1452 | 4 | Lakeville, Petaluma River | 2 | 0 | |||
174 | 9415584 | 38.2283 | -122.613 | 9414290 | S | 1452 | 5 | Upper drawbridge, Petaluma River | 2 | 0 | |||
175 | 9415052 | 38.015 | -122.503 | 9414290 | S | 1452 | 6 | Gallinas, Gallinas Creek | 2 | 0 | |||
176 | 9415344 | 38.1617 | -122.55 | 9414290 | S | 1452 | 7 | Hog Island, San Antonio Creek | 2 | 0 | |||
178 | 9415447 | 38.21 | -122.427 | 9414290 | S | 1452 | 9 | Wingo, Sonoma Creek | 2 | 0 | |||
181 | 9415469 | 38.2283 | -122.977 | 9414290 | S | 1450 | 2 | Tomales Bay entrance | 2 | 0 | |||
182 | 9415396 | 38.19 | -122.917 | 9414290 | S | 1450 | 3 | Blakes Landing, Tomales Bay | 2 | 0 | |||
183 | 9415339 | 38.1617 | -122.893 | 9414290 | S | 1450 | 4 | Marshall, Tomales Bay | 2 | 0 | |||
184 | 9415320 | 38.1467 | -122.883 | 9414290 | S | 1450 | 5 | Reynolds, Tomales Bay | 2 | 0 | |||
185 | 9415228 | 38.1133 | -122.868 | 9414290 | S | 1450 | 6 | Inverness, Tomales Bay | 2 | 0 | |||
186 | 9415625 | 38.3083 | -123.055 | 9414290 | S | 1450 | 7 | Bodega Harbor entrance | 2 | 0 | |||
187 | 9416024 | 38.5133 | -123.245 | 9414290 | S | 1450 | 8 | Fort Ross | 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;